Loan comparison template
Comparing offers on the rate alone can mislead when fees and terms differ. Enter up to three offers; the sheet works out the payment, total interest, total cost and the APR including fees, and highlights the cheapest.
Loan comparison
Download template (6 KB)The file contains only formulas and example numbers — no macros, no links, nothing that connects to the internet.
What's inside
- Three offers side by side
- Monthly payment, total interest and total cost
- True APR including upfront fees (RATE formula)
- Cheapest offer highlighted automatically
Prefer to calculate online? Use the APR calculator.
How to use it
- Download the file with the button above and open it in Excel, Google Sheets (File → Import), LibreOffice or Numbers.
- Fill in the yellow cells — they hold your own numbers. The example values show the expected format.
- Everything else is worked out by formulas. Save a copy whenever you want to keep a snapshot.
Common questions
Why can the lowest rate be the most expensive loan?
High arrangement fees or a longer term can outweigh a lower rate. Total cost and APR show the full picture.
Can I compare different terms?
Yes, but remember a longer term gives a lower payment and a higher total cost. Compare total cost if you plan to keep the loan to the end.
More free templates
- Monthly budget plannerPlanned vs actual spending by category, with a 12-month overview.
- Expense trackerLog every purchase; totals by category and month appear automatically.
- Loan amortization scheduleMonthly payment, full schedule and the effect of extra payments.
- Debt snowball and avalanche plannerPayoff order, dates and interest for up to 10 debts.
- Savings goal trackerTrack up to 10 goals: progress bars and the monthly amount still needed.
- Net worth trackerAssets minus debts, month by month for a year, with a chart.
- Monthly timesheetDaily start, end and breaks; hours, overtime and pay for the month.
Ads on this page help keep Abacurio and these templates free. Thank you for your support.