-                                                                                                           -                                                             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%