Calc Guide

Syntax Description
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.
446 OpenOffice.org 3.x Calc Guide