Screenshot 2020-06-25 at 18.23.26 | eFinancialModels

Financial Model, General Excel Financial Models, Loans and Debt, Personal Finance

Amortization, Debt Amortization, Debt Schedule, Excel, Financial Debt, Financial Model, Financial Planning, Financing, Personal Finance

This calculator will compute a mortgage or an amortized loan’s periodic payment amount at the defined payment intervals based on the principal amount borrowed, the term’s length, and the annual interest rate (fixed or variable), generating an amortization schedule for the full term, also in chart form.

An amortization schedule is a complete table of periodic payments, showing the amount of principal and the amount of interest that comprise each payment until the loan is paid off at the end of its term. While each periodic payment is the same amount early in the schedule, the majority of each payment is what is owed in terms of interest, while later in the schedule, the majority relates to the loan’s principal. Thus, the shorter the term of the loan, the lower the interest paid.

The model requires the following data inputs:
• Loan amount
• Interest rate type (fixed, variable, mixed)
• Interest rate
• Term (number of years)
• Installments frequency (monthly, quarterly, semi-annual, annual)
• Date of the first installment

Based on the above, the following information will be automatically generated:
• Amount of periodic payment
• Total payments at the due date
• Total interest payment at the due date
• Residual balance to date
• Principal repaid to date
• Interest paid to date
• Interest paid in the current year
• full amortization schedule