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 |