06 Feb Using the information provided in Twitter’s 10-K form, estimate a reasonable revenue growth rate and cost of capital for the company. Develop your estimate
Using the information provided in Twitter’s 10-K form, estimate a reasonable revenue growth rate and cost of capital for the company. Develop your estimates based on historical trends, market dynamics, and broader industry conditions. Some relevant data is provided in the accompanying Excel file, but additional information may need to be sourced independently through online research. Clearly outline your assumptions of revenue growth rate and cost of capital and provide your reasoning to justify your chosen rates. Next, utilize the accompanying Excel valuation template to calculate Twitter’s value as of April 22, 2022. Analyze how sensitive the valuation results are to changes in the revenue growth rate assumptions. Discuss the implications of this sensitivity when assessing the deal. Does this acquisition represent a good deal for Elon Musk? Why or why not?
This is the main task of the assignment. Using the link for the 10K report and with the help of the given formulas you need to file a report and calculate everything in an excel file.
Foundations for Finance
OVGU Assignment: Elon Musk’s Twitter Deal Case Study
This assignment in attachment is voluntary, and you will receive a bonus point for submission and good performance. Please submit your answer report in PDF format, along with the corresponding Excel file in xlsx via elearning. Deadline: Feb 16, 2025 at 23:59
Q. Twitter, founded in 2006 by Jack Dorsey, Noah Glass, Biz Stone, and Evan Williams, launched its platform later that year. The company went public on the New York Stock Exchange on November 7, 2013. Unlike many other tech companies, which grant founders or early investors greater voting power through multi-class share structures, Twitter adopted a single-class share structure, ensuring all shares had equal voting rights.
On April 25, 2022, Elon Musk signed an agreement to acquire all outstanding shares of Twitter for $54.20 per share in cash, valuing the company at approximately $44 billion. Below is a timeline of key events related to the deal:
Twitter’s management argued that Musk’s offer undervalued the company.
Now please analyze this transaction. You can refer to Twitter’s 2021 10-K annual report, available on the SEC’s website at this link (https://www.sec.gov/Archives/ edgar/data/1418091/000141809122000029/twtr-20211231.htm).
Answer to questions below:
(a) Evaluate Twitter’s response to Musk’s takeover attempt. Could the company have taken a stronger takeover defense? If so, how?
1
(b) Using the information provided in Twitter’s 10-K form, estimate a reasonable rev- enue growth rate and cost of capital for the company. Develop your estimates based on historical trends, market dynamics, and broader industry conditions. Some relevant data is provided in the accompanying Excel file, but additional in- formation may need to be sourced independently through online research. Clearly outline your assumptions of revenue growth rate and cost of capital and provide your reasoning to justify your chosen rates. Next, utilize the accompanying Excel valuation template to calculate Twitter’s value as of April 22, 2022. Analyze how sensitive the valuation results are to changes in the revenue growth rate assump- tions. Discuss the implications of this sensitivity when assessing the deal. Does this acquisition represent a good deal for Elon Musk? Why or why not?
Note: To simplify, assume
EBIT = Revenues ∗ Operating Margin; FCFF = EBIT ∗ (1− t)−Reinvestment;
Reinvestment = (Current Year Revenues − Previous Year Revenues) ×Sales-to-Capital Ratio;
Value of firm = PV(next five years’ FCFFs) + PV(terminal value)
where terminal value = FCFFyear5 × (1 + g)
(r − g) , PV (terminal value) =
terminal value (1 + r)5
and Value of equity = Value of the firm − Debt − Minority interest + Cash + Non − operating assets.
2
,
Input sheet and cash flows (DCF
| Date of valuation | Mar-18 | ||||||||
| Company name | |||||||||
| Numbers from your base year below ( in consistent units) | |||||||||
| Updated on January 2022 with 2022 Industry averages | |||||||||
| Country of incorporation | United States | ||||||||
| Industry (US) | Advertising | Industry averages. | |||||||
| Industry (Global) | Advertising | ||||||||
| Most recent 10-k annual report (in million dollars) | Note | Report page number | Industry (US data) | Industry (Global data) | |||||
| Revenues | Read from 10-k | Revenue growth in the most recent year = | 7.13% | 4.93% | |||||
| Operating income or EBIT | $ 273.00 | Cost of capital = | 5.64% | 7.00% | |||||
| Interest expense | $ 152.90 | ||||||||
| Book value of equity | Read from 10-k | ||||||||
| Book value of debt | $ 5,546.60 | ||||||||
| Number of shares outstanding = | 797.60 | ||||||||
| Current stock price = | $ 42.00 | ||||||||
| Effective tax rate = | 25.00% | ||||||||
| Marginal tax rate = | 25.00% | ||||||||
| The value drivers below (Assumptions): | |||||||||
| Revenue growth rate for the following 5 years | Insert your estimate here and write your reasons in report | ||||||||
| Operating Margin for the following 5 years | 20.00% | ||||||||
| Market and company numbers | |||||||||
| Riskfree rate | 2.50% | ||||||||
| Cost of capital (WACC) | Insert your estimate here and write your reasons in report | ||||||||
| Standard deviation on stock price = | 30.00% | ||||||||
| Sales-to-Capital Ratio | 2.80% | Annually | |||||||
| perpetual growth rate of FCF (g) | 4.00% | ||||||||
| Note: To simplify, | |||||||||
| EBIT=Revenues* Operating Margin | |||||||||
| FCFF=EBIT*(1-t)-Reinvestment | |||||||||
| Reinvestment = (Current Year Revenues − Previous Year Revenues) × Sales-to-Capital Ratio | |||||||||
| Value of firm = PV(next five years' FCFFs)+PV(terminal value) | |||||||||
| where terminal value=FCFF_{year5}*(1+g)/(r-g) and PV(terminal value)=terminal value/(1+r)^5 | |||||||||
| Value of equity= Value of the firm – Debt – Minority interest + Cash + Non-operating assets | |||||||||
| Forecast for the next 5 years using your estimated revenue growth rate and cost of capital for this five years. After that, Free Cash Flow each will grow at 4% growth rate, the cost of capital will be the same as the previous years | |||||||||
| Hint: you can first calculate the sum of PV(FCFF) of the first five years. Then use growing perpetuity formula given above to get the PV(terminal value) | |||||||||
| Base year | 1 | 2 | 3 | 4 | 5 | Terminal Value | |||
| Revenue growth rate | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||||
| Revenues | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | |||
| Operating margin | 19.02% | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | |||
| EBIT | |||||||||
| Tax rate (t) | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | |||
| EBIT*(1-t) | |||||||||
| – Reinvestment | |||||||||
| FCFF | |||||||||
| Cost of capital | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||||
| Cumulated discounted factor | 1 | 1 | 1 | 1 | 1 | ||||
| PV(FCFF) | |||||||||
| Value of the company | $ – 0 | ||||||||
| – Debt | $ 5,546.60 | Value of debt is 5546.6 million dollars | |||||||
| – Minority interests | $ – 0 | ||||||||
| + Cash | $ 6,393.70 | Value of cash is 6393.7 million dollars | |||||||
| + Non-operating assets | $ – 0 | ||||||||
| Value of equity | Value of equity= Value of the firm – Debt – Minority interest + Cash + Non-operating assets | ||||||||
| – Value of options | $17.91 | Value of options is 17.91 million dollars | |||||||
| Value of equity in common stock | |||||||||
| Number of shares | – 0 | ||||||||
| Estimated value /share | |||||||||
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.