As a VBA function you can use this function in macro code that is entered through the Microsoft Visual Basic Editor. Final tips for the PMT function. Nper - The total number of payments for the loan.
Click on Formulas tab in the top Menu bar select Financial from Function Library section and double-click on PMT in the drop-down menu.
Now in the cell for the monthly repayment calculation insert the PMT function Im on 2007 if you have 2003 it will be under the insert functions menu. PMT Function in Excel The function calculates the payment for a loan based on constant payments and a constant interest rate. Pv - The present value or total value of all loan payments now. This means that you cant use the function if you want to pay different amounts at different times.