Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Considering above information, are the assumption used by Morgan 1) WACC=9.7% b)TVGR=3.5% c) forecast of FCF and 2020's revenue forecase reasonable? 2016 Advertising Revenue Drivers

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Considering above information, are the assumption used by Morgan 1) WACC=9.7% b)TVGR=3.5% c) forecast of FCF and 2020's revenue forecase reasonable?

2016 Advertising Revenue Drivers Snap Instagram Facebook Twitter 129 0.15 Daily Average Users (DAU, in millions) X Hours per DAU per Day X Ads per DAU per Hour X Average Pricing ($ per 1K impressions) X 365 Days per Year Advertising Revenue ($ mil) Avg. Revenue per DAU (ARPU) 158 0.42 0.6 $26 365 345 0.36 6.6 $6 365 $1,795 $5.20 1,227 0.58 48.6 $2 365 $25,118 $20.47 104.3 $3 365 $2,254 $17.47 $378 $2.39 Exhibit 9 Summary of Analyst Assumptions and Forecasts for Snap in 2020 (see Note 1 below) Analyst(s) From Price Target Discount Rate WACC TV Growth Rate Analyst Forecast for 2020 Free Cash Revenue DAU ARPU Flow (FCF) Report Date n/a Independent Firms Pivotal Aegis Capital Susquehanna FBN Cantor Piper Jaffray 2-Mar-17 2-Mar-17 3-Mar-17 9-Mar-17 14-Mar-17 22-Mar-17 $10 $22 $22 $23 $18 $23 12.0% 13.4% n/a 10.3% 12.0% 10.7% 6.0% 3.0% n/a 4.5% 4.0% (2.0%) $3,863 $4,500 n/a $4,816 $6,248 $6,396 n/a 250 280 369 346 289 n/a $21.24 $14.09 $18.92 $22.41 ($178) $605 $357 ($592) $398 $253 27-Mar-17 $28 9.7% 3.5% $4,902 236 $20.72 ($243) 27-Mar-17 27-Mar-17 27-Mar-17 $24 $30 $30 13.0% 15.7% 3.5% n/a 3.0% $6,808 $5,126 $4,634 299 272 $21.30 $18.06 $17.02 $1,026 $1,275 $351 11.0% 281 Lead Underwriter Morgan Stanley Lead Managers JP Morgan Deutsche Bank Credit Suisse Other Underwriters Cowen & Co JMP Securities Oppenheimer RBC Capital UBS William Blair 27-Mar-17 27-Mar-17 27-Mar-17 27-Mar-17 27-Mar-17 27-Mar-17 $26 $28 range $31 $24 range 10.0% 15.0% n/a 11.0% 18.0% 10.0% n/a n/a n/a 5.0% n/a n/a $5,204 $4,965 $5,649 $4,621 $5,269 $4,654 289 n/a 281 n/a 332 n/a $18.16 n/a $18.89 n/a $16.70 n/a $351 $634 $953 $391 $442 n/a Average Median Maximum Minimum Standard Deviation Coeff. of Variation (note 2) $24.2 $24.0 $31.0 $10.0 $5.5 0.23 12.3% 11.5% 18.0% 9.7% 2.5% 0.20 3.4% 3.5% 6.0% (2.0%) 2.2% 0.66 $5,177 $4,965 $6,808 $3,863 $795 0.15 293.7 285.1 369.0 236.0 38.3 0.13 $18.86 $18.89 $22.41 $14.09 $2.44 0.13 $402 $391 $1,275 ($592) $487 1.21 Exhibit 11 Assumptions Used by Morgan Stanley for Internet Stocks and Other Market Data Morgan Stanley Reports Report Date WACC 3/27/2018 9.7% Equity Betas to 3/1/17 1 Year 2 Years Daily Weekly Financial Data on 12/31/16 (Smil) Debt at Equity at Book Market Cash Value Value Company Snap Inc. Alphabet Amazon eBay Etsy Facebook Groupon GrubHub Linkedin (a) Priceline Group Twitter Yelp Zynga 3/23/2017 1/18/2017 1/19/2017 3/1/2017 2/2/2017 2/16/2017 2/8/2017 4/29/2016 2/28/2017 2/9/2017 11/3/2016 1/19/2017 8.0% 7.5% 6.3% 8.1% 8.6% 8.2% 8.5% 9.1% 8.0% 6.3% 8.3% 9.0% 0.99 0.97 1.31 1.57 0.86 1.95 1.48 n/a 1.45 0.91 1.63 1.18 1.34 1.30 1.38 2.32 1.12 2.08 1.13 n/a 1.33 1.71 1.46 1.22 $12,918 $3,935 $19,334 $20,413 $1,816 $8,960 $182 $12 $8,903 $0 $863 $228 $240 $0 n/a n/a $2,081 $7,169 $989 $1,687 $272 $0 $852 $o $539,070 $356,313 $33,191 $1,361 $331,594 $1,896 $3,220 n/a $72,343 $11,563 $2,992 $2,292 Average Median 8.0% 8.2% 1.30 1.31 1.49 1.34 Exhibit 11 Assumptions Used by Morgan Stanley for Internet Stocks and Other Market Data Morgan Stanley Reports Report Date WACC 3/27/2018 9.7% Equity Betas to 3/1/17 1 Year 2 Years Daily Weekly Financial Data on 12/31/16 (Smil) Debt at Equity at Book Market Cash Value Value Company Snap Inc. Alphabet Amazon eBay Etsy Facebook Groupon GrubHub Linkedin (a) Priceline Group Twitter Yelp Zynga 3/23/2017 1/18/2017 1/19/2017 3/1/2017 2/2/2017 2/16/2017 2/8/2017 4/29/2016 2/28/2017 2/9/2017 11/3/2016 1/19/2017 8.0% 7.5% 6.3% 8.1% 8.6% 8.2% 8.5% 9.1% 8.0% 6.3% 8.3% 9.0% 0.99 0.97 1.31 1.57 0.86 1.95 1.48 n/a 1.45 0.91 1.63 1.18 1.34 1.30 1.38 2.32 1.12 2.08 1.13 n/a 1.33 1.71 1.46 1.22 $12,918 $3,935 $19,334 $20,413 $1,816 $8,960 $182 $12 $8,903 $0 $863 $228 $240 $0 n/a n/a $2,081 $7,169 $989 $1,687 $272 $0 $852 $o $539,070 $356,313 $33,191 $1,361 $331,594 $1,896 $3,220 n/a $72,343 $11,563 $2,992 $2,292 Average Median 8.0% 8.2% 1.30 1.31 1.49 1.34 2016 Advertising Revenue Drivers Snap Instagram Facebook Twitter 129 0.15 Daily Average Users (DAU, in millions) X Hours per DAU per Day X Ads per DAU per Hour X Average Pricing ($ per 1K impressions) X 365 Days per Year Advertising Revenue ($ mil) Avg. Revenue per DAU (ARPU) 158 0.42 0.6 $26 365 345 0.36 6.6 $6 365 $1,795 $5.20 1,227 0.58 48.6 $2 365 $25,118 $20.47 104.3 $3 365 $2,254 $17.47 $378 $2.39 Exhibit 9 Summary of Analyst Assumptions and Forecasts for Snap in 2020 (see Note 1 below) Analyst(s) From Price Target Discount Rate WACC TV Growth Rate Analyst Forecast for 2020 Free Cash Revenue DAU ARPU Flow (FCF) Report Date n/a Independent Firms Pivotal Aegis Capital Susquehanna FBN Cantor Piper Jaffray 2-Mar-17 2-Mar-17 3-Mar-17 9-Mar-17 14-Mar-17 22-Mar-17 $10 $22 $22 $23 $18 $23 12.0% 13.4% n/a 10.3% 12.0% 10.7% 6.0% 3.0% n/a 4.5% 4.0% (2.0%) $3,863 $4,500 n/a $4,816 $6,248 $6,396 n/a 250 280 369 346 289 n/a $21.24 $14.09 $18.92 $22.41 ($178) $605 $357 ($592) $398 $253 27-Mar-17 $28 9.7% 3.5% $4,902 236 $20.72 ($243) 27-Mar-17 27-Mar-17 27-Mar-17 $24 $30 $30 13.0% 15.7% 3.5% n/a 3.0% $6,808 $5,126 $4,634 299 272 $21.30 $18.06 $17.02 $1,026 $1,275 $351 11.0% 281 Lead Underwriter Morgan Stanley Lead Managers JP Morgan Deutsche Bank Credit Suisse Other Underwriters Cowen & Co JMP Securities Oppenheimer RBC Capital UBS William Blair 27-Mar-17 27-Mar-17 27-Mar-17 27-Mar-17 27-Mar-17 27-Mar-17 $26 $28 range $31 $24 range 10.0% 15.0% n/a 11.0% 18.0% 10.0% n/a n/a n/a 5.0% n/a n/a $5,204 $4,965 $5,649 $4,621 $5,269 $4,654 289 n/a 281 n/a 332 n/a $18.16 n/a $18.89 n/a $16.70 n/a $351 $634 $953 $391 $442 n/a Average Median Maximum Minimum Standard Deviation Coeff. of Variation (note 2) $24.2 $24.0 $31.0 $10.0 $5.5 0.23 12.3% 11.5% 18.0% 9.7% 2.5% 0.20 3.4% 3.5% 6.0% (2.0%) 2.2% 0.66 $5,177 $4,965 $6,808 $3,863 $795 0.15 293.7 285.1 369.0 236.0 38.3 0.13 $18.86 $18.89 $22.41 $14.09 $2.44 0.13 $402 $391 $1,275 ($592) $487 1.21 Exhibit 11 Assumptions Used by Morgan Stanley for Internet Stocks and Other Market Data Morgan Stanley Reports Report Date WACC 3/27/2018 9.7% Equity Betas to 3/1/17 1 Year 2 Years Daily Weekly Financial Data on 12/31/16 (Smil) Debt at Equity at Book Market Cash Value Value Company Snap Inc. Alphabet Amazon eBay Etsy Facebook Groupon GrubHub Linkedin (a) Priceline Group Twitter Yelp Zynga 3/23/2017 1/18/2017 1/19/2017 3/1/2017 2/2/2017 2/16/2017 2/8/2017 4/29/2016 2/28/2017 2/9/2017 11/3/2016 1/19/2017 8.0% 7.5% 6.3% 8.1% 8.6% 8.2% 8.5% 9.1% 8.0% 6.3% 8.3% 9.0% 0.99 0.97 1.31 1.57 0.86 1.95 1.48 n/a 1.45 0.91 1.63 1.18 1.34 1.30 1.38 2.32 1.12 2.08 1.13 n/a 1.33 1.71 1.46 1.22 $12,918 $3,935 $19,334 $20,413 $1,816 $8,960 $182 $12 $8,903 $0 $863 $228 $240 $0 n/a n/a $2,081 $7,169 $989 $1,687 $272 $0 $852 $o $539,070 $356,313 $33,191 $1,361 $331,594 $1,896 $3,220 n/a $72,343 $11,563 $2,992 $2,292 Average Median 8.0% 8.2% 1.30 1.31 1.49 1.34 Exhibit 11 Assumptions Used by Morgan Stanley for Internet Stocks and Other Market Data Morgan Stanley Reports Report Date WACC 3/27/2018 9.7% Equity Betas to 3/1/17 1 Year 2 Years Daily Weekly Financial Data on 12/31/16 (Smil) Debt at Equity at Book Market Cash Value Value Company Snap Inc. Alphabet Amazon eBay Etsy Facebook Groupon GrubHub Linkedin (a) Priceline Group Twitter Yelp Zynga 3/23/2017 1/18/2017 1/19/2017 3/1/2017 2/2/2017 2/16/2017 2/8/2017 4/29/2016 2/28/2017 2/9/2017 11/3/2016 1/19/2017 8.0% 7.5% 6.3% 8.1% 8.6% 8.2% 8.5% 9.1% 8.0% 6.3% 8.3% 9.0% 0.99 0.97 1.31 1.57 0.86 1.95 1.48 n/a 1.45 0.91 1.63 1.18 1.34 1.30 1.38 2.32 1.12 2.08 1.13 n/a 1.33 1.71 1.46 1.22 $12,918 $3,935 $19,334 $20,413 $1,816 $8,960 $182 $12 $8,903 $0 $863 $228 $240 $0 n/a n/a $2,081 $7,169 $989 $1,687 $272 $0 $852 $o $539,070 $356,313 $33,191 $1,361 $331,594 $1,896 $3,220 n/a $72,343 $11,563 $2,992 $2,292 Average Median 8.0% 8.2% 1.30 1.31 1.49 1.34

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Acct 2302 Managerial Accounting

Authors: Fred Phillips Stacey Whitecotton, Robert Libby

1st Edition

1259135624, 978-1259135620

More Books

Students also viewed these Accounting questions

Question

a. How do you think these stereotypes developed?

Answered: 1 week ago

Question

7. Describe phases of multicultural identity development.

Answered: 1 week ago