ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
The Hemp Store P&L Projections
3
4
Sr NoAccount HeadY1Y2Y3Y4Y5Notes
5
1Total Revenue Product Sales ₹ 232,065,840 ₹ 453,772,668 ₹ 825,874,560 ₹ 1,371,957,984 ₹ 2,162,013,000 Revenue Projections
6
2Total Revenue form B2B Sales ₹ 5,750,000 ₹ 23,614,388 ₹ 73,546,010 ₹ 173,903,275 ₹ 327,965,625
7
3Revenue form Corporate Gifiting ₹ 1,000,000 ₹ 8,400,000 ₹ 21,562,500 ₹ 38,880,000 ₹ 81,000,000
8
4Revenue form Export (INR) ₹ 27,731,520 ₹ 80,883,600 ₹ 361,087,500 ₹ 924,384,000 ₹ 1,540,640,000
9
X5Total Revenue ₹ 266,547,360 ₹ 566,670,656 ₹ 1,282,070,570 ₹ 2,509,125,259 ₹ 4,111,618,625
10
11
6Cost of Goods Sold ₹ 91,879,267 ₹ 190,957,678 ₹ 408,095,634 ₹ 769,157,820 ₹ 1,251,090,030 Direct costs associated with producing the company's products, such as raw materials, labor, and overhead costs related to the manufacturing process.
12
- Cost of Raw Materials ₹ 76,566,056 ₹ 159,131,398 ₹ 340,079,695 ₹ 640,964,850 ₹ 1,042,575,025
13
- Labor Cost ₹ 15,313,211 ₹ 31,826,280 ₹ 68,015,939 ₹ 128,192,970 ₹ 208,515,005
14
(% of Revenue)34%34%32%31%30%
15
16
7Packaging & Labelling ₹ 2,296,982 ₹ 4,773,942 ₹ 10,202,391 ₹ 19,228,946 ₹ 31,277,251 Costs associated with packaging the finished products, including the materials used for packaging (boxes, containers, etc.)
17
(% of Raw Materials)3%3%3%3%3%
18
(% of Revenue)0.9%0.8%0.8%0.8%0.8%
19
20
8Carrier & Freight ₹ 19,141,514 ₹ 38,191,536 ₹ 74,817,533 ₹ 134,602,619 ₹ 208,515,005 Expenses incurred for transporting raw materials and finished goods, including shipping charges, freight costs, and other logistics-related expenses.
21
(% of Raw Material)25.0%24.0%22.0%21.0%20.0%
22
(% of Revenue)7.2%6.7%5.8%5.4%5.1%
23
TOTAL PRODUCTION COST ₹ 113,317,763 ₹ 233,923,155 ₹ 493,115,558 ₹ 922,989,384 ₹ 1,490,882,286
24
25
XGROSS PROFIT ₹ 153,229,597 ₹ 332,747,501 ₹ 788,955,012 ₹ 1,586,135,875 ₹ 2,620,736,339
26
(GROSS MARGIN)57.49%58.72%61.54%63.21%63.74%
27
28
9Compensation & Benefits ₹ 33,800,000 ₹ 82,800,000 ₹ 155,850,000 ₹ 231,100,000 ₹ 308,500,000 Overall compensation package that is provided to Operations, Finance, Marketing & Management Team, along with the boards remuneration
29
(% of Revenue)13%15%12%9%8%
30
31
10Marketing ₹ 87,216,000 ₹ 167,146,300 ₹ 298,941,600 ₹ 450,231,000 ₹ 657,675,000 Costs associated with promoting the company's products and services including advertising campaigns, sponsorships, marketing materials, and events
32
(% of Revenue)33%29%23%18%16%
33
34
11Commission & Service Fees ₹ 48,465,372 ₹ 91,435,707 ₹ 174,143,991 ₹ 324,061,099 ₹ 537,160,200 Refers to the expenses incurred by a company for engaging third-party service providers or sales representatives to sell their products or services
zomato or online platform, custom and etc
35
(% of Revenue)18%16%14%13%13%
36
37
12Software & Licenses ₹ 460,000 ₹ 740,000 ₹ 920,000 ₹ 1,100,000 ₹ 1,280,000 Accounting, CRM, productivity tools, Licensing fees for using third-party software, Training and support services related to software usage
38
(% of Revenue)0.17%0.13%0.07%0.04%0.03%
39
40
13Legal & Professional Fees ₹ 2,665,474 ₹ 5,666,707 ₹ 12,820,706 ₹ 25,091,253 ₹ 41,116,186 Fees include licensing fees, registration fees, compliance-related charges or Consulting charges
41
(% of Revenue)1%1%1%1%1%
42
43
14Travelling & Lodging ₹ 3,502,080 ₹ 8,704,000 ₹ 21,312,000 ₹ 34,457,600 ₹ 53,698,560 Expenses related to business travel undertaken by the company's employees or representatives
44
(% of Revenue)1%2%2%1%1%
45
46
15Rent & Utlities ₹ 5,306,400 ₹ 8,131,200 ₹ 11,220,000 ₹ 12,276,000 ₹ 13,648,800 Refers to the amount paid by the company for leasing or renting the premises including necessary services like electricity, water, internet
47
(% of Revenue)2.0%1.4%0.9%0.5%0.3%
48
49
X18Operating Expenses ₹ 294,733,088 ₹ 598,547,069 ₹ 1,168,323,854 ₹ 2,001,306,336 ₹ 3,103,961,032 Total of all the Operating Expenses
50
X19EBITDA ₹ -28,185,728 ₹ -31,876,413 ₹ 113,746,716 ₹ 507,818,923 ₹ 1,007,657,593 Total Revenue - Total Operating Expenses
51
020Finance Cost ₹ 2,400,000 ₹ 2,400,000 ₹ 6,000,000 ₹ 6,000,000 ₹ 6,000,000 Interest expense on any outstanding debt or borrowing costs
_CFF AND+ CFO
52
021Depreciation ₹ 4,500,000 ₹ 4,700,000 ₹ 17,400,000 ₹ 17,520,000 ₹ 17,660,000 Depreciation expense for fixed assets like equipment, furniture, leasehold improvements
pLUS CFO/-CFI
53
022Branding & Tech Amortization ₹ 2,033,333 ₹ 4,286,667 ₹ 6,780,000 ₹ 11,533,333 ₹ 16,350,667 Amortization of any branding/trademarking costs and capitalized technology/software
pLUS CFO/-CFI
54
23Non-Operating Expenses ₹ 8,933,333 ₹ 11,386,667 ₹ 30,180,000 ₹ 35,053,333 ₹ 40,010,667
55
X24Profit before Tax ₹ -37,119,062 ₹ -43,263,080 ₹ 83,566,716 ₹ 472,765,590 ₹ 967,646,926
56
25Tax ₹ - ₹ - ₹ - ₹ 94,553,118 ₹ 241,911,732
57
026Profit after Tax ₹ -37,119,062 ₹ -43,263,080 ₹ 83,566,716 ₹ 378,212,472 ₹ 725,735,195 CFO
58
59
60
EBITDA Margin-10.6%-5.6%8.9%20.2%24.5%
61
Net Profit Margin-13.9%-7.6%6.5%15.1%17.7%
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