In this lab, you will:
Required:
1. Using Excel’s Forecast Sheet, forecast future sales for Microsoft.
2. Using Excel’s Forecast Sheet, forecast future income before extraordinary items for Microsoft.
Ask the Question: What will Microsoft’s quarterly sales and earnings for 2018 and 2019 be given times series (past quarterly sales and earnings from 2010–2017)?
Master the Data: Looking at Microsoft’s financial statements, we accumulate the values of quarterly sales and earnings from 2010–2017.
Software needed
• Excel
• Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)
Data: Excel File Lab 8-6 Alt Data.xlsx.
Perform the Analysis: Refer to Lab 8-6 Alternate in the text for instructions and Lab 8-6 steps for each of the lab parts.
Share the Story: We have now developed a forecast for sales and income before extraordinary items.
Required:
1. Which has a greater distance between the lower and upper confidence bound for Microsoft?
multiple choice 1
• Sales
• Income before extraordinary items
2. For Microsoft’s income before extraordinary items and the quarter 7/1/2020, what is the distance between the lower and upper confidence bound?
multiple choice 2
• 11,611.28
• 365.50
• 10,880.30
• No difference between lower and upper confidence bound
3. What is the forecasted amount of Microsoft’s income from extraordinary items for the 10/1/2019 time period?
multiple choice 3
• 5,364.64
• 31,546.71
• 5,440.15
• 5,326.88
4. What is the forecasted amount of Microsoft’s sales for the 10/1/2019 time period?
multiple choice 4
• 31,546.71
• 5,326.88
• 27,744.51
• 29,440.27
5. Looking at the past trend of sales or income before extraordinary items for Microsoft, which one was less volatile, sales or income before extraordinary items?
multiple choice 5
• Income Before Extraordinary Items
• Sales
No comments:
Post a Comment