|Calculates the payment for a loan based on constant payments and a constant interest rate.|
|=PMT( reference, rows, cols, [height], [width] )|
|rate||The interest rate per period.|
|pmt||The payment made each period.|
|pv||The present value, or a total value of all payments.|
|[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.