ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
2
Stealth Startup Financial Projections
Year 1Year 2Year 3Year 4Year 5
3
Total Revenue$600,000$3,600,000$15,000,000$54,000,000$168,000,000
4
Profits$478,000$1,674,375$11,605,688$46,047,078$150,530,934
5
OPERATING DATA
AssumptionNoteT=0Year 1Year 2Year 3Year 4Year 5
Accum Cash Flow
$478,000$2,152,375$13,758,063$59,805,141$210,336,074
6
7
Data Science DashboardingYear end08401605601,680
8
9
Total Subs8401605601,680
10
% Premium / BasicoutputKPI0%0%0%0%0%
11
12
Growth Data Science Subs%per month400%300%250%200%
13
14
15
Churn%per month3.0%10%10%10%10%
16
Churned Subs - Dashboarding1291204321,344
17
18
19
Gross Adds - Dashboarding9612408322,464
20
21
22
Average Subs - Dashboarding4241003601,120
23
24
Average Subs - Total4241003601,120
25
26
Price Dashboarding Subs150k/year$12,500$12,500$12,500$12,500$12,500
27
28
29
LTV Year 1Year 2Year 3Year 4Year 5
30
Data Science Dashboarding100%rate$10,707$12,085$10,864$9,621$8,373$7,124
31
32
$75,000$90,000$93,750$96,429$100,000
33
FINANCIAL DATA
T=0Year 1Year 2Year 3Year 4Year 5
34
35
Data Science Dashboarding$0$600,000$3,600,000$15,000,000$54,000,000$168,000,000
36
37
Total Revenue$0$600,000$3,600,000$15,000,000$54,000,000$168,000,000
38
% growth500%317%260%211%322%
39
40
One time Set up Cost (R&D)1 Person-day 25% decay $1,000$750$563$422$316
41
Cost per SubCloud Costs50% decay$250$125$63$31$16
42
Total Costs$2,000$3,750$6,813$11,672$17,816
43
44
Gross Profit0$598,000$3,596,250$14,993,188$53,988,328$167,982,184
45
Gross Margin100%100%100%100%100%
46
47
Marketing Expenses
48
Spend per new add$2,500$2,500$2,500$2,500$2,500
49
Sales / Advertising / Digital Marketing$20,000$100,000$400,000$1,400,000$4,200,000
50
% of Revenue3%3%3%3%3%
51
52
53
54
Total Marketing$20,000$100,000$400,000$1,400,000$4,200,000
55
56
Marketing for new Adds$20,000$100,000$400,000$1,400,000$4,200,000
57
Gross Adds9612408322,464
58
Cost of Customer Acquisition (COCA)$2,222$1,639$1,667$1,683$1,705
59
60
LTV / COCA - Dashboard Customers4.8x6.5x6.4x6.4x6.3x
61
62
63
Administrative Expenses
64
Headcount2.5513.2524.0042.0067.00
65
Implied Cost / person$0$126,179$111,979$104,315$97,481
66
Salaries & Payroll$0$1,671,875$2,687,500$4,381,250$6,531,250
67
% of Revenue0%46%18%8%4%
68
Performance Comp Rate0%10%20%25%25%
69
Performance Compensation$0$167,188$537,500$1,095,313$1,632,813
70
Rent$0$0$0$0$0
71
72
Other Expenses$100,000$150,000$300,000$2,160,000$6,720,000
73
% of Revenue16.7%4.2%2.0%4.0%4.0%
74
Total Admin$100,000$1,821,875$2,987,500$6,541,250$13,251,250
75
76
Total Expenses$120,000$1,921,875$3,387,500$7,941,250$17,451,250
77
78
SUMMARYT=0Year 1Year 2Year 3Year 4Year 5
79
Subs8401605601,680
80
Revenue / Sub$75,000$90,000$93,750$96,429$100,000
81
Revenue$600,000$3,600,000$15,000,000$54,000,000$168,000,000
82
Gross Profit$598,000$3,596,250$14,993,188$53,988,328$167,982,184
83
Expenses$120,000$1,921,875$3,387,500$7,941,250$17,451,250
84
Profit$478,000$1,674,375$11,605,688$46,047,078$150,530,934
85
Max Need
86
Cumulative Cash (Shortfall) / Surplus$478,000$478,000$2,152,375$13,758,063$59,805,141$210,336,074
87
88
89
90
91
92
93
94
95
96
97
98
99
100