Calc Guide

Syntax Description
number of interest payments per year (1, 2 or
4). Basis indicates how the year is to be
calculated.
COUPNCD(settlement;
maturity; frequency; basis)
Returns the date of the first interest date after
the settlement date, and formats the result as
a date. Settlement is the date of purchase of
the security. Maturity is the date on which the
security matures (expires). Frequency is the
number of interest payments per year (1, 2 or
4). Basis indicates how the year is to be
calculated.
COUPNUM(settlement;
maturity; frequency; basis)
Returns the number of coupons (interest
payments) between the settlement date and
the maturity date. Settlement is the date of
purchase of the security. Maturity is the date
on which the security matures (expires).
Frequency is the number of interest
payments per year (1, 2 or 4). Basis indicates
how the year is to be calculated.
COUPPCD(settlement;
maturity; frequency; basis)
Returns the date of the interest date prior to
the settlement date, and formats the result as
a date. Settlement is the date of purchase of
the security. Maturity is the date on which the
security matures (expires). Frequency is the
number of interest payments per year (1, 2 or
4). Basis indicates how the year is to be
calculated.
CUMIPMT(rate; NPER;
PV; S; E; type)
Calculates the cumulative interest payments
(the total interest) for an investment based on
a constant interest rate. Rate is the periodic
interest rate. NPER is the payment period
with the total number of periods. NPER can
also be a non-integer value. The rate and
NPER must refer to the same unit, and thus
both must be calculated annually or monthly.
PV is the current value in the sequence of
payments. S is the first period. E is the last
period. Type is the due date of the payment at
the beginning (1) or end (0) of each period.
CUMIPMT_ADD(rate;
NPER; PV; start_period;
end_period; type)
Calculates the accumulated interest for a
period. Rate is the interest rate for each
period. NPER is the total number of payment
periods. The rate and NPER must refer to the
438 OpenOffice.org 3.x Calc Guide