AVENUE SUPERMARTS LTD SCREENER.

IN

Narration Dec-99 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23
Sales - 2,208.56 3,340.85 4,686.48 6,439.43 8,583.76 11,897.70 15,033.20 20,004.52 24,870.20 31,799.33 40,659.01 51,987.09
Expenses - 2,070.53 3,125.84 4,344.77 5,981.16 7,920.15 10,929.38 13,680.39 18,371.23 22,741.89
Operating Profit - 138.03 215.01 341.71 458.27 663.61 968.32 1,352.81 1,633.29 2,128.31
Other Income - 14.19 14.50 15.84 18.26 17.87 28.56 87.80 48.35 59.99
Depreciation - 37.47 45.79 57.01 81.54 98.43 127.82 159.00 212.49 374.41
Interest - 26.02 42.59 55.68 72.36 91.34 121.98 59.54 47.21 69.12
Profit before tax - 88.73 141.13 244.86 322.63 491.71 747.08 1,222.07 1,421.94 1,744.77
Tax - 28.33 47.28 83.48 110.92 171.47 268.28 415.79 519.48 443.79
Net profit - 60.41 93.86 161.37 211.67 320.24 478.75 806.26 902.54 1,301.08
EPS - 1.13 1.73 2.95 3.77 5.70 7.67 12.92 14.46 20.08
Price to earning 83.15 102.55 101.73 108.91
Price - - - - - - 637.85 1,324.80 1,471.10 2,187.50 2,291.90 2,291.90 2,396.29

RATIOS:
Dividend Payout 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
OPM 0.00% 6.25% 6.44% 7.29% 7.12% 7.73% 8.14% 9.00% 8.16% 8.56% 9.29% 10.15% 11.09%

TRENDS: 10 YEARS 7 YEARS 5 YEARS 3 YEARS RECENT BEST WORST

Sales Growth 33.21% 31.03% 27.86% 27.86% 27.86% 27.86%
OPM 8.14% 8.25% 8.39% 8.54% 9.29% 9.29% 8.14%
Price to Earning 99.08 99.08 99.08 104.40 - 104.40 -
AVENUE SUPERMARTS LTD [Link]

Narration Jun-18 Sep-18 Dec-18 Mar-19 Jun-19 Sep-19 Dec-19 Mar-20 Jun-20 Sep-20
Sales 4,575.79 4,892.81 5,474.27 5,061.65 5,814.56 5,990.78 6,808.93 6,255.93 3,883.18 5,306.20
Expenses 4,152.68 4,504.67 5,024.56 4,689.32 5,217.80 5,473.30 6,212.19 5,838.60 3,771.41 4,976.70
Operating Profit 423.11 388.14 449.71 372.33 596.76 517.48 596.74 417.33 111.77 329.50
Other Income 13.57 13.73 7.81 13.24 10.95 8.12 6.07 34.85 50.60 52.17
Depreciation 43.42 47.56 55.66 65.85 82.69 91.91 95.24 104.57 94.78 100.72
Interest 10.04 10.17 14.96 12.04 18.15 19.01 17.60 14.36 8.82 9.27
Profit before tax 383.22 344.14 386.90 307.68 506.87 414.68 489.97 333.25 58.77 271.68
Tax 138.24 125.47 139.67 116.11 183.81 92.05 105.96 61.97 18.69 73.15
Net profit 245.01 218.69 247.25 191.58 323.09 322.66 384.04 271.29 40.09 198.55

OPM 9% 8% 8% 7% 10% 9% 9% 7% 3% 6%
AVENUE SUPERMARTS LTD [Link]

Narration Dec-99 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23
Equity Share Capital - 533.54 544.06 546.75 561.54 561.54 624.08 624.08 624.08 647.77
Reserves - 148.15 245.48 408.82 637.65 958.90 3,217.70 4,044.97 4,963.37 10,431.97
Borrowings - 380.68 526.06 640.82 904.26 1,192.34 1,497.32 439.25 700.15 333.19
Other Liabilities - 128.50 176.47 211.26 251.36 388.78 480.18 539.92 717.90 663.23
Total - 1,190.87 1,492.07 1,807.65 2,354.81 3,101.56 5,819.28 5,648.22 7,005.50 12,076.16

Net Block - 779.07 924.67 1,171.69 1,528.08 2,093.52 2,577.75 3,399.97 4,400.37 5,948.03 7,605.15 9,723.95 12,433.04
Capital Work in Progress - 84.94 118.11 88.78 98.12 81.69 152.89 147.07 376.84 364.40
Investments - 22.68 15.96 15.54 15.23 29.33 25.69 68.18 16.53 14.68
Other Assets - 304.18 433.33 531.64 713.38 897.02 3,062.95 2,033.00 2,211.76 5,749.05
Total - 1,190.87 1,492.07 1,807.65 2,354.81 3,101.56 5,819.28 5,648.22 7,005.50 12,076.16

Working Capital - 175.68 256.86 320.38 462.02 508.24 2,582.77 1,493.08 1,493.86 5,085.82
Debtors - 5.63 13.29 9.54 7.07 8.42 21.00 33.52 64.37 19.55
Inventory - 195.74 276.23 378.33 539.61 671.69 947.90 1,163.45 1,608.65 1,947.40

Debtor Days - 0.93 1.45 0.74 0.40 0.36 0.64 0.81 1.17 0.29
Inventory Turnover - 11.28 12.09 12.39 11.93 12.78 12.55 12.92 12.44 12.77

Return on Equity 9% 12% 17% 18% 21% 12% 17% 16% 12%
Return on Capital Emp 22% 15% 21% 21% 24% 22% 25% 26% 20%
AVENUE SUPERMARTS LTD Assuming non covid scenario [Link]

Narration Dec-99 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20
Cash from Operating Activity - 65.36 127.09 198.14 222.02 433.47 455.28 729.99 806.84 1,280.14
Cash from Investing Activity - -128.92 -230.89 -270.17 -473.88 -632.89 -2,481.61 463.55 -958.37 -4,656.56
Cash from Financing Activity - 93.49 117.54 65.23 234.45 196.44 2,025.26 -1,159.06 208.98 3,357.42
Net Cash Flow - 29.94 13.74 -6.80 -17.41 -2.98 -1.07 34.48 57.45 -19.00
How to use it?
You can customize this workbook as you want.
You can add custom formating, add conditional formating, add your own formulas… do ANYTHING.
Please don't edit the "Data Sheet" only.

After customization, you can upload this back on Screener.

Upload on: [Link]

Download your customized workbooks now onwards.

Now whenever you will "Export to excel" from Screener, it will export your customized file.

TESTING:
This is a testing feature currently.
You can report any formula errors on the worksheet at: [Link]@[Link]
COMPANY NAME AVENUE SUPERMARTS LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 64.78
Face Value 10.00
Current Price 2,294.60
Market Capitalization 148,638.38

PROFIT & LOSS

Report Date Mar-12 Mar-13 Mar-14
Sales 2,208.56 3,340.85 4,686.48
Raw Material Cost 1,956.77 2,937.93 4,086.53
Change in Inventory 72.81 80.49 102.10
Power and Fuel 22.58 34.84 45.31
Other Mfr. Exp 56.56 84.30 123.53
Employee Cost 45.31 68.67 87.34
Selling and admin 217.25 306.10 420.11
Other Expenses -155.13 -225.51 -315.95
Other Income 14.19 14.50 15.84
Depreciation 37.47 45.79 57.01
Interest 26.02 42.59 55.68
Profit before tax 88.73 141.13 244.86
Tax 28.33 47.28 83.48
Net profit 60.41 93.86 161.37
Dividend Amount

Quarters
Report Date Jun-18 Sep-18 Dec-18 Mar-19
Sales 4,575.79 4,892.81 5,474.27 5,061.65
Expenses 4,152.68 4,504.67 5,024.56 4,689.32
Other Income 13.57 13.73 7.81 13.24
Depreciation 43.42 47.56 55.66 65.85
Interest 10.04 10.17 14.96 12.04
Profit before tax 383.22 344.14 386.90 307.68
Tax 138.24 125.47 139.67 116.11
Net profit 245.01 218.69 247.25 191.58
Operating Profit 423.11 388.14 449.71 372.33
BALANCE SHEET
Report Date Mar-12 Mar-13 Mar-14
Equity Share Capital 533.54 544.06 546.75
Reserves 148.15 245.48 408.82
Borrowings 380.68 526.06 640.82
Other Liabilities 128.50 176.47 211.26
Total 1,190.87 1,492.07 1,807.65
Net Block 779.07 924.67 1,171.69
Capital Work in Progress 84.94 118.11 88.78
Investments 22.68 15.96 15.54
Other Assets 304.18 433.33 531.64
Total 1,190.87 1,492.07 1,807.65
Receivables 5.63 13.29 9.54
Inventory 195.74 276.23 378.33
Cash & Bank 47.92 61.62 55.41
No. of Equity Shares ### ### ###
New Bonus Shares
Face value 10.00 10.00 10.00

CASH FLOW:
Report Date Mar-12 Mar-13 Mar-14
Cash from Operating Activity 65.36 127.09 198.14
Cash from Investing Activity -128.92 -230.89 -270.17
Cash from Financing Activity 93.49 117.54 65.23
Net Cash Flow 29.94 13.74 -6.80

PRICE:

DERIVED:
Adjusted Equity Shares in Cr - 53.35 54.41 54.68
 PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET

Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20

6,439.43 8,583.76 11,897.70 15,033.20 20,004.52 24,870.20
5,648.47 7,435.62 10,357.25 12,846.95 17,445.49 21,441.68
161.28 132.08 276.22 211.31 444.65 338.75
59.33 79.24 99.41 121.26 152.80 188.24
155.35 241.36 332.90 373.72 499.72 645.96
134.06 149.04 192.67 283.14 356.17 457.14
582.80 647.37 71.24 96.00 135.84 66.40
-437.57 -500.40 152.13 170.63 225.86 281.22
18.26 17.87 28.56 87.80 48.35 59.99
81.54 98.43 127.82 159.00 212.49 374.41
72.36 91.34 121.98 59.54 47.21 69.12
322.63 491.71 747.08 1,222.07 1,421.94 1,744.77
110.92 171.47 268.28 415.79 519.48 443.79
211.67 320.24 478.75 806.26 902.54 1,301.08

Jun-19 Sep-19 Dec-19 Mar-20 Jun-20 Sep-20

5,814.56 5,990.78 6,808.93 6,255.93 3,883.18 5,306.20
5,217.80 5,473.30 6,212.19 5,838.60 3,771.41 4,976.70
10.95 8.12 6.07 34.85 50.60 52.17
82.69 91.91 95.24 104.57 94.78 100.72
18.15 19.01 17.60 14.36 8.82 9.27
506.87 414.68 489.97 333.25 58.77 271.68
183.81 92.05 105.96 61.97 18.69 73.15
323.09 322.66 384.04 271.29 40.09 198.55
596.76 517.48 596.74 417.33 111.77 329.50
Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20
561.54 561.54 624.08 624.08 624.08 647.77
637.65 958.90 3,217.70 4,044.97 4,963.37 10,431.97
904.26 1,192.34 1,497.32 439.25 700.15 333.19
251.36 388.78 480.18 539.92 717.90 663.23
2,354.81 3,101.56 5,819.28 5,648.22 7,005.50 12,076.16
1,528.08 2,093.52 2,577.75 3,399.97 4,400.37 5,948.03
98.12 81.69 152.89 147.07 376.84 364.40
15.23 29.33 25.69 68.18 16.53 14.68
713.38 897.02 3,062.95 2,033.00 2,211.76 5,749.05
2,354.81 3,101.56 5,819.28 5,648.22 7,005.50 12,076.16
7.07 8.42 21.00 33.52 64.37 19.55
539.61 671.69 947.90 1,163.45 1,608.65 1,947.40
38.04 35.10 1,884.29 560.18 219.07 107.88
### ### ### ### ### ###

10.00 10.00 10.00 10.00 10.00 10.00

Mar-15 Mar-16 Mar-17 Mar-18 Mar-19 Mar-20

222.02 433.47 455.28 729.99 806.84 1,280.14
-473.88 -632.89 -2,481.61 463.55 -958.37 -4,656.56
234.45 196.44 2,025.26 -1,159.06 208.98 3,357.42
-17.41 -2.98 -1.07 34.48 57.45 -19.00

637.85 1,324.80 1,471.10 2,187.50

56.15 56.15 62.41 62.41 62.41 64.78