| DB |
Returns the asset depreciation for a period using the fixed declining balance method. |
| DDB |
Returns the asset depreciation for a period using the double-declining balance method or another specified method. |
| FV |
Returns the future value of an investment that makes payments as a lump sum or as a series of equal periodic payments. |
| IPMT |
Returns the interest for a period of time based on an investment with periodic constant payments and a constant interest rate. |
| IRR |
Returns the internal rate of return for a series of cash flows represented by numbers in the form of values. |
| ISPMT |
Calculates the interest paid during a defined period of an investment. |
| MIRR |
Returns a modified internal rate of return for several periodic cash flows. |
| NPER |
Returns the total number of periods for an investment. This is based on a periodic constant payment and a constant interest rate. |
| NPV |
Calculates the net present value of an investment from the discount rate and several future payments and income. |
| PMT |
Calculates the loan payment for a loan based on constant payments and constant interest rates. |
| PPMT |
Returns the principal payment for a period of an investment based on periodic constant payments and a constant interest rate. |
| PV |
Returns the present value based on an investment. |
| RATE |
Returns per period the interest of an annuity. |
| SLN |
Returns the straight-line depreciation on an asset. |
| SYD |
Based on a specified period, SYD returns the sum-of-years’ digits depreciation of an asset. |
| VDB |
For a period you specify, returns the depreciation of an asset. |