The Crimson Bench

ProFinance · Simulator

Loan Amortization Schedule

The full year-by-year breakdown of any loan.

Assumptions

Monthly payment

$3,483

Total interest

$117,991

Total repaid

$417,991

YearPaymentsInterestPrincipalEnding Balance
Year 1$41,799$20,320$21,480$278,520
Year 2$41,799$18,767$23,032$255,488
Year 3$41,799$17,102$24,697$230,791
Year 4$41,799$15,316$26,483$204,308
Year 5$41,799$13,402$28,397$175,911
Year 6$41,799$11,349$30,450$145,461
Year 7$41,799$9,148$32,651$112,810
Year 8$41,799$6,788$35,011$77,799
Year 9$41,799$4,257$37,542$40,256
Year 10$41,799$1,543$40,256$0

🔒

Unlock the full projection

Every row, plus Excel/PDF export and AI analysis.

Unlock Toolkit Pro →

🔒 Save scenarios, export to Excel & PDF, run AI analysis, and unlock every simulator.

Unlock Toolkit Pro →

Toolkit Pro

Save your scenarios, export to Excel & PDF, run AI analysis, and unlock every simulator — $180/mo, $1,728/yr, or any 3 for $20.

Unlock Toolkit Pro →

Built by The Crimson Bench · Educational model, not financial advice

About the Loan Amortization Schedule

Enter principal, rate, and term to generate a complete amortization schedule — how each year splits between interest and principal, and your falling balance.

It's built for directional planning: change any assumption and watch the whole projection move, the way a seasoned operator pressure-tests a plan before committing capital. Everything is computed live in your browser — nothing is sent anywhere.

How the Loan Amortization Schedule Works

The model takes 3 assumptions and returns 3 headline metrics plus a full breakdown. Here is exactly what goes in and what comes out — no black box.

The Inputs

AssumptionExample value
Loan amount$300,000
Annual interest rate7%
Term (years)10

Worked Example

Every figure below is produced by the live model using the example assumptions above. Change any input in the simulator to see your own numbers.

Monthly payment

$3,483

Total interest

$117,991

Total repaid

$417,991

YearPaymentsInterestPrincipalEnding Balance
Year 1$41,799$20,320$21,480$278,520
Year 2$41,799$18,767$23,032$255,488
Year 3$41,799$17,102$24,697$230,791
Year 4$41,799$15,316$26,483$204,308
Year 5$41,799$13,402$28,397$175,911
Year 6$41,799$11,349$30,450$145,461

The Operator's Read

You'll pay $117,991 in interest over the life of the loan. Early years are mostly interest — extra principal payments now save far more than the same dollars later.

Assumptions & Limitations

  • The model is deterministic: it projects your inputs forward with clear arithmetic, not a Monte-Carlo or probabilistic forecast. It shows one scenario at a time — run several to bracket a range.
  • Defaults are illustrative benchmarks, not your business. Replace every field with your real numbers before drawing conclusions.
  • It abstracts away taxes, financing, seasonality, and one-off events unless a field explicitly captures them. Treat the output as a directional estimate.
  • This is an educational tool, not financial, investment, tax, or legal advice. Validate real decisions with a qualified professional.

Frequently Asked Questions

What does the Loan Amortization Schedule calculate?

Enter principal, rate, and term to generate a complete amortization schedule — how each year splits between interest and principal, and your falling balance. It takes 3 assumptions — Loan amount, Annual interest rate, Term (years) — and returns Monthly payment, Total interest, Total repaid, along with a full projection table you can export.

How do I use the Loan Amortization Schedule?

Enter your own figures in the input fields above — Loan amount, Annual interest rate, Term (years), and the rest. The model recalculates instantly and shows the resulting Monthly payment and full breakdown. No sign-up needed to run it.

Is the Loan Amortization Schedule free?

Yes — you can run the simulator and see the headline results for free. Toolkit Pro unlocks the full projection table, Excel/PDF export, saved scenarios, and AI analysis: $180/mo, $1,728/yr, or unlock any 3 simulators for $20.

What's the difference between this and a free calculator?

A calculator answers one question. This simulator models the full picture — multiple linked assumptions, a projection table, and scenario comparison — the way an operator would build it in a spreadsheet, but instantly.

Who built the Loan Amortization Schedule?

The Crimson Bench's Ivy League-educated operators — the same people we deploy into C-suites. This is the self-serve version of a model they'd build inside a live engagement.

Is this financial advice?

No. The Loan Amortization Schedule is an educational modeling tool for directional planning — not financial, investment, tax, or legal advice. Validate any real decision with a qualified professional.

Related Finance Simulators

More models in the same category.

The Crimson Bench · Est. 2002 · Founded in New York City

Need an operator, not just a model?

Verified corporate accounts only. Ivy League-educated. Flat-rate pricing. 14-day no-cause cancellation.

25,000+ Ivy League Executives · 150,000+ Global Consultants · 48-Hour Deployment