Answered step by step
Verified Expert Solution
Question
1 Approved Answer
of 34 analysts publishing on Microsoft's shares, the following is the consensus estimate. High Mean 152.0 142.2 5.66 6.00 Low 2020E Revenues $B 139.4 EPS
of 34 analysts publishing on Microsoft's shares, the following is the consensus estimate. High Mean 152.0 142.2 5.66 6.00 Low 2020E Revenues $B 139.4 EPS 5.46 2021E Revenues $B 153.2 EPS 5.52 Source: CNN Money, 3/16/20 168.7 159.7 6.30 7.11 Use the SFAM IS Model to build a forecast for 2020E and 2021E that meet the consensus. Hints: First, adjust the Revenue growth rate in the SFAM model that sets the Revenues to match the consensus. (Remember the consensus above is in $Billions and the SFAM model is expressed in $Millions.) Second, alter the figures for R&D and SG&A until the EPS matches the consensus forecast. Do not touch any of the other variables in the model. What is your EBIT forecast in $Bs for 2020E? (This means you should enter '10' for $10 billion.) 40 Nhat is your ecast in $Bs for 2021E? 48 52 What revenue growth rate would you expect to see for 2022E
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started