I need these ratios but in excel format. thank you

there is no 2017 balance sheet data

thats all the information I have.

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 2030 As of December 31. 2019 Millien, Except Share Data) 2018 s Change 2020 - 2019 Horizontal Analysis % Change s Change 2020 - 2019 2019-2018 % Change 2019-2018 4 5 7 Assets Current and Cash and cash valet Restricted cash Accounts receivable 3124.00 3.48% 1.01% 3.89% 594.80 574 506,1 1.56% 0.94% 8.32% 564920 59 467.7 1.34% L1456 $129.20 R 66.7 136.29% 13.94% 13.18% $25,60 -1.6 38.4 36.99% -2.71% 8.21% 572.8 TO 11 12 10 14 15 TE Prepaid expenses and other cures Total met Property and equipment, Operating a night-of- Goodwill Intangibles, Deferred income tax Citer long-term as Total 1.34% 975 160% 66.2 1.28% 9486 14.72% 755.8 12.4396 6621 12.79% 2206.6 14.2396 19393 32.21% 1614 31.59% 3457 3.819 276,5 4.55% 0 0.00% 2318.7 35.97% 23052 37.91% 2,100 80 40.60% 431.3 6.9% 4763 7.81% 4434 N$796 . 0.00 2.9 0.05% 4.29 0,08% 295 4.58% 304,7 5.01% 56,445.90 100.00% 56,080.70 100.00% 55.125.00 100.00% -111 1928 2473 -308 135 45 -2.9 9.7 $365 20 -11 38% 25.51% 12.62% -11.14% 0.39% -9.45% -100.00 -3.18% 6.01% 31.3 93.7 324.5 276.5 204.40 32.9 1.39 13.7 $905.70 47 28% 14.15% 19.85% NDIV/OI 9.73% 7.42% -32 40% 4.71% 1750N 17 10 0.65% 22 23 Liabilities and Shareholders' Equity Current liabilities Current portion of long-term det Current operating te labilities Accounts payable Accrued payroll Accrual interest Nyable Other pent listes Totalisht Long-term det, net of current portion 30 0.595 44 0.70% 115 1.78% 253.8 3.94% 47.1 0.7394 INS 3394 7173 11.13% 319.30 404 94,6 2105 324 303 721 335.10 0.6994 "O 0.0094 90 1.74% 1884 3.614 24.4 0.47% 333.0 645% 672.5 13.00% 1.56% 3.46% 0.53% K. 11.86% $1.00 44 20.4 433 147 85.5 3.7 2.54% 10.89% 21.56% 20.57% 45.37% 28.14% 0.51% 25 $3.50 9.785 40.4 HDIV/01 4,6 5.11% 22.1 11.73% 8 32.79% 10.1 -9,01% 48.5 7.21% 17 32506 500 30213 49.72% 3,478.0 47.00% 227.3 752% 544.70 21.987 Long-term opereliabilities 2096 343 4.0196 0 0.00% -342 -14.03% 2438 WDIV/OI + BS- CF - Ratios - . = GD . 1 A1 B D F H 2183 3038 26 Other current liabilities 27 Total current liabilities 20 Long-term debt, net of current portion 3.39% 11.139 E 5.00% 11.86% 7173 721 333.9 6.45% 672.5 13.00% -85.5 -3.7 -28.14% -0.51% -30.1 48.5 -9.01% 7.21% 3250.6 50.43% 3023.3 49.72% 2,478.60 47.90% 227.3 7.52% 544.70 21.98% Long-term operating lease liabilities Selfrisured risks Deferred income tax liabilities Other long term liabilities -14.03% 3.41% 209.6 121.2 515 93.8 44443 3.25% 1.88% 0.80% 1.4696 68.95% 0.00% 12 33 34 243.8 4.01% 117.2 1.93% 0 0.00% 427 0.70% 4148 68.31 0.00% 0 0.00% 119.6 2.31% 0 0.00% *5.6 1.65% 31563 666% 0.00% -342 4 51.8 51.1 2963 243.8 -2.4 0 42.9 791.7 0 #DIV/0! -2.01% #DIV/01 -50.12% 23.59% NDIV/01 119.67% 7.14% 31,6 8.49% 239.6 3.94% 261.7 5.06% -208 -86.81% -22.1 -8.44% 27 29 40 Commitments and contingencies Redeemable no controlling interests Shareholders' equity: Encompass Health shareholders' equity: Common stock, 5.01 pa value; 200,000,000 shares autorid; issued: 113.835,708 in 2020: 113.230.774 in 2019 Capital in excess of par value Accumulated deficit Treasury stock, etcom (14.425,235 shares in 2020 and 14,637,85 shares in 2019) Total Encompass Health scholders equity Noncontrolling interests Total shareholders equity Total liabilities and shareholders equity 1.1 1326.6 0.0296 36,09% -3.76% 1.1 23699 -526,5 38.97% -1.66% 0.02% 2588.750.02% 35.2 17.11% 0 -43.3 284.2 0.00 -1.83% 53.98% -2188 3527 0.00 -8.45% 40.52% 41 4974 -7.7294 4922 -8.10% 4279 -8.2796 5.1 104% -644 - 15.05% 1588 24.64% 32 5.93% 1253.2 20.61% 1,276,70 24.67% 340.9 5.6196 280,3 5.42% 1693.1 27.84% 30.09% 334,8 41.1 276.9 26.72% 12.06% 16.35% -23.50 60.6 136 -1.84% 21.62% 8.74N 4 1970 30.56% 1.357 45 6445.9 100.0094 GONO.7 100.00% 35,175.00 100.00% 365.2 6.01% $905.70 17.50X 1 2 2020 2018 For the Year Ended December 31, 2019 (In Millions) 100.00% $4,605.00 100.00% 3 4 $4.644.40 $4,277.30 100 5 6 7 5 1 2,573.00 623.6 82.3 167.9 247 218.7 9 2,354.00 585.1 78 158.7 220.2 199.7 52 3,647.70 10 11 12 2,682.00 634.4 81.2 200.5 155.5 243 2.8 3999.4 23 184.2 -10.6 -3.5 472.6 103.8 368,8 13 14 15 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: Net income attributable to noncontrolling interests Net income attributable to Encompass Health 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% 55.90% 13.50% 1.80% 3.60% 5.40% 4.70% 0.00% 85.00% 0.20% - 3.50% -0.70% -0.10% 12.20% 2.50% 9.70% 0.00% 9.70% -1.90% 7.80% 16 3,912.50 7.7 159.7 -30.5 -6.7 562.3 115.9 446.4 -0.6 445.8 -87.1 358.7 17 18 19 147.3 -2.2 -8.7 493.2 118.9 374.3 1.1 375.4 -83.1 292.3 20 25 22 23 24 25 368.8 -84.6 284.2 c F 1 1 2020 For the Year Ended December 31, 2019 (in Millions) 2018 3 + 1 5368,80 52.33% $445.80 0,6 70.1796 0.0994 5375.40 -1.1 20 49.24% -0.1496 3 52 199.7 4 19 11 12 3 2.8 243 7.2 2.3 -3.5 3.8 29.5 52.4 -8.7 83 859 .9.1 Cash Nows from operating activities: Net income Loss (income) from discontinued operations, net of tax Adjustments to reconcile net income to net cash provided by operating activities - Provision for government, class action, and related settlements Depreciation and amortization Amortization of debt-related items Loss on early extinguishment of debt Equity in net income of nonconsolidated affiliates Distributions from nonconsolidated affiliates Stock-based compensation Deferred tax expense (bencfit) Gain on consolidation of Yuma Rehabilitation Hospital Othernet Changes in assets and liabilities, net of acquisitions Accounts receivable Prag expenses and other assets Accounts payable Accred payroll Other liabilities Net cash (used in) provided by operating activities of discontinued operations Total adjustments Net cash provided by operating activities Cash flows from investing activities: 218,7 4.5 * 7.7 -6.7 6,6 114.4 40 -19.2 7.4 TE 18 to 0.40%- 34.48% 1.02% 0.33% -0.50% 0.54% 4.1996 7.44% 0.00% 0.84% 0.00% -5.41% 0.0194 1.93% 13.06% -10.63% -0.03% 47.67% 100% 5.9 0.00% 34.4296 0.71% 1.21% - -1.0596 1.04% 18.01% 6.306 -3.02% 1.16% 0.00% -3,60% -5.5796 -0.94% 2.08% -20.29% -0.699 29.73% 100% 9.2 6.82% 26.1990 0.52% 0.00% -1.14% 1.0994 11.2796 -1.1996 0.00% 1.2154 0.00% 0.92% 1.51% 0.8756 1.94% 0.8096 0,10% 50.91% 100% 18 1 20 11 -38.1 0.1 11.6 92 -74.9 -0.2 335.9 7047 -22.9 -35.4 -6.1 13.2 -128.9 -4.4 188.9 613.3 7 11.5 6.6 14.8 6.1 0.8 388.1 762.4 25 21 11 -1.1 -396 -8.7 -3.5 12.6 -8.7 -2.1 -407.5 -0.16% -56.19% -1.23% -0.50% 1.79% -1.23% -0.30% -57.80% -2315 -3724 -13 -187 176 -32.9 -6.5 -657,4 -36.449 -58,62% -2.05% -2.94% 2.77% -5.18% -1.02% -103.50% -143.9 -254.3 -16 -3.7 11.6 -13.3 -2.7 -4245 -18.87% -33.38%, -2.10% -0.75% 1.52% -1.74% -0.35% -55.70% 77 Cash flows from investing setivities: Acquisition of businesses, set of cash acquired Purchases of property and equipment 3D Additions to capitalured software costs Purchases of intangible assets 22 Proceeds from sale of restricted investments Purchases of restricted investments 30 Other, net 31 Net cash used in investing activities 35 Cash flows from financing activities: 37 Proceeds from bond issuance 30 Principal payments on debt, including pre-payments > Borrowings on revolving credit facility 10 Payments on revolving credit facility 41 Principal payments under finance les obligations Debt amendment and issuance costs Repurchases of common stock, including foos and expenses Dividends paid on common stock Purchase of equity interests in consolidated affiliates 16 Distributions paid to non controlling interests of consolidated affiliates Taxes paid on behalf of employou for share withheld Contributions from consolidated afslates Othernet Net cash (used in) provided by financing activities 11 Increase in cash, cash equivalents, and restricted cash Cash, cash equivalents, and restricted cash at beginning of year - Cash, cash equivalents, and restricted cash at end of year -20.6 125 -390 -179 -0.1 992.5 -718.3 330 -375 -22.5 -20.3 -6.1 -111.9 -162.3 -72.2 -15.7 14.9 1 -145.9 151.3 159,6 140,84% -101.93% 46.3% -53.21% -3.19% -2.8% -0.87% -1588% 23.01% - 10.2596 -2.23% 49594 0149 -20.70% 21.50% 22.60% 44.10% 1,000.00 -519.5 635 -620 -19.5 21.5 -459 -1082 -1629 79. 16.6 15.9 -83 48.2 26.1 1335 159.6 157.41%- -81.77% 99.95% 97.599 -3.07% -3.3896 -7.229 -17.1194 -25,64% -12.56% -2,61% 2.50% 1.119 7.6096 4.10% 21.00% 25.10% -1013 -65.1 -75.4 0.00% -2.70% 42.63% -51.15% -2.35% -0.01% 0.00% 13.22% 8.54% -9.99% 1.09 1.65% 2509 -42.10% 2.20% 15.30% 17.50% 12.6 19.4 -3212 16.7 116 1333 110.9 CF Ratios A1 1 2 2020 As of December 31 2019 (la Maphar Bata) Change 2020 - 2019 Horrontal Analysis % Change Change 2020 - 2019 2019 - 2018 % Change 2019-2018 1 1 Art 7 $129.20 136.294 Currean Cash cash Remited Acum 1 8 $25.60 16 14 36 99% 2.71% 3213 ELS 13.18% 10 11 12 RE NEPE 313 93.7 9340 5940 15656 574 25% 59 1.169 SO 4673 64 925 1.28% 735 11.43% 12.74 19593 31.5 3417 3. 2753 8.00% 2017 3.75 23052 37.815 2,100 04.04 13 4 3574 420 6.6 14 AIS 201 SAN 1544509100004 6049 10 100.00 35.00 100.0046 9815 WEE SUER Prepaid expenses and the Titlu Property and get Opramatimestants Goethe ble at Difered income her long Total 10 -111 1928 2473 -30.3 135 45 -20 -27 $165.20 -12.38 25 51% 12.62% 1114% 0.39% 9.45 -100 CON 3105 6,01% 2765 20440 47.25 14.15% 19.05% ADIV/01 9.73 7:42N -1200X 4.715 17.SON 18 10 - 139 237 $905.70 TE 19 11 8,65 335.0 97 39.90 104 Lane and Share Current a Cine portioned Curre operating we Accuble Acred prayel herine Other Tulle 6.9% L. 16 0.009 1.99 16 . 50 14 O/MON SETS TI 1914 2105 334 -5100 44 20.4 43 147 55 -3.7 7.54 10.09 2150X 20:57 4537 -28.14 OSIN $8.50 404 45 22.1 3 10.1 US 33 TE TE CHIE 1173 3279 9.01 7,21 6.71 3314 11.IN 10 22 10 ICE 311 6723 T193 100% 31584 16.04 1003 2.14 3.478 47.99 2273 752 564.70 21. SON Long-term del ferro Lengte operating Self insured risks 2438 o 2004 1113 56109 96661 0.0016 2.3116 -342 4 14.02 3.415 2433 -24 DIVO -2013 20 13 1172 119 BS- 15 - CF - Ratios - AT D F H 1 3 20 Long-term debt, net of current portion 33:50.6 50.43% 10233 49.72% 2,478.60 47.90% 2273 7.52% 544.70 21.98% 30 Long-term operating se liabilities Self-insured riscos Deferred income tax liabilities Other long-term liabilities 209,6 121.2 SLR 93.8 - 14.03% 3,41% 31 32 3.255 LAS 0.00% 1.4% 68.95% 0.00% 243,8 1172 0 42.7 4148 4,0196 1.9394 0.00% 0.70% 68.22% 0.00% 0 119.6 0 356 33563 0.00% 2.3196 0.00% 1.65% 64.86% 0.00% -342 4 518 51.1 296.3 243.8 -2.4 0 42.9 7912 0 119,67% 7.14% #DIV/0! -2.01% #DIV/01 -50.12% 23.59% #DIV/OI 143 Commitment and contingencies 31.6 0.49% 2196 34 261.7 5.06% -208 -86,81% -221 -8.44% 30 39 40 Redeemable no controlling interest Shareholders' equity Encompass Health and equity Common ock, 5.0 por value: 200,000.000 shares authorised: isied: 113.835,708 in 2020: 113,230,774 in 2019 Capital in excess of par value Accumulated deficit Treasury stock, ato (14.40.23 shares in 2020 and 14,637,855 Sures in 2019) Total Encome Health shareholders quity Noncotrolling interest Total shareholders equity Total liabilities and sharealders equity 1.1 2326.6 36.09% 3.76% 11 33699 -5265 0.035 38.97% -8.6694 1.1 0.02% 2587 50.02% -*852-17.11% 0 433 2842 0.00 -1 83% -53.98% 0 -2188 358.7 0.00% -8.45% 40.52% 11 -497.4 -4923 427.9 104% 15.05% 158 382 1970 14.64% 5.93% 30.5656 12512 3409 16931 20.61% 0.276.70 561% 2803 27.84% 1557 24.679 5.42% 30.0996 334.8 411 276.9 26.72% 12.06% 16.35% -23.50 60.6 136 -1.84% 21.62% 8.74 64459 100.00% 6080.7 100.00% 55,175.00 100.00% 365.2 6.01% $905.70 17.50% 47 3 F 0 1 7 3 2020 E For the Year Ended December 31, 2019 (in Millions) 100.00% $4,605.00 100.00% 2018 4 54.644.40 5 $4,277.30 100,00% 6 2 2,573,00 623.6 823 167.9 247 218.7 10 11 2,354.00 585.1 78 158.7 220.2 199.7 52 3,647.70 12 T3 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 3688 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.109 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.60% 5.40% 4.7095 0.0096 85.00% 0.20% 3.50% -0.704 -0.10% 12.20% 2.50% 9.70% 0.00% 9.70% -1.90% 7 8096 147.3 55.00% 13.70% 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.809 -1.90% 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 -8.7 493.2 1189 3743 1.1 375.4 -83.1 29231 23 3688 -84.6 2842 24 25 26 - AT . 1 2 2020 C For the Year Ended December 31 2019 (la Millions) 2015 5 22 5 $368.80 52.35% 5175.40 5445.80 0.6 20.179 0.099 19.24% 1.10 7 2.8 243 7.2 2.3 52 199,7 4 10 13 12 13 0.00 34429 07 1.21% 1.05 104% 18.01% 30 3.02 3.8 29.5 $2.4 218.7 4.5 7.7 6.7 6,6 114,4 40 -19.2 74 - NO 859 ...1 15 TR 59 TT 0.40%- 34.48% 1.02 0.33% -0.50% 0.5% 4.19% 7.44% 0.00 0.80 0.00% 5.419 0.0196 1.99% 13.0646 -10.63% -0.03% 476799 100% 2 Cash flows from operating activities Net income Loss (income) from discontinued operations, net of tax Adjustments to reconcile net income to net cash provided by operating activities Provision for government, class action, and related setlements Depreciation and amortization Amortization of debt-related items Loss on early extinguishment of debt Equity in net income of nonconsolidated alates Datribution from nonconsolidated after 16 Stock-based competition Deferred tax expense (benefit Cain on consolidation of Yuma Rehabilitation Hospital Othernet Changes in amets and liabilities, net of acquisitions - 19 Accounts receivable 10. Prepaid expenses and other sta Accounts payable Accrued payroll Other liabilities Net cash (used in provided by operating activities of discontinued operations Total adjustments 20 Net cash provided by operating activities 27 Cash flows from investing activities 2. Acquisition of businesses, net of cash oquired Purchases of property and equipment Additions to capitalized software costs Purchases of intangible assets 3 Proceeds from sale of restricted investments 2199 0529 00 -1.1494 Tom 112 1.19 0.001 12 0.001 0.99 1.51% 0.57% 1994 ON 0.1016 $0.996 10046 7 11.5 -354 20 18.1 0.1 1326 92 -74.9 -0.2 115.9 204.7 0.009 3.60 3:39 -690114 2.00% 20.299 -0.003 29.73% 10054 14 0 112 -128.9 -4.4 19 615 20 24 38.1 1624 231.5 3724 . -396 -8.2 -1.5 12.6 0.16 -56.19% -1.25 -0.50% 1.79% 36.44 -5.62 -3.05 -3.94% 29 1410 -2545 -16 -3.7 11 18.175 -33% -2.10 -0.7394 1.53% 18.7 17.6 31 BS CF- Ratios - 13 BISA - EL. 00 BT- AT 7047 10096 65 100% 7624 10056 0.161 56.199 -1.235 -0.504 -2315 3724 -13 58.625 396 -87 -35 12.6 -87 2.1 -6075 545 16 -5.2 11.6 17.6 -2020 -7% -333 2.10% 0.755 1525 -1.10% -0.35% -55.7044 12:19 0301 -57.809 2.771 3.1% 100 -103 5046 -2.2 4243 6574 Net cash provided by operating activities 27 Cash News from investing activities Acquisition of businesses, net of cash acquired Purchases of property and equipment 30 Additions to capitalized software costs 21 Purchases of intangible assets 12 Proceeds from sale of restricted investments Purchases of restricted investments Other, 35 Net cash used in investing activities Cash flows from financing activities 37 Proceeds from bondissance 21 Principal payments on see, including pre-payments 29 Borrowings on revolving credit facility Payments on revolving credit facility Principal payments under finance as obligations Debt amendment and cost 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 files 49 Othernet 30 Net cash (used in provided by financing acties 51 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 9925 -7183 110 375 -225 -2003 -6.1 1.000.00 -5195 635 -620 20.6 325 -190 -179 -01 -195 - -1067 140. -101.93% 46 53.219 3.19 -2 -0.87% -15% 23.03 -10.25% 2239 4.95% 0.149 -30.7096 21.50%. 22.6096 44.104 1623 -722 15.7 3.9 1 1659 1513 159.6 310.9 157.419 -31.72% 99.99% -975911 3079 -3.3856 -7221 - 17.11 -25.60 -12 -2615 2.50 -13 7,60% LID. 21.00% 25.1046 -166 15.9 0.000 2.701 42.63% 51.15% -2.15% -0.011 0.00 -1322 1854 29.9% -100% 1659 2:54 -42.104 2300 15.309 17.50 -1003 -651 754 83 126 194 -1212 16 116 1335 42 1333 1996