Website Budgeting Tool
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Website Budgeting Tool as PDF for free.
More details
- Words: 258
- Pages: 4
[Company Name] Web Site Budgeting Tool [Date] Gray cells contain calculations that should not be altered.
Company Data Required rate of return
10.0%
Tax rate
30.0%
0 Initial Investment in Web Site Hardware (e.g., servers)
$25,000
Software (e.g., e-commerce catalog software)
15,000
Development (e.g., third-party site design and development)
150,000 Total Initial Investments
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] Total Benefits
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) Hosting, domain-name registration General and administrative (e.g., rent, insurance, exec. salaries) [Other costs]
$190,000
[Other costs] [Other costs] Total Costs Net Benefits (Costs) Tax Value after tax Depreciation added back Cash flow Cumulative cash flow Evaluation Metrics Net present value (NPV) Internal rate of return (IRR) Payback period (in years)
($190,000) ($190,000)
$394 10.1% 2.52
YEAR 1
2
3
$15,000
$50,000
$75,000
25,000
25,000
25,000
25,000
25,000
25,000
25,000
25,000
25,000
50,000
50,000
50,000
5,000
5,000
5,000
0
0
0
0
0
0
0
0
0
$145,000
$180,000
$205,000
$7,500 15,000 35,000 10,000 63,333 150 10,000 0
$25,000 15,000 35,000 10,000 63,333 150 10,000 0
$37,500 15,000 35,000 10,000 63,333 150 10,000 0
0 0
0 0
0 0
$140,983
$158,483
$170,983
$4,017 1,205 2,812 63,333 $66,145 ($123,855)
$21,517 6,455 15,062 63,333 $78,395 ($45,460)
$34,017 10,205 23,812 63,333 $87,145 $41,685
Company Data Required rate of return
10.0%
Tax rate
30.0%
0 Initial Investment in Web Site Hardware (e.g., servers)
$25,000
Software (e.g., e-commerce catalog software)
15,000
Development (e.g., third-party site design and development)
150,000 Total Initial Investments
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] Total Benefits
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) Hosting, domain-name registration General and administrative (e.g., rent, insurance, exec. salaries) [Other costs]
$190,000
[Other costs] [Other costs] Total Costs Net Benefits (Costs) Tax Value after tax Depreciation added back Cash flow Cumulative cash flow Evaluation Metrics Net present value (NPV) Internal rate of return (IRR) Payback period (in years)
($190,000) ($190,000)
$394 10.1% 2.52
YEAR 1
2
3
$15,000
$50,000
$75,000
25,000
25,000
25,000
25,000
25,000
25,000
25,000
25,000
25,000
50,000
50,000
50,000
5,000
5,000
5,000
0
0
0
0
0
0
0
0
0
$145,000
$180,000
$205,000
$7,500 15,000 35,000 10,000 63,333 150 10,000 0
$25,000 15,000 35,000 10,000 63,333 150 10,000 0
$37,500 15,000 35,000 10,000 63,333 150 10,000 0
0 0
0 0
0 0
$140,983
$158,483
$170,983
$4,017 1,205 2,812 63,333 $66,145 ($123,855)
$21,517 6,455 15,062 63,333 $78,395 ($45,460)
$34,017 10,205 23,812 63,333 $87,145 $41,685
Related Documents
Website Budgeting Tool
November 2019 5
Budgeting
April 2020 21
Budgeting
December 2019 35
Budgeting As A Tool Of Control
June 2020 22
Budgeting & Budgeting Control
December 2019 29