{"product_id":"investeringskalkyl-npv-irr-payback-2026-2027","title":"Investment Calculation 2026\/2027 – NPV, IRR, Payback \u0026 Scenario | Swedish + English Excel, Word \u0026 PDF","description":"\u003cdiv class=\"mb-product\" lang=\"en\"\u003e\n\n\u003cp\u003e\u003cstrong\u003eAssess the profitability of an investment before capital is tied up.\u003c\/strong\u003e This complete template package helps companies analyze machinery, equipment, software, automation, energy measures, and expansion projects using \u003cstrong\u003eNPV\/Net Present Value, IRR\/Internal Rate of Return, payback, discounted payback, profitability index, scenarios, and sensitivity analysis\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003cdiv style=\"background:#e7f6ed;border-left:4px solid #29865a;padding:14px 18px;margin:18px 0;border-radius:6px\"\u003e\n\n\u003cstrong\u003eReviewed October 8, 2026.\u003c\/strong\u003e The calculation is a general decision support tool. Discount rate, tax, financing, working capital, and residual value must be adjusted to the specific investment.\u003c\/div\u003e\n\n\n\u003ch2\u003eWhat is included\u003c\/h2\u003e\n\n\u003ctable\u003e\n\n\u003cthead\u003e\u003ctr\u003e\n\n\u003cth\u003eDocument\u003c\/th\u003e\n\n\u003cth\u003eFormat\u003c\/th\u003e\n\n\u003cth\u003eContent\u003c\/th\u003e\n\n\n\u003c\/tr\u003e\u003c\/thead\u003e\n\n\u003ctbody\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eInvestment Appraisal – Swedish\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\u003ctd\u003eDecision template with cash flows, NPV, IRR, payback, risk, and decision\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eInvestment Appraisal – English\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\u003ctd\u003eEnglish reference\/work version for Swedish businesses\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eUser Guide – Swedish\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\u003ctd\u003eExplanations, workflow, and common errors\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eUser Guide – English\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\u003ctd\u003eEnglish step-by-step guide\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eInvestment Tool\u003c\/td\u003e\n\n\u003ctd\u003eExcel\u003c\/td\u003e\n\n\u003ctd\u003eUp to 20 years, NPV, IRR, payback, scenario, sensitivity, and dashboard\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\n\u003c\/tbody\u003e\n\n\n\u003c\/table\u003e\n\n\n\u003ch2\u003eThe Excel tool\u003c\/h2\u003e\n\n\u003cul\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eUp to 20 years of cash flows\u003c\/strong\u003e including receipts, operating payments, working capital, and other investment flows.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eNPV\/Net Present Value\u003c\/strong\u003e based on the user's own discount rate.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eIRR\/Internal Rate of Return\u003c\/strong\u003e as a supplementary measure of return.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003ePayback and discounted payback\u003c\/strong\u003e.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eProfitability index\u003c\/strong\u003e for relative assessment.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eDownside\/Base\/Upside\u003c\/strong\u003e with separate factors for revenue, costs, investment, discount rate, and residual value.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eSensitivity analysis\u003c\/strong\u003e showing how NPV changes when the discount rate is adjusted.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eDecision tab\u003c\/strong\u003e for financing, liquidity, and non-financial decision factors.\u003c\/li\u003e\n\n\n\u003c\/ul\u003e\n\n\n\u003ch2\u003eHow to use the template\u003c\/h2\u003e\n\n\u003col\u003e\n\n\u003cli\u003eEnter the initial investment, economic life, discount rate, and any residual value.\u003c\/li\u003e\n\n\u003cli\u003eFill in the investment's annual \u003cstrong\u003eincremental cash flows\u003c\/strong\u003e.\u003c\/li\u003e\n\n\u003cli\u003eRegister changes in working capital as the project ties up or releases capital.\u003c\/li\u003e\n\n\u003cli\u003eReview NPV, IRR, payback, and profitability index on the dashboard.\u003c\/li\u003e\n\n\u003cli\u003eTest downside\/upside and sensitivity to the discount rate.\u003c\/li\u003e\n\n\u003cli\u003eAnalyze financing and liquidity separately before the final decision.\u003c\/li\u003e\n\n\n\u003c\/ol\u003e\n\n\n\u003ch2\u003eKey principles\u003c\/h2\u003e\n\n\u003cp\u003eThe investment calculation is based on \u003cstrong\u003ecash flows\u003c\/strong\u003e, not accounting depreciation. Depreciation is therefore not a separate cash outflow in the basic calculation. A positive change in working capital is treated as tied-up capital. Residual value should only be used when there is a reasonable basis for it.\u003c\/p\u003e\n\n\u003cp\u003eA project may show a positive NPV but still create a financing or liquidity problem. Therefore, the investment calculation should be supplemented with a liquidity budget and financing plan. No general discount rate, tax rate, or tax depreciation is hard-coded.\u003c\/p\u003e\n\n\n\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\n\n\u003ch3\u003eWhat does a positive NPV mean?\u003c\/h3\u003e\n\n\u003cp\u003eThat the discounted future net cash flows, according to the calculation's assumptions, exceed the initial investment at the chosen discount rate.\u003c\/p\u003e\n\n\u003ch3\u003eIs IRR the same as profitability?\u003c\/h3\u003e\n\n\u003cp\u003eIRR is a supplementary measure of return. For complex cash flows and comparisons between projects, NPV should normally be used as the primary measure.\u003c\/p\u003e\n\n\u003ch3\u003eWhat is the difference between payback and discounted payback?\u003c\/h3\u003e\n\n\u003cp\u003eStandard payback uses undiscounted cash flows. Discounted payback accounts for the time value of money through the chosen discount rate.\u003c\/p\u003e\n\n\u003ch3\u003eCan I change the discount rate?\u003c\/h3\u003e\n\n\u003cp\u003eYes. The discount rate is a user-defined input, and the sensitivity tab shows how NPV is affected by other interest rate levels.\u003c\/p\u003e\n\n\u003ch3\u003eCan I use the template for a machine investment?\u003c\/h3\u003e\n\n\u003cp\u003eYes, as well as for software, automation, energy investments, capacity increases, premises, and other projects with identifiable future cash flows.\u003c\/p\u003e\n\n\n\u003ch2\u003eFormat and delivery\u003c\/h2\u003e\n\n\u003cp\u003e\u003cstrong\u003eFormat:\u003c\/strong\u003e DOCX, PDF, and XLSX. \u003cstrong\u003eLanguage:\u003c\/strong\u003e Swedish + English. \u003cstrong\u003eVersion:\u003c\/strong\u003e 1.0. \u003cstrong\u003eReviewed:\u003c\/strong\u003e 2026-10-08. Delivered digitally when the ZIP file is linked to the product in Shopify Digital Products.\u003c\/p\u003e\n\n\u003cp\u003e\u003cstrong\u003eSources:\u003c\/strong\u003e Almi's current financing guidance 2026 and Verksamt.se's guidance on financing, capital requirements, and business loans.\u003c\/p\u003e\n\n\n\u003c\/div\u003e","brand":"Svenska Dokumentmallar","offers":[{"title":"Default Title","offer_id":55642797211990,"sku":"INVESTERINGSKALKYL-2026-2027","price":79.0,"currency_code":"SEK","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0827\/2373\/3846\/files\/01_investeringskalkyl_npv_irr_payback_hero.png?v=1791414450","url":"https:\/\/mallbutiken.se\/en\/products\/investeringskalkyl-npv-irr-payback-2026-2027","provider":"Mallbutiken","version":"1.0","type":"link"}