{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["START","BUDGET TOOL"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"START","index":0,"n_rows":6,"n_cols":2,"rows_kept":6}
[null,"ABOUT THIS TEMPLATE"]
[null,"Track initial investment in website, its benefits, and costs using this website budgeting tool."]
[null,"Enter details in tables to auto-calculate totals and evaluation metrics."]
[null,"Note:  "]
[null,"Additional instructions have been provided in column A of BUDGET TOOL worksheet. This text has been intentionally hidden. To remove text, select column A, then select DELETE. To unhide text, select column A, then change the font colour."]
[null,"To learn more about tables in worksheet, press SHIFT and then F10 within a table, select the TABLE option, and then select ALTERNATIVE TEXT."]

{"sheet":"BUDGET TOOL","index":1,"n_rows":43,"n_cols":6,"rows_kept":43}
[]
[null,"Quadrex Hardware"]
[null,"WEBSITE BUDGETING TOOL"]
[null,"2022-12-01"]
[]
[null,"Company data","Rate"]
[null,"Required rate of return",{"v":0.1,"d":"10%"}]
[null,"Tax rate",{"v":0.3,"d":"30%"}]
[]
[null,"Initial investment in website","Year"]
[null,"Hardware (e.g., servers)",{"v":25000,"d":"£25,000.00"}]
[null,"Software (e.g., e-commerce catalogue software)",{"v":15000,"d":"£15,000.00"}]
[null,"Development (e.g., third-party site design and development)",{"v":150000,"d":"£150,000.00"}]
[null,"Total initial investments",{"$f":"SUBTOTAL(109,InitialInvest[Year])","v":{"v":190000,"d":"£190,000.00"}}]
[]
[null,"Benefits from website","Year 1","Year 2","Year 3"]
[null,"Direct sales",{"v":15000,"d":"£15,000.00"},{"v":50000,"d":"£50,000.00"},{"v":75000,"d":"£75,000.00"}]
[null,"Incremental sales resulting from enhanced promotional/salesperson effectiveness",{"v":25000,"d":"£25,000.00"},{"v":25000,"d":"£25,000.00"},{"v":25000,"d":"£25,000.00"}]
[null,"Incremental sales resulting from increased partner participation",{"v":25000,"d":"£25,000.00"},{"v":25000,"d":"£25,000.00"},{"v":25000,"d":"£25,000.00"}]
[null,"Reduced travel costs",{"v":25000,"d":"£25,000.00"},{"v":25000,"d":"£25,000.00"},{"v":25000,"d":"£25,000.00"}]
[null,"Reduced customer service costs",{"v":50000,"d":"£50,000.00"},{"v":50000,"d":"£50,000.00"},{"v":50000,"d":"£50,000.00"}]
[null,"Total benefits",{"$f":"SUBTOTAL(109,Benefits[Year 1])","v":{"v":140000,"d":"£140,000.00"}},{"$f":"SUBTOTAL(109,Benefits[Year 2])","v":{"v":175000,"d":"£175,000.00"}},{"$f":"SUBTOTAL(109,Benefits[Year 3])","v":{"v":200000,"d":"£200,000.00"}}]
[]
[null,"Costs (excluding initial capital investments)","YEAR 1","YEAR 2","YEAR 3"]
[null,"Cost of sales",{"v":7500,"d":"£7,500.00"},{"v":25000,"d":"£25,000.00"},{"v":37500,"d":"£37,500.00"}]
[null,"Maintenance",{"v":15000,"d":"£15,000.00"},{"v":15000,"d":"£15,000.00"},{"v":15000,"d":"£15,000.00"}]
[null,"Project management, customer support",{"v":35000,"d":"£35,000.00"},{"v":35000,"d":"£35,000.00"},{"v":35000,"d":"£35,000.00"}]
[null,"Online advertising, search-engine registration",{"v":10000,"d":"£10,000.00"},{"v":10000,"d":"£10,000.00"},{"v":10000,"d":"£10,000.00"}]
[null,"Depreciation on capital expenditures (calculation uses three-year period)",{"$f":"InitialInvest[[#Totals],[Year]]/3","v":{"v":63333.333333333336,"d":"£63,333.33"}},{"$f":"InitialInvest[[#Totals],[Year]]/3","v":{"v":63333.333333333336,"d":"£63,333.33"}},{"$f":"InitialInvest[[#Totals],[Year]]/3","v":{"v":63333.333333333336,"d":"£63,333.33"}}]
[null,"Total costs",{"$f":"SUBTOTAL(109,Costs[YEAR 1])","v":{"v":130833.33333333334,"d":"£130,833.33"}},{"$f":"SUBTOTAL(109,Costs[YEAR 2])","v":{"v":148333.33333333334,"d":"£148,333.33"}},{"$f":"SUBTOTAL(109,Costs[YEAR 3])","v":{"v":160833.33333333334,"d":"£160,833.33"}}]
[]
[null,"Totals"," ","Year 1","Year 2","Year 3"]
[null,"Net benefits (costs)",null,{"$f":"Benefits[[#Totals],[Year 1]]-Costs[[#Totals],[YEAR 1]]","v":{"v":9166.666666666657,"d":"£9,166.67"}},{"$f":"Benefits[[#Totals],[Year 2]]-Costs[[#Totals],[YEAR 2]]","v":{"v":26666.666666666657,"d":"£26,666.67"}},{"$f":"Benefits[[#Totals],[Year 3]]-Costs[[#Totals],[YEAR 3]]","v":{"v":39166.66666666666,"d":"£39,166.67"}}]
[null,"Tax",null,{"$f":"D33*TaxRate","v":{"v":2749.999999999997,"d":"£2,750.00"}},{"$f":"E33*TaxRate","v":{"v":7999.999999999996,"d":"£8,000.00"}},{"$f":"F33*TaxRate","v":{"v":11749.999999999996,"d":"£11,750.00"}}]
[null,"Value after tax",null,{"$f":"D33-D34","v":{"v":6416.666666666661,"d":"£6,416.67"}},{"v":18666.66666666666,"d":"£18,666.67"},{"v":27416.66666666666,"d":"£27,416.67"}]
[null,"Depreciation added back",null,{"$f":"C29","v":{"v":63333.333333333336,"d":"£63,333.33"}},{"$f":"D29","v":{"v":63333.333333333336,"d":"£63,333.33"}},{"$f":"E29","v":{"v":63333.333333333336,"d":"£63,333.33"}}]
[null,"Cash flow",{"$f":"-InitialInvest[[#Totals],[Year]]","v":{"v":-190000,"d":"-£190,000.00"}},{"$f":"D35+D36","v":{"v":69750,"d":"£69,750.00"}},{"$f":"E35+E36","v":{"v":82000,"d":"£82,000.00"}},{"$f":"F35+F36","v":{"v":90750,"d":"£90,750.00"}}]
[null,"Cumulative cash flow",{"$f":"C37","v":{"v":-190000,"d":"-£190,000.00"}},{"$f":"C38+D37","v":{"v":-120250,"d":"-£120,250.00"}},{"v":-38250,"d":"-£38,250.00"},{"v":52500,"d":"£52,500.00"}]
[]
[null,"Evaluation metrics","Values"]
[null,"Net present value (NPV)",{"$f":"C37+(NPV(ROR,D37:F37))","v":{"v":9359.504132231377,"d":"£9,359.50"}}]
[null,"Internal rate of return (IRR)",{"$f":"IRR(C37:F37)","v":{"v":0.12655165144706393,"d":"12.66%"}}]
[null,"Payback period (in years)",{"$f":"IF(F38<=0,\"Exceeds three years\",IF(E38<=0,(F37-F38)/F37+2,IF(D38<=0,(E37-E38)/E37+1,IF(C38<=0,(D37-D38)/D37,\"NA\"))))","v":{"v":2.4214876033057853,"d":"2.42"}}]