ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
STARTUP WEBSITE BUDGET TOOL TEMPLATE
https://bit.ly/3lcPIuI
3
RATE OF RETURN REQUIRED12.50%TAX RATE31.75%
4
5
YEAR
6
CATEGORY0123
7
INITIAL INVESTMENT $ 84,000
8
Development $ 26,000
9
Hardware $ 46,000
10
Software $ 12,000
11
12
13
14
ADDITIONAL COSTS $ 151,000 $ 137,000 $ 141,000
15
Project Management $ 56,000 $ 32,000 $ 26,000
16
Customer Support $ 50,000 $ 60,000 $ 70,000
17
Site Maintenance $ 45,000 $ 45,000 $ 45,000
18
Cost of Sales
19
SEO
20
Advertising
21
Domain
22
Hosting
23
Depreciation of Cap Exp ( 3 yr )
24
Overhead
25
Administrative
26
27
28
BENEFITS $ 350,000 $ 500,000 $ 1,000,000
29
Reduction in Sales Staff
30
Reduction in Customer Service Staff
31
Reduction in Travel
32
Reduction in Shipping / Printing
33
Direct to Customer Sales $ 350,000 $ 500,000 $ 1,000,000
34
Incremental Sales Due to Promotions
35
Incremental Sales Due to Subscriptions
36
37
38
39
40
41
NET BENEFITS $ 199,000 $ 363,000 $ 859,000
42
TAX $ 63,183 $ 115,253 $ 272,733
43
VALUE AFTER TAX $ 135,818 $ 247,748 $ 586,268
44
DEPRECIATION ADD BACK
45
CASH FLOW $ (84,000) $ 135,818 $ 247,748 $ 586,268
46
CUMULATIVE CASH FLOW $ (84,000) $ 51,818 $ 299,565 $ 885,833
47
48
EVALUATION METRICS
49
NET PRESENT-DAY VALUE (NPV) $ 820,902
50
INTERNAL RATE OF RETURN (IRR)221%
51
52
CLICK HERE TO CREATE IN SMARTSHEET
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100