• 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

Description
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.

Input
- Loan amount
- Interest rate
- Payment in years
Output
- 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!

Discuss

## Further information

### Objectives

Loan amortization and schedule - New method

See all

## 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)

• 67%
• 22%
• 11%
• -
• -
please wait...