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. |