Locate and analyze your company’s Form 10-K, for the last 3 years. This document is located on the company’s website under Investor Relations. Prepare the following requirements as individual worksheets within an Excel spreadsheet:
Horizontal analysis of the prior 3 years’ income statements and balances sheet.
Vertical analysis of the prior 3 years’ income statements and balance sheets.
In a summary of 500-750 words, you will analyze the financial strengths and weaknesses of the company you are examining, based on the results of the horizontal and vertical analyses Your analysis should be more than just a restatement of the results of the ratios. The analysis should provide some possible reasons for why the ratios increased or decreased over the last 3 years. Consider the relationships between the types of accounts and correlations that should (or should not) occur. This section will be included as supplemental schedules to the analysis you completed in Topic 2, in your final project.
Your submission will consist of two items for this assignment:
An Excel file with separate tabs for the horizontal and vertical analyses.
A Word document with your analysis summary.
While APA style is not required for the body of this assignment, solid academic writing is expected, any documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center.
Refer to “Annual Report Project – Section 3 Rubric” prior to beginning the assignment to become familiar with the expectations for successful completion.
You are required to submit this assignment to LopesWrite. Refer to the LopesWrite Technical Support articles for assistance.