Excel 모델: 모기지 금리 비교 계산기

 설명:

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.