i need these ratios in excel format. thank you

Four profitability ratios Gross profit margin Gross Profit Net Sales Profit margin ratio Return on assets ratio Net Income Net Sales Net Income (Beginning Assets + Ending Assets)/2 Net Sales (Beginning Assets + Ending Assets)/2 Asset turnover ratio A1 3 1 2 2020 As of December 31 2019 (Muhan Data Change 2020 - 2019 Horrontal Analysis % Change Change 2020 - 2019 2019 - 2018 % Change 2019 - 2018 1 7 Art Carrels Cash.cashq Remited ca Am $129,20 3 136.29% 13% 131 $25.60 16 14 36.99% 2.71% 3215 . SU 66 10 11 12 23 30 50 15656 56.30 1.34 65.4 IN 574 59 1.1496 5733 SO % 164 925 . 1.38% 9486 H6 7353 11.0356 12. 19593 23 1644 31.599 341 2763 8.00% 23187 35.15 21052 37.815 2,100 04.04 4313 44 35796 420 0.06 264 KAIS 699 6445 100.00% 600.000.00153517500 100.00% WE SEK SINE 0 Prepaid expenses the Title hoperty and persing Goodwill Difered income Oder om Tatalten 14 -111 1923 2473 -30.8 135 45 -29 -97 $365.20 92.38% 25 51% 12.62% -1114 09 -9.45% -100.00% -10 6,01% 313 93.7 325 2765 204.40 329 - 139 137 $905.70 47.28 14.15% 19.05 ADIV/01 9.73 7.42% 3740X 4.715 17.50% WP 10 . re TE 10 1969 SA 599.90 104 . Ladies and Share Current Cine powd Current operating Acope Acred prill herine Other current 5100 44 20.4 $3.50 104 46 22.1 1. 95 0.00% 1.99 14496 os LE PE 4 T18 1934 (1.1 TI 7193 2105 114 166 33 10.09 210X 20:57 4517 28.1 OSIN . DIV/OI SIN 117 3279 9.01N 7.213 1824 344 3110 6725 26 18 23 6.73% 31 11. UN ser 14.7 355 -3.7 101 45 ICE 11.00 Longum deferent 3358,4 10.04 10033 75% 2.714 2.478 47. 2273 564.70 21.0 21 3094 5 Long to operating Self insured risks 3.29 13% 3435 1172 510 5661 2016 2.31 -342 4 14.02 3.41% 2433 -2.4 DIV/! -2013 20 TI BS- 15 - CF - Ratios AT D F H 1 3 M 20 3250.6 50.43% 10233 49.72% 2.478.60 47.50% 227.3 7.52% 544.70 21.98% 29 30 Long-term debt, net of current portion Long-term operating se liabilities Self-insured Deferred income tax liabilities Other long-term liabilities 14.03% 3.41% 209,6 121.2 SLR 93.8 44443 3.25% LESS 0.00% 1.46% 68.9596 0.009 243.8 4,016 117.2 1.9394 0 0.00% 42.7 0.70% 4148 2.225 0.00% 0 119.6 0 356 33563 0.00% 2.3196 0.0096 1.65% 64.86% 0.00% -342 4 518 51.1 296,3 243.8 -24 0 42.9 7917 0 #DIV/01 -2,01% #DIV/0! 50.1296 23.59% DIV/O: 22 119,67% 7.14% 34 Commitment and contingencies 35 31.6 2196 38% 261.7 5.06% -208 -86.81% -221 -8.44% 36 30 39 40 Redeemable no controlling interest Shareholders' equity Encompass Health anders equity Comme vleck, Solpa value, 200,000,000 shares here: isied: 113.835,708 2020: 113,230,774 in 2010 Capital in excess of par value Accumulated deficit Treasury stock, ato (14.40.23 shares in 2020 and 14637,855 Sures in 2019) Total Encome Health shareholders quity Noncontrolling interest Total shareholders' equity Total liabilities and shareholders equity 1.1 0.02% 2326.6 36.09% -2423 3.76% LI 33699 -5265 0.09 38.97% -8.6694 1.1 0.02% 2587 50.02% -852-17.11% 0 -433 284.2 0.00% -1 83% -53.98% 0 -2188 358.7 0.00% -8.45% 40.52% 11 -497.4 -7.72% -1923 -8.10% 427.9 3.27% -5.1 104% -64.4 15.OS 2 1588 382 1970 34.64% 5.01 30.5656 12532 3409 20.61% 0.276.70 561% 2803 27.54% 1557 34.67% 5429 30.09% 334.8 411 276.9 26.7296 12.06% 16.35% -23.50 60.6 136 -1.84% 21.62 8.74% 1691.1 64459 100.00% 60807 100.00% 55,175.00 100.00% 365.2 6,01% $905.70 17.50% 16 47 3 F 0 1 2 3 2020 For the Year Ended December 31, 2019 (In Millions) 100.00% $4,605.00 100.00% 2018 4 $4,644.40 5 $4,277.30 100.00% 6 2,573.00 623.6 823 167.9 247 218.7 10 2,354,00 585.1 78 158.7 220.2 199.7 52 3,647.70 12 2.682.00 634.4 81.2 200.5 155.5 243 2.8 3999.4 2.3 1842 -10.6 -3.5 4726 103.8 368 8 Net operating revenues Operating expenses Salaries and benefits Other operating expenses Occupancy costs Supplies General and administrative expenses Depreciation and amortization Government, class action, and related settlements Total operating expenses Loss on carly extinguishment of debt Interest expense and amortization of debt discounts and fees Other income Equity in net income of nonconsolidated affiliates Income from continuing operations before income tax expense Provision for income tax expense Income from continuing operations (Loss) income from discontinued operations, net of tax Net Income Less: Not income attributable to noncontrolling interests Net income attributable to Encompass Health 14 15 57.70% 13.70% 1.70% 4.30% 3.30% 5.20% 0.10% 86.10% 0.00% 4.00% -0.20% -0.10% 10.20% 2.20% 7.90% 0.00% 7.90% -1.80% 6.10% 35.90% 13.50% 1.80% 3.6096 5.40% 4.7096 0.00% 85.00% 0.20% 3.50% -0.704 -0.10% 12.20% 2.50% 9.70% 0.00% 9.70% -1.90% 7.80% 147.3 55.00% 13.7096 1.80% 3.70% 5.10% 4.70% 1.20% 85.30% 0.00% 3.40% -0.10% -0.20% 11.50% 2.80% 8.80% 0.00% 8.8094 -1.909 6,8096 15 3,912.50 7.7 159.7 -30% -6.7 5623 115.9 4464 -0.6 445.8 -87.1 358.7 18 19 20 21 22 23 24 25 26 -8.7 493.2 1189 3743 1.1 375.4 -83.1 2923 3688 -84.6 284.2 AT 1 2 2020 C For the Year Ended December 31 2019 (in Millions) 2015 5 $368.80 $2.35% 5445.80 70.17% 0.099 $175.40 -1.1 202 19.24% 0.101 7 2.8 243 7.2 2.3 52 199,7 4 10 13 12 13 14 15 3.8 29.5 52.4 218.7 4.5 7.2 6,7 6.6 114.4 40 -19.2 74 -7 NO 85.9 TH T7 5.9 0.40% 34.48% 1.02 0.33% 0.50% 0.5 4.19% 7.4% 0.00 0.8% 0.00% 3419 0.01% 1.93 13.00 10.63% -0.0094 47 67 100% Cash flows from operating activities Net income Loss (income) from discontinued operations, bet of tax Adjustments to reconcile net income to net cash provided by operating activities Provision for government, class action, and related elements Depreciation and amortization Amortization of debt-related items Loss on early extinguishment of debt Equity in net income of nonconsolidated after Distribution from nonconsolidated sites Stock-based comportation Deferred tax expense (beschi Gain on consolidation of Yuma Rehabilitation Hospital Othernet Changes in amets and liabilities, net of acquisitions - 19 Accounts receivable 20. Prepaid expenses and other it Accounts payable Accrued payroll Other abilities Net cash (used in provided by operating activities of discontinued operation 25 Total adjustments 20 Net cash provided by operating activities 27 Cash flows from investing activities 2 Acquisition of businesses, net of cuth acquired Purchases of property and equipment Additions to capitalized software costs Purchases of intangible assets Proceeds from sale of restricted investments 0.00 34429 0.71 1.21% 1.05 1.04% 18.01% 0304 3.02 1.16% 0.009 100% 3.37% 09036 2009 20.2016 0.00% 29.73% 10094 2 6.82% 21 05 004 -1.1494 1.00 112 1.10 0.00% 13 0.00 0.99 1.519 0.1% 19% ON 0.1016 $0.99 10046 -720 11.5 21 14 38.1 0.1 1326 92 -74.9 -0.2 135.0 70.7 -354 6.1 132 1280 -4 1 6353 20 24 0 381 7624 2315 -3724 -1439 -2545 -16 -1.1 -396 -8.7 -1.5 12.6 36.44 38.629 -2,054 2.99 0.10 -56.19% -1.2016 -0.50% 1.79% 19 18.875 -33% -2.10 0.73% 1.53% -18.7 176 116 30 33 CF Ratios 0123- T- 13 - BISA - EL. 00 BT. AT 7047 10096 615 100% 7624 10044 1.1 396 -87 -35 12.6 7 2.1 -075 -0.161 56.1994 -1.235 -0.50% 1.79 12345 -0.301 57.809 -2013 -3724 -13 -17 176 -320 5862 -2059 2949 2.771 3.18% 10 -10350 -149 2545 -16 -5.7 11.6 -135 -2.7 4245 -IKT -333% 2.10 -0.7546 1529 -1.709 -0.355 -55.70% 6574 12 1.000.00 -5195 24 Net cash provided by operating activities 27 Cash nows from investing activities Acquisition of businesses, set of cash acquired Purchases of property and equipment Additions to capitalized software costs 31 Purchases of intangible assets 12 Proceeds from sale of restricted investments Purchases of restricted investments Othernet 33 Net cash used in investing activities Cash Nows from financing activities Proceeds from bondance 20 Principal payments on see, including pee payments 20 Borrowings on revolving credit facility Payments on revolving credit facility Principal payments under finance les obligations Debt amendment and we can 43 Repurchases of common stock, including fees and expenses Dividends paid on common stock Purchase of equity interests in consolidated affiliate 40 Distributions paid to controlling interests of consolidated affiliates Taxes paid on behalf of employees for shares wield Contributions from consolidated affiliates 49 Othernet Net cash (used in provided by financing acties Increase in cash, cash equivalents, and restricted cash Cash, cash equivalent and restricted cash at beginning of year Cash, cash equivalents, and restricted cash at end of year 20.6 325 -190 -179 -01 4 -195 -215 9925 -7183 30 -375 -225 -20.3 -6.1 -1119 -1623 -722 15.7 349 1 140. -101.93% 464 53.21% 3.19% -25% -0.87% -15816 28.035 -10.25% 2.23% 4.95% 0.10 -30.7096 21.5096 22.6096 44.1046 -1067 -1629 157.419 -3177% 99.99% -97591 3.075 -3.3855 -71223 - 17.11 25.645 12 -2615 2.500 1319 7.60% 4105 20.00 25.1046 0.00 2.709 42619 51.15% -25 -0.01 0.00% -13.236 549 9 -100% 1659 2509 -42.109 2300 15.305 17.50% 42 -1003 -651 754 3 126 194 -1212 167 1168 1333 -166 159 1513 159.6 310. M 1333 159.6 a