Loading…
Full payment-by-payment schedule with running balance, CSV export.
| # | Payment | Principal | Interest | Balance |
|---|---|---|---|---|
| 1 | $2,022.62 | $289.28 | $1,733.33 | $319,710.72 |
| 2 | $2,022.62 | $290.85 | $1,731.77 | $319,419.86 |
| 3 | $2,022.62 | $292.43 | $1,730.19 | $319,127.44 |
| 4 | $2,022.62 | $294.01 | $1,728.61 | $318,833.43 |
| 5 | $2,022.62 | $295.60 | $1,727.01 | $318,537.82 |
| 6 | $2,022.62 | $297.20 | $1,725.41 | $318,240.62 |
| 7 | $2,022.62 | $298.81 | $1,723.80 | $317,941.80 |
| 8 | $2,022.62 | $300.43 | $1,722.18 | $317,641.37 |
| 9 | $2,022.62 | $302.06 | $1,720.56 | $317,339.31 |
| 10 | $2,022.62 | $303.70 | $1,718.92 | $317,035.62 |
| 11 | $2,022.62 | $305.34 | $1,717.28 | $316,730.27 |
| 12 | $2,022.62 | $307.00 | $1,715.62 | $316,423.28 |
📋 The CSV download contains the full payment-by-payment schedule — each row splits the fixed payment into interest (balance × monthly rate) and principal, with the running balance. Early years are interest-heavy.
Each fixed payment splits into interest (current balance × monthly rate) and principal (the rest). Month one on a $320k/6.5%/30y loan sends about $1,733 to interest and only $299 to principal.
Principal overtakes interest roughly halfway through a mortgage term. That asymmetry is why extra principal payments early are disproportionately powerful — each dollar removes all future interest it would have carried.
Download the table and open it in Excel or Sheets to model scenarios: add an extra-principal column, change payment amounts mid-schedule, or total interest paid per year.
On a 30-year term, 1 percentage point swings total interest by tens of thousands. Compare schedules side by side before choosing between lenders or points.
Disclaimer: This calculator is for informational and educational purposes only and does not constitute financial, investment, or legal advice. Calculated results are estimates based on the inputs you provide; actual figures may vary. Always consult a qualified professional before making financial decisions.
The Amortization Table Generator creates amortization table generator on demand, right in your browser. Set the options you need, click generate, and the result is ready to copy. Because everything runs locally, nothing you enter or produce leaves your device.
Generators like this are useful when you need a specific output (a password, a UUID, a QR code, placeholder text) and don't want to install an app or trust an unknown website with your data. This tool is free, has no usage limits, and works the same on phone and desktop.
Common uses: people reach for this tool when they need to use a mortgage amortization table excel, monthly payment breakdown principal interest, loan payoff schedule by month, or remaining balance amortization chart.
Browser-based tools like this one have a few real advantages over installed software or manual methods:
The Amortization Table Generator is based on the following formula:
M = P × r × (1 + r)^n / ( (1 + r)^n − 1 ) Interest(k) = Balance(k−1) × r Principal(k) = M − Interest(k) Balance(k) = Balance(k−1) − Principal(k)
Variables: M = Monthly payment ($) P = Loan principal ($) r = Monthly interest rate (annual rate ÷ 12) n = Total number of payments Balance(k−1) = Remaining balance after payment k−1 ($) Interest(k) = Interest portion of payment k ($) Principal(k) = Principal portion of payment k ($) Balance(k) = Remaining balance after payment k ($)
Every payment is fixed, but its split shifts: early payments are mostly interest, later ones mostly principal. The table applies the three recurrence formulas once per payment until the balance reaches zero.
Worked example: Step 1: P = $20,000 car loan, APR 6%, 60 months: r = 0.06 ÷ 12 = 0.005. Step 2: (1.005)^60 ≈ 1.34885, so M = 20,000 × 0.005 × 1.34885 ÷ 0.34885 ≈ $386.66. Step 3: Payment 1: interest = 20,000 × 0.005 = $100.00; principal = 386.66 − 100.00 = $286.66; balance = 20,000 − 286.66 = $19,713.34. Step 4: Payment 2: interest = 19,713.34 × 0.005 = $98.57; principal = 386.66 − 98.57 = $288.09; balance = $19,425.25. Result: the schedule repeats this for all 60 payments, ending at a $0 balance.
More tools you might find useful