| 
  Quantamental
  Equity Research on TATA ELXSI LTD | Release: 12 Jan 2019 23:02:41 UTC+05:30 |
  Reporting Currency: INR | Trading Currency: INR | Exchange:NSE/BSE NSE
  CODE:TATAELXSI and BSE CODE:500408 | 
 
  | Last Close:  | 
  INR 961.95 | 
 
  | Fair Value:  | 
  INR 751.65 | 
 
  | Est. Price by Mar 19:  | 
  INR 1607.45 | 
 
  | Market Capitalization (INR
  Crs):  | 
  5990.68 | 
 
  | Industry:  | 
  IT Software Products | 
 
  | Rating:  | 
  STRONG BUY | 
 
  | Upside:  | 
  67% | 
 
  | Company Profile | 
   | 
   | 
 
  | Tata Elxsi provides product design and engineering services to
  the consumer electronics, communications & transportation industries and
  systems integration and support services for enterprise customers. It also
  provides digital content creation for media and entertainment industry. | 
 
  | Growth Per Share | 
   | 
   | 
 
  | Particulars | 
  1-Year | 
  3-Year | 
  5-Year | 
    | 
 
  | Revenue % | 
  12% | 
  102% | 
  156% | 
    | 
 
  | EBIT % | 
  38% | 
  133% | 
  905% | 
    | 
 
  | Earnings % | 
  37% | 
  133% | 
  1044% | 
    | 
 
  | Book Value
  %  | 
  32% | 
  161% | 
  285% | 
    | 
 
  | Stock Total
  Return %  | 
  43% | 
  81% | 
  1028% | 
    | 
 
   | 
 
  | Share holding
  pattern | 
 
  | Particulars | 
  %age  | 
    | 
 
  | (A) Promoter
  & Promoter Group | 
  44.57 | 
    | 
 
  | (B) FII/FPI | 
  10.76 | 
    | 
 
  | (C)
  DII/Insurance Companies | 
  6.38 | 
    | 
 
  | (D) Public holding < 2 lakhs of cap. | 
  28.60 | 
    | 
 
  | (E) Others | 
  9.69 | 
    | 
 
  | Grand Total | 
  100.00 | 
    | 
 
   | 
 
  | Fundamentals
  (Historical and Estimated) | 
 
  | Particulars | 
  Mar-10 | 
  Mar-11 | 
  Mar-12 | 
  Mar-13 | 
  Mar-14 | 
  Mar-15 | 
  Mar-16 | 
  Mar-17 | 
  Mar-18 | 
   Mar-19 E  | 
   Mar-20 E  | 
   Mar-21 E  | 
   Mar-22 E  | 
   Mar-23 E  | 
    | 
 
  | Price | 
  162 | 
  131 | 
  101 | 
  97 | 
  278 | 
  606 | 
  964 | 
  769 | 
  1099 | 
  1607 | 
  1873 | 
  2114 | 
  2310 | 
  2448 | 
    | 
 
  | Return on
  Equity | 
  28% | 
  18% | 
  18% | 
  11% | 
  32% | 
  36% | 
  40% | 
  31% | 
  33% | 
  31% | 
  29% | 
  26% | 
  24% | 
  21% | 
    | 
 
  | Price to
  Earning  | 
  21.0 | 
  25.8 | 
  18.6 | 
  28.9 | 
  23.1 | 
  36.7 | 
  38.8 | 
  27.4 | 
  28.5 | 
  34.2 | 
  34.2 | 
  34.2 | 
  34.2 | 
  34.2 | 
    | 
 
  | EVTI | 
  2.8 | 
  2.0 | 
  1.3 | 
  1.1 | 
  2.2 | 
  4.4 | 
  5.5 | 
  3.8 | 
  4.8 | 
  5.9 | 
  5.9 | 
  5.9 | 
  5.9 | 
  5.8 | 
    | 
 
  | EVTIFM | 
  21.0 | 
  25.8 | 
  18.6 | 
  28.9 | 
  23.1 | 
  36.7 | 
  38.8 | 
  27.4 | 
  28.5 | 
  34.2 | 
  34.2 | 
  34.2 | 
  34.2 | 
  34.2 | 
    | 
 
  | Price to Book
  Value | 
  5.8 | 
  4.5 | 
  3.3 | 
  3.2 | 
  7.4 | 
  13.3 | 
  15.6 | 
  8.6 | 
  9.3 | 
  10.6 | 
  9.8 | 
  9.0 | 
  8.1 | 
  7.3 | 
    | 
 
  | Debt to
  Equity  | 
  0.2 | 
  0.1 | 
  0.2 | 
  0.3 | 
  0.0 | 
  0.0 | 
  0.0 | 
  0.0 | 
  0.0 | 
  0.0 | 
  0.0 | 
  0.0 | 
  0.0 | 
  0.0 | 
    | 
 
  | Dividend Yield | 
  2% | 
  3% | 
  3% | 
  3% | 
  2% | 
  1% | 
  1% | 
  1% | 
  1% | 
  1% | 
  1% | 
  1% | 
  1% | 
  1% | 
    | 
 
  | Cash Flow to
  Firm | 
  2% | 
  8% | 
  11% | 
  4% | 
  15% | 
  5% | 
  4% | 
  3% | 
  2% | 
  3% | 
  3% | 
  3% | 
  4% | 
  4% | 
    | 
 
   | 
 
  | Detailed Estimates | 
 
  | Title | 
  Mar-18 | 
  Mar-19 E | 
  Mar-20 E | 
  Mar-21 E | 
  Mar-22 E | 
  Mar-23 E | 
    | 
 
  | Sales | 
        1,386.30  | 
        1,634.37  | 
        1,874.15  | 
        2,088.69  | 
        2,260.46  | 
        2,373.48  | 
    | 
 
  | EBITDA | 
           390.06  | 
           473.16  | 
           542.58  | 
           604.69  | 
           654.42  | 
           687.14  | 
    | 
 
  | EBIT | 
           364.71  | 
           443.28  | 
           516.61  | 
           582.96  | 
           636.94  | 
           675.08  | 
    | 
 
  | PBT | 
           363.91  | 
           443.28  | 
           516.61  | 
           582.96  | 
           636.94  | 
           675.08  | 
    | 
 
  | NPAT | 
           240.04  | 
           292.61  | 
           341.01  | 
           384.81  | 
           420.44  | 
           445.62  | 
    | 
 
  | Price to
  Earning  | 
             28.52  | 
             34.21  | 
             34.21  | 
             34.21  | 
             34.21  | 
             34.21  | 
    | 
 
  | Price to Book
  Value | 
               9.27  | 
             10.56  | 
               9.79  | 
               8.98  | 
               8.14  | 
               7.31  | 
    | 
 
  | Debt to
  Equity  | 
                   -    | 
                   -    | 
                   -    | 
                   -    | 
                   -    | 
                   -    | 
    | 
 
  | Return on
  Equity | 
               0.33  | 
               0.31  | 
               0.29  | 
               0.26  | 
               0.24  | 
               0.21  | 
    | 
 
  | Enterprise Value to Total Income (EVTI) | 
               4.79  | 
               5.88  | 
               5.90  | 
               5.90  | 
               5.87  | 
               5.83  | 
    | 
 
  | Enterprise Value to Total Income to Firm Margin(EVTIFM) | 
             34.42  | 
             40.93  | 
             40.47  | 
             39.98  | 
             39.41  | 
             38.76  | 
    | 
 
  | Price or Est.
  Share Prices | 
        1,098.74  | 
        1,607.45  | 
        1,873.40  | 
        2,114.05  | 
        2,309.80  | 
        2,448.15  | 
    | 
 
   | 
 
  | DISCOUNTED CASH
  FLOW | 
 
  | Title | 
  Mar-19 E | 
  Mar-20 E | 
  Mar-21 E | 
  Mar-22 E | 
  Mar-23 E | 
    | 
 
  | PBT | 
           443.28  | 
           516.61  | 
           582.96  | 
           636.94  | 
           675.08  | 
    | 
 
  | Interest | 
                   -    | 
                   -    | 
                   -    | 
                   -    | 
                   -    | 
    | 
 
  | Depreciation | 
             29.89  | 
             25.97  | 
             21.73  | 
             17.48  | 
             12.06  | 
    | 
 
  | Cash Flow
  Before Tax | 
           473.16  | 
           542.58  | 
           604.69  | 
           654.42  | 
           687.14  | 
    | 
 
  | Tax Rate | 
             33.99  | 
             33.99  | 
             33.99  | 
             33.99  | 
             33.99  | 
    | 
 
  | Cash Flow
  After Tax | 
           312.33  | 
           358.16  | 
           399.16  | 
           431.98  | 
           453.58  | 
    | 
 
  | Terminal Cash
  Flow | 
                                                                                      
  -    | 
        6,462.50  | 
    | 
 
  | Total Cash
  Flow | 
           312.33  | 
           358.16  | 
           399.16  | 
           431.98  | 
        6,916.08  | 
    | 
 
  | Present Value of
  Cash Flow | 
        4,680.70  | 
    | 
 
  | Debt | 
                   -    | 
    | 
 
  | Value of Equity | 
        4,680.70  | 
    | 
 
  | Fair Value Per
  Share | 
           751.65  | 
    | 
 
   | 
 
  | Equity | 
   | 
   | 
   | 
   | 
             5,991  | 
   | 
 
  | Debt | 
   | 
   | 
   | 
   | 
                    0  | 
   | 
 
   | 
 
  | Beta | 
  Take from Reuters | 
   | 
   | 
  0.9 | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
 
  | Risk Free Rate | 
  Prevailing Yield in India | 
   | 
   | 
  7% | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
 
  | Market Risk Premium | 
  Assuming 8.82% premium
  for Equity Investments | 
  7% | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
 
   | 
 
  | Interest Paid | 
   | 
   | 
   | 
   | 
                    1  | 
   | 
 
  | Tax Benefit | 
   | 
   | 
   | 
   | 
                    0  | 
   | 
 
  | Interest Net of Tax | 
   | 
   | 
   | 
   | 
                    1  | 
   | 
 
  | Debt | 
   | 
   | 
   | 
   | 
                    0  | 
   | 
 
  | Cost of Debt | 
   | 
   | 
   | 
   | 
  0% | 
   | 
 
  | Cost of Equity | 
   | 
   | 
   | 
   | 
  14% | 
   | 
 
  | Debt Weight | 
   | 
   | 
   | 
   | 
  0% | 
   | 
 
  | Equity Weight | 
   | 
   | 
   | 
   | 
  100% | 
   | 
 
  | WACC | 
   | 
   | 
   | 
   | 
  14% | 
   | 
 
   | 
 
  | Cash Flow of Mar-23 E | 
   | 
   | 
   | 
   | 
           453.58  | 
   | 
 
  | Growth | 
   | 
   | 
   | 
   | 
  7.0% | 
   | 
 
  | Present Value of Terminal
  Cashflow | 
   | 
   | 
   | 
   | 
        6,462.50  | 
   | 
 
   | 
 
  | Peer Comparision | 
 
  | # | 
  Name | 
  CMP
  Rs. | 
  Mar
  Cap Rs.Cr.  | 
  B.V.
  Rs. | 
  Annualized
  ROE % | 
  ROCE
  % | 
  Latest
  EVTI | 
  Latest
  EVTIFM | 
  CMP
  / BV | 
  P/E | 
  Debt
  / Eq | 
  Div
  Yld % | 
  Growth
  Rate R % | 
  SGR
  % | 
  Ann
  Total Income | 
  Unpledged
  Prom Hold % | 
  PQEIOI | 
  QoQ
  Sales % | 
  Qtr
  Sales Var % | 
  QoQ
  Profits % | 
  Qtr
  Profit Var % | 
  Graham's
  Number Rs. | 
 
  |    1  | 
   L & T Infotech  | 
        1,731.20  | 
           30,022  | 
           231.15  | 
             53.65  | 
             39.50  | 
               2.92  | 
             22.33  | 
               7.49  | 
             22.51  | 
                   -    | 
               1.23  | 
             35.81  | 
             65.69  | 
             9,712  | 
             74.84  | 
                  99  | 
               8.14  | 
             33.15  | 
             10.79  | 
             46.85  | 
           634.75  | 
 
  |    2  | 
   Mindtree  | 
           832.00  | 
           13,663  | 
           184.71  | 
             38.79  | 
             26.55  | 
               1.79  | 
             20.35  | 
               4.50  | 
             19.85  | 
               0.11  | 
               1.32  | 
             26.52  | 
             36.14  | 
             7,231  | 
             13.32  | 
                  89  | 
               7.07  | 
             31.83  | 
             30.40  | 
             65.44  | 
           417.64  | 
 
  |    3  | 
   L&T Technology  | 
        1,633.20  | 
           16,980  | 
           191.74  | 
             50.58  | 
             37.86  | 
               3.16  | 
             29.31  | 
               8.52  | 
             25.21  | 
               0.04  | 
               0.97  | 
             17.79  | 
             17.09  | 
             5,284  | 
             80.66  | 
                125  | 
               9.89  | 
             40.58  | 
              -3.29  | 
             55.66  | 
           532.27  | 
 
  |    4  | 
   Hexaware Tech.  | 
           325.15  | 
             9,676  | 
             75.20  | 
             43.93  | 
             34.25  | 
               1.85  | 
             15.32  | 
               4.32  | 
             16.91  | 
                   -    | 
               1.23  | 
             33.49  | 
             34.80  | 
             4,944  | 
             62.76  | 
                  66  | 
               6.41  | 
             21.81  | 
             20.03  | 
             21.00  | 
           181.97  | 
 
  |    5  | 
   Cyient  | 
           594.35  | 
             6,719  | 
           222.02  | 
             27.58  | 
             22.87  | 
               1.18  | 
             18.42  | 
               2.68  | 
             16.05  | 
               0.12  | 
               2.18  | 
             17.62  | 
             15.68  | 
             4,976  | 
             22.10  | 
                  96  | 
               9.90  | 
             22.94  | 
             53.94  | 
             14.00  | 
           429.16  | 
 
  |    6  | 
   Tata Elxsi  | 
           961.95  | 
             5,991  | 
           129.54  | 
             43.49  | 
             56.53  | 
               3.46  | 
             20.51  | 
               7.43  | 
             20.73  | 
                   -    | 
               1.14  | 
             31.07  | 
             33.85  | 
             1,617  | 
             44.57  | 
                  87  | 
               1.05  | 
             17.79  | 
            -19.70  | 
               5.13  | 
           367.79  | 
 
 
Tgt very high not workable
ReplyDelete