Sales 107% 130% 145% 124% 113% 116% 116% 109% 103%

Expenses 133% 119% 118% 124% 116% 116% 120% 175% 122%
Operating Profit 94% 138% 162% 124% 111% 116% 114% 76% 81%
Net profit 137% 135% 126% 124% 121% 118% 112% 47% 12%
AXIS BANK LTD SCREENER.IN

Narration Mar-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Trailing Best Case Worst Case 1.01
Sales 10,829.11 11,639.05 15,154.86 21,994.90 27,201.98 30,735.96 35,727.46 41,409.25 45,175.09 46,614.06 - 50,935.65 46,614.06 1.18
Expenses 3,695.87 4,909.23 5,839.66 6,894.77 8,533.61 9,929.63 11,517.76 13,868.63 24,322.98 29,699.80 - 25,961.97 46,614.06 1.26
Operating Profit 7,133.24 6,729.82 9,315.20 15,100.13 18,668.37 20,806.33 24,209.70 27,540.62 20,852.11 16,914.26 - 24,973.68 - 1.10
Operating Profit % 65.87 57.82 61.47 68.65 68.63 67.69 67.76 66.51 46.16 36.29 #DIV/0! 49.03 - 0.94
Other Income 2,988.54 3,959.73 4,664.30 5,487.19 6,828.37 7,751.51 8,834.46 9,954.98 12,417.72 11,845.91 - - - 1.17
Other Income % 42% 59% 50% 36% 37% 37% 36% 36% 60% 70% #DIV/0! 0% #DIV/0! 1.06
EBIDT 10,121.78 10,689.55 13,979.50 20,587.32 25,496.74 28,557.84 33,044.16 37,495.60 33,269.83 28,760.17 - 24,973.68 - 1.12
EBIDT % 93.47 91.84 92.24 93.60 93.73 92.91 92.49 90.55 73.65 61.70 #DIV/0! 49.03 - 0.95
Depreciation 190.22 237.87 293.69 348.15 358.77 375.46 419.64 461.39 526.67 590.58 - - - 1.13
Interest 7,148.92 6,632.63 8,588.61 13,969.18 17,513.39 18,702.97 21,341.26 24,344.23 26,789.35 27,603.69 - - - 1.16
Interest Coverage Ratio 1.00 1.01 1.08 1.08 1.07 1.11 1.13 1.13 0.78 0.61 #DIV/0! #DIV/0! #DIV/0! 0.95
Profit before tax 2,782.64 3,819.05 5,097.20 6,269.99 7,624.59 9,479.41 11,283.25 12,689.96 5,953.81 565.88 - 24,973.68 - 0.84
Profit before tax % 25.70 32.81 33.63 28.51 28.03 30.84 31.58 30.65 13.18 1.21 #DIV/0! 49.03 - 0.71
Tax 969.71 1,340.91 1,752.52 2,051.48 2,390.80 3,170.25 3,834.76 4,332.38 1,986.78 101.86 - 0% 0% 0.78
Tax % 34.85 35.11 34.38 32.72 31.36 33.44 33.99 34.14 33.37 18.00 #DIV/0! - #DIV/0! 0.93
Net profit 1,812.93 2,478.14 3,339.91 4,219.78 5,234.76 6,310.12 7,447.90 8,349.67 3,953.03 455.82 - 24,973.68 - 0.86
Net profit % 16.74 21.29 22.04 19.19 19.24 20.53 20.85 20.16 8.75 0.98 #DIV/0! 49.03 - 0.73
EPS 10.10 12.23 16.27 20.42 22.37 26.86 31.42 35.04 16.51 1.78 - 97.17 - 0.82
Price to earning 9.56 19.64 17.26 11.28 11.99 11.03 17.48 12.84 30.50 291.28 - 111.54 - 1.46
Price 96.55 240.19 280.80 230.49 268.36 296.20 549.34 449.96 503.42 517.31 664.60 10,838.71 - 1.21
#DIV/0!
RATIOS: #DIV/0!
Dividend Payout 19.80% 19.62% 17.21% 15.67% 16.09% 14.89% 14.64% 14.27% 30.29% 0.00% 0.00
OPM 65.87% 57.82% 61.47% 68.65% 68.63% 67.69% 67.76% 66.51% 46.16% 36.29% 0.00% 0.94

Price/Sales 0.89%
TRENDS: 10 YEARS 7 YEARS 5 YEARS 3 YEARS RECENT BEST WORST
Sales Growth 17.61% 17.41% 11.37% 9.27% 3.19% 9.27% 3.19%
OPM 58.39% 57.90% 55.25% 49.03% 0.00% 49.03% 0.00%
Price to Earning 43.29 55.20 72.63 111.54 - 111.54 -
Sales #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Expenses #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Operating Profit #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Net profit #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
AXIS BANK LTD SCREENER.IN

Narration Jun-16 Sep-16 Dec-16 Mar-17 Jun-17 Sep-17 Dec-17 Mar-18 Jun-18 Sep-18
Sales - - - - - - - - - -
Expenses - - - - - - - - - -
Operating Profit - - - - - - - - - -
Other Income - - - - - - - - - -
Depreciation - - - - - - - - - -
Interest - - - - - - - - - -
Profit before tax - - - - - - - - - -
Tax - - - - - - - - - -
Net profit - - - - - - - - - -

OPM
AXIS BANK LTD SCREENER.IN

Narration Mar-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18
Equity Share Capital 359.01 405.17 410.55 413.20 467.95 469.84 474.10 476.57 479.01 513.31
Reserves 9,836.70 15,583.76 18,484.06 22,268.51 32,690.42 37,926.20 44,475.49 53,082.19 55,901.34 63,694.10
Total Shareholder Funds 10,195.71 15,988.93 18,894.61 22,681.71 33,158.37 38,396.04 44,949.59 53,558.76 56,380.35 64,207.41
Borrowings 132,877.53 158,448.21 215,434.31 254,059.35 296,254.22 333,280.29 406,637.67 472,149.92 527,437.44 611,424.85
Other Liabilities 4,660.74 6,182.15 8,270.39 8,698.52 11,171.33 14,717.31 15,701.63 20,853.27 27,737.34 28,210.38
Total 147,733.98 180,619.29 242,599.31 285,439.58 340,583.92 386,393.64 467,288.89 546,561.95 611,555.13 703,842.64
Debt/Equity Ratio 13.03 9.91 11.40 11.20 8.93 8.68 9.05 8.82 9.35 9.52
Current Ratio 3.22 2.46 2.59 1.60 1.84 1.94 2.32 1.62 1.84 1.56
Net Block 1,024.88 1,178.61 2,269.96 2,204.32 2,244.91 2,345.64 2,446.72 3,357.87 3,518.14 3,697.03
Capital Work in Progress 57.51 57.38 22.96 79.82 142.42 101.62 105.18 215.89 292.10 351.79
Investments 46,271.75 55,876.54 71,787.55 92,921.44 113,378.06 113,092.78 118,526.63 131,398.64 129,018.35 153,036.71
Other Assets 100,379.84 123,506.76 168,518.84 190,234.00 224,818.53 270,853.60 346,210.36 411,589.55 478,726.54 546,757.11
Total 147,733.98 180,619.29 242,599.31 285,439.58 340,583.92 386,393.64 467,288.89 546,561.95 611,555.13 703,842.64

Working Capital 95,719.10 117,324.61 160,248.45 181,535.48 213,647.20 256,136.29 330,508.73 390,736.28 450,989.20 518,546.73
Debtors - - - - - - - - - -
Inventory - - - - - - - - - -

Debtor Days - - - - - - - - - -
Inventory Turnover - - - - - - - - - -

Return on Equity 18% 15% 18% 19% 16% 16% 17% 16% 7% 1%
Return on Capital Emp 6% 4% 4% 7% 7% 7% 6% 6% 4% 3%
AXIS BANK LTD SCREENER.IN

Narration Mar-09 Mar-10 Mar-11 Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18
Cash from Operating Activity 10,346.35 149.88 11,327.68 -9,904.28 2,573.38 14,463.60 -15,162.50 -34,494.68 32,208.62 -38,390.30 -26,882.25 -1.16
Cash from Investing Activity -9,524.79 -5,095.69 -13,894.48 -4,840.34 -10,939.09 -14,165.88 -7,972.38 9,210.70 -12,458.40 -10,007.10 -79,687.45 1.01
Cash from Financing Activity 1,692.32 5,132.30 8,769.57 7,270.19 14,931.40 7,784.52 31,044.82 22,494.69 -2,486.91 41,342.09 137,974.99 1.43
Net Cash Flow 2,513.88 186.49 6,202.77 -7,474.43 6,565.69 8,082.24 7,909.94 -2,789.29 17,263.31 -7,055.30 31,405.30

Net profit 1812.93 2478.14 3339.91 4219.78 5234.76 6310.12 7447.9 8349.67 3953.03 455.82 43,602.06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
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: https://www.screener.in/excel/

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: screener.feedback@dalal-street.in
… do ANYTHING.

dalal-street.in
COMPANY NAME AXIS BANK LTD
LATEST VERSION 2.10 PLEASE
CURRENT VERSION 2.10

META
Number of shares 257.00
Face Value 2
Current Price 664.6
Market Capitalization 170802.22

PROFIT & LOSS

Report Date Mar-09 Mar-10 Mar-11 Mar-12
Sales 10,829.11 11,639.05 15,154.86 21,994.90
Raw Material Cost
Change in Inventory
Power and Fuel
Other Mfr. Exp 224.70 304.38 389.21 538.23
Employee Cost 1,067.76 1,359.79 1,745.80 2,254.02
Selling and admin 777.77 972.38 1,285.37 1,368.23
Other Expenses 1,625.64 2,272.68 2,419.28 2,734.29
Other Income 2,988.54 3,959.73 4,664.30 5,487.19
Depreciation 190.22 237.87 293.69 348.15
Interest 7,148.92 6,632.63 8,588.61 13,969.18
Profit before tax 2,782.64 3,819.05 5,097.20 6,269.99
Tax 969.71 1,340.91 1,752.52 2,051.48
Net profit 1,812.93 2,478.14 3,339.91 4,219.78
Dividend Amount 359.01 486.20 574.77 661.12

Quarters
Report Date Jun-16 Sep-16 Dec-16 Mar-17
Sales
Expenses
Other Income
Depreciation
Interest
Profit before tax
Tax
Net profit
Operating Profit
BALANCE SHEET
Report Date Mar-09 Mar-10 Mar-11 Mar-12
Equity Share Capital 359.01 405.17 410.55 413.2
Reserves 9836.7 15583.76 18484.06 22268.51
Borrowings 132877.53 158448.21 215434.31 254059.35
Other Liabilities 4660.74 6182.15 8270.39 8698.52
Total 147,733.98 180,619.29 242,599.31 285,439.58
Net Block 1024.88 1178.61 2269.96 2204.32
Capital Work in Progress 57.51 57.38 22.96 79.82
Investments 46271.75 55876.54 71787.55 92921.44
Other Assets 100379.84 123506.76 168518.84 190234
Total 147,733.98 180,619.29 242,599.31 285,439.58
Receivables
Inventory
Cash & Bank 15019.4 15205.89 21408.65 13934.23
No. of Equity Shares 359005118 405174119 410545843 413203952
New Bonus Shares
Face value 10 10 10 10

CASH FLOW:
Report Date Mar-09 Mar-10 Mar-11 Mar-12
Cash from Operating Activity 10,346.35 149.88 11,327.68 -9,904.28
Cash from Investing Activity -9,524.79 -5,095.69 -13,894.48 -4,840.34
Cash from Financing Activity 1,692.32 5,132.30 8,769.57 7,270.19
Net Cash Flow 2,513.88 186.49 6,202.77 -7,474.43

PRICE: 96.55 240.19 280.80 230.49

DERIVED:
Adjusted Equity Shares in Cr 179.50 202.59 205.27 206.60
 PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET

Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18

27,201.98 30,735.96 35,727.46 41,409.25 45,175.09 46,614.06

596.04 642.53 753.16 736.13 880.53 878.06

2,675.37 2,973.05 3,615.69 4,019.34 4,742.10 5,414.44
1,564.50 1,672.63 1,748.83 1,643.13 2,129.85 2,279.83
3,697.70 4,641.42 5,400.08 7,470.03 16,570.50 21,127.47
6,828.37 7,751.51 8,834.46 9,954.98 12,417.72 11,845.91
358.77 375.46 419.64 461.39 526.67 590.58
17,513.39 18,702.97 21,341.26 24,344.23 26,789.35 27,603.69
7,624.59 9,479.41 11,283.25 12,689.96 5,953.81 565.88
2,390.80 3,170.25 3,834.76 4,332.38 1,986.78 101.86
5,234.76 6,310.12 7,447.90 8,349.67 3,953.03 455.82
842.31 939.68 1,090.43 1,191.42 1,197.53

Jun-17 Sep-17 Dec-17 Mar-18 Jun-18 Sep-18

Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18
467.95 469.84 474.1 476.57 479.01 513.31
32690.42 37926.2 44475.49 53082.19 55901.34 63694.1
296254.22 333280.29 406637.67 472149.92 527437.44 611424.85
11171.33 14717.31 15701.63 20853.27 27737.34 28210.38
340,583.92 386,393.64 467,288.89 546,561.95 611,555.13 703,842.64
2244.91 2345.64 2446.72 3357.87 3518.14 3697.03
142.42 101.62 105.18 215.89 292.1 351.79
113378.06 113092.78 118526.63 131398.64 129018.35 153036.71
224818.53 270853.6 346210.36 411589.55 478726.54 546757.11
340,583.92 386,393.64 467,288.89 546,561.95 611,555.13 703,842.64

20499.92 28582.16 36492.1 33702.81 50966.12 43910.81

467954468 469844553 2370522199 2382831826 2395036109 2566538936

10 10 2 2 2 2

Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18

2,573.38 14,463.60 -15,162.50 -34,494.68 32,208.62 -38,390.30
-10,939.09 -14,165.88 -7,972.38 9,210.70 -12,458.40 -10,007.10
14,931.40 7,784.52 31,044.82 22,494.69 -2,486.91 41,342.09
6,565.69 8,082.24 7,909.94 -2,789.29 17,263.31 -7,055.30

268.36 296.20 549.34 449.96 503.42 517.31

233.98 234.92 237.05 238.28 239.50 256.65