{"product_id":"bilkostnadskalkyl-fordons-tco-2026-2027-kopa-eller-leasa-bil-kostnad-per-mil-excel-word-pdf","title":"Car Cost Calculator \u0026 Vehicle TCO 2026\/2027 – Buying or Leasing a Car, Cost per Mile | Excel, Word \u0026 PDF","description":"\u003csection class=\"mb-product-description\" lang=\"en\"\u003e\n\u003ch2\u003eVehicle Cost Calculator \u0026amp; Vehicle TCO 2026\/2027 – purchase or leasing in Excel, Word and PDF\u003c\/h2\u003e\n\n\u003cp\u003eWhat does a car \u003cstrong\u003eactually cost over the entire usage period\u003c\/strong\u003e? This professional vehicle cost calculator helps Swedish companies compare \u003cstrong\u003epurchasing and leasing vehicles\u003c\/strong\u003e, including acquisition costs, leasing fees, fuel\/charging, service, insurance, vehicle tax, financing interest, and expected residual value.\u003c\/p\u003e\n\n\u003cp\u003eYou receive a functional Excel template for \u003cstrong\u003esix vehicle options and up to seven calculation years\u003c\/strong\u003e, along with editable decision forms, quote comparisons, control routines, risk checklists, and a detailed user guide in Word and PDF. The main documents are in Swedish, and an English working form and English quick guide are included. \u003cstrong\u003eOne-time price: 79 SEK.\u003c\/strong\u003e\u003c\/p\u003e\n\n\u003cnav aria-label=\"About the document template\"\u003e\u003cstrong\u003eOn this page:\u003c\/strong\u003e \u003ca href=\"#mb-innehall\"\u003eWhat is included\u003c\/a\u003e · \u003ca href=\"#mb-excel\"\u003eThe Excel tool\u003c\/a\u003e · \u003ca href=\"#mb-steg\"\u003eHow to use\u003c\/a\u003e · \u003ca href=\"#mb-juridik\"\u003eCars and VAT\u003c\/a\u003e · \u003ca href=\"#mb-faq\"\u003eQuestions and answers\u003c\/a\u003e\u003c\/nav\u003e\n\u003caside style=\"background:#EAF5EF;border-left:4px solid #377B58;padding:15px;margin:16px 0\"\u003e\u003cstrong\u003eSource-checked on October 13, 2026.\u003c\/strong\u003e Information regarding VAT on the purchase and rental\/leasing of passenger cars has been verified against the Swedish Tax Agency's (Skatteverket) guidance for 2026. The product is not government-approved or externally reviewed by legal counsel. Excel is an economic planning aid and does not perform automatic tax or contract law assessments.\u003c\/aside\u003e\n\u003ch2 id=\"mb-innehall\"\u003eWhat is included – 13 files\u003c\/h2\u003e\n\n\u003ctable\u003e\n\n\u003cthead\u003e\u003ctr\u003e\n\n\u003cth\u003eDocument\u003c\/th\u003e\n\n\u003cth\u003eUsage\u003c\/th\u003e\n\n\u003cth\u003eFormat\u003c\/th\u003e\n\n\n\u003c\/tr\u003e\u003c\/thead\u003e\n\n\u003ctbody\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eVehicle Cost Calculator \u0026amp; Vehicle TCO\u003c\/td\u003e\n\n\u003ctd\u003eEight Excel sheets with dashboard, six options, annual calculation, VAT documentation, quote register, controls, and decisions.\u003c\/td\u003e\n\n\u003ctd\u003eExcel (XLSX)\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eVehicle TCO – routine \u0026amp; comparability\u003c\/td\u003e\n\n\u003ctd\u003eInternal routine for cost basis, calculation principles, roles, risks, and decision process.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eQuote comparison – purchase or lease\u003c\/td\u003e\n\n\u003ctd\u003eCompare purchase price, initial fee, monthly fee, service, and various contract terms.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eVehicle Decision \u0026amp; TCO protocol\u003c\/td\u003e\n\n\u003ctd\u003eFinancial decision basis with total sum, cost per km, risk assessment, and signature.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eVAT basis \u0026amp; residual value risk\u003c\/td\u003e\n\n\u003ctd\u003eCheck VAT assumptions, leasing terms, excess mileage, termination costs, and risks.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eVehicle TCO Comparison – English\u003c\/td\u003e\n\n\u003ctd\u003eEnglish comparison and decision form for Swedish businesses.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eDetailed user guide\u003c\/td\u003e\n\n\u003ctd\u003eFormula principles, practical examples, checkpoints, official sources, and English quick guide.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\n\u003c\/tbody\u003e\n\n\n\u003c\/table\u003e\n\n\u003cp\u003e\u003cstrong\u003eDelivery:\u003c\/strong\u003e 6 editable DOCX files, 6 searchable A4 PDF files, and 1 Excel workbook – a total of 13 files in a ZIP.\u003c\/p\u003e\n\n\u003ch2 id=\"mb-excel\"\u003eExcel template for vehicle cost and total cost of ownership (TCO)\u003c\/h2\u003e\n\n\u003cul\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eOverview:\u003c\/strong\u003e compare six cars side-by-side with total TCO in SEK, estimated SEK\/km, SEK\/month, and control status.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eOptions:\u003c\/strong\u003e purchase or lease with 1–7 years of usage time and individual cost assumptions.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eAnnual calculation:\u003c\/strong\u003e up to 42 vehicle years where initial amounts, operating costs, leasing fees, and final payments\/revenues are distributed over the years.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eVAT basis:\u003c\/strong\u003e separate register for documented VAT assessment, amount basis, and responsible reviewer.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eQuotes:\u003c\/strong\u003e register suppliers, contract periods, mileage, return terms, residual value risk, and quote references.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eControls:\u003c\/strong\u003e checklist of cost basis, insurance, service, mileage limits, excess mileage, and agreements.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eDecisions:\u003c\/strong\u003e document choices and justification as well as who has approved the acquisition.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eGuide:\u003c\/strong\u003e separate workflow with examples and official source references.\u003c\/li\u003e\n\n\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eThe TCO principle:\u003c\/strong\u003e for purchases, the purchase price and other expenses minus the estimated net sales revenue at the end of the calculation are counted; for leasing, items such as the first non-refundable fee, monthly payments, operation, any deposits, and termination costs are included. The formulas are used only when necessary inputs are provided and the status is marked as \u003cstrong\u003eREADY\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003caside style=\"background:#FFF1D7;padding:15px;margin:16px 0\"\u003e\u003cstrong\u003eImportant limitation:\u003c\/strong\u003e All vehicle costs must be entered on a manually controlled, comparable VAT and cost basis. The template does not automatically calculate VAT deductions, car benefits, employer contributions, corporate tax, accounting depreciation, or the tax classification of the lease. Amortization should not be added as an additional cost when the entire purchase price is already included. Costs are nominal and not discounted to present value. The model is not a complete TCO calculation for every conceivable special case.\u003c\/aside\u003e\n\u003ch2 id=\"mb-steg\"\u003eHow to use the calculator\u003c\/h2\u003e\n\n\u003col\u003e\n\n\u003cli\u003eObtain comparable quotes for the relevant vehicles. Check the vehicle's usage, contract length, and number of kilometers per year.\u003c\/li\u003e\n\n\u003cli\u003eOpen Excel and register up to six options in the \"Options\" tab; select Purchase or Leasing.\u003c\/li\u003e\n\n\u003cli\u003eEnter the purchase amount or the leasing's first fee\/monthly fee. Document any deposit, termination cost, and estimated residual value.\u003c\/li\u003e\n\n\u003cli\u003eFill in all seven annual cost fields for financing interest, energy, service, insurance, tax, tires, and other. Enter zero where costs are absent.\u003c\/li\u003e\n\n\u003cli\u003eCheck that the amounts have the correct VAT basis, avoid double-counting loan amortization, and use the status column as a data check.\u003c\/li\u003e\n\n\u003cli\u003eReview the cost per kilometer, average cost per month, and cash-flow-oriented annual calculation.\u003c\/li\u003e\n\n\u003cli\u003eDocument sensitivity to residual value, fuel\/electricity prices, and excess mileage, and make a separate authorized decision.\u003c\/li\u003e\n\n\n\u003c\/ol\u003e\n\n\u003ch2\u003eExample: buying or leasing a transport vehicle\u003c\/h2\u003e\n\n\u003cp\u003eAn illustrative purchase option with a price of 300,000 SEK, 5,000 SEK in initial additions, 62,000 SEK in annual costs over five years, and 130,000 SEK in estimated sales revenue results in a \u003cstrong\u003eTCO of 485,000 SEK\u003c\/strong\u003e. At 15,000 km per year, this becomes approximately \u003cstrong\u003e64.67 SEK\/km\u003c\/strong\u003e. A leasing option with a 20,000 SEK first fee, 6,000 SEK in monthly cost, 5,000 SEK in other start-up costs, 56,000 SEK in annual costs, and 10,000 SEK in termination costs results in a \u003cstrong\u003eTCO of 675,000 SEK\u003c\/strong\u003e, or \u003cstrong\u003e90 SEK\/km\u003c\/strong\u003e at the same mileage. The examples show the calculation method, not market prices.\u003c\/p\u003e\n\n\u003ch2 id=\"mb-juridik\"\u003eVAT on purchase and leasing – Swedish law 2026\u003c\/h2\u003e\n\n\u003cp\u003eAccording to the \u003cstrong\u003eSwedish Tax Agency\u003c\/strong\u003e, as a general rule, there is no right of deduction for input VAT when purchasing a passenger car, with exceptions for certain businesses. When renting\/leasing a passenger car for VAT-registered business activities, normally 50 percent of the VAT on the rental fee may be deducted when the conditions are met. An agreement called financial leasing can, under certain circumstances, be treated as a purchase for VAT purposes. Therefore, a general automatic 50-percent rule is inappropriate in this calculator.\u003c\/p\u003e\n\n\u003cp\u003eOfficial sources: \u003ca href=\"https:\/\/www.skatteverket.se\/foretag\/moms\/sarskildamomsregler\/bilarochmoms\"\u003eSkatteverket – Cars and VAT\u003c\/a\u003e · \u003ca href=\"https:\/\/www4.skatteverket.se\/rattsligvagledning\/edition\/2026.14\/407504.html\"\u003eSkatteverket – Purchase or rental of passenger car or motorcycle, 2026\u003c\/a\u003e.\u003c\/p\u003e\n\n\u003ch2 id=\"mb-faq\"\u003eFrequently asked questions\u003c\/h2\u003e\n\n\u003ch3\u003eWhat does TCO mean for a car?\u003c\/h3\u003e\n\n\u003cp\u003eTotal Cost of Ownership is the sum of the car's costs during a specific usage period, for example, acquisition or leasing, operation, financing interest, and disposal.\u003c\/p\u003e\n\n\u003ch3\u003eCan I compare purchase and leasing?\u003c\/h3\u003e\n\n\u003cp\u003eYes. Both models are available in the same Excel workbook. For a fair comparison, the period, mileage, and VAT and cost basis must be comparable.\u003c\/p\u003e\n\n\u003ch3\u003eCan Excel calculate the cost per kilometer?\u003c\/h3\u003e\n\n\u003cp\u003eYes. The model divides the total TCO by the number of kilometers during the calculation period when required information is provided.\u003c\/p\u003e\n\n\u003ch3\u003eIs leasing VAT automatically 50 percent deductible?\u003c\/h3\u003e\n\n\u003cp\u003eNo. The right to deduct depends on, among other things, the business, usage, and how the leasing agreement is assessed for VAT purposes. The template does not determine this.\u003c\/p\u003e\n\n\u003ch3\u003eDoes the model take residual value into account?\u003c\/h3\u003e\n\n\u003cp\u003eYes, for purchases. You enter a manually estimated sales value at the end of the calculation period. This is a forecast and should be checked separately.\u003c\/p\u003e\n\n\u003ch3\u003eAre fuel, charging, and insurance included?\u003c\/h3\u003e\n\n\u003cp\u003eYes, as individually editable annual cost items. They should be based on reasonable assumptions or documented quotes.\u003c\/p\u003e\n\n\u003ch3\u003eIs this a duplicate of Vehicle Register \u0026amp; Service Planning?\u003c\/h3\u003e\n\n\u003cp\u003eNo. \u003ca href=\"\/en\/search?q=Fordonsregister%20Serviceplanering\"\u003eVehicle Register \u0026amp; Service Planning\u003c\/a\u003e documents existing vehicles, service, and historical costs. This product compares economic acquisition alternatives ahead of decisions.\u003c\/p\u003e\n\n\u003ch3\u003eIs the template available in English?\u003c\/h3\u003e\n\n\u003cp\u003eYes, an English working form and an English quick guide are included. The main Swedish templates are based on Swedish conditions.\u003c\/p\u003e\n\n\u003ch3\u003eDo I need to buy special software?\u003c\/h3\u003e\n\n\u003cp\u003eYou need Word or a compatible word processing program for editing, and Excel or a compatible spreadsheet program for calculations. No subscription is included.\u003c\/p\u003e\n\n\u003ch2\u003eDigital delivery\u003c\/h2\u003e\n\n\u003cp\u003eVersion 1.0. 13 digital files in ZIP, no physical goods. Automatic customer delivery via Shopify assumes the ZIP file has actually been linked to the Digital Products variant.\u003c\/p\u003e\n\n\u003c\/section\u003e","brand":"Svenska Dokumentmallar","offers":[{"title":"Default Title","offer_id":55734954721622,"sku":"FORDON-TCO-KOP-LEASING-2027","price":79.0,"currency_code":"SEK","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0827\/2373\/3846\/files\/fordon_tco_2027_hero.png?v=1791919172","url":"https:\/\/mallbutiken.se\/en\/products\/bilkostnadskalkyl-fordons-tco-2026-2027-kopa-eller-leasa-bil-kostnad-per-mil-excel-word-pdf","provider":"Mallbutiken","version":"1.0","type":"link"}