Use the EDGAR | Company Filings or Yahoo! Finance database to download the last 10-Q from Starbucks into Excel. Use th

[answerhappygod]

Use the EDGAR | Company
Filings or Yahoo!
Finance database to download the last 10-Q from
Starbucks into Excel. Use the downloaded data to complete the
Income Statement and Balance Sheet on the appropriate tabs in
the Financial Forecasting Template. Assume the
following:
Calculate the expenses to determine what will change and what
will remain the same.
Note: Not all costs are associated with
the cost of sales. It will be up to you to determine which line
items need to be increased and which ones need to be left alone.
This will require you to distinguish between fixed and variable
costs. For a reminder of the difference between fixed and variable
costs, please watch the video Business Costs (Fixed Costs
and Variable Costs) Explained (Links to an external
site.).
Within each line item expense explain your rationale, as well as
provide a brief summary.
Part 2
Then, calculate a quarterly variance analysis using the Variance
Analysis tab of the Financial Forecasting
Template (the same template you used for Part 1).
Complete the following in your variance analysis: