What is an Amortization Schedule? How to Calculate with a Formula

Personal Finance

Most mortgages are designed in such a way that people pay the same sum each month. The principal and interest of the loan are allocated differently over time.

Amortization is the practise of repaying debt in regular and equal installments. This deposit is used to pay a portion of the principal and a part of the interest each month.

When you make the payments on a mortgage, the majority of the money goes toward interest. Just a tiny amount is used to pay down the debt. This balance adjusts during the tenure of the loan. Each payment goes more toward the principal and less toward interest.

What is an amortization schedule?

An amortization schedule is a table for calculating amortization. It specifies the periodic payments for an amortising debt. The principle of an amortising loan is that it is fully repaid throughout the term of the loan. An equal payment is made every time.

The amortization schedule details how much you pay in interest and principal over time. It also denotes the total amount owed.

The table shows the interest rate for the monthly investment in terms of the principal. This can be useful for things like reducing interest payments for tax purposes.

A loan amortization calculator is used to create amortization schedules.

The following loans are the most likely to incorporate amortization:

Home loans

Banks and lenders can offer fixed-rate mortgages with fixed amortization schedules. These are up to 15 or 30 years old. But some lenders may instead provide an adjustable-rate mortgage. This may impact your amortization schedules in the future.

Personal loans

Personal loans may be available from some lenders with an amortization schedule. These loans have a three-year repayment period. This is used for things like loan consolidation or modest improvements.

Car loans

These loans are for five years. They allow people to repay in monthly payments with interest rather than one lump amount.

Why is it important?

Loan choices are easier to examine.

Amortization schedules make it easier for people to evaluate loan alternatives. They show how much money they’ll spend on each sort of loan. It also shows the total accumulated interest. This can help customers assess which loan’s interest rates present them with the greatest payment choice.

The timeline can be adjusted.

People can use an amortization schedule to change their payment timeline. This is based on how much they pay toward their loans each month. This allows them to repay the debt sooner and change the repayment schedule. This, thereby, saves them money.

Loan instalments are fixed.

When taking out a fixed-rate loan, the amortization plan may help consumers keep track of their payments. It also helps them keep track of the current amount of interest owed. This enables people to plan their payments better and manage their money.

It is an opportunity to build equity.

The amortization schedule may allow consumers to accumulate equity depending on the type of amortization loan they obtain.

How is it calculated?

The monthly interest is figured by dividing your rate of interest by 12 and multiplying it by the current loan balance. Your monthly payments are then increased by the principal amount. Servicers compute this amount monthly to ensure that your loan is paid off by the end of your term. When these amounts are recalculated, your mortgage balance decreases.

If you need to compute your total monthly payment for any reason, use the following formula:

Total Monthly Payment = Loan amount [I (1+i) n / ((1+i) n) – 1)]


I = monthly interest rate.

You should double your annual interest rate by 12. If you have an annual interest rate of 6%, your monthly interest rate is.005 (0.06 divided by 12 months).

n = the number of payments made over the life of the loan.

Divide the number of years of your debt by 12. A 30-year mortgage loan, for example, would have 360 instalments (30 years x 12 months).

If you know the loan term and total monthly payment amount, you can easily draw up a loan amortization plan. You can do this without using an online amortization schedule or calculator.

The following formula is used to determine the monthly principal owed on an amortized loan:

Total Monthly Payment – [Outstanding Loan Balance x (Interest Rate / 12 Months)] = Principal Payment

Entering the principal, interest rate, and loan duration into a loan amortization calculator yields an amortization schedule. However, if you know the loan rate, the outstanding balance, and the loan period, you may calculate the amortization by yourself.

How can this help save money?

A debtor will pay less interest over the entire term of the loan and pay off their mortgage faster if they make overpayments on their mortgage. Even a small extra principal payment could save them money in the long run.

When considering paying off a loan before maturity, it’s critical to ask your servicer if there are any prepayment penalties. Prepayment penalties are the costs paid if a debtor repays the loan too quickly. 


Learning amortization and monthly mortgage calculation might result in repaying your debts early or repaying the principal amount. Amortization has several benefits. For instance, it is recorded as an expense in the entity’s accounts. This leads to lower tax payments. It also helps find the actual value of the business assets. It has several long-term benefits.

Interested in reading more about amortization or another financial topic? Visit Piramal Finance to learn more.