Calculates the payment for an investment. Pmt5 5 50000 0 1 or pmtb9 b10 b11 b12 b13 Press Enter to run the formula and see your annual loan payment. Excel Pmt Function Examples Example 1 In the following spreadsheet the Excel Pmt function is used to calculate the monthly payments on a loan of 50000 which is to be paid off in full after 5 years.
Calculates the payment for an investment.
PMT Function Example Use of PMT function for fully amortized loan Let us now calculate the monthly due payment amount for a 1000 loan obtain to pay in 12 equal monthly payments. I do this below for a 200000 mortgage with biweekly payments made over the course of 25 years. The PMT function below calculates the. PMTB5B2B1 Where B5 is the cell with interest rate B2 is the cell with the number of payments and B1 is the cell with the loan amount present value.