A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Year | 2016 | 2017 | 2018 | Key | |||||||||||||||||||||||
2 | Quarter | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | from S-1 | ||||||||||||||
3 | Lyft | Calculated | ||||||||||||||||||||||||||
4 | Riders (M) | 3.5 | 4.5 | 5.7 | 6.6 | 8.1 | 9.4 | 11.4 | 12.6 | 14 | 15.5 | 17.4 | 18.6 | |||||||||||||||
5 | Rev $/rider | 15.88 | 14.11 | 18.03 | 18.53 | 21.42 | 25.29 | 26.59 | 27.34 | 28.27 | 32.67 | 33.65 | 36.04 | |||||||||||||||
6 | Rides (M) | 29 | 36.5 | 44.3 | 52.6 | 70.4 | 85.8 | 103.1 | 116.3 | 132.5 | 146.3 | 162.2 | 178.4 | |||||||||||||||
7 | Ride Rev $M | $55.58 | $63.50 | $102.77 | $122.30 | $173.50 | $237.73 | $303.13 | $344.48 | $395.78 | $506.39 | $585.51 | $670.34 | |||||||||||||||
8 | Rev % Bookings | 16.80% | 14.70% | 19.70% | 19.60% | 21.00% | 23.30% | 24.00% | 23.40% | 23.90% | 26.20% | 27.40% | 28.70% | |||||||||||||||
9 | Bookings | $330.83 | $431.94 | $521.68 | $623.97 | $826.20 | $1,020.28 | $1,263.03 | $1,472.15 | $1,655.98 | $1,932.77 | $2,136.90 | $2,335.69 | |||||||||||||||
10 | Cost of Revenue ($M) | $118.59 | $143.92 | $188.99 | $208.03 | $260.61 | $293.19 | $322.61 | $366.99 | |||||||||||||||||||
11 | Operations ($M) | $36.22 | $43.04 | $48.32 | $55.94 | $59.91 | $67.37 | $92.48 | $118.65 | |||||||||||||||||||
12 | R&D ($M) | $23.50 | $28.24 | $37.17 | $47.74 | $63.19 | $64.42 | $77.17 | $96.06 | |||||||||||||||||||
13 | S&M ($M) | $84.40 | $107.38 | $165.30 | $209.94 | $168.71 | $175.11 | $241.02 | $218.92 | |||||||||||||||||||
14 | G&A ($M) | $40.79 | $46.94 | $63.33 | $70.39 | $90.15 | $98.47 | $120.35 | $138.96 | |||||||||||||||||||
15 | Profit ($M) | -$130 | -$132 | -$200 | -$248 | -$247 | -$192 | -$268 | -$269 | |||||||||||||||||||
16 | Uber | |||||||||||||||||||||||||||
17 | MAPCs (M) | 19 | 25 | 33 | 45 | 49 | 57 | 62 | 68 | 70 | 76 | 82 | 91 | |||||||||||||||
18 | Trips (M) | 268 | 362 | 501 | 687 | 774 | 889 | 985 | 1088 | 1136 | 1242 | 1348 | 1493 | |||||||||||||||
19 | Ride Gross Bookings ($M) | $6,508 | $7,484 | $8,200 | $9,192 | $9,380 | $10,166 | $10,488 | $11,479 | |||||||||||||||||||
20 | Uber Eats Gross Bookings ($M) | $428 | $588 | $824 | $1,118 | $1,473 | $1,774 | $2,111 | $2,561 | |||||||||||||||||||
21 | Other Bets Gross Bookings ($M) | $2 | $9 | $21 | $35 | $40 | $72 | $126 | $129 | |||||||||||||||||||
22 | Total Gross Bookings ($M) | $6,938 | $8,081 | $9,045 | $10,345 | $10,893 | $12,012 | $12,725 | $14,169 | |||||||||||||||||||
23 | Ride Net Rev ($M) | $1,200 | $1,470 | $1,768 | $1,996 | $2,124 | $2,260 | $2,315 | $2,314 | |||||||||||||||||||
24 | Eat Net Rev ($M) | $34 | $75 | $109 | $149 | $183 | $218 | $191 | $165 | |||||||||||||||||||
25 | Other Net Rev ($M) | $92 | $100 | $102 | $96 | $81 | $60 | $54 | $60 | |||||||||||||||||||
26 | Core Platform Net Rev ($M) | $1,326 | $1,645 | $1,979 | $2,241 | $2,388 | $2,538 | $2,560 | $2,539 | |||||||||||||||||||
27 | ex-Core Platform Revenue ($M) | $203 | $168 | $170 | $200 | $196 | $230 | $384 | $435 | |||||||||||||||||||
28 | Revenue ($M) | $1,529 | $1,813 | $2,149 | $2,441 | $2,584 | $2,768 | $2,944 | $2,974 | |||||||||||||||||||
29 | Cost of Revenue ($M) | $820 | $952 | $1,184 | $1,204 | $1,156 | $1,342 | $1,510 | $1,615 | |||||||||||||||||||
30 | D&A ($M) | $121 | $129 | $140 | $120 | $88 | $98 | $131 | $109 | |||||||||||||||||||
31 | Effective Cost of Revenue ($M) | $941 | $1,081 | $1,324 | $1,324 | $1,244 | $1,440 | $1,641 | $1,724 | |||||||||||||||||||
32 | Operations ($M) | $301 | $327 | $364 | $362 | $372 | $349 | $387 | $408 | |||||||||||||||||||
33 | R&D ($M) | $270 | $304 | $307 | $320 | $340 | $365 | $434 | $366 | |||||||||||||||||||
34 | S&M ($M) | $549 | $601 | $695 | $679 | $677 | $715 | $785 | $974 | |||||||||||||||||||
35 | G&A ($M) | $286 | $410 | $614 | $953 | $429 | $638 | $460 | $555 | |||||||||||||||||||
36 | Profit ($M) | -$818 | -$910 | -$1,155 | -$1,197 | -$478 | -$739 | -$763 | -$1,053 | |||||||||||||||||||
37 | Comparison | |||||||||||||||||||||||||||
38 | Gross Profit as % of Bookings | 2017Q1 | 2017Q2 | 2017Q3 | 2017Q4 | 2018Q1 | 2018Q2 | 2018Q3 | 2018Q4 | |||||||||||||||||||
39 | Lyft | 6.6% | 9.2% | 9.0% | 9.3% | 8.2% | 11.0% | 12.3% | 13.0% | |||||||||||||||||||
40 | Uber | 8.5% | 9.1% | 9.1% | 10.8% | 12.3% | 11.1% | 10.2% | 8.8% | |||||||||||||||||||
41 | Bookings $ / Ride | 2016Q1 | 2016Q2 | 2016Q3 | 2016Q4 | 2017Q1 | 2017Q2 | 2017Q3 | 2017Q4 | 2018Q1 | 2018Q2 | 2018Q3 | 2018Q4 | |||||||||||||||
42 | Lyft | $11.41 | $11.83 | $11.78 | $11.86 | $11.74 | $11.89 | $12.25 | $12.66 | $12.50 | $13.21 | $13.17 | $13.09 | |||||||||||||||
43 | Uber | $8.41 | $8.42 | $8.32 | $8.45 | $8.26 | $8.19 | $7.78 | $7.69 | |||||||||||||||||||
44 | Gross Profit $ / Ride | 2017Q1 | 2017Q2 | 2017Q3 | 2017Q4 | 2018Q1 | 2018Q2 | 2018Q3 | 2018Q4 | |||||||||||||||||||
45 | Lyft | $0.78 | $1.09 | $1.11 | $1.17 | $1.02 | $1.46 | $1.62 | $1.70 | |||||||||||||||||||
46 | Uber | $0.71 | $0.76 | $0.76 | $0.91 | $1.02 | $0.91 | $0.80 | $0.68 | |||||||||||||||||||
47 | OPEX $ / Ride | 2017Q1 | 2017Q2 | 2017Q3 | 2017Q4 | 2018Q1 | 2018Q2 | 2018Q3 | 2018Q4 | |||||||||||||||||||
48 | Lyft | $2.63 | $2.63 | $3.05 | $3.30 | $2.88 | $2.77 | $3.27 | $3.21 | |||||||||||||||||||
49 | Uber | $1.82 | $1.85 | $2.01 | $2.13 | $1.60 | $1.66 | $1.53 | $1.54 | |||||||||||||||||||
50 | Profit $ / Ride | 2017Q1 | 2017Q2 | 2017Q3 | 2017Q4 | 2018Q1 | 2018Q2 | 2018Q3 | 2018Q4 | |||||||||||||||||||
51 | Lyft | -$1.85 | -$1.54 | -$1.94 | -$2.13 | -$1.86 | -$1.31 | -$1.65 | -$1.51 | |||||||||||||||||||
52 | Uber | -$1.10 | -$1.08 | -$1.25 | -$1.21 | -$0.58 | -$0.76 | -$0.74 | -$0.86 | |||||||||||||||||||
53 | ~Monthly Rides / Monthly Active Rider | 2016Q1 | 2016Q2 | 2016Q3 | 2016Q4 | 2017Q1 | 2017Q2 | 2017Q3 | 2017Q4 | 2018Q1 | 2018Q2 | 2018Q3 | 2018Q4 | |||||||||||||||
54 | Lyft | 2.76 | 2.70 | 2.59 | 2.66 | 2.90 | 3.04 | 3.01 | 3.08 | 3.15 | 3.15 | 3.11 | 3.20 | |||||||||||||||
55 | Uber | 4.70 | 4.83 | 5.06 | 5.09 | 5.27 | 5.20 | 5.30 | 5.33 | 5.41 | 5.45 | 5.48 | 5.47 | |||||||||||||||
56 | ~ Monthly Bookings / Monthly Active User | 2016Q1 | 2016Q2 | 2016Q3 | 2016Q4 | 2017Q1 | 2017Q2 | 2017Q3 | 2017Q4 | 2018Q1 | 2018Q2 | 2018Q3 | 2018Q4 | |||||||||||||||
57 | Lyft | $31.51 | $32.00 | $30.51 | $31.51 | $34.00 | $36.18 | $36.93 | $38.95 | $39.43 | $41.56 | $40.94 | $41.86 | |||||||||||||||
58 | Uber (Ride Bookings only) | $44.27 | $43.77 | $44.09 | $45.06 | $44.67 | $44.59 | $42.63 | $42.05 | |||||||||||||||||||
59 | Uber (Total Bookings) | $47.20 | $47.26 | $48.63 | $50.71 | $51.87 | $52.68 | $51.73 | $51.90 | |||||||||||||||||||
60 | ~ Monthly Gross Profit $ / Monthly Active User | 2017Q1 | 2017Q2 | 2017Q3 | 2017Q4 | 2018Q1 | 2018Q2 | 2018Q3 | 2018Q4 | |||||||||||||||||||
61 | Lyft | $2.26 | $3.33 | $3.34 | $3.61 | $3.22 | $4.58 | $5.04 | $5.44 | |||||||||||||||||||
62 | Uber (Rides only) | $3.75 | $3.96 | $4.02 | $4.87 | $5.49 | $4.93 | $4.37 | $3.71 | |||||||||||||||||||
63 | Uber (Total) | $4.00 | $4.28 | $4.44 | $5.48 | $6.38 | $5.82 | $5.30 | $4.58 | |||||||||||||||||||
64 | ~ Monthly OPEX $ / Monthly Active User | 2017Q1 | 2017Q2 | 2017Q3 | 2017Q4 | 2018Q1 | 2018Q2 | 2018Q3 | 2018Q4 | |||||||||||||||||||
65 | Lyft | $7.61 | $8.00 | $9.18 | $10.16 | $9.09 | $8.72 | $10.17 | $10.26 | |||||||||||||||||||
66 | Uber | $9.56 | $9.60 | $10.65 | $11.34 | $8.66 | $9.07 | $8.40 | $8.44 | |||||||||||||||||||
67 | ~ Monthly Profit $ / Monthly Active User | 2017Q1 | 2017Q2 | 2017Q3 | 2017Q4 | 2018Q1 | 2018Q2 | 2018Q3 | 2018Q4 | |||||||||||||||||||
68 | Lyft | -$5.35 | -$4.67 | -$5.85 | -$6.55 | -$5.88 | -$4.13 | -$5.14 | -$4.83 | |||||||||||||||||||
69 | Uber | -$5.56 | -$5.32 | -$6.21 | -$5.87 | -$2.28 | -$3.24 | -$3.10 | -$3.86 | |||||||||||||||||||
70 | Take Rate | 2017Q1 | 2017Q2 | 2017Q3 | 2017Q4 | 2018Q1 | 2018Q2 | 2018Q3 | 2018Q4 | |||||||||||||||||||
71 | Lyft | 21.00% | 23.30% | 24.00% | 23.40% | 23.90% | 26.20% | 27.40% | 28.70% | |||||||||||||||||||
72 | Uber Rides | 18.44% | 19.64% | 21.56% | 21.71% | 22.64% | 22.23% | 22.07% | 20.16% | |||||||||||||||||||
73 | Uber Eats | 7.94% | 12.76% | 13.23% | 13.33% | 12.42% | 12.29% | 9.05% | 6.44% | |||||||||||||||||||
74 | Uber Overall | 19.11% | 20.36% | 21.88% | 21.66% | 21.92% | 21.13% | 20.12% | 17.92% | |||||||||||||||||||
75 | ||||||||||||||||||||||||||||
76 | Drivers | 2018Q4 | Rides/dr | Ride $/dr | Gross $/dr | Take Home | Take Home only rides | |||||||||||||||||||||
77 | Lyft (M) | 1.1 | 162.18 | $2,123.36 | $2,123.36 | $1,513.95 | $1,513.95 | |||||||||||||||||||||
78 | Uber (M) | 3.9 | 382.82 | $2,943.33 | $3,633.08 | $2,982.05 | $2,350.00 | |||||||||||||||||||||
79 | Uber/Lyft Abs Multiple | 2.36 | 1.39 | 1.71 | 1.97 | 1.55 | ||||||||||||||||||||||
80 | Uber/Lyft Ind Factor Multiple | 136% | -41% | 23% | 15% | |||||||||||||||||||||||
81 | QoQ growth | |||||||||||||||||||||||||||
82 | Users | 2016Q1 | 2016Q2 | 2016Q3 | 2016Q4 | 2017Q1 | 2017Q2 | 2017Q3 | 2017Q4 | 2018Q1 | 2018Q2 | 2018Q3 | 2018Q4 | multiple | CQGR | |||||||||||||
83 | Lyft (Riders) | 3.5 | 4.5 | 5.7 | 6.6 | 8.1 | 9.4 | 11.4 | 12.6 | 14 | 15.5 | 17.4 | 18.6 | 5.314 | 16.4% | |||||||||||||
84 | Uber (MAPCs) | 19 | 25 | 33 | 45 | 49 | 57 | 62 | 68 | 70 | 76 | 82 | 91 | 4.789 | 15.3% | |||||||||||||
85 | Bookings | 2017Q1 | 2017Q2 | 2017Q3 | 2017Q4 | 2018Q1 | 2018Q2 | 2018Q3 | 2018Q4 | |||||||||||||||||||
86 | Lyft | $826 | $1,020 | $1,263 | $1,472 | $1,656 | $1,933 | $2,137 | $2,336 | 2.827 | 16.0% | |||||||||||||||||
87 | Uber - Rides only | $6,508 | $7,484 | $8,200 | $9,192 | $9,380 | $10,166 | $10,488 | $11,479 | 1.764 | 8.4% | |||||||||||||||||
88 | Uber - All | $6,938 | $8,081 | $9,045 | $10,345 | $10,893 | $12,012 | $12,725 | $14,169 | 2.042 | 10.7% | |||||||||||||||||
89 | ||||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||||
100 |