Page 258 - Excel Data Analysis

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

APPENDIX

EXCEL FUNCTION QUICK REFERENCE

(CONTINUED)

FINANCIAL FUNCTIONS

FUNCTION DESCRIPTION
ACCRINT(issue, first_interest, settlement, rate) AT Finds the total amount of interest paid by the
settlement date.
ACCRINTM(issue, maturity, rate[, par, basis]) AT Finds the total amount of interest paid at maturity
of an investment.
AMORDEGRC(cost, date_purchased, first_period, Uses the French accounting system to find the
salvage, period, rate, basis) AT depreciation of an asset with a depreciation
coefficient.
AMORLINC(cost, date_purchased, first_period, salvage, Uses the French accounting system to find the
period, rate, basis) AT depreciation of an asset.
COUPDAYBS(settlement, maturity, frequency[, basis]) AT Finds the number of days between the start of the
coupon period and the settlement date.
COUPDAYS(settlement, maturity, frequency[, basis]) AT Finds the number of days in the coupon period and
the settlement date.
COUPDAYSNC(settlement, maturity, frequency[, basis]) AT Finds the number of days from the settlement date
to the next coupon date.
COUPNCD(settlement, maturity, frequency[, basis]) AT Finds the next coupon date after the settlement date.
COUPNUM(settlement, maturity, frequency[, basis]) AT Finds the number of coupon dates between the
settlement date and the maturity date.
COUPPCD(settlement, maturity, frequency[, basis]) AT Finds the previous coupon date before the
settlement date.
CUMIPMT(rate, nper, start_period, end_period, type) AT Determines the cumulative interest paid on a loan
between the specified dates.
CUMIPRINC(rate, nper, start_period, end_period, type) AT Determines the cumulative principal paid on a loan
between the specified dates.
DB(cost, salvage, life, period[, month]) Finds the depreciation of an asset using fixed-
declining depreciation.
DDB(cost, salvage, life, period[, month]) Finds the depreciation of an asset using double-
declining depreciation.
DISC(settlement, maturity,pr, redemption[, basis]) AT Determines the discount rate for a security.
DOLLARDE(fractional_dollar, fraction) AT Converts from a fractional to a decimal value.

244