Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

Linear Algebra And Its Applications

Authors: David Lay, Steven Lay, Judi McDonald

6th Global Edition

9781292351216

Students also viewed these Accounting questions