Finance functions

Overview of built-in functions in the Finance group


Index financial functions

DDB Depreciation of an asset
FV Future value of an annuity
IPmt Interest payment for a certain period
IRR Internal revenue rate for a sequence of regular cash flows
MIRR Changed internal rate of return for a series of regular cash flows
NPer Number of periods for an annuity
NPV Net present value of an investment based on a series of regular cash flows
Pmt Amount of installments for a certain amount
PPmt Repayment for a certain period of an annuity
PV Present value of an annuity with constant payments
Rate Interest rate of one annuity per period
SLN Arithmetic depreciation of an asset
SYD Annual depreciation of an asset