7 January 2013
Update | Sector: Metals
Metals
CWIP valuations demystified
Sanjay Jain
(SanjayJain@MotilalOswal.com); +9122 39825412
Pavas Pethia
(Pavas.Pethia@MotilalOswal.com); +9122 39825413

Metals
Metals: CWIP valuations demystified
Page No.
Summary
........................................................................................................................
3-8
Companies
....................................................................................................................
9-61
Hindalco
...............................................................................................
10-18
Jindal Steel & Power
...........................................................................
19-25
JSW Steel
..............................................................................................
26-29
SAIL
.......................................................................................................
30-40
Sesa Sterlite
.........................................................................................
41-52
Tata Steel
.............................................................................................
53-60
*Prices as on 1 January 2013
7 January 2013
2

7 January 2013
Update | Sector: Metals
Metals
Implied valuation of CWIP at steep discount
Sesa-Sterlite, Hindalco penalized far more than warranted; Buy
Despite 30-40% earnings growth, the market capitalization of metal companies has fallen
by 30-35% over the last two-three years.
The markets have de-rated metal stocks due to exponential growth in their capital work
in progress (CWIP) and resultant increase in debt.
As the various projects start generating cash flows and capex intensity peaks over the next
two years, net debt should start coming off.
Our valuation exercise indicates that while there is still some downside in Jindal Steel &
Power and Tata Steel, Sesa-Sterlite and Hindalco could see re-rating.
We reiterate Buy on Sesa-Sterlite and Hindalco, and maintain Sell on Tata Steel, SAIL and
JSW Steel. We downgrade Jindal Steel & Power to Sell.
Aggregate CWIP has increased exponentially
Indian metal companies – Sesa-Sterlite, Hindalco, Tata Steel, SAIL, JSW Steel, and
Jindal Steel & Power – have invested INR2.6t over FY08-FY13 as compared to just
INR406b over FY01-07. Rising investment intensity and project delays on account of
various factors have driven an exponential increase in metal companies’ aggregate
CWIP (capital work in progress) to INR1.5t. Net debt has grown even faster to INR2.1t
(~USD38b) due to additional burden of acquisitions like Corus at USD14b and Novelis
at USD6b, despite equity infusion of USD12.5b and operating cash flow of INR2.6t.
Exponential rise in CWIP has driven up net debt
Note: Aggregate of top-6 listed Indian metal companies
Source: Company, MOSL
CWIP/MCap and CWIP/EV at all-time high
The significance/leverage of CWIP has never been as high as it is now, which is evident
from the exponential rise in the ratios (1) CWIP to market capitalization (MCap), and
(2) CWIP to enterprise value (EV). CWIP now stands at 67% of the total market
capitalization of the six metal companies, up from ~10% during FY03-08. Even during
the financial crisis of 2008 when MCap had crashed much below the intrinsic value of
companies, the CWIP/MCap ratio had risen to just 44%. The CWIP/EV ratio has increased
from below 10% until FY08 to 35%.
3
Investors are advised to refer
through disclosures made at the
end of the Research Report.
7 January 2013

Metals
CWIP/MCap has risen sharply to 67%
Except JSW Steel, every company has 10-20%
share in aggregate CWIP
Source: Company, MOSL
Implied valuation of CWIP at heavy discount...
With increasing debt, the markets have de-rated metal companies’ market cap below
the intrinsic value of operating assets (measured as 5x one-year forward EBITDA). In
other words, CWIP is being discounted heavily, perhaps for the right reasons – the IRR
of projects has declined much below the companies’ WACC. We believe investors are
willing to value growth companies at EV/EBITDA of 6-6.5x v/s EV/EBITDA of 5x for
mature steady state companies. This implies that investors are willing to tolerate
CWIP/EV of 20-30% provided overall net debt to EBITDA is maintained within striking
range of 2x. Despite 30-40% earnings growth, the market capitalization of metal
companies has fallen by 30-35% over the last two-three years. Higher CWIP/EV of 35%
is dragging market capitalization, resulting in CWIP/MCap ballooning out of control to
67%. The leverage of CWIP with respect to current valuations has never been so
important – it has the potential to offset commodity price compression if domestic
demand for metals starts accelerating to absorb new capacities and IRR starts improving.
Though earnings have grown, market cap has declined in the last two-three years (INR b)
Source: Company, MOSL
Five companies (Sesa-Sterlite, HNDL, JSP, TATA and SAIL) together will have a CWIP of
INR1.3t in FY14. On calculating the implied valuation of CWIP in the intrinsic value (EV
of 5x EBITDA), we find that CWIP is being valued at a 16% discount. However ex JSP
discount to CWIP is whooping 35%. In case of Sesa-Sterlite, most of the CWIP is
written off. HNDL and SAIL's CWIP is valued at a discount of 33% and 5%, respectively.
However, JSP and TATA's CWIP is valued at a premium of 151% and 33%, respectively.
7 January 2013
4

Metals
Implied valuation of CWIP vs DCF calculation of CWIP (INR b)
S.N. Company
Rating
CMP
Shares
CWIP
FY14
(ac)
235
464
134
200
256
1,289
399
416
255
635
275
1,981
Net
Debt
Implied
EV5xEBITDA
(a)
666
1,006
687
1,061
659
4,079
(b)
CWIP Discount
(%)
ic=a-b (1-ic/ac)
(INR)
1
2
3
4
5
Hindalco
Buy
Sesa-Sterlite Buy
JSP
Sell
Tata
Sell
SAIL
Sell
Total
134
199
462
438
93
(m)
1,991
2,965
935
971
4,130
509
158
33
924
82
82
349
337
-151
795
266
-33
417
242
5
2,994
1,085
16
Source: Company, MOSL
…and at variance with DCF-based valuation
We have juxtaposed the implied valuation of CWIP against our DCF-based valuation.
According to our calculations, CWIP of Jindal Steel & Power and Tata Steel should be
valued at a discount of 40% and 33%, respectively instead of a premium of 151% and
33%. Also, the markets appear to have penalized Sesa-Sterlite and Hindalco far more
than is warranted, in our opinion.
Implied valuaton of CWIP vs DCF calculation of CWIP (INR b)
Company
Rating
CMP
1-Jan
(INR)
Hindalco
Sesa-Sterlite
JSPL
Tata
SAIL
Total
Buy
Buy
Sell
Sell
Sell
134
199
462
438
93
Shares
CWIP
FY14
(ac)
235
464
134
200
256
1,289
399
416
255
635
275
1,981
Net
Debt
Implied
EV 5xEBITDA
(a)
666
1,006
687
1,061
659
4,079
(b)
509
924
349
795
417
2,994
CWIP Discount
(%)
ic=a-b (1-ic/ac)
158
82
337
266
242
1,085
33
82
-151
-33
5
16
DCF calculations
CapEx
NPV
CWIP Discount
(%)
(d)
(e) dc=d-e (1-dc/dc)
393
522
286
441
721
1,969
-48
345
12
-266
255
51
-114
172
40
-144
297
33
-418
303
58
-942
1,028
48
Source: Company, MOSL
(m)
1,991
2,965
935
971
4,130
Still some downside in Jindal Steel & Power, Tata Steel
Jindal Steel & Power:
The implied valuation of CWIP is at 151% premium. The market
appears to consider projects like Angul as value accretive due to captive coal mine,
Uktal B1, which is at final stages of lease signing, and availability of low cost pellets.
Also, Jindal Power’s 1,000MW commands higher valuations due to low cost of power
generation and freedom to sell at attractive merchant rates. However, we believe
that increasing project cost due to repeated delays, shrinking margins in the power
business, and change in regulations regarding transfer pricing of iron ore in Odisha
have resulted in the NPV of the Angul project turning negative. According to our
calculations the CWIP should attract 40% discount instead.
Tata Steel:
The implied valuation of CWIP is at 33% premium. The Odisha project is
perceived as value accretive because iron ore will be sourced from captive mines.
However, repeated delays have led to an increase in project cost. Phase-1 of the
3mtpa capacity has seen project cost rising to INR250b, implying specific cost of
USD1,500/ton – nearly 50% more expensive than the benchmark or at 60% premium
to the valuation of capacities around the world. According to our calculation, the
CWIP should attract 33% discount instead.
7 January 2013
5

Metals
Sesa-Sterlite and Hindalco could see re-rating
Sesa-Sterlite:
The implied discount is 82% against our calculation of 51% for Sesa-
Sterlite. It is additionally getting de-rated for its group structure. The cash flows of
Hindustan Zinc and Cairn India are not fungible to service the heavily leveraged balance
sheets of other businesses. There lies an opportunity for re-rating if minority stake in
Hindustan Zinc and Balco is bought out from the Government of India (GoI). The GoI is
under pressing need to meet its disinvestment targets and manage budget deficit.
Thus, the probability of the event has increased. Thereafter, the possible merger of
Hindustan Zinc and Balco will facilitate debt servicing and relieve balance sheet stress.
Hindalco:
The implied valuation of CWIP is at 33% discount against our calculation of
12%. Hindalco has the largest lever on CWIP, with CWIP/MCap at 114% and CWIP/EV at
46% because of the USD7.5b investment in the aluminum segment to derive benefits
from the allotted bauxite and coal resources. Though not entirely trouble-free, the
allocation of bauxite and coal mines to Hindalco has largely been non-controversial,
barring Mahan. With MoEF clearance, the Mahan coal block too is out of the woods.
The greenfield projects may not generate significant cash flows at current LME prices
of aluminum and the NPV is a negative INR48b. Utkal Alumina and Mahan are at an
advanced stage of completion. If not Mahan, Utkal is most likely to generate positive
cash flow right from the beginning and has the potential to expand capacity further at
low marginal cost. NPV of the projects is highly sensitive to LME prices and we believe
that LME prices of aluminum are at the bottom of the cycle.
NMDC has no material CWIP
NMDC
has no material CWIP because it has not undertaken asset heavy projects so
far. Therefore, we have kept it outside our study on CWIP. Its balance sheet is debt
free with cash surplus of ~USD4b due to strong cash flows. RoCE is still attractive in
the range of 22-26% despite being diluted by low yielding cash surpluses. The RoIC is
extremely attractive and ranges 200-300% because of its high quality iron ore assets
coupled with low cost operations.
Both volumes and prices will drive earnings at cagr of 16.3% to INR22.4/share over
FY13-15. Volumes will be driven by logistics de-bottlenecking and new 11B &
Kumarsway mines. Indian iron ore pricing is witnessing favorable dynamics due to
growing demand from Indian steel mills and reduced capacities of merchant mines
due to recent investigations/action in illegal and unchecked mining. High export duty
and other surcharges are increasingly becoming irrelevant in curtailing the pricing
power of Indian iron ore mines. The pricing of iron ore fines will inch upwards and
closer to prices of lumps with commissioning of new merchant pellet plants in India
over 1-2 years. This will boost the average iron ore realization for NMDC irrespective
of international market dynamics.
Although the investment of INR155b in setting 3mtpa steel plant has low IRR, the
project will not dent valuations materially because it can be funded purely from the
interest income of surplus cash on balance sheet due to tardy execution. If NMDC is
able to get intended additional iron ore resources, the IRR of project will be attractive.
7 January 2013
6

Metals
The stock trades at attractive EV/EBITDA of 3.6xFY15 and EV/ton of USD5. The dividend
yield is attractive at 4-5%. We value the stock at INR209/share based on 5x FY15 EV/
EBITDA. Maintain
Buy.
Investment cycle to peak in two years
As these projects start generating cash flows over the next two years and capex
intensity peaks, net debt should start coming off. The NPV of almost every project is
eroding due to falling IRR while the WACC is rising. However, there might be an
opportunity for equity value to grow because the investment cycles of most companies
will be peaking within two years for the following reasons:
1. Bearish outlook on metal prices and falling IRR has discouraged companies from
announcing new greenfield projects. Also, they have shelved difficult projects,
where only marginal amounts have been spent. Investments will, however,
continue in projects that are already at advanced stages.
2. Most of the projects that commenced during 2005-2008 have already travelled
the troubled road and are at advanced stages of completion. Therefore, further
execution delays are likely to be limited.
Using alternative approaches to valuation to factor uncertainties
We have adopted two alternative approaches to value projects to factor uncertainties
regarding execution. In both approaches, we have valued core operational assets at
an EV of 5x one-year forward EBITDA and the power business based on DCF.
1. SOTP:
We have valued operational assets as mentioned above. We have adjusted
the CWIP against the NPV of the projects.
2. FY20 valuations discounted for five years:
We arrive at FY20 valuations to factor in
completion of all ongoing projects and the possible delays. We have discounted
these valuations backwards for five years by cost of equity. We believe five years
is a fairly long period to account for unforeseen delays. Most projects will be
completed much before FY20.
Please refer to our Update on the
Steel sector, Downhill Run, dated
29 August 2012
Under each of the two approaches, we have considered two scenarios.
1. Base case scenario:
Iron ore and coking coal prices fall to USD83/ton and USD125/
ton, respectively over 12-16 months due to stagnating demand from the steel
sector and growing supplies from new projects. Aluminum prices are at the bottom
of the cycle from the margin perspective and USD2,000/ton is a good support
level. Zinc and lead prices remain at ~USD2,000/ton.
2. Optimistic scenario:
Iron ore and coking coal prices at USD106/ton and USD170/ton,
respectively. Aluminum prices increase to USD2,500/ton on some recovery in physical
and investment demand. Zinc and lead prices increased to ~USD2,500/ton.
Downgrading Jindal Steel & Power to Sell; our top picks: NMDC, Hindalco,
Sesa-Sterlite
Based on the above exercise, we draw the following conclusions:
Hindalco
has significant upside in 3 of the 4 situations, though the weighted
average IRR of projects is only 6.7%. We
reiterate Buy.
Sesa-Sterlite
has upside in 2 of the 4 situations, though its projects have low IRR.
Maintain Buy.
7 January 2013
7

Metals
Tata Steel
has downside in 3 of the 4 situations.
Maintain Sell.
Jindal Steel & Power and SAIL
have downside in all the 4 situations. We
downgrade
Jindal Steel & Power to Sell.
Also, we
maintain Sell on SAIL.
JSW Steel
does not have significant CWIP due to project delays and is the most
efficient and fastest growing steel company. It is best placed to weather the
volatility in input and steel prices. However, the pricing dynamics of iron ore have
turned adverse due to change in demand-supply equation in Karnataka, which
will progressively eat into margins and equity value. We maintain
Sell.
NMDC
has no material CWIP because it has not undertaken asset heavy projects
so far. Its balance sheet is debt free with cash surplus of ~USD4b due to strong cash
flows. The stock trades at attractive EV/EBITDA of 3.9xFY15 and EV/ton of USD5. It
is our most preferred pick. We maintain
Buy.
Summary of target prices and recommendations
S.N.
1
2
3
4
5
6
7
Company
Hindalco
Sesa-Sterlite
Tata
JSP
SAIL
JSW*
NMDC
CMP
134
199
438
462
93
807
169
Rating
Buy
Buy
Sell
Sell
Sell
Sell
Buy
Target
Price
185
205
230
356
59
478
209
SOTP
Base Optimistic
149
182
182
172
-52
242
331
348
269
-5
FY20 discounted 6yr
Base Optimistic
131
165
412
202
44
193
248
514
279
74
CapEx
(INR b)
393
522
441
286
721
NPV
(INR b)
-48
-266
-144
-114
-480
IRR
(%)
6.7
3.3
9.1
4.3
2.8
Source: Company, MOSL
*Coking coal price is practically pass-through for converters; iron ore costs dynamics are adverse & independent.
There is no significant CapEx delays which is resulting in disproportionate CWIP on balance sheet
#Base case assumptions: Iron ore (USD83/t fob for 63.5% Fe); coking coal (USD125/t fob), al/zn/pb at USD2,000/t
Optimistic assumptions: Iron ore (USD106/t fob); coking coal (USD170/t fob), al(USD2,500/t) zn&pb(USD2,500/t)
Valuations summary
Rating
Tata Steel
SAIL
JSW Steel (Merged)
JSPL
NMDC
Sesa Sterlite
Hindalco
Sell
Sell
Sell
Sell
Buy
Buy
Buy
CMP
P/E (x)
EV/EBITDA (x)
P/B (x)
RoE (%)
(INR) FY13E FY14E FY15E FY13E FY14E FY15E FY13E FY14E FY15E FY13E FY14E FY15E
438
93
812
462
169
199
134
55.3
15.9
21.4
12.4
10.2
5.1
7.0
9.1
11.1
21.5
12.1
9.1
5.9
6.5
8.8
13.6
12.1
10.9
7.5
6.1
5.9
8.5
9.1
7.7
8.9
6.0
5.7
7.6
6.7
7.9
7.8
10.2
5.1
5.4
6.5
6.6
7.9
6.8
9.1
3.9
5.1
5.5
1.7
0.9
1.3
2.2
2.3
0.8
1.3
1.5
0.9
1.3
1.9
2.0
0.7
1.1
1.4
0.8
1.2
1.6
1.7
0.6
1.0
3.0
17.8
5.9
8.1
6.2
6.1
18.6
17.0
26.3
22.8
15.9
12.2
20.6
18.8
Source: Company,
16.3
6.3
10.4
16.1
22.9
11.0
17.4
MOSL
Annexure
Cost of Equity (%)
Tata
A. Risk free rate (91 day T-bill)
B. Beta (adj.) with Sensex (x)
C. Market Premium
K. Cost of Equity (A+BxC)
8.2
1.275
8.0
18.3
SAIL
8.2
1.24
8.0
18.1
JSW
8.2
1.56
8.0
20.6
JSP
HNDL
Sesa-Stlt
8.2
1.24
8.0
18.1
Source:
8.2
8.2
1.35
1.4
8.0
8.0
18.9
19.3
Company, MOSL
7 January 2013
8

Metals
Companies
BSE Sensex: 19,581
Company Name
Hindalco
Jindal Steel & Power
JSW Steel
SAIL
Sesa Sterlite
Tata Steel
S&P CNX: 5,951
Pg.
10
19
26
30
41
53
7 January 2013
7 January 2013
9

7 January 2013
Update | Sector: Metals
Hindalco
BSE SENSEX
S&P CNX
19,581
5,951
CMP: INR134
TP: INR185
Buy
Largest CWIP/MCap turning favorable
Bloomberg
Equity Shares (m)
52-Week Range (INR)
1,6,12 Rel. Perf. (%)
M.Cap. (INR b)
M.Cap. (USD b)
HNDL IN
1,990.0
165/100
14/-4/-11
266.7
4.9
Debt to peak soon, with projects turning free cash flow positive; reiterate
Buy
Valuation summary (INR b)
Y/E March
2013E 2014E 2015E
Sales
816.0 854.6 935.8
EBITDA
87.0 101.7 116.8
NP
38.1 41.2 45.3
Adj. EPS (INR) 19.1 20.7 22.7
EPS Gr(%)
12.1
8.2
9.9
BV/Sh. (INR) 100.9 119.9 140.8
RoE (%)
20.6 18.8 17.4
RoCE (%)
7.5
8.2
8.9
Payout (%)
9.2
8.5
7.7
Valuation
P/E (x)
7.0
6.5
5.9
P/BV
1.3
1.1
1.0
EV/EBITDA (x) 7.6
6.5
5.5
Div. Yield (%) 1.1
1.1
1.1
Hindalco Industries (HNDL) has the largest lever on CWIP, with CWIP/MCap of 114%.
Though its investments in the Mahan and Aditya Aluminum projects have low IRR, its
investments in Utkal Alumina and Novelis are value accretive.
We believe the conversion business of Novelis and copper TcRc provide steady cash
flows, resilience and sustainability to HNDL. The primary aluminum business is at the
bottom of the cycle from the perspective of margins.
The implied valuation of CWIP is at a steep 33% discount, which is far more than
warranted. Our two alternative valuation approaches suggest equity value of INR131
and INR149 in the base case, and INR193 and INR242 per share in the optimistic case.
As the capex intensity peaks in 12 months and Utkal Alumina starts generating positive
cash flows, we believe the stock will get re-rated. We maintain Buy.
Hindalco Industries (HNDL) has a profitable business of aluminum and copper
smelting in India. It also owns Novelis’ flat rolled products (FRP) business. As the
conversion business accounts for ~70% of its cash flows, they are relatively less
volatile. Also, HNDL has been able to consistently grow the value of its operating
assets. However, heavy investments and delays in unfinished projects have
resulted in mounting debt on the balance sheet, which in turn, has put pressure
on equity value.
Market cap under pressure due to mounting debt (INR b)
Shareholding pattern (%)
As on
Sep-12
Promoter
32.1
Dom. Inst 14.8
Foreign
37.3
Others
15.9
Jun-12 Sep-11
32.1
32.1
15.2
14.1
36.5
39.4
16.2
14.4
Debt is rising largely due to exponential growth in CWIP
Stock performance (1 year)
(INR b)
(%)
10

Hindalco
Largest CWIP/Mcap lever…
HNDL has undertaken USD6b of capex in India and USD1.5b of capex at Novelis. Indian
projects have suffered execution delays and there have been complications in developing
the bauxite and coal mines. Novelis’ projects are, however, on schedule and within budget.
Currently, HNDL’s CWIP/MCap is 114%, the highest in the Indian Metals sector. Its CWIP/EV
is a whopping 46%, well beyond the tolerable limit of 20-30%.
Despite low weighted average IRR (WAIRR) of 6.7% and negative NPV (-INR48b) at
current LME aluminum prices of USD2,000/ton, HNDL has ventured into investing
USD7.5b largely in India to derive benefits from allotted bauxite and coal resources.
Though not entirely trouble-free, the allocation of bauxite and coal mines to Hindalco
has largely been non-controversial, barring Mahan. With MoEF clearance, the Mahan
coal block too is out of the woods.
If the coal mines do not come through, the WAIRR will decline to 2.6% at LME aluminum
prices of USD2,000/ton but will increase to 7.7% if LME prices move up to USD2,500/
ton. If the coal mines are successfully developed and LME prices too improve to
USD2,500/ton, the WAIRR will increase to 10.6%.
Summary: Projects of Hindalco (INR m)
CapEx
Total O/S as on
Sep2012
Utkal
72,000
28,000
Mahan
107,000
21,000
Aditya
131,950
64,950
Novelis
82,500
35,750
Total
393,450 149,700
CapEx in FY13H2 & FY14
130,215
O/S as on Mar 14
19,485
Project
NPV
8,991
-41,496
-54,024
38,224
-48,305
IRR
(%)
12.2
5.1
3.6
8.8
6.7
Remarks
Captive bauxite FY14 onwards
Coal mine FY16 onwards
Coal mine FY17 onwards
EBITDA/T = USD300
LME (ali) at USD2000/T
WAIRR = 10.6% at ali of USD2500/T
Source: Company, MOSL
Has traveled the troubled path…
Project delays and cost escalations have de-rated the stock. The implied valuation of
CWIP is at heavy discount of 33% and is steeper than a 12% discount according to DCF
calculations. Though not entirely trouble-free, the allocation of bauxite and coal mines
to Hindalco has largely been non-controversial, barring Mahan. With MoEF clearance,
the Mahan coal block too is out of the woods. The greenfield projects may not generate
significant cash flows at current LME prices of aluminum and the NPV is a negative
INR48b. Utkal Alumina and Mahan are at an advanced stage of completion. If not
Mahan, Utkal is most likely to generate positive cash flow right from the beginning
and has the potential to expand capacity further at low marginal cost. NPV of the
projects is highly sensitive to LME prices and we believe that LME prices of aluminum
are at the bottom of the cycle. Its heavy investment in greenfield projects and peaking
capex intensity will be a source of significant upside.
High share of conversion business lends stability to cash flows
HNDL derives ~70% of its cash flows from the conversion business; these are relatively
stable. We believe that the primary aluminum smelting business, which accounts for
the remaining 30% of its cash flows, is at the bottom of the margin cycle.
7 January 2013
11

Hindalco
CWIP/Mcap lever turning favorable as project’s turn free cash flow positive;
Re-iterate Buy
We expect the stock to get re-rated as the capex intensity peaks over next 1 year and
project’s free cash flows turn positive. Applying our two alternative approaches to
valuation, we find that HNDL has significant upside in 3 of the 4 situations. We re-
iterate our
Buy
recommendation.
1. SOTP:
We have valued operational assets at an EV of 5x one-year forward EBITDA.
We have adjusted the CWIP against the NPV of the projects. HNDL’s valuations are
highly sensitive to LME aluminum prices. In the base case scenario, where we
assume LME aluminum prices of USD2,000/ton, we arrive at a value of INR149/
share. In the optimistic scenario, where we assume LME aluminum prices of
USD2,500/ton, we arrive at a value of INR242/share.
2. FY20 valuations discounted for five years:
We arrive at FY20 valuations to factor in
completion of all ongoing projects and the possible delays. We have discounted
these valuations backwards for five years by HNDL’s cost of equity of 18.9%. In the
base case scenario, where we assume LME aluminum prices of USD2,000/ton, we
arrive at a value of INR131/share. In the optimistic scenario, where we assume
LME aluminum prices of USD2,500/ton, we arrive at a value of INR193/share.
Target Price (TP): Base case
SOTP Valuation
FY14 EBITDA
101,717
EV/EBITDA
5
Enterprise Value(1x2) 508,585
add: CWIP
234,879
add: NPV
-48,305
less: Net Debt
399,345
Equity value
295,813
Equity value per share
149
Key assumptions: Captive coal & bauxite; ali at USD2000/t
Target Price (TP): Optimistic scenario
SOTP Valuation
FY14 EBITDA
118,217
EV/EBITDA
5
Enterprise Value(1x2) 591,085
add: CWIP
234,879
add: NPV
55,242
less: Net Debt
399,345
Equity value
481,861
Equity value per share
242
Key assumptions: Captive coal & bauxite; ali at USD2500/t
7 January 2013
12

Hindalco
Target price calculations (INR m)
S.N. Project
1
2
3
4
Utkal
Mahan
Aditya
Novelis
Total equity in projects
add:current Operations@5xEV/EBITDA
Less: Net Debt (incl. projects)
Net Equity value for company
No. of share (m)
TP (INR/share)
TP (discounting back from FY20@Ke)
Current market Cap
Upside (%)
Equity value based on 5xEV/EBTIDA (project cost adjusted in net debt)
FY14
FY15
FY16
FY17
FY18
FY19
FY20
63,861
66,550
66,550
66,550
66,550
66,550
4,003
51,683
54,129
54,642
55,205
55,825
1,060
6,661
52,076
55,303
58,111
59,022
12,375
24,750
37,125
49,500
61,875
61,875
81,299
149,644
209,879
225,994
241,741
243,271
508,585
508,585
508,585
508,585
508,585
508,585
508,585
399,345
377,340
335,110
285,675
234,884
183,356
130,765
109,240
212,543
323,119
432,789
499,694
566,970
621,091
1,990
1,990
1,990
1,990
1,990
1,990
1,990
107
162
217
251
285
312
131
156
185
221
262
312
266,660
266,660
266,660
266,660
266,660
266,660
-2
16
38
65
96
133
Source: Company, MOSL
Utkal Alumina: NPV of INR9b; IRR of 12.2%
HNDL had initiated the Utkal Alumina project in JV with Alcan in 1993. At that time, it
owned 55% stake in the project. The mining lease for the bauxite mine at Baphlimali,
with reserves of 198m tons, was executed between the Odisha government and Orissa
Mining Corporation (OMC) on 17 February 1998. This was transferred to Utkal Alumina
on 10 November 2010.
The project was originally expected to cost INR48b for 1mtpa capacity. Commercial
production was scheduled by March 2009. Subsequently, in 2007, HNDL bought out
Alcan and the scope of the project was revised to 1.5mtpa at slightly higher capex of
INR56b. The project required 6,578 acres of land, which has mostly been acquired.
The timeline for initial production was revised to July 2011. However, the project has
seen further delays and cost escalation. Protests by NGOs regarding rehabilitation
and resettlement (R&R) have contributed to the delays.
The project cost has been revised to INR72b and production is now expected to start
in FY14. Bauxite will initially be transported by a 20km road from the mine to the
refinery. The conveyor is also expected to be ready by the end of FY14. By the end of
September 2012, INR44b were already spent. Since the mine capacity is 8.5mtpa,
HNDL has already obtained MoEF permission to expand capacity to 3mtpa and has
made suitable provisions in the design and layout. We believe that once the teething
problems are behind, this project will be a significant driver for overall earnings
growth.
Free cash flow to firm (INR m)
FY13
a. EBITDA
b. Depreciation
c. NOPLAT=(a-b)*(1-Tax rate)
d. Capex
e. change in Working Capital
FCFF (c+b+d+e)
Present Value (Cumulative)
FY14
8,963
2,828
4,908
-700
-2,172
4,864
82,005
FY15
12,772
2,856
7,933
-707
-923
9,159
86,394
FY16
13,310
2,885
8,340
-714
-130
10,381
86,984
FY17
13,310
2,914
8,317
-721
0
10,509
86,419
FY18
13,310
2,943
8,294
-728
0
10,508
85,661
FY19
13,310
2,972
8,270
-736
0
10,507
84,818
FY20
...FY37
13,310
13,310
3,002
3,555
8,246
6,828
-743
-880
0
0
Terminal
10,505
9,504
value
83,883
53,936
50,141
Source: Company, MOSL
13
-72,000
8,991
7 January 2013

Hindalco
Utkal is one of the few greenfield projects in the Indian Metals space with positive
NPV (INR9b or USD163m) at current LME aluminum prices. With captive bauxite, the
IRR of the project ranges from 4.3% at alumina prices of USD280/ton to 28.1% at alumina
prices of USD560/ton. We have assumed cost of bauxite at USD10/ton. In the absence
of bauxite mine, the IRR and NPV will decline significantly (summarized in the exhibits
below), as the cost of bauxite will increase to USD30-50/ton. The IRR will be
substantially higher when HNDL expands capacity further to 3mtpa at marginally lower
specific capex.
Utkal Alumina: Net present value (USD million)
160
10
15
20
30
40
50
60
(1,682)
(1,824)
(1,966)
(2,250)
(2,534)
(2,818)
(3,102)
200
(1,309)
(1,451)
(1,593)
(1,877)
(2,161)
(2,445)
(2,729)
240
(936)
(1,078)
(1,220)
(1,504)
(1,788)
(2,072)
(2,356)
Alumina USD/ton
280
320
360
(563)
(190)
183
(705)
(332)
41
(847)
(474)
(101)
(1,131)
(758)
(385)
(1,415) (1,042)
(669)
(1,699) (1,326)
(953)
(1,983) (1,610) (1,237)
400
557
415
272
(12)
(296)
(580)
(864)
440
930
788
646
361
77
(207)
(491)
480
1,303
1,161
1,019
735
451
166
(118)
520
560
1,676
2,049
1,534
1,907
1,392
1,765
1,108
1,481
824
1,197
540
913
255
629
Source: MOSL
Utkal Alumina: Internal rate of return (IRR, %)
160
10
15
20
30
40
50
60
-
-
-
-
-
-
-
200
-
-
-
-
-
-
-
240
(1.1)
(3.9)
-
-
-
-
-
Alumina USD/ton
280
320
360
4.3
2.4
0.4
-
-
-
-
8.5
7.0
5.4
1.7
(3.0)
-
-
12.2
10.8
9.4
6.4
3.0
(1.2)
-
400
15.6
14.4
13.0
10.3
7.4
4.1
0.3
440
18.9
17.7
16.4
13.9
11.2
8.3
5.2
480
22.1
20.9
19.6
17.2
14.7
12.0
9.3
520
560
25.1
28.1
23.9
27.0
22.8
25.8
20.4
23.5
17.9
21.1
15.4
18.7
12.9
16.2
Source: MOSL
Key assumptions
USD/INR =
CPC/LME =
Alumina/LME =
Import duty =
55.0
8%
15%
5%
Cost of equity =
Interest rate =
Debt/Equity =
Tax rate =
19%
10%
70/30
20%
Source: MOSL
Mahan: NPV of –INR41b; IRR of 5.1%
HNDL is setting up a 359ktpa smelter along with 900MW of CPP spread over 3,750
acres of land near Bargawan in Madhya Pradesh at a capex of INR82b. This project has
been allotted the Mahan coal block in JV with the Essar group, which is located near
the project site. The project was expected to commission by the end of July 2011 but
ran into trouble when Mr Jayram Ramesh, then the Minister of Environment and
Forests (MoEF), rejected the forest clearance for the coal mine.
Since captive coal remains at the core of project viability, construction work at the
smelter site has also slowed down, resulting in escalation of project cost to INR107b.
7 January 2013
14

Hindalco
Free cash flow to firm (INR m)
FY13
a. EBITDA
b. Depreciation
c. NOPLAT=(a-b)*(1-T)
d. Capex
e. change in Working Capital
FCFF (c+b+d+e)
Present Value (Cumulative)
FY14
750
4,242
-2,794
-1,050
-1,792
-1,393
60,241
FY15
801
4,284
-2,787
-1,061
-2,201
-1,764
68,432
FY16
10,337
4,327
4,808
-1,071
-226
7,838
77,917
FY17
10,826
4,371
5,164
-1,082
-184
8,269
78,872
FY18
10,928
4,414
5,211
-1,093
-11
8,522
79,502
FY19
11,041
4,458
5,266
-1,104
-12
8,608
79,951
FY20
...FY37
11,165
13,671
4,503
5,333
5,330
6,671
-1,115
-1,320
-14
0
Terminal
8,704
10,684
value
80,364
60,272
56,389
Source: Company, MOSL
-107,000
-41,496
Viability of the project largely depends on availability of coal from the captive mine
in the vicinity. Since the project cost has escalated multiple times due to delays, its
NPV is negative. We have assumed that cost of power will be INR3/kwh (excluding
interest and depreciation) until FY15. Thereafter, coal will be available from the captive
mine, post which the cost of power should drop to INR1/kwh.
Mahan: Net present value (USD million)
1,600
1.0
1.5
2.0
2.5
3.0
3.5
4.0
(1,263)
(1,481)
(1,698)
(1,916)
(2,134)
(2,352)
(2,570)
1,700
(1,136)
(1,353)
(1,571)
(1,789)
(2,007)
(2,225)
(2,443)
1,800
(1,009)
(1,226)
(1,444)
(1,662)
(1,880)
(2,098)
(2,316)
LME USD/ton
1,900
2,000
2,250
(882)
(1,099)
(1,317)
(1,535)
(1,753)
(1,971)
(2,188)
(754)
(972)
(1,190)
(1,408)
(1,626)
(1,844)
(2,061)
2,500
2,700
2,800
2,900
3,000
Power INR/kwh
(Fuel + O&M cost)
(437)
(119)
135
262
(655)
(337)
(83)
44
(872)
(555)
(301)
(174)
(1,090)
(773)
(519)
(391)
(1,308)
(990)
(736)
(609)
(1,526) (1,208)
(954)
(827)
(1,744) (1,426) (1,172) (1,045)
389
516
171
298
(47)
81
(264)
(137)
(482)
(355)
(700)
(573)
(918)
(791)
Source: MOSL
Mahan: Internal rate of return (IRR, %)
1,600
1.0
1.5
2.0
2.5
3.0
3.5
4.0
0.4
(2.5)
-
-
-
-
-
1,700
1.7
(0.8)
-
-
-
-
-
1,800
2.9
0.7
(2.2)
-
-
-
-
LME USD/ton
1,900
2,000
2,250
4.1
2.0
(0.5)
-
-
-
-
5.1
3.2
0.9
(1.9)
-
-
-
7.6
5.9
4.0
1.8
(0.8)
-
-
2,500
9.8
8.2
6.6
4.8
2.7
0.2
(2.9)
2,700
11.4
10.0
8.5
6.8
5.0
2.9
0.5
2,800
12.2
10.8
9.4
7.8
6.1
4.1
1.9
2,900
3,000
Power INR/kwh
(Fuel + O&M cost)
13.0
13.7
11.6
12.4
10.2
11.1
8.7
9.6
7.1
8.0
5.2
6.3
3.2
4.4
Source: MOSL
Aditya Aluminum: NPV of –INR54b; IRR of 3.6%
HNDL is setting up a 359ktpa smelter along with 900MW of CPP spread over 3,328
acres at Lapanga in Odisha at a capex of INR132b. The project was originally expected
to be completed at a capex of INR82b by October 2011. Until September 2012, INR67b
had already been spent. We expect the project to commence production in FY15 and
ramp up during FY16. 3mtpa of coal is expected to be available from the Odisha captive
mine in JV with Mahanadi Coalfields and Nevyeli Lignite.
7 January 2013
15

Hindalco
Free cash flow to firm (INR m)
FY13
a. EBITDA
b. Depreciation
c. NOPLAT=(a-b)*(1-T)
d. Capex
e. change in Working Capital
FCFF (c+b+d+e)
Present Value (Cumulative)
FY14
FY15
212
5,278
-4,053
0
-507
718
64,205
FY16
1,332
5,331
-3,199
-1,320
-2,677
-1,865
70,731
FY17
10,415
5,384
4,025
-1,333
-882
7,195
80,577
FY18
11,061
5,438
4,498
-1,346
-233
8,357
82,475
FY19
11,622
5,492
4,904
-1,359
-192
8,845
83,424
FY20
...FY37
11,804
13,671
5,547
6,570
5,006
5,681
-1,373
-1,626
Terminal
-20
0
Value
9,160
10,625
56,079
83,992
59,940
56,079
Source: Company, MOSL
-131,950
-54,024 -60,876
As in the case of Mahan, viability of Aditya Aluminum hinges upon availability of
captive coal at low cost – production cost increases by ~USD500/ton if coal is purchased.
Even with captive mine, the IRR of project is only 3.6% at LME aluminum price of
USD2,000/ton. At higher LME prices, the IRR and NPV improve significantly.
Aditya Aluminum: Net present value (USD million)
1,600
1.0
1.5
2.0
2.5
3.0
3.5
4.0
(1,416)
(1,609)
(1,802)
(1,995)
(2,188)
(2,381)
(2,574)
1,700
(1,308)
(1,501)
(1,694)
(1,887)
(2,080)
(2,273)
(2,466)
1,800
(1,199)
(1,392)
(1,585)
(1,778)
(1,971)
(2,164)
(2,357)
LME USD/ton
1,900
2,000
2,250
(1,091)
(1,284)
(1,477)
(1,670)
(1,863)
(2,056)
(2,249)
(982)
(1,175)
(1,368)
(1,561)
(1,754)
(1,947)
(2,141)
(711)
(904)
(1,097)
(1,290)
(1,483)
(1,676)
(1,869)
2,500
2,700
2,800
2,900
3,000
Power INR/kwh
(Fuel + O&M cost)
(440)
(223)
(115)
(6)
102
(633)
(416)
(308)
(200)
(91)
(826)
(609)
(501)
(393)
(284)
(1,019)
(802)
(694)
(586)
(477)
(1,212)
(996)
(887)
(779)
(670)
(1,405) (1,189) (1,080)
(972)
(863)
(1,598) (1,382) (1,273) (1,165) (1,056)
Source: MOSL
Aditya Aluminum: Internal rate of return (IRR, %)
1,600
1.0
1.5
2.0
2.5
3.0
3.5
4.0
(0.7)
(3.4)
-
-
-
-
-
1,700
0.5
(1.9)
-
-
-
-
-
1,800
1.6
(0.5)
(3.2)
-
-
-
-
LME USD/ton
1,900
2,000
2,250
2.6
0.7
(1.7)
-
-
-
-
3.6
1.8
(0.3)
(3.0)
-
-
-
5.8
4.2
2.5
0.5
(2.0)
-
-
2,500
7.7
6.3
4.8
3.1
1.2
(1.0)
(3.9)
2,700
9.1
7.8
6.5
5.0
3.3
1.4
(0.8)
2,800
9.8
8.5
7.2
5.8
4.2
2.5
0.4
2,900
3,000
Power INR/kwh
(Fuel + O&M cost)
10.4
11.1
9.2
9.9
8.0
8.7
6.6
7.4
5.1
6.0
3.5
4.4
1.6
2.7
Source: MOSL
Hindalco: Target price calculation (INR m, FY15E)
EBITDA
EV/EBTIDAx
Target EV
Net Debt
Equity Value
A. (INR/share)
CWIP
B. (INR/share)
C. CWIP discount factor (%)
Target Price A+B*C (INR/share)
7 January 2013
116,844
5.0
584,219
371,119
213,099
107
177,158
89
12
185
Source: MOSL
16

Hindalco
Financials and Valuation
Income Statement (Consolidated)
Y/E March
Net sales
Change (%)
Total Expenses
EBITDA
% of Net Sales
Depn. & Amortization
EBIT
Net Interest
Other income
PBT before EO
EO income
PBT after EO
Current tax
Deffered tax
Tax
Rate (%)
Reported PAT
Minority interests
Share of asso.
Adjusted PAT
Change (%)
2011
720,779
18.7
634,910
85,868
11.9
27,500
58,368
14,411
4,309
48,266
-9,834
38,432
9,739
-100
9,638
25.1
28,793
3,659
29
34,998
279.5
2012
808,214
12.1
726,316
81,897
10.1
28,699
53,199
17,579
7,831
43,450
43,450
7,862
7,862
18.1
35,587
2,113
496
33,970
-2.9
2013E
816,015
1.0
729,054
86,961
10.7
25,156
61,805
17,446
7,435
51,794
-2,727
49,068
8,616
3,985
12,601
25.7
36,467
1,144
29
38,079
12.1
2014E
854,565
4.7
752,848
101,717
11.9
28,909
72,808
22,677
4,905
55,036
55,036
9,155
3,618
12,773
23.2
42,263
1,089
29
41,203
8.2
(INR Million)
2015E
935,793
9.5
818,949
116,844
12.5
33,460
83,384
28,782
5,792
60,394
60,394
9,406
4,659
14,065
23.3
46,329
1,089
29
45,269
9.9
Balance Sheet
Y/E March
Share Capital
Reserves
Net Worth
Minority Interest
Total Loans
Deferred Tax Liability
Capital Employed
Gross Block
Less: Accum. Deprn.
Net Fixed Assets
Goodwill on consolidation
Capital WIP
Investments
Curr. Assets
Inventory
Account Receivables
Cash and Bank Balance
Others
Curr. Liability & Prov.
Account Payables
Provisions & Others
Net Current Assets
Appl. of Funds
E: MOSL Estimates
2011
1,990
288,243
290,233
22,169
294,602
37,596
644,601
392,654
158,014
234,640
123,940
92,518
18,742
378,856
137,420
75,411
80,680
85,346
204,095
104,334
99,761
174,761
644,601
2012
1,991
317,123
319,113
17,091
410,419
36,050
782,673
428,945
186,608
242,338
150,097
227,981
17,483
376,124
132,460
80,172
81,556
81,937
231,350
110,522
120,828
144,775
782,673
2013E
1,991
348,981
350,972
18,235
450,419
40,035
859,660
480,162
211,763
268,399
150,097
304,287
17,483
353,479
134,480
82,682
54,380
81,937
234,083
113,255
120,828
119,395
859,660
(INR Million)
2014E
1,991
386,690
388,681
19,324
460,419
43,653
912,077
619,062
240,672
378,390
150,097
234,879
17,483
370,873
141,542
86,320
61,074
81,937
239,645
118,817
120,828
131,228
912,077
2015E
1,991
428,466
430,456
20,414
470,421
48,312
969,603
719,162
274,132
445,030
150,097
177,158
17,483
430,787
155,042
94,507
99,302
81,937
250,952
130,124
120,828
179,835
969,603
7 January 2013
17

Hindalco
Financials and Valuation
Ratios (Consolidated)
Y/E March
Basic (INR)
EPS
Cash EPS
BV/Share (adj.)
DPS
Payout (%)
Valuation (x)
P/E
Cash P/E
P/BV
EV/Sales
EV/EBITDA
Dividend Yield (%)
Return Ratios (%)
RoE
RoCE (pre-tax)
RoIC (pre-tax)
Working Capital Ratios
Fixed Asset Turnover (x)
Asset Turnover (x)
Debtor (Days)
Inventory (Days)
Leverage Ratio (x)
Current Ratio
Interest Cover Ratio
Debt/Equity
2011
17.6
28.3
83.6
1.5
10.0
2012
17.1
32.3
84.9
1.5
10.3
2013E
19.1
31.0
100.9
1.5
9.2
2014E
20.7
35.8
119.9
1.5
8.5
2015E
22.7
40.1
140.8
1.5
7.7
7.9
4.1
1.6
0.7
7.3
1.1
7.0
4.3
1.3
0.8
7.6
1.1
6.5
3.7
1.1
0.8
6.5
1.1
5.9
3.3
1.0
0.7
5.5
1.1
23.1
10.1
14.5
20.3
7.5
11.7
20.6
7.5
13.2
18.8
8.2
13.5
17.4
8.9
13.1
1.8
1.1
38.2
69.6
1.9
1.0
36.2
59.8
1.7
0.9
37.0
60.2
1.4
0.9
36.9
60.5
1.3
1.0
36.9
60.5
1.9
4.1
1.3
1.6
3.0
1.9
1.5
3.5
2.0
1.5
3.2
1.7
1.7
2.9
1.3
Cash Flow Statement
Y/E March
EBITDA
Non - cash expense
tax paid
Change in working Capital
CF from Op. Activity
2011
85,868
-3,393
-13,131
-7,084
62,260
2012
81,897
14,415
-10,901
-9,322
76,090
-124,007
-13,277
-5,660
-142,945
10,861
89,511
-28,531
-4,110
67,731
876
80,680
81,556
2013E
86,961
-2727
-8,616
-1,797
73,822
-127,523
7,464
-120,059
2014E
101,717
(INR Million)
2015E
116,844
-9,406
-10,380
97,059
-42,379
5,821
-36,557
-9,155
-5,138
87,424
-69,493
4,933
-64,559
(Inc)/Dec in FA + CWIP
-77,598
(Pur)/Sale of Invest. & yield thereon 1,847
Others
4,945
CF from Inv. Activity
-70,806
Equity raised/(repaid)
Debt raised/(repaid)
Interest
Dividend (incl. tax)
CF from Fin. Activity
(Inc)/Dec in Cash
Add: Opening Balance
Closing Balance
E: MOSL Estimates
7 January 2013
99
37,384
-25,410
-3,838
8,236
-310
80,990
80,680
40,000
-17,446
-3,494
19,061
-27,176
81,556
54,380
10,000
-22,677
-3,494
-16,170
6,694
54,380
61,074
10,002
-28,782
-3,494
-22,273
38,228
61,074
99,302
18

7 January 2013
Update | Sector: Metals
Jindal Steel & Power
BSE SENSEX
S&P CNX
19,581
5,951
CMP: INR462
TP: INR356
Sell
Implied valuation of CWIP at 151% premium
Earnings declining; downgrading to Sell
Bloomberg
Equity Shares (m)
52-Week Range (INR)
1,6,12 Rel. Perf. (%)
M.Cap. (INR b)
M.Cap. (USD b)
JSP IN
934.8
663/321
14/-10/-25
431.9
7.9
Valuation summary (INR b)
Y/E March
2013E 2014E 2015E
Sales
202.9 214.6 265.4
EBITDA
65.0 75.1 94.3
Adj. PAT
35.0 35.8 39.5
Adj. EPS (INR) 37.4 38.3 42.2
EPS Gr(%)
-11.8
2.6 10.3
BV/Sh. (INR) 207.7 242.3 280.9
RoE (%)
18.6 17.0 16.1
RoCE (%)
13.0 12.0 11.9
Payout (%)
5.5
5.4
4.9
Valuation
P/E (x)
12.4 12.1 10.9
P/BV
2.2
1.9
1.6
EV/EBITDA (x) 10.2
9.1
7.7
Div. Yield (%) 0.4
0.4
0.4
Jindal Steel & Power (JSP) delivered 46% earnings CAGR over FY00-11 due to focus on
investment in high RoI / short payback projects and benefit of captive iron ore and coal
mines. Given its equally strong pipeline of projects, the stock got re-rated to factor growth.
However, over FY12-14, JSP's earnings have been declining at a compounded rate of 5%
due to margin compression and project delays. Gains on account of use of zero cost iron ore
inventories are clouding the shrinkage in the underlying steel business earnings. Non-
disclosure of such inventories is a regulatory risk.
With the shift in focus from asset-light growth to capex-intensive growth and hurdles in
execution, the CWIP/MCap and CWIP/EV ratios have started mounting. However, the
implied valuation of CWIP is at a 151% premium to our DCF-based valuation.
Our two alternative valuation approaches suggest equity value of INR172/share and INR202/
share in the base case, and INR269/share and INR279/share in the optimistic case. We
downgrade the stock to Sell.
After massive re-rating over FY08-10…
JSP’s steel business benefitted from 10x increase in iron ore prices and 6x increase
in coking coal prices over the last 10-12 years. Similarly, its power business
benefitted from high merchant power rates. Captive thermal coal and iron ore
mines helped to keep the cost of production of steel and power under check.
Further, JSP kept its balance sheet light by investing in only high RoI businesses
rather than pursuing large ambitions in the asset-heavy steel or power businesses.
The cost of the completed projects has already been fully recovered (see exhibit,
CWIP catching up with net debt). High growth in earnings and absence of dilution
led to massive re-rating of the stock during FY08-10; low earnings volatility reduced
the cost of equity. The basis of valuation shifted from EV/EBITDA to P/E to capture
the high growth and strong pipeline of projects.
CWIP at significant premium (INR b)
Shareholding pattern (%)
As on
Sep-12
Promoter
59.0
Dom. Inst
6.5
Foreign
23.2
Others
11.4
Jun-12 Sep-11
59.0
58.6
7.3
7.5
21.9
22.9
11.8
11.1
Stock performance (1 year)
Source: Company, MOSL
…the stock got de-rated due to corporate governance issues
Towards the end of 2009, JSP filed a DRHP for the listing of its power business. The
DRHP revealed that 3.57% of Jindal Power’s equity has been allotted to related
parties at throw-away prices in comparison to the intrinsic value and/or the target
19

Jindal Steel & Power
valuation for listing. Further, certain assets like overseas oil & gas investments were
stripped off. Though Jindal Power did not get listed, JSP got de-rated due to concerns
relating to corporate governance.
Also, there has been a shift from asset-light model
With rising market cap and cash flows, JSP switched its strategy from asset light growth
to asset heavy growth. It drew plans to invest USD31b to raise steel capacity to 32mtpa
and power capacity to 13GW over 10 years. Most of its projects are held up or are
progressing slowly due to multiple issues. In FY12, EBITDA yield of the gross block was
29% (GB/EBITDA of 3.5x) for the operating steel business. However, new projects
have significantly lower yields, e.g. 8.6% (GB/EBITDA of 11.6x) for the Angul project,
despite captive coal mines. The cost of the Angul greenfield project has seen inflation
of 50-70% due to delays and problems from local inhabitants near the site. Also, the
envisaged cost of iron ore and thermal coal has seen high inflation due to decline or
stagnation in mine production because of clamp-down on illegal iron ore mining and
environmental issues.
Ratios had started rising
CWIP catching up with net debt
Source: Company, MOSL
Summary: Active projects (INR m)
Project
CapEx
Total O/S post
FY14
50,000
136,000
41,487
150,000
336,000
286,000
NPV
165,131
-13,315
-100,492
51,324
41,487 -113,807
IRR
(%)
8.9
0.1
Remarks
Project cost is fully recovered
Assumed power is sold at
CERC guideline
cost of gas at USD7.5/mmbtu
using captive coal
Although JSP is investing in various
projects, but there is no
clear visibility on time line
Source: Company, MOSL
Tamnar 1
Tamnar 2
Angul
Total
Projects*
4.3
*no contribution in earnings until FY14
In addition to two active projects, i.e. Tamnar-2 and Angul, JSP has committed
investments in a number of coal mining projects in African countries, Indonesia,
Australia and Mongolia. These projects are in initial stages of development and will
require large capital commitment for rail and port infrastructure. Therefore, we believe
that these projects will be a drag on JSP’s equity value in the initial 5-10 years.
7 January 2013
20

Jindal Steel & Power
Sum of the part valuations
Equity Valuation
Iron & Steel
Shadeed
Business
Segment
As at the end of FY13, JSP will have CWIP of ~INR223b outstanding of the INR286b
capex, which will have an NPV of –INR114b. The CWIP/MCap ratio, though not as bad
as in FY02, has risen sharply to 52%. The CWIP/EV ratio has increased to 34%. Cash
flows from high yield operating assets are now being deployed in low yield projects.
This will drive further de-rating of the stock, in our view. Our SOTP value has gradually
declined from INR728/share (as per our report dated 18 July 2011) to INR356/share
because of the following reasons:
The value of the steel and CPP business has declined from INR342/share to INR186/
share due to delays in the 1.5mtpa steel and 810MW CPP project at Angul, and the
540MW CPP project at Raigarh. The profitability of 1,350MW has been far lower
than expected due to higher than expected fuel cost and inability to sell power in
the merchant market due to regulatory hurdles.
The value of Jindal Power has declined from INR337/share to INR145/share due to
repeated delays in initiating power projects of 1,980MW at Goda and Dumka in
Jharkhand because of uncertainty regarding coal blocks and tardy land acquisition.
Tamnar-2 has been delayed due to temporary suspension of ToR (terms of
reference) for the project.
The Bolivia project was closed with losses of ~INR5b (INR5/share) instead of value
of INR21/share in our SOTP.
Method
Valuation
multiple
10.0
10.0
Value Rationale
(INR m) (INR/sh)
172,080
24,472
2,046
112,721
21,869
333,188
184
26
2
121
23
356
This is equal to FY14 EV/EBITDA of 5.8x
1.5mtpa DRI plant, Attractive 22 year gas
supply contract
Coal tenaments in Australia
1000MW Capacity for Tamnar 1
2400MW capacity for Tamnar 2
Steel, Power FY14E PER (x)
Steel
FY14E PER (x)
Mkt Cap
DCF (to equity)
DCF (to equity)
Rockland & GNM Coal
Jindal Power
Power
Tamnar II
Power
SOTP
Our concerns on the business have increased
Over the last 12 months, our concerns on the business have increased.
The high margin Tamnar-1 (1,000MW) plant may be forced to sell power on long-
term power purchase agreement by the regulator. This could result in significant
reduction in earnings.
The steel business may not be able to source iron ore from Sarda Mines at low
prices. The Odisha government will be implementing e-auction from 1 April 2013.
This will lead to significantly higher transfer price. Although the transfer pricing
between Sarda Mines and JSP has already changed significantly, it has not reflected
in the recent quarterly margins and earnings, as the decline in recurring earnings
has been offset by gains on zero cost iron ore inventory.
The steel business has benefitted from high coking coal and iron ore prices. We
believe that the prices of both iron ore and coking coal will decline over the next
12-16 months due to stagnation in demand from the steel sector and growing
supply from new raw material projects. We have highlighted this view in our
recent Sector Update, Downhill Run, dated 29 August 2012. Recurrent earnings/
margins could be squeezed significantly.
Zero cost iron ore inventories are not disclosed on the balance sheet. Also, JSP
does not share this information publically. In the absence of clarity, this remains
a source of regulatory risk.
7 January 2013
21

Jindal Steel & Power
Downgrading stock recommendation to Sell
Applying our two alternative approaches to valuation, we find that JSP has downside
in all of the four situations. We downgrade our stock recommendation from Neutral
to Sell.
1. SOTP:
We have valued operational assets at an EV of 5x one-year forward EBITDA.
We have adjusted the CWIP against the NPV of the projects to capture their intrinsic
value. JSP’s valuations are highly sensitive to steel/iron ore prices. In the base
case scenario, where we assume iron ore prices of USD83/ton and coking coal
prices of USD125/ton, we arrive at a value of INR172/share. In the optimistic
scenario, where we assume iron ore prices of USD106/ton and coking coal prices
of USD170/ton, we arrive at a value of INR269/share.
2. FY20 valuations discounted for five years:
We arrive at FY20 valuations to factor in
completion of all ongoing projects and the possible delays. We have discounted
these valuations backwards for five years by JSP’s cost of equity of 18.1%. In the
base case scenario, we arrive at a value of INR202/share. In the optimistic scenario,
we arrive at a value of INR279/share.
Target Price (TP): Optimistic Scenario
SOTP Valuation
FY13 EBITDA
(excl. JPL-T1 & Angul) 19,016
EV/EBITDA (x)
5
EV (excl JPL-T1) (1x2) 95,081
JPL-T1 valuation
165,131
Angul valuation
33,863
Total EV (3+4+5)
294,074
add: CWIP
134,272
add: NPV
-13,315
less: Net Debt
254,687
Equity value
160,344
Equity value per share
172
Key assumption: iron ore at USD106/t; coking coal at USD170/t
Target Price (TP): Base case
SOTP Valuation
FY13 EBITDA
(excl. JPL-T1 & Angul) 31,147
EV/EBITDA (x)
5
EV (excl JPL-T1) (1x2) 155,735
JPL-T1 valuation
165,131
Angul valuation
64,532
Total EV (3+4+5)
385,397
add: CWIP
134,272
add: NPV
-13,315
less: Net Debt
254,687
Equity value
251,667
Equity value per share
269
Key assumption: iron ore at USD106/t; coking coal at USD170/t
7 January 2013
22

Jindal Steel & Power
Target price calculations
S.N.
1
2
3
4
5
Tamnar 2 (FCFF-DCF based)
Angul (5xEV/EBITDA)
Tamnar 1 (FCFF-DCF based)
Raigarh (3mtpa steel & 893MW of CPP)
Other mining business
Total EV for company
Less: Net Debt (incl. projects)
Net Equity value for company
No. of share (m)
TP (INR/share)
TP (discounting back from FY20@Ke)
Current market Cap
Upside (%) w.r.t. CMP
ProjectEquity value based on 5xEV/EBTIDA (project cost adjusted in net debt)
FY14
FY15
FY16
FY17
FY18
FY19
FY20
143,797
33,863
166,156
151,171
-1,589
493,398
266,325
227,073
935
243
202
431,878
-56
141,554
33,863
167,688
151,171
-1,589
492,687
233,357
259,329
935
277
239
431,878
-48
138,348
33,863
169,113
151,171
-1,589
490,905
190,206
300,699
935
322
282
431,878
-39
136,021
33,863
170,337
151,171
-1,589
489,803
144,716
345,087
935
369
333
431,878
-28
133,529
130,804
33,863
33,863
171,326
172,514
151,171
151,171
-1,589
-1,589
488,300
486,762
99,211
52,847
389,088
433,916
935
935
416
464
393
464
431,878
431,878
-15
0
Source: Company, MOSL
165,131
151,171
-1,589
314,713
254,687
60,026
Key assumptions
USD/INR =
Iron ore prices =
Coking coal =
HRC =
55.0
83
125
443
Cost of equity =
Interest rate =
Debt/project cost =
Tax rate =
18.3%
10%
50%
20%
Source: MOSL
7 January 2013
23

Jindal Steel & Power
Financials and Valuation
Income Statement (Consolidated)
Y/E March
Net sales
Change (%)
Total Expenses
EBITDA
% of Net Sales
Depn. & Amortization
EBIT
Net Interest
Other income
PBT before EO
EO income
PBT after EO
Tax
Rate (%)
Reported PAT
Minority interests
Share of Associates
Adjusted PAT
Change (%)
2011
131,122
18.2
67,960
63,162
48.2
11,510
51,652
2,596
815
49,871
49,871
11,830
23.7
38,040
659
158
37,539
4.7
2012
182,086
38.9
114,154
67,932
37.3
13,865
54,067
3,600
1,419
51,886
51,886
11,863
22.9
40,023
574
200
39,649
5.6
2013E
202,876
11.4
137,882
64,994
32.0
14,263
50,731
6,854
1,388
45,264
-5,741
39,523
10,175
25.7
29,347
447
310
34,952
-11.8
2014E
214,563
5.8
139,482
75,081
35.0
18,239
56,842
10,785
1,548
47,605
0
47,605
11,433
24.0
36,173
527
200
35,846
2.6
(INR Million)
2015E
265,444
23.7
171,154
94,290
35.5
25,297
68,992
17,124
259
52,127
0
52,127
11,991
23.0
40,136
812
200
39,525
10.3
Balance Sheet (Consolidated)
Y/E March
Share Capital
Reserves
Net Worth
Minority Interest
Total Loans
Deferred Tax Liability
Capital Employed
Gross Block
Less: Accum. Deprn.
Net Fixed Assets
Capital WIP
Good will
Investments
Curr. Assets
Inventory
Account Receivables
Cash and Bank Balance
loans & advances and others
Curr. Liability & Prov.
Account Payables
Provisions & Others
Net Current Assets
Appl. of Funds
E: MOSL Estimates
2011
934
140,169
141,103
2,335
139,728
10,055
293,221
192,756
44,321
148,435
93,809
1,018
2,979
114,648
27,734
11,537
4,640
70,737
67,668
22,736
44,933
46,980
293,221
2012
935
180,176
181,111
3,071
170,908
11,920
367,010
223,301
58,360
164,940
136,520
918
3,776
143,922
35,795
13,068
1,492
93,567
83,066
29,110
53,956
60,856
367,010
2013E
935
193,247
194,182
3,477
230,455
13,281
441,395
224,002
73,066
150,936
222,536
1,018
5,001
152,478
35,693
18,238
1,151
97,396
90,572
36,110
54,462
61,905
441,395
(INR Million)
2014E
935
225,595
226,530
4,061
290,955
14,724
536,269
389,168
91,306
297,862
134,272
1,018
5,001
191,173
38,057
19,453
36,268
97,396
93,056
38,594
54,462
98,117
536,270
2015E
935
261,621
262,556
4,929
344,955
15,886
628,326
457,660
116,603
341,057
165,988
1,018
5,001
212,382
40,424
22,095
52,467
97,396
97,119
42,657
54,462
115,263
628,326
7 January 2013
24

Jindal Steel & Power
Financials and Valuation
Ratios (Consolidated)
Y/E March
Basic (INR)
EPS
Cash EPS
BV/Share
DPS
Payout (%)
Valuation (x)
P/E
Cash P/E
P/BV
EV/Sales
EV/EBITDA
Dividend Yield (%)
Return Ratios (%)
RoE
RoCE (pre-tax)
RoIC (pre-tax)
Working Capital Ratios
Fixed Asset Turnover (x)
Asset Turnover (x)
Debtor (Days)
Inventory (Days)
Leverage Ratio (x)
Interest Cover Ratio
Debt/Equity
2011
40.1
53.0
151.0
1.5
3.8
2012
42.4
57.6
193.7
1.6
3.9
2013E
37.4
46.7
207.7
2.0
5.5
2014E
38.3
58.2
242.3
2.0
5.4
2015E
42.2
70.0
280.9
2.0
4.9
10.9
8.0
2.4
3.3
8.9
0.3
12.4
9.9
2.2
3.3
10.2
0.4
12.1
7.9
1.9
3.2
9.1
0.4
10.9
6.6
1.6
2.7
7.7
0.4
30.5
21.3
33.7
24.6
16.9
26.1
18.6
13.0
23.3
17.0
12.0
19.9
16.1
11.9
18.1
0.7
0.4
32.1
21.2
0.8
0.5
26.2
19.7
0.9
0.5
32.8
17.6
0.6
0.4
33.1
17.7
0.6
0.4
30.4
15.2
19.9
1.0
15.0
0.9
7.4
1.2
5.3
1.1
4.0
1.1
Cash Flow Statement (Consolidated)
Y/E March
Pre-tax profit
Depreciation
(Inc)/Dec in Wkg. Cap.
Tax paid
Other operating activities
CF from Op. Activity
(Inc)/Dec in FA + CWIP
(Pur)/Sale of Investments
CF from Inv. Activity
Equity raised/(repaid)
Debt raised/(repaid)
Dividend (incl. tax)
Other financing activities
CF from Fin. Activity
(Inc)/Dec in Cash
Add: Opening Balance
Closing Balance
E: MOSL Estimates
2011
49,871
11,510
-25,857
-10,230
1,235
26,528
-75,471
206
-75,265
3
53,685
-1,439
52,249
3,512
1,128
4,640
2012
51,886
13,865
-17,024
-9,999
840
39,568
-73,254
-797
-74,052
1
31,180
-1,536
1,663
31,307
-3,177
4,640
1,492
2013E
39,523
14,263
-1,390
-8,140
-14,281
29,974
-86,718
-1,225
-87,942
0
59,547
-1,920
57,627
-341
1,492
1,151
(INR Million)
2014E
47,605
18,239
-1,095
-9,995
-1,316
53,439
-76,902
0
-76,902
0
60,500
-1,920
58,580
35,117
1,151
36,268
2015E
52,127
25,297
-947
-10,835
-1,316
64,327
-100,208
0
-100,208
0
54,000
-1,920
52,080
16,199
36,268
52,467
7 January 2013
25

7 January 2013
Update | Sector: Metals
JSW Steel
BSE SENSEX
S&P CNX
19,581
5,951
CMP: INR831
TP: INR478
Sell
No pile-up of CWIP, but balance sheet leveraged
Margins to come under pressure; Sell
Bloomberg
Equity Shares (m)
52-Week Range (INR)
1,6,12 Rel. Perf. (%)
M.Cap. (INR b)
M.Cap. (USD b)
JSTL IN
223.1
885/503
11/7/37
185.4
3.4
Valuation summary (INR b)*
Y/E March
2013E 2014E 2015E
Sales
476.2 465.0 500.7
EBITDA
70.8 72.5 83.1
Adj. PAT
9.4
9.3 16.6
Adj. EPS (INR) 38.9 38.6 68.5
EPS Gr(%)
-41.6
-0.6 77.2
BV/Sh. (INR) 628.2 633.9 676.9
RoE (%)
6.2
6.1 10.4
RoCE (%)
8.7
8.5
9.8
Payout (%)
22.6 22.7 12.8
Valuation
P/E (x)
21.4 21.5 12.1
P/BV
1.3
1.3
1.2
EV/EBITDA (x) 7.7
7.8
6.8
Div. Yield (%) 0.9
0.9
0.9
*Post merger JSW-ISPAT
JSW Steel (JSTL) has been the best executor of projects among Indian metal companies,
and has avoided piling up CWIP on its balance sheet.
However, its balance sheet has got leveraged due to expensive investments in overseas
plate & pipe mill, and iron ore / coking coal mines in the Americas. It also acquired the
debt-laden Ispat industries, recently.
We continue to admire JSTL’s operating efficiencies and execution skills, but are
concerned about continued availability of attractively priced iron ore fines. We expect
the prices of iron ore fines to move up to bridge the gap vis-à-vis the prices of pellets
and/or lumps.
As the availability of attractively priced iron ore fines gets constrained, JSTL’s margins
will come under pressure. We reiterate Sell.
Superior execution skills have helped to avoid pile-up of CWIP
JSW Steel (JSTL) has been the best executor of projects among Indian metal
companies, with very comfortable CWIP/MCap and CWIP/EV ratios. There was,
however, one exception in its history – JSTL’s CWIP/MCap had spiked immediately
after the financial crisis of 2008 due to the double whammy of (1) CWIP on account
of its new ~3mtpa blast furnace, whose commissioning was delayed due to demand
collapse, and (2) pressure on market cap due to debt burden. However, the
recovery was equally swift, once the banking system normalized.
CWIP at comfortable levels (INR b)
Shareholding pattern (%)
As on
Sep-12
Promoter
38.6
Dom. Inst
4.7
Foreign
41.8
Others
14.9
Jun-12 Sep-11
38.6
38.3
4.7
4.6
41.3
42.8
15.3
14.4
Stock performance (1 year)
Ratios at much lower levels than industry
(%)
Expensive investment led to high debt level
(INR b)
26

JSW Steel
Profitable business in India, but overseas investments prove expensive
JSTL has a profitable steel business in India and has been the fastest growing steel
company in the world. In the last five years, it has invested USD900m in US plate &
pipe mill, USD250m in Chile iron ore mines, and USD100m in US coking coal mine.
None of its overseas acquisitions have been profitable and there is no visibility of
turnaround, given the global economic slowdown, high cost structure, and strategic /
technological disadvantage. We believe it is fair to treat them as sunk investments.
Acquisition of debt-laden Ispat Industries to provide growth opportunity…
The recent acquisition of Ispat Industries (Dolvi) will provide growth opportunity to
the JSW Steel group, especially given that growing through brownfield expansion in
Karnataka and greenfield projects in eastern states like West Bengal is challenging.
The Supreme Court imposed a cap on total iron ore production in Karnataka, limiting
the opportunity to grow steel production in the state. Similarly, the IRR of its steel
project in West Bengal has taken a hit due to delays in developing its coal mine due to
regulatory and political confusion. Further, iron ore availability has become difficult
for non-integrated steel plants due to drop in India’s iron ore production post the
Shah Commission investigation.
…but adds to balance sheet leverage
Post merger, the Dovi plant will be the key driver for future expansions. Dolvi (near
Mumbai) has the advantage of an in-plant jetty to receive coal and iron ore from the
sea route and proximity to re-rollers in western India. JSTL is pursuing projects to set
up coke-oven batteries, pellet plants and captive power plants at Dolvi, which will
have high IRR because of productivity gains and internal utilization of waste energy.
Similarly, it is investing in CAPL (downstream facility) at Vijay Nagar to cater to the
auto industry and improve its product mix. In the absence of publically available
information to accurately calculate the profitability of these projects, we value them
at project cost.
Margins to come under pressure; maintain Sell
We expect margins of USD125/ton and volumes of 9.4m tons in FY14 from the erstwhile
JSTL operations. We remain concerned that margins will come under pressure due to
changed iron ore pricing dynamics in India, which has (perhaps temporarily) turned
net importer of iron ore. Our target price for JSTL is INR478/share (EV of 5x FY14E
EBITDA), which implies 42% downside. We maintain
Sell.
Target price calculations (INR m)
Year
EBITDA
Target EBITDA multiple
Target EV
less: Net Debt (INR m)
add: CWIP
Residual equity value
No. of shares
Target price (INR)
2015E
83,086
5.0
415,430
366,179
66,335
115,586
242
478
Source: Company, MOSL
27
7 January 2013

JSW Steel
Financials and Valuation
Income Statement (Consolidated, JSW-Ispat merged from FY13)
Y/E March
Net sales
Change (%)
Total Expenses
EBITDA
% of Net Sales
Depn. & Amortization
EBIT
Net Interest
Other income
PBT before EO
EO income
PBT after EO
Tax
Rate (%)
Reported PAT
Minority interests
Share of Associates
Preference dividend
Adj. PAT (after MI & Asso)
Change (%)
2011
241,059
27.2
192,380
48,679
20.2
15,597
33,082
10,603
1,900
24,379
24,379
7,785
31.9
16,594
-239
707
279
16,783
40.4
2012
343,681
42.6
282,662
61,019
17.8
19,332
41,687
14,273
769
28,183
-15,353
12,830
5,002
39.0
7,828
189
-2,262
279
14,844
-11.6
2013E
476,228
7.0
405,424
70,805
16.9
28,530
42,275
28,343
3,170
17,102
-1,645
15,457
9,040
42.5
6,416
-384
828
9,393
-39.6
2014E
465,014
-1.7
392,528
72,485
17.4
29,069
43,417
31,132
1,495
13,779
13,779
4,134
30.0
6,395
-524
828
9,341
-14.9
(INR Million)
2015E
500,731
9.9
417,645
83,086
17.0
29,069
54,017
31,132
1,545
24,430
24,430
7,573
31.0
13,677
-524
828
16,552
68.0
Balance Sheet
Y/E March
Share Capital
Reserves
Net Worth
Minority Interest
Total Loans
Deferred Tax Liability
Capital Employed
Gross Block
Less: Accum. Deprn.
Net Fixed Assets
Capital WIP
Investments
Curr. Assets
Inventory
Account Receivables
Cash and Bank Balance
Others
Curr. Liability & Prov.
Account Payables
Provisions & Others
Net Current Assets
Appl. of Funds
E: MOSL Estimates
2011
2,231
163,062
165,293
2,219
211,203
20,494
399,209
337,771
68,732
269,039
65,078
26,437
98,329
44,097
9,334
23,170
21,729
59,674
29,622
30,052
38,655
399,209
2012
2,231
165,265
167,496
2,177
274,301
27,250
471,223
426,895
88,775
338,121
35,703
18,856
146,453
57,893
15,394
32,653
40,514
67,910
41,039
26,871
78,543
471,223
2013E
2,417
149,430
151,847
1,793
359,941
10,849
524,430
596,378
185,364
411,014
56,335
4,441
166,884
84,222
22,540
14,193
45,930
114,245
86,916
27,329
52,639
524,430
(INR Million)
2014E
2,417
150,819
153,236
1,270
379,941
15,037
549,483
627,878
214,433
413,446
76,335
4,441
166,873
82,115
21,947
16,881
45,930
111,612
84,283
27,329
55,261
549,483
2015E
2,417
161,219
163,636
746
399,941
25,908
590,231
687,878
243,501
444,377
66,335
4,441
191,093
87,986
23,415
33,762
45,930
116,015
88,686
27,329
75,078
590,231
7 January 2013
28

JSW Steel
Financials and Valuation
Ratios (Consolidated, JSW-Ispat merged from FY13)
Y/E March
Basic (INR)
EPS
Cash EPS
BV/Share
DPS
Payout (%)
Valuation (x)
P/E
Cash P/E
P/BV
EV/Sales
EV/EBITDA
Dividend Yield (%)
Return Ratios (%)
RoE
RoCE (pre-tax)
RoIC (pre-tax)
Working Capital Ratios
Debtor (Days)
Inventory (Days)
Creditors(Days)
Leverage Ratio (x)
Debt/Equity
2011
75.2
144.3
740.8
12.3
20.9
2012
66.5
121.7
750.7
7.5
15.4
2013E
38.9
144.6
628.2
7.5
19.3
2014E
38.6
146.7
633.9
7.5
19.4
2015E
68.5
176.8
676.9
7.5
11.0
12.5
6.8
1.1
1.2
7.0
0.9
21.4
5.7
1.3
1.1
7.7
0.9
21.5
5.7
1.3
1.2
7.8
0.9
12.1
4.7
1.2
1.1
6.8
0.9
12.3
9.9
12.5
8.9
9.2
12.5
6.2
8.7
9.4
6.1
8.5
9.6
10.4
9.8
11.5
14
67
45
16
61
44
17
65
67
17
64
66
17
64
65
1.1
1.4
2.3
2.4
2.2
Cash Flow Statement (Consolidated)
Y/E March
EBITDA
(Inc)/Dec in Wkg. Cap.
Tax Paid
CF from Op. Activity
(Inc)/Dec in FA + CWIP
(Pur)/Sale of Investments
Acquisition in subsidiaries
Int. & Dividend Income
CF from Inv. Activity
Equity raised/(repaid)
Debt raised/(repaid)
Dividend (incl. tax)
Interest paid
Other financing
CF from Fin. Activity
2011
48,679
-13,137
-4,269
31,273
-52,994
-266
-23,598
526
-76,331
59,356
4,008
-2,397
-10,007
-281
50,679
2012
61,019
-30,404
-4,113
26,502
-59,750
7,581
769
-51,400
2013E
70,805
4,933
-3,074
72,660
-51,500
(INR Million)
2014E
72,485
66
-3,197
69,354
-51,500
2015E
83,086
-2,936
59
80,209
-50,000
3,170
-48,330
1,495
-50,005
1,545
-48,455
63,098
-2,284
-14,273
-12,159
34,382
9,484
23,170
32,653
1,611
-3,271
-28,343
-4,883
-34,887
-10,557
24,750
14,193
20,000
-2,237
-31,132
-3,292
-16,661
2,688
14,193
16,881
20,000
-2,237
-31,132
-1,504
-14,874
16,881
16,881
33,762
(Inc)/Dec in Cash
5,621
Add: opening Balance
3,030
Margin Money & debenture balance 14,518
Closing Balance
23,170
E: MOSL Estimates
7 January 2013
29

7 January 2013
Update | Sector: Metals
SAIL
BSE SENSEX
S&P CNX
19,581
5,951
CMP: INR93
TP: INR59
Sell
Structural increase in conversion cost; margins
shrinking
Bloomberg
Equity Shares (m)
52-Week Range (INR)
1,6,12 Rel. Perf. (%)
M.Cap. (INR b)
M.Cap. (USD b)
SAIL IN
4,130.4
116/76
384.1
7.0
13/-12/-13
Valuation exercise indicates more downside; Sell
Valuation summary (INR b)
Y/E March
2013E 2014E 2015E
Sales
444.0 488.1 524.0
EBITDA
59.6 83.4 88.5
NP
24.2 34.6 28.3
Adj. EPS (INR) 5.9
8.4
6.8
EPS Gr(%)
-35.8 42.9 -18.2
BV/Sh. (INR) 100.7 106.7 111.2
RoE (%)
5.9
8.1
6.3
RoCE (%)
7.3
8.5
7.6
Payout (%)
42.4 28.0 34.2
Valuation
P/E (x)
15.9 11.1 13.6
P/BV
0.9
0.9
0.8
EV/EBITDA (x) 9.1
7.9
7.9
Div. Yield (%) 2.2
2.2
2.2
SAIL’s growth plan involving a capex of INR721b and shrinking margins have been drags
on its market cap. Though it has already spent INR456b, volume growth remains
elusive due to project delays.
CWIP/MCap has ballooned to 92%. Cumulatively, SAIL’s projects have a weighted
average internal rate of return (WAIRR) of 5.3% and an NPV of –INR344b provided iron
ore and coking coal prices stay at USD106/ton FOB and USD170/ton FOB, an optimistic
scenario. WAIRR and NPV will fall further to 2.8% and –INR418b if iron ore and coking
coal prices were to fall to USD83/ton FOB and USD125/ton FOB, respectively, which is
our base case.
Our two alternative valuation approaches suggest equity value of –52/share and 44/
share in the base case, and -INR5/share and INR74/share in the optimistic case. SAIL is
structurally moving up the industry conversion cost curve due to inflation in wages,
fuel and other operating costs. Though volume growth will drive earnings, the spreads
because of iron ore advantage will shrink. We maintain Sell.
Has traversed the full circle
SAIL seems to have traversed the full circle in the last 10-12 years. At the beginning
of the last decade, it had low profitability, high debt and near zero equity value.
CWIP/MCap was 40%, though this is no benchmark, as MCap was very small (EV
comprised largely of debt). Thereafter, its fortunes turned due to the boom in the
sector and complete absence of capex until FY08. From net debt of ~INR140b in
FY01, the balance sheet had net cash surplus of INR111b by the end of FY08, which
led to massive re-rating and huge stock performance (stock was up >50x in 7 years).
Even during the financial crisis of 2008, SAIL outperformed the sector due to its
strong balance sheet. Since FY09, however, SAIL’s earnings have come under
pressure due to inflation of wages, lack of volume growth, related productivity
gain and increased financial leverage, with net debt increasing by ~INR400b on
account of INR721b capex. The stock has witnessed de-rating and market cap has
dipped below 5x one-year forward EBITDA.
CWIP mounting on INR721b capex (INR b)
Shareholding pattern (%)
As on
Sep-12
Promoter
85.8
Dom. Inst
7.6
Foreign
3.6
Others
3.0
Jun-12 Sep-11
85.8
85.8
7.9
7.5
3.3
4.1
3.0
2.6
Stock performance (1 year)
Source: Company, MOSL
30

SAIL
SAIL’s CWIP/MCap ratio has zoomed past its historical high of 50% in FY01 to 92% in
FY13. This is the second highest in the Metals sector after Hindalco. The ratio is worse
than the last two cyclical distresses in FY00-01 and FY09. The question is, once the
capex cycle peaks for SAIL over the next 2-3 years, can we expect significant returns?
Cumulative capex estimated at INR721b
SAIL is undertaking expansion and modernization across plants to increase its saleable
steel capacity from 12.4mtpa to 20.2mtpa. The total capital outlay for the project is
INR721b, of which it has already incurred INR456b until September 2012. We expect
various capacities to commence operations over FY14-16, with 6-18 months delay
from the current schedule.
Ratios above industry average (%)
Debt rising in synce with increasing CWIP (INR b)
Source: Company, MOSL
At steel prices USD518/ton (HRC FOB) and iron ore prices at USD106/ton, SAIL’s projects
will have an NPV of –INR344b, with an IRR of 5.3%. This is an optimistic scenario, in our
view. In our base case scenario (please refer to our recent Sector Update, Downhill
Run), where we have assumed that iron ore prices will correct to USD83/ton, with
corresponding correction of USD39/ton in steel prices and EBITDA per ton (please
note we are ignoring coking coal prices here because SAIL hardly has any captive
mines and its earnings, therefore, have low sensitivity to coking coal prices), the total
NPV will be –INR480b, with an IRR of 2.8%. Lower iron ore prices will reduce the
benefit of iron ore integration significantly, leading to lower NPV. We believe that
spreads between prices of inputs like iron ore, coking coal, etc and steel prices will
remain subdued due to huge overcapacity in the steel sector. Hence, change in raw
material prices will be completely passed through in steel prices.
Summary: Projects of SAIL (INR m)
Project
CapEx
Total O/S as on
Sep-12
172,660
164,080
118,120
111,020
155,460
721,340
95,380
27,310
32,210
18,570
133,160
306,630
273,000
33,630
NPV
-115,780
-114,706
-75,598
-73,086
-38,525
-417,695
IRR
(%)
0.5
0.6
2.3
0.7
9.4
2.8
Remarks
capacity will expand by 2.3mtpa to 6.6mtpa
2.4mtpa of new capacity
capacity will expand by 2.1mtpa to 4mtpa
about 1.5mtpa of additional production
replacing ingot casting route with concasts
Bhilai Steel Plant
ISP Burnpur
Roorkela
BSL, DSP, Sp.steel etc
Others (cost savings $30/t)
Total
CapEx in FY13-14
O/S as on Mar 14
7 January 2013
Source: Company, MOSL
31

SAIL
SAIL: Target price calculation
(INR m)
FY15E
EBITDA
88,488
Target EBITDA multiple (x)5.0
Target EV
442,438
Net Debt
317,261
add: CWIP
(50% disc.)
118,078
Residual MCap
243,255
Target Price (INR)
59
Valuation exercise indicates more downside; Sell
Applying our two alternative approaches to valuation, we find that SAIL has downside
in all 4 situations.
1. SOTP:
We have valued operational assets at an EV of 5x one-year forward EBITDA.
We have adjusted the CWIP against the NPV of the projects to capture their intrinsic
value. SAIL’s valuations are highly sensitive to steel/iron ore prices. In the base
case scenario, where we assume iron ore prices of USD83/ton, we arrive at a value
of –INR52/share. In the optimistic scenario, where we assume iron ore prices of
USD106/ton FOB, we arrive at a value of -INR5/share.
2. FY20 valuations discounted for five years:
We arrive at FY20 valuations to factor in
completion of all ongoing projects and the possible delays. We have discounted
these valuations backwards for five years by SAIL’s cost of equity of 18.1%. In the
base case scenario, we arrive at a value of INR44/share. In the optimistic scenario,
we arrive at a value of INR74/share.
Target price (TP): Base case (Iron ore @ USD83/t fob)
SOTP Valuation
FY14 EBITDA
44,107
EV/EBITDA
5
Enterprise Value(1x2) 220,536
add: CWIP
256,157
add: NPV
-417,695
less: Net Debt
275,095
Equity value
-216,097
Equity value per share
-52
Target price (TP): Optimistic case (Iron ore @ USD106/t fob)
SOTP Valuation
FY14 EBITDA
68,408
EV/EBITDA
5
Enterprise Value(1x2) 342,039
add: CWIP
256,157
add: NPV
-344,303
less: Net Debt
275,095
Equity value
-21,202
Equity value per share
-5
7 January 2013
32

SAIL
Target price calculations (INR m)
S.N. Project
1
2
3
4
5
Bhilai Steel Plant
ISP Burnpur
Roorkela
BSL, DSP, Sp.
Others (cost savings $30/t)
Total equity in projects
add:current Operations@5xEV/EBITDA
Less: Net Debt (incl. projects)
Net Equity value for company
No. of share (m)
TP (INR/share)
TP (discounting back from FY20@Ke)
Current market Cap
Upside (%)
Equity value based on 5xEV/EBTIDA (project cost adjusted in net debt)
FY14
FY15
FY16
FY17
FY18
FY19
FY20
26,028
24,387
28,850
34,704
32,516
28,850
101,277
226,197
220,536
244,386
202,347
4,130
49
52
384,127
-47
44,236
41,645
38,612
28,850
101,277
254,621
220,536
203,287
271,870
4,130
66
61
384,127
-29
44,236
41,645
38,612
28,850
101,277
254,621
220,536
156,144
319,013
4,130
77
72
384,127
-17
44,236
44,236
41,645
41,645
38,612
38,612
28,850
28,850
101,277
101,277
254,621
254,621
220,536
220,536
107,858
58,321
367,298
416,836
4,130
4,130
89
101
85
101
384,127
384,127
-4
9
Source: Company, MOSL
220,536
275,095
37
50,415
220,536
277,811
-6,860
4,130
-2
44
384,127
-102
Bhilai Steel Plant (BSP)
Bhilai Steel Plant (BSP) is SAIL’s largest facility, with saleable steel capacity of 4.3mtpa.
It produces rails, heavy steel plates, wire rods and structural steel. Currently, it sources
iron ore from its captive iron ore mine, Dalli Rajhara. It is developing a 12mtpa mine
at Rowghat for future raw material requirement, as the Dalli Rajhara mine is nearing
the end of its life. It has planned capex of INR173b to enhance saleable steel capacity
from 4.3mtpa to 6.6mtpa. SAIL is adding coke oven battery, sinter plant, blast furnace
VIII (2.8mtpa), SMS, billet/bloom caster, universal rail mill, bar & rod mill, and is
augmenting existing auxiliary facilities. The scheduled commissioning date for most
of its facilities is September 2013, but we expect actual production to start in FY16.
According to our calculations, the project has an NPV of –INR94b, with an IRR of 3.8%
in the optimistic scenario. The NPV will further reduce to –INR116b, with an IRR of
0.5% in the base case scenario.
Free cash flow to firm (INR m)
FY14
a. EBITDA
b. Depreciation
c. NOPLAT=(a-b)*(1-Tax rate)
d. Capex
e. change in Working Capital
FCFF (c+b+d+e)
Present Value (Cumulative)
FY15
FY16
5,770
6,906
-909
0
-5,467
530
39,696
FY17
8,847
6,975
1,497
-1,727
-2,916
3,831
44,740
FY18
8,847
7,045
1,442
-1,744
0
6,743
47,191
FY19
8,847
7,116
1,385
-1,761
0
6,740
47,075
FY20
...FY39
8,847
8,847
7,187
8,682
1,328
115
-1,779
-2,149
0
0 Terminal
6,736
6,649
Value
46,945
38,186
36,747
Source: Company, MOSL
-172,660
-115,780
7 January 2013
33

SAIL
Bhilai Steel Plant: Net present value (USD million)
90
60
70
80
90
100
110
120
(2,796)
(2,602)
(2,408)
(2,214)
(2,020)
(1,825)
(1,631)
110
(2,799)
(2,605)
(2,411)
(2,217)
(2,023)
(1,829)
(1,635)
130
(2,803)
(2,609)
(2,414)
(2,220)
(2,026)
(1,832)
(1,638)
Coking coal prices USD/ton
150
170
190
210
(2,806)
(2,612)
(2,418)
(2,224)
(2,030)
(1,835)
(1,641)
(2,809)
(2,615)
(2,421)
(2,227)
(2,033)
(1,839)
(1,645)
(2,813)
(2,619)
(2,424)
(2,230)
(2,036)
(1,842)
(1,648)
(2,816)
(2,622)
(2,428)
(2,234)
(2,039)
(1,845)
(1,651)
230
(2,819)
(2,625)
(2,431)
(2,237)
(2,043)
(1,849)
(1,655)
250
(2,823)
(2,628)
(2,434)
(2,240)
(2,046)
(1,852)
(1,658)
270
290
(2,826) (2,829)
(2,632) (2,635)
(2,438) (2,441)
(2,244) (2,247)
(2,049) (2,053)
(1,855) (1,859)
(1,661) (1,664)
Source: MOSL
Bhilai Steel Plant: Internal rate of return (IRR, %)
90
60
70
80
90
100
110
120
-
(1.8)
0.1
1.7
3.1
4.3
5.5
110
-
(1.8)
0.1
1.6
3.1
4.3
5.5
130
-
(1.8)
0.1
1.6
3.0
4.3
5.5
Coking coal prices USD/ton
150
170
190
210
-
(1.8)
0.1
1.6
3.0
4.3
5.5
-
(1.8)
0.1
1.6
3.0
4.3
5.5
-
(1.8)
0.0
1.6
3.0
4.3
5.5
-
(1.8)
0.0
1.6
3.0
4.3
5.5
230
-
(1.8)
0.0
1.6
3.0
4.3
5.5
250
-
(1.8)
0.0
1.6
3.0
4.3
5.5
270
290
-
-
(1.8)
(1.8)
0.0
0.0
1.6
1.6
3.0
3.0
4.3
4.2
5.4
5.4
Source: MOSL
Key assumptions
USD/INR =
Iron ore prices =
Coking coal=
HRC =
55.0
83
170
479
Cost of equity =
Interest rate =
Debt/project cost =
Tax rate =
18%
10%
40%
20%
Source: MOSL
Our sensitivity analysis indicates that BSP’s expansion and modernization will result
in negative NPV for the most likely range of iron ore and coking coal prices. The NPV
turns positive at iron ore realization of USD177/ton due to the benefits of SAIL’s 100%
iron ore integration. NPV sensitivity to coking coal prices is low, as SAIL depends upon
external sourcing of coking coal. Any change in coking coal prices also translates into
similar change in steel realization.
Rourkela Steel Plant (RSP)
SAIL’s Rourkela Steel Plant (RSP) has saleable steel capacity of 2.1mtpa. It produces
various flats, tubular and coated products to cater to the Power, Oil & Gas and Packaging
sectors. It gets iron ore from its captive iron ore mine at Barsua. It has planned capex
of INR118b to enhance its saleable steel capacity from 2.1mtpa to 4mtpa. It is also
adding coke oven battery, sinter plant, blast furnace V (2.9mtpa), plate mill and is
augmenting SMS II. The coke oven battery and sinter plant have already started. The
scheduled commissioning date for most of its facilities is March 2013 and we expect
enhanced capacity to run at 32% utilization in FY14, the first year of operations.
According to our calculations, the project will have an NPV of –INR59b, with an IRR of
5.4% in the optimistic scenario. The NPV will reduce further to –INR76b, with an IRR of
2.3% in the base case scenario.
7 January 2013
34

SAIL
Free cash flow to firm (INR m)
a. EBITDA
b. Depreciation
c. NOPLAT=(a-b)*(1-Tax rate)
d. Capex
e. change in Working Capital
FCFF (c+b+d+e)
Present Value (Cumulative)
FY14
2,439
4,725
-1,829
0
-2,187
709
31,302
FY15
4,877
4,772
84
-1,181
-2,187
1,488
35,238
FY16
6,503
4,820
1,347
-1,193
-1,458
3,516
38,698
FY17
7,722
4,868
2,284
-1,205
-1,093
4,853
40,616
FY18
7,722
4,917
2,245
-1,217
0
5,944
41,466
FY19
7,722
4,966
2,205
-1,229
0
5,942
41,344
FY20
...FY39
7,722
7,722
5,015
6,059
2,166
1,164
-1,241
-1,500
0
0
Terminal
5,940
5,724
value
41,208
32,881
31,642
Source: Company, MOSL
-118,120
-75,598
Rourkela Steel Plant: Net present value (USD million)
90
60
70
80
90
100
110
120
(1,866)
(1,721)
(1,576)
(1,432)
(1,287)
(1,143)
(998)
110
(1,868)
(1,723)
(1,579)
(1,434)
(1,290)
(1,145)
(1,001)
130
(1,870)
(1,726)
(1,581)
(1,437)
(1,292)
(1,148)
(1,003)
Coking coal prices USD/ton
150
170
190
210
(1,873)
(1,728)
(1,584)
(1,439)
(1,295)
(1,150)
(1,005)
(1,875)
(1,731)
(1,586)
(1,442)
(1,297)
(1,152)
(1,008)
(1,878)
(1,733)
(1,589)
(1,444)
(1,299)
(1,155)
(1,010)
(1,880)
(1,736)
(1,591)
(1,447)
(1,302)
(1,157)
(1,013)
230
(1,883)
(1,738)
(1,594)
(1,449)
(1,304)
(1,160)
(1,015)
250
(1,885)
(1,741)
(1,596)
(1,451)
(1,307)
(1,162)
(1,018)
270
290
(1,888) (1,890)
(1,743) (1,745)
(1,598) (1,601)
(1,454) (1,456)
(1,309) (1,312)
(1,165) (1,167)
(1,020) (1,023)
Source: MOSL
Rourkela Steel Plant: Internal rate of return (IRR, %)
90
60
70
80
90
100
110
120
-
0.1
1.8
3.4
4.7
6.0
7.2
110
-
0.1
1.8
3.3
4.7
6.0
7.1
130
-
0.1
1.8
3.3
4.7
6.0
7.1
Coking coal prices USD/ton
150
170
190
210
-
0.0
1.8
3.3
4.7
5.9
7.1
-
0.0
1.8
3.3
4.7
5.9
7.1
-
0.0
1.8
3.3
4.7
5.9
7.1
-
0.0
1.8
3.3
4.7
5.9
7.1
230
-
0.0
1.8
3.3
4.7
5.9
7.1
250
-
(0.0)
1.8
3.3
4.6
5.9
7.1
270
290
-
-
(0.0)
(0.0)
1.7
1.7
3.3
3.3
4.6
4.6
5.9
5.9
7.1
7.0
Source: MOSL
Our sensitivity analysis indicates that RSP’s expansion and modernization will result
in negative NPV for the most likely range of iron ore and coking coal prices. The NPV
turns positive at iron ore realization of USD161/ton due to the benefits of SAIL’s 100%
iron ore integration. NPV sensitivity to coking coal prices is low, as SAIL depends upon
external sourcing of coking coal. Any change in coking coal prices also translates into
similar change in steel realization.
ISSCO Steel Plant (ISP)
The ISSCO Steel Plant (ISP) has saleable steel capacity of 0.3mtpa. It produces steel
structures, special sections as well as pig iron. It gets metallurgical coke from captive
mines at Chasnalla and Jitpur, and thermal coal from captive mines at Gua. It is also
developing mines at Chiria. It has planned capex of INR118b to enhance saleable
steel capacity from 0.3mtpa to 2.4mtpa. It is also adding coke oven battery, sinter
plant, blast furnace (2.7mtpa), BOF, billet caster, HSM, bar mill and wire rod mill. The
coke oven battery and sinter plant have already started. Commissioning of individual
facilities began in May 2012, while the major facilities are expected to be
7 January 2013
35

SAIL
commissioned by March 2013. We expect its capacity to run at 25% utilization in FY14,
the first year of operations. According to our calculations, the project will have an
NPV of –INR94b, with an IRR of 3.9% in the optimistic scenario. The NPV will further
reduce to –INR115b, with an IRR of 0.6% in the base case scenario.
Free cash flow to firm (INR m)
a. EBITDA
b. Depreciation
c. NOPLAT=(a-b)*(1-Tax rate)
d. Capex
e. change in Working Capital
FCFF (c+b+d+e)
Present Value (Cumulative)
FY14
2,082
6,563
-3,585
0
-2,187
792
32,350
FY15
5,206
6,629
-1,139
-1,641
-3,280
569
36,360
FY16
6,941
6,695
197
-1,657
-1,822
3,412
40,896
FY17
8,329
6,762
1,254
-1,674
-1,458
4,884
43,226
FY18
8,329
6,830
1,200
-1,691
0
6,339
44,411
FY19
8,329
6,898
1,145
-1,707
0
6,335
44,308
FY20
...FY39
8,329
8,329
6,967
8,417
1,090
-61
-1,724
-2,083
0
0
Terminal
6,332
6,272
Value
44,195
36,022
34,664
Source: Company, MOSL
-164,080
-114,706
ISSCO Steel Plant: Net present value (USD million)
90
60
70
80
90
100
110
120
(2,743)
(2,563)
(2,383)
(2,203)
(2,023)
(1,843)
(1,663)
110
(2,746)
(2,566)
(2,386)
(2,206)
(2,026)
(1,846)
(1,666)
130
(2,749)
(2,569)
(2,389)
(2,209)
(2,029)
(1,849)
(1,669)
Coking coal prices USD/ton
150
170
190
210
(2,752)
(2,572)
(2,392)
(2,212)
(2,032)
(1,852)
(1,672)
(2,755)
(2,575)
(2,395)
(2,215)
(2,035)
(1,855)
(1,675)
(2,758)
(2,578)
(2,398)
(2,218)
(2,038)
(1,858)
(1,678)
(2,761)
(2,581)
(2,401)
(2,221)
(2,041)
(1,861)
(1,681)
230
(2,764)
(2,584)
(2,404)
(2,224)
(2,044)
(1,864)
(1,684)
250
(2,767)
(2,587)
(2,407)
(2,227)
(2,047)
(1,867)
(1,687)
270
290
(2,770) (2,773)
(2,590) (2,593)
(2,410) (2,413)
(2,230) (2,233)
(2,050) (2,053)
(1,870) (1,873)
(1,690) (1,693)
Source: MOSL
ISSCO Steel Plant: Internal rate of return (IRR, %)
90
60
70
80
90
100
110
120
-
(1.8)
0.2
1.8
3.2
4.4
5.6
110
-
(1.8)
0.1
1.7
3.1
4.4
5.6
130
-
(1.8)
0.1
1.7
3.1
4.4
5.5
Coking coal prices USD/ton
150
170
190
210
-
(1.8)
0.1
1.7
3.1
4.4
5.5
-
(1.8)
0.1
1.7
3.1
4.4
5.5
-
(1.8)
0.1
1.7
3.1
4.4
5.5
-
(1.8)
0.1
1.7
3.1
4.4
5.5
230
-
(1.8)
0.1
1.7
3.1
4.3
5.5
250
-
(1.8)
0.1
1.7
3.1
4.3
5.5
270
290
-
-
(1.8)
(1.8)
0.1
0.1
1.7
1.7
3.1
3.1
4.3
4.3
5.5
5.5
Source: MOSL
Our sensitivity analysis indicates that ISP’s expansion and modernization will result
in negative NPV for the most likely range of iron ore and coking coal prices. The NPV
turns positive at iron ore realization of USD182/ton due to the benefits of SAIL’s 100%
iron ore integration. NPV sensitivity to coking coal prices is low, as SAIL depends upon
external sourcing of coking coal. Any change in coking coal prices also translates into
similar change in steel realization.
Capacity upgradation at BSL, DSP, VISL, SSP and ASP
Apart from adding capacity through new furnaces in BSP, RSP and ISP, SAIL is also
increasing capacity at the following facilities through modernization and repair. Total
capacity expansion at BSL, DSP, VISL, ASP and SSP combined is 1.5mtpa of saleable
steel. Although individual facilities have started commissioning, we expect meaningful
contribution to begin from FY16.
7 January 2013
36

SAIL
Bokaro Steel Plant (BSL):
BSL has saleable steel capacity of 3.3mtpa. It produces mainly
flat products and special grade steel. It gets iron ore from its captive iron ore mines at
Kiriburu, Meghahataburu, Bhawanathpur, Tulsidamar and Kuteshwar. It has planned
capex of INR63.3b to enhance saleable steel capacity from 3.3mtpa to 4.2mtpa. It is
adding a CRM facility while upgrading/rebuilding two coke oven batteries, two blast
furnaces, SMS, HSM and augmenting raw material handling facilities.
Durgapur Steel Plant (DSP):
DSP has saleable steel capacity of 1.8mtpa. Its product
mix includes mainly semis, structural and merchant products. It gets iron ore from
captive mines at Bolani in Orissa. It is expanding capacity to 2.1mtpa through
modernization and upgradation of existing facilities. It is rebuilding its coke oven
battery while adding bloom caster, structural mill, oxygen plant and is upgrading raw
material handling facilities. Total capital outlay for the project is INR29b.
Visvesvaraya Iron and Steel Plant (VISL):
VISL has saleable steel capacity of 0.1mtpa,
which is being expanded to 0.2mtpa. It produces special alloy and forged steel. It
sources iron ore from NMDC.
Alloy Steels Plant (ASP):
ASP has saleable steel capacity of 0.2mtpa, which is being
expanded to 0.4mtpa. It produces special alloy and stainless steel. SAIL recently signed
an MoU with Kobe Steel to set up a 0.5mtpa iron ore nugget plant at ASP based on
ITmk3 technology.
Salem Steel Plant (SSP):
SSP has saleable steel capacity of 0.3mtpa, which is being
expanded to 0.34mtpa. It is adding SMS and CRM facilities, and is augmenting other
facilities, for which entire capex of INR19b has already been incurred. It produces
mainly stainless steel products.
We estimate that SAIL’s various upgradation measures at BSL, DSP, SSP, ASP and VISL
will involve cumulative capex of INR111b. According to our calculations, these projects
will have an NPV of –INR58b, with an IRR of 4.1% in the optimistic scenario, where we
assume iron ore prices of USD106/ton. The NPV will further reduce to –INR73b, with
an IRR of 0.7% in the base case scenario, where we assume iron ore prices of USD83/
ton.
Free cash flow to firm (INR m)
FY14
a. EBITDA
b. Depreciation
c. NOPLAT=(a-b)*(1-Tax rate)
d. Capex
e. change in Working Capital
FCFF (c+b+d+e)
Present Value (Cumulative)
FY15
FY16
5,770
4,441
1,063
0
-5,467
37
27,087
FY17
5,770
4,485
1,028
-1,110
0
4,403
30,853
FY18
5,770
4,530
992
-1,121
0
4,401
30,782
FY19
5,770
4,575
956
-1,133
0
4,399
30,704
FY20
...FY39
5,770
5,770
4,621
5,583
919
131
-1,144
-1,382
0
0
Terminal
4,396
4,332
value
30,617
24,881
23,943
Source: Company, MOSL
-111,020
-73,086
7 January 2013
37

SAIL
Net present value (USD million)
90
60
70
80
90
100
110
120
(1,787)
(1,655)
(1,522)
(1,390)
(1,257)
(1,125)
(992)
110
(1,790)
(1,657)
(1,525)
(1,392)
(1,260)
(1,127)
(994)
130
(1,792)
(1,659)
(1,527)
(1,394)
(1,262)
(1,129)
(997)
Coking coal prices USD/ton
150
170
190
210
(1,794)
(1,662)
(1,529)
(1,397)
(1,264)
(1,131)
(999)
(1,796)
(1,664)
(1,531)
(1,399)
(1,266)
(1,134)
(1,001)
(1,799)
(1,666)
(1,534)
(1,401)
(1,269)
(1,136)
(1,003)
(1,801)
(1,668)
(1,536)
(1,403)
(1,271)
(1,138)
(1,006)
230
(1,803)
(1,671)
(1,538)
(1,406)
(1,273)
(1,141)
(1,008)
250
(1,805)
(1,673)
(1,540)
(1,408)
(1,275)
(1,143)
(1,010)
270
(1,808)
(1,675)
(1,543)
(1,410)
(1,278)
(1,145)
(1,013)
290
(1,810)
(1,677)
(1,545)
(1,412)
(1,280)
(1,147)
(1,015)
Internal rate of return (IRR, %)
90
60
70
80
90
100
110
120
-
(1.6)
0.3
1.9
3.3
4.6
5.9
110
-
(1.6)
0.3
1.9
3.3
4.6
5.9
130
-
(1.6)
0.2
1.9
3.3
4.6
5.9
Coking coal prices USD/ton
150
170
190
210
-
(1.6)
0.2
1.8
3.3
4.6
5.9
-
(1.6)
0.2
1.8
3.3
4.6
5.8
-
(1.7)
0.2
1.8
3.3
4.6
5.8
-
(1.7)
0.2
1.8
3.3
4.6
5.8
230
-
(1.7)
0.2
1.8
3.2
4.6
5.8
250
-
(1.7)
0.2
1.8
3.2
4.6
5.8
270
290
-
-
(1.7)
(1.7)
0.2
0.2
1.8
1.8
3.2
3.2
4.6
4.5
5.8
5.8
Source: MOSL
Our sensitivity analysis indicates that capacity upgradation at BSL, DSP, VISL, SSP and
ASP will result in negative NPV for the most likely range of iron ore and coking coal
prices. The NPV turns positive at iron ore realization of USD170/ton due to the benefits
of SAIL’s 100% iron ore integration. NPV sensitivity to coking coal prices is low, as SAIL
depends upon external sourcing of coking coal. Any change in coking coal prices also
translates into similar change in steel realization.
Value addition, development of new mine, technological upgradation
Apart from adding capacity through new furnaces and upgradation/repair of old facilities,
SAIL has also undertaken various cost saving measures such as improving product mix,
augmenting old mines, developing new mines and technological upgradation. The
cumulative capex for such measures is close to INR155b. We expect cost savings of
USD30/ton on existing production on account of these measures. According to our
calculations, these initiatives will have an NPV of –INR39b, with an IRR of 9.4%.
Free cash flow to firm (INR m)
FY14
a. EBITDA
b. Depreciation
c. NOPLAT=(a-b)*(1-T)
d. Capex
FCFF (c+b+d)
Present Value (Cumulative)
FY15
FY16
20,255
6,218
11,230
0
17,448
111,218
FY17
20,255
6,281
11,180
-1,555
15,906
109,386
FY18
20,255
6,343
11,130
-1,570
15,903
108,840
FY19
20,255
6,407
11,079
-1,586
15,900
108,220
FY20
20,255
6,471
11,028
-1,602
15,897
107,515
...FY39
20,255
7,818
8,707
-1,935
Terminal
14,589
Value
83,847
80,696
-155,460
-38,525
Value addition: Net present value (USD million)
Margin improvement due to investment in Continuous casting (USD/ton)
5
10
15
20
25
30
35
40
45
50
(2,426) (2,098) (1,770) (1,442) (1,114)
(786)
(458)
(130)
198
526
55
854
Value addition: Internal rate of return (IRR, %)
5
-
7 January 2013
10
(0.1)
15
2.7
Coking coal prices USD/ton
20
25
30
35
5.2
7.4
9.4
11.3
40
13.2
45
15.1
50
55
16.9
18.7
Source: MOSL
38

SAIL
Financials and Valuation
Income Statement (Consolidated)
Y/E March
Net Sales
Change (%)
Total Expenditure
EBIDTA
Change (%)
% of Sales
Depreciation
EBIT
Interest
Other income
PBT before EO
Extra ordinary Item
PBT
Total Tax
Effective Rate (%)
Reported PAT
Change (%)
Minority Interest
Adjusted PAT
Change (%)
2011
433,994
7.0
354,567
79,427
-16.0
18.3
16,030
63,398
5,724
14,923
72,597
1,239
73,836
23,696
32.1
50,140
-26.8
1.8
49,296
-27.7
2012
466,582
7.5
402,541
64,041
-19.4
13.7
16,859
47,182
7,782
16,046
55,446
-2,620
52,826
16,897
32.0
35,930
-28.3
37,711
-23.5
2013E
443,974
-4.8
384,411
59,563
-7.0
13.4
21,129
38,434
9,091
8,037
37,380
-2,151
35,229
12,427
35.3
22,803
-36.5
24,195
-35.8
2014E
488,067
9.9
404,656
83,411
40.0
17.1
25,197
58,214
12,741
3,183
48,655
48,655
14,079
28.9
34,577
51.6
34,576
42.9
(INR Million)
2015E
523,997
7.4
435,510
88,488
6.1
16.9
29,068
59,419
16,215
1,303
44,507
44,507
16,232
36.5
28,275
-18.2
28,274
-18.2
Balance Sheet (Consolidated)
Y/E March
Share Capital
Reserves and Surplus
Share holders fund
Loans
Deferred Tax Liability
Minority Interest
Capital Employed
Gross Fixed Assets
Less: Depreciation
Net Fixed Assets
Capital WIP
Investments
Curr. Assets, Loans & Advances
Inventory
Sundry Debtors
Cash & Bank Balances
Interest Receivable/Accrued
Loans and Advances
Current Liabilities
Sundry Creditors
Other Current Liabilities
Provisions
Net Current Assets
Application of Funds
E: MOSL Estimates
2011
41,304
334,823
376,127
204,751
15,567
12
596,457
404,391
238,301
166,091
224,220
608
2012
41,305
361,426
402,732
173,606
17,817
594,155
440,657
253,014
187,643
283,157
685
2013E
41,305
374,564
415,869
237,101
17,817
670,788
490,657
274,143
216,514
353,157
685
2014E
41,305
399,475
440,780
322,169
17,817
780,766
740,657
299,340
441,317
256,157
685
(INR Million)
2015E
41,305
418,084
459,390
344,345
17,817
821,552
840,657
328,408
512,249
236,157
685
115,069
40,799
177,490
25,146
31,549
138,989
48,478
66,623
22,669
36,711
121,637
42,573
76,979
22,669
36,711
133,717
46,801
47,074
22,669
36,711
143,561
50,246
27,084
22,669
36,711
32,651
91,210
60,654
205,538
596,457
33,236
97,603
59,962
122,670
594,155
42,573
97,603
59,962
100,431
670,788
46,801
97,603
59,962
82,607
780,766
50,246
97,603
59,962
72,461
821,552
7 January 2013
39

SAIL
Financials and Valuation
Ratios (Consolidated)
Y/E March
Basic (INR)
EPS
Cash EPS
Book Value per Share
Dividend Per Share
Valuation (x)
P/E
Cash PE
EV/EBITDA
EV/Sales
EV( USD/Ton)
Price to Book Value
Profitability Ratios (%)
RoE
RoCE (pre-tax)
RoIC (pre-tax)
Turnover Ratios
Debtors (Days)
Inventory (Days)
Creditors (Days)
Leverage Ratio
Debt/Equity (x)
2011
11.9
16.0
91.1
2.4
2012
9.1
12.8
97.5
2.0
2013E
5.9
10.6
100.7
2.0
2014E
8.4
14.5
106.7
2.0
2015E
6.8
13.9
111.2
2.0
10.2
7.3
7.7
1.1
788
1.0
15.9
8.7
9.1
1.2
1,196
0.9
11.1
6.4
7.9
1.4
1,182
0.9
13.6
6.7
7.9
1.3
1,154
0.8
13.8
13.9
37.2
9.7
10.6
21.6
5.9
7.3
15.9
8.1
8.5
16.2
6.3
7.6
11.5
34
97
34
38
109
30
35
100
35
35
100
35
35
100
35
0.1
0.3
0.4
0.6
0.7
Cash Flow Statement
Y/E March
OP/(Loss) before Tax
Depreciation & Amort.
Interest Paid
Direct Taxes Paid
(Inc)/Dec in Working Capital
CF from Oper. Activity
Other Items
CF after EO Items
(Inc)/Dec in FA & CWIP
(Inc)/Dec in Misc Exp.
(Pur)/Sale of Invest.
CF from Inv. Activity
Free Cash Flows
Issue of Shares
Inc / (Dec) in Debt
Interest Paid
Dividends Paid
CF from Finan. Activity
Inc / ( Dec) in Cash
Add: Opening Balance
Closing Balance
E: MOSL Estimates
7 January 2013
2011
73,836
16,030
5,724
-24,293
-32,517
38,779
1,247
40,026
-100,595
4
-162
-100,753
-61,974
28,373
-5,724
-11,617
11,032
-49,695
227,185
177,490
2012
52,826
16,859
7,782
-15,234
-27,999
34,234
-1,242
32,993
-95,202
-77
-95,279
-61,045
1
-31,145
-7,782
-9,655
-48,580
-110,867
177,490
66,623
2013E
35,229
21,129
9,091
-11,805
32,594
86,238
-632
85,606
-120,000
2014E
48,655
25,197
12,741
-13,426
-12,080
61,087
-663
60,424
-153,000
(INR Million)
2015E
44,507
29,068
16,215
-15,547
-9,844
64,400
-695
63,704
-80,000
-120,000
-33,762
63,495
-9,091
-9,655
44,750
10,356
66,623
76,979
-153,000
-91,913
85,068
-12,741
-9,655
62,671
-29,905
76,979
47,074
-80,000
-15,600
22,176
-16,215
-9,655
-3,694
-19,990
47,074
27,084
40

7 January 2013
Update | Sector: Metals
Sesa Sterlite
BSE SENSEX
S&P CNX
19,581
5,951
CMP: INR199
TP: INR205
Buy
Implied valuation of CWIP at 82% discount
Simpler group structure will re-rate stock; maintain Buy
Bloomberg
Equity Shares (m)
52-Week Range (INR)
1,6,12 Rel. Perf. (%)
M.Cap. (INR b)
M.Cap. (USD b)
SESA IN
869.1
270/153
8/-11/-5
173.0
3.1
Valuation summary (INR b)
Y/E March
2013E 2014E 2015E
Sales
722.0 731.8 759.0
EBITDA*
181.1 184.9 188.5
NP
116.7 99.2 97.2
Adj. EPS (INR) 39.4 33.5 32.8
EPS Gr(%)
26.9
-3.5 -16.7
BV/Sh. (INR) 72.7 96.8 120.5
RoE (%)
15.9 12.2 11.0
RoCE (%)
24.1 13.0 11.9
Payout (%)
10.4 12.2 12.5
Valuation
P/E (x)
5.1
5.9
6.1
P/BV
0.8
0.7
0.6
EV/EBITDA (x)* 5.7
5.4
5.1
Div. Yield (%) 3.1
3.1
3.1
*Attributable
Sesa-Sterlite has witnessed considerable de-rating due to its burgeoning CWIP. Financial
stress on the merged entity's balance sheet due to leveraged buyout of Cairn India
and Vedanta Aluminum acquisition, and temporary suspension of iron ore mining in
Goa has resulted in further de-rating.
Sesa-Sterlite's CWIP/MCap ratio has ballooned to 67%. The implied valuation of its
CWIP is at 82% discount. With capex intensity peaking and LME prices at the bottom
from the margins perspective, we do not anticipate further increase in the discount.
The highly probable buyout of remaining stake in Hindustan Zinc and its subsequent
merger with Sesa-Sterlite will relieve balance sheet stress and re-rate the stock.
Our two alternative valuation approaches suggest equity value of INR182/share and
INR165/share in the base case, and INR331/share and INR248/share in the optimistic
case. We maintain Buy.
The Sesa-Sterlite group has undertaken projects totaling INR797b, of which
projects worth INR522b will not be contributing to the merged entity’s earnings
even in FY14 due to project delays. By the end of FY13, net debt will be INR436b
and CWIP will be INR398b. By the end of FY14, CWIP will increase further to
INR466b, while net debt will increase to INR706b (ex-Cairn India cash) if the minority
stakes in Hindustan Zinc and Balco are also bought out in all cash offer and merged
with Sesa-Sterlite.
CWIP/MCap at 67%; CWIP/EV at 39%
CWIP/MCap has increased to 67% and CWIP/EV has increased to 39%. These ratios
are much beyond the acceptable range of 20-30% for growth companies. Earnings
have grown through both the organic and inorganic routes; yet the market cap has
come under pressure (despite equity infusion of USD3.5b-4b) due to investment
in low IRR projects and leveraged buyout of Cairn India. High debt in low cash flow
businesses and non-fungible surplus cash in Hindustan Zinc and Cairn India has
de-rated the stock.
CWIP burgeoning (INR b)
Shareholding pattern (%)
As on
Sep-12
Promoter
55.1
Dom. Inst
4.2
Foreign
27.0
Others
13.7
Jun-12 Sep-11
55.1
55.1
4.3
5.2
26.4
24.1
14.1
15.7
Stock performance (1 year)
Source: Company, MOSL
41

Sesa Sterlite
Summary: Projects of Sesa-Sterlite (INR m)
Project
Total
CapEx
O/S
post FY14
-37,171
-74,033
-13,855
93,767
74,250 -257,796
NPV
IRR Remarks
(%)
-0.2 Operating asset, LME=USD2000/t
-0.1 Operating asset, LME=USD2000/t
7.9 Operating asset, rate of INR3.3/kwh
Operating asset, but closed due to mining ban
Project is put on hold because of cash losses
at current LME
7.8 Near completion
7.6 Near completion
5.4 commissioning during FY14-15
5.8 Production start in FY15
3.3
Source: Company, MOSL
Lanjigarh (1.6mtpa Alumina +90MW CPP)
57,750
VAL phase 1 (500ktpa Ali smlter + 1215MW CPP)113,465
SEL (2400MW)
104,500
Sesa Goa
VAL phase 2 (1.25mtpa Ali)
253,000
Balco (325ktpa + 600MW)
Balco 600MW surplus CPP
Talwandi Sabo (1980MW)
Liberia
Total
Projects*
*no contribution in earnings until FY14
73,975
-19,352
34,375
-7,531
118,250 35,475 -42,413
42,075 37,868 -13,381
797,390 147,593 -371,765
521,675 147,593 -266,223
Ratios have started rising
Net Debt increasing in sync with CWIP
Target price calculations (INR m)
S.N. Project
1
2
3
4
5
6
7
8
9
Equity value based on 5xEV/EBTIDA (CapEx & cash flows adjusted in debt)
FY14
FY15
FY16
FY17
FY18
FY19
FY20
10,805
22,719
89,482
105,773
28,388
21,226
85,752
1,801
242,939
684,036
437,760
722,305
642,430
2,965
217
165
590,035
9
13,506
20,698
89,592
111,038
37,817
25,876
87,399
3,602
265,733
684,036
487,680
706,076
731,373
2,965
247
197
590,035
24
13,506
18,029
87,272
110,341
39,446
28,201
85,124
7,205
270,316
684,036
543,292
677,613
820,031
2,965
277
235
590,035
39
13,506
19,986
83,533
109,583
40,105
28,201
81,444
14,410
273,743
684,036
605,247
630,766
932,260
2,965
314
281
590,035
58
13,506
22,139
80,492
108,759
13,506
24,506
77,396
107,862
Lanjigarh (1.6mtpa Alumina +90MW CPP)
VAL phase 1 (500ktpa Ali smlter + 1215MW CPP)
SEL (2400MW)
Sesa Goa
VAL phase 2 (1.25mtpa Ali)
--- Project is on hold ---
Balco (325ktpa + 600MW)
Balco 600MW surplus CPP
Talwandi Sabo (1980MW)
Liberia
Total equity in new projects (4+5+6+7+8+9)
add:5xEV/EBITDA (excl. Cairn)
684,036
add: Cairn India equity (58.9%)
392,950
Less: Net Debt*
706,356
Net Equity value for company (incl. 1+2+3+4) 370,629
No. of share (m)
2,965
TP (INR/share)
TP (discounting back from FY20@Ke)
Current market Cap
Upside (%) w.r.t. CMP
*(incl. HZL&Balco buyout; Ex Cairn)
7 January 2013
40,830
41,627
28,201
27,675
78,403
75,343
21,615
21,615
277,807
274,122
684,036
684,036
674,266
751,156
579,758
523,655
1,056,352 1,185,658
2,965
2,965
356
400
335
400
590,035
590,035
79
101
Source: Company, MOSL
42

Sesa Sterlite
Expect stock re-rating; maintain Buy
Applying our two alternative approaches to valuation, we find that Sesa-Sterlite has
significant upside in 2 of the 4 situations.
1. SOTP:
We have valued operational assets (ex Cairn India) at an EV of 5x one-year
forward EBITDA. We have adjusted the CWIP against the NPV of the projects to
capture their intrinsic value. For Cairn India, we have used our Oil & Gas team’s
DCF-based valuation of INR350/share. In the base case scenario, where we assume
LME aluminum lead and zinc prices of USD2,000/ton and iron ore prices of USD83/
ton, we arrive at a value of INR182/share for Sesa-Sterlite. In the optimistic
scenario, where we assume LME aluminum, lead and zinc prices of USD2,500/ton
and iron ore prices of USD106/ton, we arrive at a value of INR331/share.
2. FY20 valuations discounted for five years:
We arrive at FY20 valuations to factor in
completion of all ongoing projects and the possible delays. We have discounted
these valuations backwards for five years by Sesa-Sterlite’s cost of equity of 19.3%.
We have added the value of Cairn India stake separately. In the base case scenario,
where we assume LME aluminum, lead and zinc prices of USD2,000/ton and iron
ore prices of USD83/ton, we arrive at a value of INR165/share. In the optimistic
scenario, where we assume LME aluminum, lead and zinc prices of USD2,500/ton
and iron ore prices of USD106/ton, we arrive at a value of INR248/share.
Assumptions
Projects worth INR522b, which will not be contributing to FY14 earnings, will have
a combined weighted average IRR (WAIRR) of just 3.3% and negative NPV (-INR266b
after adjusting for the unspent INR74b on the stalled VAL phase-2 project).
Therefore, we believe it is fair to adjust this amount from the CWIP in the valuation
of Sesa-Sterlite.
Sesa-Sterlite has undertaken numerous projects to significantly enhance its
aluminum, energy and iron ore capacities. The capex is heavily skewed in favor of
aluminum (64% share of capex), where NPV is significantly negative due to
suppressed LME prices and low level of backward integration. Most of these
projects have very low IRR, particularly VAL phase-2, which will incur cash losses
at current LME prices. The valuation of Sesa-Sterlite will continue to be undermined
by these projects until and unless it is able to get coal and bauxite mining projects
operational.
We believe that Sesa-Sterlite will be able to buy out minority stakes in Hindustan
Zinc and Balco in the near term, given the government’s eagerness to meet its
divestment targets. We have, therefore, valued Sesa-Sterlite assuming 100%
buyout of Hindustan Zinc and Balco. We have assumed buyout at the upper limit
(to be conservative) of INR249b to achieve 100% stake in both Hindustan Zinc and
Balco.
7 January 2013
43

Sesa Sterlite
SOTP Valuation
FY14 EBITDA
129,895
EV/EBITDA
5
Enterprise Value(1x2) 649,475
add: Cairn
392,950
add: Sesa Goa DCF 105,773
add: CWIP
364,538
add: NPV
-266,223
less: Net Debt
706,356
Equity value
540,156
Equity value per share
182
Key assumption: iron ore at
USD83/t; ali at USD2000/t
Target Price (TP): Optimistic scenario
Target Price (TP): Base case
SOTP Valuation
FY14 EBITDA
176,107
EV/EBITDA
5
Enterprise Value(1x2) 880,537
add: Cairn
392,950
add: Sesa Goa DCF 163,436
add: CWIP
364,538
add: NPV
-151,958
less: Net Debt
668,031
Equity value
981,471
Equity value per share
331
Key assumption: iron ore at
USD106/t; ali at USD2500/t
Source: MOSL
VAL Phase-2 (1.25mtpa expansion): NPV of –INR258b
Vedanta Aluminum (VAL) plans to expand its smelting capacity at Jharsuguda by
1.25mtpa from the current 0.5mtpa. Total capex for the project is INR253b (including
partial work on refinery expansion). About INR179b has already been incurred, but
the project has been halted due to falling IRR and uncertainty regarding bauxite and
coal. The project will not be able to recover its cash cost due to absence of captive
bauxite and coal, and suppressed LME prices. VAL’s earlier attempt to get cheap bauxite
through Niyamgiri mines ran into regulatory hurdles. Total project NPV is -INR258b
due to cash losses at current LME prices. We believe Sesa-Sterlite is better off not
committing any more capital until and unless it has visibility of cheaper raw material
supply and higher LME prices.
Free cash flow to firm (INR m)
FY14
a. EBITDA
b. Depreciation
c. NOPLAT=(a-b)*(1-Tax rate)
d. Capex
e. change in Working Capital
FCFF (c+b+d+e)
FY15
-894
10,815
-9,367
-17,380
-1,207
-17,138
FY16
-1,787
11,517
-10,644
-17,554
-1,207
-17,887
FY17
-2,681
12,227
-11,926
-17,729
-1,207
-18,635
FY18
-3,574
12,943
-13,214
-17,907
-1,207
-19,384
FY19
-4,468
13,666
-14,507
-18,086
-1,207
-20,133
FY20
...FY37
-5,361 -10,722
13,803
16,347
-15,331 -21,655
-3,417
-4,046
Terminal
-1,207
0
value
-6,152
-9,355 -48,279
Source: Company, MOSL
-178,750
7 January 2013
44

Sesa Sterlite
Project NPV to remain negative unless it gets cheaper power and LME prices increase
1,600
1.0
1.5
2.0
2.5
3.0
3.5
4.0
(3,254)
(3,780)
(4,305)
(4,831)
(5,356)
(5,882)
(6,408)
1,700
(3,008)
(3,533)
(4,059)
(4,585)
(5,110)
(5,636)
(6,161)
1,800
(2,762)
(3,287)
(3,813)
(4,339)
(4,864)
(5,390)
(5,915)
LME USD/ton
1,900
2,000
2,250
(2,516)
(3,041)
(3,567)
(4,092)
(4,618)
(5,144)
(5,669)
(2,269)
(2,795)
(3,321)
(3,846)
(4,372)
(4,897)
(5,423)
(1,654)
(2,180)
(2,705)
(3,231)
(3,756)
(4,282)
(4,808)
2,500
(1,039)
(1,564)
(2,090)
(2,616)
(3,141)
(3,667)
(4,192)
2,700
(546)
(1,072)
(1,598)
(2,123)
(2,649)
(3,174)
(3,700)
2,800
(300)
(826)
(1,351)
(1,877)
(2,403)
(2,928)
(3,454)
2,900
3,000
(54)
192
(580)
(334)
(1,105)
(859)
(1,631) (1,385)
(2,157) (1,910)
(2,682) (2,436)
(3,208) (2,962)
Source: MOSL
19%
10%
70/30
20%
Source: MOSL
Key assumptions
USD/INR =
CPC/LME =
Alumina/LME =
Import duty =
55.0
8%
15%
5%
Cost of equity =
Interest rate =
Debt/Equity =
Tax rate =
1mtpa Lanjigarh Refinery: NPV of -INR37b; IRR of -0.2%
VAL operates a 1mtpa alumina refinery at Lanjigarh, Odisha along with 3x30MW coal-
fired cogeneration plant. It has signed an MoU with the Odisha government under
which it will receive 150mtpa of bauxite through Orissa Mining Corporation (OMC).
However, OMC so far has not been able to supply bauxite for the refinery. As a result,
the refinery is operating at low capacity utilization. VAL had earlier planned to expand
the refinery capacity to 5mtpa (60% construction work completed), but has deferred
the expansion due to lack of regulatory clearances for the proposed expansion.
To achieve raw material security, it has invested INR2b for 24.7% stake in L&T promoted
Raykal Aluminium, which holds bauxite mining licenses in Odisha. It has the right to
acquire 100% stake over a period of time for INR18.1b, subject to achievement of
certain milestones. However, there is a long way to go before mining can start;
therefore, we have not factored this in our estimates.
The total project cost is estimated to be INR58b. Our calculations indicate that the
project delivers an NPV of -INR37b, with an IRR of -0.2%, owing to lack of captive
bauxite. However, captive bauxite mine coupled with higher realizations might lead
to positive NPV.
Free cash flow to firm (INR m)
FY14
a. EBITDA
b. Depreciation
c. NOPLAT=(a-b)*(1-Tax rate)
d. Capex
e. change in Working Capital
FCFF (c+b+d+e)
Present Value (Cumulative)
FY15
2,161
2,333
-138
-578
-434
1,183
17,020
FY16
2,701
2,356
276
-583
-434
1,615
17,347
FY17
2,701
2,380
257
-589
0
2,048
17,277
FY18
2,701
2,404
238
-595
0
2,047
17,200
FY19
2,701
2,428
219
-601
0
2,046
17,116
FY20
...FY37
2,701
2,701
2,452
2,904
199
-142
-607
-719
Terminal
0
0
value
2,044
2,043
10,546
10,451
9,527
Source: Company, MOSL
-37,171
-57,750
16,340
7 January 2013
45

Sesa Sterlite
NPV INRb
160
10
15
20
30
40
50
60
(1,448)
(1,544)
(1,639)
(1,829)
(2,019)
(2,209)
(2,399)
200
(1,196)
(1,291)
(1,387)
(1,577)
(1,767)
(1,957)
(2,147)
240
(944)
(1,039)
(1,134)
(1,325)
(1,515)
(1,705)
(1,895)
Alumina USD/ton
280
320
360
(692)
(440)
(188)
(787)
(535)
(283)
(882)
(630)
(378)
(1,073)
(820)
(568)
(1,263) (1,011)
(759)
(1,453) (1,201)
(949)
(1,643) (1,391) (1,139)
400
64
(31)
(126)
(316)
(506)
(697)
(887)
440
316
221
126
(64)
(254)
(445)
(635)
480
568
473
378
188
(2)
(193)
(383)
520
560
820
1,072
725
977
630
882
440
692
250
502
60
312
(131)
121
Source: MOSL
VAL Phase-1 (500ktpa smelter; 9x135MW CPP): NPV of –INR74b; IRR of –0.1%
VAL operates a 500ktpa smelter and 9x135MW CPP at Jharsuguda, Odisha. It has spent
INR113b on the project. It is adding 1.25mtpa smelter capacity, which is 80% complete,
but is currently on hold due to cash losses at current LME prices. According to our
calculations, the project has an NPV of –INR74b on account of lack of backward
integration and suppressed LME prices. The project IIR is –0.1%; VAL will continue to
make losses in the current pricing environment. However, the project becomes NPV
positive on lower cost of power (INR1/KWH) even at current LME prices. The associated
9x135MW power plant has partial coal linkage from Coal India.
Free cash flow to firm (INR m)
a. EBITDA
b. Depreciation
c. NOPLAT=(a-b)*(1-Tax rate)
d. Capex
e. change in Working Capital
FCFF (c+b+d+e)
Present Value (Cumulative)
FY14
4,103
4,584
-385
-1,135
489
-113,465
-74,033
FY15
4,544
4,630
-69
-1,146
-49
3,366
30,990
FY16
4,140
4,676
-429
-1,157
45
3,134
31,157
FY17
3,606
4,723
-894
-1,169
59
2,719
31,576
FY18
3,997
4,770
-618
-1,181
-43
2,928
32,458
FY19
4,428
4,818
-312
-1,193
-48
3,266
33,231
FY20
...FY37
4,901
5,573
4,866
5,763
28
-152
-1,204
-1,426
-52
0
Terminal
3,637
4,184
value
33,755
21,208
19,442
Source: Company, MOSL
NPV (INR b)
1,600
1.0
1.5
2.0
2.5
3.0
3.5
4.0
(956)
(1,368)
(1,779)
(2,191)
(2,603)
(3,014)
(3,426)
1,700
(745)
(1,156)
(1,568)
(1,980)
(2,391)
(2,803)
(3,215)
1,800
(534)
(945)
(1,357)
(1,769)
(2,180)
(2,592)
(3,003)
LME USD/ton
1,900
2,000
2,250
(322)
(734)
(1,146)
(1,557)
(1,969)
(2,381)
(2,792)
2,500
2,700
2,800
1,579
1,167
755
344
(68)
(480)
(891)
2,900
1,790
1,378
967
555
143
(268)
(680)
3,000
2,001
1,589
1,178
766
355
(57)
(469)
(111)
417
945
1,367
(523)
5
533
956
(934)
(406)
122
544
(1,346)
(818)
(290)
133
(1,758) (1,230)
(702)
(279)
(2,169) (1,641) (1,113)
(691)
(2,581) (2,053) (1,525) (1,102)
VAL Phase-1: Internal rate of return (IRR, %)
1,600
1.0
1.5
2.0
2.5
3.0
3.5
4.0
3.9
(0.4)
-
-
-
-
-
1,700
5.8
2.0
-
-
-
-
-
1,800
7.5
4.1
(0.3)
-
-
-
-
LME USD/ton
1,900
2,000
2,250
9.1
5.9
2.1
-
-
-
-
10.6
7.6
4.2
(0.1)
-
-
-
14.2
11.4
8.5
5.2
1.3
-
-
2,500
17.7
15.0
12.2
9.3
6.2
2.5
(2.4)
2,700
20.4
17.7
15.1
12.3
9.4
6.3
2.7
2,800
21.7
19.1
16.4
13.7
10.9
8.0
4.6
2,900
3,000
Power INR/kwh
(Fuel + O&M cost)
23.1
24.4
20.4
21.8
17.8
19.2
15.1
16.5
12.4
13.8
9.5
11.0
6.4
8.0
Source: MOSL
46
7 January 2013

Sesa Sterlite
Balco (325ktpa + 600MW) expansion: NPV of –INR19.4b; IRR of 7.8%
Balco is expanding its smelter capacity by 325ktpa and is adding 4x300MW power
capacity. We have valued only 2x300MW, which will serve captive requirements, under
this head. We have valued the excess 2x300MW power capacity independently. Phase-
wise commissioning has begun and the first metal tapping is expected in FY13. The
211mtpa coal block at Durgapur-II/Taraimar is awaiting stage-2 forest clearance. The
cost of power is expected to be lower post availability of captive coal. However, it will
need to procure alumina from external sources. The total project cost is likely to be
INR74b. In the absence of captive coal and at current LME prices, we expect the project
to deliver an NPV of –INR19.4b.
Free cash flow to firm (INR m)
FY13
a. EBITDA
b. Depreciation
c. NOPLAT=(a-b)*(1-Tax rate)
d. Capex
e. change in Working Capital
FCFF (c+b+d+e)
Present Value (Cumulative)
FY14
FY15
5,678
2,989
2,151
-740
-2,594
1,806
52,416
FY16
7,563
3,018
3,636
-747
-1,192
4,716
56,588
FY17
7,889
3,049
3,872
-755
-282
5,885
58,325
FY18
8,021
3,079
3,954
-762
-15
6,256
59,091
FY19
8,166
3,110
4,045
-770
-16
6,369
59,574
FY20
8,325
3,141
4,148
-777
-18
6,493
59,998
...FY37
10,111
3,720
5,113
-921
0
Terminal
7,912
value
40,071
36,728
-73,975
-19,352
Project NPV (USD m) is negative due to depressed LME and external bauxite purchase
1,600
1.0
1.5
2.0
2.5
3.0
3.5
4.0
(817)
(1,053)
(1,289)
(1,524)
(1,760)
(1,996)
(2,232)
1,700
(701)
(937)
(1,172)
(1,408)
(1,644)
(1,880)
(2,115)
1,800
(585)
(820)
(1,056)
(1,292)
(1,528)
(1,763)
(1,999)
LME USD/ton
1,900
2,000
2,250
(468)
(704)
(940)
(1,175)
(1,411)
(1,647)
(1,883)
2,500
2,700
462
227
(9)
(245)
(481)
(716)
(952)
2,800
579
343
107
(128)
(364)
(600)
(836)
2,900
3,000
(352)
(61)
230
(588)
(297)
(6)
(823)
(533)
(242)
(1,059)
(768)
(477)
(1,295) (1,004)
(713)
(1,531) (1,240)
(949)
(1,766) (1,476) (1,185)
695
811
459
576
224
340
(12)
104
(248)
(132)
(484)
(367)
(719)
(603)
Source: MOSL
Balco 600MW excess power: NPV of –INR7.5b; IRR of 7.6%
We have valued the 2x300MW power capacity, which will be in excess of Balco’s captive
requirement, independently. The total project cost is expected to be INR17.5b. The
cost of power is likely to be lower post availability of captive coal. We expect the
project to deliver an NPV of –INR7.5b; the implied IRR would be 7.6%.
Free cash flow to firm (INR m)
FY14
a. EBITDA
b. Depreciation
c. NOPLAT=(a-b)*(1-Tax rate)
d. Capex
e. change in Working Capital
FCFF (c+b+d+e)
FY15
4,245
1,994
1,806
0
-2,829
970
FY16
5,175
2,034
2,520
-688
-435
3,430
FY17
5,640
2,074
2,860
-701
-218
4,015
FY18
5,640
2,116
2,827
-715
0
4,227
FY19
5,640
2,179
2,776
-1,094
0
3,861
FY20
5,535
2,245
2,639
-1,127
37
3,794
...FY37
5,325
3,923
1,124
-3,221
Terminal
0
value
1,826
10,666
-34,375
7 January 2013
47

Sesa Sterlite
NPV (INR Billion)
2.0
(13)
(16)
(18)
(22)
(30)
Power rate (INR/kwh)
2.5
3.0
(2)
8
(5)
6
(8)
3
(11)
(0)
(19)
(9)
3.5
19
16
14
11
2
4.0
30
27
25
21
13
500
650
800
1,000
1,500
IRR (%)
2.0
4.1
2.2
(0.1)
(5.0)
-
Power rate (INR/kwh)
2.5
3.0
10.2
15.0
9.0
13.9
7.6
12.8
5.7
11.3
(1.1)
7.1
3.5
19.2
18.2
17.2
15.9
12.3
4.0
23.0
22.1
21.2
19.9
16.7
500
650
800
1,000
1,500
Talwandi Sabo Power Project: NPV of –INR42.4b; IRR of 5.4%
STLT subsidiary, Sterlite Energy, is setting up a 3x660MW thermal power plant at Punjab.
It will supply 100% of its power to Punjab State Electricity Board (PSEB) for 25 years at
a fixed RoE. The coal linkages for the project are in place. Production is expected to
start in FY14, with full ramp-up in FY16. The total project cost is estimated to be
INR118b. We expect the project to deliver an NPV of –INR42.4b and an IRR of 5.4%.
Free cash flow to firm (INR m)
FY13
a. EBITDA
b. Depreciation
c. NOPLAT=(a-b)*(1-Tax rate)
d. Capex
e. change in Working Capital
FCFF (c+b+d+e)
Present value cumulative
FY14
FY15
12,110
3,515
6,893
-15,600
-11,560
-16,752
61,837
FY16
16,814
5,905
8,749
-1,212
-5,156
8,286
85,752
FY17
17,955
6,023
9,570
-2,036
-1,157
12,399
87,399
FY18
17,955
6,144
9,473
-2,077
0
13,540
85,124
FY19
17,955
6,328
9,325
-3,178
0
12,475
81,444
FY20
...FY34
17,336
16,097
6,518
11,391
8,676
3,774
-3,273
-9,352
221
0
Terminal
12,141
5,813
value
78,403
75,343
30,323
Source: Company, MOSL
-37,250
-37,250
-20,000
-20,000
-42,413
NPV (INR Billion)
2.0
(40)
(42)
(45)
(48)
(51)
Power rate (INR/kwh)
3.0
4.0
(37)
(34)
(39)
(36)
(42)
(38)
(44)
(41)
(47)
(43)
5.0
(31)
(33)
(35)
(37)
(39)
7.0
(25)
(26)
(28)
(29)
(31)
3,000
3,500
4,000
4,500
5,000
IRR (%)
2.0
5.7
5.4
5.0
4.7
4.3
Power rate (INR/kwh)
3.0
4.0
6.1
6.5
5.8
6.3
5.5
6.0
5.2
5.7
4.9
5.4
5.0
6.9
6.7
6.4
6.2
6.0
7.0
7.6
7.5
7.3
7.1
7.0
3,000
3,500
4,000
4,500
5,000
7 January 2013
48

Sesa Sterlite
Jharsuguda Power Project: NPV of –INR14b; IRR of 7.9%
Sterlite Energy, a wholly-owned subsidiary of Sterlite Industries, is developing a
4x600MW independent power plant (IPP) at Jharsuguda, Odisha. Three units of 600MW
are already operational while the fourth is currently under trial run. The Hirakud
Reservoir is being used as a water source and coal is being derived from the IB Valley
Coalfield. It has linkage for 9.5mtpa of E/F grade coal. Though the Rampia Coal Block
allocated for the project (Sterlite Energy’s share: 112.22mtpa) will suffice for ~1,000MW,
it is yet to be operational. Long-term PPA has been signed with GRIDCO, giving it the
right to purchase up to 718MW. Sterlite Energy intends to supply power to Vedanta
Aluminium for its proposed 1.25mtpa aluminum smelter expansion project at the
adjacent site. It plans to sell the production from one 600MW unit on merchant basis.
The project capex is USD104.5b. We expect the project to deliver an NPV of –INR14b
and an IRR of 7.9%. However, starting of coal mine will lead to higher IRR and positive
NPV at current merchant rates of ~INR3.3/KWH.
Free cash flow to firm (INR m)
a. EBITDA
b. Depreciation
c. NOPLAT=(a-b)*(1-Tax rate)
d. Capex
e. change in Working Capital
FCFF (c+b+d+e)
NPV
FY13
FY14
9,181 12,242
3,574
6,082
4,497
4,940
-21,217 -11,232
-4,111 -3,485
-81,017 -17,257 -3,695
-13,855
FY12
FY15
13,862
6,203
6,142
-2,097
-1,162
9,087
FY16
17,102
6,327
8,641
-2,139
-2,323
10,507
FY17
18,722
6,454
9,839
-2,182
-1,162
12,950
FY18
18,722
6,583
9,736
-2,225
0
14,093
FY19
18,722
6,780
9,577
-3,405
0
12,953
FY20 …FY34
18,167 17,057
6,984 12,205
8,969
3,891
-3,507 -10,021
Terminal
200
0
value
12,646
6,076 35,389
Source: Company, MOSL
NPV (INR Billion)
2.0
(95)
(139)
(157)
(232)
(281)
Power rate (INR/kwh)
2.5
3.0
(40)
13
(83)
(29)
(100)
(46)
(172)
(115)
(219)
(160)
3.3
44
3
(14)
(82)
(126)
4.0
114
74
58
(7)
(49)
1,500
2,000
2,200
3,000
3,500
IRR (%)
2.0
-
-
-
-
-
Power rate (INR/kwh)
2.5
3.0
4
11
-
6
-
3
-
-
-
-
3.3
14
10
8
-
-
4.0
21
17
16
9
3
1,500
2,000
2,200
3,000
3,500
Western Cluster, Liberia: NPV of –INR26b; IRR of 5.8%
Sesa Goa acquired 51% stake in Western Cluster Limited, Liberia for USD90m in 2011.
In the first phase of operations, it intends ramp up production to 10mtpa. However,
we are factoring peak production of 6mtpa from FY19. The total estimated capex for
the project is INR82.5b. The company is guiding for first shipment from the mine in
FY14. It plans to invest INR4b-4.5b in the project in FY13. We expect the project to
deliver an NPV of –INR26b at iron ore price of USD83/ton, with IRR of 5.8%.
7 January 2013
49

Sesa Sterlite
Free cash flow to firm (INR m)
FY13
a. EBITDA
b. Depreciation
c. NOPLAT=(a-b)*(1-Tax rate)
d. Capex
e. change in Working Capital
FCFF (c+b+d+e)
Present Value (Cumulative)
FY14
FY15
706
3,300
-2,075
-25,575
-227
-24,576
-20,978
FY16
1,413
4,323
-2,328
-25,575
-227
-23,807
1,206
FY17
2,825
5,356
-2,025
-25,831
-453
-22,952
25,150
FY18
5,651
5,410
193
-1,339
-906
3,357
50,970
FY19
8,476
5,464
2,410
-1,352
-906
5,615
53,425
FY20
...FY39
8,476
8,476
5,519
6,667
2,366
1,447
-1,366
-1,650
0
0
Terminal
6,519
6,464
value
53,902
32,753
30,024
Source: Company, MOSL
-8,250
-26,236
NPV (INR b)
70
(865)
80
(612)
90
(358)
Iron ore prices USD/ton
100
110
120
(104)
150
403
130
657
140
911
150
1,165
160
1,418
IRR Matrix (%)
70
1
80
5
90
8
Iron ore prices USD/ton
100
110
120
10
13
15
130
17
140
19
150
21
160
23
Iron ore mining in Goa and Karnataka
NPV of INR94bSesa Goa’s standalone mining operations in Goa and Karnataka have been
impacted due to a ban on mining in the state. Production is unlikely to resume anytime
soon. We have assumed a volume of 12m tons for FY15 (9.8m tons in Goa and 2.2m tons in
Karnataka), much lower than the earlier annual run rate due to increased regulatory vigil.
We believe Sesa Goa’s mining operations will continue to yield positive NPV, owing to
low cost of operations. We expect the project to deliver an NPV of INR94b.
Free cash flow to firm (INR m)
FY13
a. EBITDA
b. Depreciation
c. NOPLAT=(a-b)*(1-Tax rate)
d. Capex
e. change in Working Capital
FCFF (c+b+d+e)
Present Value (Cumulative)
FY14
FY15
17,516
1,200
13,053
-900
-5,076
8,277
105,773
FY16
17,516
1,236
13,024
-900
0
13,360
111,038
FY17
17,516
1,273
12,994
-927
0
13,340
110,341
FY18
17,516
1,311
12,964
-955
0
13,320
109,583
FY19
17,516
1,351
12,932
-983
0
13,300
108,759
FY20
...FY45
17,516
17,516
1,391
2,913
12,900
11,683
-1,013
-2,121
0
0
13,278
12,474
107,862
11,198
Source: Company, MOSL
93,767
NPV (INR b)
70
71
80
88
90
106
Iron ore prices USD/ton
100
110
120
124
142
160
130
177
140
195
150
213
160
231
SESA-Sterlite: SOTP (INR b)
Net EBITDA
Sales
(A)
Stand-alone #
Hindustan Zinc
Balco
CMT+TSPL+interseg.
Zinc International
Cairn India
Total
7 January 2013
343
131
42
19
45
178
759
47
71
7
5
13
93
235
PAT
Net
Debt
(G)
672
-318
57
92
-72
-242
188
Net Valuations
Worth Basis
(B)
381
278
25
-559
111
300
536
5.0xEBITDA
5.0xEBITDA
5.0xEBITDA
5.0xEBITDA
3.5xEBITDA
363=Cairn TP
EV
C=(AxB)
236
354
34
24
44
CWIP
Equity Stake Attrib.
Disc(%) Value
(%) Equity
(D)
(F) C-G+D*(1-F)
51
0
51
51
-348
677
23
-19
116
691
100
64.9
51
100
100
59.0
SOTP
-348
439
12
-19
116
407
608
INR/
share
-117
148
4
-6
39
137
205
50
-10
70
3
-6
10
66
133
181
4
94
101
0
112
492

Sesa Sterlite
Financials and Valuation
Income Statement (Consolidated)
Y/E March
FY11
FY12
Net Sales
92,051
683,698
Change (%)
57.1
642.7
Total Expenses
39,988
433,987
EBITDA
52,063
249,712
Change (YoY %)
65.4
379.6
As % of Net Sales
56.6
36.5
Depn. & Amortization
964
44,751
EBIT
51,099
204,961
Net Interest
901
37,568
Other income
5,399
31,380
PBT
55,597
198,773
Current tax
13,442
46,213
Deffered tax
-70
-10,037
Tax
13,372
36,177
Rate (%)
24.1
18.2
PAT
42,225
162,596
Minority interests
0
59,803
Attrib. PAT (after MI & asso)
42,225
102,793
Change (YoY %)
60.6
143.4
E: MOSL Estimates; FY11 (SESA); FY12-14 are post merger
FY13E
722,037
5.6
460,694
261,344
4.7
36.2
49,707
211,636
42,931
42,686
211,391
37,716
-15,487
22,229
10.5
189,162
72,447
116,715
13.5
FY14E
731,760
1.3
464,984
266,776
2.1
36.5
59,348
207,428
54,272
41,505
194,661
24,220
2,731
26,951
13.8
167,710
68,533
99,177
-15.0
(INR Million)
FY15E
759,031
3.7
491,575
267,456
0.3
35.2
61,570
205,885
57,208
42,951
191,628
29,519
-1,543
27,976
14.6
163,652
66,484
97,168
-2.0
Balance Sheet
Y/E March
Share Capital
Reserves
Net Worth
Minority Interest
Total Loans
Deferred Tax Liability
Capital Employed
Gross Block
Less: Accum. Deprn.
Net Fixed Assets
Goodwill
Capital WIP
Investments
Associates
Liquid invest.(of above)
Curr. Assets
Inventory
Account Receivables
Cash and Bank Balance
Loans and advances
Curr. Liability & Prov.
Account Payables
Provisions & Others
Net Curr. Assets
Appl. of Funds
E: MOSL Estimates; FY10&11 (SESA);
7 January 2013
FY11
869
127,235
128,104
0
9,995
682
138,781
FY12
29,648
661,279
690,928
320,470
686,914
29,866
1,728,178
FY13E
29,648
748,728
778,377
376,979
729,914
36,338
1,921,607
(INR Million)
FY14E
29,648
820,306
849,954
430,965
777,914
42,691
2,101,524
722,175
237,477
484,698
562,957
463,763
266,423
3,292
252,328
474,286
65,786
41,177
246,687
120,637
150,603
72,674
77,929
323,683
2,101,524
FY15E
29,648
890,588
920,237
483,485
801,914
42,935
2,248,570
768,555
279,294
489,261
562,957
491,963
324,731
3,292
310,636
534,392
67,008
42,900
303,105
121,379
154,734
75,878
78,855
379,658
2,248,570
15,903
621,488
671,620
6,492
159,344
196,763
9,411
462,143
474,856
14,745
562,956
562,956
7,287
325,850
398,933
1
158,033
207,374
0
3,292
3,292
0
143,937
193,278
124,530
378,894
427,415
7,374
68,321
66,655
6,830
41,805
41,186
96,968
162,334
199,445
13,358
106,433
120,129
17,193
159,698
149,927
11,695
73,586
72,812
5,498
86,112
77,116
107,337
219,196
277,487
138,781
1,728,178
1,921,607
FY12-14 are post merger
51

Sesa Sterlite
Financials and Valuation
Ratios (Consolidated)
Y/E March
Basic (INR)
EPS
Cash EPS
BV/Share (ex-goodwill)
BV/Share (incl.-goodwill)
DPS
Payout (%)
Valuation (x)
P/E
Cash P/E
P/BV (incl.-goodwill)
EV/Sales
EV/EBITDA
Dividend Yield (%)
Return Ratios (%)
RoE
RoCE (pre-tax)
RoIC (pre-tax)
Working Capital Ratios
Fixed Asset Turnover (x)
Receivable (Days)
Inventory (Days)
Leverage Ratio (x)
Current Ratio
Interest Cover Ratio
FY11
48.6
49.7
130.4
147.4
3.5
7.2
FY12
34.7
49.8
43.2
233.0
3.5
10.1
FY13E
39.4
56.1
72.7
262.5
3.5
8.9
FY14E
33.5
53.5
96.8
286.7
3.5
10.5
FY15E
32.8
53.5
120.5
310.4
3.5
10.7
5.7
4.0
0.9
1.5
5.8
3.1
5.1
3.5
0.8
1.4
5.7
3.1
5.9
3.7
0.7
1.4
5.4
3.1
6.1
3.7
0.6
1.3
5.1
3.1
40.7
40.7
159.3
17.0
25.3
36.7
15.9
24.1
36.7
12.2
13.0
18.8
11.0
11.9
18.3
5.8
27
29
1.1
22
36
1.1
21
34
1.0
21
33
1.0
21
32
7.2
56.7
FY11
52,063
1,270
-1,570
-13,372
38,391
-9,637
0
5,399
-2,056
-6,294
9,376
-9,611
-3,559
-901
-4,696
27,401
69,566
96,968
2.4
5.5
FY12
249,712
0
-46,492
-36,177
167,043
-82,645
-13,002
21,966
-630,256
2.9
4.9
FY13E
261,344
10,588
-21,181
-37,716
191,859
-123,215
-49,341
29,880
-142,676
3.1
3.8
FY14E
266,776
32,568
1,046
-24,220
211,035
-115,385
-59,049
29,054
-145,380
3.5
3.6
FY15E
267,456
33,790
443
-29,519
204,589
-74,580
-58,308
30,065
-102,822
Cash Flow Statement
Y/E March
EBITDA
Non cash expenditure (income)
(Inc)/Dec in Wkg. Cap.
Tax paid
CF from Op. Activity
(Inc)/Dec in FA + CWIP
(Pur)/Sale of Investments
Interest & Dividend Income
Loans and advances
CF from Inv. Activity
Equity raised/(repaid)
Debt raised/(repaid)
Dividend (incl. tax)
Interest paid
Other financing activities
CF from Fin. Activity
(Inc)/Dec in Cash
Add: Opening Balance
Closing Balance
E: MOSL Estimates
7 January 2013
(INR Million)
559,633
-12,141
-37,568
18,655
528,579
65,367
96,968
162,334
43,000
-12,141
-42,931
-12,072
37,111
162,334
199,445
48,000
-12,141
-54,272
-18,413
47,241
199,445
246,687
24,000
-12,141
-57,208
-45,348
56,419
246,687
303,105
52

7 January 2013
Update | Sector: Metals
Tata Steel
BSE SENSEX
S&P CNX
19,581
5,951
CMP: INR438
TP: INR230
Sell
Implied valuation of CWIP at 33% premium
Further downside possible; maintain Sell
Bloomberg
Equity Shares (m)
52-Week Range (INR)
1,6,12 Rel. Perf. (%)
M.Cap. (INR b)
M.Cap. (USD b)
TATA IN
971.4
501/332
12/-14/4
425.5
7.7
Valuation summary (INR b)
Y/E March
2013
Sales
1,360
EBITDA
121
Adj. PAT
7.7
Adj. EPS (INR) 7.9
EPS Gr(%)
-57.4
BV/Sh. (INR) 255.1
RoE (%)
3.0
RoCE (%)
6.9
Payout (%) 211.4
Valuation
P/E (x)
55.3
P/BV
1.7
EV/EBITDA (x) 8.5
Div. Yield (%) 2.7
2014E 2015E
1,372 1,393
159
164
46.9 48.4
48.3 49.8
509.6
3.2
288.9 324.2
17.8 16.3
10.0 10.0
28.1 27.3
9.1
1.5
6.7
2.7
8.8
1.4
6.6
2.7
For Tata Steel (TATA), CWIP has not been as much of a problem as the burden of debt
on account of Corus' acquisition and the dip in the latter's margins post the financial
crisis of 2008. High debt and Corus' volatile margins have introduced volatility into
earnings and market capitalization, despite equity infusion of USD4b.
TATA has commissioned two new blast furnaces at Jamshedpur in 2008 and 2012. The
Odisha project has witnessed delays and cost escalation due to protests from local
inhabitants. Phase-1 of the 3mtpa capacity is now expected to cost INR250b, which
implies specific capex of USD1,515/ton. This is ~50% higher than the benchmark
USD1,000/ton.
The Odisha project has been the primary reason behind the rise in CWIP. Capex at its
Canadian facilities is also contributing to the CWIP.
The implied valuation of CWIP is at 33% premium. Our two alternative valuation
approaches suggest equity value of INR182/share and INR412/share in the base case,
and INR348/share and INR514/share in the optimistic case. We maintain Sell.
Shareholding pattern (%)
As on
Sep-12
Promoter
31.4
Dom. Inst 27.3
Foreign
16.6
Others
24.7
Jun-12 Sep-11
31.4
30.7
28.7
27.7
15.8
17.2
24.1
24.4
Tata Steel India has recently undergone 2.9mtpa brownfield expansion at
Jamshedpur. It is planning 6mtpa greenfield expansion in Odisha in two phases of
3mtpa each. It also has 80% stake in the DSO (Direct shipping ore) project in Canada,
with the balance 20% stake owned by New Millennium Iron Corporation (NML).
(Tata Steel has 27.4% stake in NML). Cumulatively, the capex of all the three projects
is expected to be INR441b. In an optimistic scenario of iron ore prices at USD106/
ton, all the three projects combined will have an NPV of –INR80b, with an IRR of
11.9%. In our base case scenario of iron ore prices at USD83/ton, the combined
NPV will decline further to –INR144b, with an IRR of 9.1%. Lower iron ore prices
will result in reduced iron ore integration benefits as well as lower realizations
for the DSO project.
Summary: Key Projects (INR m)
Project
CapEx
Total
O/S
as on
Mar-14
NPV
IRR Remarks
(%)
Stock performance (1 year)
Jamshedpur (JSR)
Odisha (ODS)
New Millenium
Total
160,000
0 -25,338
250,000 96,900 -104,795
30,800
0 -13,421
440,800 96,900 -143,554
12.1 80% C.U. in FY14; 100% ramp up in FY15
7.2 54% C.U in FY16; full ramp up by FY19
8.7 2m ton in FY14; 4.2mtpa FY15 onwards
9.1
Source: Company, MOSL
53

Tata Steel
CWIP not a problem...
...but rising debt level is a concern
Source: Company, MOSL
The CWIP/EV ratio remains comfortable at ~20%. Though CWIP/MCap has deteriorated
sharply in recent years to ~47%, it is lower than the 2008 financial crisis.
CWIP/EV at comfortable levels of 20%
TATA SOTP - (INR m, FY15E)
India
EBITDA per ton (USD)
212
Sales (m tons)
10
EBITDA-India
115,804
Target EBITDA
multiple
5.0
EV (India) - (a)
579,018.9
INR/share
596.1
TSE and other subs.
EBITDA per ton (USD)
51.5
Sales (m tons)
17.5
EBITDA
49,077.8
Target EBITDA
multiple
5.0
EV (TSE) - (b)
245,388.9
INR/share
252.6
Target EV (c=a+b)
824,408
Net Debt (d)
646,379
INR/share
665.4
Investments (e)
90,511
INR/share
93.2
Equity value
(f=c-d+e*50%)
223,285
Target Price
230
7 January 2013
Source: Company, MOSL
Valuation exercise indicates more downside; Sell
Applying our two alternative approaches to valuation, we find that Tata Steel (TATA)
has downside in 3 of the 4 situations. We maintain our
Sell
recommendation.
1. SOTP:
We have valued operational assets at an EV of 5x one-year forward EBITDA.
We have adjusted the CWIP against the NPV of the projects to capture their intrinsic
value. TATA’s valuations are highly sensitive to steel/iron ore prices. In the base
case scenario, where we assume iron ore prices of USD83/ton, we arrive at a value
of INR182/share. In the optimistic scenario, where we assume iron ore prices of
USD106/ton FOB, we arrive at a value of INR348/share.
2. FY20 valuations discounted for five years:
We arrive at FY20 valuations to factor in
completion of all ongoing projects and the possible delays. We have discounted
these valuations backwards for five years by TATA’s cost of equity of 18.3%. In the
base case scenario, where we assume iron ore prices of USD83/ton, we arrive at a
value of INR412/share. In the optimistic scenario, where we assume iron ore prices
of USD106/ton, we arrive at a value of INR514/share.
54

Tata Steel
Target price (TP): Base case (Iron ore @ USD83/t fob)
SOTP Valuation
FY14 EBITDA
125,685
EV/EBITDA
5
Enterprise Value(1x2) 628,427
add: Jamshedpur
(JSR-3mtpa)
126,974
add: CWIP
200,397
add: NPV
-143,554
less: Net Debt
635,355
Equity value
176,890
Equity value per share
182
Target price (TP): Optimistic scenario (Iron ore @ USD106/t fob)
SOTP Valuation
FY14 EBITDA
139,879
EV/EBITDA
5
Enterprise Value(1x2) 699,394
add: Jamshedpur
(JSR-3mtpa)
153,586
add: CWIP
200,397
add: NPV
-79,853
less: Net Debt
635,355
Equity value
338,169
Equity value per share
348
Source: Company, MOSL
Target price calculations (INR m)
S.N. Project
1
2
3
Jamshedpur (JSR-3mtpa)
Odisha (ODS)
New Millenium (NML)
Total equity in projects
add:current Operations@5xEV/EBITDA
Less: Net Debt (incl. projects)
Net Equity value for company
No. of share (m)
TP (INR/share)
TP (discounting back from FY20@Ke)
Current market Cap
Upside (%)
Equity value based on 5xEV/EBTIDA (assuming project cost is w/off)
FY14
FY15
FY16
FY17
FY18
FY19
FY20
101,579
126,974
137,132
142,211
142,211
142,211
142,211
79,897
122,508
133,161
149,141
149,141
18,161
18,161
18,161
18,161
18,161
18,161
101,579
145,134
235,189
282,879
293,532
309,512
309,512
628,427
628,427
628,427
628,427
628,427
628,427
628,427
635,355
607,826
516,474
397,585
272,199
142,730
8,211
94,651
165,735
347,142
513,722
649,761
795,209
929,728
971
971
971
971
971
971
171
357
529
669
819
957
412
488
577
683
809
957
425,478
425,478
425,478
425,478
425,478
425,478
-6
11
32
56
85
119
Source: Company, MOSL
7 January 2013
55

Tata Steel
Jamshedpur 2.9mtpa expansion: NPV of –INR25b; IRR of 12.1%
TATA has commissioned most of the facilities in its 2.9mtpa brownfield expansion at
Jamshedpur. This has resulted in crude steel capacity of Indian operations expanding
from 6.8mtpa to 9.7mtpa. Incremental volume of 1mtpa is expected from the project
in FY13. The project included setting up of a 6mtpa pellet plant, two coke oven
batteries of 0.7mtpa each, 2.9mtpa blast furnace, LD shop, thin slab caster, 2.4mtpa
rolling mill for HRC, expansion of captive mines at Noamundi and Joda, and expansion
of ancillary support systems. The total project capex was INR160b. According to our
calculations, the project has an NPV of –ve INR22m, with an IRR of 14.7%, in the
optimistic scenario. In the base case scenario, the NPV reduces to –INR25.3b, with an
IRR of 12.1%.
Free Cash Flow to firm (INR m)
a. EBITDA
b. Depreciation
c. NOPLAT=(a-b)*(1-Tax rate)
d. Capex
e. change in Working Capital
FCFF (c+b+d+e)
Present Value (Cumulative)
FY14
20,316
6,400
11,133
0
-9,280
8,253
130,860
FY15
25,395
6,464
15,145
-1,600
-2,320
17,689
142,247
FY16
27,426
6,529
16,718
-1,616
-928
20,703
144,771
FY17
28,442
6,594
17,479
-1,632
-464
21,976
144,638
FY18
28,442
6,660
17,426
-1,648
0
22,437
143,213
FY19
28,442
6,726
17,373
-1,665
0
22,434
141,125
FY20
...FY39
28,442
28,442
6,794
8,208
17,319
14,164
-1,682
-2,032
0
0
Terminal
22,431
20,340
Value
138,743
17,872 110,811
Source: Company, MOSL
-160,000
-25,338
Project delivers positive NPV (USD m) if Iron ore prices remains higher than USD106/t
90
60
70
80
90
100
110
120
110
Coking coal prices USD/ton
130
150
170
190
210
230
250
270
290
(1,018) (1,022) (1,026) (1,030) (1,034) (1,038) (1,042) (1,046) (1,050) (1,054) (1,057)
(793)
(797)
(801)
(805)
(809)
(813)
(817)
(821)
(825)
(829)
(833)
(569)
(573)
(577)
(581)
(584)
(588)
(592)
(596)
(600)
(604)
(608)
(344)
(348)
(352)
(356)
(360)
(364)
(368)
(372)
(376)
(380)
(384)
(119)
(123)
(127)
(131)
(135)
(139)
(143)
(147)
(151)
(155)
(159)
105
101
97
93
89
85
81
78
74
70
66
330
326
322
318
314
310
306
302
298
294
290
Source: MOSL
IRR (%)
90
60
70
80
90
100
110
120
9.3
10.5
11.8
13.0
14.1
15.3
16.4
110
9.3
10.5
11.7
12.9
14.1
15.3
16.4
Coking coal prices USD/ton
130
150
170
190
9.3
10.5
11.7
12.9
14.1
15.2
16.4
9.2
10.5
11.7
12.9
14.1
15.2
16.3
9.2
10.5
11.7
12.9
14.0
15.2
16.3
9.2
10.5
11.7
12.9
14.0
15.2
16.3
210
9.2
10.4
11.7
12.8
14.0
15.2
16.3
230
9.2
10.4
11.6
12.8
14.0
15.1
16.3
250
9.2
10.4
11.6
12.8
14.0
15.1
16.2
270
290
9.1
9.1
10.4
10.4
11.6
11.6
12.8
12.8
14.0
13.9
15.1
15.1
16.2
16.2
Source: MOSL
Key assumptions
USD/INR =
Iron ore prices=
Coking coal=
HRC =
55.0
83
170
479
Cost of equity =
Interest rate =
Debt/project cost =
Tax rate =
18%
10%
40%
20%
Source: MOSL
56
7 January 2013

Tata Steel
Our sensitivity analysis indicates that the Jamshedpur expansion is likely to result in
positive NPV at iron ore above USD106/ton owing to lower cost of brownfield expansion
and relatively high level of integration. However, for iron ore prices below USD106/
ton, NPV turns negative. NPV sensitivity to coking coal prices is low, as incremental
capacity will have to depend upon external sourcing of coking coal. Any change in
coking coal prices translates into similar change in steel realization.
Odisha 6mtpa Greenfield expansion: NPV of –INR105b; IRR of 7.2%
TATA plans to add 6mtpa steel capacity at Kalinganagar, Odisha, comprising mainly of
flat products. It plans to complete the expansion in two phases of 3mtpa each. Ordering
of equipment for the first phase has been completed while civil and construction
work is currently under progress. The project will comprise major facilities like sinter
plant, pellet plant, coke plant, blast furnace, steel melt shop, hot strip mill, cold
rolling mill, and raw material handling units.
The first phase is scheduled for commissioning by 2014 while the second phase is on
schedule to commission in 18-24 months after the commissioning of the first phase.
Raw material security is yet to come through for the project, as its application for iron
ore mine is still pending. In the interim, it will be relying on existing mines. The total
project cost, which was estimated at INR345b, is likely to be revised upwards, given
the significant INR depreciation, general inflation and project delays.
We are building in only the first phase of the expansion in our calculations. We have
assumed INR250b as the project cost for the first phase of 3mtpa. The project NPV
remains negative due to higher cost, though margins are expected to be in the same
range as the Jamshedpur expansion. The NPV turns positive at iron ore prices of over
USD185/ton. According to our calculations, the project has an NPV of –INR81b, with an
IRR of 9.1%, in the optimistic scenario. In the base case scenario, the NPV reduces to
–INR105b, with an IRR of 7.2%.
Free Cash Flow to firm (INR m)
FY14
a. EBITDA
b. Depreciation
c. NOPLAT=(a-b)*(1-Tax rate)
d. Capex
e. change in Working Capital
FCFF (c+b+d+e)
Present Value (Cumulative)
FY15
FY16
15,979
10,000
4,783
0
-6,960
7,823
129,477
FY17
24,502
10,100
11,521
-2,500
-3,712
15,409
141,086
FY18
26,632
10,201
13,145
-2,525
-928
19,893
145,724
FY19
29,828
10,303
15,620
-2,550
-1,392
21,981
146,537
FY20
...FY39
29,828
29,828
10,406
12,572
15,538
12,080
-2,576
-3,112
0
0
Terminal
23,368
21,539
value
145,377
18,926 117,322
Source: Company, MOSL
-250,000
-104,795
Project delivers negative NPV (USD m) mostly due to high cost of project
90
60
70
80
90
100
110
120
(2,608)
(2,397)
(2,187)
(1,976)
(1,765)
(1,555)
(1,344)
110
(2,612)
(2,401)
(2,190)
(1,980)
(1,769)
(1,558)
(1,348)
Coking coal prices USD/ton
130
150
170
190
(2,616)
(2,405)
(2,194)
(1,984)
(1,773)
(1,562)
(1,352)
(2,619)
(2,409)
(2,198)
(1,987)
(1,777)
(1,566)
(1,355)
(2,623)
(2,413)
(2,202)
(1,991)
(1,781)
(1,570)
(1,359)
(2,627)
(2,416)
(2,206)
(1,995)
(1,784)
(1,574)
(1,363)
210
(2,631)
(2,420)
(2,209)
(1,999)
(1,788)
(1,577)
(1,367)
230
(2,635)
(2,424)
(2,213)
(2,003)
(1,792)
(1,581)
(1,371)
250
(2,638)
(2,428)
(2,217)
(2,006)
(1,796)
(1,585)
(1,374)
270
290
(2,642) (2,646)
(2,432) (2,435)
(2,221) (2,225)
(2,010) (2,014)
(1,800) (1,803)
(1,589) (1,593)
(1,378) (1,382)
Source: MOSL
57
7 January 2013

Tata Steel
IRR (%)
90
60
70
80
90
100
110
120
5.2
6.1
7.0
7.9
8.7
9.5
10.3
110
5.2
6.1
7.0
7.8
8.7
9.5
10.2
Coking coal prices USD/ton
130
150
170
190
5.2
6.1
7.0
7.8
8.7
9.5
10.2
5.2
6.1
7.0
7.8
8.6
9.4
10.2
5.2
6.1
7.0
7.8
8.6
9.4
10.2
5.1
6.1
7.0
7.8
8.6
9.4
10.2
210
5.1
6.1
6.9
7.8
8.6
9.4
10.2
230
5.1
6.1
6.9
7.8
8.6
9.4
10.2
250
5.1
6.0
6.9
7.8
8.6
9.4
10.2
270
290
5.1
5.1
6.0
6.0
6.9
6.9
7.8
7.8
8.6
8.6
9.4
9.4
10.2
10.2
Source: MOSL
Our sensitivity analysis indicates that the Odisha expansion (phase-1) is likely to
result in negative NPV owing to high project cost, despite full iron ore integration.
However, for iron ore prices above USD185/ton, the NPV turns positive. NPV sensitivity
to coking coal prices is low, as the entire capacity will have to depend upon external
sourcing of coking coal. Any change in coking coal prices also translates into similar
change in steel realization.
DSO Project, Canada
In 2008, TATA entered into an agreement with New Millennium Iron Corporation (NML),
a Canadian listed mining company, to develop iron ore projects in northern Quebec
and Newfoundland & Labrador. NML planned to develop the Direct Shipping Ore (DSO)
Project, having estimated proven and probable reserves of 64.1m tons, and the
Taconite Projects, namely Labmag and Kemag, with a combined resource size of 5.65b
tons. TATA later acquired 27.4% stake in NML through a 100% subsidiary. It also acquired
80% equity in Tata Steel Minerals Canada (TSMC), a JV between TATA and NML formed
for the development of the DSO Project.
The total project cost is expected to be INR31b. Iron ore shipments from the project
have already begun and are likely to ramp up gradually to 6m tons in FY16. The project
has positive NPV at iron ore prices above USD100/ton. In the optimistic scenario,
where we assume iron ore prices of USD106/ton, the project has a positive NPV of
INR1.2b, with an IRR of 19.1%. In the base case, where we assume iron ore prices of
USD83/ton, NPV works out to –INR13.4b, with an IRR of 8.7%.
Free Cash Flow to firm (INR m)
FY14
a. EBITDA
b. Depreciation
c. NOPLAT=(a-b)*(1-Tax rate)
d. Capex
e. change in Working Capital
FCFF (c+b+d+e)
Present Value (Cumulative)
FY15
4,249
1,232
2,112
-308
0
1,066
14,916
FY16
4,249
1,244
2,103
-308
0
3,040
16,586
FY17
4,249
1,257
2,095
-311
0
3,040
16,590
FY18
4,249
1,269
2,086
-314
0
3,041
16,594
FY19
4,249
1,282
2,077
-317
0
3,042
16,597
FY20
...FY39
4,249
4,249
1,295
1,564
2,068
1,879
-321
-387
0
Terminal
3,042
3,056
Value
16,601
16,651
16,649
Source: Company, MOSL
-1,970
-30,800
-13,421
Project delivers positive NPV (USD m) if Iron ore prices remains higher than USD90/t
60
(573)
7 January 2013
70
(443)
80
(313)
Iron ore prices USD/ton
90
100
110
120
(183)
(53)
77
207
130
337
140
467
150
160
597
726
Source: MOSL
58

Tata Steel
Financials and Valuation
Income Statement (Consolidated)
Y/E March
Net Sales
Change (%)
EBITDA
% of Net Sales
Depn. & Amortization
EBIT
Finace cost
Other income
PBT before EO
EO income
PBT after EO
Tax
Rate (%)
Reported PAT
Minority interest P/L
Share of asso. PAT
PAT (After MI & asso.)
Div. on Pref. /Hybrid Sec.
Adjusted PAT
Change (%)
2011
1,187,531
16.0
159,956
13.5
44,148
115,808
27,700
2,809
90,917
30,103
121,020
32,459
26.8
88,561
-603
664
89,827
59,724
-n/a-
2012
1,328,997
11.9
124,168
9.3
45,167
79,001
42,501
15,730
52,231
33,619
85,850
36,365
42.4
49,485
-1,731
2,681
53,898
2,225
18,054
-69.8
2013E
1,360,256
2.4
120,671
8.9
55,264
65,407
41,948
9,567
33,026
-1,874
31,152
24,701
79.3
6,451
-915
1,071
8,437
2,616
7,695
-57.4
2014E
1,371,955
0.9
158,989
11.6
57,619
101,370
46,209
9,448
64,610
64,610
16,110
24.9
48,500
-109
913
49,522
2,616
46,906
509.6
(INR Million)
2015E
1,393,081
1.5
163,591
11.7
58,341
105,251
47,921
9,563
66,893
66,893
16,935
25.3
49,958
-114
950
51,023
2,616
48,406
3.2
Balance Sheet (Consolidated)
Y/E March
Share Capital
Reserves
Net Worth
Minority Interest
Total Loans
Deferred Tax Liability
Capital Employed
Gross Block
Less: Accum. Deprn.
Net Fixed Assets
Capital WIP
Investments
Goodwill on consolidation
Other assets
Curr. Assets
Inventory
Account Receivables
Cash & Bank Balance
Others
Curr. Liability & Prov.
Account Payables
Provisions & Others
Net Current Assets
Appl. of Funds
E: MOSL Estimates
2011
9,587
346,226
355,814
8,889
635,201
20,126
1,020,030
981,023
615,338
365,685
135,508
46,881
152,982
87,181
564,890
240,552
148,119
140,183
36,035
333,097
171,162
161,935
231,793
1,020,030
2012
9,714
420,672
430,386
10,912
644,028
24,424
1,109,749
1,133,047
712,043
421,003
200,397
26,229
173,546
84,833
565,779
255,980
148,785
122,000
39,015
362,038
184,093
177,945
203,741
1,109,749
2013E
9,714
411,624
421,339
9,997
644,028
27,815
1,103,178
1,253,047
767,307
485,740
200,397
26,229
173,546
84,833
496,715
260,871
156,523
40,307
39,015
364,282
186,336
177,945
132,433
1,103,178
(INR Million)
2014E
9,714
444,468
454,183
9,888
646,028
27,815
1,137,913
1,373,047
824,926
548,121
200,397
26,229
173,546
84,833
470,671
263,115
157,869
10,673
39,015
365,884
187,939
177,945
104,787
1,137,913
2015E
9,714
478,807
488,521
9,774
649,028
27,815
1,175,137
1,473,047
883,266
589,780
200,397
26,229
173,546
84,833
469,130
267,166
160,300
2,649
39,015
368,778
190,833
177,945
100,352
1,175,137
7 January 2013
59

Tata Steel
Financials and Valuation
Ratios (Consolidated)
Y/E March
Basic (INR)
EPS
Cash EPS
BV/Share
DPS
Payout (%)
Valuation (x)
P/E
Cash P/E
P/BV
EV/Sales
EV/EBITDA
Dividend Yield (%)
Return Ratios (%)
RoE
RoCE (pre-tax)
RoIC (pre-tax)
Working Capital Ratios
Debtor (Days)
Inventory (Days)
Leverage Ratio (x)
Debt/Equity
2011
62.3
138.3
211.4
12.0
21.9
2012
18.6
97.4
264.4
12.0
74.6
2013E
7.9
63.5
255.1
12.0
177.2
2014E
48.3
109.2
288.9
12.0
29.1
2015E
49.8
111.5
324.2
12.0
28.2
23.6
4.5
1.7
0.7
7.6
2.7
55.3
6.9
1.7
0.8
8.5
2.7
9.1
4.0
1.5
0.8
6.7
2.7
8.8
3.9
1.4
0.8
6.6
2.7
40.5
13.2
19.5
7.8
9.1
12.3
3.0
6.9
9.2
17.8
10.0
12.9
16.3
10.0
12.6
45.5
73.9
40.9
70.3
42.0
70.0
42.0
70.0
42.0
70.0
2.4
2.0
2.4
2.3
2.1
Cash Flow Statement (Consolidated)
Y/E March
EBITDA
Non cash exp. (income)
(Inc)/Dec in Wkg. Cap.
Tax Paid
Other operating activities
CF from Op. Activity
(Inc)/Dec in FA + CWIP
(Pur)/Sale of Investments
Acquisition in subsidiaries
Int. & Divident Income
Other investing activities
CF from Inv. Activity
Equity raised/(repaid)
Debt raised/(repaid)
Dividend (incl. tax)
Interest & equiv. paid
CF from Fin. Activity
(Inc)/Dec in Cash
Add: opening Balance
Closing Balance
E: MOSL Estimates
7 January 2013
2011
159,956
8,773
-71,749
-32,351
64,629
-101,636
22,294
-647
3,518
39,218
-37,254
45,568
37,874
-7,146
-31,366
44,930
72,305
67,878
140,183
2012
124,168
13,603
11,590
-36,524
112,838
-119,586
4,164
6,194
61,251
-47,978
6,045
-39,803
-11,639
-37,646
-83,043
-18,184
140,183
122,000
2013E
120,671
-2,693
-10,385
-21,310
-82
86,201
-120,000
-1,874
9,567
-112,307
(INR Million)
2014E
158,989
-2,130
-1,987
-16,110
3
138,766
-120,000
2015E
163,591
-2,130
-3,589
-16,935
35
140,973
-100,000
9,448
-110,552
9,563
-90,437
-13,639
-41,948
-55,587
-81,693
122,000
40,307
2,000
-13,639
-46,209
-57,847
-29,634
40,307
10,673
3,000
-13,639
-47,921
-58,559
-8,024
10,673
2,649
60

Tata Steel
N O T E S
7 January 2013
61

Disclosures
This report is for personal information of the authorized recipient and does not construe to be any investment, legal or taxation advice to you. This research report does not constitute an offer, invitation or inducement
to invest in securities or other investments and Motilal Oswal Securities Limited (hereinafter referred as MOSt) is not soliciting any action based upon it. This report is not for public distribution and has been
furnished to you solely for your information and should not be reproduced or redistributed to any other person in any form.
Unauthorized disclosure, use, dissemination or copying (either whole or partial) of this information, is prohibited. The person accessing this information specifically agrees to exempt MOSt or any of its affiliates
or employees from, any and all responsibility/liability arising from such misuse and agrees not to hold MOSt or any of its affiliates or employees responsible for any such misuse and further agrees to hold MOSt
or any of its affiliates or employees free and harmless from all losses, costs, damages, expenses that may be suffered by the person accessing this information due to any errors and delays.
The information contained herein is based on publicly available data or other sources believed to be reliable. While we would endeavour to update the information herein on reasonable basis, MOSt and/or its
affiliates are under no obligation to update the information. Also there may be regulatory, compliance, or other reasons that may prevent MOSt and/or its affiliates from doing so. MOSt or any of its affiliates or
employees shall not be in any way responsible and liable for any loss or damage that may arise to any person from any inadvertent error in the information contained in this report . MOSt or any of its affiliates
or employees do not provide, at any time, any express or implied warranty of any kind, regarding any matter pertaining to this report, including without limitation the implied warranties of merchantability, fitness
for a particular purpose, and non-infringement. The recipients of this report should rely on their own investigations.
This report is intended for distribution to institutional investors. Recipients who are not institutional investors should seek advice of their independent financial advisor prior to taking any investment decision
based on this report or for any necessary explanation of its contents.
MOSt and/or its affiliates and/or employees may have interests/positions, financial or otherwise in the securities mentioned in this report. To enhance transparency, MOSt has incorporated a Disclosure of Interest
Statement in this document. This should, however, not be treated as endorsement of the views expressed in the report.
Disclosure of Interest Statement
1. Analyst ownership of the stock
2. Group/Directors ownership of the stock
3. Broking relationship with company covered
4. Investment Banking relationship with company covered
Companies where there is interest
Sesa Goa
None
None
None
Analyst Certification
The views expressed in this research report accurately reflect the personal views of the analyst(s) about the subject securities or issues, and no part of the compensation of the research analyst(s) was, is, or
will be directly or indirectly related to the specific recommendations and views expressed by research analyst(s) in this report. The research analysts, strategists, or research associates principally responsible
for preparation of MOSt research receive compensation based upon various factors, including quality of research, investor client feedback, stock picking, competitive factors and firm revenues.
Regional Disclosures (outside India)
This report is not directed or intended for distribution to or use by any person or entity resident in a state, country or any jurisdiction, where such distribution, publication, availability or use would be contrary to
law, regulation or which would subject MOSt & its group companies to registration or licensing requirements within such jurisdictions.
For U.K.
This report is intended for distribution only to persons having professional experience in matters relating to investments as described in Article 19 of the Financial Services and Markets Act 2000 (Financial
Promotion) Order 2005 (referred to as "investment professionals"). This document must not be acted on or relied on by persons who are not investment professionals. Any investment or investment activity to
which this document relates is only available to investment professionals and will be engaged in only with such persons.
For U.S.
Motilal Oswal Securities Limited (MOSL) is not a registered broker - dealer under the U.S. Securities Exchange Act of 1934, as amended (the"1934 act") and under applicable state laws in the United States.
In addition MOSL is not a registered investment adviser under the U.S. Investment Advisers Act of 1940, as amended (the "Advisers Act" and together with the 1934 Act, the "Acts), and under applicable state
laws in the United States. Accordingly, in the absence of specific exemption under the Acts, any brokerage and investment services provided by MOSL, including the products and services described herein
are not available to or intended for U.S. persons.
This report is intended for distribution only to "Major Institutional Investors" as defined by Rule 15a-6(b)(4) of the Exchange Act and interpretations thereof by SEC (henceforth referred to as "major institutional
investors"). This document must not be acted on or relied on by persons who are not major institutional investors. Any investment or investment activity to which this document relates is only available to major
institutional investors and will be engaged in only with major institutional investors. In reliance on the exemption from registration provided by Rule 15a-6 of the U.S. Securities Exchange Act of 1934, as amended
(the "Exchange Act") and interpretations thereof by the U.S. Securities and Exchange Commission ("SEC") in order to conduct business with Institutional Investors based in the U.S., MOSL has entered into
a chaperoning agreement with a U.S. registered broker-dealer, Marco Polo Securities Inc. ("Marco Polo"). Any business interaction pursuant to this report will have to be executed within the provisions of this
chaperoning agreement.
This website and its respective contents does not constitute an offer or invitation to purchase or subscribe for any securities or solicitation of any investments or investment services and/or shall not be considered
as an advertisement tool. "U.S. Persons" are generally defined as a natural person, residing in the United States or any entity organized or incorporated under the laws of the United States. US Citizens living
abroad may also be deemed "U.S. Persons " under certain rules.
The Research Analysts contributing to the report may not be registered /qualified as research analyst with FINRA. Such research analyst may not be associated persons of the U.S. registered broker-dealer, Marco
Polo, and therefore, may not be subject to NASD rule 2711 and NYSE Rule 472 restrictions on communication with a subject company, public appearances and trading securities held by a research analyst account.
For Singapore
Motilal Oswal Capital Markets Singapore Pte Limited is acting as an exempt financial advisor under section 23(1)(f) of the Financial Advisers Act(FAA) read with regulation 17(1)(d) of the Financial Advisors
Regulations and is a subsidiary of Motilal Oswal Securities Limited in India. This research is distributed in Singapore by Motilal Oswal Capital Markets Singapore Pte Limited and it is only directed in Singapore
to accredited investors, as defined in the Financial Advisers Regulations and the Securities and Futures Act (Chapter 289), as amended from time to time.
In respect of any matter arising from or in connection with the research you could contact the following representatives of Motilal Oswal Capital Markets Singapore Pte Limited:
Nihar Oza
Kadambari Balachandran
Email: niharoza.sg@motilaloswal.com
Email : kadambari.balachandran@motilaloswal.com
Contact: (+65) 68189232
Contact: (+65) 68189233 / 65249115
Office address: 21 (Suite 31), 16 Collyer Quay, Singapore 049318
Motilal Oswal Securities Ltd
Motilal Oswal Tower, Level 9, Sayani Road, Prabhadevi, Mumbai 400 025
Phone: +91 22 3982 5500 E-mail: reports@motilaloswal.com