Page 259 - Excel Data Analysis

14 537547 AppB.qxd 3/4/03 11:57 AM Page 245

EXCEL FUNCTION QUICK REFERENCE B

FINANCIAL FUNCTIONS (CONTINUED)

FUNCTION DESCRIPTION
DOLLARFR(decimal_dollar, fraction) AT Converts from a decimal value to a fractional value.
DURATION(settlement, maturity, coupon, yld, Finds the Macauley duration value for a security.
frequency[, basis]) AT
EFFECT(nominal_rate, npery) AT Finds the effective annual interest rate on an
investment.
FV(rate, nper, pmt[, pv, type]) Finds the future value of an investment.
FVSCHEDULE(principal, schedule) AT Finds the future value of an investment with a
variable interest rate.
INTRATE(settlement, maturity, investment, Finds the interest rate on a security.
redemption, [basis]) AT
IPMT(rate, per, nper, pv[, fv, type]) Finds the interest payment on an investment for a
specific period.
IRR(values, [guess]) Finds the internal rate of return.
ISPMT(rate, per, nper, pv) Finds the interest payment for a specific period.
MDURATION(settlement, maturity, coupon, yld, Finds the modified duration value for a security.
frequency[, basis]) AT
MIRR(values, finance_rate, reinvest_rate) Finds the modified internal rate of return.
NOMINAL(effect_rate, npery) AT Finds the nominal annual interest rate.
NPER(rate, pmt, pv, [fv, type]) Finds the number of payments on an investment.
NPV(rate, value1, [value2, ...]) Calculates the present value of an investment.
ODDFPRICE(settlement, maturity, issue, first_coupon, Calculates the price of an investment with an
rate, yld, redemption, frequency[, basis]) AT abnormal length of the first period.
ODDFYIELD(settlement, maturity, issue, first_coupon, Calculates the yield of an investment with an
rate, pr, redemption, frequency,[basis]) AT abnormal length of the first period.
ODDLPRICE(settlement, maturity, issue, last_interest, Calculates the price of an investment with an
rate, yld, redemption, frequency[, basis]) AT abnormal length of the first period.
ODDLYIELD(settlement, maturity, issue, last_interest, Calculates the yield of an investment with an
rate, pr, redemption, frequency,[basis]) AT abnormal length of the first period.
PMT(rate, nper, pv[, fv, type]) Finds an investment payment.
PPMT(rate, per, nper, pv[, fv, type]) Finds the amount applied to the principal for a
payment period.
PRICE(settlement, maturity, rate, yld, redemption, Calculates the price of a security with periodic
frequency,[basis]) AT interest.

245