Assignment2_AdvCorpFinance

.xlsx

School

Western University *

*We aren’t endorsed by this school

Course

5100

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

18

Uploaded by BarristerIceBadger32

Report
This spreadsheet su analyzed by Victoria
upports the analysis of the case "Spotify Direct-Listing IPO" as a Chambers, Corey Wheaton, Breena T'ien, Hartley Shapiro and Austin Krausert
Spotify Direct Listing General First year of forecast in financial model: 2018 10-year cash flow model discounted to December 31, 2017 Expense Growth Rate 10% Cost Inflation 18% Net Debt 467 Depreciation ### Revenue Growth Rates Year Growth Rate 2018 25% 2019 25% 2020 25% 2021 25% 2022 25% 2023 20% 2024 15% 2025 11% 2026 8% 2027 5% Valuation - Market Risk Premium 5% - Shares outstanding (Millions) 178.11 - Share Price 148.4 The terminal value growth rate is 1.5% to 3.0% Taxes - No taxes paid through 2022 - Tax rate after 2022 25%
g - IPO
Valuation - Market Risk Premium 5.0% - Beta without tax 13.86 - Beta with tax 14.13 - Shares outstanding (Millions) 178.11 - Risk-free 2.85% - Cost of Equity without tax 0.72 - Cost of Equity with tax 0.73 TAKE 2 Without Tax Company 5 yr Beta LTM EBITDA otal Enterprise Valu Alibaba 2.58 14,222.70 456,971.0 Amazon 1.55 15,039 706,121.7 Apple 1.18 74,174 889,968.7 Baidu 1.77 4,362 68,388.2 Comcast 1.16 27,812 217,888.2 EBay 1.06 2,941 44,746.5 Facebook 0.66 23,228 402,841.3 Netflix 0.96 910.6 127,686.1 Pandora -0.4 -289 1,527.2 Walt Disney 1.31 16,912 174,522.2 Time Warner 0.92 9,081 94,621.0 Twenty-First Century F 1.26 6540 82,104.3 Twitter 0.8 344.8 18,675.1 Wayfair 1.27 -174.2 5,560.6 1.15 195,103.70 Spotify Unlevered B 1.06 Levered B 13.86 TAKE 2 With Tax Company 5 yr Beta LTM EBITDA otal Enterprise Valu Alibaba 2.58 14,222.70 456,971.0 Amazon 1.55 15,039 706,121.7 Apple 1.18 74,174 889,968.7 Baidu 1.77 4,362 68,388.2 Comcast 1.16 27,812 217,888.2 EBay 1.06 2,941 44,746.5 Facebook 0.66 23,228 402,841.3 Netflix 0.96 910.6 127,686.1 Pandora -0.4 -289 1,527.2 Walt Disney 1.31 16,912 174,522.2
Time Warner 0.92 9,081 94,621.0 Twenty-First Century F 1.26 6540 82,104.3 Twitter 0.8 344.8 18,675.1 Wayfair 1.27 -174.2 5,560.6 1.15 195,103.70 Spotify Unlevered B 1.08 Levered B 14.13
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help