Element
Description
DDB function
Returns double-declining balance depreciation of an asset for a specific period
FV function
Calculates the future value of an annuity
IPmt function
Computes the interest payment for a given period of an annuity
IRR function
Calculates the internal rate of return for a series of periodic cash flows
MIRR function
Calculates the modified internal rate of return
NPer function
Determines the number of payment periods for an annuity, based on fixed periodic payments and a fixed interest rate
NPV function
Calculates the net present value of an investment
Pmt function
Calculates the payment for an annuity
PPmt function
Computes the payment of principal for a given period of an annuity
PV function
Calculates the present value of an annuity
Rate function
Returns the interest rate per period for an annuity
SLN method
Computes the straight-line depreciation of an asset
SYD function
Computes the sum-of- years ' digits depreciation of an asset for a specified period