Financial
DB
Description: Returns the depreciation using fixed declining balance calculation.
Example:
DB(cost, salvage, life, period, month)
DDB
Description: Returns the depreciation using double declining balance calculation.
Example:
DDB(cost, salvage, life, period, factor)
FV
Description: Returns future value of an investment.
Example:
FV( interest_rate, number_payments, payment, PV, Type )
IPMT
Description: Returns interest payment.
Example:
IRR
Description: Returns internal rate of return.
Example:
IRR(values, guess)
ISPMT
Description: Returns interest payment.
Example:
ISPMT(rate, per, nper, pv)
MIRR
Description: Returns internal rate of return.
Example:
MIRR(values, finance_rate, reinvest_rate)
NPER
Description: Returns number of payment periods.
Example:
NPER(rate, pmt, pv, fv, type)
NPV
Description: Returns net present value.
Example:
NPV(rate, value1, value2, ...)
PMT
Description: Returns loan payment.
Example:
PMT(rate, nper, pv, fv, type)
PPMT
Description: Returns principal payment.
Example:
PPMT(rate, per, nper, pv, fv, type)
PV
Description: Returns present value.
Example:
PV(rate, nper, pmt, fv, type)
RATE
Description: Returns interest rate per period.
Example:
RATE(nper, pmt, pv, fv, type, guess)
SLN
Description: Returns straight-line depreciation.
Example:
SLN(cost, salvage, life)
SYD
Description: Returns sum-of-years depreciation.
Example:
SYD(cost, salvage, life, per)
VDB
Description: Returns the depreciation using double declining balance calculation.
Example:
VDB(cost, salvage, life, start_period, end_period, factor, no_switch)
Xirr
Description: Computes the internal rate of return for a schedule of possibly non-periodic cash flows.
Example:
Xirr(cashflow, datelist, value)