Enter a loan amount, rate, and term above, and you’ll get the complete amortization schedule — every payment split into interest and principal, with the running balance, grouped by year. Download the whole table as a CSV for your spreadsheet. Free, no signup, and generated entirely in your browser.
How to use
- Loan amount, rate, and term — the same three inputs as any mortgage payment calculator; the summary shows the level payment, total interest, and total paid.
- Browse the schedule — payments are grouped into years; the first year is expanded, and each header shows the balance remaining at year end.
- Download CSV — exports month, payment, interest, principal, and balance for every row, ready for Excel or Google Sheets.
Share a scenario by copying the URL — the inputs are stored in the address bar as you type.
Why early payments are mostly interest
Amortization has a simple engine: each month, interest is charged on whatever balance remains, and only the remainder of your fixed payment reduces that balance. At the start the balance is at its peak, so interest devours the payment — $1,000 of the first $1,199.10 on a $200,000 loan at 6%. But every month the principal portion grows slightly, because it’s chipping at a smaller balance. The crossover where more than half your payment goes to principal arrives surprisingly late — around year 19 on that 30-year example. Higher rates push it later still, which is one reason two loans with similar payments can build equity at very different speeds. This is why selling after five years often returns less equity than people expect, and why the schedule — not the payment — tells you what a loan really costs at any point in time. Scan the year-end balances in the collapsed headers above to see the curve at a glance: shallow for the first decade, then steepening as interest loosens its grip.
How extra principal bends the curve
The schedule also shows why extra principal payments punch above their weight. An extra $100 against principal in month one doesn’t just shave $100 off the end of the loan — it removes the decades of interest that $100 would have generated. Export the CSV, add an “extra payment” column in your spreadsheet, and recompute the balance line: on typical 30-year terms, $100 extra per month removes roughly five years of payments. The same logic explains why lump sums early in the loan (a bonus, a tax refund) beat the identical amount applied in year twenty. If you’re comparing that strategy against refinancing, the refinance break-even calculator handles the other side of the question, and the mortgage affordability calculator helps size the loan before you commit to one.
Limits
The schedule covers a fixed-rate, fully amortizing loan: principal and interest only, no escrow for taxes or insurance, no PMI, and no adjustable-rate resets. Lenders may round or credit payments on slightly different days, so your statement can differ from this table by a few cents in any given month — though the final-payment adjustment convention is the same. Loans with biweekly payments, interest-only periods, or balloon structures follow different math entirely. For how amortization affects your loan choices, the CFPB’s amortization explainer is a short, plain-English read.
Browse all our calculators — every one shows its formula and sources, and our file-based tools run privately in your browser too.