MERGERS and Acquisitions
MERGERS and Acquisitions
1. The following information is relating to Fortune India Ltd. having two divisions, viz.
Pharma Division and Fast Moving consumer goods division (FMCG Division). Paid up
share capital of Fortune India Ltd. is consisting of 3,000 lakhs equity shares of Re. 1 each.
Fortune India Ltd. decided to demerge Pharma Division as Fortune Pharma Ltd w.e.f.
1.4.2005. Details of Fortune India Ltd as on 31.3.2005 and of Fortune Pharma Ltd as on
1.4.2005 are given below:
Fortune Pharma Ltd Fortune India Ltd.
(` Lakhs) (` Lakhs)
Outside Liabilities
Secured Loans 400 3000
Unsecured Loans 2,400 800
CL & Provisions 1,300 21,200
Assets
FA 7,740 20,400
Investments 7,600 12,300
CA 8,800 30,200
Loans and Advances 900 7,300
Deferred tax / Misc. Exps. 60 (200)
Board of directors of the company have decided to issue necessary equity shares of
Fortune Pharma Ltd of ` 1 each, without any consideration to the shareholders of Fortune
India Ltd for that purpose following points are to be considered:
1. Transfer of Liabilities & Assets at Book value.
2. Estimated Profit for the year 2005-06 is ` 11,400 lakh for Fortune India Ltd. &`
1,470 lakhs for Fortune Pharma Ltd.
3. Estimated Market price of Fortune Pharma Ltd is ` 24.50 per share.
4. Average P/E Ratio of FMCG sector is 42 & Pharma sector is 25, which is to be
expected for both the companies.
Calculate:
i. The Ratio in which shares of Fortune Pharma are to be issued to the shareholders
of Fortune India Ltd.
ii. Expected Market Price of Fortune India Ltd.
iii. Book Value per share of both the companies immediately after Demerger.
Sol. (i) Given,
*Fortune Pharma
PAT = ` 1,470 L
P/E = 25 times
MPS = ` 24.50
*Fortune India
Nos. = 3,000
PAT = ` 11,400 L
P/E = 42 times
` 24.5
EPS = = ` 0.98
25
` 1, 470
No. of shares = = 1,500
0.98
1,500
ER = = 0.50
3, 000
This means every erstwhile shareholder of combined firm should get one share of pharma
for every 2 shares hold originally.
` 11, 400L
(ii) EPS = = ` 3.80/-
3, 000L
P/E = 42 times (given)
MPS = `3.80 × 42 = `159.60
(iii) Book value of combined firm
= ` 20,400 + ` 12,300 + ` 30,200 + ` 7,300 - ` 200 – ` 3,000 – ` 800 – ` 21,200
= ` 45,000L
` 45,000L
BVPS =
3,000L
= ` 15/-
2. The CEO of Ganga Ltd. is considering the acquisition of Yamuna Ltd. The basic data of
the two companies are given as follows:
Ganga Ltd. Yamuna Ltd.
No. of shares 2,00,000 1,20,000
Share price ` 450 ` 100
Expected EPS ` 25 ` 7.50
Expected Dividend per share ` 15 ` 5.25
The above data assumes 5% p.a. growth in the earnings and dividends. However, under
the new management, the growth will be 7.5% without any further investment. The
exchange ratio of 1 for 3 is being considered. Find the cost of acquisition. What is the
gain from the acquisition?
Sol. Gain from acquisition = VAB – VA – VB
Cost of Acquisition = VABx × α - VB
NB × ER
α =
NA + NB × ER
VAB = VA + new VB
VA = ` 450 × 2L
= ` 900L
Computation of D1
D1 = D0(1 + g)
5.25 = D0(1.05)
D0 = ` 5.0
New D1 = 5(1.075) = ` 5.375
Computation of Ke
We assume that the risk perception of shareholders of Yamuna cannot change and hence
we use the historical ‘Ke’ to compute the new value.
D1
Ke = +g
P0
5.25
Ke = + 0.05 = 10.25%
100
5.375
P0 =
0.1025 - 0.075
= ` 195.45
\ New VB = ` 195.45 × 120.000
= ` 234.54 L
VAB = ` 900 L + ` 234.54 L
= ` 1134.54 L
\ Gain = ` 1134.54 L - ` 450 × 2L – 100 × 1.2 L
Cost = VAB × α – VB
= ` 1134.54 × 16.67 % - ` 100 × 1.2 L
= ` 69.13 L
1
1, 20, 000 ×
α = 3 × 100
1
2, 00, 000 + 1,20,000 ×
3
= 16.67%
3. BA Ltd and DA Ltd both the companies operate in the same industry. The Financial
statements of both the companies for the current financial year are as follows:
Balance Sheet
Particulars BA Ltd. DA Ltd.
Current Assets 14L 10L
Fixed Assets (net) 10L 5L
Total (`) 24L 15L
Equity Capital (` 10 each) 10L 08L
Retained Earnings 2L -
14% Long term debt 5L 3L
Current Liabilities 7L 4L
Total (`) 24L 15L
Income Statement
Net Sales 34.50 L 17.00 L
Cost of goods sold 27.60 L 13.60 L
Gross Profit 6.90 L 3.40 L
Operating Expenses 2.00 L 1.00 L
Interest 0.70 L 0.42 L
EBT 4.20L 1.98L
EAT 2.10L 0.99L
Additional Information
No. of equity shares 1,00,000 80,000
Dividend Pay-out (D/P) 40% 60%
Market Price per Share ` 40 ` 15
Sol. BA Ltd. = A
DA Ltd. = B
PATA 2.10L
(i) EPSA = = = ` 2.10/-
NA 1L
PATB 0.99L
EPSB = = = ` 1.24/-
NB 0.8L
` 40
P/EA = = 19.05 times
` 2.10
` 15
P/EB = = 12.10 times
` 1.24
PATA ` 2.10L
ROEA = = × 100 = 17.50%
BV ` 10L + ` 2L
PATB ` 0.99L
ROEB = = × 100 = 12.38%
B.V ` 8L
Total BV ` 12L
BVPSA = = = ` 12.0/-
No of shares 1
` 8L
BVPSB = = ` 10.0/-
0.8L
(ii) g = b× r
b = Retention Ratio
r = ROE
gA = (1 - 40%) × 17.5% = 10.50%
gB = (1 - 60%) × 12.38% = 4.95%
` 15
(iii) ER on the basis of B intrinsic value of B post- merger = = 0.375
` 40
` 20
ER as per intrinsic values of B post -merger = = 0.50
` 40
® Lower Range = 0.375
Higher Range = 0.50
On the basic of computation in (i) & (ii), We observe that the vital parameters like EPS,
ROE & growth ratio of B are lower in comparison to A, there by brining higher bargaining
power to acquirer and hence, we expect ER towards “Lower Range”.
` 2.10L + ` 0.99L
(iv) Post Merger EPS = = ` 2.34
1L + 0.80L ´ 0.4
Particulars A B
EPS Before ` 2.10 ` 1.24
EPS After ` 2.34 `2.34 × 0.4
= 0.94
Gain `0.24 (`0.30)
(v) Post -Merger MPS = ` 2.34 × 19.05 times = `44.58/-
Particulars A B
Wealth Before ` 40 ` 15
Wealth After ` 44.58 ` 44.58 × 0.4 = ` 17.832
Gain ` 4.58 ` 2.83
4. AS Ltd. is planning to acquire and absorb the running business of XY Ltd. The valuation
is to be based on the recommendation of merchant bankers and the consideration is to be
discharged in, the form of equity shares to be is used by AB Ltd. As on 31.3.2006, the
paid up capital of AS Ltd. consists of 80 Lakhs shares of ` 10 each. The highest and the
lowest market quotation during the last 6 months were ` 570 and ` 430. For the purpose
of the acquisition the price per share is to be reckoned as the average of the highest and
lowest market price during the last 6 months ended on 31.3.06.
XY Ltd.’s Balance Sheet as at 31.3.2006 is summarised below ` Lakhs
Sources 200
Share Capital 50
20 lakhs equity shares of ` 10 each fully paid 100
10 lakhs equity shares of ` 10 each, ` 5 paid
Loans
Total 350
Fixed Assets (Net) 150
5. T Ltd. and E Ltd. are in the same industry. The former is in negotiation for acquisition of
the latter. Important information about the two companies as their latest financial
statement given below:
T Ltd. E Ltd.
`10 Equity shares outstanding Debt 12 lakhs 6 lakhs
10% Debentures (` lakhs) 580 -
12.5% Institution Loan (`lakhs) - 240
Earnings Before interest, Depreciation and Tax-
(EBIDAT) (` lakhs) 400.68 115.71
Market Price/share (`) 220.00 110.00
T Ltd. plans to offer a price to E Ltd. business as a whole which will be 7 times EBIDAT
reduced by outstanding debt, to discharged by own shares at market price.
E Ltd. is planning to seek one share in T Ltd. for every 2shares in E Ltd. Based on the
market price. Tax rate for the two companies may be assumed as 30%.
Calculate and show the following under both alternatives - T Ltd.'s offer and E
Ltd.'s plan:
i. Net consideration payable
ii. No. of shares to be issued by T Ltd.
iii. EPS of T Ltd. after acquisition.
iv. Expected market price per share of T Ltd. after acquisition.
v. State briefly the advantages to T Ltd. from the acquisition
Calculate(except EPS) may be rounded off to 2 decimals in lakhs.
Sol. As per T’s Plan:
(i) Net consideration:
Computation of Gross value = 7 × ` 115.71L
7 × EBIDAT = ` 809. 97 L
(-) O/S Debt (` 240 L)
Net Consideration ` 569.97L
(ii) No. of shares to be issued by T to E
1
(ii) No of shares = NB × ER= 6L × = 3L
2
239.876 + 60
(iii) Post merger EPS = = ` 20 [ ` 239.876 L + ` 60.000 L]
12L + 3L
6. Simple Ltd. and Dimple Ltd. are planning to merge. The total value of the companies are
dependent on the fluctuating business conditions. The following information is given for
the total value (debt + equity) structure of each of the two companies.
Business Condition Probability Simple Ltd. Dimple Ltd.
` Lakhs ` Lakhs
High Growth 0.20 820 1050
Medium Growth 0.60 550 825
Slow Growth 0.20 410 590
The current debt of Dimple Ltd. is ` 65 lacs and of Simple Ltd. is ` 460 lacs.
Calculate the expected value of debt and equity separately for the merged entity.
7. There are two companies ABC Ltd. and XYZ Ltd. are in same in industry. On order to
increase its size ABC Ltd. made a takeover bid for XYZ Ltd.
Equity beta of ABC and XYZ is 1.2 and 1.05 respectively. Risk Free Rate of Return is
10% and Market Rate of Return is 16%. The growth rate of earnings after tax of ABC
Ltd. in recent years has been 15% and XYZ's is 12%. Further both companies had
continuously followed constant dividend policy.
Sol.
(i) Value of XYZ on the basis of Net worth & Earnings:
Land & Building = 1,500 (1.25)4
= ` 3,662.11L
(+) P & M = 2,800
(+) Current Assets = 4,900
(-) Long term loans = (1,000)
(-) C L = (2,000)
` 8,362.10 L
(ii) gc = 12 %
As per DDM
D1 D (1 + g)
Po = = 0
ke - g ke - g
Total Dividend = ` 760 L
` 760L
D0 = = ` 19
40L
Ke = Rf + (Rm - Rf) B
= 10 + (16 -10) 1.05
= 16.30%
` 19 (1.12 ) 21.28
P0 = = = ` 494.8
0.1630 - 0.12 0.048
` 494.8 - ` 470.0
% Premium = ´ 100 = 5.29%
` 470.0
On the basis of above computation, we observe & conclude that the firm should go by
DDM Model due to two reasons.
(a) It considers time value of money.
(b) The premium is relatively more reasonable than the first method.
` 194.737 Cr
(1 + g)4 =
` 82.5 Cr
1 + g = (2.36)1/4
1 + g = 1.2394
g = 23.94% p.a.
10. Bank 'R' was established in 2005 and doing banking in India. The bank is facing DO OR
DIE Situation. There are problems of Gross NPA (Non Performing Assets) at 40% &
CAR/CRAR (Capital Adequacy Ratio/ Capital Risk Weight Asset Ratio) at 4%. The net
worth of the bank is not good. Shares are not traded regularly. Last week, it was traded
@ ` 8 per share.
RBI Audit suggested that bank has either to liquidate or to merge with other bank.
Bank 'P' is professionally managed bank with low gross NPA of 5%.It has Net NPA as
0% and CAR at 16%. Its share is quoted in the market @ ` 128 per share. The board of
directors of bank 'P' has submitted a proposal to RBI for take over of bank 'R' on the basis
of share exchange ratio.
The Balance Sheet details of both the banks are as follows:
Bank R (`In lakhs) Bank P (`In lakhs)
Paid up share capital 140 500
Reserves & Surplus 70 5,500
Deposits 4,000 40,000
Other liabilities 890 2,500
Total Liabilities 5,100 48,500
Cash in hand & with RBI 400 2,500
Balance with other banks - 2,000
Investments 1,100 15,000
Advances 3,500 27,000
Other Assets 100 2,000
Total Assets 5,100 48,500
in Lakhs in Lakhs
Paid up capital 517.5 Cash in land with RBI 2,900.0
Reserve 5,570.0 Balance with other banks 2,000.0
Capital reserve 122.5 Investment 16,000
Deposit 44,000.0 Advances 30,500.0
Other liabilities 3,390.0 other Assets 2,100.0
53,600.0 53,600.00
(d) Computation of CAR & GNPA % after the Merger
Total capital
(i) CAR =
Risk weighted assets
Gross NPA
(ii) GNPA = × 100
Advances
Particulars Bank p Bank R Total
GNPA 5% 40%
Advances ` 27,000 ` 3,500 ` 30,500
Gross NPA ` 1,350 ` 1,400 ` 2,750
2, 750
\ GNPA of merged firm = = 9.02%
30,500
11. M plc and C plc operating in same industry are not experiencing any rapid growth but
providing a steady stream of earnings. M plc’s management is interested in acquisition
of C plc due to its excess plant capacity. Share of C plc is trading in market at £4 each.
Other date relating to C plc is as follows:
Particulars M plc C plc Combined
Entity
Profit after tax £4,800,000 £3,000,000 £9,200,000
Residual Net Cash Flow per year £6,000,000 £4,000,000 £12,000,000
Required return on Equity 12.5% 11.25% 12.00%
12. Hanky Ltd. and Shanky Ltd. operate in the same field, manufacturing newly born babies’s
clothes. Although Shanky Ltd. also has interests in communication equipments, Hanky
Ltd. is planning to take over Shanky Ltd. and the shareholders of Shanky Ltd. do not
regard it as a hostilebid.
The following information is available about the two companies.
Hanky Ltd. Shanky Ltd.
Current earnings `6,50,00,000 ` 2,40,00,000
Number of shares 50,00,000 15,00,000
Percentage of retained earnings 20% 80%
13. Simpson Ltd. is considering a merger with Wilson Ltd. The data below are in the hands
of both Board of Directors. The issue at hand is how many shares of Simpson should be
exchanged for Wilson Ltd. Both boards are considering three possibilities 20,000, 25,000
and 30,000 shares. You are required to construct a table demonstrating the potential
impact of each scheme on each set of shareholders:
Simpson Wilson Combined
Ltd. Ltd. Post -Merger
Firm ‘A’
1. Current earnings per year 2,00,000 1,00,000 3,50,000
2. Share outstanding 50,000 10,000 ?
3. Earnings per share(`) (1÷ 2) 4 10 ?
4. Price per share (`) 40 100 ?
5. Price-Earnings ratio [4÷ 3] 10 10 10
6. Value of firm(`) 20,00,000 10,00,000 35,00,000
7. Expected Annual growth rate in 0 0 0
earnings in foreseeable future
Sol. The following table demonstrates the potential impact of the three possible schemes, on
each set of shareholders:-
Number of Exchange Number of Fraction of Value of Fraction of Value of
Simpson ratio [(1)/ Simpson Ltd. (Post shares Simpson shares
Ltd.'s shares 10,000 Ltd's merger) owned by Ltd. owned by
issued to shares of shares owned by Wilson (combined Simpson
shareholders outstanding Wilson Ltd.s' Post-merger Ltd.'s
14. Yes Ltd. wants to acquire No Ltd. and the cash flows of Yes Ltd. and the merged entity
are given below:
(`lakhs)
Year 1 2 3 4 5
Yes Ltd. 175 200 320 340 350
Merged Entity 400 450 523 590 620
Earnings would have witnessed 5% constant growth rate without merger and 6% with
merger on account of economies of operations after 5 years in each case. The cost of
capital is 15%.
The number of shares outstanding in both the companies before the merger is the same
and the companies agree to an exchange ratio of 0.5 shares of Yes Ltd. for each share of
No Ltd.
PV factor at 15% for years 1-5 are 0.870, 0.756; 0.658, 0.572, 0.497 respectively.
You are required to:
i. Compute the Value of Yes Ltd. before and after merger
ii. Value of Acquisition and
iii. Gain to shareholders of Yes Ltd.
Sol. i. Working Notes:
Present Value of Cash Flows (CF) up to 5 years
Year End CF of Yes PVF @ PV of CF CF of PV of CF of
Ltd. 15% (` lakhs) Merged Merged
(` lakhs) Entity Entity
(` lakhs) (` lakhs)
1 175 0.870 152.25 400 348.00
2 200 0.756 151.20 450 340.20
3 320 0.658 210.56 525 345.45
15. XY Ltd. Has two major operating divisions, furniture manufacturing and real estate,
with revenues of ` 2,600 crore and ` 6,200 crore respectively. Following financial
information is available.
Balance Sheet as on 31-3-2015
Liabilities Amount Assets Amount
(`Crore) (`Crore)
Ordinary shares (` 10 per share) 500 Land and Buildings 800
Reserves 1,300 Plant and Machinery 1,400
Secured Term Loans 600 Current Assets 2,500
13% Debenture (` 100 Par 500
Current Liabilities 1,800
4,700 4,700
Note : In any gearing estimates the Furniture Manufacturing division may be assumed to
comprise 55% of the market value of equity of XY Ltd, and Real Estate division 45%.
Year 1 2 3 4 5 6-15
PVAF @ 10% 0.909 0.821 0.751 0.683 0.621 3.815
PVAF @ 8.5% 0.922 0.849 0.783 0.722 0.665 4.364
Sln. To decide whether the XY Ltd. should go for the option of demerger i.e. floating two
companies for Furniture Manufacturing business and Real Estate we should compare their
values.
Working Notes:
i. Calculation of Discounting Rates
a. For Furniture Manufacturing
Market Value of Debt (Secured Loan) ` 600.00 crore
Market Value of Equity (` 118.40 × 50 crore × 55%) ` 3256.00 crore
Total × 3856.00 crore
Gearing Levels
Equity Debt
3256.00
= 84.44%
3856.00
600.00
= 15.56%
3856.00
Since this level of gearing differs from the gearing level of industry to find out the beta
we must re-gear the asset beta taking into account the current structure. Assuming Debt
to be risk free let us de-gear the beta as follows:
bL
bu =
[1 + (1 - T)D / E]
Accordingly,
1.30
bu =
[1 + (1 - 0.30)30 / 70]
Re-gearing
βL = βU [1+ (1 – T) D / E]
βL = 1.00 [1+ (1 – 0.30) 15.56/ 84.44] = 1.129
Cost of Equity using CAPM
Ke = 5.50% + 1.129(14% - 5.50%) =15.10%
Cost of Debt using Short Cut Method
(100 - 131)
13(1 - 0.30) +
Kd = 15 = 0.0609 i.e. 6.0
100 + 31
2
WACC of Furniture Manufacturing Division
15.10% × 84.44% + 6.09% × 15.56% = 13.70%
(1 + No min al Rate) (1 + 0.1370)
Real WACC = -1 = - 1 = 10.39 say 10%
(1 + Inflation Rate) (1 + 0.03)
b. For Real Estate
Market Value of Debt (Secured Loan) ` 655.00crore
Market Value of Equity (` 118.40 × 50 crore × 45%) ` 2,664.00 crore
Total ` 3,319.00 crore
Gearing Levels
Equity Debt
2, 664.00 655.00
= 19.73%
3,319.00 3,319.00
Since this level of gearing is almost equal to the gearing level of industry the beta of
industry shall be the beta of Real Estate Division and Cost of Equity using CAPM will
be:
Ke = 5.50% + 0.90(14% - 5.50%) =13.15%
WACC of Real Estate Division
13.15% × 80.27% + 6.09% × 19.73% = 11.76%
(1 + No min al Rate) (1 + 0.1176)
Real WACC = -1 = = -1 = 0.085
(1 + Inflation Rate) (1 + 0.03)
ii. Calculation of Value of Both Division
a. Furniture Manufacturing
Year 1 2 3 4 5 6
Onward
Operating Profit 450 480 500 520 570 600
before Tax
16. Two companies Bull Ltd. and Bear Ltd. recently have been merged. The merger initiative
has been taken by Bull Ltd. to achieve a lower risk profile for the combined firm in spite
of fact that both companies belong to different industries and disclose a little co-
movement in their profit earning streams. Though there is likely to synergy benefits to
the tune of `7 crore from proposed merger. Further both companies are equity financed
and other details are asfollows:
MarketCapitalization Beta
Bull Ltd. `1000crore 1.50
Bear Ltd. `500 crore 0.60
Expected Market Return and Risk Free Rate of Return are 13% and 8% respectively.
Shares of merged entity have been distributed in the ratio of 2:1 i.e. market capitalization
just before merger. You are required to:
a. Calculate return on shares of both companies before merger and after merger.
b. Calculate the impact of merger on Mr. X, a shareholder holding 4% shares in Bull
Ltd. and 2% share of Bear Ltd.
Sln. a. Expected Return using CAPM
i. Before Merger
Share of Bull Ltd. 8% +1.50 (13% -8%) =15.50%
Share of Bear Ltd. 8% + 0.60 (13% - 8%) =11.00%
17. Teer Ltd. is considering acquisition of Nishana Ltd. CFO of Teer Ltd. is of opinion that
Nishana Ltd. will be able to generate operating cash flows (after deducting necessary
capital expenditure) of `10 crore per annum for 5years.
The following additional information was not considered in the above estimations.
i. Office premises of Nishana Ltd. can be disposed of and its staff can be relocated in
Teer Ltd.’s office not impacting the operating cash flows of either businesses.
However, this action will generate an immediate capital gain of ` 20 crore.
ii. Synergy Gain of ` 2 crore per annum is expected to be accrued from the proposed
acquisition.
iii. Nishana Ltd. has outstanding Debentures having a market value of ` 15 crore. It
has no other debts.
iv. It is also estimated that after 5 years if necessary, Nishana Ltd. can also be
disposed of for an amount equal to five times its operating annual cashflow.
Calculate the maximum price to be paid for Nishana Ltd. if cost of capital of Teer Ltd. is
20%. Ignore any type of taxation.
Sol. Calculation of Maximum Price to be paid for the acquisition of Nishana Ltd.
(` Crore)
Year 0 1 2 3 4 5
Operating cash flow - 10.00 10.00 10.00 10.00 10.00
Gain on Sale of office 20.00 - - - - -
premises
Synergy Benefits - 2.00 2.00 2.00 2.00 2.00
Disposal of Nishana - - - - - 50.00
Ltd.
Net cash flow 20.00 12.00 12.00 12.00 12.00 62.00
PVF @ 20% 1 0.833 0.694 0.579 0.482 0.402
Present value 20.00 10.00 8.324 6.948 5.784 24.924
18. 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
Tax @ 35% 56.70
105.30
b. $ Million
Market value of Equity Stock [W. No. 2] 500
Equity Fund [W. No. 3] 425
Market Value Added 75
Working Notes:
1. Total Capital Employed
Equity Stock $ 100 Million
Reserve and Surplus $ 325 Million
Loan $ 180 Million
WACC $ 605 Million
Cost of Capital employed $ 605Million х 12% 12%
2. Market Price per equity share (A) $ 72.60 Million
No. of equity share outstanding (B) $ 50
Market value of equity stock (A) х(B) 10 Million
3. Equity Fund $ 500 Million
Equity Stock
Reserves &Surplus $ 100 Million
$ 325 Million
$ 425 Million
19. The CEO of a company thinks that shareholders always look for EPS. Therefore he
considers maximization of EPS as his company's objective. His company's current Net
Profits are `80.00 lakhs and P/E multiple is 10.5. He wants to buy another firm which
has current income of `15.75 lakhs & P/E multiple of 10.
What is the maximum exchange ratio which the CEO should offer so that he could keep
EPS at the current level, given that the current market price of both the acquirer and the
target company are `42 and`105 respectively?
If the CEO borrows funds at 15% and buys out Target Company by paying cash, how
much should he offer to maintain his EPS? Assume tax rate of30%.
Sol. i.
Acquirer Company Target Company
Net Profit ` 80 lakhs ` 15.75 lakhs
PE Multiple 10.50 10.00
Market Capitalization ` 840 lakhs ` 157.50 lakhs
Market Price `42 ` 105
No. of Shares 20 lakhs 1.50 lakhs
EPS `4 ` 10.50
Maximum Exchange Ratio 4 : 10.50 or 1 : 2.625.
Thus, for every one share of Target Company 2.625 shares of Acquirer Company.
ii. Let x lakhs be the amount paid by Acquirer company to Target Company. Then to
maintain same EPS i.e. ` 4 the number of shares to be issued will be:
(80 lakhs + 15.75 lakhs) - 0.70 ´ 15% ´ X
=4
20 lakhs
95.75 - 0.105x
=4
20
x = ` 150 lakhs
Thus, ` 150 lakhs shall be offer Edincashto Target Company to maintain same EPS.
æ 3.00 ö
Note : 1,80,000 may be calculated as = ç 3, 00, 000 ´ ÷
è 5.00 ø
34,00,000
EPS for Cauliflower Ltd. after merger Impact on EPS = = ` 5.00
6,80,000
`
Cauliflower Ltd. shareholders
EPS before merger 5.00
EPS after merger Increase/ 5.00
Decrease in EPS 0.00
Cabbage Ltd.' Shareholders
EPS before merger 3.00
EPS after the merger 5.00 × 3/5 3.00
Increase/ Decrease in EPS 0.00
Impact on EPS
`
Cauliflower Ltd. shareholders
EPS before merger 5.0000
EPS after merger 5.2300
Increase in EPS 0.2300
Cabbage Ltd.' Shareholders
EPS before merger 3.0000
EPS after the merger 5.23 × 0.5 2.6150
Decrease in EPS 0.3850
21. Longitude Limited is in the process of acquiring Latitude Limited on a share exchange
basis. Following relevant data are available:
Longitude Latitude
Limited Limited
Profit after Tax (PAT) ` in Lakhs 140 60
Number of Shares Lakhs 15 16
Earning per Share (EPS) ` 8 5
Price Earnings Ratio (P/E Ratio) 15 10
(Ignore Synergy)
You are required to determine:
i. Pre-merger Market Value per Share, and
ii. The maximum exchange ratio Longitude Limited can offer without the dilution of
1. EPS and
2. Market Value per Share
Calculate Ratio/s up to four decimal points and amounts and number of shares up to two
decimal points.
Sol. i. Pre -Merger Market Value of Per Share P/E Ratio XEPS
Longitude Ltd. `8×15 = `120.00
Latitude Ltd. `5×10 = `50.00
Note: Since in the question figures given of PAT of both companies are not matching with
figures of EPS X Number of Shares. Hence, if students computed PAT by using this formula
then alternative answer shall be as follows:
22. AXE Ltd. is interested to acquire PB Ltd. AXE has 50,00,000 shares of ` 10 each,
which are presently being quoted at ` 25 per share. On the other hand PB has
20,00,000 share of `10 each currently selling at ` 17. AXE and PB have EPS of `
3.20 and ` 2.40 respectively.
You are required to:
a. Show the impact of merger on EPS, in case if exchange ratio is based on relative
proportion of EPS.
b. Suppose, if AXE quote an offer of share exchange ratio of 1:1, then should PB
accept the offer or not, assuming that there will be no change in PE ratio of AXE
after the merger.
c. The maximum ratio likely to acceptable to management of AXE.
Sol.
` 240 ( EPS of PBLtd.)
a. Exchange Ratio =
`3.20 ( EPS of AXE Ltd.)
= 0.75
Earning of AXE Ltd. = ` 3.20 × 50,00,000 = `1,60,00,000
Earning of PB Ltd. = ` 2.40 × 20,00,000 = ` 48,00,000
Combined earnings after merger = ` 2,08,00,000
Total No. of shares to be issued to PB Ltd. 0.75 × 20,00,000 = 15,00,000
Existing No. of Shares of AXE Ltd. = 50,00,000
65,00,000
208, 00, 000
EPS after Merger =
65, 00, 000
= ` 3.20
The shares of Day Ltd. and Night Ltd. trade at 20 and 15 times their respective P/E ratios.
Day Ltd. considers taking over Night Ltd. By paying ` 55 crores considering that the
market price of Night Ltd. reflects its true value. It is considering both the following
options:
i. Takeover is funded entirely in cash.
ii. Takeover is funded entirely in stock.
You are required to calculate the cost of the takeover and adivse Day Ltd. on the best
alternative.
24. Longitude Limited is in the process of acquiring Latitude Limited on a share exchange
basis.
Following relevant data are available:
Longitude Latitude
Limited Limited
Profit after Tax (PAT) ` in Lakhs 140 60
Number of Share (EPS) Lakhs 15 16
Earnings Per Share (EPS) ` 8 5
Price Earnings Ratio (P/E Ratio) 15 10
(Ignore Synergy)
25. The CEO of a company thinks the shareholders always look for EPS. Therefore, he
considers maximization of EPS as his company’s objective. His company’s current Net
Profits are ` 80.00 lakhs P / E multiple is 10.5. He wants to buy another firm which has
current income of ` 15.75 lakhs & P / E multiple of 10.
What is the maximum exchange ratio which the CEO should offer so that he could keep
EPS at the current level, given that the current market price of both the acquirer and the
target company are ` 42 and ` 105 respectively?
If the CEO borrows funds at 15% and buys out Target Company by paying cash, how
much should he offer to maintain his EPS? Assume tax rate of 30%
Sol.
i.
Acquirer Company Target Company
Net Profit ` 80 Lakhs ` 15.75 lakhs
PE Multiple 10.50 10.00
Market Capitalization ` 840 lakhs ` 157.50 lakhs
Market Price ` 42 ` 105
No. of Shares 20 Lakhs 1.50 lakhs
EPS `4 ` 10.50
ii. Let x lakhs be the amount paid by Acquirer company to Target Company. Then to
maintain same EPS i.e. ` 4 the number of shares to be issued will be:
(80 lakhs + 15.75 lakhs) -0.70 × 15% × x
=4
20lakhs
95.75 - 0.105 x
=4
20
x = ` 150 lakhs
Thus, ` 150 lakhs shall be offered in cash to Target Company to maintain same EPS.
26. R Ltd. and S Ltd. operating in same industry are not experiencing any rapid growth but
providing a steady stream of earnings. R Ltd.’s management is interested in acquisition
of S. Ltd. due to its excess plant capacity. Share of S Ltd. is trading in market at ` 3.20
each. Other data relating to S Ltd. is as follows:
Balance Sheet of S Ltd.
Liabilities Amount (`) Assets Amount (`)
Current Liabilities 1,59,80,000 Current Assets 2,48,75,000
Long Term Liabilities 1,28,00,000 Other Assets 94,00,000
Therefore, the minimum price per share S ltd. should accept from R Ltd. is ` 5 (current
book value)
ii. Calculation of Maximum price per share R Ltd. shall be willing to offer to S Ltd.
Residual Cash Flow 90,10,000
Value of R Ltd. = = = ` 6,55,27,273
K e -g 0.1375 - 0
1,85,00,000
Value of combined entity = = ` 14,80,00,000
0.125 - 0
Value of synergy = Value of combined entity – individual values of R Ltd. and S
Ltd.
iii. Floor value of per share of S Ltd shall be ` 3.20 (current market price) and it shall not
play any role in decision for the acquisition of S Ltd. as it is lower than its current book
value.
27. MS stones has different divisions of home interiors products. Recently, due to economic
slowdown, the Managing Director of the Company expressed it desire to divestiture its
ceramic tile business. The relevant financial details of this business are as follows:
Estimated Pre- Tax Cash Flow Next Year = ` 200 Crore
Book Value of Liabilities = ` 780 Crore
In an order to increase its share in the market, the Tripati Tiles Ltd. showed its interest in
the acquisition of this unit and offered a proceed of ` 950 Crore for the same to MS
Stones. The other data pertaining to the business are as follows:
Tax rate 30%
Growth Rate 4%
Applicable Discount Rate for Tile Business 12%
If market value of liabilities is ` 40 Crore more than book value, you are required to
advice MD whether she should go for divestiture of the tile business or not.
Sol. First of all we shall compute PV of Cash inflows as follows:
200 crore (1 - 0.30)
PVCF = = ` 1750 Crore
0.12 - 0.04
Market Value of Liabilities = ` 780 Crore + ` 40 core = ` 820 Crore
Net Asset Value = ` 930 Crore
Since, the Tripati Tiles is offering ` 950 Crore, more than Net Asset Value of ` 930 Crore,
the company should go further with decision of divesture of tile business.
28. XYZ, a large business house is planning to acquire ABC another business entity in similar
line of business. XYZ has expressed in interest in making a bid for ABC. XYZ expects
that after acquisition the annual earning of ABC will increase by 10%.
29. Equity of KGF Ltd. (KGFL) is ` 410 Crores, its debt, is worth ` 170 Crores. Printer
Division segments value is attributable to 74%, which has an Asset Beta (bP) of 1.45,
balance value is applied on Spares and Consumables Division, which has an Asset Beta
(bSC) of 1.20 KGFL Debt beta (bD) is 0.24.
You are required to calculate:
i. Equity Beta (bE)
ii. Ascertain Equity Beta (bE), if KGF Ltd. decides to change its Debt Equity position
by raising further debt and buying back of equity to have its Debt Equity Ratio at
1.90. Assume that the present Debt Beta (bD1) is 0.35 and any further funds raised
by way of Debt will have a Beta (bD2) of 0.40.
iii.Whether the new Equity Beta (bE) justifies increase in the value of equity an account
of leverage?
Sol. i. Equity Beta
To calculate Equity Beta first we shall calculate Weighted Average of Asset Beta as
follows:
= 1.45 × 0.74 + 1.20 × 0.26
= 1.073 + 0.312 = 1.385
Now we shall compute Equity Beta using the following formula:
é E ù é D(i - t) ù
bAsset = bEquity ê ú + β Debt ê ú
ë E+D(i - t) û ë E+D(i - t) û
Accordingly,
é 410 ù é 170 ù
1.385 = bEquity ê + β
ë 410 + 170 úû êë 410 + 170 úû
Debt
é 410 ù é 170 ù
1.3885 = bEquity ê + 0.24
ë 580 úû êë 580 úû
bEquity = 1.86
iii. Yes, it justifies the increase as it leads to increase in the Value of Equity due to increase
in Beta.
TS Ltd. has an undistributed reserves of ` 8 crores. The company requires ` 3 crores for
the purpose of expansion which is expected to earn the same rate of return on capital
employed as present. However, if the debt to capital employed ratio is higher than 35%,
then P / E ratio is expected 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 ` 25 each.
Sol. Working Notes :
i. Calculation of Return on Capital Employed (ROCE)
( ` in crores )
Capital Employed:
Share Capital (` 10 × 40 lakhs) 4
Reserve 8
Debt (` 1 cr. × 100 / 10) 10
22
PBIT 5
ROCE 22.73%
10
iv. Debt to Capital Employed Ratio in Option (ii) = = 0.40
25
So, P / E Ratio to be reduced to 8 times in this case also
Decision: Since the MPS is expected to be more in the case of additional financing done
though debt (Option – 1) Option – 1 is preferred.
31. Strong Ltd., (SL), an all equity financed, conglomerate is in need to borrow `2,000 crore
to finance expansion of its crore current operations. However, SL is susceptible to raise the
amount from the market. The CFO has suggested for divesting one of the two nonprime units
to reduce the overall borrowings from the market. The following data, after internal due
diligence, has been placed for consideration of the Board:
(` in cores)
Particulars Unit Unit 2
Reported Profit After Tax 147 140
Extra Ordinary Gains 16 8
Extra Ordinary Losses 20 12
Expected Profit from the launch of the new product 56 12
Price Earnings Ratio 10 12.5
Corporate Tax Rate (%) 30 30
You are required to advise the Borad on the following:
(i) The price at which the units can be divested,
(ii) The unit which can be divested so as to minimise the borrowings from the market and
(iii) The amount of borrowing.(10 Marks)
(10 Marks)
Sol.
(i) Price at which units can be Divested
(` Crore)
Particulars Unit I Unit II
Reported Profit after Tax (a) 147 140
Reported profit before Tax [(a) /0.70] 210 200
Less: Extra Ordinary Gains 16 8
Add: Extra Ordinary Losses 20 12
214 204
Profit from New Product 56 12
Profit before Tax 270 216
Less : Tax @ 30% 81 64.80
Future Maintainable Profit after Tax (b) 189 151.20
PE Ratio 10 12.5
(i) The amount of borrowing ` 2000 crore - ` 1890 crore = ` 110 crore
32. ICL is proposing to take over SVL with an objective to diversify. ICL's profit after tax (PAT)
has grown @ 18 per cent per annum and SVL's PAT is grown @ 15 per cent per annum. Both
the companies pay dividend regularly. The summarised Profit & Loss Account of both the
companies are as follows:
` in Crores
Particulars ICL SVL
Net Sales 4,545 1,500
PBlT 2,980 720
Interest 750 25
Provision for Tax 1,440 445
PAT 790 250
Dividends 235 125
ICL SVL
Fixed Assets
Land & Building (Net) 720 190
Plant & Machinery (Net) 900 350
Furniture & Fixtures (Net) 30 1,650 10 550
Current Assets 775 580
Less: Current Liabilities
Creditors 230 130
Overdrafts 35 10
Provision for Tax 145 50
Provision for dividends 60 470 50 240
Amount ` in Crores
Total Assets (Fixed assets + Current Assets) = (550 + 580) 1130
Less: Liabilities (Current Liabilities + Borrowings) = (240 + 105) 345
Net Assets Value 785
Current Value of Land after growing for three years @ 30% = 190 × 2.197 417.43
æ D1 ö æ 10 ö 0.2833
Cost of Equity ç + g÷ ç + 0.15 ÷
è P ø è 75 ø
33. Snake Ltd. is taking over Lizard Ltd, both are listed companies. The PE Ratio of Lizard
Ltd. has been low as 4 and high as 7 and is currently 5. Lizard Ltd.`s previous year EPS
was ` 3.40 and current expected EPS this year to be ` 4.00.
Determine the different range of values of shares using P/E Model. (6 Marks)
Sol. The range of values using P/E Ratio and EPS either historic or projected are as follows.
EPS Value (`) P/E Ratio Value Value of
Shares
Historic 3.40 Lowest 4 13.60
Historic 3.40 Current 5 17.00
33. Long Ltd., is planning to acquire Tall Ltd., with the following data available for both the
companies:
Long Ltd. Tall Ltd.
Expected EPS ` 12 `5
Expected DPS ` 10 `3
No. of Shares 30,00,000 18,00,000
Current Market Price of Share ` 180 ` 50
As per an estimate Tall Ltd., is expected to have steady growth of earnings and dividends
to the tune of 6% per annum. However, under the new management the growth rate is
likely to be enhanced to 8% per annum without additional investment.
You are required to:
(i) Calculate the net cost of acquisition by Long Ltd., if ` 60 is paid for each share of
Tall Ltd.
(ii) If the agreed exchange ratio is one share of Long Ltd., for every three shares of Tall
Ltd., in lieu of the cash acquisition as per (i) above, what will be the net cost of
acquisition?
(iii) Calculate Gain from acquisition. (8 Marks)
Sol.
(i) Net cost of acquisition shall be computed as follows:
Cash Paid for the shares of Tall Ltd. (` 60 × 18,00,000) ` 10,80,00,000
Less: Value of Tall Ltd., as a separate entity (18,00,000 × ` 50) ` 9,00,00,000
Net Cost of acquisition of Tall Ltd. ` 1,80,00,000
34. Teer Ltd. is considering acquisition of Nishana Ltd. CFO of Teer Ltd. is of opinion that
Nishana Ltd. will be able to generate operating cash flows (after deducting necessary
capital expenditure) of `10 crore per annum for 5years.
The following additional information was not considered in the above estimations.
i. Office premises of Nishana Ltd. can be disposed of and its staff can be relocated in
Teer Ltd.’s office not impacting the operating cash flows of either businesses.
However, this action will generate an immediate capital gain of ` 20 crore.
ii. Synergy Gain of ` 2 crore per annum is expected to be accrued from the proposed
acquisition.
iii. Nishana Ltd. has outstanding Debentures having a market value of ` 15 crore. It
has no other debts.
iv. It is also estimated that after 5 years if necessary, Nishana Ltd. can also be
disposed of for an amount equal to five times its operating annual cashflow.
35. Alfa Ltd. wants to acquire Beta Ltd. and has offered a swap ratio of 1 : 2 (0.5 shares for
every one share of Beta Ltd.). Following information is provided:
Alfa Ltd. Beta Ltd.
Profit after tax (` 18,00,000 3,60,000
Equity shares outstanding (Nos.) 6,00,000 1,80,000
EPS (`) 3 2
PE Ratio 10 times 7 times
Market price per share (` 30 14
(i) You are required to determine:
(a) the number of equity shares to be issued by Alfa Ltd. for acquisition of Beta
Ltd.
(b) the EPS of Alfa Ltd. after the acquisition.
(c) the equivalent earnings per share of Beta Ltd.
(d) the expected market price per share of Alfa Ltd.* after the acquisition, if PE
increases to 12 times.
(e) the market value of the merged firm.
(ii) If you are the shareholder of Beta Ltd and holding 100 shares, will you be interested
to sell your stake ? Why? (8 Marks)
Sol.
(i)
(ii)
Present market Value of share of Beta Ltd. (100 × ` 14) ` 1,400
Revised market price of each share of Alfa Ltd. after Merger ` 37.56
Equivalent No. of Alfa Ltd. share in exchange of Beta Ltd. (0.50 × 100) 50
Equivalent Value of Alfa Ltd. share in exchange of Beta Ltd. ` 1,878
(100 × 0.50 × ` 37.56)
Increase in Market Value (` 1,878 - ` 1,400) ` 478
2,136.61
= ` 30,523 Cr.
0.15 - 0.08
No, I am not agreed to sell the stake as there is increase in market value.
36. Big Ltd. (BL), a listed company, is enjoying a price earnings ratio (PER) of 15 on an
Earnings Per Share (EPS) of? 5. The Total number of outstanding shares are 2,00,000.
BL is proposing to acquire Small Pvt. Ltd. (SPL) an unlisted company by issuing shares
in the ratio 4:5 i.e. for 5 shares of SPL 4 shares of BL will be issued. The outstanding
shares of SPL are 50,000. SPL will be listed before the actual merger to discover its value.
The EPS of the merged entity will be 5.5. *
No other information is available for SPL.