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 ... |
Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.