Amortization schedules your bank never sees
Build the full payment-by-payment table for any fixed-rate loan — with extra payments, biweekly mode, and real Excel, CSV and PDF exports. Everything runs in your browser: your balance, rate and payoff plans never leave your device.
- Free, no signup, no email gate
- Exports generated on your device
- Works offline — proof nothing uploads
- Formulas documented
Example loan — replace with your own amount, rate and term
Payment-by-payment schedule
| # | Date | Payment | Principal | Interest | Extra | Balance |
|---|
Click a year to expand its payments. Exports and print always include every payment.
How it works
- Enter the loan amount, interest rate and term — the payment, payoff date and full schedule appear instantly.
- Add extra payments (monthly, yearly, or one-time) or switch to biweekly and watch the payoff date move and the interest saved appear.
- Read the payment-by-payment table — every row shows principal, interest and the balance left.
- Download the schedule as Excel, CSV or PDF, or print it. Everything is generated on your device.
Under the hood it’s the standard fixed-rate loan math — the same annuity formula every servicer uses, documented with worked examples on the methodology page and explained in plain language in how amortization works. No black box: the schedule you download can be reproduced line by line.
Why a loan calculator should run locally
An amortization schedule needs your loan balance, your interest rate, and your plans for paying it off — a decent sketch of your financial life. Type those into a typical “free” mortgage calculator and they land on the server of a company whose actual product is refinance leads or your contact details. AmortizeLocal keeps the trade honest: the site is static, the math is a few kilobytes of JavaScript running on your device, drafts stay in your browser’s own storage, and there is no email field anywhere. Ads may eventually pay for hosting — they will never see your numbers, because there’s architecturally nothing to see.
Frequently asked questions
What is an amortization schedule?
A payment-by-payment table of a loan’s life: for every payment it shows how much goes to interest, how much to principal, and the balance left afterward. Early payments are interest-heavy because interest is charged on the whole remaining balance; the split shifts toward principal as the balance falls. The generator above builds the complete table for any fixed-rate loan and lets you download it.
How is each payment split between principal and interest?
Each period’s interest is the annual rate divided by the number of payments per year, applied to the current balance; whatever is left of your level payment then reduces the principal. On a $200,000 loan at 6%, the first month charges $1,000 interest (200,000 × 0.5%), so a $1,199.10 payment retires only $199.10 of principal. Next month the balance is slightly smaller, so the interest slice is too. The full math is on our methodology page.
How do extra payments change the schedule?
Extra payments are principal-only: they skip the interest line and permanently shrink the balance every later interest charge is computed on. That’s why modest extras compound into years of difference. Open “Extra payments” in the calculator, and the schedule, chart and savings figures update to show exactly what your extra amount does — no rules of thumb involved.
What does paying biweekly do?
Half your monthly payment every two weeks is 26 half-payments a year — the same as 13 monthly payments instead of 12. The 13th payment is pure principal, which shortens the loan by years at typical mortgage rates. The calculator has a biweekly mode that rebuilds the whole schedule on 14-day dates, and compares it against the monthly baseline.
Can I download the schedule to Excel?
Yes — the Excel button produces a real .xlsx workbook (a Summary sheet plus the full Schedule sheet with numeric cells), generated entirely in your browser. There’s also CSV for imports, PDF for records, and print. No template downloads, no email gate, no upload — the file is built on your device.
Where do my loan details go when I type them in?
Nowhere. This site is static — there is no server that could receive your numbers. The schedule is computed by a small JavaScript program running on your own device, and your inputs persist only in your browser’s localStorage. Verify it yourself: open DevTools → Network while using the calculator, or switch off Wi-Fi — it keeps working.
Does this work for mortgages, car loans and personal loans alike?
Any fixed-rate, fully-amortizing loan — mortgage, auto, student (on a fixed plan), personal — uses the same math and works here. What it deliberately doesn’t model: variable-rate loans and HELOCs (the rate path is unknowable), interest-only periods, and income-driven student plans. For car loans, note that many lenders accrue interest daily; on-time payers will match this schedule within a few dollars.
How accurate is this compared to my lender’s schedule?
It uses the standard US fixed-rate conventions — monthly (or biweekly) rate on the remaining balance, payment rounded to the cent, final payment adjusted — so it lands within a few dollars of servicer schedules; tiny differences come from lenders’ rounding and day-count choices. Every convention is documented on the methodology page so you can reproduce any number.