Calc Guide

Syntax Description
MIRR(values; investment;
reinvest_rate)
Calculates the modified internal rate of return
of a series of investments. Values corresponds
to the array or the cell reference for cells
whose content corresponds to the payments.
Investment is the rate of interest of the
investments (the negative values of the array)
Reinvest_rate is the rate of interest of the
reinvestment (the positive values of the array).
NOMINAL(effective_rate;
Npery)
Calculates the yearly nominal interest rate,
given the effective rate and the number of
compounding periods per year. Effective_rate
is the effective interest rate Npery is the
number of periodic interest payments per
year.
NOMINAL_ADD(effective_
rate; Npery)
Calculates the yearly nominal rate of interest,
given the effective rate and the number of
compounding periods per year. Effective_rate
is the effective annual rate of interest. Npery
is the number of interest payments per year.
NPER(rate; PMT; PV; FV;
type)
Returns the number of periods for an
investment based on periodic, constant
payments and a constant interest rate. Rate is
the periodic interest rate. PMT is the constant
annuity paid in each period. PV is the present
value (cash value) in a sequence of payments.
FV (optional) is the future value, which is
reached at the end of the last period. Type
(optional) defines whether the payment is due
at the beginning (1) or the end (0) of a period.
NPV(Rate; value_1;
value_2; ... value_30)
Returns the net present value of an investment
based on a series of periodic cash flows and a
discount rate. Rate is the discount rate for a
period. Value_1; value_2;... value_30 are
values representing deposits or withdrawals.
ODDFPRICE(settlement;
maturity; issue;
first_coupon; rate; yield;
redemption; frequency;
basis)
Calculates the price per 100 currency units
par value of a security, if the first interest date
falls irregularly. 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.
First_coupon is the first interest date of the
security. Rate is the annual rate of interest.
Yield is the annual yield of the security.
Appendix B Description of Functions 443