Financial Terms / amortization schedule

Amortization Schedule Calculator

The Amortization Schedule Calculator is a useful tool for calculating monthly mortgage payments and the total principal and interest paid on a mortgage at a specified date.

How do I calculate the amortization schedule?

An amortization schedule is a great way to pay off a loan or spread out capital expenses over a set duration. To calculate the term, you can use a formula such as  P = R x ( (1 + R)N / ((1 + R)N - 1) )  where P is the payment amount, R is the interest rate per period, and N is the total number of payments. You can also easily generate an amortization schedule using a program like Sourcetable.

What is an amortization schedule?

An amortization schedule is a table showing the amount of principal and interest you need to pay each month on a loan. It also shows the total amount of principal and interest you will pay over the life of the loan.

How does an amortization schedule work?

An amortization schedule is used to calculate the monthly payment on a loan. The monthly payment is calculated by applying the following formula: Monthly Payment = Principal * (Interest Rate / 12) / (1 - (1 + Interest Rate / 12)-Term), where Principal is the loan amount, Interest Rate is the annual interest rate on the loan, and Term is the length of the loan in months.

What information is included in an amortization schedule?

An amortization schedule will typically contain information about the loan amount, interest rate, loan term, and the monthly payment. It will also show the total amount of principal and interest you will pay over the life of the loan. 

Key Points

Periodic Loan Payments:
An amortization schedule shows the periodic loan payments for loans with a level payment. The payments are usually made on a monthly basis and are composed of both principal and interest.
Example Loans:
An example of an amortizing loan is a mortgage and a car loan because both have known payoff dates.
Payoff Date:
The payoff date for an amortizing loan is known in advance, making it easy to determine when the loan will be paid off.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.