Reference no: EM133205969

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). 

1. 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.
2. 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.