This spreadsheet helps users calculate the benefits of making extra payments on their mortgage to pay it off early. It includes sections for loan information, a summary of loan payments with and without extra payments, and a detailed payment schedule.
贷款信息: Enter details such as loan amount, annual interest rate, term of the loan, and extra monthly payment.
Loan Summary: Compare monthly payment, number of payments, total payments, total interest, and interest savings with and without extra payments.
Payment Schedule: Track monthly payments, including breakdowns of principal and interest, cumulative totals, and remaining balance.