| [Company Name] |
|
|
|
|
| Web Site Budgeting Tool |
|
|
|
|
| [Date] |
|
|
|
|
| |
|
|
|
|
| Gray cells contain calculations that should not be altered. |
|
|
|
|
| Company Data |
|
|
|
|
| Required rate of return |
|
|
|
|
| Tax rate |
|
|
|
|
| |
|
|
|
|
| |
YEAR |
| |
0 |
1 |
2 |
3 |
| Initial Investment in Web Site |
|
|
|
|
| Hardware (e.g., servers) |
|
|
|
|
| Software (e.g., e-commerce catalog software) |
|
|
|
|
| Development (e.g., third-party site design and development) |
|
|
|
|
| |
|
|
|
|
| Total Initial Investments |
$0 |
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| Benefits from Web Site |
|
|
|
|
| Direct sales |
|
|
|
|
| Incremental sales resulting from enhanced promotional/salesperson effectiveness |
|
|
|
|
| Incremental sales resulting from increased partner participation |
|
|
|
|
| Reduced travel costs |
|
|
|
|
| Reduced customer service costs |
|
|
|
|
| Reduced printing and shipping costs |
|
|
|
|
| [Other benefits] |
|
|
|
|
| [Other benefits] |
|
|
|
|
| [Other benefits] |
|
0 |
0 |
0 |
| |
|
|
|
|
| Total Benefits |
|
$0 |
$0 |
$0 |
| |
|
|
|
|
| |
|
|
|
|
| Costs (Excluding Initial Capital Investments) |
|
|
|
|
| Cost of sales |
|
|
|
|
| Maintenance |
|
|
|
|
| Project management, customer support |
|
|
|
|
| Online advertising, search-engine registration |
|
|
|
|
| Depreciation on capital expenditures (calculation uses three-year period) |
|
0 |
0 |
0 |
| Hosting, domain-name registration |
|
|
|
|
| General and administrative (e.g., rent, insurance, exec. salaries) |
|
|
|
|
| [Other costs] |
|
|
|
|
| [Other costs] |
|
|
|
|
| [Other costs] |
|
|
|
|
| |
|
|
|
|
| Total Costs |
|
$0 |
$0 |
$0 |
| |
|
|
|
|
| Net Benefits (Costs) |
|
$0 |
$0 |
$0 |
| Tax |
|
0 |
0 |
0 |
| Value after tax |
|
0 |
0 |
0 |
| Depreciation added back |
|
0 |
0 |
0 |
| Cash flow |
$0 |
$0 |
$0 |
$0 |
| Cumulative cash flow |
$0 |
$0 |
$0 |
$0 |
| |
|
|
|
|
