
What it does
Renewal letters, switch offers and Loan Estimates are hard to compare. One has a lower rate but a $1,200 fee. Another has cashback. A third has a 3-year term when you're thinking 5 years ahead. Lining up the monthly payments doesn't tell you which one costs less. This kit compares every offer over the same horizon you choose, month by month, and ranks them by net cost: interest + fees + penalties − cashback/credits. Because it counts the balance you still owe at the end, an offer can't look cheaper just because it repays less.
- Up to 4 offers side by side: rate, rate type, term, amortization, fees, penalties and cashback
- Explicit compounding: Canadian fixed semi-annual, monthly for variable and U.S. loans
- Common comparison horizon (1–40 years) for every offer
- Monthly payment schedule (480 months) for every offer
- Optional extra payments: one recurring amount plus up to 8 dated lump sums, applied equally to every offer
- Canadian prepayment-privilege check
- Totals over the horizon: payments, extras, interest, principal, balance owed, fees, credits and net cost, with a cash-view cross-check
- Life of the loan: payoff date, months saved and total interest
- Zero-interest and early-payoff support
- Dashboard with charts, plus a printable one-page Summary
What's inside
Workbook tabs: Start Here · Dashboard · Offers · Extra Payments · Compare · Summary · Schedule. Download: one .zip with 4 Excel workbooks (.xlsx), a PDF user guide and a licence.
Who it's for
- - Homeowners renewing or switching a mortgage - Buyers comparing purchase or refinance offers from different lenders or brokers
Free calculator: Mortgage calculator (Canada & US)
Frequently asked questions
Does it rank by the lowest payment?
No. It ranks by net cost over your horizon, including the balance still owed.
Why are there two editions?
Canadian fixed-rate mortgages compound semi-annually; U.S. loans compound monthly and include points and PMI.
Can it calculate my penalty?
No. Ask your lender for the exact figure and enter it.
Does it work in Google Sheets?
It hasn't been tested there yet.
You might also like

Rental Property Buy-or-Pass Analyzer
Enter a property's price, financing, rent and costs and see cash needed, NOI, cash flow after a capital reserve, cap rate, cash-on-cash, DSCR and break-even occupancy in three scenarios, checked against your own rules. Excel template with a worked example.

Rental Portfolio Cash-Flow & Reserve Planner
Forecast 12 months of cash for up to 10 rental properties, schedule roofs, HVAC and appliances, and see the monthly reserve transfer that keeps each property above your minimum. Excel template with a worked example.
Rental Property Tracker (T776)
Rent, expenses and your T776 for up to 5 properties.