Calculate Profitability Ratios: a. Gross profit margin % b. Income before tax / Owner's equity c. Sales/Total assets d. Income before tax/Total assets e. Sales / Working Capital

X Calibri 11 Wrap Text General AA== BOA Paste BIU Merge & Center - $ - % 48-58 Insert Conditional Format as Cell Formatting Table Styles Styles Clipboard 15 Font Alignment Number N16 fo D E F G H . 4246 228 7458 2127 -28695 -34831 4018 5331 -15 6136 -52 69 3949 5346 1576 6188 859 1145 A B 21 22 Pretax Income 7718 23 Total Income Taxes -1897 24 25 Income Before Extraordinary Items 26 and Noncontrolling Interests 9615 27 Noncontrolling Interest - Inc Acc -72 28 29 Income Before Extraordinary 30 Items & Discontinued Operations 9687 31 Preferred Dividends 0 32 33 Available for Common 9687 34 Savings Due to Common 35 Stock Equivalents 0 36 37 Adjusted Available for Common 9687 38 Extraordinary Items 0 39 Discontinued Operations 0 40 41 Adjusted Net Income 9687 42 Income to Company Incl Extraordinary 43 Items & Disc Ops 9615 44 XYZ Balance Sheet XYZ Income Statement 2804 3770 5329 0 0 -470 2804 0 0 3770 0 0 4859 0 0 4859 2804 3770 6136 5331 4018 L Search Cinement. File Home ins Page Layout Add X 11 | A A Great F Insert Delete Fon Paste BT Mergea Center - Conditional Formats Call Formatting - Table Styles Styles Mh Chipboard Font Alignment N16 3 c D E F H 1 2001 3770 A 41 Adjusted Net Income 42 Income to Company incl Extraordinary 43 Items & Disc Ops 9615 4018 5831 6.11 1.75 2.71 6.11 1.75 2.71 5.91 1.65 2.38 2.92 45 46 Earnings Per Share Basic 47 Excluding Extra Items & Disc Op 48 Earnings Per Share Basic 49 Including Extre Items & Disc Op 50 Earnings Per Share Diluted 51 Excluding Extra Items & Disc Op 52 Earnings Per Share Diluted- 53 Including Extra Items & Disc Op 54 EPS Basic from Operations 55 EPS Diluted from Ops 56 Dividends Per Share 57 Com Shares for Basic EPS 58 Com Shares for Diluted EPS 59 2.92 2.38 2.88 2.52 0.23 5.91 5.01 4.87 1.38 1586 1640 1.65 3.06 2.9 1.2 1605 1687 1393 1566 1675 1676 60 61 62 63 XYZ Balance Sheet XYZ Income Statement O Search L AutoSave OCH Home File Insert Formulas Data Review View Help Add-ins Page Layout Calibri General 111 A A == 29 Wrap Text - OAE Merge & Center Ins Paste BIU- $ -% -08 Conditional Format as Cell Formatting Table Styles Styles Number Clipboard Alignment Font 151 B B C G H 1 D E F ANNUAL BALANCE SHEET ($ thousands) 12/31/2020 12/31/2019 12/31/2018 21/31/2017 24991 26388 13764 0 12864 29514 25606 13642 0 14908 30240 22813 14039 0 28096 14439 14714 0 12747 14409 1 XYZ Corporation 2 3 4 5 6 ASSETS 7 Cash & Equivalents 8 Net Receivables 9 Inventories 10 Prepaid Expenses 11 Other Current Assets 12 13 Total Current Assets 14 Gross Plant Property & Equipment 15 Accumulated Depreciation 16 17 Net Plant Property & Equipment 18 Investments at Equity 19 Other Investments 20 Intangibles 21 Deferred Charges 22 Other Assets 23 24 TOTAL ASSETS XYZ Balance Sheet 83670 78007 63750 44078 9275 81501 36679 7429 69996 31662 5817 12349 51401 9201 18500 5947 0 31464 34803 8350 16006 6410 0 29250 8094 14354 7228 0 25845 6883 6954 8782 0 30962 28438 25917 177677 166344 149422 194520 XYZ Income Statement + Search Calibri 11 X LG ' " 53 Wrap Text General Paste Insert BIU $ % 48-58 3-O-A E Merge 8 Center Alignment Conditional Format as Cell Formatting - Table - Styles Styles Number F Font Clipboard 151 B D E G H 1 0 31464 0 28438 F 0 25917 0 0 20962 194520 177677 166344 149422 0 0 19562 4629 889 14158 23621 24062 0 0 14988 22529 0 5726 22458 25166 0 5063 18245 0 4844 19789 5865 21977 A 21 Deferred Charges 22 Other Assets 23 24 TOTAL ASSETS 25 LIABILITIES 26 Long Term Debt Due In One Year 27 Notes Payable 28 Accounts Payable 29 Taxes Payable 30 Accrued Expenses 31 Other Current Liabilities 32 33 Total Current Liabilities 34 Long Term Debt 35 Deferred Taxes 36 Investment Tax Credit 37 Other Liabilities 38 39 TOTAL LIABILITES 40 Redeemable Noncontrolling Int. 41 EQUITY 42 Preferred Stock - Redeemable 43 Preferred Stock - Nonredeemable 44 XYZ Balance Sheet 65701 62412 22025 53992 10532 503 71466 43549 0 0 39182 31853 0 0 44099 0 38733 0 47295 112422 154197 0 141653 0 123170 0 0 0 0 0 3109 0 10391 0 XYZ Income Statement O Search Calibri 11 TAA Wrap Text X 00 General BIU O. AEE E Merge & Center $ - % 98 99 Conditional Format as Cell Formatting Table Styles Styles Alignment Font Number Clipboard 151 B E D F G A H 1 0 0 0 oo 10391 3109 0 0 0 3109 15 16 28937 6504 0 27607 12249 0 10391 14 23834 2005 15 28780 10703 0 0 41 EQUITY 42 Preferred Stock - Redeemable 43 Preferred Stock - Nonredeemable 44 45 Total Preferred Stock 46 Common Stock 47 Capital Surplus 48 Retained Earnings 49 Less: Treasury Stock 50 51 Common Equity 52 53 Stockholder's Equity - Parent 54 Nonredeemable Noncontrolling Int. 55 56 Stockholder's Equity - Total 57 58 TOTAL LIABILITIES & EQUITY 59 COMMON SHARES OUTSTANDING 60 61 39871 25853 35457 39498 36244 39871 452 35457 567 42607 567 756 36024 43174 37000 40323 194520 1500 177677 1600 166344 1500 149422 1366.374 62 63 64 XYZ Balance Sheet XYZ Income Statement o O Search