| A | B | C | D | E | F | G | H | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | EUME LIFESTYLE PRIVATE LIMITED | |||||||||||||||||||||
2 | MIS | |||||||||||||||||||||
3 | Period | Q1 FY24 | Q2 FY24 | Q3 FY24 | ||||||||||||||||||
4 | Particulars | Apr | May | Jun | Jul | Aug | Sept | Oct | Total | |||||||||||||
5 | KEY METRICS | |||||||||||||||||||||
6 | Total Qty Sold | 24,925 | 99,924 | 99,345 | 93,012 | 58,078 | 46,603 | 38,140 | 460,027 | |||||||||||||
7 | ASP | 398 | 247 | 250 | 222 | 355 | 292 | 351 | 278 | |||||||||||||
8 | CM1 | 46% | 14% | 20% | 26% | 19% | 13% | 15% | 20% | |||||||||||||
9 | CM2 | 24% | 5% | 9% | 9% | 8% | 3% | 3% | 8% | |||||||||||||
10 | Net Margins | -17% | -5% | -5% | -15% | -3% | -16% | -14% | -9% | |||||||||||||
11 | ROAS | 0.62 | 1.15 | 2.00 | 2.30 | 1.57 | 1.45 | 1.56 | 1.60 | |||||||||||||
12 | ||||||||||||||||||||||
13 | P&L | Apr | May | Jun | Jul | Aug | Sept | Oct | Total | |||||||||||||
14 | REVENUE | |||||||||||||||||||||
15 | Sales - Amazon (Fill channel Specific sheet) | 771,179 | 1,070,145 | 2,460,426 | 2,515,869 | 918,221 | 521,380 | 399,791 | 8,657,011 | |||||||||||||
16 | Sales - Flipkart (Fill channel Specific sheet) | 89,039 | 188,266 | 1,471,614 | 2,475,985 | 387,774 | 151,125 | 982,949 | 5,746,752 | |||||||||||||
17 | Sales - Own Website (Fill channel Specific sheet) | 419,170 | 898,960 | 468,669 | 631,370 | 686,876 | 112,117 | 78,668 | 3,295,830 | |||||||||||||
18 | Sales - Own Other Major channel (Fill channel Specific sheet) | 108,170 | 608,683 | 1,162,165 | 2,187,991 | 1,314,297 | 1,142,694 | 1,059,176 | 7,583,176 | |||||||||||||
19 | Corporate Sales(B2B) | 8,535,952 | 21,945,656 | 19,260,209 | 12,852,728 | 17,331,580 | 11,672,658 | 10,885,336 | 102,484,119 | |||||||||||||
20 | ||||||||||||||||||||||
21 | TOTAL REVENUE | 9,923,510 | 24,711,710 | 24,823,083 | 20,663,943 | 20,638,748 | 13,599,974 | 13,405,920 | 127,766,888 | |||||||||||||
22 | Other Income | 163,365 | 66,922 | - | - | - | - | - | 230,287 | |||||||||||||
23 | 10,086,875 | 24,778,632 | 24,823,083 | 20,663,943 | 20,638,748 | 13,599,974 | 13,405,920 | 127,997,175 | ||||||||||||||
24 | DIRECT COSTS | |||||||||||||||||||||
25 | COGS | 5,511,423 | 21,234,392 | 19,782,977 | 15,355,021 | 16,807,534 | 11,856,646 | 11,439,046 | 101,987,039 | |||||||||||||
26 | Amazon | 289,818 | 404,583 | 898,712 | 1,066,826 | 431,310 | 213,765 | 172,341 | 3,477,355 | |||||||||||||
27 | Flipkart | 36,017 | 69,481 | 687,614 | 1,170,191 | 250,204 | 90,675 | 896,414 | 3,200,596 | |||||||||||||
28 | Own Website | 196,875 | 386,408 | 170,820 | 390,081 | 438,690 | 69,512 | 48,661 | 1,701,047 | |||||||||||||
29 | Other online channels | 54,138 | 378,057 | 796,681 | 1,346,130 | 1,113,895 | 822,739 | 530,230 | 5,041,870 | |||||||||||||
30 | B2B | 4,934,575 | 19,995,863 | 17,229,150 | 11,381,793 | 14,573,435 | 10,659,955 | 9,791,400 | 88,566,171 | |||||||||||||
31 | ||||||||||||||||||||||
32 | Others Direct Expenses | - | - | - | - | - | - | - | - | |||||||||||||
33 | ||||||||||||||||||||||
34 | TOTAL DIRECT COSTS | 5,511,423 | 21,234,392 | 19,782,977 | 15,355,021 | 16,807,534 | 11,856,646 | 11,439,046 | 101,987,039 | |||||||||||||
35 | ||||||||||||||||||||||
36 | GROSS MARGINS 1 | 4,575,452 | 3,544,240 | 5,040,106 | 5,308,922 | 3,831,214 | 1,743,328 | 1,966,874 | 26,010,136 | |||||||||||||
37 | GROSS MARGINS (%) | 46.11% | 14.34% | 20.30% | 25.69% | 18.56% | 12.82% | 14.67% | 20.36% | |||||||||||||
38 | ||||||||||||||||||||||
39 | Marketing & Employee Cost | |||||||||||||||||||||
40 | -Employee Benefit Expenses | 1,018,597 | 1,061,435 | 991,851 | 1,038,591 | 949,467 | 947,469 | 928,918 | 6,936,328 | |||||||||||||
41 | -Marketing | |||||||||||||||||||||
42 | 927,110 | 830,592 | 413,128 | 710,859 | 28,372 | 368,311 | 187,686 | 3,466,058 | ||||||||||||||
43 | 307,986 | 451,334 | 182,841 | 101,495 | 144,440 | 90,543 | 144,000 | 1,422,639 | ||||||||||||||
44 | Amazon | 439,087 | 599,032 | 1,208,475 | 1,746,610 | 654,237 | 338,983 | 438,983 | 5,425,407 | |||||||||||||
45 | Flipkart | 30,681 | 2,504 | 182,591 | 548,351 | 306,727 | - | 115,130 | 1,185,984 | |||||||||||||
46 | Other Channels | 111,000 | 362,000 | 298,329 | 107,772 | 586,252 | 304,874 | 555,899 | 2,326,126 | |||||||||||||
47 | Influencer Marketing | 300,000 | - | 225,000 | 102,000 | - | 86,000 | 19,280 | 732,280 | |||||||||||||
48 | -Business Promotion | 104,798 | 118,223 | 222,187 | 72,531 | 385,354 | 136,986 | 79,702 | 1,119,781 | |||||||||||||
49 | Photography & Videoshoot Expenses | - | 34,950 | 51,825 | - | - | - | 76,250 | 163,025 | |||||||||||||
50 | ||||||||||||||||||||||
51 | Marketing & Employee Cost | 3,239,259 | 3,460,070 | 3,776,227 | 4,428,209 | 3,054,849 | 2,273,166 | 2,545,848 | 22,777,628 | |||||||||||||
52 | GROSS MARGINS 2 | 1,336,193 | 84,170 | 1,263,879 | 880,713 | 776,365 | -529,838 | -578,974 | 3,232,509 | |||||||||||||
53 | GROSS MARGINS (%) | 13.46% | 0.34% | 5.09% | 4.26% | 3.76% | -3.90% | -4.32% | 2.53% | |||||||||||||
54 | ||||||||||||||||||||||
55 | -Other Indirect Expenses | |||||||||||||||||||||
56 | Channel Margin (Online Selling Charges) | 412,172 | 606,712 | 1,545,868 | 2,692,400 | 782,606 | 589,686 | 795,569 | 7,425,013 | |||||||||||||
57 | ||||||||||||||||||||||
58 | Transportation Charges | 233,489 | 200,157 | 196,916 | 211,904 | 435,394 | 424,311 | 187,214 | 1,889,385 | |||||||||||||
59 | Rentals & Admin | 115,237 | 115,237 | 115,237 | 115,237 | 115,237 | 115,237 | 115,237 | 806,659 | |||||||||||||
60 | Legal & Professional | 2,079,766 | 425,000 | 574,790 | 928,000 | - | 90,000 | - | 4,097,556 | |||||||||||||
61 | General Office Expenses | 154,721 | 44,959 | 90,318 | 29,938 | 32,675 | 268,609 | 94,820 | 716,040 | |||||||||||||
62 | Other Misc Expenses | 47,704 | 32,858 | 23,134 | 25,716 | 42,338 | 96,287 | 49,939 | 317,976 | |||||||||||||
63 | Total Other Indirect Expenses | 3,043,089 | 1,424,923 | 2,546,263 | 4,003,195 | 1,408,250 | 1,584,130 | 1,242,779 | 15,252,629 | |||||||||||||
64 | ||||||||||||||||||||||
65 | TOTAL COSTS | 11,793,771 | 26,119,385 | 26,105,467 | 23,786,425 | 21,270,633 | 15,713,942 | 15,227,673 | 140,017,296 | |||||||||||||
66 | ||||||||||||||||||||||
67 | EBITDA | -1,706,896 | -1,340,753 | -1,282,384 | -3,122,482 | -631,885 | -2,113,968 | -1,821,753 | -12,020,121 | |||||||||||||
68 | EBITDA (%) | -17.20% | -5.43% | -5.17% | -15.11% | -3.06% | -15.54% | -13.59% | -9.41% | |||||||||||||
70 | ||||||||||||||||||||||
71 | Cash in Hand & Bank | 14,118,111 | 14,683,698 | 11,680,192 | 11,621,132 | 10,869,595 | 13,385,417 | 16,057,457 | - | |||||||||||||
72 | ||||||||||||||||||||||
73 | Team Size | 20 | 21 | 21 | 24 | 23 | 23 | 23 | - | |||||||||||||
74 | ||||||||||||||||||||||
75 | DIRECT COSTS | |||||||||||||||||||||
76 | COGS | |||||||||||||||||||||
77 | COGS | 56% | 86% | 80% | 74% | 81% | 87% | 85% | 80% | |||||||||||||
78 | Channel Margin | 4% | 2% | 6% | 13% | 4% | 4% | 6% | 6% | |||||||||||||
83 | ||||||||||||||||||||||
84 | TOTAL DIRECT COSTS | 56% | 86% | 80% | 74% | 81% | 87% | 85% | 80% | |||||||||||||
85 | ||||||||||||||||||||||
86 | GROSS MARGINS | 46% | 14% | 20% | 26% | 19% | 13% | 15% | 20% | |||||||||||||
87 | GROSS MARGINS (%) | |||||||||||||||||||||
88 | ||||||||||||||||||||||
89 | INDIRECT COSTS | |||||||||||||||||||||
90 | -Employee Benefit Expenses | 10% | 4% | 4% | 5% | 5% | 7% | 7% | 5% | |||||||||||||
91 | -Marketing | |||||||||||||||||||||
92 | 9% | 3% | 2% | 3% | 0% | 3% | 1% | 3% | ||||||||||||||
93 | 3% | 2% | 1% | 0% | 1% | 1% | 1% | 1% | ||||||||||||||
94 | Amazon | 4% | 2% | 5% | 8% | 3% | 2% | 3% | 4% | |||||||||||||
95 | Flipkart | 0% | 0% | 1% | 3% | 1% | 0% | 1% | 1% | |||||||||||||
96 | Other Channel | 1% | 1% | 1% | 1% | 3% | 2% | 4% | 2% | |||||||||||||
97 | -Business Promotion | 1% | 1% | 1% | 0% | 2% | 1% | 1% | 1% | |||||||||||||
98 | Marketing & Employee Cost | 33% | 14% | 15% | 21% | 15% | 17% | 19% | 18% | |||||||||||||
99 | ||||||||||||||||||||||
100 | -Other Indirect Expenses | |||||||||||||||||||||
101 | -Rentals & Admin | 1% | 0% | 0% | 1% | 1% | 1% | 1% | 1% | |||||||||||||
102 | -Legal & Professional | 21% | 2% | 2% | 4% | 0% | 1% | 0% | 3% | |||||||||||||
103 | -Office Expenses | 2% | 0% | 0% | 0% | 0% | 2% | 1% | 1% | |||||||||||||
104 | Other Misc Expenses | 0% | 0% | 0% | 0% | 0% | 1% | 0% | 0% | |||||||||||||
105 | ||||||||||||||||||||||