Order from us for quality, customized work in due time of your choice.
The purpose of this assignment is to prepare a vertical and horizontal common-si
The purpose of this assignment is to prepare a vertical and horizontal common-size analysis.
Financial statement analysis requires the analyst to utilize calculation tools, such as horizontal, vertical, and ratio analysis. Interpretation of the ratio analysis allows the analyzer to observe changes in revenue over time.
For your assignment, locate and review the last 4 years of the annual report of the company selected for your Financial Statement Analysis Report (Starbucks). This document is located on the company′s website under Investor Relations. Prepare a vertical and horizontal analysis in the Balance Sheet and Income Statement tabs of the ″Financial Statement Report Excel Spreadsheet″ (FSAR Excel Spreadsheet) provided in the Class Resources. The spreadsheet will serve as a guideline for completing the assignment, the actual sections or order of reporting from the company′s annual report may vary. Complete only the applicable sections based on the information provided in the company′s annual report.
Complete the horizontal analysis column of the prior 3 years
Complete the vertical analysis column for the prior 3 years
Address the following questions in the comments section of both the Balance Sheet and Income Statement tabs:
Identify which accounts had a large magnitude of change of 10% or more.
Identify which accounts changed for the period and explain how this affected the financial analysis calculation.
Explain why the account changed during the period, what business decisions may have caused the change, and how these changes impacted company performance.
The CLC group will submit the FSAR Excel Spreadsheet with the analyzed data for the selected company. To earn full credit on this assignment, the group must show detailed work in Excel, which includes providing the formulas and comments in the cells, not just the summary value.
APA style is not required, but solid academic writing is expected.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
You are not required to submit this assignment to LopesWrite.
Order from us for quality, customized work in due time of your choice.