Case synopsis:
Company B has been planning for the past 6 months to merge with Company H. After few discussions, it has decided to make a cash offer of $250 million for Company H. Person B, the financial officer of Company B, has been involved in the negotiations of merger.
He has prepared a pro forma financial statements for Company H assuming that the merger will take place. If Company B purchases Company H, then there will be an immediate payment of dividend. Person B has identified the interest rate of borrowing for both the companies.
Characters in the case:
- Company B
- Company H
- Person B
Adequate information:
- Both the companies are planning to merge have niche markets in the industry of golf club.
To calculate: Whether Company B must continue with the merger if the shareholders of Company H agree at a price of $31.25 per share.
Answer to Problem 1M
The
Explanation of Solution
Given information:
Company H will have a cash offer of $250 million for the merger. The dividend of $67.5 million will be paid from Company H to Company B, if Company B buys Company H. The sale price of the stock in Company B is $87 per share and its outstanding shares are 8 million. The rate of interest at which both the company could borrow is 8%.
The present capital cost for Company B and Company H are 11% and 12.4% respectively. The equity cost is 16.9%. Within five years, Company H’s value is projected to be $270 million.
Note: It is necessary to find the
Explanation:
Formula to calculate the total present cash flow from the acquisition:
Calculate the total present cash flow from the acquisition:
Hence, the present cash flow is -$182,500,000.
Formula to compute the dividend from Company H:
Compute the dividend from Company H:
Hence, the dividend in Year 1 is $20,700,000.
Hence, the dividend in Year 2 is $5,000,000.
Hence, the dividend in Year 3 is $13,500,000.
Hence, the dividend in Year 4 is $19,950,000.
Hence, the dividend in Year 5 is $27,000,000.
Table showing the total cash flow:
Total cash flow | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
Dividends from Hybrid | $20,700,000 | $5,000,000 | $13,500,000 | $19,950,000 | $27,000,000 |
Terminal value of equity | $270,000,000 | ||||
Total | $20,700,000 | $5,000,000 | $13,500,000 | $19,950,000 | $29,700,000 |
It is necessary to discount every cash flow at the appropriate rate of discount. The company’s terminal risk is subjected to the normal business risk and must be discounted at the capital cost. The dividends must be discounted at the equity cost.
Formula to compute the discounted dividend:
Where,
t denotes the number of years.
Compute the discounted dividend:
Hence, the discounted dividend for Year 1 is $17,707,442.
Hence, the discounted dividend for Year 2 is $3,658,819.
Hence, the discounted dividend for Year 3 is $8,450,652.
Hence, the discounted dividend for Year 4 is $10,682,794.
Hence, the discounted dividend for Year 5 is $12,367,765.
Formula to compute the present value of the terminal value of equity:
Where,
t denotes the number of years.
Compute the present value of the terminal value of equity:
Hence, the present value of the terminal value of equity is $150,498,513.
Table showing the present values of the cash flows:
Discount rate | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
Dividends | 16.90% | $17,707,442 | $3,658,819 | $8,450,652 | $10,682,794 | $12,367,765 |
PV of terminal value | 12.40% | $150,498,513 | ||||
Total | $17,707,442 | $3,658,819 | $8,450,652 | $10,682,794 | $162,866,277 |
Formula to calculate the NPV of the acquisition:
Calculate the NPV of the acquisition:
Hence, the NPV of the acquisition is $20,865,984.
Want to see more full solutions like this?
Chapter 26 Solutions
Connect 1 Semester Access Card for Fundamentals of Corporate Finance
- Scenario 2: The homepage for Coca-Cola Company can be found at coca-cola.com Links to an external site.. Locate the most recent annual report, which contains a balance sheet for the company. What is the book value of equity for Coca-Cola? The market value of a company is (# of shares of stock outstanding multiplied by the price per share). This information can be found at www.finance.yahoo.com Links to an external site., using the ticker symbol for Coca-Cola (KO). What is the market value of equity? Which number is more relevant to shareholders – the book value of equity or the market value of equity?arrow_forwardFILE HOME INSERT Calibri Paste Clipboard BIU Font A1 1 2 34 сл 5 6 Calculating interest rates - Excel PAGE LAYOUT FORMULAS DATA 11 Α΄ Α΄ % × fx A B C 4 17 REVIEW VIEW Alignment Number Conditional Format as Cell Cells Formatting Table Styles▾ Styles D E F G H Solve for the unknown interest rate in each of the following: Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. 7 8 Present value Years Interest rate 9 10 11 SA SASA A $ 181 4 $ 335 18 $ 48,000 19 $ 40,353 25 12 13 14 15 16 $ SA SA SA A $ Future value 297 1,080 $ 185,382 $ 531,618arrow_forwardB B Canning Machine 2 Monster Beverage is considering purchasing a new canning machine. This machine costs $3,500,000 up front. Required return = 12.0% Year Cash Flow 0 $-3,500,000 1 $1,000,000 2 $1,200,000 3 $1,300,000 4 $900,000 What is the value of Year 3 cash flow discounted to the present? 5 $1,000,000 Enter a response then click Submit below $ 0 Submitarrow_forward
- Finances Income Statement Balance Sheet Finances Income Statement Balance Sheet Materia Income Statement Balance Sheet FY23 FY24 FY23 FY24 FY23 FY24 Sales Cost of Goods Sold 11,306,000,000 5,088,000,000 13,206,000,000 Current Current Assets 5,943,000,000 Other Expenses 4,523,000,000 5,283,000,000 Cash 211,000,000 328,600,000 Liabilities Accounts Payable 621,000,000 532,000,000 Depreciation 905,000,000 1,058,000,000 Accounts 502,000,000 619,600,000 Notes Payable 376,000,000 440,000,000 Earnings Before Int. & Tax 790,000,000 922,000,000 Receivable Interest Expense 453,000,000 530,000,000 Total Current Inventory 41,000,000 99,800,000 997,000,000 972,000,000 Taxable Income 337,000,000 392,000,000 Liabilities Taxes (25%) 84,250,000 98,000,000 Total Current 754,000,000 1,048,000,000 Long-Term Debt 16,529,000,000 17,383,500,000 Net Income Dividends 252,750,000 294,000,000 Assets 0 0 Fixed Assets Add. to Retained Earnings 252,750,000 294,000,000 Net Plant & 20,038,000,000 21,722,000,000…arrow_forwardDo you know what are Keith Gill's previous projects?arrow_forwardExplain why long-term bonds are subject to greater interest rate risk than short-term bonds with references or practical examples.arrow_forward
- What does it mean when a bond is referred to as a convertible bond? Would a convertible bond be more or less attractive to a bond holder than a non-convertible bond? Explain in detail with examples or academic references.arrow_forwardAlfa international paid $2.00 annual dividend on common stock and promises that the dividend will grow by 4% per year, if the stock’s market price for today is $20, what is required rate of return?arrow_forwardgive answer general accounting.arrow_forward
- Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage LearningEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENTIntermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning