Finance functions

Overview of built-in functions in the Finance group

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

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