Amortization Calculator

Amortization Calculator: Your Full Schedule and How to Read It

Use this amortization calculator to construct a full payment schedule for any fixed-rate loan and really learn how to interpret it. Most amortized loan calculator programs provide you with a table, and then they end. Leaving you to work out on your own which row counts and why. This loan amortization calculator page does the reverse. We will construct a real schedule and go row by row so you leave knowing exactly what your own schedule is telling you. By the end you’ll know how to find the break-even point on your loan, compare a lender’s statement with your own calculations, and know exactly what happens when you make an extra payment each month.

The Loan We’ll Read Together

For the purposes of this site we will be using one loan: $250,000 borrowed at 6.5% for 30 years (360 months).

Monthly payment: $1,580.17. All the explanations below link back to this same loan, so you may regenerate the same timetable yourself and follow along row by row.

How to Read a Single Row

Each row in an amortization calculator contains 5 parts. The payment number, the amount of the payment, how much of that payment is interest, how much of that payment is principal, and what the residual balance is thereafter.

Here is the plainly spelled-out payment number 1 on our example loan:

Interest is always figured on the remaining balance times the monthly rate: $250,000 x (6.5% / 12) = $250,000 x 0.005417 = $1,354.17.

What is left of the payment after interest is paid off is simply the principal: $1,580.17 − $1,354.17 = $226.00.

New balance = old balance – that principal: $250,000 – $226.00 = $249,774.00

And that’s the whole mechanism. Every row on a schedule, for any loan, does the identical three-step calculation: interest from the current amount, principal as the remainder, and new balance as the outcome. Once you can duplicate this one row by hand, you can test any row in your own schedule the same way.

The Three Rows That Actually Matter

A full schedule can run to hundreds of rows, but three of them tell you almost everything worth knowing.

The First Row

We just figured it out above. Of the $1,580.17 initial payment, just $226.00 actually goes to lower the debt. So, just 14.3% of that payment is going to the actual loan, and the other 85.7% is just paying interest. This is the line item that shocks most new borrowers, and it is worth pondering: In the early years of a long-term loan, you are largely paying for the privilege of borrowing, not reducing what you owe.

The Crossover Row

This is the particular amortization calculator where the principal amount first exceeds the interest portion, and it’s the single most memorable fact on this page because nearly nobody has seen it quantified for their personal loan.

That is payment number 233 for our sample loan, which is 19.4 years into the 30-year period. Interest for that row is $788.75, principal is $791.42, and remaining balance is $144,824.47. Before payment of 233, more of each dollar you pay goes to the bank than to your personal equity. Then it eventually turns over.

The Final Row

At payment 360 the balance is exactly zero. By now the interest portion is down to just $8.51, with $1,571.66, practically the whole payment, applied to principal.

Total interest paid on the original $250,000 borrowed: $318,861.22 throughout the entire 30 years. It is a very helpful number to remember before signing on the dotted line. The real cost, indicated as cumulative interest in the bottom row, is generally considerably greater than the amount you borrowed initially.

Well let’s stop right there at that gap. An interest of $318,861.22 on a $250,000 loan means the entire cost of borrowing is larger than the loan itself around 1.28 times the original loan amount. This sum is seldom presented to the borrower before signing because it’s the monthly payment that is advertised and negotiated, not the total that sits quietly in the last row of a schedule that no one ever reads all the way through.

The Formula Behind the Schedule

The schedule is made by calculating the fixed payment using a mortgage amortization calculator and one formula and then repeating the row-by-row calculation above for each month of the term.

M = P × r(1+r)ⁿ  / (1+r)ⁿ – 1

Where P = principal (amount of loan), r = monthly interest rate, n = number of payments

In our example: M = $250,000 × [0.005417 × (1.005417)³⁶⁰] ÷ [(1.005417)³⁶⁰ − 1] ≈ $1,580.17, the same value given on this page.

Then that number repeats itself every month for the whole term. Interest is recalculated against a shrinking amount each time therefore the division between interest and principal is what changes month to month not the payment. This amortization schedule calculator is exactly the technique explained in the preceding row-reading section.

What Changes When You Pay Extra

The extra payment is applied immediately to your main balance. So you will compute each subsequent row of interest on a lesser number. This will shorten your timetable on the back end rather than the front end.

For our example loan, adding $200 a month in extra installments, making the total amount $1,780.17:

The crossover point slides all the way from payment 233 (19.4 years) to payment 138, 11.5 years, over 8 years earlier. The loan is paid off in full by month 265 (22.1 years) instead of month 360, saving almost 95 months, or 7.9 years. You’ve saved around $97,618 over the initial timetable, bringing your total interest down to about $221,243.

For many folks, the crossover row move is a more obvious method to illustrate the effect of more payments than a line with a savings figure on it; it displays concretely how much sooner your payments start working largely for you instead of mostly for the lender.

Here are a couple of practical tips before making extra payments on an actual loan: Be sure to tell your servicer directly to put the extra amount to the principal, because some servicers default to merely moving your next due date forward instead, which doesn’t shorten the schedule at all. First, review your loan for prepayment penalties. Not all loans enable you to make extra payments without some expense. For a more detailed discussion of payment schemes, try our early payoff calculator.

Five Ways to Actually Use Your Schedule

A schedule is not just a reference table but a really useful tool when you know what you are checking against.

Compare a lender or servicer statement with your own numbers. If the interest or principal split on your statement for a specific payment doesn’t nearly align with what you have on your own schedule, that’s something worth checking directly with your servicer.

Find your balance at a later date. If you plan to sell or refinance in five years, for example, your schedule will tell you the precise balance at that time, not an estimate.

Work out when you would cross an equity threshold. If you are paying mortgage insurance until you reach a certain loan-to-value level, your schedule will tell you exactly what payment takes you there.

See if the timing of a windfall matters. Applying a lump sum early in the schedule, when the debt is greatest, saves significantly more interest than applying the same amount later, as more of the loan’s life is still left to it.

Read the real cost before you sign. And the total of the interest in the last line, which you can see plainly on any full calendar, tells you the real cost of a loan much more honestly than the monthly payment ever would.

Amortization for Car Loans and Other Debts

The same math applies to any fixed-installment debt, not just mortgages, but the shape of the schedule is substantially different on a shorter loan.

Say you got a loan for a $25,000 automobile at 7% for 60 months. Your payment would be $495.03 / month. The break-even point for this loan is immediate, at payment #1: interest is $145.83 and principal is $349.20, so more of your very first payment goes to principal than interest. Compare that to 19.4 years to get to the same milestone in our mortgage scenario. That difference is purely a matter of the shorter term and lower loan-to-payment ratio. A car payment is a significant percentage of the balance, so it becomes mostly principal quickly, whereas a 30-year mortgage payment is little relative to a much greater initial total.

The same schedule structure is used for personal loans and any other fixed-installment debt amortization calculator situation: the same formula, the same row-by-row logic, and only different values based on the size of the loan and period.

One crucial exception should be noted: balances on revolving credit cards are not amortized. There is no preset payment, no predetermined timetable, interest accrues every day, and the minimum payment declines as the balance declines, rather than a set schedule. The scheduling reasoning on this site does not apply at all to card debt. If you want to see how card debt really behaves, check out our Credit Card Calculator instead.

You may also find amortization options provided directly by credit bureaus or individual lenders as part of their own account capabilities. This article does not review or connect to any single provider’s tool; the math here is the same standard computation used industry-wide.

Conclusion

An amortization calculator is more than a table to generate and put aside. It’s a way to check a lender’s statistics, to plan around a potential sale or refinance, and to discover the exact cost of a loan before you sign. You can understand any timetable for any loan, not just the example presented here and not just a 30-year mortgage, but a short amortization calculator car loan or a personal loan somewhere in between, as soon as you can read a single row, the crossover point, and the sum of the final row. The math is always the same just the magnitude of the figures and the speed at which the break-even point occurs change with the particular rate and length of your loan.

FAQs

Q1. How do I read an amortization schedule?

Each row contains a payment number, the amount of payment, and how it is split between interest and principal. Interest is the rate per month times the balance left. The principal is the payment after that. In our example loan, the first payment is $1,580.17, of which $1,354.17 is interest, and $226.00 is principal.

Q2. When does more of my payment go to principal than interest?

This is known as the crossover point, and it is completely dependent on your loan’s rate and length. In our $250,000, 6.5% 30-year example, this happened at payment 233, or around 19.4 years into the loan. Shorter-term loans, such as our example of an automobile loan, can crossover practically instantly.

Q3. Why does my lender’s schedule differ slightly from this one?

This schedule contains principal and interest only; norms for rounding and exact dates of the payment or escrow amounts (property tax and insurance), which are included in a lender’s statement, are not often included. It is common to have small differences they are not a mistake.

Q4. Does an amortization schedule include property tax and insurance?

No. This amortization calculator covers principle & interest only. Property taxes, homeowner’s insurance, and mortgage insurance are generally collected separately in an escrow account and are added into your total monthly payment outside of this calculation.

Q5. How does one extra payment change the whole schedule?

It reduces your balance immediately. That reduces every future interest computation thus it moves the crossover point earlier and shortens the schedule from the end. In our example, the $200 extra payments a month paid off the crossover approximately 8 years earlier and saved around $97,618 in total interest.

Q6. Do credit cards amortize?

No, credit card balances have no set schedule at all. Interest compounds daily and minimum payments go down as the balance goes down. Check out how it works in our credit card calculator.