February 2002
Beginner
328 pages
10h 47m
English
| 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 ... |
Read now
Unlock full access