Calculating the Periodic Payment In this workbook we will develop a spreadsheet for calculating the payment in an meet in Chapter 13. This tool can be extremely helpful if you need to make some calculations and do not want to waste time in a bank. Use the Excel Formula Coach to figure out a monthly loan payment.
This is in a nutshell what the PMT function Excel is and how you can take advantage of it.
Calculating the Periodic Payment In this workbook we will develop a spreadsheet for calculating the payment in an meet in Chapter 13. Calculating the Periodic Payment In this workbook we will develop a spreadsheet for calculating the payment in an meet in Chapter 13. PMTrate nper pv fv type. I do this below for a 200000 mortgage with biweekly payments made over the course of 25 years.