Calc Guide

Syntax Description
PRICEMAT(settlement;
maturity; issue; rate; yield;
basis)
Calculates the price per 100 currency units of par
value of a security, that pays interest on the maturity
date. Settlement is the date of purchase of the
security. Maturity is the date on which the security
matures (expires). Issue is the date of issue of the
security. Rate is the interest rate of the security on
the issue date. Yield is the annual yield of the
security. Basis indicates how the year is to be
calculated.
PV(rate; NPER; PMT; FV;
type)
Returns the present value of an investment resulting
from a series of regular payments. Rate defines the
interest rate per period. NPER is the total number of
payment periods. PMT is the regular payment made
per period. FV (optional) defines the future value
remaining after the final installment has been made.
Type (optional) defines whether the payment is due
at the beginning (1) or the end (0) of a period.
RATE(NPER; PMT; PV; FV;
type; guess)
Returns the constant interest rate per period of an
annuity. NPER is the total number of periods, during
which payments are made (payment period). PMT is
the constant payment (annuity) paid during each
period. PV is the cash value in the sequence of
payments. FV (optional) is the future value, which is
reached at the end of the periodic payments. Type
(optional) defines whether the payment is due at the
beginning (1) or the end (0) of a period. Guess
(optional) determines the estimated value of the
interest with iterative calculation.
RECEIVED(settlement;
maturity; investment;
discount; basis)
Calculates the amount received that is paid for a
fixed-interest security at a given point in time.
Settlement is the date of purchase of the security.
Maturity is the date on which the security matures.
Investment is the purchase sum. Discount is the
percentage discount on acquisition of the security.
Basis indicates how the year is to be calculated.
RRI(P; PV; FV) Calculates the interest rate resulting from the profit
(return) of an investment. P is the number of periods
needed for calculating the interest rate. PV is the
present value (must be >0). FV is determines what
is desired as the cash value of the deposit.
SLN(cost; salvage; life) Returns the straight-line depreciation of an asset for
one period. The amount of the depreciation is
constant during the depreciation period. Cost is the
initial cost of an asset. Salvage is the value of an
asset at the end of the depreciation. Life is the
depreciation period determining the number of
periods in the depreciation of the asset.
390 OpenOffice.org 3.3 Calc Guide