I am having trouble with the historical ratios and competitior ratios
Boing Historical Ratios For the years ended December 31, 2017, 2018, 2019 Competitior Ratio Analysis Northrop Gruman Industry Ratio 2017 2018 2019 Raytheon 1.14128 1.07648 1.05053 0.31891 0.30963 0.26314 1.13260547 1.084167 1.049607802 0.7675649 0.66435 0.69522 0.72825 0.229599163 0.9223671 45.0773 240.678 -11.293 3.659145028 0.8279312 -28.075 -24.429 3.12881 -4.825757576 5.1166977 Liquidity Current Ratio Quick Ratio Leverage Ratios Debt to Total Asssets Ratio Debt to Equity Ratio Long-Term Debt to Equity Times Interested Earned Ratio Activity Ratios Inventory Turnover Fixed Assets Turnover Total Assets Turnover Accounts Recievable Turnover Average Collection Period Profitability Ratios Gross Profit Margin Operating Profit Margin Net Profit Margin Return on Assets (ROA) Return on Stockholders' Equity Earnings Per Share (EPS) Price Earnings Ratio Northrop Grumman Corporation Consolidated Balance Sheets As of December 31, 2019, December 31, 2018, and December 31, 2017 $s in millions Dec. 31, 2017 Dec. 31, 2019 Dec. 31, 2018 Assets 11225 1054 2245 1326 5334 783 997 1579 1448 5026 654 973 3465 398 445 9680 10685 6912 1511 18708 1040 508 1725 16587 4225 0 12455 6372 0 18672 1372 94 1463 37653 52 447 1362 35128 41089 1661 2182 1676 1917 Cash and cash equivalents Accounts receivable, net Unbilled receivables, net Inventoried costs, net Prepaid expenses and other current assets Total current assets Property, plant and equipment, net of accumulated depreciation of $5,85 Operating lease right-of-use assets Goodwill Intangible assets, net Deferred tax assets Other non-current assets Total assets Liabilities Trade accounts payable Accrued employee compensation Advance payments and billings in excess of costs incurred Other current liabilities Total current liabilities Long-term debt, net of current portion of $1,109 for 2019 and $517 for 20 Pension and other postretirement benefit plan liabilities Operating lease liabilities Deferred tax liabilities Other non-current liabilities Total liabilities Commitments and contingencies (Note 12) Shareholders' equity ' Preferred stock, $1 par value; 10,000,000 shares authorized; no shares is Common stock, $1 par value; 800,000,000 shares authorized; issued and Paid-in capital Retained earnings Accumulated other comprehensive loss Total shareholders' equity Total liabilities and shareholders' equity 2226 1865 2237 3106 9434 12770 6979 2499 8274 13883 5755 1382 1761 2288 7092 14399 5511 o 0 994 27996 1308 0 0 1779 0 108 1446 32270 29466 0 168 0 171 0 0 174 44 0 8068 -52 8748 -97 8819 41089 6913 1 7132 35128 8187 37653 F G 61388 B D Boeing Consolidated Balance Sheets As of December 31, 2019, December 31, 2018, and December 31, 2017 $s in millions Assets Dec. 31, 2019 Dec. 31, 2018 Dec. 31, 2017 Cash and cash equivalents $ 9,485.00 $ 7,637.00 $ 8,813.00 Short-term and other investments 545 927 1179 Accounts receivable, net 3266 3879 2894 Unbilled receivables, net 9043 10025 8194 Current portion of customer financing, net 162 460 309 Inventories 76622 62567 Other current assets 3106 2335 2417 Total current assets 102229 87830 85194 Customer financing, net 2136 2418 2756 Property, plant and equipment, net 12502 12645 12672 Goodwill 8060 7840 5559 Acquired intangible assets, net 3338 3429 2573 Deferred income taxes 683 284 321 Investments 1092 1087 1260 Other assets, net of accumulated amortization of $580 and $503 3585 1826 2027 Total assets $ 133,625.00 $ 117,359.00 $ 112,362.00 Liabilities and equity Accounts payable 15553 12916 12202 Accrued liabilities 22868 14808 13069 Advances and progress billings 51551 50676 48042 Short-term debt and current portion of long-term debt 7340 3190 1335 Total current liabilities 97312 81590 74648 Deferred income taxes 413 1736 2188 Accrued retiree health care 4540 4584 5545 Accrued pension plan liability, net 16276 15323 16471 Other long-term liabilities 3422 3059 2015 Long-term debt 19962 10657 9782 Shareholders' equity: Common stock, par value $5.00 - 1,200,000,000 shares authorized; 1,012,261,159 shares issued 5061 5061 5061 Additional paid-in capital 6745 6768 6804 Treasury stock, at cost (54914) (52348) (43454) Retained earnings 50644 55941 49618 Accumulated other comprehensive loss [1] (16153) (15083) (16373) Total shareholders' equity (8617) 339 1656 Noncontrolling interests 317 71 57 Total equity (8300) 410 1713 Total liabilities and equity $ 133,625.00 $ 117,359.00 $ 112,362.00 [1] Net of tax. Raytheon Company Consolidated Balance Sheets As of December 31, 2019, December 31, 2018, and December 31, 2017 $s in millions Dec. 31, 2019 Dec. 31, 2018 Dec. 31, 2017 Assets Cash and cash equivalents 7378 6152 $ 8,985 Accounts receivable (net of allowance for doubtful a 13524 14271 12,595 Contract with Customer, Asset, Net, Current 4184 3486 0 Inventory, net 10950 10083 9,881 Other assets, current 1461 1511 1,397 Total Current Assets 37497 35503 32,858 Customer financing assets 3477 3023 2,372 Future income tax benefits 1611 1646 1,723 Fixed assets, net 12755 12297 10,186 Operating Lease, Right-of-Use Asset 2599 0 0 Goodwill 48063 48112 27,910 Intangible assets, net 26046 26424 15,883 Other assets 7668 7206 5,988 Total Assets 139716 134211 96,920 Liabilities and Equity Short-term borrowings 2364 1469 392 Accounts payable 10809 11080 9,579 Accrued liabilities 11737 10223 12,316 Contract with Customer, Liability, Current 6180 5720 0 Long-term debt currently due 3496 2876 2,104 Total Current Liabilities 34586 31368 24,391 Long-term debt 37788 41192 24,989 Future pension and postretirement benefit obligatio 3502 4018 3,036 Operating Lease, Liability, Noncurrent 2144 0 0 Contract with Customer, Liability, Noncurrent 5732 5069 0 Other long-term liabilities 11638 11845 12,952 Total Liabilities 93492 65,368 Redeemable noncontrolling interest 109 131 Capital Stock: Preferred Stock, $1 par value; 250,000 shares autho 0 0 0 Common Stock, $1 par value; 4,000,000 shares auth 23019 22514 17,574 Treasury Stock-586,479 and 585,479 common sha 32626 32482 35,596 Retained earnings 61594 57823 55,242 Unearned ESOP shares 64 76 85 Total Accumulated other comprehensive loss -10149 -9333 (7,525) Total Shareowners' Equity 41774 38446 29,610 Noncontrolling interest 2457 2164 1,811 Total Equity 44231 40610 31,421 Total Liabilities and Equity 139716 134211 $ 96,920 Allowance for doubtful accounts 389 488 Preferred Stock, par value 1 Preferred Stock. shares authorized 250000 Common Stock, par value 1 Common Stock, shares authorized 4000000 Common Stock, Shares, Issued 1450845 1446961 Treasury Stock, shares 586479 585479 Boing Historical Ratios For the years ended December 31, 2017, 2018, 2019 Competitior Ratio Analysis Northrop Gruman Industry Ratio 2017 2018 2019 Raytheon 1.14128 1.07648 1.05053 0.31891 0.30963 0.26314 1.13260547 1.084167 1.049607802 0.7675649 0.66435 0.69522 0.72825 0.229599163 0.9223671 45.0773 240.678 -11.293 3.659145028 0.8279312 -28.075 -24.429 3.12881 -4.825757576 5.1166977 Liquidity Current Ratio Quick Ratio Leverage Ratios Debt to Total Asssets Ratio Debt to Equity Ratio Long-Term Debt to Equity Times Interested Earned Ratio Activity Ratios Inventory Turnover Fixed Assets Turnover Total Assets Turnover Accounts Recievable Turnover Average Collection Period Profitability Ratios Gross Profit Margin Operating Profit Margin Net Profit Margin Return on Assets (ROA) Return on Stockholders' Equity Earnings Per Share (EPS) Price Earnings Ratio Northrop Grumman Corporation Consolidated Balance Sheets As of December 31, 2019, December 31, 2018, and December 31, 2017 $s in millions Dec. 31, 2017 Dec. 31, 2019 Dec. 31, 2018 Assets 11225 1054 2245 1326 5334 783 997 1579 1448 5026 654 973 3465 398 445 9680 10685 6912 1511 18708 1040 508 1725 16587 4225 0 12455 6372 0 18672 1372 94 1463 37653 52 447 1362 35128 41089 1661 2182 1676 1917 Cash and cash equivalents Accounts receivable, net Unbilled receivables, net Inventoried costs, net Prepaid expenses and other current assets Total current assets Property, plant and equipment, net of accumulated depreciation of $5,85 Operating lease right-of-use assets Goodwill Intangible assets, net Deferred tax assets Other non-current assets Total assets Liabilities Trade accounts payable Accrued employee compensation Advance payments and billings in excess of costs incurred Other current liabilities Total current liabilities Long-term debt, net of current portion of $1,109 for 2019 and $517 for 20 Pension and other postretirement benefit plan liabilities Operating lease liabilities Deferred tax liabilities Other non-current liabilities Total liabilities Commitments and contingencies (Note 12) Shareholders' equity ' Preferred stock, $1 par value; 10,000,000 shares authorized; no shares is Common stock, $1 par value; 800,000,000 shares authorized; issued and Paid-in capital Retained earnings Accumulated other comprehensive loss Total shareholders' equity Total liabilities and shareholders' equity 2226 1865 2237 3106 9434 12770 6979 2499 8274 13883 5755 1382 1761 2288 7092 14399 5511 o 0 994 27996 1308 0 0 1779 0 108 1446 32270 29466 0 168 0 171 0 0 174 44 0 8068 -52 8748 -97 8819 41089 6913 1 7132 35128 8187 37653 F G 61388 B D Boeing Consolidated Balance Sheets As of December 31, 2019, December 31, 2018, and December 31, 2017 $s in millions Assets Dec. 31, 2019 Dec. 31, 2018 Dec. 31, 2017 Cash and cash equivalents $ 9,485.00 $ 7,637.00 $ 8,813.00 Short-term and other investments 545 927 1179 Accounts receivable, net 3266 3879 2894 Unbilled receivables, net 9043 10025 8194 Current portion of customer financing, net 162 460 309 Inventories 76622 62567 Other current assets 3106 2335 2417 Total current assets 102229 87830 85194 Customer financing, net 2136 2418 2756 Property, plant and equipment, net 12502 12645 12672 Goodwill 8060 7840 5559 Acquired intangible assets, net 3338 3429 2573 Deferred income taxes 683 284 321 Investments 1092 1087 1260 Other assets, net of accumulated amortization of $580 and $503 3585 1826 2027 Total assets $ 133,625.00 $ 117,359.00 $ 112,362.00 Liabilities and equity Accounts payable 15553 12916 12202 Accrued liabilities 22868 14808 13069 Advances and progress billings 51551 50676 48042 Short-term debt and current portion of long-term debt 7340 3190 1335 Total current liabilities 97312 81590 74648 Deferred income taxes 413 1736 2188 Accrued retiree health care 4540 4584 5545 Accrued pension plan liability, net 16276 15323 16471 Other long-term liabilities 3422 3059 2015 Long-term debt 19962 10657 9782 Shareholders' equity: Common stock, par value $5.00 - 1,200,000,000 shares authorized; 1,012,261,159 shares issued 5061 5061 5061 Additional paid-in capital 6745 6768 6804 Treasury stock, at cost (54914) (52348) (43454) Retained earnings 50644 55941 49618 Accumulated other comprehensive loss [1] (16153) (15083) (16373) Total shareholders' equity (8617) 339 1656 Noncontrolling interests 317 71 57 Total equity (8300) 410 1713 Total liabilities and equity $ 133,625.00 $ 117,359.00 $ 112,362.00 [1] Net of tax. Raytheon Company Consolidated Balance Sheets As of December 31, 2019, December 31, 2018, and December 31, 2017 $s in millions Dec. 31, 2019 Dec. 31, 2018 Dec. 31, 2017 Assets Cash and cash equivalents 7378 6152 $ 8,985 Accounts receivable (net of allowance for doubtful a 13524 14271 12,595 Contract with Customer, Asset, Net, Current 4184 3486 0 Inventory, net 10950 10083 9,881 Other assets, current 1461 1511 1,397 Total Current Assets 37497 35503 32,858 Customer financing assets 3477 3023 2,372 Future income tax benefits 1611 1646 1,723 Fixed assets, net 12755 12297 10,186 Operating Lease, Right-of-Use Asset 2599 0 0 Goodwill 48063 48112 27,910 Intangible assets, net 26046 26424 15,883 Other assets 7668 7206 5,988 Total Assets 139716 134211 96,920 Liabilities and Equity Short-term borrowings 2364 1469 392 Accounts payable 10809 11080 9,579 Accrued liabilities 11737 10223 12,316 Contract with Customer, Liability, Current 6180 5720 0 Long-term debt currently due 3496 2876 2,104 Total Current Liabilities 34586 31368 24,391 Long-term debt 37788 41192 24,989 Future pension and postretirement benefit obligatio 3502 4018 3,036 Operating Lease, Liability, Noncurrent 2144 0 0 Contract with Customer, Liability, Noncurrent 5732 5069 0 Other long-term liabilities 11638 11845 12,952 Total Liabilities 93492 65,368 Redeemable noncontrolling interest 109 131 Capital Stock: Preferred Stock, $1 par value; 250,000 shares autho 0 0 0 Common Stock, $1 par value; 4,000,000 shares auth 23019 22514 17,574 Treasury Stock-586,479 and 585,479 common sha 32626 32482 35,596 Retained earnings 61594 57823 55,242 Unearned ESOP shares 64 76 85 Total Accumulated other comprehensive loss -10149 -9333 (7,525) Total Shareowners' Equity 41774 38446 29,610 Noncontrolling interest 2457 2164 1,811 Total Equity 44231 40610 31,421 Total Liabilities and Equity 139716 134211 $ 96,920 Allowance for doubtful accounts 389 488 Preferred Stock, par value 1 Preferred Stock. shares authorized 250000 Common Stock, par value 1 Common Stock, shares authorized 4000000 Common Stock, Shares, Issued 1450845 1446961 Treasury Stock, shares 586479 585479
