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.