50.1K

Verified Solution

Link Copied!

how do I do this I missed 2 weeks of class and have no clue what I am doing.

All cases of acadeMIE DISTU Part One Instructions The financial information for the past two years (2016 and 2017) is provided. Using a spreadsheet application, such as Microsoft Excel, and the information from the previous years, provide the following: 1. Prepare a Statement of Cash Flows for the current year using the indirect method. 2. Using horizontal analysis, prepare a Comparative Balance Sheet. 3. Using vertical analysis, prepare an Income Statement. 4. Using the textbook, calculate the ratios set out below: a. Current ratio both years b. Quick ratio both years c. Accounts Receivable Turnover 2017 d. Number of Days Sales in Receivables 2017 (Company policy states 30 days in receivables) Inventory Turnover 2017 Number of Days Sales in Inventory 2017 (Company policy states 50 days to turn over inventory) e. f. g. Ratio of Liabilities to Stockholders' Equity 2017 h. Return on Total Assets 2017 i. Return on Stockholders' Equity 2017 j. Earnings Per Share 2016 and 2017 The financial statements provided in this practice set can also be downloaded from Blackboard. An example of a Statement of Cash Flow has been provided at the end of the Practice Set. Download the Excel files (income Statement and Balance Sheet) from Blackboard and add a column and calculate the ratios for the vertical and horizontal analysis. Acting as an accounting advisor to the firm, prepare a memo in which you analyze the financial statements you prepared in step two and prepare an analysis of the company's financial position. Identify two strengths and two weaknesses in the company. Make two recommendations to improve the company's financial position. Be specific in each of the recommendations and use the ratios to support your analysis. The length should be no more than one page. 5. 21 Page All cases of acadeMIE DISTU Part One Instructions The financial information for the past two years (2016 and 2017) is provided. Using a spreadsheet application, such as Microsoft Excel, and the information from the previous years, provide the following: 1. Prepare a Statement of Cash Flows for the current year using the indirect method. 2. Using horizontal analysis, prepare a Comparative Balance Sheet. 3. Using vertical analysis, prepare an Income Statement. 4. Using the textbook, calculate the ratios set out below: a. Current ratio both years b. Quick ratio both years c. Accounts Receivable Turnover 2017 d. Number of Days Sales in Receivables 2017 (Company policy states 30 days in receivables) Inventory Turnover 2017 Number of Days Sales in Inventory 2017 (Company policy states 50 days to turn over inventory) e. f. g. Ratio of Liabilities to Stockholders' Equity 2017 h. Return on Total Assets 2017 i. Return on Stockholders' Equity 2017 j. Earnings Per Share 2016 and 2017 The financial statements provided in this practice set can also be downloaded from Blackboard. An example of a Statement of Cash Flow has been provided at the end of the Practice Set. Download the Excel files (income Statement and Balance Sheet) from Blackboard and add a column and calculate the ratios for the vertical and horizontal analysis. Acting as an accounting advisor to the firm, prepare a memo in which you analyze the financial statements you prepared in step two and prepare an analysis of the company's financial position. Identify two strengths and two weaknesses in the company. Make two recommendations to improve the company's financial position. Be specific in each of the recommendations and use the ratios to support your analysis. The length should be no more than one page. 5. 21 Page

Answer & Explanation Solved by verified expert

See Answer