Overview:In the discussion this week, you selected a publicly traded company to research. In this Financial Analysis assignment, you will obtain the company’s financial statements to develop a company

by


Overview:In the discussion this week, you selected a publicly traded company to research. In this Financial Analysis assignment, you will obtain the company’s financial statements to develop a company trend and common-size analysis as well as obtain the Statement of Cash Flows. Instructions:Using the company that you chose in this week’s Discussion, develop a company trend and common-size analysis using the Mergent Database and Excel. 

  1. Download the company’s financial statements. (ATTACHED)
    1. Download the Mergent Online Database Instructions.docx (link located under the assignment title above).
    2. Follow the step-by-step instructions in the Mergent Online Database Instructions document to select your company and download their financial statements from the Mergent Online database.   
  2. Review Horizontal and Vertical Analysis for Balance Sheet and Income Statement.
    1. Download and complete the steps on the Module 1 Assignment 1 – Company Financial Analysis – Part 1 – Balance Sheet (Horizontal Analysis) document (link located under the assignment title above). Use your company’s two most recent years, as the example is dated. 
      • Remember that Horizontal analysis is used to evaluate trends in the financial condition of an organization. 
    2. Download and complete the steps on the Module 1 Assignment 1 – Company Financial Analysis – Part 1 – Income Statement (Vertical Analysis) document (link located under the assignment title above). Use your company’s two most recent years, as the example is dated. 
      • Remember that Vertical analysis is used to detect items that are out of line, that deviate from a predetermined amount, or that are indicative of other problems. 
    3. Perform the Horizontal and Vertical Analysis of the Balance Sheet and Income Statement and Prepare a Written Analysis. 
  3. For the Statement of Cash Flows, you will analyze the information presented in the Statement.
    1. Obtain the Statement of Cash Flows that you saved from Mergent.
    2. The Statement of Cash Flows is broken out into three areas: Operating Activities, Investing Activities, and Financing Activities.
    3. How did your company’s use of cash differ in operating activities from year-to-year?
    4. What are the sources and uses of cash in both investing and financing activities? 
  4. Submit all of your files to this assignment area.