Calculation of ROIC Mar-19 Mar-20 Mar-21 Mar-22

Current Assets
Inventories 3,150.00 3,390.00 3,799.00 6,153.00
Trade receivables 1,907.00 1,795.00 2,602.00 3,871.00
Short term loans 16.00 12.00 11.00 8.00
Other asset items 1,456.00 1,727.00 2,555.00 2,869.00
Total Current Assets 6,529.00 6,924.00 8,967.00 12,901.00

Current Liabilities
Trade Payables 2,394.00 2,137.00 3,379.00 4,164.00
Advance from Customers 13.00 29.00 41.00 76.00
Other liability items 2,690.00 2,320.00 2,613.00 2,932.00
Total Current Liabilities 5,097.00 4,486.00 6,033.00 7,172.00

# Net Working Capital 1,432.00 2,438.00 2,934.00 5,729.00

Non-Current Assets
Land 605.00 640.00 644.00 644.00
Building 2,402.00 2,257.00 2,249.00 2,325.00
Plant Machinery 4,006.00 4,208.00 4,340.00 4,531.00
Equipments 221.00 241.00 243.00 253.00
Furniture n fittings 88.00 94.00 99.00 113.00
Vehicles 47.00 43.00 38.00 32.00
Intangible Assets 512.00 505.00 476.00 345.00
Other fixed assets 261.00 293.00 302.00 294.00

Gross Block 8,142.00 8,281.00 8,391.00 8,537.00

Accumulated Depreciation (1,592.00) (2,010.00) (2,533.00) (3,019.00)
Net Non-Current Assets 6,550.00 6,271.00 5,858.00 5,518.00

# Invested Capital 7,982.00 8,709.00 8,792.00 11,247.00

EBIT 1420.82 1753.9 1330.67 2004.27

# ROIC 17.80% 20.14% 15.14% 17.82%

Calculation of Reinvestment Rate Mar-19 Mar-20 Mar-21 Mar-22

Net Capex 1,134.00 367.00 254.00 511.00

Change in Working Capital - 1,006.00 496.00 2,795.00

EBIT 1,420.82 1,753.90 1,330.67 2,004.27

Marginal Tax Rate 0.25 0.25 0.25 0.25
EBIT(1-Tax) 1,065.62 1,315.43 998.00 1,503.20

Reinvestment - 1,373.00 750.00 3,306.00

Reinvestment Rate 104.38% 75.15% 219.93%

4 Year Average
4 Year Median

Calculation of Growth Rate Mar-19 Mar-20 Mar-21 Mar-22

Reinvestment Rate 104.38% 75.15% 219.93%

ROIC 20.14% 15.14% 17.82%
Intrinsic Growth 21.02% 11.37% 39.19%

4 Year Average
4 Year Median
 Mar-23

6,211.00
4,637.00
12.00
3,024.00
13,884.00

3,635.00
108.00
3,657.00
7,400.00

6,484.00

799.00
2,617.00
4,825.00
270.00
146.00
30.00
330.00
289.00

9,306.00
(3,536.00)
5,770.00

12,254.00
2999.9

24.48%

Mar-23

1,420.00
 755.00

2,999.90
0.25
2,249.92

2,175.00
96.67%

124.03%
100.52%

Mar-23

96.67%
24.48%
23.67%

23.81%
22.34%
Particulars Mar-12 Mar-13 Mar-14 Mar-15 Mar-16

Equity Capital 96 96 96 96 96
Reserves 2,653 3,288 3,943 4,646 6,429
Borrowings -
Long term Borrowings 55 47 41 78 73
Short term Borrowings 280 190 199 332 231
Lease Liabilities 0 0 0 0 0
Other Borrowings 6 14 9 8 20
Other Liabilities -
Non controlling int 137 161 246 264 384
Trade Payables 1,333 1,442 1,746 1,549 1,565
Advance from Customers 0 0 0 5 12
Other liability items 1,153 1,547 1,795 1,937 1,750
Total Liabilities 5,712 6,784 8,075 8,914 10,559

Fixed Assets -
Land 225 238 247 251 429
Building 573 874 931 962 923
Plant Machinery 1,070 1,956 2,054 2,132 1,793
Equipments 79 137 155 171 97
Furniture n fittings 50 57 71 83 49
Vehicles 11 11 14 18 11
Intangible Assets 53 57 203 351 339
Other fixed assets 84 99 128 145 103
Gross Block 2,146 3,429 3,804 4,112 3,744
Accumulated Depreciation 834 979 1,223 1,438 275
Net Block 1,312 2,450 2,581 2,674 3,469

CWIP 617 59 72 196 107

Investments 355 296 1,424 1,588 2,712

Other Assets -
Inventories 1,599 1,830 2,070 2,259 1,998
Trade receivables 781 981 1,110 1,182 1,187
Cash Equivalents 624 737 229 204 424
Short term loans 6 4 7 9 9
Other asset items 430 436 603 817 705
Total Assets 5,712 6,784 8,075 8,914 10,559

Cash from Operating Activity - 710 1,187 1,402 1,188 2,243

Profit from operations 1,539 1,784 2,051 2,271 2,848
Receivables -305 -299 -254 -155 -146
Inventory -293 -247 -231 -144 202
Payables 188 388 317 -151 142
Other WC items 0 0 0 0 0
Working capital changes -410 -159 -168 -450 198
Direct taxes -430 -438 -480 -633 -802
Exceptional CF items 10 0 0 0 0
Cash from Investing Activity - -386 -463 -586 -465 -866
Fixed assets purchased -546 -644 -251 -454 -817
Fixed assets sold 6 7 16 16 15
Investments purchased -290 -247 -872 -243 -282
Investments sold 398 330 463 278 205
Interest received 6 11 14 11 15
Dividends received 42 33 65 71 69
Investment in group cos 0 0 0 0 0
Redemp n Canc of Shares 0 0 0 0 0
Acquisition of companies 0 0 0 0 0
Other investing items -1 46 -21 -144 -70
Cash from Financing Activity - -327 -601 -626 -576 -849
Proceeds from borrowings 109 33 44 239 8
Repayment of borrowings -12 -135 -81 -86 -119
Interest paid fin -40 -37 -42 -35 -40
Dividends paid -383 -462 -547 -695 -764
Financial liabilities 0 0 0 0 0
Other financing items 0 0 0 0 66
Net Cash Flow -2 123 190 147 528
Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23

96 96 96 96 96 96 96
7,508 8,314 9,375 10,034 12,710 13,716 15,896

41 28 19 19 15 45 76
504 492 597 321 334 731 896
0 0 693 764 745 811 960
15 13 11 15 0 0 0

375 328 361 404 423 388 454

1,923 2,160 2,394 2,137 3,379 4,164 3,635
17 16 13 29 41 76 108
1,925 2,316 2,690 2,320 2,613 2,932 3,657
12,405 13,763 16,249 16,138 20,355 22,958 25,779

408 586 605 640 644 644 799

931 957 2,402 2,257 2,249 2,325 2,617
1,980 2,157 4,006 4,208 4,340 4,531 4,825
119 200 221 241 243 253 270
59 72 88 94 99 113 146
14 27 47 43 38 32 30
276 468 512 505 476 345 330
128 238 261 293 302 294 289
3,914 4,705 8,141 8,282 8,392 8,538 9,307
610 973 1,592 2,010 2,533 3,019 3,536
3,304 3,732 6,549 6,272 5,859 5,519 5,771

258 1,405 210 140 183 426 1,020

2,652 2,141 2,569 2,019 4,737 3,248 4,262

2,627 2,658 3,150 3,390 3,799 6,153 6,211

1,447 1,731 1,907 1,795 2,602 3,871 4,637
801 405 445 783 611 864 844
14 13 16 12 11 8 12
1,303 1,678 1,456 1,727 2,555 2,869 3,024
12,405 13,763 16,249 16,138 20,355 22,958 25,779

1,527 2,113 2,470 3,038 3,683 986 4,193

3,056 3,274 3,861 4,380 4,970 4,957 6,460
-475 -483 -205 160 -849 -1,326 -834
-629 -39 -492 -251 -409 -2,354 -56
501 442 287 -241 1,143 644 -539
 0 0 0 0 -92 242 657
-603 -80 -410 -331 -206 -2,795 -772
-925 -1,081 -982 -1,011 -1,080 -1,176 -1,494
0 0 0 0 0 0 0
-681 -1,556 -918 -518 -541 -317 -1,282
-684 -1,426 -1,151 -404 -282 -551 -1,446
17 17 17 37 28 40 26
-153 -320 -573 -25 -140 0 -146
357 362 733 134 272 207 446
32 39 40 65 73 77 87
74 38 40 27 8 15 56
0 0 0 0 0 0 -180
0 141 0 0 0 0 0
0 -525 0 0 0 0 0
-324 118 -24 -353 -500 -105 -126
-756 -1,379 -1,117 -2,871 -650 -1,808 -2,140
271 10 243 18 155 418 254
-58 -54 -26 -279 -14 -8 -25
-36 -35 -106 -101 -89 -94 -142
-947 -1,218 -1,049 -2,121 -499 -1,763 -1,936
0 0 -180 -179 -203 -221 -256
13 -82 0 -209 0 -140 -36
90 -822 434 -351 2,492 -1,138 771
 Historical Financial Statements - AVENU
Year Mar-14 Mar-15 Mar-16 Mar-17

# Income Statement
Sales ₹ 4,686.5 ₹ 6,439.4 ₹ 8,583.8 ₹ 11,897.7
Sales Growth - 37.40% 33.30% 38.61%

COGS ₹ 4,240.6 ₹ 5,835.9 ₹ 7,773.2 ₹ 10,706.0

COGS % Sales 90.49% 90.63% 90.56% 89.98%

Gross Profit ₹ 445.9 ₹ 603.5 ₹ 810.6 ₹ 1,191.7

Gross Profit % Sales 9.51% 9.37% 9.44% 10.02%

Selling & General Expenses ₹ 104.6 ₹ 147.2 ₹ 146.1 ₹ 222.5

S&G Exp % Sales 2.23% 2.29% 1.70% 1.87%

EBITDA ₹ 341.28 ₹ 456.26 ₹ 664.46 ₹ 969.18

EBITDA Margins 7.28% 7.09% 7.74% 8.15%

Interest ₹ 55.7 ₹ 72.4 ₹ 91.3 ₹ 122.0

Interest % Sales 1.19% 1.12% 1.06% 1.03%

Depreciation ₹ 57.0 ₹ 81.5 ₹ 98.4 ₹ 127.8

Depreciation % Sales 1.22% 1.27% 1.15% 1.07%

EBT ₹ 228.6 ₹ 302.4 ₹ 474.7 ₹ 719.4

EBT % Sales 4.88% 4.70% 5.53% 6.05%

Tax ₹ 83.5 ₹ 110.9 ₹ 171.5 ₹ 268.3

Effective Tax rate 36.52% 36.68% 36.12% 37.29%

Net Profit ₹ 145.1 ₹ 191.4 ₹ 303.2 ₹ 451.1

Net margins 3.10% 2.97% 3.53% 3.79%

No. of Equity Shares 54.68 56.15 56.15 62.41

Earnings Per Share ₹ 2.7 ₹ 3.4 ₹ 5.4 ₹ 7.2

EPS Growth % - 28.47% 58.39% 33.85%

Dividend per share - - - -

Dividend Payout Ratio 0.00% 0.00% 0.00% 0.00%

Retained Earnings 100.00% 100.00% 100.00% 100.00%

# Balance Sheet
Equity Share Capital ₹ 546.8 ₹ 561.5 ₹ 561.5 ₹ 624.1
Reserves ₹ 408.8 ₹ 637.7 ₹ 958.9 ₹ 3,217.7
 Borrowings ₹ 640.8 ₹ 904.3 ₹ 1,192.3 ₹ 1,497.3
Other Liabilities ₹ 211.3 ₹ 251.4 ₹ 388.8 ₹ 480.2
Total Liabilities ₹ 1,807.7 ₹ 2,354.8 ₹ 3,101.6 ₹ 5,819.3

Fixed Assets Net Block ₹ 1,171.7 ₹ 1,528.1 ₹ 2,093.5 ₹ 2,577.8

Capital Work in Progress ₹ 88.8 ₹ 98.1 ₹ 81.7 ₹ 152.9
Investments ₹ 15.5 ₹ 15.2 ₹ 29.3 ₹ 25.7
Other Assets ₹ 88.4 ₹ 128.7 ₹ 181.8 ₹ 209.8
Total Non-Currents Assets ₹ 1,364.4 ₹ 1,770.1 ₹ 2,386.4 ₹ 2,966.1

Receivables ₹ 9.5 ₹ 7.1 ₹ 8.4 ₹ 21.0

Inventory ₹ 378.3 ₹ 539.6 ₹ 671.7 ₹ 947.9
Cash & Bank ₹ 55.4 ₹ 38.0 ₹ 35.1 ₹ 1,884.3
Total Current Assets ₹ 443.3 ₹ 584.7 ₹ 715.2 ₹ 2,853.2

Total Assets ₹ 1,807.6 ₹ 2,354.8 ₹ 3,101.6 ₹ 5,819.3

Check 1 1 1 1

# Cash Flow Statement

Operating Activities
Profit from operations ₹ 36,303.0 ₹ 43,397.0 ₹ 38,626.0 ₹ 28,840.0
Receivables ₹ 445.0 ₹ (3,179.0) ₹ (2,223.0) ₹ (4,152.0)
Inventory ₹ (2,853.0) ₹ (3,692.0) ₹ (5,743.0) ₹ (6,621.0)
Payables ₹ 4,694.0 ₹ 3,598.0 ₹ 3,947.0 ₹ 9,301.0
Loans Advances - - ₹ (520.0) -
Other WC items ₹ 1,870.0 ₹ (398.0) ₹ 5,852.0 ₹ 4,727.0
Working capital changes ₹ 4,157.0 ₹ (3,672.0) ₹ 1,313.0 ₹ 3,254.0
Direct taxes ₹ (4,308.0) ₹ (4,194.0) ₹ (2,040.0) ₹ (1,895.0)
Cash From Operating Activities ₹ 40,308.0 ₹ 31,860.0 ₹ 39,212.0 ₹ 33,454.0

Investing Activities
Fixed assets purchased ₹ (26,975.0) ₹ (31,962.0) ₹ (31,503.0) ₹ (16,072.0)
Fixed assets sold ₹ 50.0 ₹ 74.0 ₹ 59.0 ₹ 53.0
Investments purchased ₹ (429.0) ₹ (5,461.0) ₹ (4,728.0) ₹ (6.0)
Investments sold ₹ 4.0 ₹ 42.0 ₹ 89.0 ₹ 1,965.0
Interest received ₹ 653.0 ₹ 698.0 ₹ 731.0 ₹ 638.0
Dividends received ₹ 40.0 ₹ 80.0 ₹ 58.0 ₹ 620.0
Invest in subsidiaries - - - -
Investment in group cos - ₹ (160.0) - ₹ (107.0)
Redemp n Canc of Shares - - - -
Acquisition of companies ₹ (185.0) - ₹ (111.0) -
Inter corporate deposits - - - -
Other investing items ₹ (1,149.0) ₹ 456.0 ₹ (1,289.0) ₹ (26,663.0)
Cash From Investing Activities ₹ (27,991.0) ₹ (36,233.0) ₹ (36,694.0) ₹ (39,572.0)

Financing Activities
Proceeds from shares - - ₹ 7,433.0 ₹ 5.0
Redemption of debentures ₹ (658.0) ₹ (744.0) - -
Proceeds from borrowings ₹ 33,258.0 ₹ 36,363.0 ₹ 19,519.0 ₹ 33,390.0
Repayment of borrowings ₹ (29,141.0) ₹ (23,332.0) ₹ (24,924.0) ₹ (21,732.0)
Interest paid fin ₹ (6,171.0) ₹ (6,307.0) ₹ (5,716.0) ₹ (5,336.0)
Dividends paid ₹ (722.0) ₹ (720.0) ₹ (108.0) ₹ (121.0)
Financial liabilities - - - -
Other financing items ₹ (450.0) ₹ (57.0) - -
Cash From Financing Activities ₹ (3,884.0) ₹ 5,203.0 ₹ (3,796.0) ₹ 6,206.0

Net Cash Flow ₹ 8,433.0 ₹ 830.0 ₹ (1,278.0) ₹ 88.0

nancial Statements - AVENUE SUPERMARTS LTD
Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23

₹ 15,033.2 ₹ 20,004.5 ₹ 24,870.2 ₹ 24,143.1 ₹ 30,976.3 ₹ 42,839.6

26.35% 33.07% 24.32% (2.92%) 28.30% 38.30%

₹ 13,413.8 ₹ 18,009.5 ₹ 22,394.3 ₹ 22,012.9 ₹ 28,028.5 ₹ 38,563.3

89.23% 90.03% 90.04% 91.18% 90.48% 90.02%

₹ 1,619.4 ₹ 1,995.0 ₹ 2,475.9 ₹ 2,130.2 ₹ 2,947.8 ₹ 4,276.3

10.77% 9.97% 9.96% 8.82% 9.52% 9.98%

₹ 266.6 ₹ 361.7 ₹ 347.6 ₹ 385.3 ₹ 445.5 ₹ 637.5

1.77% 1.81% 1.40% 1.60% 1.44% 1.49%

₹ 1,352.86 ₹ 1,633.31 ₹ 2,128.31 ₹ 1,744.83 ₹ 2,502.35 ₹ 3,638.77

9.00% 8.16% 8.56% 7.23% 8.08% 8.49%

₹ 59.5 ₹ 47.2 ₹ 69.1 ₹ 41.7 ₹ 53.8 ₹ 67.4

0.40% 0.24% 0.28% 0.17% 0.17% 0.16%

₹ 159.0 ₹ 212.5 ₹ 374.4 ₹ 414.2 ₹ 498.1 ₹ 638.9

1.06% 1.06% 1.51% 1.72% 1.61% 1.49%

₹ 1,134.3 ₹ 1,373.6 ₹ 1,684.8 ₹ 1,289.0 ₹ 1,950.5 ₹ 2,932.5

7.55% 6.87% 6.77% 5.34% 6.30% 6.85%

₹ 415.8 ₹ 519.5 ₹ 443.8 ₹ 384.0 ₹ 571.7 ₹ 681.8

36.66% 37.82% 26.34% 29.79% 29.31% 23.25%

₹ 718.5 ₹ 854.1 ₹ 1,241.0 ₹ 905.0 ₹ 1,378.8 ₹ 2,250.7

4.78% 4.27% 4.99% 3.75% 4.45% 5.25%

62.41 62.41 64.78 64.78 64.78 64.83

₹ 11.5 ₹ 13.7 ₹ 19.2 ₹ 14.0 ₹ 21.3 ₹ 34.7

59.28% 18.87% 39.98% (27.07%) 52.35% 63.12%

- - - - - -
0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

₹ 624.1 ₹ 624.1 ₹ 647.8 ₹ 647.8 ₹ 647.8 ₹ 648.3

₹ 4,045.0 ₹ 4,963.4 ₹ 10,432.0 ₹ 11,535.9 ₹ 13,029.9 ₹ 15,430.4
 ₹ 439.3 ₹ 700.2 ₹ 333.2 ₹ 392.7 ₹ 646.9 ₹ 643.0
₹ 539.9 ₹ 717.9 ₹ 663.2 ₹ 1,078.6 ₹ 1,146.4 ₹ 1,382.8
₹ 5,648.2 ₹ 7,005.5 ₹ 12,076.2 ₹ 13,655.1 ₹ 15,471.0 ₹ 18,104.5

₹ 3,400.0 ₹ 4,400.4 ₹ 5,948.0 ₹ 7,008.8 ₹ 9,260.0 ₹ 11,340.5

₹ 147.1 ₹ 376.8 ₹ 364.4 ₹ 1,019.6 ₹ 1,129.3 ₹ 829.2
₹ 68.2 ₹ 16.5 ₹ 14.7 ₹ 3.0 ₹ 5.9 ₹ 202.2
₹ 275.8 ₹ 319.7 ₹ 3,674.2 ₹ 1,886.3 ₹ 1,967.6 ₹ 1,018.7
₹ 3,891.1 ₹ 5,113.4 ₹ 10,001.3 ₹ 9,917.6 ₹ 12,362.9 ₹ 13,390.6

₹ 33.5 ₹ 64.4 ₹ 19.6 ₹ 43.6 ₹ 66.9 ₹ 62.2

₹ 1,163.5 ₹ 1,608.7 ₹ 1,947.4 ₹ 2,248.3 ₹ 2,742.7 ₹ 3,243.5
₹ 560.2 ₹ 219.1 ₹ 107.9 ₹ 1,445.6 ₹ 298.6 ₹ 1,408.3
₹ 1,757.2 ₹ 1,892.1 ₹ 2,074.8 ₹ 3,737.4 ₹ 3,108.1 ₹ 4,714.0

₹ 5,648.2 ₹ 7,005.5 ₹ 12,076.2 ₹ 13,655.1 ₹ 15,471.0 ₹ 18,104.5

1 1 1 1 1 TRUE

₹ 33,312.0 ₹ 28,771.0 ₹ 23,352.0 ₹ 31,198.0 ₹ 26,943.0 ₹ 41,694.0

₹ (10,688.0) ₹ (9,109.0) ₹ 9,950.0 ₹ (5,505.0) ₹ 185.0 ₹ (2,213.0)
₹ (3,560.0) ₹ 2,069.0 ₹ 2,326.0 ₹ 3,814.0 ₹ 472.0 ₹ (5,665.0)
₹ 7,320.0 ₹ (4,692.0) ₹ (8,085.0) ₹ 5,748.0 ₹ (7,012.0) ₹ 6,945.0
- - - - - -
₹ 494.0 ₹ 4,512.0 ₹ 875.0 ₹ (4,150.0) ₹ (4,396.0) ₹ (2,194.0)
₹ (6,434.0) ₹ (7,221.0) ₹ 5,065.0 ₹ (93.0) ₹ (10,750.0) ₹ (3,127.0)
₹ (3,021.0) ₹ (2,659.0) ₹ (1,785.0) ₹ (2,105.0) ₹ (1,910.0) ₹ (3,179.0)
₹ 17,423.0 ₹ 11,671.0 ₹ 31,698.0 ₹ 28,907.0 ₹ 3,532.0 ₹ 32,261.0

₹ (35,079.0) ₹ (35,304.0) ₹ (29,702.0) ₹ (20,205.0) ₹ (15,168.0) ₹ (19,230.0)

₹ 30.0 ₹ 67.0 ₹ 171.0 ₹ 351.0 ₹ 230.0 ₹ 285.0
₹ (329.0) ₹ (130.0) ₹ (1,439.0) ₹ (7,530.0) ₹ (3,008.0) ₹ (50.0)
₹ 2,381.0 ₹ 5,644.0 ₹ 21.0 ₹ 226.0 ₹ 104.0 ₹ 6,895.0
₹ 690.0 ₹ 761.0 ₹ 1,104.0 ₹ 428.0 ₹ 653.0 ₹ 973.0
₹ 1,797.0 ₹ 232.0 ₹ 21.0 ₹ 18.0 ₹ 32.0 ₹ 46.0
- - - - - -
₹ (4.0) ₹ (9.0) ₹ (606.0) ₹ (10.0) - -
₹ 14.0 ₹ 533.0 - - - ₹ 19.0
- ₹ (8.0) ₹ (27.0) - ₹ (98.0) -
- - - - - -
₹ 5,360.0 ₹ 7,335.0 ₹ (2,659.0) ₹ 1,051.0 ₹ 12,813.0 ₹ (4,357.0)
₹ (25,140.0) ₹ (20,879.0) ₹ (33,116.0) ₹ (25,671.0) ₹ (4,442.0) ₹ (15,419.0)

- - ₹ 3,889.0 ₹ 2,603.0 ₹ 19.0 ₹ 20.0

 - - - - - -
₹ 37,482.0 ₹ 51,128.0 ₹ 38,297.0 ₹ 46,641.0 ₹ 46,578.0 ₹ 43,934.0
₹ (29,964.0) ₹ (35,198.0) ₹ (29,847.0) ₹ (29,709.0) ₹ (42,816.0) ₹ (62,557.0)
₹ (5,411.0) ₹ (7,005.0) ₹ (7,518.0) ₹ (8,123.0) ₹ (9,251.0) ₹ (9,336.0)
₹ (96.0) ₹ (95.0) ₹ (57.0) ₹ (30.0) ₹ (100.0) ₹ (141.0)
- - ₹ (1,346.0) ₹ (1,477.0) ₹ (1,559.0) ₹ (1,517.0)
- - ₹ (29.0) - ₹ 3,750.0 ₹ 3,355.0
₹ 2,011.0 ₹ 8,830.0 ₹ 3,389.0 ₹ 9,905.0 ₹ (3,379.0) ₹ (26,242.0)

₹ (5,706.0) ₹ (378.0) ₹ 1,971.0 ₹ 13,141.0 ₹ (4,289.0) ₹ (9,400.0)

 LTM

₹ 48,656.4
13.58%

₹ 44,724.8
91.92%

₹ 3,931.6
8.08%

-
0.00%

₹ 3,931.64
8.08%

₹ 60.2
0.12%

₹ 690.0
1.42%

₹ 3,181.4
6.54%

₹ 890.5
27.99%

₹ 2,290.9
4.71%

64.83

₹ 35.3
1.79%

-
0.00%

100.00%
COMPANY NAME AVENUE SUPERMARTS LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 64.96
Face Value 10
Current Price 4420.55
Market Capitalization 287170.12

PROFIT & LOSS

Report Date Mar-14 Mar-15 Mar-16 Mar-17
Sales 4686.48 6439.43 8583.76 11897.7
Raw Material Cost 4086.53 5648.47 7435.62 10357.25
Change in Inventory 102.1 161.28 132.08 276.22
Power and Fuel 45.31 59.33 79.24 99.41
Other Mfr. Exp 123.53 155.35 241.36 332.9
Employee Cost 87.34 134.06 149.04 192.67
Selling and admin 420.11 582.8 647.37 71.24
Other Expenses -315.52 -435.56 -501.25 151.27
Other Income 16.27 20.27 17.02 27.7
Depreciation 57.01 81.54 98.43 127.82
Interest 55.68 72.36 91.34 121.98
Profit before tax 244.86 322.63 491.71 747.08
Tax 83.48 110.92 171.47 268.28
Net profit 161.37 211.67 320.24 478.75
Dividend Amount

Quarters
Report Date Sep-21 Dec-21 Mar-22 Jun-22
Sales 7788.94 9217.76 8786.45 10038.07
Expenses 7120.36 8351.3 8047.17 9029.83
Other Income 27.5 25.96 32.57 29.14
Depreciation 116.01 128.3 146.33 144.74
Interest 12.37 13.95 16.63 17.22
Profit before tax 567.7 750.17 608.89 875.42
Tax 149.94 197.64 182.14 232.53
Net profit 417.79 552.56 426.83 642.93
Operating Profit 668.58 866.46 739.28 1008.24

BALANCE SHEET
Report Date Mar-14 Mar-15 Mar-16 Mar-17
Equity Share Capital 546.75 561.54 561.54 624.08
Reserves 408.82 637.65 958.9 3217.7
Borrowings 640.82 904.26 1192.34 1497.32
Other Liabilities 211.26 251.36 388.78 480.18
Total 1807.65 2354.81 3101.56 5819.28
Net Block 1171.69 1528.08 2093.52 2577.75
Capital Work in Progress 88.78 98.12 81.69 152.89
Investments 15.54 15.23 29.33 25.69
Other Assets 531.64 713.38 897.02 3062.95
Total 1807.65 2354.81 3101.56 5819.28
Receivables 9.54 7.07 8.42 21
Inventory 378.33 539.61 671.69 947.9
Cash & Bank 55.41 38.04 35.1 1884.29
No. of Equity Shares 546752880 561542680 561542680 624084486
New Bonus Shares
Face value 10 10 10 10

CASH FLOW:
Report Date Mar-14 Mar-15 Mar-16 Mar-17
Cash from Operating Activity 198.14 222.02 433.47 455.28
Cash from Investing Activity -270.17 -473.88 -632.89 -2481.61
Cash from Financing Activity 65.23 234.45 196.44 2025.26
Net Cash Flow -6.8 -17.41 -2.98 -1.07

PRICE: 637.85

DERIVED:
Adjusted Equity Shares in Cr 54.68 56.15 56.15 62.41
 PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET

Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23

15033.2 20004.52 24870.2 24143.06 30976.27 42839.56
12846.95 17445.49 21441.68 20855.56 26891.77 36884.77
211.31 444.65 338.75 300.88 494.38 500.82
121.26 152.8 188.24 174.2 207.86 314.62
373.72 499.72 645.96 746.43 805.85 1116.56
283.14 356.17 457.14 537.58 617.36 748.16
96 135.84 119.23 108.69 143.41 212.04
170.58 225.84 228.39 276.65 302.05 425.46
87.75 48.33 59.99 194.43 113.64 127.6
159 212.49 374.41 414.16 498.08 638.87
59.54 47.21 69.12 41.65 53.79 67.41
1222.07 1421.94 1744.77 1483.45 2064.12 3060.09
415.79 519.48 443.79 384.02 571.72 681.75
806.26 902.54 1301.08 1099.49 1492.55 2378.51

Sep-22 Dec-22 Mar-23 Jun-23 Sep-23 Dec-23

10638.33 11569.05 10594.11 11865.44 12624.37 13572.47
9746.31 10603.79 9822.6 10830.17 11619.4 12452.58
35.57 31.56 33.07 38.74 36.92 32.92
161.96 168.09 164.08 162.18 174.36 189.33
17.68 16.98 15.53 14.57 15.59 14.55
747.95 811.75 624.97 897.26 851.94 948.93
62.24 222.11 164.87 238.55 228.59 258.52
 685.77 589.68 460.13 658.75 623.56 690.61
892.02 965.26 771.51 1035.27 1004.97 1119.89

Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23

624.08 624.08 647.77 647.77 647.77 648.26
4044.97 4963.37 10431.97 11535.94 13029.87 15430.44
439.25 700.15 333.19 392.71 646.94 642.98
539.92 717.9 663.23 1078.63 1146.4 1382.84
5648.22 7005.5 12076.16 13655.05 15470.98 18104.52
3399.97 4400.37 5948.03 7008.8 9260.02 11340.48
147.07 376.84 364.4 1019.59 1129.34 829.16
68.18 16.53 14.68 2.95 5.94 202.2
2033 2211.76 5749.05 5623.71 5075.68 5732.68
5648.22 7005.5 12076.16 13655.05 15470.98 18104.52
33.52 64.37 19.55 43.58 66.89 62.16
1163.45 1608.65 1947.4 2248.28 2742.66 3243.48
560.18 219.07 107.88 1445.58 298.58 1408.33
624084486 624084486 647774691 647774691 647774691 648263978

10 10 10 10 10 10

Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23

729.99 806.84 1280.14 1375.14 1372.35 2630.27
463.55 -958.37 -4656.56 -1110 -1289.49 -2313.1
-1159.06 208.98 3357.42 -179.5 -179.24 -205.14
34.48 57.45 -19 85.64 -96.38 112.03

1324.8 1471.1 2187.5 2859.05 4003.35 3401.05

62.41 62.41 64.78 64.78 64.78 64.83