{"product_id":"car-loan-payoff-cost-tracker","title":"Car Loan Payoff and Car Cost Tracker Spreadsheet","description":"\u003cp\u003eThis car loan tracker puts the loan and the cost of running the car in one place, because the monthly payment is only part of what a car costs. In the demo the payment is 700 a month, but the car costs 1,543. It is for anyone who wants the full picture before or after taking on an auto loan.\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\u003eRunning costs priced the way you pay them\u003c\/h2\u003e\u003cp\u003eTen running-cost categories, each priced as what it costs each time and how many times a year: fuel weekly, insurance monthly, tires once. The yearly total falls out, and so does the number almost nobody works out, the cost per kilometer with loan and running costs together.\u003c\/p\u003e\u003cp\u003eIn the demo that is 10,122 in running costs on top of 8,400 in loan payments, over 18,400 kilometers, or 1.01 a kilometer all in. Interest is shown separately and inside the payment, not added on top of it, which is where many spreadsheets quietly double-count.\u003c\/p\u003e\u003ch2\u003eThe loan side\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eLoan payments and interest read from your debt list, never retyped\u003c\/li\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\u003ch2\u003eEleven connected tabs\u003c\/h2\u003e\u003cp\u003eEverything recalculates from your debt list, so nothing is typed twice. It works as a loan calculator for the payoff date and as a log of vehicle expenses for the year, with car costs and the loan side by side on the dashboard.\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\u003eDoes it work 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 are running costs entered?\u003c\/h3\u003e\u003cp\u003eFor each of ten categories you enter what it costs each time and how many times a year, and the yearly total is worked out.\u003c\/p\u003e\u003ch3\u003eDoes it work out cost per kilometer?\u003c\/h3\u003e\u003cp\u003eYes. It combines running costs and loan payments over the distance you drive to give a cost per kilometer, all in.\u003c\/p\u003e\u003ch3\u003eDoes it double-count interest?\u003c\/h3\u003e\u003cp\u003eNo. Interest is shown separately but inside the loan payment, not added on top of it.\u003c\/p\u003e\u003ch3\u003eCan I track other debts too?\u003c\/h3\u003e\u003cp\u003eYes. The debt list takes other loans, with snowball and avalanche calculated in full and a payoff date for each debt.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597864108126,"sku":"OPX-070","price":20.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/car-loan-payoff-cost-tracker-01.jpg?v=1790832326","url":"https:\/\/opxviashop.com\/products\/car-loan-payoff-cost-tracker","provider":"OPXVIA","version":"1.0","type":"link"}