IPOs - Google Sheets

	A	B	C	D
1
2		Average
3	5yr	OldCo	NewCo
4	Sales Growth	129.22%	116.42%
5	Shares Growth	584.83%	483.71%
6	COGS:Sales	50.76%	29.13%
7	R&D:Sales	30.00%	29.48%
8	S&M:Sales	72.46%	57.28%
9	G&A:Sales	22.07%	21.11%
10	Total Costs:Sales	180.04%	143.16%
11	CFO:Sales	24.93%	21.13%
12	FCF:Sales	20.22%	16.46%
13
14
15		Average
16	Last year	OldCo	NewCo
17	Sales Growth	76.08%	325.81%
18	COGS:Sales	56.00%	31.00%
19	R&D:Sales	18.88%	6.19%
20	S&M:Sales	37.02%	25.83%
21	G&A:Sales	13.44%	12.09%
22	Total Costs:Sales	125.34%	75.11%
23	CFO:Sales	26.33%	55.49%
24	FCF:Sales	24.23%	52.47%
25
26
27	Valuation	IPO Valuation ($B)	NTM Sales ($B)	P/S
28	Google	$30.00	$6.14	4.89
29	Salesforce	$1.70	$0.09	19.81
30	Workday	$0.64	$0.27	2.34
31	Snowflake	$70.00	$1.22	57.41
32	Zoom	$10.00	$0.62	16.06
33	Airbnb	$47.00	$5.99	7.84
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
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