Exhibit 10: Morgan Stanley's Cash Flow Forecasts and Valuation Assumptions for Snap Inc. ($ millions) Item...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Exhibit 10: Morgan Stanley's Cash Flow Forecasts and Valuation Assumptions for Snap Inc. ($ millions) Item Income Statement Net Revenue Growth Adj. EBITDA (Note 1) Adj. EBITDA Margin Cash Flow Items Cash Taxes Incr (Decr) in Net WC Capital Expenditures Stock-based Comp. Free Cash Flow Tax Rate Cost of Equity 2016Act Equity Risk Premium Stated WACC $405 589.5% ($459) (113.6%) $0 Morgan Stanley Valuation Assumptions Cost of Debt Future Leverage (D/V) $151 $67 $0 $257 $83 $32 $75 ($709) ($1,186) 2017 3.00% 2% 35% 9.90% 5.59% 9.7% 2018 $944 $1,935 $3,254 133.3% 105.0% 68.2% ($195) (6.0%) ($772) ($610) (81.8%) (31.5%) 2019 $0 $0 $228 $231 $97 $109 $159 $203 ($1,093) ($737) Financial Forecast ($ millions) 2020 $4,902 $6,907 50.6% $363 7.4% $0 $228 $120 $257 ($243) 2021 # Fully Diluted Shares (millions) Excess Cash ($ mil) Perpetual Growth Rate $0 $209 $130 $317 $818 $9,189 $11,635 $14,131 $16,569 40.9% 33.0% 26.6% 21.4% 17.3% $1,474 $2,616 $3,888 $5,223 $6,574 21.3% 28.5% 37.0% 39.7% 33.4% 1,404 $2,081 2022 3.5% 2023 2024 $0 $823 $224 $207 $140 $155 $421 $533 $648 $1,831 $2,958 $3,390 $0 $248 $148 2025 Source: Nowak, B., et al., "Crackle or Pop? Initiate OW, $28 PT," Snap Inc. analyst report Exhibit 5 (p. 7), Morgan Stanley Research, 3/27/17. Note 1: Adjusted EBITDA is a non-GAAP item. It excludes stock-based compensation expense (a cash expense), but includes depreciation and amortization. $1,448 $151 $161 $759 $4,054 Market Data (March 27, 2017) US Treasury Yields 30-Year 10-Year 27-Mar 3.06% 2.38% Note 2: Morgan Stanley Equity Research Disclosure: Morgan Stanley does and seeks to do business with companies covered in Morgan Stanley Research. As a result, investors should be aware that the firm may have a conflict of interest that could affect the objectivity of Morgan Stanley Research. (p. 1 of the Snap Inc. analyst report, 3/27/17). Note 3: Morgan Stanley Code of Conduct: Our values inform everything we do: Putting Clients First, Leading with Exceptional Ideas, Doing the Right Thing and Giving Back. Our Code of Conduct reflects our continued commitment to performing all our business activities in accordance with these core values and in full alignment with the letter and spritit of applicable laws, regulations and our policies... Putting Clients First requires us to place our clients' interests first and avoid conflicts between their interests and ours. Available at https://www.morganstanley.com/about-us-governance/code-of-conduct, accessed 3/18/18. Year 2026 Used Only to Calculate TV $17,149 3.5% $6,804 39.7% $4,196 c. The free cash flow forecast in general and Snap's 2020 revenue forecast in particular. (15 points) What growth rates does the FCF forecast assume for revenue? (Hint: not terminal value but the first years of FCF) - - Discuss how Nowak's report argues that Snap will accomplish this growth. - In your opinion, is this growth rate reasonable? Discuss why. - How does the revenue forecast compare against what other analysts have predicted? - Did the analysts with more optimistic FCF forecasts use higher or lower discount rates? (Show a table as well as discuss) - Does this explain why the price target estimates by the different analysts was fairly close even though they had very different FCF forecasts? Explain. Exhibit 10: Morgan Stanley's Cash Flow Forecasts and Valuation Assumptions for Snap Inc. ($ millions) Item Income Statement Net Revenue Growth Adj. EBITDA (Note 1) Adj. EBITDA Margin Cash Flow Items Cash Taxes Incr (Decr) in Net WC Capital Expenditures Stock-based Comp. Free Cash Flow Tax Rate Cost of Equity 2016Act Equity Risk Premium Stated WACC $405 589.5% ($459) (113.6%) $0 Morgan Stanley Valuation Assumptions Cost of Debt Future Leverage (D/V) $151 $67 $0 $257 $83 $32 $75 ($709) ($1,186) 2017 3.00% 2% 35% 9.90% 5.59% 9.7% 2018 $944 $1,935 $3,254 133.3% 105.0% 68.2% ($195) (6.0%) ($772) ($610) (81.8%) (31.5%) 2019 $0 $0 $228 $231 $97 $109 $159 $203 ($1,093) ($737) Financial Forecast ($ millions) 2020 $4,902 $6,907 50.6% $363 7.4% $0 $228 $120 $257 ($243) 2021 # Fully Diluted Shares (millions) Excess Cash ($ mil) Perpetual Growth Rate $0 $209 $130 $317 $818 $9,189 $11,635 $14,131 $16,569 40.9% 33.0% 26.6% 21.4% 17.3% $1,474 $2,616 $3,888 $5,223 $6,574 21.3% 28.5% 37.0% 39.7% 33.4% 1,404 $2,081 2022 3.5% 2023 2024 $0 $823 $224 $207 $140 $155 $421 $533 $648 $1,831 $2,958 $3,390 $0 $248 $148 2025 Source: Nowak, B., et al., "Crackle or Pop? Initiate OW, $28 PT," Snap Inc. analyst report Exhibit 5 (p. 7), Morgan Stanley Research, 3/27/17. Note 1: Adjusted EBITDA is a non-GAAP item. It excludes stock-based compensation expense (a cash expense), but includes depreciation and amortization. $1,448 $151 $161 $759 $4,054 Market Data (March 27, 2017) US Treasury Yields 30-Year 10-Year 27-Mar 3.06% 2.38% Note 2: Morgan Stanley Equity Research Disclosure: Morgan Stanley does and seeks to do business with companies covered in Morgan Stanley Research. As a result, investors should be aware that the firm may have a conflict of interest that could affect the objectivity of Morgan Stanley Research. (p. 1 of the Snap Inc. analyst report, 3/27/17). Note 3: Morgan Stanley Code of Conduct: Our values inform everything we do: Putting Clients First, Leading with Exceptional Ideas, Doing the Right Thing and Giving Back. Our Code of Conduct reflects our continued commitment to performing all our business activities in accordance with these core values and in full alignment with the letter and spritit of applicable laws, regulations and our policies... Putting Clients First requires us to place our clients' interests first and avoid conflicts between their interests and ours. Available at https://www.morganstanley.com/about-us-governance/code-of-conduct, accessed 3/18/18. Year 2026 Used Only to Calculate TV $17,149 3.5% $6,804 39.7% $4,196 c. The free cash flow forecast in general and Snap's 2020 revenue forecast in particular. (15 points) What growth rates does the FCF forecast assume for revenue? (Hint: not terminal value but the first years of FCF) - - Discuss how Nowak's report argues that Snap will accomplish this growth. - In your opinion, is this growth rate reasonable? Discuss why. - How does the revenue forecast compare against what other analysts have predicted? - Did the analysts with more optimistic FCF forecasts use higher or lower discount rates? (Show a table as well as discuss) - Does this explain why the price target estimates by the different analysts was fairly close even though they had very different FCF forecasts? Explain.
Expert Answer:
Answer rating: 100% (QA)
Free Cash Flow FCF Forecast and Snaps 2020 Revenue Forecast Growth Rates in FCF Forecast for Revenue The FCF forecast assumes varying growth rates for ... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1285190907
8th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these finance questions
-
Problem 1 (Normal Continuous Spoilage Using Weighted Average Method) Mio Chemical Inc. uses process costing system with weighted average cost flow assumption to account for the production of its only...
-
IRR Project L costs $48,245.13, its expected cash inflows are $11,000 per year for 8 years, and its WACC is 13%. What is the project's IRR? Round your answer to two decimal places. % MIRR Project L...
-
Use the attached "words.txt" file to store the words along with their ranks in an AVL tree. Then provide the user the option to search for any word. If the word exists the program displays the rank...
-
A railroad flatcar is traveling to the right at a speed of 13.0 m/s relative to an observer standing on the ground. Someone is riding a motor scooter on the flatcar (Fig. 3.43). What is the velocity...
-
Consider the model Yi = B1 + B2Xi + B3X2i + B4X3i + ui where Y = the total cost of production and X = the output. Since X2 and X3 are functions of X, there is perfect collinearity. Do you agree? Why...
-
The cascade reactor control configuration shown in Fig. 16.3 utilizes a measurement of the cooling water temperature. It has been suggested that the temperature of the reactor wall be measured to...
-
Develop a brief answer for each of the following questions: 1. When would the disposal of a long-term asset result in no gain or loss? 2. When would annual depletion not equal depletion expense? 3....
-
During its first year of operation, Lux Company purchased 5,600 units of a product at $42 per unit. During the second year, it purchased 6,000 units of the same product at $48 per unit. During the...
-
Shrs19mins X Progress sa ents Score: 0/120 0/30 answered Question 25
-
In about 300 words, explain how incubators and accelerators work. In your answer, compare these two approaches and provide at least one example of each.
-
A common law system is different from a civil law system because: a common law system is very rigid, while a civil law system tends to be more flexible. in a common law system a judge relies on legal
-
Indicate whether each of the following accounts normally has a debit balance or a credit balance. a. Unearned Revenue b. Service Revenue c. Dividends d. Land e. Accounts Receivable f. Cash g. Common...
-
During the last week of 2017, George Green, controller of We 'R' Appliances, received a memorandum from the firm's president, Jane Anderson. The memorandum stated that Anderson had negotiated a very...
-
Pick Corporation started business on January 1, 2019. The following information was compiled by Pick's accountant on December 31, 2019: Required a. You have been asked to assist the accountant for...
-
Match each of the items in the left column with the appropriate annual report component from the right column: 1. The company's total assets a. Income Statement 2. An opinion regarding whether the...
-
The text used Figure 6-3 to describe fluctuations in the spreads between riskless rate on 10-year US Treasury bonds and 10-year AAA and BBB corporate bonds. This figure can be updated by going to the...
-
Which step in the process of measuring external transactions involves determining the effect on assets, liabilities, and stockholders' equity? Multiple Choice Use source documents to determine...
-
At Glass Company, materials are added at the beginning of the process and conversion costs are added uniformly. Work in process, beginning: Number of units Transferred - in costs Direct materials...
-
Presented below are excerpts from Note 1 to Starbucks' September 30, 2012, consolidated financial statements in which Starbucks describes accounting policy for long-lived assets. a. Leasehold...
-
Problem 13.18 and Exhibit 13.7 in Chapter 13 present selected hypothetical data from projected financial statements for Steak 'n Shake for Year +1 to Year +11. The amounts for Year +11 reflect a...
-
Royal Dutch Shell is a petroleum and petrochemicals company. It engages primarily in the exploration, production, and sale of crude oil and natural gas and the manufacture, transportation, and sale...
-
In the formation stages of a project, are there any distinct advantages to using xPM over APF for an extreme project? If so, identify them.
-
In the formation stages of a project, are there any distinct disadvantages to using APF over xPM for an extreme project? If so, identify them. In considering your answer, think about what is really...
-
As a class exercise, identify three xPM projects and write the POS for one of them.
Study smarter with the SolutionInn App