Calc Guide

Syntax Description
method. Note that the book value will never
reach zero under this calculation type. Cost
fixes the initial cost of an asset. Salvage fixes
the value of an asset at the end of its life. Life
is the number of periods defining how long the
asset is to be used. Period defines the length
of the period. The period must be entered in
the same time unit as the life. Factor
(optional) is the factor by which depreciation
decreases.
DISC(settlement;
maturity; price;
redemption; basis)
Calculates the allowance (discount) of a
security as a percentage. Settlement is the
date of purchase of the security. Maturity is
the date on which the security matures
(expires). Price is the price of the security per
100 currency units of par value. Redemption
is the redemption value of the security per 100
currency units of par value. Basis indicates
how the year is to be calculated.
DOLLARDE(fractional
_dollar; fraction)
Converts a quotation that has been given as a
decimal fraction into a decimal number.
Fractional_dollar is a number given as a
decimal fraction. (In this number, the decimal
value is the numerator of the fraction.)
Fraction is a whole number that is used as
the denominator of the decimal fraction.
DOLLARFR(decimal
_dollar; fraction)
Converts a quotation that has been given as a
decimal number into a mixed decimal fraction.
The decimal of the result is the numerator of
the fraction that would have Fraction as the
denominator. Decimal_dollar is a decimal
number. Fraction is a whole number that is
used as the denominator of the decimal
fraction.
DURATION(rate; PV; FV) Calculates the number of periods required by
an investment to attain the desired value.
Rate (a constant) is the interest rate to be
calculated for the entire duration. Entering
the interest rate divided by the periods per
year, can calculate the interest after each
period. PV is the present value. FV is the
desired future value of the investment.
DURATION_ADD Calculates the duration of a fixed interest
440 OpenOffice.org 3.x Calc Guide