Amortization Calculator: Free Amortization Schedule

How an Amortization Calculator Builds Your Loan Schedule

Borrowing is amortized when it is repaid through equal installments over a set length of time. Each installment covers the interest accrued since the previous one, and whatever is left reduces what you owe. The calculator repeats that step once per pay period until nothing remains, which is why a 25-year loan produces a table of 300 rows. Try the free house affordability calculator to run your own numbers — everything is calculated in your browser and nothing you enter is stored or sent anywhere.

To keep the numbers concrete, this guide follows one example from start to finish: a $318,750 loan at 5.875% over 25 years. The payment comes out to $2,029.42, and the lifetime interest cost across all 300 rows is $290,078.92, which is about 91% of the amount you originally borrowed.

Loan Amount, Interest Rate and Term

Three inputs drive everything. The loan amount is what you borrow, the rate is the annual percentage the lender charges, and the term is how long you have to repay. Change any one and the whole table moves: a lower rate shrinks the interest column, while a shorter term raises the payment but removes many rows of interest.

Choosing a Start Date for Your Amortized Loan

The start date does not change the math, but it labels every row with a real calendar date, so you can see exactly when what you owe drops below a refinancing threshold or when the last bill is due. Enter the date your first payment is due, not the date you signed.

The Amortization Formula Behind Every Installment

The fixed monthly payment comes from one equation: Next, open the free home equity loan calculator and enter your own details to see an estimate in seconds.

$$M = P \times \frac{r(1+r)^{n}}{(1+r)^{n} - 1}$$

Here \(M\) is the payment, \(P\) is the principal, \(r\) is the rate for one period and \(n\) is the total count of payments. It is the same arithmetic you would use in a spreadsheet, only done for you.

Interest Rate per Period and Number of Payments

The annual rate has to be converted before it goes into the formula. For the example, \(r = 0.05875 \div 12 = 0.004896\) and \(n = 25 \times 12 = 300\). That gives \((1+r)^{300} = 4.3283\), so \(M = 318{,}750 \times 0.004896 \times 4.3283 \div 3.3283 = \$2{,}029.42\).

Splitting Each Payment into Interest and Principal

Once you know the payment, the split for any row follows three steps:

1. Interest = balance × \(r\)
2. Principal = payment − interest
3. New balance = old balance − principal

For payment 1, interest is $318,750 × 0.004896 = $1,560.55, so only $468.87 reduces the balance to $318,281.13.

Reading Your Amortization Schedule Line by Line

Every row of an amortization schedule is one payment. The table below shows selected rows from the example, with the same $2,029.42 payment in each. Pair this with the free mortgage payoff calculator for a fuller picture before you make a decision.

Many tools also roll the rows up by year. Here is the same loan in annual form:

Where the Crossover Point Lands

The crossover point is the first payment where principal exceeds interest. In this example it arrives at payment 160, more than 13 years in. Even then you still owe $205,303.37, about 64% of the original amount. That gap between payments made and equity built is why selling early surprises people.

Using the Annual Summary to Plan Ahead

The yearly view makes a trend easy to spot. In year 1 you hand over $24,353.04 and only 23.7% of it reduces the debt. By year 25 about 96.9% does. That shift is the practical meaning of amortization: the bill never changes, yet its purpose does. If you expect a raise, a bonus or a maturing savings account, mark the year on this table where you could afford to prepay, and rerun the numbers from that row.

Why the Interest Column Falls Faster Near the End

Early rows barely move: row 1 to row 2 shaves only $2.30 off the charge. Late in the process the same effect accelerates, because each smaller balance produces a smaller charge, which frees more of the bill to attack what remains. In the example the annual cost drops from $6,751.03 in year 20 to $757.76 in year 25, a fall of nearly 89% in five years. This is the reason that prepaying early saves far more than prepaying late.

Why the Final Row Looks Slightly Different

Each row is rounded to the cent, and those fractions of a cent accumulate over 300 rows. The calculator therefore adjusts the last installment, which is $2,032.34 here rather than $2,029.42, so the final balance lands on exactly $0.00. A difference of a few dollars on the last row is normal and does not mean the table is wrong. Your statement may show a similar small adjustment.

Extra Payments and Your Payoff Date

Any amount above the required payment goes straight to principal, so the next row's interest is calculated on a smaller balance. The saving compounds. On the example loan, adding to every payment changes the finish line like this:

The $175 figure is about 8.6% of the required bill, small enough to fit most budgets yet large enough to matter. An extra $175 a month moves the payoff date forward by 48 payments, a four-year head start, and keeps $53,324.84 in your pocket. Before you commit, check for these points:

• Look for prepayment penalties in your agreement, which are rare on mortgages but common on some other products.
• Tell the servicer in writing that the extra money is meant for principal, not for a future installment.
• Rerun the table with the lower balance after any lump sum.

Verifying a Dealer's Quote Against an Amortization Table

Dana is standing in a dealership finance office with a quote for a used SUV: $27,480 financed, 60 months, a stated 7.35% rate, and a bill of $561 a month. Before signing, Dana opens the amortization calculator on a phone and enters exactly those three figures.

The result comes back at $548.69, not $561. The first row shows $168.31 of interest and $380.38 of principal, and the full table adds up to $5,441.14 of interest over the 60 rows. The gap is $12.31 a month, or $738.60 across the whole loan, so something in the quote is not just principal and interest.

Dana asks for an itemized worksheet. It lists a $617 add-on product folded into the financed figure. That fits the arithmetic: financing $617 more at the same rate adds about $12.32 to the monthly bill, which is the gap. Dana asks for the add-on to be removed and, as a second check, reruns the table at 6.40%, the rate on a credit union pre-approval already in an email. That version gives $536.39 a month and $4,703.51 of interest, which is $737.63 cheaper than the dealer's rate on the same price.

Two decisions follow from the numbers. First, Dana declines the add-on and keeps the dealer's quote only if it matches the credit union's 6.40%. Second, Dana checks the table's row 12, where $22,758.54 is still owed. That figure is the payoff a lender would quote after one year, and it is the number to compare against the trade-in value if the vehicle is ever sold early. With the add-on gone and the lower rate secured, the bill Dana signs for is $536.39.

Loans That Break the Standard Amortization Schedule

A clean table only works for a fixed rate and a fixed payment. Several products behave differently:

• Interest-only loans charge just the interest for an opening stretch, so the balance does not move.
• Balloon loans are calculated on a long schedule but come due early, leaving a lump sum at loan maturity.
• Negative amortization occurs when the payment is smaller than the interest owed, and the shortfall is added to what you owe.
• Adjustable-rate loans redraw the table at each reset, so a schedule is only valid until the next change.
• Credit cards are revolving debt with no fixed end date, because the minimum shrinks as the balance does.

Loan Calculator, Mortgage Calculator or Payoff Calculator

The same engine sits behind several tools, and each adds something for a specific borrower. Pick the one that matches the costs you actually face.

For a business loan, use the plain schedule and add fees separately. If you are weighing a lower rate against restarting the clock, run the new offer through a refinance comparison before you sign.

Comparing Loan Lengths with an Amortization Table

Running the same $318,750 at 5.875% across several lengths shows how strongly duration controls cost. A shorter schedule raises the monthly loan bill but removes whole stretches of charges, while a longer one lowers the bill and adds interest.

Moving from 30 to 15 raises the bill by $782.79 a month but cuts the interest bill by $198,491.25. Whether that trade works depends on your budget, which is exactly the question a printed amortization table helps you answer before you commit.

How a Lower Rate Changes the Cost

Rate matters in the same way. At 5.375% the 25-year schedule costs $261,354.73 in interest, while at 6.375% it costs $319,468.78. That is a spread of $58,114.05 from a single point of difference, so compare offers on the full schedule rather than on the headline bill alone.

Checking Your Servicer's Statement Against the Table

After the first few months, compare your statement with the matching row of your amortization schedule. If the principal amount applied differs from the table by more than a few cents, ask whether a fee or an uneven first period explains it. A match also confirms that the principal balance on your statement agrees with the table.

Comparing Your Table's Interest with Other Debt

Because the table shows each row's interest, you can set that figure beside the monthly cost of your other debts. When you carry credit cards next to a mortgage, the card charge usually runs far higher, so spare cash saves more there than in extra mortgage repayments. Rerun the table as balances change to keep the comparison current.

When to Use an Amortization Schedule Calculator Instead of a Rough Estimate

A rule-of-thumb payment ignores compounding and hides the split entirely. An amortization schedule calculator keeps both, so you can see what each stage of repayment costs. It is the better choice whenever you plan to prepay, refinance or sell within five years.

Amortized Loan Versus Amortized Assets in Accounting

In bookkeeping, amortization describes spreading the cost of intangible assets over their useful life, much like depreciation does for equipment. Patents, copyrights, licenses and customer lists are typical examples, and goodwill is the best known, though self-created goodwill generally cannot be deducted. Certain startup costs can also be written off this way, subject to tax rules, so an adviser should confirm which treatment applies. That meaning has nothing to do with the loan schedule above, but it explains why the same word appears in both finance and accounting contexts.

A Simple Test for Which Meaning You Need

If your question involves a lender and a monthly bill, you need the loan table. If it involves a balance sheet and a multi-year deduction, you need the asset version, and a spreadsheet or an Excel template is usually the easier route there.

Using Your Amortization Schedule to Decide Next Steps

Use the figures it produces to compare options: the installment, the total interest, the payoff date and the balance at any given row. Rerun it whenever your rate or balance changes, and keep the printed table handy at tax time or when talking to your servicer.