• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Financial Functions

Financial Functions

DB(cost,salvage,life,period,month)Returns the depreciation of an asset for a specified period using the fixed-declining balance method.
DDB(cost,salvage,life,period,factor)Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify.
FV(rate,nper,pmt,pv,type)Returns the future value of an investment.
IPMT(rate,per,nper,pv,fv,type)Returns the interest payment for an investment for a given period.
IRR(values,guess)Returns the internal rate of return for a series of cash flows.
ISPMT(rate,per,nper,pv)Returns the straight-loan payment interest.
MIRR(values,finance_rate,reinvest_rate)Returns the internal rate of return where positive and negative cash flows are financed at different rates.
NPER(rate,pmt,pv,fv,type)Returns the number of periods for an investment.
NPV(rate,value1,value2,…)Returns the net present value of an investment based on a series of periodic cash flows and a discount rate.
PMT(rate,nper,pv,fv,type)Returns the period payment for an annuity.
PPMT(rate,per,nper,pv,fv,type)Returns the payment on the principal for an investment for a given period.
PV(rate,nper,pmt,fv,type)Returns the present value of an investment.
RATE(nper,pmt,pv,fv,type,guess)Returns the interest rate per period of an annuity.
SLN(cost,salvage,life)Returns the straight-line depreciation of an asset for one period.
SYD(cost,salvage,life,per)Returns the sum-of-years'-digits depreciation of an asset for a specified period.
VDB(cost,salvage,life,start_period,end_period,factor,…)Returns the depreciation of an asset for a specified or partial period using a declining balance method.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint