Debt Payment Breakdown Calculator

 

Use this calculator to breakdown a loan's payment into its principal & interest components for any payment.

Enter your loan terms (monthly principal & interest payment, interest rate & amount borrowed) along with what payment number you want broke down. Results automatically update when any variable is changed.

Your Loan Payment Info

Original amount borrowed:
What is the loan's annual interest rate?
Loan's monthly payment amount?
Which payment number would you like broken down?

Your Repayment Results

Principal portion of the entered payment:
Interest portion of the entered payment:
Remaining monthly payments:
Debt payoff date:

Understanding How Debt Amortization Works

Guide published by Jose Abuyuan on January 21, 2020

Making major life purchases involve taking out a loan. Whether you’re planning to get your first car or own a house, you’ll need to find lenders that offer favorable terms. Otherwise, the wrong decision may lead you into debt.

To date, credit bureau Experian states that Americans reached an average mortgage debt of $203,296 in 2019. That’s $4,919 more debt, or a 2 percent increase from 2018.  

With all the paperwork, payments, and loan terms you need to consider, how does one obtain a good loan? As responsible debtors, we want to make sure we can make timely payments each month. More importantly, how do you know if a loan can end up costing more?

Here’s why you need to know how debt amortization works. In this article, we’ll walk you through what amortization is and how it’s used in calculating loan payments. We’ll also discuss how amortization schedules can help you compare loans to find more favorable terms.

What is Amortization?

Hand giving cash to another hand

Amortization in business is the process of distributing payments over a fixed duration of time. It is often done to monthly loan payments, such as mortgages and auto loans. Accountants refer to amortization as a computing technique used to periodically reduce the value of a loan or intangible asset over a set amount of time.

Amortization applies to two processes. The first is loan amortization and the second is amortization of assets. Loan amortization, or debt amortization, involves paying off a loan balance over a fixed period of time. On the other hand, amortization of assets entails calculating incremental costs throughout the life of an intangible asset.

How Does Debt Amortization Work?

Amortization is a repayment process for a loan with fixed monthly payments and an agreed end date. Examples of amortized loans include 30-year fixed-rate mortgages and 5-year car loans.

Debt amortization applies when you are paying down debt in regular installments. The process involves making planned incremental payments toward the loan’s interest and the principal. Amortization determines how much of your payment goes toward the interest and balance over the life of the loan.

Pigly's Tip!

Think of interest as the amount you pay lenders to secure your loan. And any amount that goes toward the principal gradually reduces your loan balance.

The Challenges of Amortization

The main challenge with amortization is that borrowers do not readily see how much they are paying in interest. This is why it’s important to check amortization schedules. Make sure your payments cover interest that accrues. For the most part, amortized loans are usually distributed evenly to cover any accrued interest. But if your payment fails to address this, negative amortization occurs.

Did You Know?

According to the Consumer Financial Protection Bureau (CFPB), negative amortization happens when the amount you pay is not enough to cover the interest. Ultimately, this causes your balance to increase.

Knowing Your Payment Schedule

Checking date on a calendar

Financial institutions use amortization schedules to show repayment timelines based on agreed terms. If you’ve ever wondered how lending companies compute 30-year home loans, it involves creating this type of payment schedule.

Evaluating your amortization schedule is crucial in understanding how borrowing money works. It helps you calculate how much you should save, as well as the amount of extra payments you can make to pay off your debt sooner.

Many consumers make the mistake of taking loans based on lower monthly payments. Often, amortization schedules for extended loan terms with low payments actually cost more in interest.

If you’re looking for a mortgage lender, reviewing the amortization schedule will help you decide if the terms are truly in your favor.

Take note of the following factors when it comes to analyzing the payment schedule:

  • Payment number
  • Starting balance
  • Principal paid
  • Interest paid
  • Ending balance – Also the current balance, depending on how many payments you’ve made

How do you calculate the interest? The interest payment is computed by multiplying the interest rate by the outstanding loan balance. Then, you divide the product by 12.

How about the principal payment? Subtract the interest payment from your monthly payment, and the difference is the amount that goes to your principal. Then, subtract this value from the original balance to obtain the current loan balance.

To easily break down your loan payment details, use our calculator.

Study the calculations below to give you a better idea. For example purposes, let’s say we are calculating the first interest payment for a 30-year fixed-rate mortgage.

Loan balance: $200,000
Monthly payment: $955
Interest rate: 4%

0.04 x 200,000
= 8,000

8,000 / 12
= 666.67
The first interest payment is $666.67.

955 – 666.67
= 288.33
The first principal payment is $288.33.

200,000 – 288.33
=199,711.67
The current loan balance is $199,711.67.

To calculate the second interest payment, as well as the succeeding payments, repeat this calculation. But use the current loan balance.

This example helps us better understand how debt payments are being distributed to the interest and principal. Once you see your amortization table, you’ll realize the real cost of borrowing money.

Below is a sample amortization table showing the first five payments and the last five payments of a 30-year fixed-rate mortgage.

Amortization Schedule
Loan balance: $200,000
Monthly payment: $955
Interest rate: 4%

Month / Year Payment No. Starting Balance Interest Paid Principal Paid Ending Balance
Feb 2020 1 $200,000 $667 $288 $199,712
March 2020 2 $199,712 $666 $289 $199,423
April 2020 3 $199,423 $665 $290 $199,133
May 2020 4 $199,133 $664 $291 $198,842
Jun 2020 5 $198,842 $663 $292 $198,550
*** *** *** *** *** ***
Sept 2049 356 $4,727 $16 $939 $3,788
Oct 2049 357 $3,788 $13 $942 $2,846
Nov 2049 358 $2,846 $9 $945 $1,900
Dec 2049 359 $1,900 $6 $948 $952
Jan 2050 360 $952 $3 $952 $0

*The figures in this table were rounded off to the nearest whole number.

In the example above, initial payments go more towards interest cost than balance. Principal paid started at $288, increasing by $1 every month for the first five payments. The fifth principal payment is $292. After the first five payments, the balance slightly went down to $198,550.

But towards the end of the loan, the table shows that more of the payment goes toward the principal. Interest paid went down to $16 by the 356th payment. It continues to decrease by $3 every month until the final payment, which is $3. Meanwhile, the principal paid rose to $939 by the 356th payment. It increases by $3 every month, until the balance is fully paid down with $952.

Extended Loans Tend to Cost More in Overall Interest

The table illustrates how most of your payments go towards interest during the early years of a loan. This is most apparent in extended or long-term loans. A large portion of your payment is consumed by interest costs, while the balance only marginally decreases.

However, over the years, a greater portion of your payment goes toward your balance. With every succeeding payment, you’ll eventually pay lower interest cost every month.

Different Types of Amortizing Loans

Loans operate differently. But what the following amortizing loans have in common are fixed interest rates and the same monthly payment, where a portion of the amount goes to the interest and principal.

Common amortizing loans include the following:

Mortgages – It applies to fixed-rate mortgages with 15 or 30-year terms. The payment terms are long because it assumes you will be keeping the property for a long time. However, many homeowners don’t stay too long in one home. They either refinance their home loan or sell their house to move.

Car loans – Traditionally, car loan terms are only around five years. But recently, Experian reported that at least a third of new car loans have terms more than six years. The longer payment duration seems to make expensive cars ‘affordable’ to consumers. However, this is highly unfavorable. Cars depreciate at a quick rate. The longer the loan, the more you’ll spend on a unit with substantially lower value.

Personal loans – Personal loans typically come in three-year terms. Like mortgage and auto loans, they have fixed payments and interest rates. These types of loans are also used to consolidate debt or fund small home improvement plans.

What about non-amortizing loans? These loans include credit cards, which allow you to pay any amount as long as it’s not below the minimum. Another non-amortizing loan is a balloon loan, which involves making a large payment by the end of the term.  

Making Wise Financial Choices

Putting coin in a piggy bank

Debt amortization is useful because it sets fixed payments. This allows you to anticipate the actual cost and keeps you from worrying about increasing monthly payments. Though paying your balance may be slow, it’s a way to manage your cash flow without spending a large amount at once.

Pigly's Tip!

As a borrower, avoid taking out a loan without reviewing all the terms. If you’re shopping for a mortgage, negotiate for lower interest rates. Know how much you to need pay every month. Most importantly, always check the total interest cost. Doing your research will greatly benefit you in the long run.

Having trouble reducing your credit card balance? To learn how to manage your payments, visit this page.

About The Author

Jose Abuyuan is a web content writer, fictionist, and digital artist hailing from Las Piñas City. He is a graduate of Communication and Media Studies at San Beda College Alabang, who took his internship in the weekly news magazine the Philippines Graphic. He has authored works professionally for over a decade.

Thanks for Reading

Please come again!