KKoumen Tools PRO

Amortization schedule — every payment, split two ways.

One row per payment: interest, principal, balance. Add extra payments to see the months and interest it removes. Export the whole table as CSV.

$
%
yr
$

Free today: 3/3 exports. The first year of the table is always on screen; the CSV carries every payment. All-Access lifts the counter.

The loan figures never reach a server — the arithmetic runs in this tab.

Waiting for numbers
—
Payments—
Total interest—
Payoff—

Interest compounds at the payment frequency, not annually. Monthly payments use rate/12; biweekly uses rate/26, which is not the same as making half a monthly payment every two weeks.

A schedule is not an estimate — it is the contract arithmetic. If your lender's table and this one differ by more than a cent on the final payment, one of the two is compounding on a different basis.

What an amortization schedule actually is

An amortization schedule is a loan contract written out one payment at a time. For each period the lender takes the outstanding balance, multiplies it by the periodic rate, charges that as interest, and applies whatever is left of the payment to the principal. The balance drops, so next month's interest is slightly smaller, so slightly more of the payment goes to principal. The payment stays level; only its two halves move.

It matters because the two halves behave completely differently outside the contract. Interest is gone. Principal comes back to you as equity in the asset, or as a smaller balance you no longer pay interest on. Two loans with the same payment and the same rate but different schedules — one with a balloon, one without — are not the same loan, and the schedule is the only place that shows it.

How to read the numbers this tool produces

  1. Loan amount is the principal at origination, not the purchase price. If you are modelling a mortgage on a $312,000 house with 20% down, the figure here is 249,600. Fees rolled into the loan belong here too; fees paid at closing do not.
  2. Annual rate goes in as the nominal rate on the note — the one in the truth-in-lending box, not the APR. The APR folds in fees and is always a little higher, so typing it here double-counts cost.
  3. Term is the number of years the payment is calculated over. A 30-year loan with a 10-year balloon still has a 30-year payment; the schedule will run to 360 rows and the balloon is your problem, not the calculator's.
  4. Extra principal is applied every payment and shortens the term rather than lowering the payment. That is what almost every lender does by default, and it is the behaviour that saves the most interest.
  5. Payments per year changes the periodic rate, not just the count. Choosing biweekly divides the annual rate by 26 and compounds 26 times a year, which produces a genuinely different total from paying twelve times.

The periodic rate is annual rate ÷ payments per year. Nothing here uses an effective annual rate, because lenders quote nominal rates and charge on the nominal basis. A 6% note paid monthly accrues 0.5% a month, which is 6.17% a year once compounding is counted — and that gap is why the total interest on a 30-year loan looks larger than "six percent" suggests.

A worked example, through to the last row

Take a $250,000 loan at 6.5% over 30 years, paid monthly, first payment January 2027. The periodic rate is 6.5 ÷ 12 = 0.0054167. The level payment is:

250,000 × 0.0054167 ÷ (1 − 1.0054167−360) = $1,580.17

The first row: interest is 250,000 × 0.0054167 = $1,354.17; principal is 1,580.17 − 1,354.17 = $226.00; the balance falls to $249,774.00. In the first twelve payments you hand over $18,962.04 and reduce the debt by $2,819.93 — 14.9% of the year's money went to principal. That single ratio is the reason an early payoff feels slow and a late one feels fast.

Now add $200 a month of extra principal. The cash out the door becomes $1,780.17 and the balance clears in 265 payments instead of 360 — seven years and eleven months earlier. Total interest drops from $318,861.58 to $221,243.14, a saving of $97,618 for $52,800 of extra cash spread over 22 years — roughly $1.85 of interest avoided for every extra dollar, because each extra dollar removes years of charges on itself.

Compare that with buying the shorter term up front. A 20-year loan at the same 6.5% has a contractual payment of $1,863.93 — higher than $1,780.17 — finishes in 240 payments, and costs $197,344.65 in interest. That is $23,898 less interest than the extra-payment route, and it is the price of keeping the option to drop back to $1,580.17 in a bad month. Neither column is wrong; the schedule is how you price the difference before you sign, rather than discovering it in year nine.

The rows also explain a complaint that sounds like an error. Payment 360 of the base loan leaves a balance of $0.38, so the closing payment is 38 cents rather than $1,580.17. That is rounding: 360 rows each rounded to the nearest cent drift by up to half a cent apiece. Lenders handle it the same way, and a table whose last row exactly equals the regular payment to the cent was probably not rounded row by row.

Where amortization tables go wrong

Why export the table at all

Because the number people need is rarely the monthly payment. It is the interest in year three for a tax return, the balance at a given date for a divorce or estate filing, the payoff figure a buyer needs before closing, or the row where the balance finally drops below the value of the car. All of those are lookups in a table, and a table is more useful as a spreadsheet than as a picture of one. The CSV opens in Excel, Numbers, Google Sheets or a bookkeeping import, with a header row and one line per payment.

Desktop lending software does the same thing behind a per-seat licence, and most online calculators show you a chart and hide the rows. The arithmetic is not the valuable part — the row-by-row record is.

Questions

Does the extra payment shorten the loan or lower the payment?

It shortens it. The contract payment stays the same and the balance falls faster, so the schedule ends early. Lowering the payment requires the lender to re-amortise the remaining balance over the remaining term, which most servicers will only do on request and sometimes only at a fee. The savings figure on this page is the interest you avoid by finishing early, not a change to the monthly amount.

Why does my bank's total interest differ by a few dollars?

Almost always rounding. Some servicers round the periodic rate to eight decimals, some round each interest charge to cents before subtracting, and a few use a 365/360 day-count that adds a day of interest in 31-day months. A few dollars over 360 payments is normal; a few hundred means a different rate basis or an escrow amount folded into the payment.

Can I model a car loan or a personal loan with this?

Yes, and the inputs are the same three numbers: amount financed, note rate, term in years. A $28,400 car loan at 7.9% over 5 years is 60 payments of $574.49 with $6,069.52 of interest. Leave the extra field at zero to match the dealer's sheet, then add $50 to see what the long term actually costs.

What goes in the first payment date?

Only the date column. It changes nothing in the arithmetic, but it does make the exported table usable as a filing — a payment on 2027-03-01 lands in the right tax year without you sorting it by hand afterwards.

Is the loan data uploaded anywhere?

No. The schedule is computed and the CSV is built in this tab, and nothing is transmitted. The only request the page makes is the quota check that tells the server how many exports you have left today, and it carries no loan figures.

More money tools

All money tools →

Guides

Free: 3 exports a day, first year on screen

This one counts exports rather than files: three a day for free, with the first year of the table on screen. All-Access removes the counter and opens the PDF and image tools, which are free three runs a day on the first two pages.