Calc Guide

Syntax Description
DURATION_ADD (settlement;
maturity; coupon; yield;
frequency; basis)
Calculates the duration of a fixed interest security in
years. Settlement is the date of purchase of the
security. Maturity is the date on which the security
matures (expires). Coupon is the annual coupon
interest rate (nominal rate of interest). Yield is the
annual yield 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.
EFFECT_ADD(nominal _rate;
Npery)
Calculates the effective annual rate of interest on the
basis of the nominal interest rate and the number of
interest payments per annum. Nominal interest
refers to the amount of interest due at the end of a
calculation period. Nominal_rate is the annual
nominal rate of interest. Npery is the number of
interest payments per year.
EFFECTIVE(NOM; P) Calculates the effective annual rate of interest on the
basis of the nominal interest rate and the number of
interest payments per annum. Nominal interest
refers to the amount of interest due at the end of a
calculation period. NOM is the nominal interest. P is
the number of interest payment periods per year.
FV(rate; NPER; PMT; PV;
type)
Returns the future value of an investment based on
periodic, constant payments and a constant interest
rate. Rate is the periodic interest rate. NPER is the
total number of periods. PMT is the annuity paid
regularly per period. PV (optional) is the present
cash value of an investment. Type (optional) defines
whether the payment is due at the beginning (1) or
the end (0) of a period.
FVSCHEDULE(principal;
schedule)
Calculates the accumulated value of the starting
capital for a series of periodically varying interest
rates. Principal is the starting capital. Schedule is
a series of interest rates. Schedule has to be
entered with cell references.
INTRATE(settlement;
maturity; investment;
redemption; basis)
Calculates the annual interest rate that results when
a security (or other item) is purchased at an
investment value and sold at a redemption value
with no interest being paid. Settlement is the date
of purchase of the security. Maturity is the date on
which the security is sold. Investment is the
purchase price. Redemption is the selling price.
Basis indicates how the year is to be calculated.
386 OpenOffice.org 3.3 Calc Guide