Calc Guide

Syntax Description
type)
with constant interest rates. Rate is the
periodic interest rate. NPER is the number of
periods in which annuity is paid. PV is the
present value (cash value) in a sequence of
payments. FV (optional) is the desired value
(future value) to be 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.
PPMT(rate; period; NPER;
PV; FV; type)
Returns for a given period the payment on the
principal for an investment that is based on
periodic and constant payments and a
constant interest rate. Rate is the periodic
interest rate. Period is the amortization
period. NPER is the total number of periods
during which annuity is paid. PV is the present
value in the sequence of payments. FV
(optional) is the desired (future) value. Type
(optional) defines whether the payment is due
at the beginning (1) or the end (0) of a period.
PRICE(settlement;
maturity; rate; yield;
redemption; frequency;
basis)
Calculates the market value of a fixed interest
security with a par value of 100 currency units
as a function of the forecast yield. Settlement
is the date of purchase of the security.
Maturity is the date on which the security
matures (expires). Rate is the annual nominal
rate of interest (coupon interest rate). Yield is
the annual yield of the security. Redemption
is the redemption value per 100 currency units
of par value. Frequency is the number of
interest payments per year (1, 2 or 4). Basis
indicates how the year is to be calculated.
PRICEDISC(settlement;
maturity; discount;
redemption; basis)
Calculates the price per 100 currency units of
par value of a non-interest-bearing security.
Settlement is the date of purchase of the
security. Maturity is the date on which the
security matures (expires). Discount is the
discount of a security as a percentage.
Redemption is the redemption value per 100
currency units of par value. Basis indicates
how the year is to be calculated.
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
Appendix B Description of Functions 445