please calculate the following ratios using the info below

the ratios I provided

what do you mean I posted the whole b/s with its numerical values I'll post it again

ECHIBIT 14-26 Summary of Analytical Measures or other Meccurement Method of Computation Since Mures of short-term liquidity Current ratio Quick ratio Current Assets Current Liabilities Quick Assets Current Liabilities Current Assets - Current Liabilities Working capital Net cash provided by operating activities Appears in the statement of cash flows Cash flow from operations to current liabilities Cash Flows from Operating Activities Current Liabilities Accounts receivable turnover rate A measure of short-term deb yng ability A measure of short-term debt-paying ability A measure of short-term debt paying ability Indicates the cash generated by operations after allowing for cash payment of expenses and operat ing liabilities Indicates ability to cover currently maturing obligations from recurring operations Indicates how quickly receivables are collected Indicates in days how quickly receivables are collected Indicates how quickly inventory sells Indicates in days how quickly inventory sells Indicates in days how quickly cash invested in inventory converts back into cash Excess of operating cash flow over basic needs Net Sales Average Accounts Receivable 365 Days Accounts Receivable Turnover Rate Cost of Goods Sold Average Inventory 365 Days Inventory Turnover Rate Days to Sell Inventory+ Days to Collect Receivables Days to collect average accounts receivable Inventory turnover rate Days to sell the average inventory Operating cycle Free cash flow Net Cash from Operating Activities - Cash Used for Investing Activities and Dividends Days to sell the average Inventory Operating cycle 365 Days Inventory Turnover Rate Days to Sell Inventory+ Days to Collect Receivables Indicates in days how quicy Inventory sells Indicates in days how quicy cash Invested in inventory converts back into cash Excess of operating cash flow over basic needs Free cash flow Net Cash from Operating Activities - Cash Used for Investing Activities and Dividends Measures of long-term credit risk Debt ratio Total Liabilities Total Assets Trend in net cash provided by operating activities Appears in comparative statements of cash flows Percentage of assets financed by creditors, indicates relative size of the equity position Indicator of a company's ability to generate the cash necessary to meet its obligations Indicator of a company's ability to meet its interest payment obligations Interest coverage ratio Income before Interest and Taxes Annual Interest Expense Measures of profitability Percentage changes; that is in net sales and net income Dollar Amount of Change Financial Statement Amount in the Earlier Year Gross profit rate Gross Profit Net Sales Operating Expenses Net Sales The rate at which a key measure is increasing or decreasing: the "growth rate A measure of the profitability of the company's products A measure of management's ability to control expenses Operating expense ratio F G B D 1 12 Months Ended Consolidated Statements of Cash Flows - USD ($) $ in Millions Dec. 31, Dec. 31, Dec. 31, 2 2019 2018 2017 3 CASH PROVIDED BY (USED IN) OPERATING ACTIVITIES: 4 Net income $ 450 $ 396 $ 434.6 Adjustments to reconcile net income to net cash provided by 5 operating activities: 6 (Income) loss from discontinued operations 0.8 (0.1) 0.4 7 Depreciation and amortization 180.5 166.2 158.6 3 Amortization of debt issuance costs and accretion of debt discounts 5.2 5.4 5.6 Stock-based compensation expense 31.1 25.5 20.6 o Deferred income tax provision (benefit) 45.8 14.5 -19 1 Net gain on asset sales and dispositions (44.9) (57.6) (95.4) Franchise rights impairment 9.6 8.1 0 3 Other non-cash impairment charges 2.2 3.2. 26.4 Unrealized gain on equity investment (25.7) 0 0 Other (6.8) C+ (7.3) (Increase) decrease, net of effects from business combinations and divestitures: Receivables 56.2 133.7 (61.6) Consolidated Balance Sheets Consolidated Statements of Inco Consolidated Statements of Cash B D E 133.7 (319.5) (107.9) (61.6) 39.3 -37 17 Receivables 56.2 18 Inventory 296 19 Other assets 49.5 Increase (decrease), net of effects from business combinations and 20 divestitures: 21 Vehicle floorplan payable-trade, net (240.6) 22 Accounts payable (17.6) 23 Other liabilities (22.1) 24 Net cash provided by continuing operations 769.2 25 Net cash provided by (used in) discontinued operations 0 26 Net cash provided by operating activities 769.2 27 CASH PROVIDED BY (USED IN) INVESTING ACTIVITIES: 28 Purchases of property and equipment (269.3) 29 Proceeds from the sale of property and equipment 30 Proceeds from the disposal of assets held for sale 38 31 Insurance recoveries on property and equipment 3.5 32 Cash used in business acquisitions, net of cash acquired (4.7) 33 Cash received from business divestitures, net of cash relinquished 115.6 34 Investment in equity security 0 0.1 Consolidated Statements of Cash 242.4 1.7 -2 510.4 0.6 511 (64.4) 0.5 139.1 540.4 (0.3) 540.1 (400.8) 28 21.1 1.1 (67.2) 173.2 -50 (0.7) (313.4) 21 38 1.7 (76.8) 104.6 0 35 Other (2.1) alance Sheets Consolidated Statements of Inco G (0.7) (295.3) 0 (295.3) D (2.1) -227 0 -227 -100 -400 0 B 35 Other 0.1 36 Net cash used in continuing operations (115.8) 37 Net cash used in discontinued operations 0 38 Net cash used in investing activities (115.8) 39 CASH PROVIDED BY (USED IN) FINANCING ACTIVITIES: 40 Repurchases of common stock (44.7) 41 Payment of 6.75% Senior Notes due 2018 0 42 Proceeds from revolving credit facilities 0 43 Payments of revolving credit facilities 0 44 Net proceeds from (payments of) commercial paper -460 45 Payment of debt issuance costs 0 Net proceeds from (payments of) vehicle floorplan payable - non-trade (134.3) 46 47 Payments of mortgage facilities O 48 Payments of capital lease and other debt obligations -31 49 Proceeds from the exercise of stock options 12.7 50 Payments of tax withholdings for stock-based awards -3 0 52 Net cash used in continuing operations (660.3) 53 Net cash used in discontinued operations KM Consolidated Balance Sheets Consolidated Statements of Inco Consolidated Statements of Cash 0 300 0 (34.2) (434.9) 0 1,307 -1,307 -612 (13.5) 130.2 0 (15.8) 17.8 (2.7) (2.5) (237.4) 0 (153.2) (11.8) 39.7 (1.1) 0 (307.4) 51 Other 0 B G (134.3) (34.2) 130.2 (153.2) (11.8) 39.7 (1.1) Net proceeds from (payments of) vehicle floorplan payable - non-trade 46 47 Payments of mortgage facilities 48 Payments of capital lease and other debt obligations 49 Proceeds from the exercise of stock options 50 Payments of tax withholdings for stock-based awards 51 Other 52 Net cash used in continuing operations 53 Net cash used in discontinued operations 54 Net cash used in financing activities INCREASE (DECREASE) IN CASH, CASH EQUIVALENTS, AND RESTRICTED 55 CASH CASH, CASH EQUIVALENTS, AND RESTRICTED CASH at beginning of year 56 7 CASH, CASH EQUIVALENTS, AND RESTRICTED CASH at end of year 0 -31 12.7 -3 0 (660.3) 0 (660.3) (6.9) 0 (15.8) 17.8 (2.7) (2.5) (237.4) 0 (237.4) (21.7) 0 (307.4) 0 (307.4) 5.7 49.4 71.1 65.4 42.5 49.4 71.1 122 -0.8 D E 2 B 12 Months Ended Consolidated Statements of Income - USD ($) shares in Millions, $ in Dec. 31, Dec. 31, Dec. 31, Millions 2019 2018 2017 3 Revenue: 4 TOTAL REVENUE $ 21,335.7 5 Cost of Sales: 6 TOTAL COST OF SALES (excluding depreciation shown below) $ 17,812.7 7 Gross Profit: 8 TOTAL GROSS PROFIT $ 3,523.0 $ 3,397.3 $3,359.0 9 Selling, general, and administrative expenses $ 2,558.6 $2,509.8 $2,436.2 10 Depreciation and amortization $ 180.5 $ 166.2 $ 158.6 11 Franchise rights impairment $ 9.6 $ 8.1 $ 0.0 12 Other income, net $ (49.3) $ (64.7) $ 179.2) 13 OPERATING INCOME $ 823.6 $ 777.9 $ 843.4 14 Non-operating income (expense) items: 15 Floorplan interest expense $(138.4) S(130.4) S (97.0) 16 Other interest expense $ (106.7) $(119.4) $ (120.2) 17 Interest income $ 0.5 $ 1.1 $ 1.0 18 Other income, net $ 33.6 $ 0.2 $ 9.3 19 INCOME FROM CONTINUING OPERATIONS BEFORE INCOME TAXES $ 612.6 $ 529.4 $ 636.5 Consolidated Balance Sheets Consolidad Statements of Inco Consolidated Statements of Cash Ready Formatting as Table Styles Font Alignment Humber B22 -0.8 A $ 777.9 $ 843.4 $(130.4) $ (119.4) $ 1.1 $ 0.2 $ 529.4 $ 133.5 $395.9 $ 0.1 $ 396.0 $ (97.0) $ (120.2) $ 1.0 $9.3 $ 636.5 $201.5 $ 435.0 $ (0.4) $ 434.6 13 OPERATING INCOME $ 823.6 14 Non-operating income (expense) items: 15 Floorplan interest expense $ (138.4) 16 Other interest expense $ (106.7) 17 Interest income $ 0.5 18 Other income, net $ 33.6 19 INCOME FROM CONTINUING OPERATIONS BEFORE INCOME TAXES $ 612.6 20 Income tax provision $ 161.8 21 NET INCOME FROM CONTINUING OPERATIONS $ 450.8 22 Income (loss) from discontinued operations, net of income taxes $ (0.8) 3 NET INCOME $ 450.0 4 BASIC EARNINGS (LOSS) PER SHARE: s Continuing operations (in dollars per share) $5 Discontinued operations (in dollars per share) -0.01 Net income (in dollars per share) $ 4.99 Weighted average common shares outstanding (in shares) 90.1 DILUTED EARNINGS (LOSS) PER SHARE: Continuing operations (in dollars per share) $ 4.98 Discontinued operations (in dollars per share) -0.01 Net income (in dollars per share) $ 4.97 Consolidated Balance Sheets Consolidated Statements of Inco Consolidated Statements of Cash dy $ 4.36 0 $4.36 90.9 $ 4.45 0 $ 4.44 97.8 $ 4.34 0 $ 4.34 $ 4.43 0 $ 4.43 Average: 5104) C Dec. 31, 2019 Dec 31, 2018 1 Consolidated Balance Sheets - USD ($) Sin Millions 2 CURRENT ASSETS: 3 Cash and cash equivalents 4 Receivables, net 5 Inventory 6. Other current assets 7 Total Current Assets 8 PROPERTY AND EQUIPMENT, NET 9 OPERATING LEASE ASSETS 10 GOODWILL 11 OTHER INTANGIBLE ASSETS, NET 12 OTHER ASSETS 13 Total Assets 4 CURRENT LIABILITIES: 5 Vehicle floorplan payable Accounts payable - Commercial paper Current maturities of long-term debt Other current liabilities Total Current Liabilities $ 42.0 $ 916.7 $ 3,305.8 $ 38,882.0 $ 4,411.1 $ 3,174.6 $ 333.1 $ 39,828.0 $ 581.6 $541.0 $10543.30 0.4% 8.7% 31.4% 1.4% 41.8% 30.1% 3.2% 14.2% 5.5% 5.1% 100.0% $ 48.6 $ 976.2 $ 3,650.5 $ 208.7 $4,884.0 $3,155.3 $ 0.0 $ 1,513.2 $ 595.4 $ 517.2 $10665.10 0.5% 9.2% 34.2% 2.0% 45.8% 29.6% 0.0% 14.2% 5.6% 4.8% 100.0% $ 3,575.8 $ 290.3 $ 170.0 $ 355.6 $ 708.5 $ 5,100.2 33.9% 2.8% 1.6% 3.4% 6.7% 48.4% $ 3,997.7 $ 306.2 $ 630.0 $ 44.3 $ 679.9 $ 5,658.1 37.5% 2.9% 5.9% 0.4% 6.4% 53.1% Calibri 11 AA Wrap Text Paste Currency Copy Format Painter Clipboard BLU- Merge & Center 0.00 Insert Delete Format Font Alignment Conditional Format Cell Formatting as Table Styles - Styles Clear Number B79 35 B D F 36 37 HORIZONTAL ANALYSIS OF BALANCE SHEET(FROM 2018 TO 2019): Dollar amount change(in millions) % Change 38 39 Current Assets 40 Cash and Cash equivalents 41 Receivables, Net 42 Inventory 43 Other Current Assets 44 TOTAL CURRENT ASSETS 45 Prpoperty and Equipment,Net 46 Operating Lease Assets, Net 47 Goodwill 48 Other Intangible Assets, Net 49 Other Assets 50 TOTAL ASSETS -$6.6 -$59.5 $344.7 $62.1 -$472.9 $19.3 $333.1 -$11.3 $13.8 $23.8 -$121.8 -13.6% -6.1% -9.4% 29.8% -9.7% 0.6% 0.0% -0.7% -2.396 4.6% -1.196 51 52 CURRENT LIABILITIES 53 Vehicle Floorplan Payable 54 Accounts payable 55 Commercial Paner Consolidated Balance Sheets Ready -$421.9 $15.9 -4600 Consolidated Statements of Inco Consoldated Statements of Cash 10.6% -5.29 73 ES Home Auto Nation simplified financial statements (2) - Microsoft Excel Insert Page Layout Formulas Data Review View Calibri 11 AN Wrap Text Paste Currency Autosum BIU-- Xcut Ca Copy Format Painter Clipboard B79 - A- TA 34 2 Merge & Center - Alignment Font Conditional Format Cell Formatting - as Table Styles Styles Insert Delete Format e Clear Number Sort & Find a Filter Seler Editing fo Cells B E $23.8 $121.8 4.6% -1.1% A 49 Other Assets 50 TOTAL ASSETS 51 52 CURRENT LIABILITIES 53 Vehicle Floorplan Payable 54 Accounts payable 55 Commercial Paper 56 Current Maturities of Long Term Debt 57 Other Current Liabilities 58 TOTAL CURRENT LIABILITIES 59 Long Term Debt, Net off current maturities 60 Non current operating Lease Liabilities 61 Defferred Income Taxes 62 Other Liabilities 63 TOTAL LIABILITIES 64 COMMITMNENTS AND CONTINGENCIES 65 SHAREHOLDER'S EQUITY 56 Preferred stock 67 Common stock 68 Additional paid in capital KEN Consolidated Balance Sheets Consolidated Statements of Inco Ready $421.9 -$15.9 -$460.0 $311.3 $28.6 $557.9 -$347.7 $305.0 $45.3 $12.6 $567.9 -10.6% -5.2% -73.0% 702.7% 4.2% -9.9% -18.1% 0.0% 50.4% -4.6% -7.1% $0.0 $0.0 $15.1 Consoldated Statements of Cash 096 0.0% 72.6% FE O Home Insert JU MILI. Salernens (2) - Microsoft Excel Page Layout Formulas Data Review View X cut Calibri -11 A Wrap Text Currency BT A Copy Paste Format Painter Clipboard B79 . AutoSu Fill- SEB Merge & Center 05 Insert Delete Format Font Conditional Format Cell Formatting as Table - Styles Styles Alignment Number Cells A B D E $567.9 -7.1% 63 TOTAL LIABILITIES 64 COMMITMNENTS AND CONTINGENCIES 65 SHAREHOLDER'S EQUITY 66 Preferred stock 67 Common stock 68 Additional paid in capital 69 Retained earnings 70 Treasury stock 71 Total Shareholders equity 72 TOTAL LIABILITIES AND SHAREHOLDERS EQUITY $0.0 $0.0 $15.1 $450.0 -$19.0 $446.1 $121.8 0% 0.0% 72.6% 13.9% 3.5% 16.4% -1.1% 73 74 75 Debt Equity Ratio for 2019: Total Liabilities/Total Owners Equity = $ 7381.2/$ 3162.1= $ 2.3 76 79 79 80 81 82 Consolidated Balance Sheets Consolidated Statements of Inco Consolidated Statements of Cash Home Insert Page Layout Auto Nation simplified financial statements (2) - Microsoft Excel Formulas Data Review View 11 A 9- Wrap Text Currency * Cut La Copy Paste Format Painter Clipboard B79 ru - 2. AutoSum Merge & Center % | .09 Font Alignment Conditional Format Cell Formatting - as Table - Styles Styles Insert Delete Format Number fi Sort & Find 2 Clear Editing A E D Dec. 31, 2018 F G 1 B Consolidated Balance Sheets - USD ($) $ in Millions 2 CURRENT ASSETS: Dec. 31, 2019 3 Cash and cash equivalents $ 42.0 4 Receivables, net $ 916.7 5 Inventory $ 3,305.8 6 Other current assets $ 38,882.0 7 Total Current Assets $ 4,411.1 8 PROPERTY AND EQUIPMENT, NET $ 3,174.6 9 OPERATING LEASE ASSETS $ 333.1 10 GOODWILL $ 39,828.0 11 OTHER INTANGIBLE ASSETS, NET $ 581.6 12 OTHER ASSETS $ 541.0 13 Total Assets $10543.30 14 CURRENT LIABILITIES: 15 Vehicle floorplan payable $ 3,575.8 16 Accounts payable $ 290.3 17 Commercial paper $ 170.0 18 Current maturities of long-term debt $ 355.6 19 Other current liabilities $ 708.5 20 Total Current Liabilities $5,100.2 Consolidated Balance Sheets Consolidated Statements of Inco Consolidated Statements of Cash Ready 0.4% 8.7% 31.4% 1.4% 41.8% 30.1% 3.2% 14.2% 5.5% 5.1% 100.0% $48.6 $ 976.2 $ 3,650.5 $ 208.7 $ 4,884.0 $ 3,155.3 $ 0.0 $ 1,513.2 $ 595.4 $ 517.2 $10665.10 0.5% 9.2% 34.2% 2.0% 45.8% 29.6% 0.0% 14.2% 5.696 4.896 100.0% 33.9% 2.8% 1.6% 3.4% 6.79 48.4% $ 3,997.7 $ 306.2 $ 630.0 $ 44,3 S 679.9 $ 5,658.1 37.5% 2.9% 5.9% 0.4% 6.4% 53.1% o