Mortgage Refinance Comparison Spreadsheet, Break-Even Calculator (XLSX + ODS)
By EducoPrice in USD. Local taxes calculated at checkout.
Buy 3 or more, save 20% from this shop
- 1 ZIP download · XLSX, ODS, TTF, TXT, ZIP formats · 3 tabs; XLSX + ODS
- Buyer protection. Corrupt or mismatched files? Full refund.
Item details
A refinance comparison: put the current loan in the first column and two refinance offers next to it to see monthly saving and months to recover fees.
'Compare' sets 3 offers (Current loan, Refinance 1, Refinance 2) in columns: amount, rate, term and fees in, then payment, total of payments, total interest, total cost with fees and cost per $1,000 out. A winner row flags the cheapest total cost; a break-even row divides extra upfront fees by the monthly saving versus the first offer. 'Chart Data' stacks interest and fees per offer.
Workbook pages: Compare: 3 offers side by side with PMT-based payment, total interest, total cost, cost per $1,000, winner flag and break-even months.; Chart Data: Interest and fees per offer with a stacked column chart..
The offers are invented examples.
Download one ZIP containing XLSX + ODS workbook versions, Atkinson Hyperlegible, Nunito OFL font files and licences, and README.txt. The Start Here tab explains inputs, calculations and how to clear the worked entries.
The workbook contains 33 formulas. Its peach design uses coloured input cells and separate calculation cells. Install the bundled fonts before editing to match the previews.
Works with spreadsheet software supporting XLSX + ODS files. Digital download; no macros or external data connections.
Live charts are in the XLSX version. The ODS copy retains the input cells, working formulas and numerical summaries without embedded chart objects.
File specs
| Formats | XLSX, ODS, TTF, TXT, ZIP |
|---|---|
| Dimensions | 3 tabs; XLSX + ODS |
| Color space | sRGB |
| Downloadable files | 1 ZIP download · XLSX, ODS, TTF, TXT, ZIP formats |
| Category | Templates |
| Last updated |
What you’ll download
- zipmortgage-refinance-comparison-spreadsheet-break-even-calcula.zip129 KB
License and usage
- Personal · $4.99
- Use the files in your own non-commercial projects: home prints, gifts, personal social posts and school work. Anything made with them can’t be sold.
- Commercial · $14.97
- Use the files in client work and in products you sell, up to 5,000 units across all products. Credit is appreciated but not required.
No license allows reselling, sharing or redistributing the original files as they are, including in free packs or AI training sets.
