This spreadsheet helps users compare different mortgage options by calculating the payments and financial implications of each mortgage rate. It includes sections for entering loan details, calculating loan summaries, and a payment schedule.
Loan Details: Enter loan amount, interest rate, loan term, and payment frequency.
Loan Summary: Summarizes total payments, payment per period, and interest cost.
Payment Schedule: Breakdown of each payment, including date, payment amount, interest, principal, and remaining loan balance.
Quelle: Custom Calculator
Click the following icon to open the full workbook viewer in a new tab, allowing you to easily edit and save.
Click the following icon to download the spreadsheet, allowing you to save the file on your computer along with edits.