ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQAR
1
ParticularsSEP-23 (P)Oct-23Nov-23Dec-23Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24Sep-24Oct-24Nov-24Dec-24Jan-25Feb-25Mar-25Apr-25May-25Jun-25Jul-25Aug-25Sep-25Oct-25Nov-25Dec-25Jan-26Feb-26Mar-26Apr-26May-26Jun-26Jul-26Aug-26Sep-26Oct-26Nov-26Dec-26Jan-27Feb-27Mar-27
2
Sales
3
Prepaid-(Payment Gateway)+Online Transfers
18112838.06 19,924,121.86 23,908,946.23 22,713,498.92 23,849,173.87 21,464,256.48 25,757,107.78 30,908,529.33 33,999,382.27 37,399,320.49 41,139,252.54 45,253,177.80 52,041,154.47 59,847,327.64 68,824,426.78 65,383,205.44 68,652,365.72 61,787,129.14 74,144,554.97 88,973,465.97 97,870,812.56 102,764,353.19 113,040,788.51 124,344,867.36 136,779,354.10 150,457,289.51 165,503,018.46 182,053,320.30 200,258,652.33 220,284,517.57 242,312,969.33 266,544,266.26 293,198,692.88 322,518,562.17 354,770,418.39 390,247,460.23 429,272,206.25 472,199,426.88 519,419,369.56 571,361,306.52 628,497,437.17 691,347,180.89 760,481,898.98
4
SAAS 300,000.00 315,000.00 330,750.00 347,287.50 382,016.25 420,217.88 462,239.66 485,351.65 509,619.23 535,100.19 508,345.18 610,014.22 671,015.64 738,117.20 811,928.92 893,121.81 982,433.99 1,080,677.39 1,188,745.13 1,307,619.65 1,438,381.61 1,582,219.77 1,740,441.75 1,914,485.93 2,105,934.52 2,316,527.97 2,548,180.77 2,802,998.84 3,083,298.73 3,391,628.60 3,730,791.46 4,103,870.61 4,514,257.67 4,965,683.43 5,462,251.78 6,008,476.95
5
COD
6
Offline
7
Marketplaces (amazon/flipkart)
8
Total Sales 18,112,838.06 19,924,121.86 23,908,946.23 22,713,498.92 23,849,173.87 21,464,256.48 25,757,107.78 31,208,529.33 34,314,382.27 37,730,070.49 41,486,540.04 45,635,194.05 52,461,372.34 60,309,567.30 69,309,778.43 65,892,824.67 69,187,465.90 62,295,474.32 74,754,569.19 89,644,481.60 98,608,929.76 103,576,282.11 113,933,910.32 125,327,301.36 137,860,031.49 151,646,034.64 166,810,638.11 183,491,701.92 201,840,872.11 222,024,959.32 244,227,455.25 268,650,200.78 295,515,220.85 325,066,742.94 357,573,417.23 393,330,758.95 432,663,834.85 475,930,218.34 523,523,240.17 575,875,564.19 633,463,120.60 696,809,432.66 766,490,375.93
9
COGS14490270 15939297 19127157 18170799 19079339 17171405 20605686 24726823 27199506 29919456 32911402 36202542 41632924 47877862 55059541 52306564 54921893 49429703 59315644 71178773 78296650 82211483 90432631 99475894 109423483 120365832 132402415 145642656 160206922 176227614 193850375 213235413 234558954 258014850 283816335 312197968 343417765 377759542 415535496 457089045 502797950 553077745 608385519
10
Gross margin 3,622,567.61 3,984,824.37 4,781,789.25 4,542,699.78 4,769,834.77 4,292,851.30 5,151,421.56 6,481,705.87 7,114,876.45 7,810,614.10 8,575,138.01 9,432,651.81 10,828,448.77 12,431,705.19 14,250,237.00 13,586,260.32 14,265,573.33 12,865,771.01 15,438,925.21 18,465,708.83 20,312,279.71 21,364,799.56 23,501,279.52 25,851,407.47 28,436,548.21 31,280,203.04 34,408,223.34 37,849,045.67 41,633,950.24 45,797,345.26 50,377,079.79 55,414,787.77 60,956,266.55 67,051,893.20 73,757,082.52 81,132,790.77 89,246,069.85 98,170,676.84 107,987,744.52 118,786,518.97 130,665,170.87 143,731,687.95 158,104,856.75
11
Gross margin(%)0.20.20.20.20.20.20.20.20769020540.20734385940.20701297390.20669687080.20669687080.20640803480.206131560.20560211450.206187250.206187250.20652818120.20652818120.20598823820.20598823820.20627115710.20627115710.20627115710.20627115710.20627115710.20627115710.20627115710.20627115710.20627115710.20627115710.20627115710.20627115710.20627115710.20627115710.20627115710.20627115710.20627115710.20627115710.20627115710.20627115710.20627115710.2062711571
12
13
Other direct/variable cost:
14
Packaging cost
15
Logistics
16
Commissions
17
CM1 3,622,568 3,984,824 4,781,789 4,542,700 4,769,835 4,292,851 5,151,422 6,481,706 7,114,876 7,810,614 8,575,138 9,432,652 10,828,449 12,431,705 14,250,237 13,586,260 14,265,573 12,865,771 15,438,925 18,465,709 20,312,280 21,364,800 23,501,280 25,851,407 28,436,548 31,280,203 34,408,223 37,849,046 41,633,950 45,797,345 50,377,080 55,414,788 60,956,267 67,051,893 73,757,083 81,132,791 89,246,070 98,170,677 107,987,745 118,786,519 130,665,171 143,731,688 158,104,857
18
CM1 (%)20%20%20%20%20%20%20%21%21%21%21%21%21%21%21%21%21%21%21%21%21%21%21%21%21%21%21%21%21%21%21%21%21%21%21%21%21%21%21%21%21%21%21%
19
20
Marketing expenses50000 200,000.00 300,000.00 300,000.00 450,000.00 600,000.00 600,000.00 800,000.00 800,000.00 800,000.00 800,000.00 1,700,000.00 1,200,000.00 1,200,000.00 1,200,000.00 1,200,000.00 1,200,000.00 1,200,000.00 1,200,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,200,000.00 1,440,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,500,000.00 2,250,000.00 3,375,000.00 1,000,000.00 1,000,000.00 1,000,000.00
21
CM2 3,572,568 3,784,824 4,481,789 4,242,700 4,319,835 3,692,851 4,551,422 5,681,706 6,314,876 7,010,614 7,775,138 7,732,652 9,628,449 11,231,705 13,050,237 12,386,260 13,065,573 11,665,771 14,238,925 17,465,709 19,312,280 20,364,800 22,501,280 24,851,407 27,436,548 30,280,203 33,208,223 36,409,046 40,633,950 44,797,345 49,377,080 54,414,788 59,956,267 66,051,893 72,757,083 80,132,791 88,246,070 96,670,677 105,737,745 115,411,519 129,665,171 142,731,688 157,104,857
22
CM2 (%)20%19%19%19%18%17%18%18%18%19%19%17%18%19%19%19%19%19%19%19%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%
23
ROAS 362.3 99.6 79.7 75.7 53.0 35.8 42.9 39.0 42.9 47.2 51.9 26.8 43.7 50.3 57.8 54.9 57.7 51.9 62.3 89.6 98.6 103.6 113.9 125.3 137.9 151.6 139.0 127.4 201.8 222.0 244.2 268.7 295.5 325.1 357.6 393.3 432.7 317.3 232.7 170.6 633.5 696.8 766.5
24
25
Technical costs150000150000150000180000180000180000180000500000500000500000500000500000500000500000500000500000500000500000500000800000800000800000800000800000800000800000800000800000800000800000800000110000011000001100000110000011000001100000110000011000001100000110000011000001100000
26
Salary costs90000090000013500001350000135000016000001600000160000019500001950000195000022000002400000250000025000002700000270000030000003000000300000030000003200000320000032000003200000320000035000003500000350000035000003800000380000038000003800000380000042000004200000420000042000004200000450000045000004500000
27
WA cost for facilitation 155,252.90 170,778.19 204,933.82 194,687.13 204,421.49 183,979.34 220,775.21 264,930.25 291,423.28 320,565.60 352,622.16 387,884.38 446,067.04 512,977.09 589,923.66 560,427.48 588,448.85 529,603.96 635,524.76 762,629.71 838,892.68 880,837.31 968,921.04 1,065,813.15 1,172,394.46 1,289,633.91 1,418,597.30 1,560,457.03 1,716,502.73 1,888,153.01 2,076,968.31 2,284,665.14 2,513,131.65 2,764,444.82 3,040,889.30 3,344,978.23 3,679,476.05 4,047,423.66 4,452,166.02 4,897,382.63 5,387,120.89 5,925,832.98 6,518,416.28
28
Cashbacks and promotions 200,000.00 500,000.00 500,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 500,000.00 500,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 500,000.00 500,000.00 500,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 500,000.00 500,000.00 500,000.00 400000400000400000400000
29
Other 250,000.00 250,000.00 250,000.00 250,000.00 300,000.00 300,000.00 300,000.00 300,000.00 300,000.00 300,000.00 300,000.00 300,000.00 300,000.00 300,000.00 300,000.00 300,000.00 300,000.00 300,000.00 300,000.00 300,000.00 330,000.00 330,000.00 330,000.00 330,000.00 330,000.00 330,000.00 330,000.00 330,000.00 330,000.00 330,000.00 330,000.00 330,000.00 330,000.00 330,000.00 330,000.00 400,000.00 400,000.00 400,000.00 400,000.00 400,000.00 400,000.00 400,000.00 400,000.00
30
Total fixed expenses 1,655,253 1,970,778 2,454,934 2,174,687 2,234,421 2,463,979 2,500,775 2,864,930 3,241,423 3,270,566 3,302,622 3,587,884 3,846,067 4,312,977 4,389,924 4,260,427 4,288,449 4,529,604 4,635,525 5,062,630 5,168,893 5,410,837 5,498,921 5,595,813 5,702,394 6,119,634 6,548,597 6,690,457 6,546,503 6,718,153 7,206,968 7,714,665 7,943,132 8,194,445 8,470,889 9,244,978 9,879,476 10,247,424 10,652,166 10,997,383 11,787,121 12,325,833 12,918,416
31
EBITDA 1,917,315 1,814,046 2,026,855 2,068,013 2,085,413 1,228,872 2,050,646 2,816,776 3,073,453 3,740,048 4,472,516 4,144,767 5,782,382 6,918,728 8,660,313 8,125,833 8,777,124 7,136,167 9,603,400 12,403,079 14,143,387 14,953,962 17,002,358 19,255,594 21,734,154 24,160,569 26,659,626 29,718,589 34,087,448 38,079,192 42,170,111 46,700,123 52,013,135 57,857,448 64,286,193 70,887,813 78,366,594 86,423,253 95,085,578 104,414,136 117,878,050 130,405,855 144,186,440
32
EBITDA (%)11%9%8%9%9%6%8%9%9%10%11%9%11%11%12%12%13%11%13%14%14%14%15%15%16%16%16%16%17%17%17%17%18%18%18%18%18%18%18%18%19%19%19%
33
34
Net cash burn
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
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