PMTC5 12 C6 12 - C9 When assumptions in column C are changed the estimated payment will recalculate automatically. This will go in the A column. To do this well divide the interest rate by the number of periods in this case 12 to find the monthly interest rate.
Then in the cell next to Payment per month B5 for instance enter this formula PMT B2B4B5B10 press Enter key the monthly mortgage payments has been displayed.
Then in the cell next to Payment per month B5 for instance enter this formula PMT B2B4B5B10 press Enter key the monthly mortgage payments has been displayed. This will open a new Excel spreadsheet. To calculate a loan payment amount given an interest rate the loan term and the loan amount you can use the PMT function. Simply enter the price of the home your down payment and details about the home loan to calculate your mortgage payment breakdown schedule and more.