The Financial Functions

As we stated earlier in this chapter, Excel provides several different functions used to perform financial calculations. These functions are covered in alphabetical order, but can be categorized as follows:

To determine the depreciation of an asset:

AMORDEGRC (French function for determining depreciation)
AMORLINC (French function for determining depreciation)
DB (fixed-declining depreciation)
DDB (double-declining depreciation)
SLN (straight-line depreciation)
SYD (sum-of-years depreciation)
VBD (depreciation amount over multiple periods)

To work with loans and annuities with compounded interest:

CUMPRINC (principal paid on a loan)
DISC (discount rate)
FV (future value of an investment)
FVSCHEDULE (future value of investment with variable interest)
IRR (internal rate of return)
MIRR (modified internal rate of return)
NPER (number of payments for future value)
NPV (present value of cash flows)
PMT (investment payment)
PPMT (amount applied to principal for a period)
PV (present value of investment)
RATE (interest rate for an annuity)
XIRR (rate of return for non-periodic cash flows)
XNPV (present value of non-periodic cash flows)

To figure out the number of coupon days in a period:

COUPDAYBS (days between start of period and settlement)
COUPDAYS (days in settlement date period)
COUPDAYSNC (days from settlement date until next period)
COUPNCD (coupon date after settlement)
COUPNUM (number of coupon dates between settlement and maturity)
COUPPCD (determines the coupon date before settlement) ...

Get Excel 2000 in a Nutshell now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.