Seatwork No. 2 FINANCIAL RATIO ANALYSIS HORIZONTAL, VERTICAL, TREND ANALYSIS I Caselast meeting The following are the balance sheet and income statement data of XYZ Company December 31 Halance Sheet Accounts: 2019 2018 14.000 35.000 Accounts payable 59,000 60.000 Accounts receivable Accrued expenses payable 3.500 2.000 71.000 63.000 Building, net 30.000 Common stock equity 224,000 200.000 Income taxes payable 2.500 2000 Inventory 76.000 Land 28.000 26,000 11,000 10,000 Mortgage payable 35.000 35.000 Prepaid Insurance 4,000 3,000 Retained carnings 26,000 1.000 Income statement accounts, 2019; Cost of goods sold Depreciation expense-building Depreciation expense - machinery Income taxes Interest expense Sales Selling and administrative expenses 22000 6,000 8.000 15,000 100 LOGO 20,000 wird 1. Comparative balance sheet for 2018 and 2019, 2. Income statement for 2019 3. Horizontal analysis of comparative balance sheet, 2018 and 2019. ) 4. Vertical analysis of income statement for 2019 5. Calculate the indicated ratios for XYZ Company for 2019. Use 2 decimal places in your analysis, if needed Ratio XYZ Company Industry Average Current 2.0x Quick Days sales outstanding 35 days Inventory tumover Total assets turnover 3.0 Nel profit margin Return on ASSIS Return on Common Equity 796 6.5x Outline XYZ's strengths and weaknesses as revealed by your analysis. rend Analysis. Jupiter Company has provided the following comparative information: 2019 2018 2017 Net income $ 100,000 $150,000 $150,000 Income tax expense 30,000 45,000 45,000 Interest 144.000 138,000 138.000 Average total assets 2,300,000 2,150,000 2,000,000 Average total stockholder's equity 1.100.000 1,000,000 850,000 2016 S 22,000 60.000 126,000 1,750,000 700.000 2015 $250,000 75.000 120,000 1,500,000 500.000 been asked to evaluate the performance of the company over the last five years. To the extent the data permit, comment on the signifi hips revealed by your analysis. Use 2015 as your base year