0% found this document useful (0 votes)
27 views14 pages

HDFC Bank

The document provides a detailed financial overview of a company from March 2016 to March 2025, including sales, expenses, operating profit, and net profit figures. It highlights trends in sales growth, profit margins, and various financial ratios, with some data marked as errors. Additionally, it includes profit and loss statements, balance sheets, and cash flow analyses for specific years.

Uploaded by

Praveen yadav
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
27 views14 pages

HDFC Bank

The document provides a detailed financial overview of a company from March 2016 to March 2025, including sales, expenses, operating profit, and net profit figures. It highlights trends in sales growth, profit margins, and various financial ratios, with some data marked as errors. Additionally, it includes profit and loss statements, balance sheets, and cash flow analyses for specific years.

Uploaded by

Praveen yadav
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 14

- - SCREENER.

IN

Narration Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25 Trailing Best Case Worst Case
Sales 63,161.56 73,271.35 85,287.84 105,160.74 122,189.29 128,552.40 135,936.41 170,754.05 283,649.02 336,367.43 #ERROR! 454,960.11 #ERROR!
Expenses Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 Err:508 #ERROR! #ERROR! #ERROR!
Operating Profit #ERROR! #ERROR! #ERROR! #ERROR! #ERROR! #ERROR! #ERROR! #ERROR! #ERROR! #ERROR! #ERROR! #ERROR! #ERROR!
Other Income 11,211.65 12,905.08 16,056.60 18,947.05 24,878.97 27,332.88 31,758.99 33,912.05 124,345.75 134,548.50 #ERROR! - -
Depreciation 738.03 886.19 966.78 1,220.67 1,276.77 1,385.01 1,680.73 2,345.47 3,092.08 3,805.23 #ERROR! #ERROR! #ERROR!
Interest 34,069.57 38,041.58 42,381.48 53,712.69 62,137.42 59,247.59 58,584.33 77,779.94 154,138.55 183,894.20 #ERROR! #ERROR! #ERROR!
Profit before tax 19,510.99 23,392.97 28,463.92 34,318.16 38,194.86 42,796.15 50,873.38 61,498.39 76,568.60 96,242.05 #ERROR! #ERROR! #ERROR!
Tax 6,693.66 8,078.12 9,903.08 11,872.55 10,898.59 10,939.38 12,722.48 15,349.69 11,122.10 22,801.88 #ERROR! #ERROR! #ERROR!
Net profit 12,801.33 15,280.48 18,510.02 22,332.43 27,253.95 31,833.21 38,052.75 45,997.11 64,062.04 70,792.25 #ERROR! #ERROR! #ERROR!
EPS 25.32 29.81 35.66 41.00 49.70 57.74 68.62 82.44 84.33 92.51 Err:508 Err:508 Err:508
Price to earning 21.15 24.19 26.44 28.28 17.34 25.87 21.43 19.52 17.17 19.76 #ERROR! #ERROR! #ERROR!
Price 535.58 721.28 943.05 1,159.45 861.90 1,493.65 1,470.35 1,609.55 1,447.90 1,828.20 Err:509 #ERROR! #ERROR!

RATIOS:
Dividend Payout 18.76% 18.45% 18.23% 18.29% 5.03% 11.26% 22.59% 23.05% 23.12% 23.78%
OPM #ERROR! #ERROR! #ERROR! #ERROR! #ERROR! #ERROR! #ERROR! #ERROR! #ERROR! #ERROR! #ERROR!

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


Sales Growth 20.42% 21.66% 22.45% 35.26% 35.26% 20.42%
OPM #ERROR! #ERROR! #ERROR! #ERROR! #ERROR! #ERROR! #ERROR!
Price to Earning 22.12 21.34 20.75 18.82 #ERROR! #ERROR! #ERROR!
PROFIT & LOSS
Report Date Mar-16 Mar-17
Sales 63162 73271
Other Mfr. Exp 1042 1272
Employee Cost 6309 8508
Selling and admin 3043 3328
Other Expenses 9661 10747
Other Income 11212 12905
Depreciation 738 886
Interest 34070 38042
Profit before tax 19511 23393
Tax 6694 8078
Net profit 12801 15280
Dividend Amount 2402 2819

BALANCE SHEET
Report Date Mar-16 Mar-17
Equity Share Capital 506 513
Reserves 73798 91281
Borrowings 649587 741550
Other Liabilities 38321 59000
Total 762212 892344
Net Block 3667 4000
Investments 193634 210777
Other Assets 564912 677567
Total 762212 892344
Cash & Bank 24489 33633
No. of Equity Shares 2528186517 2562545717

CASH FLOW:
Report Date Mar-16 Mar-17
Cash from Operating Activity -34435 17282
Cash from Investing Activity -837 -1146
Cash from Financing Activity 37815 -5893
Net Cash Flow 2542 10242
PRICE: 536 721
Adjusted Equity Shares in Cr 506 513
HDFC BANK L
Mar-18 Mar-19 Mar-20 Mar-21
85288 105161 122189 128552
1315 1284 1293 1649
9197 10455 12924 13682
3658 3900 4192 4781
15362 19218 27050 32345
16057 18947 24879 27333
967 1221 1277 1385
42381 53713 62137 59248
28464 34318 38195 42796
9903 11873 10899 10939
18510 22332 27254 31833
3374 4085 1371 3583

Mar-18 Mar-19 Mar-20 Mar-21


519 545 548 551
109080 153128 175810 209259
944817 1080235 1333041 1511418
48770 58898 71430 78279
1103186 1292806 1580830 1799507
4008 4369 4776 5248
238461 289446 389305 438823
860717 998991 1186750 1355435
1103186 1292806 1580830 1799507
97138 39372 62997 86648
2595090267 2723306610 5483286460 5512776482

Mar-18 Mar-19 Mar-20 Mar-21


17214 -62872 -16869 42476
-842 -1503 -1403 -1823
57378 23131 24395 -7321
73750 -41244 6122 33332
943 1159 862 1494
519 545 548 551
Mar-22 Mar-23 Mar-24 Mar-25
135936 170754 283649 336367
1772 2177 3256 3944
15905 20031 31050 34168
5407 6580 87580 105188
33473 34254 52310 43675
31759 33912 124346 134549
1681 2345 3092 3805
58584 77780 154139 183894
50873 61498 76569 96242
12722 15350 11122 22802
38053 45997 64062 70792
8596 10601 14814 16835

Mar-22 Mar-23 Mar-24 Mar-25


555 558 760 765
246772 288880 455636 521024
1784970 2139212 3107503 3345504
90639 101783 466296 524817
2122934 2530432 4030194 4392110
6432 8431 12604 15258
449264 511582 1005682 1186473
1667238 2010419 3011909 3190379
2122934 2530432 4030194 4392110
118791 103918 165659 132227
5545540976 5579742786 7596910662 7652221674

Mar-22 Mar-23 Mar-24 Mar-25


-11960 20814 19069 127242
-2051 -2992 16600 -3651
48124 23941 -3983 -102478
34113 41762 31687 21113
1470 1610 1448 1828
555 558 760 765
PROFIT & LOSS
Report Date 2016-2017 2017-2018 2018-2019 2019-2020
Sales 16.01% 16.40% 23.30% 16.19%
Other Mfr. Exp 22.08% 3.39% -2.39% 0.77%
Employee Cost 34.86% 8.10% 13.67% 23.62%
Selling and admin 9.37% 9.92% 6.61% 7.49%
Other Expenses 11.25% 42.94% 25.10% 40.75%
Other Income 15.10% 24.42% 18.00% 31.31%
Depreciation 20.08% 9.09% 26.26% 4.60%
Interest 11.66% 11.41% 26.74% 15.68%
Profit before tax 19.90% 21.68% 20.57% 11.30%
Tax 20.68% 22.59% 19.89% -8.20%
Net profit 19.37% 21.14% 20.65% 22.04%
Dividend Amount 17.36% 19.68% 21.08% -66.44%

BALANCE SHEET
Report Date 2016-2017 2017-2018 2018-2019 2019-2020
Equity Share Capital 1.34% 1.25% 4.71% 0.67%
Reserves 19.15% 16.32% 28.77% 12.90%
Borrowings 12.40% 21.51% 12.54% 18.96%
Other Liabilities 35.05% -20.98% 17.20% 17.55%
Total 14.58% 19.11% 14.67% 18.22%
Net Block 8.32% 0.21% 8.25% 8.52%
Investments 8.13% 11.61% 17.61% 25.65%
Other Assets 16.63% 21.28% 13.84% 15.82%
Total 14.58% 19.11% 14.67% 18.22%
Cash & Bank 27.19% 65.38% -146.72% 37.50%
No. of Equity Shares 1.34% 1.25% 4.71% 50.33%

CASH FLOW:
Report Date 2016-2017 2017-2018 2018-2019 2019-2020
Cash from Operating Activity -150.19% -0.39% -465.23% -73.17%
Cash from Investing Activity 36.91% -26.59% 78.60% -6.66%
Cash from Financing Activity -115.58% -1073.66% -59.69% 5.46%
Net Cash Flow 302.85% 620.06% -155.92% -114.84%
PRICE: 34.67% 30.75% 22.95% -25.66%
Adjusted Equity Shares in Cr 1.36% 1.27% 4.94% 0.67%
2020-2021 2021-2022 2022-2023 2023-2024 2024-2025
5.21% 5.74% 25.61% 66.12% 18.59%
27.50% 7.47% 22.81% 49.59% 21.13%
5.87% 16.24% 25.95% 55.01% 10.04%
14.04% 13.10% 21.70% 1231.00% 20.11%
19.58% 3.49% 2.33% 52.71% -16.51%
9.86% 16.19% 6.78% 266.67% 8.21%
8.48% 21.35% 39.55% 31.83% 23.06%
-4.65% -1.12% 32.77% 98.17% 19.30%
12.05% 18.87% 20.89% 24.51% 25.69%
0.37% 16.30% 20.65% -27.54% 105.01%
16.80% 19.54% 20.88% 39.27% 10.51%
161.40% 139.88% 23.34% 39.74% 13.64%

2020-2021 2021-2022 2022-2023 2023-2024 2024-2025


0.54% 0.59% 0.61% 26.55% 0.72%
15.98% 15.20% 14.58% 36.60% 12.55%
11.80% 15.33% 16.56% 31.16% 7.11%
8.75% 13.64% 10.95% 78.17% 11.15%
12.15% 15.23% 16.10% 37.21% 8.24%
9.01% 18.40% 23.71% 33.10% 17.40%
11.28% 2.32% 12.18% 49.13% 15.24%
12.45% 18.70% 17.07% 33.25% 5.59%
12.15% 15.23% 16.10% 37.21% 8.24%
27.30% 27.06% -14.31% 37.27% -25.28%
0.53% 0.59% 0.61% 26.55% 0.72%

2020-2021 2021-2022 2022-2023 2023-2024 2024-2025


-351.80% -128.16% -274.03% -8.38% 567.26%
29.92% 12.54% 45.87% -654.79% -121.99%
-130.01% -757.31% -50.25% -116.64% 2472.83%
444.43% 2.34% 22.42% -24.13% -33.37%
73.30% -1.56% 9.47% -10.04% 26.27%
0.54% 0.59% 0.62% 36.15% 0.73%
PROFIT & LOSS
Report Date 2016-2017 2017-2018 2018-2019
Sales 100.00% 100.00% 100.00%
Other Mfr. Exp 1.65% 1.74% 1.54%
Employee Cost 9.99% 11.61% 10.78%
Selling and admin 4.82% 4.54% 4.29%
Other Expenses 15.30% 14.67% 18.01%
Other Income 17.75% 17.61% 18.83%
Depreciation 1.17% 1.21% 1.13%
Interest 53.94% 51.92% 49.69%
Profit before tax 30.89% 31.93% 33.37%
Tax 10.60% 11.02% 11.61%
Net profit 20.27% 20.85% 21.70%
Dividend Amount 3.80% 3.85% 3.96%

BALANCE SHEET
Report Date 2016-2017 2017-2018 2018-2019
Equity Share Capital 0.07% 0.06% 0.05%
Reserves 9.68% 10.23% 9.89%
Borrowings 85.22% 83.10% 85.64%
Other Liabilities 5.03% 6.61% 4.42%
Total 100.00% 100.00% 100.00%
Net Block 0.48% 0.45% 0.36%
Investments 25.40% 23.62% 21.62%
Other Assets 74.11% 75.93% 78.02%
Total 100.00% 100.00% 100.00%
Cash & Bank 3.21% 3.77% 8.81%
No. of Equity Shares 331690.58% 287170.11% 235235.93%
2019-2020 2020-2021 2021-2022 2022-2023 2023-2024
100.00% 100.00% 100.00% 100.00% 100.00%
1.22% 1.06% 1.28% 1.30% 1.27%
9.94% 10.58% 10.64% 11.70% 11.73%
3.71% 3.43% 3.72% 3.98% 3.85%
18.27% 22.14% 25.16% 24.62% 20.06%
18.02% 20.36% 21.26% 23.36% 19.86%
1.16% 1.04% 1.08% 1.24% 1.37%
51.08% 50.85% 46.09% 43.10% 45.55%
32.63% 31.26% 33.29% 37.42% 36.02%
11.29% 8.92% 8.51% 9.36% 8.99%
21.24% 22.30% 24.76% 27.99% 26.94%
3.88% 1.12% 2.79% 6.32% 6.21%

2019-2020 2020-2021 2021-2022 2022-2023 2023-2024


0.04% 0.03% 0.03% 0.03% 0.02%
11.84% 11.12% 11.63% 11.62% 11.42%
83.56% 84.33% 83.99% 84.08% 84.54%
4.56% 4.52% 4.35% 4.27% 4.02%
100.00% 100.00% 100.00% 100.00% 100.00%
0.34% 0.30% 0.29% 0.30% 0.33%
22.39% 24.63% 24.39% 21.16% 20.22%
77.27% 75.07% 75.32% 78.53% 79.45%
100.00% 100.00% 100.00% 100.00% 100.00%
3.05% 3.99% 4.82% 5.60% 4.11%
210650.88% 346861.14% 306349.33% 261220.57% 220505.50%
2024-2025
100.00%
1.15%
10.95%
30.88%
18.44%
43.84%
1.09%
54.34%
26.99%
3.92%
22.58%
5.22%

2024-2025
0.02%
11.31%
77.11%
11.57%
100.00%
0.31%
24.95%
74.73%
100.00%
4.11%
188499.86%

You might also like