Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using an Excel spreadsheet application, such as Microsoft Excel, and the information from the previous years, provide the following: 1 . Prepare a Statement of
Using an Excel spreadsheet application, such as Microsoft Excel, and the information from the previous years, provide the following: Prepare a Statement of Cash Flows for the current year using the indirect method. Using horizontal analysis, prepare a Comparative Balance Sheet. Using vertical analysis, prepare an Income Statement. Using the textbook, calculate the ratios set out below: a Current Ratio for years and b Quick ratio for years and C Accounts Receivable Turnover for the year d Number of Days Sales in Receivables for year e Inventory Turnover for the year f Number of Days Sales in Inventory for year g Ratio of Liabilities to Stockholders' Equity for the years and h Return on Total Assets for the year i Return on Stockholders' Equity for the year j Earnings Per Share for the years and The financial statements provided in this practice set can be downloaded from Blackboard. Read the instructions provided before downloading. 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 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. Page OCIETY Save, print and upload the following documents to Blackboard by going to the navigation pane and clicking where it says Practice Set by the assigned date: a Statement of Cash Flows b Balance Sheet with horizontal analysis c Income Statement with vertical analysis d Worksheet showing the calculations of the ratios prepared in Excel. e Memo analyzing the company's strengths and weaknesses with two recommendations. Students must use a memo template in Word and make sure there are no spelling, grammatical, or punctuation errors. Blackboard Instructions a Answer questions that use numbers into Blackboard as specified below: b When the answer is in units enter the number as is See example below i c When the answer is for ratios ie Days and has a decimal take the decimal out to two decimal places. Round to two decimals. See example below i days d When ratios are in times take out to two decimal places See example below i times e When the answer is in dollars ALWAYS include a dollar sign and cents even if the cents is zero add See example below i $ or $ Please follow all instructions. If the answers are formatted incorrectly the answer will be counted wrong. Make sure that you input the information first into the templates, save the completed template to your computer, then print it out so you can use it to answer the questions in Blackboard. Once you complete answering the questions in Blackboard, upload your saved template to Blackboard by going to the Navigation Pane in this course, clicking on Practice Set and then uploading the file that you saved. Page
Using an Excel spreadsheet application, such as Microsoft Excel, and the information from the previous years, provide the following: Prepare a Statement of Cash Flows for the current year using the indirect method. Using horizontal analysis, prepare a Comparative Balance Sheet. Using vertical analysis, prepare an Income Statement. Using the textbook, calculate the ratios set out below: a Current Ratio for years and b Quick ratio for years and C Accounts Receivable Turnover for the year d Number of Days Sales in Receivables for year e Inventory Turnover for the year f Number of Days Sales in Inventory for year g Ratio of Liabilities to Stockholders' Equity for the years and h Return on Total Assets for the year i Return on Stockholders' Equity for the year j Earnings Per Share for the years and The financial statements provided in this practice set can be downloaded from Blackboard. Read the instructions provided before downloading. 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 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. Page
OCIETY Save, print and upload the following documents to Blackboard by going to the navigation pane and clicking where it says Practice Set by the assigned date: a Statement of Cash Flows b Balance Sheet with horizontal analysis c Income Statement with vertical analysis d Worksheet showing the calculations of the ratios prepared in Excel. e Memo analyzing the company's strengths and weaknesses with two recommendations. Students must use a memo template in Word and make sure there are no spelling, grammatical, or punctuation errors. Blackboard Instructions a Answer questions that use numbers into Blackboard as specified below: b When the answer is in units enter the number as is See example below i c When the answer is for ratios ie Days and has a decimal take the decimal out to two decimal places. Round to two decimals. See example below i days d When ratios are in times take out to two decimal places See example below i times e When the answer is in dollars ALWAYS include a dollar sign and cents even if the cents is zero add See example below i $ or $ Please follow all instructions. If the answers are formatted incorrectly the answer will be counted wrong. Make sure that you input the information first into the templates, save the completed template to your computer, then print it out so you can use it to answer the questions in Blackboard. Once you complete answering the questions in Blackboard, upload your saved template to Blackboard by going to the Navigation Pane in this course, clicking on Practice Set and then uploading the file that you saved. Page
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started