Answered You can buy a ready-made answer or pick a professional tutor to order an original one.
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
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.
- Download the company's financial statements. (ATTACHED)
- 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). 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.
- 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.
- Perform the Horizontal and Vertical Analysis of the Balance Sheet and Income Statement and Prepare a Written Analysis.
- 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.
- 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 company’s 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?
- Submit all of your files to this assignment area.
- @
- 5233 orders completed
- ANSWER
-
Tutor has posted answer for $50.00. See answer's preview
***************************************************************************************************************************************************************************************************************************************************************************************