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)