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 Download the company's financial statements Download the Mergent Online Database Instructions docx (link located under the assignment title above) 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 Review Horizontal and Vertical Analysis for Balance Sheet and Income Statement 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) Remember that Horizontal analysis is used to evaluate trends in the financial condition of an organization 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) 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 Perform the Horizontal and Vertical Analysis of the Balance Sheet and Income Statement and Prepare a Written Analysis For the Statement of Cash Flows, you will analyze the information presented in the Statement Obtain the Statement of Cash Flows that you saved from Mergent The Statement of Cash Flows is broken out into three areas Operating Activities, Investing Activities, and Financing Activities How did your companys use of cash differ in operating activities from year to year What are the sources and uses of cash in both investing and financing activities

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 06, 2024

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

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.

Download the company's financial statements.
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.
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).
  - 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).
  - 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.
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 companys 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?