Look at company A and company Bs ratios and choose which company you would invest in.
Excel File Edit View Insert Format Tools Data Window Help 2 Thu Dec 9 4:31 PM O.. AutoSave OFF NewG... Financial Accounting a SP Insert Home - Draw Page Layout Formulas Data Review View Tell me Share Comments X Arial v 10 A Y == Y General 9. Wrap Text 47. O 0 Insert v Delete ! Format y Paste BTU A E == +E Merge & Center $ % Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Analyze Data Sensitivity E31 A B D E F G H J 1 Company A Times Interest eamed ratio in 2019 45.06134969 EBIT/Interest expense Price-earnings ratio in 2019 12.3522 Market price of one share at stockeamings perstar Average days to collect receivable in 2019 38.84575835 365 Days/Accounts receivable tumove Times Interest oamned ratio in 2020 37.64387917 Price-earnings ratio in 2020 9.451807 Average days to collect receivable in 2020 31.79048891 Return-on-Assets Ratio in 2019 0.1614 EBIT/Total assets Earning per share ratio in 2019 5.1816839 Not coming Number of share of common stock outstanding Average Days to Sell Inventory in 2019 107.0095557 365 Days'Inventory tumover Return-on-Assets Ratio in 2020 0.154666179 Earning per share ratio in 2020 4,871581772 Average Days to Sell Inventory in 2020 89.79287895 Return-On-Sales Ratio in 2019 0.292475509 Net Income/Net Sales Current Ratio in 2019 1.400224115 Current Assets/Current Liabilities 3 Debt-to-Assets Ratio in 2019 4 0.212424189 Total debts/Total assets 5 6 Debt-to-Assets Ratio in 2020 7 0.237773612 8 9 Return-on-Assets Ratio in 2019 10 0.154170695 Net Income Total Assets 11 12 Return-on-Assets Ratio in 2020 13 0.136513577 14 15 Return-on-Equity Ratio in 2019 16 0.27157308 Net Income/Stackhalder's equity 17 18 Return-on-Equity Ratio in 2020 19 0.25789136 20 21 Gross Margin Percentage in 2019 22 0.585562426 Gross Margin/Net Sales 23 24 Gross Margin Percentage in 2020 25 0.560083219 26 27 28 29 30 31 32 33 Return-On-Sales Ratio in 2020 0.268393543 Current Ratio in 2020 1.905742021 Inventory Turnover ratio in 2019 3.410910339 Cost of goods sold'Inventory Accounts receivable turnover ratio in 2019 9.396135266 Sales/Net Accounts receivable Inventory Turnover ratio in 2020 4.064910407 Accounts receivable turnover ratio in 2020 11.48142141 Sheet1 Sheet2 + Ready + 125% % Excel File Edit View Insert Format Tools Data Window Help 2 Thu Dec 9 4:33 PM 0.0 AutoSave OFF N@ 2GB Financial Accounting Insert Home - Draw Page Layout Formulas Data Review View Tell me Share Comments Arial v 18 AP E = 24. Wrao Text Ganeral 3 2-D Insert Delete Format YD v Paste B BTU AA = Merge & Center $ % 9 Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Analyze Data Sensitivity A1 X fr Company B C D E F G H J L Times Interest earned ratio in 2019 65.5862 EBIT/Interest expense Price-earnings ratio in 2019 24.12048193 Market price at one share at stockleamings per stam Average days to collect receivable in 2019 44.3633 365 Days/Accounts receivable tumover Times Interest earned ratio in 2020 54.7305 Price-earnings ratio in 2020 55.4159292 Average days to collect receivable in 2020 55.3952 Return-on-Assets Ratio in 2019 0.2862 EBIT/Total assets Earning per share ratio in 2019 1.6564 Net caming Number of share at common stock outstanding Average Days to Sell Inventory in 2019 126.4851485 355 Days Inventory tumover Return-on-Assets Ratio in 2020 0.2862 Earning per share ratio in 2020 0.651748252 Average Days to Sell Inventory in 2020 36.10481928 A B 1 Company B 2 3 Debt-to-Assets Ratio in 2019 4 0.1883 Total debts/Total assets 5 6 Debt-to-Assets Ratio in 2020 7 0.1454 8 9 Return-on-Assets Ratio in 2019 10 0.3115 Net Income Total Assets 11 12 Return-on-Assets Ratio in 2020 13 0.1615 14 15 Return-on-Equity Ratio in 2019 16 0.4433 Net Income Stockholder's equity 17 18 Return-on-Equity Ratio in 2020 19 0.2291 20 21 Gross Margin Percentage in 2019 22 0.612 Gross Margin/Net Sales 23 24 Gross Margin Percentage in 2020 25 0.62 26 27 28 29 30 31 32 33 Return-On-Sales Ratio in 2019 0.353448276 Net Income/Net Sales Current Ratio in 2019 7.9436 Current Assets/Current Liabilities Return-On-Sales Ratio in 2020 0.258090859 Current Ratio in 2020 7.6738 Inventory Turnover ratio in 2019 2.885714286 Cost of goods sold Inventory Accounts receivable turnover ratio in 2019 8.2275 Sales/Net Accounts receivable Inventory Turnover ratio in 2020 4.239019405 Accounts receivable turnover ratio in 2020 6.589 Sheet1 Sheet2 + Enter 3 DPI + 125%
