The financial information for the past two years (2018 and 2019) is provided. Using a spreadsheet...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The financial information for the past two years (2018 and 2019) 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. Working Capital both years b. Current Ratio both years C. Quick ratio both years d. Accounts Receivable Turnover 2019 Number of Days Sales in Receivables 2019 (Company policy states 30 days in receivables) f. Inventory Turnover 2019 B. Number of Days Sales in Inventory 2019 (Company policy states 50 days to turn over inventory) h. Ratio of Liabilities to Stockholders' Equity 2018 and 2019 e. i. Return on Total Assets 2019 j. Return on Stockholders' Equity 2019 k. Earnings Per Share 2018 and 2019 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. 5. 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 OCIETY 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 moré than three paragraphs; one for strengths, one for weaknesses and one for recommendations. Blackboard Instructions 6. Memo analyzing the company's strengths and weaknesses with two recommendations. In Blackboard you will write a memo using ratios to analyze the strengths and weaknesses of the company. Make sure there are no spelling, grammatical, or punctuation errors. a. b. Add information concerning numbers here and enter Blackboard as specified below When the answer is in units enter the number as is (See example below) C. 280 When the answer is for ratios (ie. Current ratio) and has a decimal take the decimal out two decimal spaces (See example below) 1. 280.89 d. e. When ratios are in days/times take out to two decimal places and write days or times after the number (See example below) 1. 280.96 days or times f. When the answer is in dollars ALWAYS include a dollar sign and cents even if the cents is zero add .00 (See example below) i. $280.00 or $3,800.00 CCOUNTING FOCTETY Cumparutive Halance Seet Robust Robots, Inc. Comparative Balance Sheet December31, 2019 and 2018 Assets 2019 2018 Current Asets: Cash G5.000 80,000 100.000 Accounts Recelvable, net 150,000 Merchandise Inventory 135.000 70,000 Supplies Prepaid insurance 9.700 500 30,000 10,000 Total Current Assets 389,700 260,500 Property, Plant.and Eguipment: Equipment Less: Accumulated Depreciation - Equipment Total Property Plant, and Equipment 500,000 240,000 (80,000) (90,000) 420,000 150,000 Total Assets B09,700 410,500 CCOUNTING OeTETY 2018 2019 Liatities and Stackholders Equity Current Liabilities: Accounts Payable 150,000 40.000 40,000 10,000 40,000 50,000 110,0 -10, 10 inearmed Revenue 30,000 Salaries Payalle Fedural income Taxes Pavatie Total Current Liobilities 10,000 130.000 240,000 Long Term Liabilities Note Payable 130,000 130,000 Total Long Tarm Liabilities Total Liabnties 370,000 130,000 Stockholders' Equity: Common Stock, $10 Par Paid in Capital in Excess of Par 170,000 100,000 43,700 226,000 180,500 Retained Earnings 439,700 280,500 Total Stockholders Equity Total Liabilities and Stockholders' Equity 809,700 410,500 Cmparative lncom Statement Robust Robots, Inc. Comparative Statement of tncome For the Years Ended December 31, 2019 and 2018 2018 2019 700,000 524,300 500,000 420.000 Sales Cost of Goods Sold Gross Margin 180,000 175,700 Operating Expenses: Salaries and Wages Expertse Rent Expense Depreciation Expense 100,000 47.290 20,256 20,000 20,000 10,000 130,000 87,546 88,154 Total Operoting Expenses 50,000 Income from Operations LOss an Sale of Equipnent (5,213) (3,656) is (5,000) (5.000) Interest Expense Increase (Decrease) in Operoting (8,869) Income 79,285 (23,786) 45,000 Income before Taxes (13,500) 31,500 Federal Income Taxes Net Income 55,500 6|Pa Caps Ln CCOUNTING OCTETY Compantive Statement of Retained Earnings Robust Robots, Inc. Comparative Statement of Retained Earninga For the Years Ended December 31, 2019 and 2018 2019 2018 Retained Earnings, Beginning of Year 180,500 176,000 Net Income 55,500 10,000 31,500 27,000 Less. Dividends Retained Eaarnings, End of Year 1. Equipment with a cost of $90,000 on which depreciation has been recorded, was sold for cash. Additional equipment was purchased for cash and a long-term note payable. 2. Stock was issued for cash. 3. The dividends were paid in cash. 226,000 180,500 The financial information for the past two years (2018 and 2019) 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. Working Capital both years b. Current Ratio both years C. Quick ratio both years d. Accounts Receivable Turnover 2019 Number of Days Sales in Receivables 2019 (Company policy states 30 days in receivables) f. Inventory Turnover 2019 B. Number of Days Sales in Inventory 2019 (Company policy states 50 days to turn over inventory) h. Ratio of Liabilities to Stockholders' Equity 2018 and 2019 e. i. Return on Total Assets 2019 j. Return on Stockholders' Equity 2019 k. Earnings Per Share 2018 and 2019 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. 5. 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 OCIETY 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 moré than three paragraphs; one for strengths, one for weaknesses and one for recommendations. Blackboard Instructions 6. Memo analyzing the company's strengths and weaknesses with two recommendations. In Blackboard you will write a memo using ratios to analyze the strengths and weaknesses of the company. Make sure there are no spelling, grammatical, or punctuation errors. a. b. Add information concerning numbers here and enter Blackboard as specified below When the answer is in units enter the number as is (See example below) C. 280 When the answer is for ratios (ie. Current ratio) and has a decimal take the decimal out two decimal spaces (See example below) 1. 280.89 d. e. When ratios are in days/times take out to two decimal places and write days or times after the number (See example below) 1. 280.96 days or times f. When the answer is in dollars ALWAYS include a dollar sign and cents even if the cents is zero add .00 (See example below) i. $280.00 or $3,800.00 CCOUNTING FOCTETY Cumparutive Halance Seet Robust Robots, Inc. Comparative Balance Sheet December31, 2019 and 2018 Assets 2019 2018 Current Asets: Cash G5.000 80,000 100.000 Accounts Recelvable, net 150,000 Merchandise Inventory 135.000 70,000 Supplies Prepaid insurance 9.700 500 30,000 10,000 Total Current Assets 389,700 260,500 Property, Plant.and Eguipment: Equipment Less: Accumulated Depreciation - Equipment Total Property Plant, and Equipment 500,000 240,000 (80,000) (90,000) 420,000 150,000 Total Assets B09,700 410,500 CCOUNTING OeTETY 2018 2019 Liatities and Stackholders Equity Current Liabilities: Accounts Payable 150,000 40.000 40,000 10,000 40,000 50,000 110,0 -10, 10 inearmed Revenue 30,000 Salaries Payalle Fedural income Taxes Pavatie Total Current Liobilities 10,000 130.000 240,000 Long Term Liabilities Note Payable 130,000 130,000 Total Long Tarm Liabilities Total Liabnties 370,000 130,000 Stockholders' Equity: Common Stock, $10 Par Paid in Capital in Excess of Par 170,000 100,000 43,700 226,000 180,500 Retained Earnings 439,700 280,500 Total Stockholders Equity Total Liabilities and Stockholders' Equity 809,700 410,500 Cmparative lncom Statement Robust Robots, Inc. Comparative Statement of tncome For the Years Ended December 31, 2019 and 2018 2018 2019 700,000 524,300 500,000 420.000 Sales Cost of Goods Sold Gross Margin 180,000 175,700 Operating Expenses: Salaries and Wages Expertse Rent Expense Depreciation Expense 100,000 47.290 20,256 20,000 20,000 10,000 130,000 87,546 88,154 Total Operoting Expenses 50,000 Income from Operations LOss an Sale of Equipnent (5,213) (3,656) is (5,000) (5.000) Interest Expense Increase (Decrease) in Operoting (8,869) Income 79,285 (23,786) 45,000 Income before Taxes (13,500) 31,500 Federal Income Taxes Net Income 55,500 6|Pa Caps Ln CCOUNTING OCTETY Compantive Statement of Retained Earnings Robust Robots, Inc. Comparative Statement of Retained Earninga For the Years Ended December 31, 2019 and 2018 2019 2018 Retained Earnings, Beginning of Year 180,500 176,000 Net Income 55,500 10,000 31,500 27,000 Less. Dividends Retained Eaarnings, End of Year 1. Equipment with a cost of $90,000 on which depreciation has been recorded, was sold for cash. Additional equipment was purchased for cash and a long-term note payable. 2. Stock was issued for cash. 3. The dividends were paid in cash. 226,000 180,500
Expert Answer:
Answer rating: 100% (QA)
Comparative Balance Sheet Dec 31 2019 2018 Assets 2019 2018 increasedecrease change current assets cash 65000 80000 15000 1875 accounts receivable 150000 100000 50000 5000 inventory 135000 70000 65000 ... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-0078111006
14th edition
Authors: Ray Garrison, Eric Noreen and Peter Brewer
Posted Date:
Students also viewed these accounting questions
-
A comparative balance sheet for Alcorn Company containing data for the last two years is as follows: The following additional information is available about the companys activities during this year:...
-
A comparative balance sheet for Lomax Company containing data for the last two years is as follows: The following additional information is available about the companys activities during this year:...
-
A comparative balance sheet for Alcorn Products containing data for the last two years is as follows: The following additional information is available about the companys activities during 2008, the...
-
AASB 102 prohibits the use of the LIFO method. What is the argument against the use of LIFO?
-
Air Borealis works only with advance reservations and experiences a 7% rate of no-shows. How many reservations could be accepted for an airliner with a capacity of 250 if there is at least a 0.95...
-
Given: 1kg = 1000g 1. A pitcher threw a pitch that generated an impulse of 3.25 Ns on the catcher's glove. If the mass of the baseball is 142g, what was the velocity of the pitched baseball when it...
-
The following financial statements were prepared for the management of Satay Ltd. The statements contain some information that will be disclosed in note form in the general purpose financial...
-
Faced with three young children who were always complaining Im bored, Ann Newton was looking for an interesting afterschool activity. Finding nothing available in the community, she decided to solve...
-
Based on the information given answer the following: What Cape Fear could do to improve operations for 2022, and how their operations differ from Wilmington Health. Do not repeat information given in...
-
Kate Collins has opened Fontina and Stuff, a wholesale grocery and cheese company. The following transactions occurred in February: Required 1. Journalize the transactions. Beginning balances of...
-
Read the discussion of a controversial issue entitled America at Odds. Write a paper on Do U.S. Citizens Really Need Military Based Rifles. Your paper should discuss the specific issues involved and...
-
Godfrey is a director of Hospitality Hotel Corporation. Like most directors, Godfrey was most likely a. appointed by the secretary of state in the state of incorporation. b. chosen by a vote of the...
-
A patient who has recently been dispensed a prescription medication angrily confronts the pharmacist. The patient has read the CMI included with the product and notes that the drug is not indicated...
-
For fifty years, the Soviet Union made and sold Stolichnaya vodka and licensed its trademark for use in the United States. After the Soviet Union collapsed, the state enterprise that had managed the...
-
Hong Electronics, a state-owned factory in the Peoples Republic of China, made counterfeit parts that were misrepresented as genuine and sold in the United States. Integrated Technology Corp., a U.S....
-
Mobile Processes, Inc., a U.S. company, made network management devices. To test the demand for the devices in Asia, Mobile exported the products to Asian markets. When the test proved successful,...
-
9-18. A simply supported beam is subjected to a quadratic distributed load as shown in Fig. P9.18. y Figure P9.18 Simply supported beam subjected to a quadratic distributed load. a. Determine the...
-
Saccharin is an artificial sweetener that is used in diet beverages. In order for it to be metabolized by the body, it must pass into cells. Below are shown the two forms of saccharin. Saccharin has...
-
Sue Jaski, supervisor of the Karaki Corporations Machining Department, was visibly upset after being reprimanded for her departments poor performance over the prior month. The departments cost...
-
Logan Products computes its predetermined overhead rate annually on the basis of direct labor- hours. At the beginning of the year, it estimated that 40,000 direct labor-hours would be required for...
-
Papyrutech Corporation produces fine papers in three production departmentsPulping, Drying, and Finishing. In the Pulping Department, raw materials such as wood fiber and rag cotton are mechanically...
-
solve the given problem using PSO method \[f(X)=1200\left(2 x_{1} x_{3}+2 x_{2} x_{3} ight)+2500 x_{1} x_{2}+500\left(\frac{1000}{x_{1} x_{2} x_{3}} ight)+100\left(\frac{1000}{10 x_{1} x_{2} x_{3}}...
-
Solve the optimization problem using SA \[\min f(X)=100\left(x_{1}^{2}+x_{2} ight)^{2}+\left(1-x_{1} ight)^{2}\] subject to $X \in[0,7]$
-
Discuss the perturbation mechanism of simulated annealing.
Study smarter with the SolutionInn App