{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Web Site Budgeting Tool"],"not_rendered":{"external_links":1,"defined_names":6},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Web Site Budgeting Tool","index":0,"n_rows":58,"n_cols":5,"rows_kept":58,"merged":[[9,1,9,4]],"flags":["formulas_cached_only"]}
["[Company Name]"]
["Web Site Budgeting Tool"]
["[Date]"]
[]
["Gray cells contain calculations that should not be altered."]
["Company Data"]
["Required rate of return",{"v":0.1,"d":"10.0%"}]
["Tax rate",{"v":0.3,"d":"30.0%"}]
[]
[null,"YEAR"]
[null,0,1,2,3]
["Initial Investment in Web Site"]
["Hardware (e.g., servers)",{"v":25000,"d":"$25,000"}]
["Software (e.g., e-commerce catalog software)",{"v":15000,"d":"15,000 "}]
["Development (e.g., third-party site design and development)",{"v":150000,"d":"150,000 "}]
[]
["Total Initial Investments",{"v":190000,"d":"$190,000"}]
[]
[]
["Benefits from Web Site"]
["Direct sales",null,{"v":15000,"d":"$15,000"},{"v":50000,"d":"$50,000"},{"v":75000,"d":"$75,000"}]
["Incremental sales resulting from enhanced promotional/salesperson effectiveness",null,{"v":25000,"d":"25,000 "},{"v":25000,"d":"25,000 "},{"v":25000,"d":"25,000 "}]
["Incremental sales resulting from increased partner participation",null,{"v":25000,"d":"25,000 "},{"v":25000,"d":"25,000 "},{"v":25000,"d":"25,000 "}]
["Reduced travel costs",null,{"v":25000,"d":"25,000 "},{"v":25000,"d":"25,000 "},{"v":25000,"d":"25,000 "}]
["Reduced customer service costs",null,{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "}]
["Reduced printing and shipping costs",null,{"v":5000,"d":"5,000 "},{"v":5000,"d":"5,000 "},{"v":5000,"d":"5,000 "}]
["[Other benefits]",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
["[Other benefits]",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
["[Other benefits]",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[]
["Total Benefits",null,{"v":145000,"d":"$145,000"},{"v":180000,"d":"$180,000"},{"v":205000,"d":"$205,000"}]
[]
[]
["Costs (Excluding Initial Capital Investments)"]
["Cost of sales",null,{"v":7500,"d":"$7,500"},{"v":25000,"d":"$25,000"},{"v":37500,"d":"$37,500"}]
["Maintenance",null,{"v":15000,"d":"15,000 "},{"v":15000,"d":"15,000 "},{"v":15000,"d":"15,000 "}]
["Project management, customer support",null,{"v":35000,"d":"35,000 "},{"v":35000,"d":"35,000 "},{"v":35000,"d":"35,000 "}]
["Online advertising, search-engine registration",null,{"v":10000,"d":"10,000 "},{"v":10000,"d":"10,000 "},{"v":10000,"d":"10,000 "}]
["Depreciation on capital expenditures (calculation uses three-year period)",null,{"v":63333.333333333336,"d":"63,333 "},{"v":63333.333333333336,"d":"63,333 "},{"v":63333.333333333336,"d":"63,333 "}]
["Hosting, domain-name registration",null,{"v":150,"d":"150 "},{"v":150,"d":"150 "},{"v":150,"d":"150 "}]
["General and administrative (e.g., rent, insurance, exec. salaries)",null,{"v":10000,"d":"10,000 "},{"v":10000,"d":"10,000 "},{"v":10000,"d":"10,000 "}]
["[Other costs]",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
["[Other costs]",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
["[Other costs]",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[]
["Total Costs",null,{"v":140983.33333333334,"d":"$140,983"},{"v":158483.33333333334,"d":"$158,483"},{"v":170983.33333333334,"d":"$170,983"}]
[]
["Net Benefits (Costs)",null,{"v":4016.666666666657,"d":"$4,017"},{"v":21516.666666666657,"d":"$21,517"},{"v":34016.66666666666,"d":"$34,017"}]
["Tax",null,{"v":1204.999999999997,"d":"1,205 "},{"v":6454.999999999997,"d":"6,455 "},{"v":10204.999999999996,"d":"10,205 "}]
["Value after tax",null,{"v":2811.6666666666597,"d":"2,812 "},{"v":15061.66666666666,"d":"15,062 "},{"v":23811.66666666666,"d":"23,812 "}]
["Depreciation added back",null,{"v":63333.333333333336,"d":"63,333 "},{"v":63333.333333333336,"d":"63,333 "},{"v":63333.333333333336,"d":"63,333 "}]
["Cash flow",{"v":-190000,"d":"($190,000)"},{"v":66145,"d":"$66,145"},{"v":78395,"d":"$78,395"},{"v":87145,"d":"$87,145"}]
["Cumulative cash flow",{"v":-190000,"d":"($190,000)"},{"v":-123855,"d":"($123,855)"},{"v":-45460,"d":"($45,460)"},{"v":41685,"d":"$41,685"}]
[]
["Evaluation Metrics"]
["Net present value (NPV)",{"v":394.40270473327837,"d":"$394"}]
["Internal rate of return (IRR)",{"v":0.101125493839836,"d":"10.1%"}]
["Payback period (in years)",{"v":2.521659303459751,"d":"2.52"}]