QuanthavenAll financial tools

Loan Calculator

Compare up to five loan scenarios side-by-side with full amortization, refinance modeling, and Excel export.

Frequently asked questions

What is an amortization schedule?

An amortization schedule is a month-by-month table showing how each loan payment is split between interest and principal, and the remaining balance after each payment. Early payments are interest-heavy; later payments shift toward principal as the balance shrinks.

How do I compare loan scenarios side by side?

Add up to five scenarios in the calculator — each with its own loan amount, rate, term, and optional refinance timing. The results view displays every scenario in a comparison table with total interest, monthly payment, and payoff date, so you can see the tradeoffs at a glance.

When does refinancing actually save money?

Refinancing saves money when the interest saved over your remaining hold period exceeds the closing costs of the new loan. This tool models a refinance at any month, compares the remaining interest of the original loan against the new loan plus fees, and reports the break-even date.

Can I export the amortization schedule to Excel?

Yes. Every scenario exports to a fully-formatted Excel workbook with live formulas — you can edit any input in Excel and every downstream cell updates, matching how a bank underwriter would review the loan.