BCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAG
1
🔧 How do you make a copy of a Google document to your Google Drive?
 input
2
TimelineUnitsYear 1Year 2Year 3Year 4Year 5
3
4
Income Statement Assumptions
5
Revenue
6
7
Greenhouses
8
New customers (greenhouses)Count 2 4 12 20 35
9
Average # of packages per greenhouse Count 24 24 24 24 24
10
Price per packageUSD 1,830 1,830 1,922 1,922 1,922
11
Setup revenue - GreenhousesUSD 87,840 175,680 553,392 922,320 1,614,060
12
13
Annual Churn Rate%35%
14
15
Churn table
16
Year 1Count 2 1 1 1 1
17
Year 2Count 4 3 2 1
18
Year 3Count 12 8 5
19
Year 4Count 20 13
20
Year 5Count 35
21
Total number of active customers Count 2 5 16 31 55
22
23
Refill price per packageUSD 180 180 180 180 180
24
Average # of refills per yearCount 2 2 2 2 2
25
Total active packagesCount 48 120 384 744 1,320
26
27
Refill revenue - GreenhousesUSD 17,280 43,200 138,240 267,840 475,200
28
Revenue - GreenhousesUSD 105,120 218,880 691,632 1,190,160 2,089,260
29
30
Individuals
31
New customers / individualsCount 2 8 20 35 50
32
Average # of packages per customer / Individual Count 1 1 1 1 1
33
Price per packageUSD 273 273 286 286 286
34
Setup revenue - IndividualsUSD 545 2,180 5,723 10,014 14,306
35
36
Annual Churn Rate%35%
37
38
Churn table
39
Year 1Count 2 1 1 1 1
40
Year 2Count 8 5 3 2
41
Year 3Count 20 13 8
42
Year 4Count 35 23
43
Year 4Count 50
44
TotalCount 2 9 26 52 84
45
46
Refill price per packageUSD 23 23 23 23 23
47
Average refill per yearCount 3 3 3 3 3
48
Total active packagesCount 2 9 26 52 84
49
50
Refill revenue - IndividualsUSD 135 608 1,755 3,510 5,670
51
Revenue - IndividualsUSD 680 2,788 7,478 13,524 19,976
52
53
Subscription - Greenhouses
54
Active # of customers - GreenhousesCount 2 5 16 31 55
55
Annual subscripition fee - GreenhouseUSD 360 360 360 360 360
56
Subscription revenue - GreenhousesUSD 720 1,800 5,760 11,160 19,800
57
58
Subscription - Individuals
59
Active # of customers - IndividualsCount 2 9 26 52 84
60
Annual subscripition fee - IndividualsUSD 120 120 120 120 120
61
Subscription revenue - IndividualsUSD 240 1,080 3,120 6,240 10,080
62
63
Subscription revenue - TotalUSD 960 2,880 8,880 17,400 29,880
64
65
Revenue
66
67
Revenue
68
Revenue - GreenhousesUSD 105,120 218,880 691,632 1,190,160 2,089,260
69
Revenue - IndividualsUSD 680 2,788 7,478 13,524 19,976
70
Subscription revenue - TotalUSD 960 2,880 8,880 17,400 29,880
71
Total revenueUSD 106,760 224,548 707,990 1,221,084 2,139,116
72
73
Cost of services
74
75
Greenhouses
76
# of packages soldCount 48 96 288 480 840
77
Cost per packageUSD 660 660 594 594 594
why did you decrease the amount as of year 3? What is the rationale?
78
Cost - Setup GreenhousesUSD 31,661 63,322 170,968 284,947 498,658
79
80
Total refillsCount 96 240 768 1,488 2,640
81
Cost per refillUSD 130 130 117 117 117
why did you decrease the amount as of year 3? What is the rationale?
82
Cost - Refills GreenhousesUSD 12,442 31,104 89,580 173,560 307,930
83
84
Individual
85
Packages soldCount 2 8 20 35 50
86
Cost per packageUSD 109 109 98 98 98
why did you decrease the amount as of year 3? What is the rationale?
87
Cost - Setup IndividualsUSD 217 870 1,957 3,424 4,892
88
89
Total refillsCount 6 27 78 156 252
90
Cost per refillUSD 16 16 15 15 15
why did you decrease the amount as of year 3? What is the rationale?
91
Cost - Refills IndividualsUSD 97 437 1,137 2,274 3,674
92
93
Total costUSD 44,417 95,733 263,642 464,206 815,153
94
95
OPEX
96
Rent of warehouse USD 4,000 4,000 4,000 4,500 4,500
97
Cost of logistics per move USD - - - - -
98
Cost of logisticsUSD 1,000 1,000 1,500 1,500 1,750
99
Utilities (gov expenses, municipality, electricity, water, finance malieh)
USD 1,500 1,500 2,000 2,000 2,000
100
Sales & Marketing USD 30,000 60,000 100,000 130,000 200,000