Calc Guide

Syntax Description
XNPV(rate; values; dates) Calculates the capital value (net present value) for a
list of payments which take place on different dates.
The calculation is based on a 365 days per year
basis, ignoring leap years. If the payments take place
at regular intervals, use the NPV function. Rate is
the internal rate of return for the payments. Values
and dates are a series of payments and the series of
associated date values entered as cell references.
YIELD(settlement; maturity;
rate; price; redemption;
frequency; basis)
Calculates the yield of a security. Settlement is the
date of purchase of the security. Maturity is the date
on which the security matures (expires). Rate is the
annual rate of interest. Price is the price (purchase
price) of the security per 100 currency units of par
value. 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.
YIELDDISC(settlement;
maturity; price; redemption;
basis)
Calculates the annual yield 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). Price is the price (purchase price)
of the security per 100 currency units of par value.
Redemption is the redemption value per 100
currency units of par value. Basis indicates how the
year is to be calculated.
YIELDMAT(settlement;
maturity; issue; rate; price;
basis)
Calculates the annual yield of a security, the interest
of which is paid on the date of maturity. Settlement
is the date of 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. Price
is the price (purchase price) of the security per 100
currency units of par value. Basis indicates how the
year is to be calculated.
392 OpenOffice.org 3.3 Calc Guide