X fx B C D E F G H NOTE: You may 1) place your answer to this problem on the sheets provided in this file (ie. "Parta" and "Part b"), or 2) place your answer on a Word file or 3) 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: XYZ 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 Module 5 Practice Problem as a model. You do not need to show the 4 "Supprting Calculations." b) By referring to the ratios, write a brief assessment of the financial performance of XYZ 5 Company 6 XYZ Company 7 2017 2016 2015 8 Balance Sheet 9 Cash $ 7,500 $ 5,000 $ 4,600 10 Accounts Receivable 2,400 2,900 2,200 11 Inventory 1,360 3,400 1,920 12 Prepaid Expenses 830 1,210 360 13 Other Current Assets 380 430 350 14 Total Current Assets 12.470 12,900 9,000 15 Property and Equipment 72,000 87.000 30,200 16 Total Assets $ 8,470 $ 99,940 $ 39,640 17 18 Current Liabilities $ 8,800 $ 8,800 $ 9,800 19 Long-term Liabilities 38,200 48.600 15,600 20 Total Liabilities 47,000 57.000 25,400 21 Contributed Capital 29,800 40,000 13,300 22 Retained Earnings 7,670 2,500 940 23 Total Shareholders' equity 37.470 42.500 14,200 24 tal Liabilities and Shareholders' Equity S 84.470 $ 99,90 $39.610 25 $ 92,000 69,800 22,200 26 27 28 29 30 30 Income Statement Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses Income from Operations Interest Expense Question Parta $ 64,000 52,000 12.000 2.800 9,200 1.606 $ 52,000 39,000 13,000 7,800 5,200 1.200 4.800 17,400 Part b READY OS om the Internet can contain viruses. Unless you need to edit. it's safer to stay in Protected View Enable Edit E F K B Accounts Receivable Inventory Prepaid Expenses Other Current Assets Total Current Assets Property and Equipment Total Assets D 2,400 1,360 830 380 12,470 72,000 $ 84,470 2,900 3,400 1,210 430 12,940 87,000 $ 99,940 H 2,200 1,920 360 360 9,440 30,200 $ 39,640 Current Liabilities Long-term Liabilities Total Liabilities Contributed Capital Retained Earnings Total Shareholders' equity Total Liabilities and Shareholders' Equity $ 8,800 38,200 47,000 29,800 7,670 37,470 $ 84,470 $ 8,800 48,640 57,440 40,000 2,500 42,500 $ 99,940 $ 9,800 15,600 25,400 13,300 940 14,240 $ 39,640 Inconie 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 69,800 22,200 4,800 17,400 3,474 13,926 4,178 $ 9,748 $ 64,000 52.000 12,000 2,800 9,200 1,606 7,594 2,278 $ 5,316 $ 52,000 39,000 13,000 7,800 5,200 1,200 4,000 1.200 $ 2,800 Question Parta Part b X fx B C D E F G H NOTE: You may 1) place your answer to this problem on the sheets provided in this file (ie. "Parta" and "Part b"), or 2) place your answer on a Word file or 3) 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: XYZ 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 Module 5 Practice Problem as a model. You do not need to show the 4 "Supprting Calculations." b) By referring to the ratios, write a brief assessment of the financial performance of XYZ 5 Company 6 XYZ Company 7 2017 2016 2015 8 Balance Sheet 9 Cash $ 7,500 $ 5,000 $ 4,600 10 Accounts Receivable 2,400 2,900 2,200 11 Inventory 1,360 3,400 1,920 12 Prepaid Expenses 830 1,210 360 13 Other Current Assets 380 430 350 14 Total Current Assets 12.470 12,900 9,000 15 Property and Equipment 72,000 87.000 30,200 16 Total Assets $ 8,470 $ 99,940 $ 39,640 17 18 Current Liabilities $ 8,800 $ 8,800 $ 9,800 19 Long-term Liabilities 38,200 48.600 15,600 20 Total Liabilities 47,000 57.000 25,400 21 Contributed Capital 29,800 40,000 13,300 22 Retained Earnings 7,670 2,500 940 23 Total Shareholders' equity 37.470 42.500 14,200 24 tal Liabilities and Shareholders' Equity S 84.470 $ 99,90 $39.610 25 $ 92,000 69,800 22,200 26 27 28 29 30 30 Income Statement Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses Income from Operations Interest Expense Question Parta $ 64,000 52,000 12.000 2.800 9,200 1.606 $ 52,000 39,000 13,000 7,800 5,200 1.200 4.800 17,400 Part b READY OS om the Internet can contain viruses. Unless you need to edit. it's safer to stay in Protected View Enable Edit E F K B Accounts Receivable Inventory Prepaid Expenses Other Current Assets Total Current Assets Property and Equipment Total Assets D 2,400 1,360 830 380 12,470 72,000 $ 84,470 2,900 3,400 1,210 430 12,940 87,000 $ 99,940 H 2,200 1,920 360 360 9,440 30,200 $ 39,640 Current Liabilities Long-term Liabilities Total Liabilities Contributed Capital Retained Earnings Total Shareholders' equity Total Liabilities and Shareholders' Equity $ 8,800 38,200 47,000 29,800 7,670 37,470 $ 84,470 $ 8,800 48,640 57,440 40,000 2,500 42,500 $ 99,940 $ 9,800 15,600 25,400 13,300 940 14,240 $ 39,640 Inconie 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 69,800 22,200 4,800 17,400 3,474 13,926 4,178 $ 9,748 $ 64,000 52.000 12,000 2,800 9,200 1,606 7,594 2,278 $ 5,316 $ 52,000 39,000 13,000 7,800 5,200 1,200 4,000 1.200 $ 2,800 Question Parta Part b