om the Internet can contain viruses. Unless you need to edit it's safe to stay in Protected View A2 fx Question: XYZ Company's financial data is presented below. A B D E F G H K NOTE: You may 1) place your answer to this problem on the sheets provided in this file e. "Parta and Part b'), or 2 place your answer on a Wordle or ) write your answer on paper and prepare a scanned file of your answer. Whatever method you choose, submit your file to the Assignment Dropbox for Module 5 1 2 Question: XY2 Company's financial data is presented below. 3 Required: a) Calculate the seven ratios in the financial analysis map for 2017 and 2016. Show your calculations, using the Modules Practice Problem as a model. You do not need to show the Supprting Calculations." b) By referring to the ratios, write a brief assessment of the financial performance of XYZ 5 Company XYZ Company 7 2017 2016 2015 8 9 10 11 12 15 14 15 Balance Sheet Cash Accounts Receivable Inventory Prepaid Expenses Other Current Assets Total Current Assets Property and Equipment Total Assets $7,500 2,400 1,360 830 390 12.470 72.000 $ 1.470 $5,000 2.900 3,400 1,210 430 12.940 87.000 $ 93,940 $ 4,600 2,200 1.920 300 360 9.410 30,200 $ 39,600 17 12 20 21 22 2 Current Liabilities Long-term Liabilities Total Liabilities Contributed capital Retained Earnings Total Shareholders equity Total abilities and Shareholders' Equity $ 8.800 38,200 47.000 29,800 7,670 27.470 S 84,470 $ 8.800 48,640 57.440 40,000 2,500 42,500 $ 99,900 $ 9.500 15.600 25,000 13,300 140 14,240 $39,640 24 25 20 39 30 31 Income Statement Sales Revenue Cost of Goods sold Gross Profit Operating Expenses Income from Operations Interest Expense Question Parts $ 99.000 69,800 22,200 4,300 17,400 $ 60,000 52,000 12,000 2,800 9,200 1.000 $ 52,000 29.000 13,000 7.000 5,200 1,200 Part READY 0 03 Eiferto ay in Protected View AZ X f Question: XYZ Company's financial data is presented below. B E 1 2 D 2017 H 2015 K 2016 9 10 11 12 18 14 Balance sheet Cash Accounts Receivable Inventory Prepaid Expenses Other Current Assets Total Current Assets Property and Equipment Total Assets $ 7,500 2,400 1,360 830 380 12,470 72.000 $ 84,470 $ 5,000 2,900 3,400 1,210 430 12,940 87,000 $ 99,940 $4,500 2,200 1.920 360 360 9,440 30,200 $ 39,610 15 16 17 18 19 20 21 22 23 24 $ 8,300 38,200 47,000 29,800 7,620 37,470 $ 81.470 $ 8,800 48,640 57,460 40,000 2.500 42,500 $ 99,900 $ 9,800 15,600 25,400 13,300 940 14,210 $39.610 25 26 27 20 29 20 21 33 Current Liabilities Long-term Liabilities Total abilities Contributed Capital Retained Earnings Total Shareholders' equity Total liabilities and Shareholders' Equity Income Statement Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses Income from Operations Interest Expense Earnings before income taxes Income Tax Expense Net Income $ 92,000 3,00 22.200 4,000 17,400 3.44 13.920 $ 54,000 52.000 12,000 2.800 9,200 1606 7.594 2.278 $5.316 $ 52,000 29,000 13,000 7,800 5.200 1.200 4,000 1.200 $9, $ 2,800 35 36 39 40 41 42 44 15 46 Question Darts Part READY Q 3 E 03