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

{"sheet":"BUDGET TOOL","index":0,"n_rows":53,"n_cols":6,"rows_kept":53,"merged":[[15,1,15,5],[27,1,27,5],[40,1,40,5],[48,1,48,5]]}
[]
[null,"[Company Name]"]
[null,"Web Site Budgeting Tool"]
[null,"[Date]"]
[]
[null,"Gray cells contain calculations that should not be altered."]
[null,"Company Data"]
[null,"Required rate of return",{"v":0.1,"d":"10%"}]
[null,"Tax rate",{"v":0.3,"d":"30%"}]
[]
[null,"Initial Investment in Web Site","YEAR","1","2","3"]
[null,"Hardware (e.g., servers)",{"v":25000,"d":"$25,000.00"}]
[null,"Software (e.g., e-commerce catalog 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,tblInitialInvest[YEAR])","v":{"v":190000,"d":"$190,000.00"}}]
[]
[null,"Benefits from Web Site","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,"Reduced printing and shipping costs",null,{"v":5000,"d":"$5,000.00"},{"v":5000,"d":"$5,000.00"},{"v":5000,"d":"$5,000.00"}]
[null,"[Other benefits]",null,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,"[Other benefits]",null,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,"[Other benefits]",null,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,"Total Benefits",null,{"$f":"SUBTOTAL(109,tblBenefits[1])","v":{"v":145000,"d":"$145,000.00"}},{"$f":"SUBTOTAL(109,tblBenefits[2])","v":{"v":180000,"d":"$180,000.00"}},{"$f":"SUBTOTAL(109,tblBenefits[3])","v":{"v":205000,"d":"$205,000.00"}}]
[]
[null,"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":"tblInitialInvest[[#Totals],[YEAR]]/3","v":{"v":63333.333333333336,"d":"$63,333.33"}},{"$f":"tblInitialInvest[[#Totals],[YEAR]]/3","v":{"v":63333.333333333336,"d":"$63,333.33"}},{"$f":"tblInitialInvest[[#Totals],[YEAR]]/3","v":{"v":63333.333333333336,"d":"$63,333.33"}}]
[null,"Hosting, domain-name registration",null,{"v":150,"d":"$150.00"},{"v":150,"d":"$150.00"},{"v":150,"d":"$150.00"}]
[null,"General and administrative (e.g., rent, insurance, exec. salaries)",null,{"v":10000,"d":"$10,000.00"},{"v":10000,"d":"$10,000.00"},{"v":10000,"d":"$10,000.00"}]
[null,"[Other costs]",null,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,"[Other costs]",null,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,"[Other costs]",null,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,"Total Costs",null,{"$f":"SUBTOTAL(109,tblCosts[1])","v":{"v":140983.33333333334,"d":"$140,983.33"}},{"$f":"SUBTOTAL(109,tblCosts[2])","v":{"v":158483.33333333334,"d":"$158,483.33"}},{"$f":"SUBTOTAL(109,tblCosts[3])","v":{"v":170983.33333333334,"d":"$170,983.33"}}]
[]
[null,"Totals","YEAR","1","2","3"]
[null,"Net Benefits (Costs)",null,{"$f":"tblBenefits[[#Totals],[1]]-tblCosts[[#Totals],[1]]","v":{"v":4016.666666666657,"d":"$4,016.67"}},{"$f":"tblBenefits[[#Totals],[2]]-tblCosts[[#Totals],[2]]","v":{"v":21516.666666666657,"d":"$21,516.67"}},{"$f":"tblBenefits[[#Totals],[3]]-tblCosts[[#Totals],[3]]","v":{"v":34016.66666666666,"d":"$34,016.67"}}]
[null,"Tax",null,{"$f":"D43*TaxRate","v":{"v":1204.999999999997,"d":"$1,205.00"}},{"$f":"E43*TaxRate","v":{"v":6454.999999999997,"d":"$6,455.00"}},{"$f":"F43*TaxRate","v":{"v":10204.999999999996,"d":"$10,205.00"}}]
[null,"Value after tax",null,{"$f":"D43-D44","v":{"v":2811.6666666666597,"d":"$2,811.67"}},{"v":15061.66666666666,"d":"$15,061.67"},{"v":23811.66666666666,"d":"$23,811.67"}]
[null,"Depreciation added back",null,{"$f":"D34","v":{"v":63333.333333333336,"d":"$63,333.33"}},{"v":63333.333333333336,"d":"$63,333.33"},{"v":63333.333333333336,"d":"$63,333.33"}]
[null,"Cash flow",{"$f":"-tblInitialInvest[[#Totals],[YEAR]]","v":{"v":-190000,"d":"-$190,000.00"}},{"$f":"D45+D46","v":{"v":66145,"d":"$66,145.00"}},{"v":78395,"d":"$78,395.00"},{"v":87145,"d":"$87,145.00"}]
[null,"Cumulative cash flow",{"$f":"C47","v":{"v":-190000,"d":"-$190,000.00"}},{"$f":"C48+D47","v":{"v":-123855,"d":"($123,855.00)"}},{"v":-45460,"d":"($45,460.00)"},{"v":41685,"d":"$41,685.00"}]
[]
[null,"Evaluation Metrics"," "]
[null,"Net present value (NPV)",{"$f":"C47+(NPV(ROR,D47:F47))","v":{"v":394.40270473327837,"d":"$394.40"}}]
[null,"Internal rate of return (IRR)",{"$f":"IRR(C47:F47)","v":{"v":0.1011254938398336,"d":"10.11%"}}]
[null,"Payback period (in years)",{"$f":"IF(F48<=0,\"Exceeds 3 years\",IF(E48<=0,(F47-F48)/F47+2,IF(D48<=0,(E47-E48)/E47+1,IF(C48<=0,(D47-D48)/D47,\"NA\"))))","v":{"v":2.521659303459751,"d":"2.52"}}]