Calc Guide

Syntax Description
(settlement; maturity;
coupon; yield; frequency;
basis)
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.
Appendix B Description of Functions 441