|Returns the present value of an investment: the total amount that a series of future payments is worth now.|
|=NPER( rate, nper, pmt, [fv], [type] )|
|rate||The interest rate per period.|
|nper||The total number of payment periods.|
|pmt||The payment made each period.|
|[fv]||The future value.|
|[type]||0 = end of period. 1 = beginning of period. Default is 0.|
Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.