You make a down payment of 10% (or $25,000) on a 30-year fixed-rate mortgage with a 6% interest rate. Here's how to calculate monthly mortgage payments in Excel: In the spreadsheet, type in "=PMT ...