Skip to content

Financial Functions

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.
Back to top