One row per payment: interest, principal, balance. Add extra payments to see the months and interest it removes. Export the whole table as CSV.
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.
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.
| # | Date | Payment | Interest | Principal | Extra | Balance |
|---|
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.