Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

34 analyats publishing on Microsoft's shares, the following is the consensus estimate. These are NeW numbers not the Bullish or Bcarsh fgures you used in

image text in transcribed
34 analyats publishing on Microsoft's shares, the following is the consensus estimate. These are NeW numbers not the Bullish or Bcarsh fgures you used in the prlor Assignments. rest Please change all the numbers so that vou arrive at the figures below. This is a aew problem. Je the SFAM is Model to build a forecast for 20206 and 2021 E that meet the consensus. Hints: First, adjust the Revenue growth ratein the SFAM moded that sets the Revenues to match the consersus. (Remember the consensas above is in SBillions and the SFAM model is expressed in SMilions) Secend, alter the figures for RE D and SGSA until the EPS matches the consenwus forecast. Do not touch any of the other variables in the model. What is your ceit forecast in Sts for 2020C ? (This means you should enter 510 ' for $10 billion.) What is your EerT forecast in Ses for 2021r ? What revenue erowth rate would you expect to iee for 2022R Save your consensus forecast in the 'income Statement (GAAP)' Sheet as we will use it in the next case

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

How To Understand Business Finance

Authors: Bob Cinnamon, Brian Helweg-Larsen

2nd Edition

0749460202, 978-0749460204

More Books

Students also viewed these Finance questions

Question

Explain the concept called liability of newness.

Answered: 1 week ago