14.5 Financial functions
Financial functions perform a range of specialist calculations involving money.
-
CTERM(
interest,
future_value,
present_value )
-
DB(
cost,
salvage,
life,
period
{, month} )
-
DDB(
cost,
salvage,
life,
period
{, factor} )
-
FV(
payment,
interest,
term )
-
FVSCHEDULE(
principal,
rates )
-
IRR(
guess,
data )
-
MIRR(
values,
finance_rate,
reinvest_rate )
-
NPER(
rate,
pmt,
present_value )
-
NPV(
interest,
range )
-
PMT(
principal,
interest,
term )
-
PV(
payment,
interest,
term )
-
RATE(
future_value,
present_value,
term )
-
SLN(
cost,
salvage,
life )
-
SYD(
cost,
salvage,
life,
period )
-
TERM(
payment,
interest,
future_value )