1 Equity Analysis and Valuation
1 Equity Analysis and Valuation
1 Equity Analysis and Valuation
2008
Question 1 Nov 2008 RTP
The total market value of the equity share of Raheja Company is Rs.90,00,000 and the total value of
the debt is Rs.60,00,000. The treasurer estimated that the beta of the stock is currently 1.9 and that
the expected risk premium on the market is 12 per cent. The treasury bill rate is 9 per cent.
Required :
(1) What is the beta of the Company’s existing portfolio of assets?
(2) Estimate the Company’s Cost of capital and the discount rate for an expansion of the company’s
present business.
Solution :
1) Beta of Company’s existing Portfolio
β Assets = β Liabilities
1|Page
Equity Analysis & Valuation SFM COMPILER
Solution :
Retained Earning = Rs.3 = 37.5%
3
Earnings = Rs.8
37.5%
Dividend = Rs.5 (8 – 3)
P.E. ratio = 7.5
MPs = EPs P.E. = 8 7.5 = Rs.60/share
D1
IV = Re ‐ g
A) Re = ?, if g = 12%
5
60 = Re = 20.33%
Re 0.12
B) If g = 13%
5
IV = = Rs.68.21/share
0.2033 0.13
C) If Re = 18%, g = 15%
5
IV = = Rs166.67/share
0.18 0.15
2|Page
SFM COMPILER Equity Analysis & Valuation
Solution :
(i) Dividend are expected to grow at 12% per annum forever
D1
IV =
Re-g
1.2
20 =
Re 0.12
Re = 18%
(ii) If the dividend are expected to grow at the rate of 20% for 5 years and 10% thereafter
WE will have to use the concept of Trial and Error to get the answer i.e. IV = 20
Let say Re = 20%
IV for first years (Stage 1)
Yrs Dividend Pv (20%)
1 1.2 1
2 1.44 1
3 1.73 1
4 2.07 1
5 2.49 1
Total 5
3|Page
Equity Analysis & Valuation SFM COMPILER
3 1.73 1.05
4 2.07 1.07
5 2.49 1.09
Total 5.26
2009
Question 4 May 2009 RTP
An investor is holding 2000 shares of X ltd. Current year dividend rate is Rs. 2 per share. Market price
of the share is Rs. 30 each. The investor is concerned about several factors are likely to change during
the next financial year as indicated below :
Current Year Next Year
Dividend paid / anticipated per share (Rs.) 2 1.8
Risk free rate 12% 10%
Market Risk Premium 5% 4%
Beta Value 1.3 1.4
Expected growth 9% 7%
In view of the above, advise whether the investor should buy, hold or sell the shares.
Solution :
Current Next
Re = Rf + (Rm – Rf) 12 + 1.3(5) = 18.5% 10 + 1.4(4) = 15.6%
D1 2 1.09 1.8 1.07
IV = = =
Re - g 0.185 0.09 0.156 0.07
=Rs.22.95 /sh. Rs.22.40/sh.
4|Page
SFM COMPILER Equity Analysis & Valuation
Solution :
FCFE1
IV =
Ke - g
FCFE = PAT – NI (Net Investment)
PAT = 290 Crores
PAT/Shares i.e EPS =
No of shares = 1300 / 40 = 32.5 Crores
PAT 290
EPS = = = Rs. 8.923 per share
No.of shares 32.5
NI = [(Capital Spending – Depreciation) + Working Capital] (1 – 0.27)
= [(47 – 39) + 3.45] (1‐0.27)
= 11.45 (1 – 0.27)
= 8.3585
FCFE = 8.923 – 8.3585 = 0.5645
Re = Rf + β (RM – Rf)
= 8.7 + 0.1 (10.3– 8.7) = 8.86%
0.5645 1.08
IV = = Rs.70.89 / shares
0.0886 0.08
5|Page
Equity Analysis & Valuation SFM COMPILER
(c) Based on the results of your computations in part b, which firm would be considered the best
investment? Why?
(d) Assume the industry PIE ratio generally is 15 x. Using the industry norm, estimate the price
for each share.
(e) What factors would cause you to adjust the PIE ratio value used in part d so that it is more
appropriate?
Solution :
(a)
P Ltd. Q Ltd. R Ltd.
WACC 14(1 – 0.35) 12(1 – 0.35) 10(1 – 0.35)
= i(l – t)
Kd 9.1 7.8 6.5
Ke 26% 22% 20%
= 9.1 0.8 + 26 = 7.8 0.5 + 22 = 6.5 0.2 + 20
Kc = w + Ke + w + Kd
0.2 = 12.48% 0.5 = 14.9% 0.8 = 17.3%
(b)
P Ltd. Q Ltd. R Ltd.
EVA = NOPAT – Kc 25000 (1 – 0.35)
16250 16250
NOPAT = EVIT – Tax = 16250
100000 12.48% = 100000 14.9% = 100000 17.3% =
Kc = Capital Kc
12480 14900 17300
EVA 3770 1350 –1050
(c) EVAP > EVAQ > EVAR; Thus, P Ltd. would be considered the best investment. The result should
have been obvious, given that the firms have the same EBIT, but WACCP < WACCQ < WACCR.
(d)
P Ltd. Q Ltd. R Ltd.
EBIT € 25,000 € 25,000 € 25,000
Interest* (11,200) (6,000) (2,000)
PBT 13,800 19,000 23,000
Tax (35%) (4,830) (6,650) (8,050)
Net income € 8,970 € 12,350 € 14,950
Shares 6,100 8,300 10,000
EPS € 1.470 € 1.488 € 1.495
Stock price: P/E = 15x € 22.05 € 22.32 € 22.425
6|Page
SFM COMPILER Equity Analysis & Valuation
(e) Given the three firms have substantially different capital structures, we would expect that
they also have different degrees of financial risk. Therefore, we might want to adjust the P/E
ratios to account for the risk differences.
Solution :
(a) Taxable income =Net income/(1‐ 0.40)
Taxable income= (Rs. 12,00,000)/(1‐ 0.40) = Rs. 20,00,000 = EBIT‐ Interest
EBIT = Taxable income + Interest
= Rs. 20,00,000 + Rs. 15,00,000
= Rs. 35,00,000
(b) EVA = EBIT(1‐ T)‐ (WACC X Invested capital)
= Rs. 35,00,000(1‐ 0.40)‐ (0.12 X Rs. 80,00,000)
= Rs. 21,00,000 ‐ Rs. 9,60,000
= Rs. 11,40,000
(c) EVA dividend = (Rs. 11,40,000)/500,000 = Rs. 2.28.
If AAA does not pay a dividend, we would expect the value of the firm to increase because it
will achieve higher growth, hence a higher level of EBIT. If EBIT is higher, then, all else equal,
the value of the firm will increase. (This assumes the firm has positive NPV projects in which
to invest.)
7|Page
Equity Analysis & Valuation SFM COMPILER
Solution :
(i) Income Statement :
Sales
Asset turnover ratio = = 1.1
Assets
Total Assets = Rs. 600
Turnover Rs. 600 lakhs 11 = Rs. 660 lakhs
Interest
Effective interest rate = = 8%
Liabilities
Liabilities = Rs. 125 lakhs+50 lakhs = 175 lakh
Interest =Rs. 175 lakhs× 0.08 = Rs. 14 lakh
Operating Margin = 10%
Hence operating cost = (1‐0.10) Rs. 660 lakhs = Rs. 594 lakh
Dividend Payout = 16.67%
Tax rate = 40%
Income statement (Rs. Lakhs)
Sale 660
Operating Exp 594
EBIT 66
Interest 14
EBT 52
Tax @ 40% 20.80
EAT 31.20
Dividend @ 16.67% 5.20
Retained Earnings 26.00
(ii) G = br
G = Growth
b = Retention Ratio
r = ROE
8|Page
SFM COMPILER Equity Analysis & Valuation
PAT 31.20
ROE = = = 7.8%
Equity 100 300
Retention Ratio = 100 – 16.67 = 83.33%
Growth = 83.33 x 7.8% = 6.5%
D1
(iii) IV =
Re - g
D = 5.2/10 = 0.52 per share
Ke = 15%
G = 6.5%
0.52 6.5%
IV = = Rs.6.51 per share
0.15 0.065
(iv) Since the current market price of share is Rs.14, the share is overvalued. Hence the investor
should not invest in the company.
Solution :
D1
Current IV =
Re - g
2(1.05)
= = Rs.20/share
0.155 0.05
D1
IV (growth rate = 8%) =
Re - g
2(1.08)
= = Rs.28.8 /share
0.155 0.08
D1
IV (growth rate = 3%) =
Re - g
2 1.03
= = Rs.16.48 /share
0.155 0.03
Note : IV and growth share direct relationship. Higher the growth, higher the share price and vice
versa.
2010
Question 10 May 2010 RTP
Suppose you are verifying a valuation done on an established company by a well‐known analyst has
estimated a value of Rs.750 lakhs, based upon the expected free cash flow next year, of Rs.30 lakhs,
and with an expected growth rate of 5%.
9|Page
Equity Analysis & Valuation SFM COMPILER
You found that, he has made the mistake of using the book values of debt and equity in his
calculation. While you do not know the book value weights he used, you have been provided
following information:
(a) Company has a cost of equity of 12%.
(b) After‐tax cost of debt of 6%.
(c) The market value of equity is three times the book value of equity, while the market value of
debt is equal to the book value of debt.
You are required to estimate the correct value of company.
Solution :
Step 1:
30
= 750 =
Kc - 0.05
Kc = 9%
Step 2:
Let X be the weight of Debt, then weight of equity = 1 ‐ x
Given Cost of equity = 12%;
Cost of debt = 6% then
12% (1‐X) + 6% X =9
Hence X = 0.50 : So book value weight for debt was 50%
Step3:
The above wts were based on book value. Weight based on market value will be
Equity = 0.5 3 = 1.5
Debt = 0.5 1 = 0.5
Total 2
Step 4:
Kc based or market value weights
1.5 0.5
12 +8 = 10.5
2 2
Step 5:
30
= = 545.45 lakhs
0.105 0.05
Correct firm value = Rs. 545.45 lakhs
10 | P a g e
SFM COMPILER Equity Analysis & Valuation
Solution :
1) EBIT 245
– Int. 218.125
EBT 26.875
– Tax 9.675
EAT 17.2
.
2) Tax rate = 100 = 36%
.
218.125
3) % Interest = 1934 100 = 11.28%
4)
Kc for 1st 5 years Kc beyond 5 yrs.
Ke = 16% Ke = 16%
Kd = 11.28(1 – 0.36) = 7.22% Debt = 1934 0.7 = 1353.8
MV of equity = 75 66 = Rs. 4950 Equity = 4950
Debt = 1934 Total 6303.8
Total = 6884 4950 1353.8
Kc = 6303.8 16% + 6303.8 7.22% = 14.11%
4950 1934
Kc = 6884 16 6884+ 7.22 = 13.53%
5)
Stage 1
2009 2010 2011 2012 2013 2014 2015
1) NOPAT
11 | P a g e
Equity Analysis & Valuation SFM COMPILER
2) NI
CS‐Dep. ‐ ‐ ‐ ‐ ‐
WC 3.52 3.801 4.11 4.43 4.79
(44 8%)
NI 3.52 3.801 4.11 4.43 4.79
FCFF 165.82 179.089 193.39 208.89 225.6 240.336
DF 0.881 0.776 0.683 0.602 0.530
DCF 146.08 138.97 132.09 125.75 119.56
Total = 662.45
6) Stage 2
FCFF6 240.336
V5 = =
Ke - g 0.1411 0.06
= 2963.45
V0 = 2963.45 0.530 = 1570.6298
7) Total value of firm = 662.45 + 1570.6298 = 2233.0798
Less Value of debt 1934
Value of 299.0798
299.0798
Value of equity = Rs.3.9877 /share
75
Question 12 May 2010 RTP
Herbal Gyan is a small but profitable producer of beauty cosmetics using the plant Aloe Vera. This is
not a high‐tech business, but Herbal’s earnings have averaged around Rs.12 lakh after tax, largely on
the strength of its patented beauty cream for removing the pimples.
The patent has eight years to run, and Herbal has been offered Rs.40 lakhs for the patent rights.
Herbal’s assets include Rs.20 lakhs of working capital and Rs.80 lakhs of property, plant, and
equipment. The patent is not shown on Herbal’s books. Suppose Herbal’s cost of capital is 15 percent.
What is its Economic Value Added (EVA)?
Solution :
EVA = Income earned– (Cost of capital x Total Investment)
Total Investments
Particulars Amount
Working capital Rs.20 lakhs
Property, plant, and equipment Rs.80 lakhs
12 | P a g e
SFM COMPILER Equity Analysis & Valuation
Solution :
(a)
Orange Grape Apple
WACC 14(1 – 0.35) 12(1 – 0.35) 10(1 – 0.35)
= i(l – t)
Kd 9.1 7.8 6.5
Ke 26% 22% 20%
= 9.1 0.8 + 26 = 7.8 0.5 + 22 = 6.5 0.2 + 20
Kc = w + Ke + w + Kd
0.2 = 12.48% 0.5 = 14.9% 0.8 = 17.3%
(b)
Orange Grape Apple
EVA = NOPAT – Kc 25000 (1 – 0.35)
16250 16250
NOPAT = EVIT – Tax = 16250
100000 12.48% = 100000 14.9% = 100000 17.3% =
Kc = Capital Kc
12480 14900 17300
EVA 3770 1350 –1050
13 | P a g e
Equity Analysis & Valuation SFM COMPILER
(c) EVAP > EVAQ > EVAR; Thus, P Ltd. would be considered the best investment. The result should
have been obvious, given that the firms have the same EBIT, but WACCP < WACCQ < WACCR.
(d)
Orange Grape Apple
EBIT € 25,000 € 25,000 € 25,000
Interest* (11,200) (6,000) (2,000)
PBT 13,800 19,000 23,000
Tax (35%) (4,830) (6,650) (8,050)
Net income € 8,970 € 12,350 € 14,950
Shares 6,100 8,300 10,000
EPS € 1.470 € 1.488 € 1.495
Stock price: P/E = 15x € 22.05 € 22.32 € 22.425
Solution :
Valuation Equation
EVAt = NOPATt – (Total Invest Capitalt x WACCt)
EVA1 = Rs.14,00,000 – (Rs.1,00,00,000 X 0.0842) = Rs.5,58,000
EVA2 = Rs.16,00,000 – (Rs.1,10,00,000 X 0.0842) = Rs.6,73,800
Total Valuation Equation
=
558000
673800
673800 1 0.065
1.0842 1.0842 2 0.0842 0.065
1.0842
2
= Rs.5,14,665 + Rs.5,73,207 + Rs.3,17,95,128 + Rs.90,00,000
= Rs.4,18,83,000
14 | P a g e
SFM COMPILER Equity Analysis & Valuation
Industry data for pure play firms have been compiled and are summarized as follows :‐
Business Capitalization/Sales Capitalization Capitalization /
Segment Assets Operating Income
Wholesale 0.85 0.7 9
Retail 1.2 0.7 8
General 0.8 0.7 4
Solution :
Wholesale
Sales 225000 0.85 = 191250
Assets 600000 0.7 = 420000 428750 (avg.)
Op.Inc. 75000 9 = 675000
Retail
Sales 720000 1.2 = 864000
Assets 500000 0.7 = 350000 804666.67
Op.Inc. 150000 8 = 1200000
General
Sales 2500000 0.8 = 2000000
Assets 4000000 0.7 = 2800000 2533333.33
Op.Inc. 700000 4 = 2800000 __________
TOTAL 3766750
15 | P a g e
Equity Analysis & Valuation SFM COMPILER
Solution :
Re = Rf + β(Rm – Rf)
= 10 + 1.2 (15 – 10)
= 10 + 6 = 16%
D1
IV =
Re - g
3 x (1.12)
= 0.16 ‐ 0.12 = Rs.84/share
Solution :
1) Operating Income (EBIT)
NPAT 15,00,000
+ tax. (40%) 10,00,000
NPBT 25,00,000
+ Int. 15,00,000
EBIT 40,00,000
2) EVA = NOPAT – Kc
a) NOPAT = 40,00,000 – 40%
= 24,00,000
b) Cost of capital = 1,00,00,000 12.6
= Rs. 12,60,000
c) EVA = 24,00,000 – 12,60,000
= 11,40,000
11, 40, 000
3) Max. dividend per share = = 4.56/share
2, 50, 000
The value of firm will increase provided NPV is positive.
16 | P a g e
SFM COMPILER Equity Analysis & Valuation
A valuation done of an established company by a well‐known analyst has estimated a value of Rs.500
lakhs, based on the expected free cash flow for next year of Rs.20 lakhs and an expected growth rate
of 5%.
While going through the valuation procedure, you found that the analyst has made the mistake of
using the book values of debt and equity in his calculation. While you do not know the book value
weights he used, you have been provided with the following information:
(i) Company has a cost of equity of 12%,
(ii) After tax cost of debt is 6%,
(iii) The market value of equity is three times the book value of equity, while the market value of
debt is equal to the book value of debt.
You are required to estimate the correct value of the company.
Solution :
FCFF1
Vo = Kc ‐ 1
20
500 = Kc ‐ 0.05
Kc = 0.09 i.e 9%
Let the weight of the debt be x
Wt of Equity will be (1‐x)
WACC = Wt debt + Wt Equity
= 12(1 – x) + 6(x) = 9
X = 0.5 ‐‐‐ these were old weights
i.e equity and debt were 50 – 50 (book values), however equity shall be 50 x 3 = 150 and debt shall
be 50 x 1 = 50. This puts the weights to 75 : 25 (Equity/Debt)
New WACC = 12 (0.75) + 6(0.25) = 10.50%
FCFF1 20
Vo = Kc ‐ 1 = 0.105 ‐ 0.05 = Rs.363.64
2011
Question 19 May 2011 ‐ RTP
Calculate Economic Value Added (EVA) with the help of the following information of Hypothetical
Limited:
Financial leverage : 1.4 times
Capital structure : Equity Capital Rs.170 lakhs
Reserves and surplus Rs.130 lakhs
10% Debentures Rs.400 lakhs
Cost of Equity : 17.5%
Income Tax Rate : 30%.
Solution :
EBIT 140 1.4
17 | P a g e
Equity Analysis & Valuation SFM COMPILER
– Int 40 0.4
EBT 100 1.0
40
EBIT = 0.4 1.4 = 140
NOPAT = EBIT (1 – t) = 140(1 – 0.3) = 98
Ke = 17.5%
Kd = 10(1 – 0.3) – 7%
300 400
WACC = × 17.5 + × 7%
700 700
Cost of capital = 700 11.5% = 80.5
EVA = 98 – 80.5 = 17.5
Solution :
Retained Earning = Rs.3 = 37.5%
3
Earnings = Rs.8 37.5%
Dividend = Rs.5 (8 – 3)
P.E. ratio = 7.5
MPs = EPs P.E. = 8 7.5
= Rs.60/share
Re = ?, if g = 12%
D1
A) IV = Re ‐ g
5(1.12)
60 = Re ‐ g Re = 21.33%
B) If g = 13%
5(1.13)
IV = 0.2133 ‐ 0.13 = Rs.67.83/share
C) If Re = 18%, g = 15%
5(1.15)
IV =0.18 ‐ 0.15 = Rs.191.67/share
18 | P a g e
SFM COMPILER Equity Analysis & Valuation
Solution :
1) Net Assets Value
Assets (R.V.)
L&B 96
P&M 100
Investments 10
Stock 20
Debtors 15
Cash / Bank 5 246
Less Liabilities (R.V.)
Creditors 30
Net Assets 216
Net Assets for ESH
I.V. = No. of shares
216
= 10
= Rs.21.6/share
2) Yield value
19 | P a g e
Equity Analysis & Valuation SFM COMPILER
ERR
Profit 64
‐ Extra Inc. (4)
‐ Inc. from Inv. (1)
‐ Add. Exp. (5)
‐ Add. Dep. (6)
NPBT 48
‐ tax @ 30% 14.4
NPAT 33.6
33.6
ERR = 100 100 = 33.6%
(Capital)
NRR = 15%
33.6 33.6
Yield = 100 = 100 = 22.4/share
NRR 15
IV+Yield
3) Fair value =
2
21.6 22.4
=
2
= Rs.22/share
Solution :
Retained Earning = Rs.5 = 45%
5
Earnings = Rs.11.11
45%
Dividend = Rs.6.11 (11.11 – 5)
P.E. ratio =8
MPs = EPS P.E. = 11.11 8
= Rs.88.88/share
A) Re = ?, if g = 15%
D1
IV =
Re - g
20 | P a g e
SFM COMPILER Equity Analysis & Valuation
6.11
88.88 = Re = 21.87%
Re - 0.15
B) If g = 16%
6.11
IV = = Rs.104.08/share
0.2287 0.16
C) If Re = 20%, g = 19%
6.11
IV = = Rs.611/share
0.20 0.19
Question 23 May 2011 ‐ Paper – 8 Marks
Tender Ltd. has earned a net profit of 15 lacs after tax at 30%. Interest cost charged by financial
institutions was 10 lacs. The invested capital is 95 lacs of which 55% is debt. The company maintains
a weighted average cost of capital of 13%.
Required
(a) Compute the operating income.
(b) Compute the Economic Value Added (EVA).
(c) Tender Ltd. has 6 lac equity shares outstanding. How much dividend can the company pay
before the value of the entity starts declining?
Solution :
(a) Operating Income
NPAT 15 70%
15
NPBT = = 21.42
70%
EBIT = 21.42 + 10 = 31.42
(b) EVA = NOPAT – Cost of Capital
(i) NOPAT
EBIT 31.42
‐tax (30%) ____
NOPAT Rs. 22
(ii) Cost of Capital = 95 13%
= Rs. 12.35
EVA = 22 – 12.35
= 9.65
(c) The maximum amount that a company can pay before the value of entity starts decreasing is
equal to EVA.
9.65
Max. dividend per share = 6 = Rs.1.608/share
21 | P a g e
Equity Analysis & Valuation SFM COMPILER
expenditure for launching a new product. The benefits of this expenditure is expected to be lasted
for 3 years.
The cost of capital of division C is 11% and cost of debt is 8%.
The Net Assets (Invested Capital) of Division C as per latest Balance Sheet is Rs.60 crore, but
replacement cost of these assets is estimated at Rs.84 crore
You are required to compute EVA of Division C.
Solution :
First necessary adjustment of the data as reported by historical accounting system shall be made as
follows:
Rs.
Operating Profit 20,20,00,000
Add: Cost of unutilized Advertisement Expenditures 2,00,00,000
22,20,00,000
Invested Capital (as per replacement cost) is Rs.84 crore.
Accordingly,
EVA = Operating Profit – (Invested Capital x Cost of Capital)
= Rs.22,20,00,000 – (Rs.84 crore x 11%)
= Rs.22.2 crore – Rs.9.24 crore
= Rs.12.96 crore.
Solution :
1) Beta of Company’s existing Portfolio
β Assets = β Liabilities
β Liabilities = Wt β Equity + wt β Debt
Since β Debt is not given to us, we assume it to be Zero
Equity = 60,00,000
Debt = 40,00,000
Total = 1,00,00,000
Therefore, β Assets = 1.5 x 60/100 = 0.9
2) Cost of Capital
Ke = Rf + β (RM – Rf)
22 | P a g e
SFM COMPILER Equity Analysis & Valuation
Ke = Cost of capital
Rf = Risk Free Rate
RM = Market Return
Rm – RF = Market Risk Premium
Therefore, Ke = 8 + 0.9 x 10 = 17%
Solution :
EPS = 137.80 x 15% = 20.67
Dividend = 20.67 x 40% (Retention is 60%) = 8.268
G = br
= 60 x 15% = 9%
D1 = 8.268 x 1.09 = 9.01
D1
IV =
Re - g
9.01
= 0.18 ‐ 0.09 = Rs. 100.11/share
23 | P a g e
Equity Analysis & Valuation SFM COMPILER
As per the new strategy, sales will grow at 30 percent per year for the next four years. The gross
margin ratio will increase to 35 percent. The Assets turnover ratio and income tax rate will remain
unchanged.
Depreciation is to be at 15 percent on the value of the net fixed assets at the beginning of the year.
Company's target rate of return is 14%.
Determine if the strategy is financially viable giving detailed workings
Solution :
1) Value of firm before strategy
FCFE(PAT) 4200
Vf = = = Rs.30,000
Ke 14%
2) Value of firm after the strategy
a) Stage 1
FCFE 1 2 3 4
PAT 5460 7098 9227.4 11995.62
(4200 + 305)
– NI 4500 5850 7605 9556.50
(15000 30%)
960 1248 1622.4 2109.12
PV @14% 842.11 960.30 1095.07 1248.77
Total = 4146.25
b) Stage 2
FCFE5 11995.62
Vf4 = = = 85683
Ke 0.14
85683
Vf0 = = 50731.21
1.144
Total value = 50731.21 + 4143.25 = 54877.46
3) Value of strategy
Value of firm Af strategy 54877.46
Value of firm Bf strategy 30000
24877.46
Advice : Since value of strategy is positive the firm should implement the strategy.
2012
Question 29 May 2012 RTP
The following data pertains to XYZ Inc. engaged in software consultancy business as on 31 December
2010
$ Million
Income from consultancy 935.00
EBIT 180.00
Less : Interest on Loan 18.00
EBT 162.00
24 | P a g e
SFM COMPILER Equity Analysis & Valuation
With the above information and following assumption you are required to compute
(a) Economic Value Added®
(b) Market Value Added.
Assuming that:
(i) WACC is 12%.
(ii) The share of company currently quoted at Rs. 50 each
Solution :
1) EVA = NOPAT – Cost of Capital
NOPAT = EBIT (1 – t)
= 180 (1 – 0.35)
= 117
Kc = Capital = 100 + 325 + 180 = 605
= 605 12% = 72.6
EVA = 117 – 72.6 = 44.4
2) MVA
MV BV
Equity Capital 500 100
Reserves ‐ 325
Debt 180 180
Total 680 605
MVA = MV – BV
= 680 – 605
= 75
25 | P a g e
Equity Analysis & Valuation SFM COMPILER
Solution :
1)
Satge 1 Ke Stage 2 Kc
Re = Rf + (Rm – Rf) Re = 9 + 1 (5) = 14%
= 10 + 1.15 (6) Kd = 12.86 (1 – 0.3) = 9%
= 16.9% 2 3
Kc = 5 x 9 + 5 x 14 = 12%
Kd = i (1 – t) = 13 (1 – 0.3)
= 9.1%
Kc = Kc 0.5 x 9.1 + 0.5 x 16.9
= 13%
2) Stage 1
Base 1 2 3 4 5
1) NOPAT
EBIT 300 360 432 518.4 622.08 684.288
(300 + 20%) (622.08 + 10%)
‐Tax (30%) NOPAT 103 129.6 155.52 186.62 205.286
252 302.4 362.88 435.46 479
2) Net
Invest
Capital Sp 280
26 | P a g e
SFM COMPILER Equity Analysis & Valuation
–Dep 200 ‐ ‐ ‐ ‐
i) 80 96 115.2 138 165.8 Nil
(80 + 10%)
Revenue 2000 2400 2880 3456 4147.2 4561.92
(2000 + 20%) (4147.2 + 10%)
WC 500 600 720 864 1036.8 1140.48
ii) WC 100 120 144 172.8 103.68
NI(i +ii) 196 235.2 282 338.6 103.68
FCFF = (NOPAT – 56 67.2 80.88 96.856 375.32
NI)
PV @ 13% 49.56 52.61 56.05 59.4
Total = 217.63
3) Stage 2
FCFF5 375.32
V4 = = 0.12 ‐ 0.1 = 18766
Kc - g
18766
V0 = = 11509.54
1.134
Total = Stage 1 + Stage 2
= 217.63 + 11509.54 = Rs.11727.17
Solution :
1. Firm offer one right share for 2 shares held
10,00,000
No of shares to be issued = = 5,00,000 shares
2
2,00,00,00 0
Subscription Price = = Rs. 40 / shares
5,00,000
Ex Right Price =
10,00,000 130 2,00,00,000 = Rs.100
15,00,000
Value of Right = 100 – 40 = Rs. 60/share
27 | P a g e
Equity Analysis & Valuation SFM COMPILER
3. Calculation of effect of right issue on shareholders wealth (Assuming he is holding 100 shares)
One share for 2 held One share for 4 held
Value of shares after right 15000 15000
(150 x 100) (125 x 120)
Less cost of right 2000 2000
(50 x 40) (25 x 80)
Net Value after right 13000 13000
Value before right 13000 13000
(100 x 130) (100 x 130)
Effect of right issue NIL NIL
Question 32 May 2012 Paper – Similar to ‐ Question 22 ‐ May 2011 ‐ Paper – 8 Marks
Solution :
(i) According to Dividend Discount Model approach the firm’s expected or required return on
equity is computed as follows:
D
Re = 1 + g
P0
Where
Ke = Cost of equity share capital
D1 = Expected dividend at the end of year 1
P0 = Current market price of the share.
g = Expected growth rate of dividend.
28 | P a g e
SFM COMPILER Equity Analysis & Valuation
3.36
Therefore Ke = 146 + 7.5 = 9.80%
(ii) With rate of return on retained earnings (r) 10% and retention ratio (b) 60%, new growth rate
will be as follows:
g = br i.e.
= 0.10 x 0.60 = 0.06
Accordingly dividend will also get changed and to calculate this, first we shall calculate
previous retention ratio (b1) and then EPS assuming that rate of return on retained earnings
(r) is same.
With previous Growth Rate of 7.5% and r =10% the retention ratio comes out to be:
0.075 =b1 X 0.10
b1 = 0.75 and payout ratio = 0.25
With 0.25 payout ratio the EPS will be as follows:
3.36 = 13.44
0.25
With new 0.40 (1 – 0.60) payout ratio the new dividend will be
D1 = 13.44 0.40 = 5.376
5.376
Accordingly new Ke will be ke = 146 + 6.0 Ke = 9.68%
29 | P a g e
Equity Analysis & Valuation SFM COMPILER
1 – 4 years 1.6
5 – 8 years 2
(b) An additional advertisement and sales promotion campaign shah be launched requiring
expenditure as per following details:
Period Amount ($ Million)
1 year 0.50
2‐3years 1.50
4‐6years 3.00
7‐8years 1.00
(c) Fixed Assets are subject to depreciation at 15% as per WDV method.
(d) The company has planned capital expenditure for the coming 8 years as follows
Period Amount ($ Million)
1 0.50
2 0.60
3 2.00
4 2.50
5 3.50
6 2.50
7 1.50
8 1.00
(e) Investment in working capital to be 20% of Revenue
(f) Applicable tax rate for the company is 30%
(g) Cost of Equity is estimated to be 16%
(h) The free cash flows of the firm is expected to grow at 5% per annum after 8 years
With above information you are required to determine the
(i) Value of the firm
(ii) Value of Equity
Solution :
1) Working note for depreciation
Year 1 2 3 4 5 6 7 8
Assets Op. 17 14.875 13.15375 12.881 13.074 14.088 14.1 13.26
+ Cap.sp. 0.5 0.6 2 2.5 3.5 2.5 1.5 1
Assets 17.5 15.475 15.15375 15.381 16.57 16.588 15.6 14.26
‐ Dep. 2.625 2.32125 2.273 2.3071 2.486 2.488 2.34 2.139
Assets Clo. 14.875 13.15375 12.881 13.074 14.088 14.1 13.26 12.121
2) Kc = 16%
Kd = i(1 – t)
= 12(1 – 0.3)
30 | P a g e
SFM COMPILER Equity Analysis & Valuation
= 8.4%
12 8
WACC = 20 16% + 20 8.4%
= 12.96%
5) FCFF
Year 1 2 3 4 5 6 7 8
(NOPAT – 0.5775 0.13225 (0.189) (0.1879) 0.345 0.466 2.162 1.9417
NI)
PV @ 0.511 0.1036 (0.131) (0.115) 0.188 0.224 0.921 0.732
12.96%
FCFF9
6) V8 = Kc ‐ g
1.9417(1.05)
=
0.1296 0.05
= 25.612
25.612
V0 (Stage 2) = = 9.66
1.12968
7) Value of firm = Stage II + Stage II
31 | P a g e
Equity Analysis & Valuation SFM COMPILER
= 2.4336
= 2.4336 + 9.66
= 12.09
Value of equity = Value of Firm – Value of Debt
= 12.09 – 8
= 4.09
Assets:
Net Fixed Assets 220.00 0.50
Net Current Assets 1,020.00 29.00
Deferred Tax Assets 60.00 2.00
Total 1,300.00 31.50
H Ltd. proposes to buy out B Ltd. and the following information is provided to you as part of the
scheme of buying:
(1) The weighted average post tax maintainable profits of H Ltd. and B Ltd. for the last 4 years
are Rs. 300 crores and Rs. 10 crores respectively.
(2) Both the companies envisage a capitalization rate of 8%.
(3) H Ltd. has a contingent liability of Rs. 300 crores as on 31st March, 2012.
(4) H Ltd. to issue shares of Rs. 100 each to the shareholders of B Ltd. in terms of the exchange
ratio as arrived on a Fair Value basis. (Please consider weights of 1 and 3 for the value of
shares arrived on Net Asset basis and Earnings capitalization method respectively for both H
Ltd. and B Ltd.)
You are required to arrive at the value of the shares of both H Ltd. and B Ltd. under:
(i) Net Asset Value Method (ii) Earnings Capitalisation Method
Solution :
Net Assets for Equity Shareholders
(i) Net Asset Value = No. of Shares
32 | P a g e
SFM COMPILER Equity Analysis & Valuation
1300‐300
H Ltd. = 3.5 = Rs. 285.71 per share
31.5
B Ltd. = 0.65 = Rs. 48.46 per share
Earnings / NPR
(ii) Earning Capitalization Method = No. of Shares
300 / 0.08
H Ltd. = = Rs. 1071.43 per share
3.5
10 / 0.08
B Ltd. = = Rs. 192.31 per share
0.65
Net Assets Value + Earnings Capitalization Method
(iii) Fair Value = 2
285.71 x 1 + 1071.43 x 3
H Ltd. = 4 = Rs. 875 per share
48.46 x 1 + 192.31 x 3
B Ltd. = 4 = Rs. 156.3475 per share
156.3475
Exchange Ratio = 875 = 0.1787
H Ltd Should issue its 0.1787 share for each share of B Ltd.
Question 36 Nov 2012 Paper – 4 Marks – Similar to ‐ Question 19 ‐ May 2011 ‐ RTP
Solution :
(i) Value of Business
Existing Business New Business
33 | P a g e
Equity Analysis & Valuation SFM COMPILER
Profit 98
Value of Business = Capitalization Rate = 14% = 700
(ii) Market Price of Equity shares
Profit After Tax 98
Less Preference Dividend 13
Profits for Equity shareholders 85
No. of shares 50 Lakhs shares
EPS Rs. 1.70 per shares
P.E Ratio 10
Market Price Per shares (EPS x PE) 17 shares
Rs. in lakhs
Equity share Capital 100
8%debentures 125
10% bonds (2007) 50
Equity shares (Rs. 10 each) 100
Reserves and Surplus 200
Total Assets 500
Assets Turnovers ratio 1 .1
Effective tax rate 30%
Operating margin 10%
Dividend payout ratio 20%
Current market Price of Share 13
Required Return for ESH 15%
You are required to:
(i) Draw income statement for the year
(ii) Calculate its sustainable growth rate
(iii) Calculate the fair price of the company’s share using dividend discount model, and
(iv) What is your opinion on investment in the company’s share at current price?
34 | P a g e
SFM COMPILER Equity Analysis & Valuation
Solution :
Workings:
Asset turnover ratio = 1.1
Total Assets = Rs.500 lakhs
Turnover Rs.500 lakhs × 1.1 = Rs.550 lakhs
(i) Income Statement
Rs.in Lakhs
Sales (500 1.1) 550.00
Less : Operating Expenses 495.00
EBIT (10%) 55.00
Less : Interest (125 0.08 + 50 0.1) 15.00
EBT 40.00
Less : Tax (30%) 12.00
EAT 28.00
Less : Dividend (20%) 5.60
Retained Earnings 22.40
(ii) Growth Rate
G = br
NPAT 28
ROE = Net Worth = 100 + 200 x 100 = 9.33%
b = 1 – payout ratio = 1 – 0.2 = 0.8 = 80%
g = 80 9.33% = 7.464%
(iii) IV of the share using Dividend Discount Model
D1
IV = Ke ‐ g
5.6
D1 = 10 + 7.464% = 0.6018
0.6018
Iv = 0.15‐0.07464 = Rs.8 Per share
(iv) The current market price of the shares if Rs.13 and the Iv is 8, therefore the share is overpriced
in the market and hence the investor should go short.
35 | P a g e
Equity Analysis & Valuation SFM COMPILER
The sales of the company are growing and to support this, the company proposes to obtain additional
borrowing of Rs.100 lakhs expected to cost 16%.The increase in EBIT is expected to be 15%.
Calculate the change in interest coverage ratio after the additional borrowing is effected and
comment on the arrangement made.
Solution :
Calculation of Present Interest Coverage Ratio
Present EBIT = Rs.90 lakh
Interest charges (present) Rs.in lakhs
Term loan @ 12% 36.00
Bank Borrowing @ 15% 30.00
Public Deposit @ 11% 11.00
77.00
EBIT
Present Interest Coverage Ratio = Inerest Charges
Rs.90 lakhs
=
Rs.77 lakhs
= 1.169
36 | P a g e
SFM COMPILER Equity Analysis & Valuation
Solution :
(i) Iv of the share (By Dividend Discount Model)
D1
Iv =
Ke g
D1 = 5 + 2% = 5.1 per share
5.1
Iv = = Rs.63.75 per share
0.010 - 0.02
(ii) ROE = 8%
G = br
Where
G = Growth = 2%
b = Retention Ratio
r = ROE = 8%
2 = b x 8%, therefore b = 25%
Payout Ratio = 100 – 25 = 75%
Dividend = 3 x 75% = 2.25
D1 2.25(1.02)
New Price of share = = = Rs.28.6875
Ke g 0.10 - 0.02
The Stock is overpriced at 40
2013
Question 41 May 2013 ‐ Paper – 8 Marks
X Limited, just declared a dividend of Rs.14.00 per share. Mr. B is planning to purchase the share of
X Limited, anticipating increase in growth rate from 8% to 9%, which will continue for three years. He
also expects the market price of this share to be Rs.360.00 after three years.
You are required to determine:
(i) the maximum amount Mr. B should pay for shares, if he requires a rate of return of 13% per
annum.
(ii) the maximum price Mr. B will be willing to pay for share, if he is of the opinion that the 9%
growth can be maintained indefinitely and require 13% rate of return per annum.
(iii) the price of share at the end of three years, if 9% growth rate is achieved and assuming other
conditions remaining same as in (ii) above.
Calculate rupee amount up to two decimal points.
Year‐1 Year‐2 Year‐3
FVIF @ 9% 1.090 1.188 1.295
FVIF @ 13% 1.130 1.277 1.443
PVIF @ 13% 0.885 0.783 0.693
Solution :
(i) Stage 1
Year Dividend PV@13%
37 | P a g e
Equity Analysis & Valuation SFM COMPILER
1 15.26 13.50
2 16.6334 13.03
3 18.13 12.56
39.09
Stage 2
360
IV0 = = 250
1.133
Total IV = 250 + 39.09
= 289.09
(ii) If growth rate 9% is achieved for indefinite period, then maximum price of share should Mr.
A willing be to pay is
D1 15.26
Iv = = = Rs.381.50 per share
Re g 0.13 - 0.09
(iii) Assuming that conditions mentioned above remain same, the price expected after 3 years will
D4 18.13 1.09
be: = = Rs.494 per share
Ke g 0.04
Question 42 Nov 2013 RTP – Similar to ‐ Question 5 ‐ May 2009 Paper – 6 Marks
Solution :
Retained Earning = Rs.3 = 37.5%
3
Earnings = Rs.8 37.5%
Dividend = Rs.5 (8 – 3)
P.E. ratio = 7.5
MPs = EPs P.E. = 8 7.5
= Rs.60/share
D1
A) IV =
Re g
38 | P a g e
SFM COMPILER Equity Analysis & Valuation
5(1.12)
60 = Re ‐ 0.12 Re = 21.33%
B) If g = 13%
51.13
IV = = Rs.67.83/share
0.2133 - 0.13
C) If Re = 18%, g = 15%
5(1.15)
IV = 0.18 ‐ 0.0.15 = Rs.191.67/share
2014
Question 45 May 2014 ‐ RTP
A valuation done of an established company by a well‐known analyst has estimated a value of Rs.
500 lakhs, based on the expected free cash flow for next year of Rs. 20 lakhs and an expected growth
rate of 5%.
While going through the valuation procedure, you found that the analyst has made the mistake of
using the book values of debt and equity in his calculation. While you do not know the book value
weights he used, you have been provided with the following information:
(i) Company has a cost of equity of 12%,
(ii) After tax cost of debt is 6%,
(iii) The market value of equity is three times the book value of equity, while the market value of
debt is equal to the book value of debt. You are required to estimate the correct value of the
company.
Solution :
FCFF1
Vo = Kc ‐ 1
20
500 = Kc ‐ 0.05
Kc = 0.09 i.e 9%
Let the weight of the debt be x
Wt of Equity will be (1‐x)
WACC = Wt debt + Wt Equity
= 12(1 – x) + 6(x) = 9
X = 0.5 ‐‐‐ these were old weights
i.e. equity and debt were 50 – 50 (book values), however equity shall be 50 x 3 = 150 and debt shall
be 50 x 1 = 50. This puts the weights to 75 : 25 (Equity/Debt)
New WACC = 12 (0.75) + 6(0.25) = 10.50%
FCFF1 20
Vo = Kc ‐ 1 = 0.105‐0.05 = Rs. 363.64
39 | P a g e
Equity Analysis & Valuation SFM COMPILER
MNP Ltd. has declared and paid annual dividend of Rs. 4 per share. It is expected to grow @ 20% for
the next two years and 10% thereafter. The required rate of return of equity investors is 15%.
Compute the current price at which equity shares should sell.
Note: Present Value Interest Factor (PVIF) @ 15%:
For year 1 = 0.8696;
For year 2 = 0.7561
Solution :
Stage 1 : Explicit Stage
Year Dividend PV of Dividend (15%
1 4.80 4.17408
2 5.76 4.355136
Total 8.529216
Stage 2 : Horizon Stage
D3 5.76 + 10%
IV2 = = 0.15 ‐ 0.1 = 126.72
Re g
IV0 = 126.72 x 0.7561 = 95.812992
Total IV = Stage 1 + Stage 2 = 8.529216 + 95.812992 = Rs.104.342208
40 | P a g e
SFM COMPILER Equity Analysis & Valuation
Solution :
Working Note 1 :
FCFF = NOPAT – NI
(i) NOPAT = EBIT (I – t)
Year 1 Year 2 Year 3 Year 4
Revenue 9000.00 10800.00 12960.00 13996.80
Less : COGS 3600.00 4320.00 5184.00 5598.72
Less : Operating Expenses 1980.00 2376.00 2851.20 3079.30
Less : Depreciation 720.00 864.00 1036.80 1119.74
EBIT 2700.00 3240.00 3888.00 4199.04
Less : Tax (30%) 810.00 972.00 1166.40 1259.71
NOPAT 1890.00 2268.00 2721.60 2939.33
(iii) FCFF
Year 1 Year 2 Year 3 Year 4
NOPAT – NI 1342.50 1619.62 1953.47 2680.13
Stage 1 : Explicit
Year FCFF PV @ 15%
1 1342.50 1167.44
2 1619.62 1224.59
3 1953.47 1284.41
Total 3676.44
Stage 2 : Horizon Stage
FCFF4 .
V3 = = = 38287.57
Kc g . .
.
V0 = = Rs. 25174.08 Crore
.
Total Value of Firm
= Stage 1 + Stage 2 = 3676.44 + 25,174.70 = Rs. 28,851.14 Crores
41 | P a g e
Equity Analysis & Valuation SFM COMPILER
RST Ltd.’s current financial year's income statement reported its net income as Rs. 25,00,000. The
applicable corporate income tax rate is 30%.
Following is the capital structure of RST Ltd. at the end of current financial year:
Rs.
Debt (Coupon rate = 11%) 40 lakhs
Equity (Share Capital + Reserves & Surplus) 125 lakhs
Invested Capital 165 lakhs
Following data is given to estimate cost of equity capital:
Rs.
Beta of RST Ltd. 1.36
Risk –free rate i.e. current yield on Govt. bonds 8.5%
Average market risk premium (i.e. Excess of return on
market portfolio over risk‐free rate) 9%
Required:
(i) Estimate Weighted Average Cost of Capital (WACC) of RST Ltd.; and
(ii) Estimate Economic Value Added (EVA) of RST Ltd
Solution :
(i) WACC
Cost of Equity as per CAPM
ke = Rf + x (RM – Rf) ‐ Market Risk Premium
= 8.5% + 1.36 x 9%
= 8.5% + 12.24%
= 20.74%
Cost of Debt
kd = 11%(1 – 0.30) = 7.70%
125 40
WACC = Wt Ke + Wt Kd = 20.74 x 165 + 7.70 x 165 = 17.58%
(ii) Economic Value Added
Net Profit After Tax = 25,00,000
Add : Tax (30%)
Net Profit Before Tax = 35,71,429
Add Interest = 4,40,000
EBIT = 40,11,429
EVA = Nopat – Kc (Amount
Nopat = EBIT (1 – t) = 40,11,429 (1‐0.3) = 28,08,000
Kc (Amount) = 125,00,000 + 40,00,000) x 17.58% = 29,00,700
EVA = 28,08,000 – 29,00,700 = ‐ 92,700
42 | P a g e
SFM COMPILER Equity Analysis & Valuation
Solution :
FCFF1
VO = Kc ‐ 1
1800 =
.
Kc = 0.12 i.e 12%
Let the weight of the debt be x
Wt of Equity will be (1‐x)
WACC = Wt Equity + Wt Debt
= 20(1 – x) + 10(x) = 12
X = 0.8 – Weight of Debt
Weight of Equity = 1 – 0.8 = 0.2
i.e equity and debt were 20 and 80 respectively (book values),
however equity shall be 20 x 3 = 60
and debt shall be 80 x 9/10 = 72
Total = 132
New WACC = 20 (60/132) + 10(72/132) = 14.5455%
FCFF1
VO = Kc ‐ g = = Rs.973.76 lakhs.
. .
43 | P a g e
Equity Analysis & Valuation SFM COMPILER
Solution :
CY NY
(i) Re = Rf + (Rm – Rf) 12 + 1.3(5) 10 + 1.4 (4)
= 18.5 = 15.6
D1 3(1.09) 2.5(1.07)
(ii) IV = = =
Re g 0.185 - 0.09 0.156 - 0.07
= Rs.34.42/sh = Rs.31.10/sh
2015
Question 54 May 2015 – RTP
ABC Ltd. has divisions A,B & C. The division C has recently reported on annual operating profit of
Rs.20,20,00,000. This figure arrived at after charging Rs.3 crores full cost of advertisement
expenditure for launching a new product. The benefits of this expenditure is expected to be lasted
for 3 years.
The cost of capital of division C is 11% and cost of debt is 8%.
44 | P a g e
SFM COMPILER Equity Analysis & Valuation
The Net Assets (Invested Capital) of Division C as per latest Balance Sheet is Rs.60 crore, but
replacement cost of these assets is estimated at Rs. 84 crore.
You are required to compute EVA of the Division C.
Solution :
First necessary adjustment of the data as reported by historical accounting system shall be made as
follows:
Rs.
Operating Profit 20,20,00,000
Add: Cost of unutilized Advertisement Expenditures 2,00,00,000
22,20,00,000
Invested Capital (as per replacement cost) is Rs. 84 crore.
Accordingly, EVA = Operating Profit – (Invested Capital x Cost of Capital)
= Rs. 22,20,00,000 – Rs. 84 crore x 11%
= Rs. 22.2 crore – Rs. 9.24 crore
= Rs. 12.96 crore
Solution :
1) Beta of Company’s existing Portfolio
β Assets = β Liabilities
β Assets = Wt β Equity + wt β Debt
Since β Debt is not given to us, we assume it to be Zero
Equity = 60,00,000
Debt = 40,00,000
Total = 1,00,00,000
Therefore, β Assets = 1.5 x 60/100 = 0.9
2) Cost of Capital
Ke = Rf + β (RM – Rf)
= 8 + 0.09(10) = 179
45 | P a g e
Equity Analysis & Valuation SFM COMPILER
Two companies A Ltd. and B Ltd. paid a dividend of Rs. 3.50 per share. Both are anticipating that
dividend shall grow @ 8%. The beta of A Ltd. and B Ltd. are 0.95 and 1.42 respectively.
The yield on GOI Bond is 7% and it is expected that stock market index shall increase at annual rate
of 13%. You are required to determine:
(a) Value of share of both companies.
(b) Why there is a difference in the value of shares of two companies.
(c) If current market price of share of A Ltd. and B Ltd. are Rs. 74 and Rs. 55 respectively. As an
investor what course of action should be followed?
Solution :
(a) First of all we shall compute Cost of Capital (Ke) of these companies using CAPM as follows:
Ke = Rf + β (RM – Rf)
Ke (A) = 7.00% + (13% ‐7%)0.95
= 7.00% + 5.70% = 12.7%
Ke (B) = 7.00% + (13% ‐7%)1.42
= 7.00% + 8.52% = 15.52%
(b) Value of shares
D1 3.5 + 8%
Va = Re ‐ g = 0.127 ‐ 0.08 = Rs. 80.43
D1 3.5 + 8%
Vb = Re ‐ g = 0.1552 ‐ 0.08 = Rs. 50.27
(c) The valuation of share of B Ltd. is lower because systematic risk is higher though both have
same growth rate.
(d) If the price of share of A Ltd. is Rs.74, the share is undervalued and it should be bought. If
price of share of B Ltd. is Rs.55, it is overvalued and should not be bought.
Question 58 Nov 2015 – RTP ‐ Similar to ‐ Question 17 ‐ Nov 2010 ‐ Paper – 8 Marks
46 | P a g e
SFM COMPILER Equity Analysis & Valuation
Solution :
(a) The formula for the Dividend valuation Model is
D1
Iv = Ke ‐ g
Ke = Cost of Capital
g = Growth rate
D1 = Dividend at the end of year 1
Stage 1 : Explicit Stage
On the basis of the information given, the following projection can be made:
Year EPS (Rs.) DPS (Rs.) PV of DPS @15%
2015 12.00 4.80 4.176
(9.60 x 125%) (3.84 x 125%)
2016 15.00 6.00 4.536
(12.00 x 125%) (4.80 x 125%)
2017 16.50 8.25* 5.429
(15.00 x 110%) (50% of Rs. 16.50)
14.141
*Payout Ratio changed to 50%.
Stage 2 : Horizon
After 2017, the perpetuity value assuming 10% constant annual growth is:
D4 = Rs. 8.25 × 110% = Rs. 9.075
D4 9.075
IV3 = Ke ‐ g = 0.15 ‐ 0.10 = 181.50
181.50
Iv0 = (1.15)3 = 119.43
Total IV = Stage 1 + Stage 2 = 14.141 + 119.43 = 133.57
2016
Question 60 May 2016 – RTP
Following Financial data are available for PQR Ltd. for the year 2008:
(Rs. in lakh)
8% Debentures 125
47 | P a g e
Equity Analysis & Valuation SFM COMPILER
10% Bonds 50
Equity Shares (Rs.10 each) 100
Reserves and Surplus 300
Total Assets 600
Assets Turnover ratio 1:1
Effective interest rate 8%
Effective tax rate 40%
Operating margin 10%
Dividend payout ratio 16.67%
Current market Price of Share Rs.14
Required rate of return of investors 15%
You are required to:
(i) Draw income statement for the year
(ii) Calculate its sustainable growth rate
(iii) Calculate the fair price of the Company's share using dividend discount model, and
(iv) What is your opinion on investment in the company's share at current price?
Solution :
(i) Income Statement
(Rs. in lakh)
Sale (600 1.1) 660
Operating Expense 594
EBIT (10%) 66
Interest (125 + 50) 8% 14
EBT 52
Tax @ 40% 20.80
EAT 31.20
Dividend @ 16.67% 5.20
Retained Earnings 26.00
(ii) G = br
ROE = and NW = Rs.100 lakhs + Rs.300 lakhs
= 400Lakhs
.
ROE = × 100 = 7.8%
Retention Ratio = 100 – 16.67 = 83.33
G = 83.33 7.8% = 6.5%
(iii) Calculation of fair price of share using dividend discount model
P =
48 | P a g e
SFM COMPILER Equity Analysis & Valuation
.
Dividends = = Rs.0.52
Growth Rate = 6.5%
. . . . .
Hence P = = = Rs.6.51
. . .
(iv) Since the current market price of share is Rs.14, the share is overvalued. Hence the investor
should not invest in the company.
Solution :
.
No. of shares = = 30 crore
.
EPS =
.
.
EPS = = Rs.10.00
49 | P a g e
Equity Analysis & Valuation SFM COMPILER
XYZ Ltd. paid a dividend of 2 for the current year. The dividend is expected to grow at 40% for the
next 5 years and at 15% per annum thereafter. The return on 182 days T‐bills is 11% per annum and
the market return is expected to be around 18% with a variance of 24%.
The co‐variance of XYZ's return with that of the market is 30%. You are required to calculate the
required rate of return and intrinsic value of the stock.
Solution :
β =
%
β = = 1.25
%
Expected return = R + β(R R)
= 11% + 1.25(18% ‐ 11%)
= 11% + 8.75%
= 19.75%
Intrinsic Value
Year Dividend (Rs.) Present Value (Rs.)
1 2.80 2.34
2 3.92 2.73
3 5.49 3.19
4 7.68 3.73
5 10.76 4.37
16.36
. .
IV5 = = Rs.260.51
. .
260.51
IV0 = = 105.79
1.19755
Intrinsic Value = Rs.16.36 + Rs.105.79
= Rs.122.15
50 | P a g e
SFM COMPILER Equity Analysis & Valuation
Solution :
Cost of Equity as per CAPM
= R + β(R R)
P = or
. .
= = = Rs.31.82
. . .
P0 Price of share (Revised)
. .
= = = Rs.67.50
. . .
51 | P a g e
Equity Analysis & Valuation SFM COMPILER
Solution :
1) Value of firm before strategy
PAT(FCFE) 14000
Vf = = = 93,333.33
Re 0.15
2) Value of firm after strategy
A) Stage 1
Year 1 2 3 4
FCFE 16800 20160 26208 34070.4
PAT (14000 + 20%) (20160 + 30%)
‐ NI 24000 28800 51840 67392
(120000 1.2) (120000 1.2 (51840 1.3)
1.2 1.3 –
172800)
FCFE (7200) (8640) (25632) (33,321.6)
PV @ 15% (6260.87) (6533.08) (16853.46) (19051.73)
Total = (48,699.14)
B) Stage 2
FCFE 5 (PAT) 34070.4
Vf4 = = = 227136
Re 0.15
227136
Vf0 = = 129865.75
(1.15) 4
Total= 129865.75 – 48699.14 = 81,166.61
3) Value of strategy
= Value of firm after strategy = 81166.61
= Value of firm before strategy = 93333.33
–12166.72
Note : Since value of strategy is negative it should not be implemented.
52 | P a g e
SFM COMPILER Equity Analysis & Valuation
Solution :
i. Computation of Business Value
(Rs.in lakhs)
. 152
Profit before tax
.
Less: Extraordinary income (14)
Add: Extraordinary losses 5
143
Profit from new product
Sales 70
Less: Material costs 20
Labour cost 16
Fixed costs 10 (46) 24
167.00
Less: Taxes @34% 58.78
Future Maintainable profits after taxes 110.22
Relevant Capitalization Factor 0.12
Value of Business (Rs.110.22/22) 918.50
2017
Question 66 May 2017 – RTP
ABC Co. is considering a new sales strategy that will be valid for the next 4 years. They want to know
the value of the new strategy. Following information relating to the year which has just ended, is
available:
Income Statement Rs.
Sales 20,000
53 | P a g e
Equity Analysis & Valuation SFM COMPILER
Solutions :
1) Value of firm before the strategy
FCFE(PAT) 1400
Vf = = = 9333.33
Re 15%
2) Value of firm after strategy
a) Stage 1
Year 1 2 3 4
FCFE 16800 20160 26208 34070.4
PAT (14000 + 20%) (20160 + 30%)
‐ NI 24000 28800 51840 67392
(120000 20%) (2400 + 20%)
(720) (864) (1036.8) (1244.16)
PV @ 15% (626.09) (653.31) (681.71) (711.35)
Total = (2672.46)
b) Stage 2
FCFE(PAT) 5 2903.04
IV4 = = = 19353.6
Re 0.15
19353.6
IV0 = = 11065.48
1.154
Total IV = 11065.48 – 2672.46 = 8393.02
3) Value of strategy
= Value of firm after strategy = 8393.02
= Value of firm before strategy = 9333.33
–940.31
Note : Since he value of strategy is negative the firm should not go ahead with strategy.
54 | P a g e
SFM COMPILER Equity Analysis & Valuation
Solutions :
Date 1 2 EMA for 3 4 5
Sensex Previous day 1‐2 3 x 0.062 EMA
2+4
6 14522 15000 (478) (29.636) 14970.364
7 14925 14970.364 (45.364) (2.812) 14967.55
10 15222 14967.55 254.45 15.776 14983.32
11 16000 14983.32 1016.68 63.034 15046.354
12 16400 15046.354 1353.646 83.926 15130.28
13 17000 15130.28 1869.72 115.922 15246.202
17 18000 15246.202 2753.798 170.735 15416.937
Conclusion ‐ The market is bullish. The market is likely to remain bullish for short term to medium
term if other factors remain the same. On the basis of this indicator (EMA) the investors/brokers can
take long position.
55 | P a g e
Equity Analysis & Valuation SFM COMPILER
However, due to the decision of the Board of Director to grow inorganically in the recent past beta is
likely to increase to 1.75.
You are required to find out under Capital Asset Pricing Model
(i) The present value of the share
(ii) The likely value of the share after the decision.
Solution :
The value of Cost of Equity with the help of CAPM
K = R + β(R ‐ R )
With the given data the Cost of Equity using CAPM will be:
K = 0.11 + 1.5(0.15 – 0.11)
K = 0.11 + 1.5(0.04)
= 0.17 or 17%
The value of share using the Growth Model:
P =
.
P =
. .
.
P = = Rs.272.50
.
However, if the decision of the Board of Directors is implemented, the beta factor is likely to
increase to 1.75.
Therefore,
K = 0.11 + 1.75(0.15 – 0.11)
K = 0.11 + 1.75(0.04)
= 18%
The value of share using the Growth Model:
P =
.
P =
. .
.
P = = Rs.242.22
.
56 | P a g e
SFM COMPILER Equity Analysis & Valuation
Solution :
Rs.in Lakhs
Net Assets Method
Assets: Land & Buildings 96
Plant & Machinery 100
Investments 10
Stocks 20
Debtors 15
Cash & Bank 5
Total Assets 246
Less: Long Term Debts 30
Net Assets 216
Value per share
, , ,
(i) Number of shares = 10,00,000
(ii) Net Assets Rs.2,16,00,000
. , , ,
= Rs.21.6
, ,
57 | P a g e
Equity Analysis & Valuation SFM COMPILER
Value of business
.
Capitalisation factor = = 224
.
Less : Long Term Debts 30
194
58 | P a g e
SFM COMPILER Equity Analysis & Valuation
Solution :
Impact of Financial Restructuring
i. Benefits of Grape XYZ Ltd.
Rs.in lakhs
(a) Reduction of liabilities payable
Reduction in equity share capital 400
(50 lakh shares x Rs.8 per share)
Reduction in preference share capital 50
(10 lakh shares x Rs.5 per share)
Waiver of outstanding debenture interest 12
Waiver from trade creditors (Rs.300 lakhs x 0.20) 60
522
(b) Revaluation of Assets
Appreciation of Land & Building (350 ‐ 150) 200
Total (A) 722
ii. Amount of Rs.722 lakhs utilized to write off losses, fictitious assets and over‐valued assets.
Rs.in lakhs
59 | P a g e
Equity Analysis & Valuation SFM COMPILER
iii. Balance Sheet of XYZ ltd. as at 31st March 2016 (after re‐construction)
Liabilities Rs.in lakhs Assets Rs.in lakhs
100 lakhs equity shares of Rs.2 200 Land and Buildings 350
each
9% Preference Shares of Rs.5 50 Plant and Machinery 150
each
Capital Reserve 165 Furniture and Fixtures 60
10% Debenture 100 Inventory 60
Loan from Bank 60 Sundry debtors 50
Less: Provision for
Doubtful Debt (5) 45
Trade Creditors 240 Cash at bank 150
(300 ‐ 60) (Balancing figure)*
Total 815 Total 815
Balance Sheet Total
*Opening Balance of Rs.50/‐ Lakhs + Sale proceeds from issue of new equity shares Rs.100/‐ lakhs.
60 | P a g e
SFM COMPILER Equity Analysis & Valuation
b) Book Value
c) Net Realizable Value
Solution :
(i) Rs.50 crore x 9 = Rs.450 crore
.
(ii) Rs.50 crore x = Rs.666.70
.
= 0.060.80
(iii) (a) Ke = 6% + 1.2 (11% ‐ 6%) = 12%
.
Value of firm = = Rs.520 crore
. .
(b) Rs.225 crore
(c) Rs.225 crore + Rs.100 crore – Rs.25 crore = 300 crore
Solution :
(i) Pre‐tax Income required on investment of Rs.30,00,000 is Rs.1,80,000.
Let the period of Investment be ‘P’ and return required on investment Rs.1,80,000
(Rs.30,00,000 x 6%)
Accordingly,
(Rs.30,00,000 x x ) – Rs.45,000 = Rs.1,80,000 10010 12P
P = 9 months
2018
Question 73 May 2018 – RTP
SAM Ltd. has just paid a dividend of Rs.2 per share and it is expected to grow @ 6% p.a. After paying
dividend, the Board declared to take up a project by retaining the next three annual dividends. It is
expected that this project is of same risk as the existing projects. The results of this project will start
coming from the 4th year onward from now. The dividends will then be Rs.2.50 per share and will
grow @ 7% p.a.
61 | P a g e
Equity Analysis & Valuation SFM COMPILER
An investor has 1,000 shares in SAM Ltd. and wants a receipt of at least Rs.2,000 p.a. from this
investment.
Show that the market value of the share is affected by the decision of the Board. Also show as to how
the investor can maintain his target receipt from the investment for first 3 years and improved
income thereafter, given that the cost of capital of the firm is 8%.
Solution :
Value of share at present =
.
= = Rs.106
. .
However, if the Board implement its decision, no dividend would be payable for 3 years and the
dividend for year 4 would be Rs.2.50 and growing at 7% p.a. The price of the share, in this case, now
would be:
.
P = × = Rs.198.46
. . .
So, the price of the share is expected to increase from Rs.106 to Rs.198.45 after the announcement
of the project. The investor can take up this situation as follows:
Expected market price after 3 years . Rs.250.00
=
. .
In order to maintain his receipt at Rs.2,000 for first 3 year, he would sell
10 shares in 1st year @ Rs.214.33 for Rs.2,143.30
st
9 shares in 1 year @ Rs.231.48 for Rs.2,083.32
st
8 shares in 1 year @ Rs.250 for Rs.2,000.00
At the end of 3rd year, he would be having 973 shares valued @ Rs.250 each i.e. Rs.2,43,250. On
these 973 shares, his dividend income for year 4 would be @ Rs.2.50 i.e. Rs.2,432.50.
So, if the project is taken up by the company, the investor would be able to maintain his receipt of at
least Rs. 2,000 for first three years and would be getting increased income thereafter.
62 | P a g e
SFM COMPILER Equity Analysis & Valuation
1 8
2 10
3 15
4 22
5 30
6 26
7 23
8 20
Additional Information:
(a) Its variable expenses is 40% of sales revenue and fixed operating expenses (cash) are
estimated to be as follows:
Period Amount ($ Million)
1 – 4 Years 1.6
5 – 8 Years 2
(b) An additional advertisement and sales promotion campaign shall be launched requiring
expenditure as per following details:
Period Amount ($ Million)
1 Year 0.50
2 – 3 Years 1.50
4 – 6 Years 3.00
7 – 8 Years 1.00
(c) Fixed assets are subject to depreciation at 15% as per WDV method.
(d) The company has planned additional capital expenditures (in the beginning of each year) for
the coming 8 years as follows:
Period Amount ($ Million)
1 0.50
2 0.80
3 2.00
4 2.50
5 3.50
6 2.50
7 1.50
8 1.00
(e) Investment in Working Capital is estimated to be 20% of Revenue.
63 | P a g e
Equity Analysis & Valuation SFM COMPILER
Solution :
1) Working note for depreciation
Year 1 2 3 4 5 6 7 8
Assets Op. 17 14.875 13.15375 12.881 13.074 14.088 14.1 13.26
+ Cap.sp. 0.5 0.6 2 2.5 3.5 2.5 1.5 1
Assets 17.5 15.475 15.15375 15.381 16.57 16.588 15.6 14.26
‐ Dep. 2.625 2.32125 2.273 2.3071 2.486 2.488 2.34 2.139
Assets Clo. 14.875 13.15375 12.881 13.074 14.088 14.1 13.26 12.121
2) Kc = 16%
Kd = i(1 – t)
= 12(1 – 0.3)
= 8.4%
12 8
WACC = 20 16% + 20 8.4%
= 12.96%
64 | P a g e
SFM COMPILER Equity Analysis & Valuation
5) FCFF
Year 1 2 3 4 5 6 7 8
(NOPAT – 0.5775 0.13225 (0.189) (0.1879) 0.345 0.466 2.162 1.9417
NI)
PV @ 0.511 0.1036 (0.131) (0.115) 0.188 0.224 0.921 0.732
12.96%
FCFF9
6) V8 = Kc ‐ g
1.9417(1.05)
=
0.1296 0.05
= 25.612
25.612
V0 (Stage 2) = = 9.66
1.12968
7) Value of firm = Stage II + Stage II
= 2.4336
= 2.4336 + 9.66
= 12.09
Value of equity = Value of Firm – Value of Debt
= 12.09 – 8
= 4.09
Solution :
EVA = NOPATA – WACC x Capital Employed.
Capital Employed Rs.lacs
Property, etc. 50
Working Capital 25
Patent Value 50
65 | P a g e
Equity Analysis & Valuation SFM COMPILER
Solution :
FCFF1
Value of the Company = ,
Kc g
200
5000 =
Kc 0.05
Kc = 9%
We do not know the weights the analyst had taken for arriving at the cost of capital. Let w be the
proportion of equity. Then, (1‐w) will be the proportion of debt.
Kc = 9 = w x 12 + (1‐w) x 6
9 = 6 + 6w
6w =3
Hence w = 3/ 6 = 0.5 = 50 % or 1:1
The weights are equal i.e. 1:1 for equity and debt.
The correct weights should be market value of equity : market value of debts.
i.e. 4 times book value of equity : book value of debts. i.e. 4:1 equity : debt
Revised Kc = 4/5 x 12 + 1/5 x 6= 10.8 %
Revised value of the company = = 200 / 5.8% = 3448.28 lacs.
.
66 | P a g e
SFM COMPILER Equity Analysis & Valuation
The risk free rate of return is 5 percent. The expected rate of return on the market portfolio is 11
percent. The expected rate of growth in dividend of X Ltd. is 8 percent. The last dividend paid was
Rs.2.00 per share. The beta of X Ltd. equity stock is 1.5
(i) What is the present price of the equity stock of X Ltd.?
(ii) How would the price change when
• The inflation premium increases by 3 percent?
• The expected growth rate decreases by 3 percent?
• The beta decreases to 1.3?
Solution :
(i) Present Price of Stock
Re = Rf + β(Rm ‐ Rf)
= 5 + 1.5(11 ‐ 5)
= 5 + 9= 14%
D1 . .
IV = Re ‐ g = = Rs.36/share
. .
Solution :
(i) Calculation of theoretical Post‐rights (ex‐right) price per share:
Ex‐Right Value =
Where,
M = Market price,
N = Number of old shares for a right share
67 | P a g e
Equity Analysis & Valuation SFM COMPILER
S = Subscription price
R = Right share offer
= = Rs.22.40
(ii) Calculation of theoretical value of the rights alone:
= Ex‐right price – Cost of rights share
= Rs.22.40 – Rs.16
= Rs.6.40
(iii) Calculation of effect of the rights issue on the wealth of a shareholder who has 1,000 shares
assuming he sells the entire rights:
Rs.
(a) Value of shares before right issue 24,000
(1,000 shares × Rs.24)
(b) Value of shares after right issue 22,400
(1,000 shares × Rs.22.40) 1,600
Add: Sale proceeds of rights renunciation
(250 shares × Rs.6.40)
24,000
There is no change in the wealth of the shareholder even if he sells his right.
(iv) Calculation of effect if the shareholder does not take any action and ignores the issue:
Rs.
Value of shares before right issue 24,000
(1,000 shares × Rs.24)
Value of shares after right issue 22,400
(1,000 shares × Rs.22.40)
68 | P a g e
SFM COMPILER Equity Analysis & Valuation
Solution :
(i) Expected dividend for next 3 years.
Year 1 (D1) Rs.14.00 (1.09) = Rs.15.26
Year 2 (D2) Rs.14.00 1.09 = Rs.16.63
Year 3 (D3) Rs.14.00 1.09 = Rs.18.13
Required rate of return = 13% (Ke)
Market price of share after 3 years = (P3) = Rs.360
The present value of share
= + + +
. . .
= + + +
. . . .
= 15.26(0.885) + 16.63(0.783) +18.13(0.693) + 360(0.693)
= 13.50 + 13.02 + 12.56 + 249.48
= Rs.288.56
(ii) If growth rate 9% is achieved for indefinite period, then maximum price of share should Mr.
A willing be to pay is
. . . .
= = = = Rs.381.50
. . .
(iii) Assuming that conditions mentioned above remain same, the price expected after 3 years will
be:
. . . .
= = = = = Rs.494
. . . .
69 | P a g e
Equity Analysis & Valuation SFM COMPILER
.
H. EPS = = = Rs.203.80
.
Solution :
1. PE using Gordon growth
.
IV = = = 8.5
. .
.
PE = = = 3.4 times
.
2. Current PE = 7 times
MPS = 2.5 x 7 = 17.5
Assuming market is at equilibrium
17.5 =
.
2.45 – 17.5g = 1 + 1g
1.45 = 18.5g
g = 7.84%
Solution :
1. No. of shares to be issued = = 18750
2. Priced at Rs.24
3. Ex Right Price =
, , , ,
= = Rs.33.6
,
70 | P a g e
SFM COMPILER Equity Analysis & Valuation
Solution :
(i) Number of shares to be issued: 5,00,000
20,00,000
Subscription price =4
5,00,000
1,30,00,000 20,00,000
Sh. Price after right = = 10
15,00,000
Or = Rs.10 – Rs.4 = Rs.6
20,00,000
(ii) Subscription price = Rs.8
2,50,000
1,30,00,000 20,00,000
Ex‐right Price = Rs.12
12,50,000
Or = Rs.12 – Rs.8 = Rs.4
(iii) The effect of right issue on wealth of Shareholder’s wealth who is holding, say 100 shares.
(a) When firm offers one share for two shares held.
Value of Shares after right issue (150 × Rs.10) Rs.1,500
Less: Amount paid to acquire right shares (50 × Rs.4) Rs.200
Rs.1,300
(b) When firm offers one share for every four shares held.
Value of Shares after right issue (125 × Rs.20) Rs.1,500
Less: Amount paid to acquire right shares (25 × Rs.8) Rs.200
Rs.1,300
(c) Wealth of Shareholders before Right Issue Rs.1,300
Thus, there will be no change in the wealth of shareholders from (i) and (ii).
71 | P a g e
Equity Analysis & Valuation SFM COMPILER
Solution :
(i) Firm’s Expected or Required Return on Equity
D1
Iv =
Re g
1.12
20 =
Re 0.12
Re = 17.6%
(ii) Firm’s Expected or Required Return on Equity
(If dividends were expected to grow at a rate of 20% per annum for 5 years and 10% per
year thereafter)
Year Div PV @18%
1 1.2 1.017
2 1.44 1.034
3 1.728 1.052
4 2.0736 1.07
5 2.488 1.08
5.261
2.488(1.2)
IV5 = = 37.32
0.18 0.10
37.32
IV0 = = 16.31
1.185
Total = 5.261 + 16.31
= 21.57720
Since the PV is 720. Lets increase the Re to 20%
72 | P a g e
SFM COMPILER Equity Analysis & Valuation
2.488(1.2)
IV5 = = 29.856
0.20 0.10
29.856
IV0 = = 12
1.25
Total = 17 < 20
Solution :
(i) Computation of Business Value
Rs.in lakhs
Profit before tax (77/1‐0.30) 110
Less: Extraordinary income (8)
Add: Extraordinary losses (10)
73 | P a g e
Equity Analysis & Valuation SFM COMPILER
112
Profit from new product Rs.in lakhs
Sales 70
Less: Material costs 20
Labour costs 12
Fixed costs 10 (42) 28
140.00
Less: Taxed @ 30% 42.00
Future Maintainable Profits after taxes 98.00
Relevant Capitalisation Factor 0.14
Value of Business (Rs.98/0.14) 700
Solution :
Dividend = 10 x 50% = Rs.5 / share
MPS = EPS x PE = 10 x 8 = Rs.80 / share
1. Assuming market at Equilibrium MPS = IV
Intrinsic Value IV =
.
80 =
.
80 Re – 12 = 5.75
74 | P a g e
SFM COMPILER Equity Analysis & Valuation
Therefore Re = 22.1875%
2. Market Price with same cost of capital and Growth rate of 16%
.
IV = = = Rs.93.74 / share
. .
3. Market price of cost of capital is 20% and Growth is 18%.
.
IV = = = Rs.295 / share
. .
Solution :
1. Value of firm before strategy
VF = = = = Rs.28,000
%
2. Value of firm after strategy
Stage 1
Year 1 2 3 4 5
PAT 5460 7098 9227.4 11995.62 11995.62
75 | P a g e
Equity Analysis & Valuation SFM COMPILER
Stage 2
.
VF4 = = = 79,970.8
.
.
VF0 = = 45,723.56
.
Total IV = 4,051.17 + 45,723.56 = 49,774.73
3. Value of Strategy = 49,774.73 – 28,000
= 21,774.74
Note: Since the value of strategy is positive we should implement the strategy.
2019
Question 89 : May 2019 (New) – RTP
Based on the credit rating of bonds, Mr. Z has decided to apply the following discount rates for valuing
bonds:
Credit Rating Discount Rate
AAA 364 day T bill rate + 3% spread
AA AAA + 2% spread
A AAA + 3% spread
He is considering to invest in AA rated, Rs.1,000 face value bond currently selling at Rs.1,025.86. The
bond has five years to maturity and the coupon rate on the bond is 15% p.a. payable annually. The
next interest payment is due one year from today and the bond is redeemable at par. (Assume the
364 day T‐bill rate to be 9%).
You are required to calculate the intrinsic value of the bond for Mr. Z. Should he invests in the bond?
Also calculate the current yield and the Yield to Maturity (YTM) of the bond.
Solution :
The appropriate discount rate for valuing the bond for Mr. Z is:
R = 9% + 3% + 2% = 14%
Time CF PVIF 14% PV (CF) PV (CF)
1 150 0.877 131.55
2 150 0.769 115.35
3 150 0.675 101.25
4 150 0.592 88.80
5 1150 0.519 596.85
PV (CF) i.e. P0 = 1033.80
76 | P a g e
SFM COMPILER Equity Analysis & Valuation
Since, the current market value is less than the intrinsic value; Mr. Z should buy the bond. Current
yield = Annual Interest / Price = 150 / 1025.86 = 14.62%
The YTM of the bond is calculated as follows:
@15%
P = 150 × PVIFA 15%, 4 + 1150 × PVIF 15%, 5
= 150 × 2.855 + 1150 × 0.497 = 428.25 + 571.55 = 999.80
@14%
As found in sub part (a) P0 = 1033.80
By interpolation we get,
7.94 7.94
= 14% + × (15% – 14%) = 14% + %
7.94 (26.06) 34
YTM = 14.23%
Question 90 : May 2019 (New) – RTP
Seawell Corporation, a manufacturer of do‐it‐yourself hardware and housewares, reported earnings
per share of € 2.10 in 2013, on which it paid dividends per share of €0.69. Earnings are expected to
grow 15% a year from 2004 to 2008, during this period the dividend payout ratio is expected to
remain unchanged. After 2018, the earnings growth rate is expected to drop to a stable rate of 6%,
and the payout ratio is expected to increase to 65% of earnings. The firm has a beta of 1.40 currently,
and is expected to have a beta of 1.10 after 2018. The market risk premium is 5.5%. The Treasury
bond rate is 6.25%.
(a) What is the expected price of the stock at the end of 2018?
(b) What is the value of the stock, using the two‐stage dividend discount model?
Solution :
1) Stage 1
Re = Rf + (Rm – Rf)
= 6.25 + 1.14(5.5) = 13.95%
Stage 2
= 6.25 + 1.1(5.5) = 12.3
2) Stage 1
Year EPS DPS @32.857% PV @13.95%
14 2.415 0.7935 0.696
15 2.777 0.9125 0.703
16 3.194 1.049 0.709
17 3.673 1.207 0.716
18 4.224 1.388 0.722
3.546
3) Stage 2
4.224 1.06 0.65
Vf18 = = 49.196
0.123 0.06
77 | P a g e
Equity Analysis & Valuation SFM COMPILER
46.196
Vf13 = = 24.045
1.13955
4) Total IV = 24.045 + 3.546
= 27.59
Solution :
FCFF1
1) Vf =
Kc g
54
1800 =
Kc 0.09
Kc = 12%
2) Let the wt for debt be x
Equity =1–x
10x + 20(1 – x) = 12
10x + 20 – 20x = 12
x = 0.8
1–x = 0.2
3) The above were book value with the market value wts shall be
Debt 0.8 0.9 = 0.72
Equity 0.2 3 = 0.6
1 1.32
4) Kc based on market value wts
0.6 0.72
= 20 + 10 = 14.545%
1.32 1.32
FCFF1 54
5) Vf = = = Rs.973.85
Kc g 0.14545 - 0.09
78 | P a g e
SFM COMPILER Equity Analysis & Valuation
(i) The earnings and dividend will grow at 25% for the next two years.
(ii) Earnings are likely to grow at the rate of 10% from 3rd year and onwards.
(iii) Further, if there is reduction in earnings growth, dividend payout ratio will increase to 50%.
The other data related to the company are as follows:
Year EPS (Rs.) Net Dividend per share (Rs.) Share Price (Rs.)
2010 6.30 2.52 63.00
2011 7.00 2.80 46.00
2012 7.70 3.08 63.75
2013 8.40 3.36 68.75
2014 9.60 3.84 93.00
You may assume that the tax rate is 30% (not expected to change in future) and post tax cost of
capital is 15%.
By using the Dividend Valuation Model, calculate
(i) Expected Market Price per share
(ii) P/E Ratio.
Solution :
1) Stage 1
Year EPS DPS PV @15%
1 12 4.8 4.174
2 15 6 4.537
8.711
2) Stage 2
15 1.1 0.5
IV3 = = 165
0.15 - 0.1
165
IV0 = = 124.764
1.152
3) Total IV = 8.711 + 124.764 = 133.475
MPS 133 - 475
4) PE Rate = = = 13.9 times
EPS 9. 6
79 | P a g e
Equity Analysis & Valuation SFM COMPILER
Balance Sheet
Particulars Rs. In Lakhs
Equity and Liabilities :
(a) Shareholders' Fund ‐
Equity Share Capital 1,000
Reserves & Surplus 600
(b) Non ‐ Current Liabilities ‐
Long Term Borrowings 200
(c) Current Liabilities 800
Total 2,600
Assets :
(a) Non ‐ Current Assets 2,000
(b) Current Assets 600
Total 2,600
Other Information :
(1) Cost of Debts is 15%.
(2) Cost of Equity (i.e. shareholders’ expected return) is 12%
(3) Tax Rate is 30%
(4) Bad Debts Provision of Rs.40 lakhs is included in indirect expenses and Rs.40 lakhs reduced
from receivables in current assets.
Solution :
EVA = NOPAT – Kc
1) NOPAT 2) Kc (%)
EBIT 800 Ke = 12%
+ RDD 40 Kd = 15%
Adjusted EBIT 840 Kc = w + Ke + w + Kd
1640 200
– Tax (30%) ___ = 12 + 15
1840 1840
NOPAT 588 = 12.33%
3) Kc(Amt)
= 1840 12.33% = 226.87
EVA = 588 – 226.87 = 361.128
80 | P a g e
SFM COMPILER Equity Analysis & Valuation
The shares of G Ltd. Are currently being traded at Rs.46. The company published its results for the
year ended 31st March 2019 and declared a dividend of Rs.5. The company made a return of 15% on
its capital and expects that to be the norm in which it operates. G Ltd. Also expects the dividends to
grow at 10% for the first three years and thereafter at 5%.
You are required to advise whether the share of the company is being traded at premium or discount.
PVIF @ 15% for the next 3 years is 0.870, 0.756 and 0.658 respectively.
Solution :
1) Stage 1
Year Div PV @15%
1 5.5 4.78
2 6.05 4.57
3 6.655 4.38
13.73
2) Stage 2
D4 6.655(1.05 )
IV3 = = = 69.8775
Re g 0.15 0.05
69.8775
IV0 = = 45.95
1.153
Total IV = 45.95 + 13.73 = 59.68
Advise : Since MP = 46, the stock is under priced and investor should go lay.
Solution :
(i) Let P be the buyback price decided by ABB Ltd.
Market Capitalisation after Buyback
400 lakhs = 1.15P (Original Shares – Shares Bought Back)
81 | P a g e
Equity Analysis & Valuation SFM COMPILER
Solution :
1) Income statements
Sales (1200 2) 2400
– Operating cost 2160
Operating margin (10%) 240
– Interest 35
82 | P a g e
SFM COMPILER Equity Analysis & Valuation
EBT 205
– Tax (30%) 61.5
EAT 143.5
– Dividend (143.5 20%) 28.7
Retained earnings 114.8
2) G = br
b = Retention Ratio = 100 – Payout = 80%
PAT 143.5
r = roe = = = 17.9375
Equation 800
G = 80 17.9375% = 14.35%
D1 28.7
3) IV = D1 = 1.1435 = 1.6409
Re g 20
1.6409
IV = = Rs.44.96/sh.
0.18 - 0.1435
4) Opinion = MP = 28, the stock is underpriced the investor should go long.
Solution :
A) A = L
A = 1.45 74% + 1.2 26% = 1.385
L = 1.385
L = w + E + w + D
170 410
1.385 = 0.24 + E
580 580
1.314655 = 0.70689655 E
E = 1.860
B) E = ? New Debt : Equity = 1.90, D = 0.35 New D = 0.40
Existing capital = 580
83 | P a g e
Equity Analysis & Valuation SFM COMPILER
The company has 500,000 equity shares of Rs.10 each and 100,000 9% Preference Shares of Rs.100
each. The price Earnings Ratio is 6 times. Post tax cost of capital is 10 per cent per annum. Tax rate is
34 per cent.
You are required to determine :
(i) Existing Profit from old operations
(ii) The value of business
Solution :
24
A) Existing profits for equity = = 4 500000
6
= 20,00,000
+ Preference div. 9,00,000
PAT 29,00,000 66%
+ Tax _________ 34%
84 | P a g e
SFM COMPILER Equity Analysis & Valuation
PBT 43,93,939
–Ext. Income 24,00,000
+ Ext. Loss 9,00,000
28,93,939
B) New Business
Sales 150
– MC 40
– LC 34
– 24
52
C) Total = 30,93,939
– Tax __ 34%
53,42,000
5342000
D) Value of Business = = 5,34,20,000
0. 1
Solution :
(i) Stage 1
Year Div. PV @18%
1 6 5.085
2 7.08 5.085
3 8.3544 5.085
4 9.858 5.085
20.34
Stage 2
D5 9.858(1.14)
IV4 = = = 280.953
Re - g 0.18 0.14
280 .953
IV0 = = 144.91
1.18 4
Total IV = 144.91 + 20.34 = 165.25
(ii) The CMP = 150, share is underpriced in market and therefore we should Buy.
85 | P a g e
Equity Analysis & Valuation SFM COMPILER
A hypothetical company ABC Ltd. issued a 10% Debenture (Face Value of Rs.1000) of the duration of
10 years is currently trading at Rs.850 per debentnure. The bond is convertible into 50 equity shares
being currently quoted at Rs.17 per share.
If yield on equivalent comparable bond is 11.80%, then calculate the spread of yield of the above
bond from this comparable bond.
The relevant present value table is as follows.
Present Values t1 t2 t3 t4 t5 t6 t7 t8 t9 t10
PVIF0.11, t 0.901 0.812 0.731 0.659 0.593 0.535 0.482 0.434 0.391 0.352
PVIF0.13, t 0.885 0.783 0.693 0.613 0.543 0.480 0.425 0.376 0.333 0.295
Solution :
Conversion Price = Rs.50 x 17 = rs.850
Intrinsic Value = Rs.850
Accordingly the yield (r) on the bond shall be:
Rs.850 = Rs.100 PVAF (r, 10) + Rs.1000 PVF (r, 10)
Let us discount the cash flows by 11%
850 = 100 PVAF (11%, 10) + 1000 PVF (11%, 10)
850 = 100 x 5.890 + 1000 x 0.352
= 91
Now let us discount the cash flows by 13%
850 = 100 PVAF (13%, 10) + 1000 PVF (13%, 10)
850 = 100 x 5.426 + 1000 x 0.295
= –12.40
Accordingly, IRR
90.90
11% + × (13% –11%)
90.90 (12.40)
90.90
11% + ×( 13% –11%)
103.30
= 12.76%
The spread from comparable bond = 12.76% – 11.80% = 0.96%
Solution :
86 | P a g e
SFM COMPILER Equity Analysis & Valuation
Solution :
Cost of capital by applying Free Cash Flow to Firm (FCFF) Model is as follows:‐
FCFF1
Value of Firm = V0 =
Kc gn
Where –
FCFF1 = Expected FCFF in the year 1
Kc = Cost of capital
gn = Growth rate forever
Thus, Rs.500 lakhs = Rs.20 lakhs /(Kc – g)
Since g = 5%, then Kc = 9%
Now, let X be the weight of debt and given cost of equity = 12% and cost of debt = 6%, then 12%
(1 – X) + 6% X = 9%
87 | P a g e
Equity Analysis & Valuation SFM COMPILER
88 | P a g e
SFM COMPILER Equity Analysis & Valuation
to decline to 8 Times and rise in the cost of additional debt to 14%. Given this data which of the
following options the company would prefer, and why?
Option (i) : If the required amount is raised through debt, and
Option (ii) : If the required amount is raised through equity and the new shares will be issued at a
price of Rs.25 each.
89 | P a g e
Equity Analysis & Valuation SFM COMPILER
You are require to calculate the intrinsic value of the company’s stock based on expected dividend.
If the current market price of the stock is Rs.125, suggest if it is advisable for the investor to invest in
the company’s stock or not.
2020
Question 109 : May 2020 (New) – RTP
Calculate the value of share from the following information:
Profit after tax of the company Rs.290 crores
Equity capital of company Rs.1,300 crores
Par value of share Rs.40 each
Debt ratio of company (Debt/ Debt + Equity) 27%
Long run growth rate of the company 8%
Beta 0.1; risk free interest rate 8.7%
Market returns 10.3%
Capital expenditure per share Rs.47
Depreciation per share Rs.39
Change in Working capital Rs.3.45 per share
Solution :
90 | P a g e
SFM COMPILER Equity Analysis & Valuation
Rs.1,300crores
No. of Shares = = 32.5 Crores
Rs.40
PAT
EPS =
No. of shares
Rs.290 crores
EPS = = Rs.8.923
32.5 crores
FCFE = Net income – [(1 – b) (capex – dep) + (1 – b) (WC)]
FCFE = 8.923 – [(1 – 0.27) (47 – 39) + (1 – 0.27) (3.45)]
= 8.923 – [5.84 + 2.5185] = 0.5645
Cost of Equity = Rf + (Rm – Rf)
= 8.7 + 0.1 (10.3 – 8.7) = 8.86%
FCFE(1 g) 0.5645(1.08) 0.60966
P0 = = = Rs.70.89
Ke g 0.0886 .08 0.0086
Solution :
Projected Balance Sheet
Year 1 Year 2 Year 3 Year 4
Fixed Assets (40% of Sales) 9,600 11,520 13,824 13,824
Current Assets (20% of Sales) 4,800 5,760 6,912 6,912
Total Assets 14,400 17,280 20,736 20,736
91 | P a g e
Equity Analysis & Valuation SFM COMPILER
92 | P a g e
SFM COMPILER Equity Analysis & Valuation
You may assume that the tax rate is 30% (not expected to change in future) and post‐tax cost of
capital is 15%.
By using the Dividend Valuation Model, calculate
(a) Expected Market Price per share
(b) P/E Ratio.
Solution :
D1
(a) The formula for the Dividend valuation Model is P0 =
Ke g
Ke = Cost of Capital
g = Growth rate
D1 = Dividend at the end of year 1
On the basis of the information given, the following projection can be made:
Year EPS (Rs.) DPS (`) PVF @15% PV of DPS (Rs.)
2015 12.00 (9.60 x 125%) 4.80(3.84 x 125%) 0.870 4.176
2016 15.00(12.00 x 125%) 6.00(4.80 x 125%) 0.756 4.536
2017 16.50(15.00 x 110%) 8.25*(50% of Rs.16.50) 0.658 5.429
14.141
*Payout Ratio changed to 50%.
After 2017, the perpetuity value assuming 10% constant annual growth is :
D1 = Rs.8.25 × 110% = Rs.9.075
Therefore Po from the end of 2017
This must be discounted back to the present value, using the 3 year discount factor after 15%.
Rs.
Present Value of P0 (` 181.50 × 0.658) 119.43
Add: PV of Dividends 2015 to 2017 14.14
Expected Market Price of Share 133.57
(b) P/E Ratio
Expected Market Price of Shares (P1 )
P/E Ratio =
EPS
Rs.133.57
= = Rs.13.91
Rs.9.60
93 | P a g e