Page 260 - Excel Data Analysis
P. 260
14 537547 AppB.qxd 3/4/03 11:57 AM Page 246
APPENDIX
EXCEL FUNCTION QUICK REFERENCE
(CONTINUED)
FINANCIAL FUNCTIONS (CONTINUED)
FUNCTION DESCRIPTION
PRICEDISC(settlement, maturity, discount, Calculates the price of a discounted security.
redemption, [basis]) AT
PRICEMAT(settlement, maturity, issue, rate, yld[, basis]) AT Calculates the price of a security with interest paid
at maturity.
PV(rate, nper, pmt[, fv, type]) Finds the present value of an investment.
RATE(nper, pmt, pv[, fv, type, guess]) Finds the interest rate per period of an annuity.
RECEIVED(settlement, maturity, investment, Calculates the amount received at the maturity of a
discount[, basis]) AT security.
SLN(cost, salvage, life) Finds the straight-line depreciation of an asset.
SYD(cost, salvage, life, per) Finds the sum-of-year's digits depreciation of an asset.
TBILLEQ(settlement, maturity, discount) AT Finds the bond-equivalent yield for a Treasury Bill.
TBILLPRICE(settlement, maturity, discount) AT Finds the price for a Treasury Bill.
TBILLYIELD(settlement, maturity, pr) AT Finds the yield for a Treasury Bill.
VDB(cost, salvage, life, start_period, end_period[, Finds the depreciation of an asset over multiple
factor, no_switch]) periods.
XIRR(values, dates, [guess]) AT Calculates the rate of return for non-periodic cash
flows.
XNPV(rate, values, dates) AT Calculates the present value of non-periodic cash
flows.
YIELD(settlement, maturity, rate, pr, redemption, Calculates the yield of a security.
frequency[, basis]) AT
YIELDDISC(settlement, maturity, pr, redemption, Calculates the yield of a discounted security.
[basis]) AT
YIELDMAT(settlement, maturity, issue, rate, [basis]) AT Calculates the yield of a security with interest paid
at maturity.
246
