Dynamic Loan amortization & schedule Excel Calculator
Originally published: 26/08/2019 07:32
Last version published: 07/09/2019 08:07
Publication number: ELQ-31787-3
View all versions & Certificate

Dynamic Loan amortization & schedule Excel Calculator

Dynamic loan amortization & schedule - New method

What Is an Amortization Schedule?

An amortization schedule is a complete table of periodic loan 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 interest; later in the schedule, the majority of each payment covers the loan's principal. The last line of the schedule shows the borrower’s total interest and principal payments for the entire loan term.

Amortization Schedule

In an amortization schedule, the percentage of each payment that goes toward interest diminishes a bit with each payment and the percentage that goes toward principal increases.

Understanding Amortization Schedule

Borrowers and lenders use amortization schedules for instalment loans that have payoff dates that are known at the time the loan is taken out, such as a mortgage or a car loan. If you know the term of a loan and the total periodic payment, there is an easy way to calculate an amortization schedule without resorting to the use of this dynamic loan amortization schedule or calculator.

Dynamic loan calculator:
This calculator automatically loan summary and amortization schedule dynamic rows.

- Loan amount
- Interest rate
- Payment in years
- End date
- Repayment (month)
- Total interest
-Total payment
-Dynamic amortization & schedule

This Best Practice includes
1 Excel Spreadsheet

Bolortseren Boldtseren offers you this Best Practice for free!

download for free

Add to bookmarks


Further information

Loan amortization and schedule - New method



Any questions on Dynamic Loan Amortization & Schedule Excel Calculator?

The user community and author are here to help. Go ahead!

4.6 / 5 (9 votes)

please wait...