Calc Guide

• As a percentage. To enter an interest rate as a percentage, type in
the interest rate followed by the % key. For example, to compute a
loan with a 3.25% interest rate, enter 3.25% into the function.
If you enter it as 3.25, the function will treat it as a 325% interest rate.
Accounting systems vary in the number of days in a month or a year
used in calculations. The following table gives the integers used for the
basis parameter used in some of the financial analysis functions.
Table 35: Basis calculation types
Basis Calculation
0 or
missing
US method (NASD), 12 months of 30 days each.
1 Exact number of days in months, exact number of days in year.
2 Exact number of days in month, year has 360 days.
3 Exact number of days in month, year has 365 days.
4 European method, 12 months of 30 days each.
Table 36: Financial analysis functions
Syntax Description
ACCRINT(issue;
first_interest; settlement;
rate; par; frequency; basis)
Calculates the accrued interest of a security in
the case of periodic payments. Issue is the
issue date of the security. First_interest is the
first interest date of the security. Settlement
is the maturity date. Rate is the annual
nominal rate of interest (coupon interest rate).
Par is the par value of the security. Frequency
is the number of interest payments per year
(1, 2 or 4). Basis indicates how the year is to
be calculated.
ACCRINTM(issue;
settlement; rate; par;
basis)
Calculates the accrued interest of a security in
the case of one-off payment at the settlement
date. Issue is the issue date of the security.
Settlement is the maturity date. Rate is the
annual nominal rate of interest (coupon
interest rate). Par is the par value of the
security. Basis indicates how the year is to be
calculated.
AMORDEGRC(cost;
date_purchased;
first_period; salvage;
Calculates the amount of depreciation for a
settlement period as degressive amortization.
Unlike AMORLINC, a depreciation coefficient
436 OpenOffice.org 3.x Calc Guide