Excel 모델: 조기 모기지 상환 계산기

 설명:

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.