Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For the purchase of Twitter, assume that Musk borrows $ 2 5 billion and provides the remaining $ 2 1 billion in equity of his

For the purchase of Twitter, assume that Musk borrows $25 billion and provides the remaining $21 billion in equity of his own and of investors (total $46 billion to cover the $44 billion deal value and $2 billion closing costs), and that equity holders (including Must himself) require a return of 25% on their investment. Using the information provided (Exhibit 6), calculate and discount residual (i.e., levered) cash flows to estimate Twitters value under the scenario: Best-Case Scenario. EBITDA margin 25%, Revenue growth 15% for first 5 years, then 10% thereafter and an exit EV/EBITDA multiple of 25xEXHIBIT 6: PROJECTED NET INCOME GIVEN EBITDA GROWTH (BEST-CASE SCENARIO)
\table[[Twitter Inc.],[Metric,2021 A,2022E,2023E,2024E,2025E,2026E,2027E,2028E],[Revenue Growth,36.63%,25%,15.00%,15.00%,15.00%,15.00%,15.00%,10%],[Depreciation and Amortization,,,9.5%,9.0%,8.5%,8.0%,7.5%,],[EBITDA Margin (Pre-Tax),16.11%,,25.00%,25.00%,25.00%,25.00%,25.00%,],[Capital Expenditures (% Revenue),,,10.0%,10.0%,10.0%,10.0%,10.0%,],[\table[[Change in NWC (% Change in],[Revenue)]],,,1.00%,1.00%,1.00%,1.00%,1.00%,],[,,,,,,,,],[Terminal EBITDA Multiple (x),,,,,,,25,],[Debt,,$25,000,,,,,,],[Minimum Cash Balance,,,,,,,,],[Blended Interest Rate on Debt*,,7%,,,,,,],[Tax Rate,,28%,,,,,,],[Elon Musk's Required Return,,25%,,,,,,],[Sponsors' Required Return,,25%,,,,,,],[Flow to Equity Valuation Analysis],[,2021,2022E,2023E,2024E,2025E,2026E,2027E,],[Revenue,$5,077.48,$6,346.85,,,,,,],[EBITDA,,,,,,,,],[Depreciation and Amortization],[{
\table[[Earnings before Interest and Taxes],[Interest Expense]]}],[],[Earnings before Taxes],[{
\table[[Taxes],[Net Income]]}],[],[Capital Expenditures],[Change in NWC],[Cash Flow Available to Repay Debt],[{
\table[[Debt Draw Down / Repayment],[Cash Flow to Fauitv]]}],[],[\table[[Cash Flow to Equity],[Terminal Value]]],[Terminal Value of Equity],[{
\table[[Cash Flow to Equity with TVE and Initial Equity],[PV of Equitv (@25%)]]}],[],[Excess Cash ^(*****)],[Enterprise Value],[{
\table[[Implied share price],[Snonsor and Musk's Five-Year IRR]]}],[],[Interest Coverage (EBITDA/Interest)],[Total Debt / EBITDA,,,,,,,,],[\table[[(EBITDA - CAPEX)/ Interest],[Expense]],,,,,,,,]]
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808

Students also viewed these Finance questions