{"product_id":"mortgage-comparison-calculator","title":"Mortgage Comparison Calculator Spreadsheet","description":"\u003cp\u003eThis mortgage comparison spreadsheet shows why the lowest rate is not always the cheapest loan. In the demo, 4.39% costs more than 4.54%. It is for homebuyers and anyone weighing a refinance who wants to compare mortgages with every cost included.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eFour offers, every cost in\u003c\/h2\u003e\u003cp\u003eEnter up to four offers side by side with rate, term, amortization, lender fee and points. Then the sheet does two things most comparison sheets get wrong.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe same number of months.\u003c\/strong\u003e Offers with different terms are compared over the shortest term on offer. A three-year term simply has fewer payments in it; it is not cheaper.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe balance still owed.\u003c\/strong\u003e What you would still owe at the end of the term is counted. Leave it out and the answer flips.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eWhat is left is interest plus fees: the real cost. In the demo the cheapest rate on the page, 4.39%, costs 952 more than 4.54% once its mortgage points and its fee are in. Break even against the no-fee offer is 32.6 months for the winner and 46.2 for the one with the tempting rate.\u003c\/p\u003e\u003ch2\u003eWhat it works out\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eOffer comparison: four offers, every cost in, over a common horizon\u003c\/li\u003e\n\u003cli\u003eBreak-even against the no-fee offer, in months\u003c\/li\u003e\n\u003cli\u003eBalance still owed when your term ends, for each offer\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eEleven connected tabs\u003c\/h2\u003e\u003cp\u003eEverything recalculates from your debt list, so nothing is typed twice. The same workbook also plans payoff for other debts:\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eBoth snowball and avalanche calculated in full, month by month\u003c\/li\u003e\n\u003cli\u003eFreed minimums roll onto the next debt automatically\u003c\/li\u003e\n\u003cli\u003eA payoff date per debt, and the month you are done\u003c\/li\u003e\n\u003cli\u003e400 payments logged, split into principal and interest\u003c\/li\u003e\n\u003cli\u003eCharts that redraw from your own numbers, not pictures\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eLender fees and points are the closing costs that most change the answer, which is why each one is entered per offer.\u003c\/p\u003e\u003cp\u003eYou get a filled-in copy as well as a blank one: a full demo you can click through and a blank ready for your own numbers, in Excel and Google Sheets. There are no dynamic arrays, no macros and no add-ins, and the Google Sheets version is a real workbook, not a PDF with a link in it.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice. No Microsoft 365 subscription required.\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. No Google account is needed for the Excel files.\u003c\/li\u003e\n\u003cli\u003eNo add-ins, no macros, no subscription and no bank connection\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example, and the same workbook blank and ready for yours\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. The Start Here tab walks you through setup in a few minutes. The files are for your own use; please do not share or resell them. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eCan I use it in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. You get Excel files for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make Google Sheets copies with a free Google account.\u003c\/p\u003e\u003ch3\u003eHow many mortgage offers can I compare?\u003c\/h3\u003e\u003cp\u003eFour, side by side, each with rate, term, amortization, lender fee and points.\u003c\/p\u003e\u003ch3\u003eHow does it compare offers with different terms?\u003c\/h3\u003e\u003cp\u003eEverything is measured over the shortest term on offer, and the balance still owed at that point is counted, so a shorter term does not look cheaper just because it has fewer payments.\u003c\/p\u003e\u003ch3\u003eWhat does break-even mean here?\u003c\/h3\u003e\u003cp\u003eThe number of months before an offer with fees or points becomes cheaper than the no-fee offer.\u003c\/p\u003e\u003ch3\u003eWill it tell me which mortgage to choose?\u003c\/h3\u003e\u003cp\u003eNo. It calculates the figures you enter. It is not financial advice, so check the results and the terms with your lender.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597864140894,"sku":"OPX-071","price":22.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/mortgage-comparison-calculator-01.jpg?v=1790832332","url":"https:\/\/opxviashop.com\/products\/mortgage-comparison-calculator","provider":"OPXVIA","version":"1.0","type":"link"}