Calculate Monthly Mortgage Payments in Excel Spreadsheet programs, such as Microsoft Excel and Google Sheets, include a payment function that can calculate the principal and interest on a mortgage.

Your monthly payment on a $600,000 home will depend on a few factors, including how big of a down payment you make, your interest rate and your loan term.

Including your down payment, you'd pay $851,844 on your home. If you can afford a higher monthly payment, getting a 15-year fixed-rate mortgage can save you money on interest payments.