{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Capital Budgeting Template"],"read":"whole","date_system":"1900"}

{"sheet":"Capital Budgeting Template","index":0,"n_rows":46,"n_cols":8,"rows_kept":46}
["<insert date>"]
["<Company Name>"]
[]
["ROI CALCULATOR"]
[]
["Year","Costs","Cumulative Costs","Benefits","Cumulative Benefits",null,null,"ROI measures"]
[{"$nulls":7},"Cost of capital"]
[{"$nulls":7},"Net present value"]
[{"$nulls":7},"Return on investment"]
[{"$nulls":7},"Payback in years"]
[]
[]
["EQUITY ANALYSIS"]
[]
["Initial investment","Value","Discount rate","Value"]
["Investment",null,"Discount rate"]
["minus Tax credit",null,"Beta"]
["Net investment",null,"Riskless rate"]
["plus Working capital",null,"Market risk premium"]
["Opportunity cost",null,"Debt ratio"]
["Cashflow details",null,"Cost of borrowing"]
["Revenues in year 1",null,"Discount rate used"]
["Var.expenses as % of Revenue",null,"Working capital"]
["Fixed expenses in year 1",null,"Investment"]
["Tax rate on net income",null,"minus Tax credit"]
[null,null,"Net investment"]
[null,null,"plus Working capital"]
[null,null,"Opportunity cost"]
[]
[]
[]
[]
[null,"Year One","Year Two","Year Three"]
["Total costs"]
["Annual benefit flow"]
["Cumulative benefit flow"]
["Discounted costs"]
["Discounted benefits"]
["Total dicosounted benefit flow"]
["Total cumulative benefit flow"]
["Initial investment"]
["Implementation costs"]
["Ongoing support costs"]
["Training costs"]
["Other costs"]
["Total costs"]