Question: FIN3CSF Semester 1, 2024 - Case Study 1 Merger Earnings Valuation Model (Figures in US$ Million) Account Item Operating Revenue Cost of Goods Sold

FIN3CSF Semester 1, 2024 - Case Study 1 Merger Earnings Valuation Model

FIN3CSF Semester 1, 2024 - Case Study 1 Merger Earnings Valuation Model (Figures in US$ Million) Account Item Operating Revenue Cost of Goods Sold (inc D&A) Gross Income SG&A Expenses Depreciation and Amortisation Operating Income (EBIT) Non-operating Income Net Interest Expense Income Before Tax Income Tax Expense Net Income for Shareholders Discount factor Present value of earnings cash flow Total intrinsic valuation as at January 1st 2024 Total intrinsic valuation as at February 25th 2024 Company information at the time of merger negotiation Walt Disney Company Issued capital Beta coefficient 1834.00 1.09 Market capitalisation as at February 25th 2024 197,595.16 Share price as at February 25th 2024 107.74 Netflix Inc Issued capital 432.80 Beta coefficent Share price as at February 25th 2024 1.25 Market capitalisation as at February 25th 2024 252,564.77 583.56 Walt Disney Company September 2023 Actual 88,898 Netflix Inc Merged Entity Merged Entity Merged Entity 33,723 122,621 131,204 144,325 59,201 19,715 78,916 86,018 92,900 Merged Entity December 2023 Actual December 2023 Act December 2024 Foreca December 2025 Foreca December 2026 Foreca 2027 onwards Merged Entity Parameters Beta coefficient Risk-free rate of return (in decimals) Merged Entity 159,479 100,332 29,697 14,008 43,705 45,186 51,425 59,147 15,336 7,054 22,390 26,181 25,390 27,490 5,369 5,369 5,637 5,835 6,010 Expected market return (in decimals) Cost of equity Earnings growth forecast (in decimals) 1.1798 0.0000 0.0000 0.0000 0.0000 8,992 6,954 15,946 13,367 20,200 25,647 -3,014 -49 -3,063 -2,863 -2,713 -2,613 1,209 700 1,909 2,100 2,268 2,449 Ownership share for Walt Disney Company (in decimals) 0.0000 4,769 6,205 10,974 8,404 15,219 20,585 Market value of ownership share #DIV/O! 1,379 797 2,176 1,975 3,576 4,837 Equivalent merger value per share #DIV/O! 3,390 5,408 8,798 6,429 11,643 15,747 #DIV/O! Ownership share for Netflix Inc (in decimals) 1.0000 1.0000 6,429.43 1.0000 11,642.60 1.0000 15,747.32 Market value of ownership share #DIV/O! Equivalent merger value per share 0.0000 #DIV/O! #DIV/O! #DIV/O! #DIV/O!

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Donna Geary started an interior design company called Interiors by Donna, Inc., on April 1, 2018. The following amounts summarize the financial position of her business on April 14, 2018, after the...

Ali needs$3500for a future project. He can invest$2500now at an annual rate of12.5%,compounded quarterly. Assuming that no withdrawals are made, how long will it take for him to have enough money for...

Consider the following information: Rate of Return if State Occurs State of Economy Boom :57 Bust of Economy .66 .34 Probability of State Stock A .09 .13 Stock B Stock C .03 .19 .24 -.04 a. What is...

CoursHeroTranscribedText: Question 1 The daily volume of a brokerage company follows a normal distribution. The director wants to estimate the daily volume negotiated. a) What size should have a...

financial SUBDOMAINS: 325.4 COMMUNICATING EFFECTIVELY IN ORGANIZATIONS 326.1 MANAGING INTERNAL COST & CONTROLLING FINANCES 326.2 MANAGING CAPITAL & FINANCIAL ASSETS 326.4 MANAGING ENTERPRISE RISK &...

1. Prepare a written analysis of the financial ratios of the company Walmart.. This must include trend analysis (historical and projected) and comparative analysis (cross-sectional or industry). The...

This requires two forecasts. organic strategy, merger or acquisition growth strategy and analysis Week 8 Growth Analysis - Organic & Merger/Acquisition (Rev. 030917) MAKE SURE THAT YOU DOWNLOAD THE...

Attached is the project for the assignment. I will need a draft by Feb 20th but the actually project is not due until Feb 27th. My weekly discussion post are attached as well they are title...

1. (Points: 1) The primary purpose of hiring a public accounting firm to examine the financial statements of the company is a. to assure no fraud has been committed by the company's management b. to...

Not every part of the form need to be filled out. So please read the direction carefully. thank you. Forms to Complete (2015) Form 1065 (not Schedule B) Schedule Dand Forms 8949 Form 1125-A Schedule...

Equilibrium: Where Supply Meets Demand Chapter Problem - End of Consider the following data from the market demand and supply for apartments. a. Suppose that the average monthly rent for apartments...

Determine whether the following statements are true or false, and briefly explain why: a. A given total emission reduction in a polluting industry will be achieved at the lowest possible total cost...

Which of the following is a short - term financial management decision? Managing accounts payable Choosing a plant location None of the answers is correct Determining the debt - to - equity ratio...

b) Given that the head loss coefficient for the valve in its open position is 8.5 and the head loss coefficient at entry to the lower reservoir is 1.4, calculate the difference in elevation between...

The diameter of a piston of the steam engine is 300 mm and the maximum steam pressure is 0.7 N/mm2. If the maximum permissible compressive stress for the piston rod material is 40 N/mm2, find the...

12.6.4.2a) determine the extrema of y = ( ( x - 1 ) ) 1/3 + ( ( x + 1 ) ) 1/3

Let's say I add a small amount of hydrochloric acid to the buffer outlined in the previous problem. What buffer component would react with the added acid? O H30+ ym O H20 nsv O H2S HS OH

The Happybus Company is a school bus company. It provides transportation to private schools in the city of Riyadh. The company has 70 buses that are garaged in four different regions and it provides...

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

15. Hurricane Dorians destructive path through the Bahamas in 2019 powerfully illustrates the stressful nature of . a. daily hassles b. major life events c. catastrophes d. both a and b

2. Pedro has experienced an intense, burning sensation during urination and a thick, yellowish penile discharge. Pedro most likely has which STI? a. Gonorrhea b. Genital herpes c. Genital warts d. HPV

3. Which of the following people is most likely to report being the happiest? a. Haifa, who is extremely wealthy, has a few close friends, and focuses on negative experiences b. Sam, who is...