Function 
Description and Example 
See detail 
DB(cost,salvage,life,period,month)

Returns the depreciation of an asset for
a specified period using the fixeddeclining balance method. 

DDB(cost,salvage,life,period,factor)

Returns the depreciation of an asset for
a specified period using the doubledeclining balance method
or some other method you specify.


VDB(cost;salvage;life;start_period;end_period;factor;no_switch)

Returns
the depreciation of an asset for a specific period, including
partial periods 

ISPMT(rate,per,nper,pv)

Calculates the interest paid during a specific
period of an investment. 

NPER(rate;pmt;pv;fv;type) 
Returns the number of periods for an investment


PMT(rate;nper;pv;fv;type) 
Calculates the payment for a loan based
on constant payments and a constant interest rate.


IPMT(rate;period;nper,pv;fv;type)

Returns the interest payment for a given period for an investment
based on periodic, constant payments and a constant interest
rate.


PPMT(rate,per,nper,pv,fv,type)

Returns the payment on the principal for
a given period for an investment based on periodic, constant
payments and a constant interest rate.


SLN(cost,salvage,life)

Returns the straightline depreciation of an asset for one
period.


SYD(cost,salvage,life,per)

Returns the sumofyears' digits depreciation of an asset
for a specified period.


RATE(nper;pmt;pv;fv;type;guess)

Returns the interest rate per period of an annuity.


IRR(values;guess)

Returns the internal rate of an investment for a series of
cash values


MIRR(values;finance_rate;reinvest_rate)

Returns the internal rate
of modified return


PV(rate;nper;pmt;fv;type)

Returns the actual
value of an investment 

FV(rate:nper;pmt;pv;type)

Returns the future of an investment based on periodic and
constant payments plus a fixed interest rate


NPV(rate;value1;value2;...)

Returns the actual net value of an inversion, from a discount
rate and a series of future payments

