{"text_format":"1","workbook":"xls","n_sheets":1,"sheets":["Web Site Budgeting Tool"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Web Site Budgeting Tool","index":0,"n_rows":58,"n_cols":5,"rows_kept":58,"cut":false,"hidden":false,"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",0.1]
["Tax rate",0.3]
[]
[null,"YEAR"]
[null,0,1,2,3]
["Initial Investment in Web Site"]
["Hardware (e.g., servers)",25000]
["Software (e.g., e-commerce catalog software)",15000]
["Development (e.g., third-party site design and development)",150000]
[]
["Total Initial Investments",190000]
[]
[]
["Benefits from Web Site"]
["Direct sales",null,15000,50000,75000]
["Incremental sales resulting from enhanced promotional/salesperson effectiveness",null,25000,25000,25000]
["Incremental sales resulting from increased partner participation",null,25000,25000,25000]
["Reduced travel costs",null,25000,25000,25000]
["Reduced customer service costs",null,50000,50000,50000]
["Reduced printing and shipping costs",null,5000,5000,5000]
["[Other benefits]",null,0,0,0]
["[Other benefits]",null,0,0,0]
["[Other benefits]",null,0,0,0]
[]
["Total Benefits",null,145000,180000,205000]
[]
[]
["Costs (Excluding Initial Capital Investments)"]
["Cost of sales",null,7500,25000,37500]
["Maintenance",null,15000,15000,15000]
["Project management, customer support",null,35000,35000,35000]
["Online advertising, search-engine registration",null,10000,10000,10000]
["Depreciation on capital expenditures (calculation uses three-year period)",null,63333.333333333336,63333.333333333336,63333.333333333336]
["Hosting, domain-name registration",null,150,150,150]
["General and administrative (e.g., rent, insurance, exec. salaries)",null,10000,10000,10000]
["[Other costs]",null,0,0,0]
["[Other costs]",null,0,0,0]
["[Other costs]",null,0,0,0]
[]
["Total Costs",null,140983.33333333334,158483.33333333334,170983.33333333334]
[]
["Net Benefits (Costs)",null,4016.666666666657,21516.666666666657,34016.66666666666]
["Tax",null,1204.999999999997,6454.999999999997,10204.999999999996]
["Value after tax",null,2811.6666666666597,15061.66666666666,23811.66666666666]
["Depreciation added back",null,63333.333333333336,63333.333333333336,63333.333333333336]
["Cash flow",-190000,66145,78395,87145]
["Cumulative cash flow",-190000,-123855,-45460,41685]
[]
["Evaluation Metrics"]
["Net present value (NPV)",394.40270473327837]
["Internal rate of return (IRR)",0.101125493839836]
["Payback period (in years)",2.521659303459751]