Reference no: EM132281816
Use the annual report to find the total current assets and total current liabilities.
Compute the current ratio for previous two fiscal years
Review reports on data for the last two years.
Net Cash Flows from Operating Activities
Net Cash used by Investing Activities
Net Cash used by Financing Activities
Cash and Cash Equivalents at the end of the Years
Identify trends with an indication of if the financial statements show a positive or negative for the organization and investors.
Use Microsoft Excel to create at least three (3) graphical displays to show the trends (i.e., bar graph, pivot table, histogram, etc). You should include a copy of your graphs in the body of your report.
Part 2 Word Document Report
Discusses which year your chosen company appears to be in a stronger financial position and big differences between the 2 years (Keep in mind that dollar amounts in ( ) are negative or cash outflows).
Summarize your responses in a report using titles from the assignment requirements (i.e., assets and liabilities, cash flows/balance sheet, trends, financial position). This document will serve as your Financial Statements section of your project.
Attachment:- Cash Flow Statement.rar