Objectives The objectives of this assignment are to develop the ability to perform basic financial s

Objectives The objectives of this assignment are to develop the ability to perform basic financial s

Objectives

The objectives of this assignment are
to develop the ability to perform basic financial statement analysis and
effectively communicate your results.

Use the company’s (Starbucks) current Annual Report to get answers. Document Preview:

Part 2. Horizontal and Vertical Financial Statement Analysis with Explanatory Narrative.
General formatting requirements: Please construct visually attractive and easily readable worksheets. Round your calculated percentages to the nearest one tenth of one percent (e.g., 100.0%; 65.2%; 4.3%, etc).

Use Excel to prepare a horizontal and a vertical analysis of the following selected income statement components: Net revenues, gross profit, SG&A expenses, and Net Income. The specific terminology and classifications will vary somewhat across companies. Use the three most recent years’ income statement data to construct two horizontal income statement analyses and three vertical analyses.

From your company’s 10-K, locate management’s discussion and analysis of year-to-year financial and operating results to identify the main reasons for the changes, trends, and relationships in your horizontal and vertical spreadsheets. Organize your analysis under four headings: Net revenues; inventory and cost of sales; SG&A expenses;, and Net Income. Your narrative should require approximately three pages. In your narrative, please refer to the specific horizontal or vertical percentages you are explaining, describe more than one factor for each income component, identify relevant offsetting factors when applicable, and quantify the impact of those factors.

Print and attach a copy of each spreadsheet and a copy of the Excel formulas for each spreadsheet, for a total of four spreadsheet printouts. You may insert the spreadsheets directly into your Word file. Instructions for viewing and printing formulas in Excel:

Highlight area on spreadsheet
Select Tools, Select Options, Select View tab
Under Window Options, place a ( in the Formulas box
Print
To return to original document, repeat above steps and uncheck the Formulas box.

Alternatively, use Control and tilde (the ~ key just to the left of the #1 key) to toggle between original document and…

Attachments:

Looking for a similar assignment? Get help from our qualified experts!

Order Now

Related Posts