| A | B | C | D | |
|---|---|---|---|---|
1 | Bird Bikes business model | |||
2 | ||||
3 | To use this worksheet, please copy it to your own organization. File → Make a Copy. You will then be able to edit it as you wish. Thanks! - @Haje | |||
4 | ||||
5 | ||||
6 | ||||
7 | ||||
8 | ||||
9 | ||||
10 | Acquisition cost | |||
11 | MSRP | $499.00 | ||
12 | Discounted | $300.00 | ||
13 | Asset tracker | $80.00 | ||
14 | Labor to assemble | $20.00 | ||
15 | Total bike cost | $400.00 | ||
16 | ||||
17 | Variables | |||
18 | Bike Usable Life | 300 | rides | |
19 | Maintenance every... | 14 | days | |
20 | Maintenance cost (avg) | $20.00 | per maintenance interval | |
21 | Number of rides per day per scooter | 5 | Rides | |
22 | Average ride length | 25 | Minutes | |
23 | Card processing cost | 3.00% | ||
24 | Scooters charged by users | 50.00% | ||
25 | Cost to charge bike by user | $5.00 | ||
26 | Cost to charge bike by Bird | $20.00 | ||
27 | ||||
28 | Unit economics | |||
29 | Revenue | Charge per ride | $1.00 | |
30 | Charge per minute | $0.15 | ||
31 | Revenue per ride | $4.75 | Per ride | |
32 | ||||
33 | Costs | Card Processing | $0.14 | |
34 | Maintenance cost | $0.29 | Per ride | |
35 | Charging costs (user) | $0.50 | Assuming charging every day | |
36 | Charging costs (Bird) | $2.00 | ||
37 | Costs per ride | $2.93 | ||
38 | ||||
39 | Profit per ride | $1.82 | ||
40 | ||||
41 | Getting to break-even | |||
42 | Rides | 220 | ||
43 | Days | 44 | ||
44 | Profit | $400.79 | ||
45 | ||||
46 | Model 1 - Scooter lifetime P/L | |||
47 | Scooter usable life (rides) | 300 | ||
48 | Cost of scooter | $400.00 | ||
49 | Total operating cost (all rides) | $878.46 | ||
50 | % of charges by users | 50.00% | ||
51 | % of charges by Bird | 50.00% | ||
52 | Avg ride duration | 25 min | ||
53 | Rides per day per scooter | 5 | ||
54 | Total lifetime revenue per scooter | $1,425.00 | ||
55 | P/L per scooter | $146.54 | ||
56 | Gross margin | 10.28% | ||
57 | ||||
58 | ↓ Note additional tabs for alternate business models! | |||