{"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":7,"n_cols":2,"rows_kept":7}
[null,"ABOUT THIS TEMPLATE"]
[null,"Track Initial Investment in Website, its Benefits and Costs using this Website Budgeting Tool."]
[null,"Fill in Company Name and Date."]
[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 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,"merged":[[14,1,14,5],[22,1,22,5],[30,1,30,5],[38,1,38,5]]}
["Create Website Budget in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started."]
["Enter Company Name in cell to the right.","Company Name"]
["Title of this worksheet is in cell to the right.","Website Budgeting Tool"]
["Enter Date in cell to the right.","Date"]
["Tip is in cell to the right.","Grey cells contain calculations that should not be altered."]
["Enter details in Rate table starting in cell to the right. Next instruction is in cell A10.","Company data","Rate"]
[null,"Required rate of return",{"v":0.1,"d":"10%"}]
[null,"Tax rate",{"v":0.3,"d":"30%"}]
[]
["Enter details in Initial Invest table starting in cell to the right. Next instruction is in cell A16.","Initial Investment in Website","YEAR","1","2","3"]
[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"}}]
[]
["Enter details in Benefits table starting in cell to the right. Next instruction is in cell A24.","Benefits from website","YEAR","1","2","3"]
[null,"Direct sales",null,{"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",null,{"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",null,{"v":25000,"d":"£25,000.00"},{"v":25000,"d":"£25,000.00"},{"v":25000,"d":"£25,000.00"}]
[null,"Reduced travel costs",null,{"v":25000,"d":"£25,000.00"},{"v":25000,"d":"£25,000.00"},{"v":25000,"d":"£25,000.00"}]
[null,"Reduced customer service costs",null,{"v":50000,"d":"£50,000.00"},{"v":50000,"d":"£50,000.00"},{"v":50000,"d":"£50,000.00"}]
[null,"Total Benefits",null,{"$f":"SUBTOTAL(109,Benefits[1])","v":{"v":140000,"d":"£140,000.00"}},{"$f":"SUBTOTAL(109,Benefits[2])","v":{"v":175000,"d":"£175,000.00"}},{"$f":"SUBTOTAL(109,Benefits[3])","v":{"v":200000,"d":"£200,000.00"}}]
[]
["Enter details in Costs table starting in cell to the right. Values are auto-calculated in cells containing formulas. Next instruction is in cell A32.","Costs (excluding Initial Capital Investments)","YEAR","1","2","3"]
[null,"Cost of sales",null,{"v":7500,"d":"£7,500.00"},{"v":25000,"d":"£25,000.00"},{"v":37500,"d":"£37,500.00"}]
[null,"Maintenance",null,{"v":15000,"d":"£15,000.00"},{"v":15000,"d":"£15,000.00"},{"v":15000,"d":"£15,000.00"}]
[null,"Project management, customer support",null,{"v":35000,"d":"£35,000.00"},{"v":35000,"d":"£35,000.00"},{"v":35000,"d":"£35,000.00"}]
[null,"Online advertising, search-engine registration",null,{"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)",null,{"$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",null,{"$f":"SUBTOTAL(109,Costs[1])","v":{"v":130833.33333333334,"d":"£130,833.33"}},{"$f":"SUBTOTAL(109,Costs[2])","v":{"v":148333.33333333334,"d":"£148,333.33"}},{"$f":"SUBTOTAL(109,Costs[3])","v":{"v":160833.33333333334,"d":"£160,833.33"}}]
[]
["Values are auto-calculated in Totals table starting in cell to the right. Next instruction is in cell A40.","Totals","YEAR","1","2","3"]
[null,"Net Benefits (Costs)",null,{"$f":"Benefits[[#Totals],[1]]-Costs[[#Totals],[1]]","v":{"v":9166.666666666657,"d":"£9,166.67"}},{"$f":"Benefits[[#Totals],[2]]-Costs[[#Totals],[2]]","v":{"v":26666.666666666657,"d":"£26,666.67"}},{"$f":"Benefits[[#Totals],[3]]-Costs[[#Totals],[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":"D29","v":{"v":63333.333333333336,"d":"£63,333.33"}},{"$f":"E29","v":{"v":63333.333333333336,"d":"£63,333.33"}},{"$f":"F29","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"}},{"v":82000,"d":"£82,000.00"},{"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"}]
[]
["Evaluation Metrics are auto-calculated in Metrics table starting in cell to the right.","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"}}]