Can I pls have the table completed
SEALED AIR LTD SEALED AIR LTD Income Statement 2019 2018 2017 2016 12/31/2019 12/31/2018 12/31/2017 12/31/2016 Balance Sheet All numbers in thousands (GHS) Period Ending Current Assets Cash And Cash Equivalents Short Term Investments Net Receivables 271,700 594,000 333,700 351,700 Inventory 613,100 544,900 2,700 1,554,800 727,700 506,800 7,700 1,866,400 544,700 456,700 840,800 2,215,300 912,600 660,800 79,400 2,215,700 1,036,200 1,947,600 101,700 998,400 1,939,800 83,600 889,600 1,882,900 40,100 945,700 2,909,500 784,300 409,900 392,100 2,387,600 549,800 170,500 176,200 197,100 204,700 5,050,200 5,280,300 7,415,500 7,405,000 All numbers in thousands (GHS) 2019 2018 2017 2016 Revenue 12/31/2019 12/31/2018 12/31/2017 12/31/2016 Total Revenue 4,732,700 4,461,600 4,211,300 4,410,300 Cost of Revenue 3,230,600 3,049,500 2,810,300 2,955,100 Gross Profit 1,502,100 1,412, 100 1,401,000 1,455,200 Operating Expenses Research Development Selling General and 757,500 730,300 Administrative 756,700 778,000 Non Recurring Others Total Operating Expenses 4,003,800 3,792,900 3,582,000 3,744,200 Operating Income or Loss 728,900 668,700 629,300 666,100 Income from Continuing Operations Total Other -271,100 -275,400 -241,400 -374,700 Income/Expenses Net Earnings Before Interest and 728,900 668,700 629,300 666,100 Taxes Interest Expense -193,000 -201,800 - 199,400 -211,000 Income Before Tax 457,800 393,300 387,900 291,400 Income Tax Expense 307,500 330,500 95,600 132,600 Minority Interest Net Income From Continuing 150,300 62,800 292,300 158,800 Ops Non-recurring Events Discontinued Operations 42,800 194,100 176,600 Extraordinary Items Effect Of Accounting Changes Other Items Net Income 193,100 814,900 486,400 Net Income 335,400 Preferred Stock And Other Adjustments Net Income Applicable To 192,200 810,000 483,000 333,200 Common Shares Other Current Assets Total Current Assets Long Term Investments Property, plant and equipment Goodwill Intangible Assets Accumulated Amortization Other Assets Deferred Long Term Asset Charges Total Assets Current Liabilities Accounts Payable Short/Current Long Term Debt Other Current Liabilities Total Current Liabilities Long Term Debt Other Liabilities Deferred Long Term Liability Charges Minority Interest Negative Goodwill Total Liabilities Stockholders' Equity 765,000 4,900 57,000 1,488,600 3,206,200 673,700 723,800 2,200 64,900 1,378.200 3,230,500 519,300 539.200 297,000 776,400 2,119,000 3,762,600 924,200 669,000 46,600 103,300 1,807,100 4,266,800 804,000 752,100 5,398,800 5,128,000 6,805,800 6,877,900 Misc. Stocks Options Warrants Redeemable Preferred Stock Preferred Stock Common Stock Retained Earnings Treasury Stock Capital Surplus Other Stockholder Equity Total stockholders' equity Net Tangible Assets 23,200 1,835,500 -4,256,900 2,049,600 -920,400 -348,600 -2,397,900 23,000 22,800 1,735,200 1,040,000 -3,545,500 -2,427,200 1,939,600 1,974,100 -844,900 -949,100 152,300 609,700 -1,871,100 -1,313,300 22,600 675,200 -2,085,700 1,915,000 -820,000 527,100 -3,166,700 AMCOR CO. LTD. AMCOR CO. LTD. Income Statement 2019 6/30/2019 2018 6/30/2018 2017 6/30/2017 2016 6/30/2016 All numbers in thousands (GHS) Revenue 2019 2018 6/30/2019 6/30/2018 9,458,200 9,319,100 2017 2016 6/30/2017 6/30/2016 9,101,000 9,421,300 601,600 620,800 561,500 515,700 Total Revenue Balance Sheet All numbers in thousands (GHS) Period Ending Current Assets Cash And Cash Equivalents Short Term Investments Net Receivables Inventory Other Current Assets Total Current Assets Long Term Investments Property, plant and equipment 7,189,200 7,426,500 1,911,800 1,994,800 1,864,300 1,953,800 421,200 5,210,100 131,700 3,975,000 1,379,000 1,358,800 8,800 3,620,300 138,600 2.698.500 1,328,000 1,305,500 14,300 3,286,500 438,700 2,765,300 1,339,300 1,244,400 21,400 3,193,100 490,800 2,690,900 69,100 67,400 912,500 953,600 Goodwill 5,156,000 2,056,600 1.790,300 2,033,300 362,200 -44,800 -77,000 2,306,800 324.800 292.100 8,370,500 8,126.000 975,000 1,050,800 385,400 218,700 197,300 224,900 190,900 70,700 66,700 47,500 -245,100 -641,900 17,165,000 9,057,500 9,083,300 8,682,100 Cost of Revenue 7,659,100 7,462,300 Gross Profit 1.799, 100 1,856,800 Operating Expenses Research Development 64,000 72,700 Selling General and 815,200 Administrative 784,200 Non Recurring Others -18,400 -43,000 Total Operating Expenses 8,519,900 8,276,200 Operating Income or Loss 938,300 1,042,900 Income from Continuing Operations Total Other Income/Expenses -330,100 -337.500 Net Earnings Before Interest and 938,300 1,042,900 Taxes Interest Expense -207,900 -210,000 Income Before Tax 608,200 705,400 Income Tax Expense 171,500 118,800 Minority Interest 65,700 68,800 Net Income From Continuing 436,700 586,600 Ops Non-recurring Events Discontinued Operations 700 700 Extraordinary Items Effect Of Accounting Changes Other Items Net Income Net Income 430,200 575,200 Preferred Stock And Other Adjustments Net Income Applicable To 429,400 573,900 Common Shares Intangible Assets Accumulated Amortization Other Assets Deferred Long Term Asset Charges Total Assets Current Liabilities Accounts Payable Short/Current Long Term Debt Other Current Liabilities Total Current Liabilities Long Term Debt 975,000 -190,900 729.900 148,900 69,600 1,050.800 -192,200 408,900 135,300 61,600 2,303,400 5,400 1,058,400 4,541,800 5,309,000 1,861,000 984,100 760,200 5,055,200 2,691,700 2,607,900 341,600 301,700 4,034,200 3,480,100 693,000 2,418,400 323,100 310,100 3,645,200 3,418,500 581,000 273,600 1,639,500 615,200 763,000 19,700 13,800 700 700 65,700 68,800 69,600 61,600 11,490,300 8,362,100 8,213,600 7,836,600 564,000 244,100 Other Liabilities Deferred Long Term Liability Charges Minority Interest Negative Goodwill Total Liabilities Stockholders' Equity Misc. Stocks Options Warrants Redeemable Preferred Stock Preferred Stock Common Stock Retained Earnings Treasury Stock Capital Surplus Other Stockholder Equity Total stockholders' equity Net Tangible Assets 562,300 244,100 1,425.000 264,900 -889,800 1,466,600 139,000 -821,700 16,300 323,700 -738,500 6,007,500 -722.400 5,609,000 -1,853,800 561,400 -719,200 784,400 -708,500 626,600 -1,754,800 -881,700 800,100 -1,595,400 -800,200 783,900 -1,298,500 Complete the table below for the two companies for the year 2019 LIQUIDITY RATIO Armcor PLC Sealed Air PLC Cash Ratio Current Ratio Acid Test Ratio LEVERAGE RATIO Total Debt ratio Debt/Equity Ratio Debt/Equity Ratio (approximated) PROFITABILITY Gross profit margin Net Profit Margin Operating Income margin EFFICIENCY RATIO Inventory turnover Period Trade Receivable period Trade Payable Period MARKET/INVESTMENT RATIO Earnings per share (EPS) P/E ratio Interest cover ratio Dividend Cover ratio 1. Amcor plc (AMCR) NYSE - NYSE Delayed Price. Currency in USD 10.31+0.03 (+0.29%) At close: June 19 4:00PM EDT 2. Sealed Air Stock Price, Forecast & News $31.65 +0.23 (+0.73 %) (As of 06/19/2020 04:00 PM ET) SEALED AIR LTD SEALED AIR LTD Income Statement 2019 2018 2017 2016 12/31/2019 12/31/2018 12/31/2017 12/31/2016 Balance Sheet All numbers in thousands (GHS) Period Ending Current Assets Cash And Cash Equivalents Short Term Investments Net Receivables 271,700 594,000 333,700 351,700 Inventory 613,100 544,900 2,700 1,554,800 727,700 506,800 7,700 1,866,400 544,700 456,700 840,800 2,215,300 912,600 660,800 79,400 2,215,700 1,036,200 1,947,600 101,700 998,400 1,939,800 83,600 889,600 1,882,900 40,100 945,700 2,909,500 784,300 409,900 392,100 2,387,600 549,800 170,500 176,200 197,100 204,700 5,050,200 5,280,300 7,415,500 7,405,000 All numbers in thousands (GHS) 2019 2018 2017 2016 Revenue 12/31/2019 12/31/2018 12/31/2017 12/31/2016 Total Revenue 4,732,700 4,461,600 4,211,300 4,410,300 Cost of Revenue 3,230,600 3,049,500 2,810,300 2,955,100 Gross Profit 1,502,100 1,412, 100 1,401,000 1,455,200 Operating Expenses Research Development Selling General and 757,500 730,300 Administrative 756,700 778,000 Non Recurring Others Total Operating Expenses 4,003,800 3,792,900 3,582,000 3,744,200 Operating Income or Loss 728,900 668,700 629,300 666,100 Income from Continuing Operations Total Other -271,100 -275,400 -241,400 -374,700 Income/Expenses Net Earnings Before Interest and 728,900 668,700 629,300 666,100 Taxes Interest Expense -193,000 -201,800 - 199,400 -211,000 Income Before Tax 457,800 393,300 387,900 291,400 Income Tax Expense 307,500 330,500 95,600 132,600 Minority Interest Net Income From Continuing 150,300 62,800 292,300 158,800 Ops Non-recurring Events Discontinued Operations 42,800 194,100 176,600 Extraordinary Items Effect Of Accounting Changes Other Items Net Income 193,100 814,900 486,400 Net Income 335,400 Preferred Stock And Other Adjustments Net Income Applicable To 192,200 810,000 483,000 333,200 Common Shares Other Current Assets Total Current Assets Long Term Investments Property, plant and equipment Goodwill Intangible Assets Accumulated Amortization Other Assets Deferred Long Term Asset Charges Total Assets Current Liabilities Accounts Payable Short/Current Long Term Debt Other Current Liabilities Total Current Liabilities Long Term Debt Other Liabilities Deferred Long Term Liability Charges Minority Interest Negative Goodwill Total Liabilities Stockholders' Equity 765,000 4,900 57,000 1,488,600 3,206,200 673,700 723,800 2,200 64,900 1,378.200 3,230,500 519,300 539.200 297,000 776,400 2,119,000 3,762,600 924,200 669,000 46,600 103,300 1,807,100 4,266,800 804,000 752,100 5,398,800 5,128,000 6,805,800 6,877,900 Misc. Stocks Options Warrants Redeemable Preferred Stock Preferred Stock Common Stock Retained Earnings Treasury Stock Capital Surplus Other Stockholder Equity Total stockholders' equity Net Tangible Assets 23,200 1,835,500 -4,256,900 2,049,600 -920,400 -348,600 -2,397,900 23,000 22,800 1,735,200 1,040,000 -3,545,500 -2,427,200 1,939,600 1,974,100 -844,900 -949,100 152,300 609,700 -1,871,100 -1,313,300 22,600 675,200 -2,085,700 1,915,000 -820,000 527,100 -3,166,700 AMCOR CO. LTD. AMCOR CO. LTD. Income Statement 2019 6/30/2019 2018 6/30/2018 2017 6/30/2017 2016 6/30/2016 All numbers in thousands (GHS) Revenue 2019 2018 6/30/2019 6/30/2018 9,458,200 9,319,100 2017 2016 6/30/2017 6/30/2016 9,101,000 9,421,300 601,600 620,800 561,500 515,700 Total Revenue Balance Sheet All numbers in thousands (GHS) Period Ending Current Assets Cash And Cash Equivalents Short Term Investments Net Receivables Inventory Other Current Assets Total Current Assets Long Term Investments Property, plant and equipment 7,189,200 7,426,500 1,911,800 1,994,800 1,864,300 1,953,800 421,200 5,210,100 131,700 3,975,000 1,379,000 1,358,800 8,800 3,620,300 138,600 2.698.500 1,328,000 1,305,500 14,300 3,286,500 438,700 2,765,300 1,339,300 1,244,400 21,400 3,193,100 490,800 2,690,900 69,100 67,400 912,500 953,600 Goodwill 5,156,000 2,056,600 1.790,300 2,033,300 362,200 -44,800 -77,000 2,306,800 324.800 292.100 8,370,500 8,126.000 975,000 1,050,800 385,400 218,700 197,300 224,900 190,900 70,700 66,700 47,500 -245,100 -641,900 17,165,000 9,057,500 9,083,300 8,682,100 Cost of Revenue 7,659,100 7,462,300 Gross Profit 1.799, 100 1,856,800 Operating Expenses Research Development 64,000 72,700 Selling General and 815,200 Administrative 784,200 Non Recurring Others -18,400 -43,000 Total Operating Expenses 8,519,900 8,276,200 Operating Income or Loss 938,300 1,042,900 Income from Continuing Operations Total Other Income/Expenses -330,100 -337.500 Net Earnings Before Interest and 938,300 1,042,900 Taxes Interest Expense -207,900 -210,000 Income Before Tax 608,200 705,400 Income Tax Expense 171,500 118,800 Minority Interest 65,700 68,800 Net Income From Continuing 436,700 586,600 Ops Non-recurring Events Discontinued Operations 700 700 Extraordinary Items Effect Of Accounting Changes Other Items Net Income Net Income 430,200 575,200 Preferred Stock And Other Adjustments Net Income Applicable To 429,400 573,900 Common Shares Intangible Assets Accumulated Amortization Other Assets Deferred Long Term Asset Charges Total Assets Current Liabilities Accounts Payable Short/Current Long Term Debt Other Current Liabilities Total Current Liabilities Long Term Debt 975,000 -190,900 729.900 148,900 69,600 1,050.800 -192,200 408,900 135,300 61,600 2,303,400 5,400 1,058,400 4,541,800 5,309,000 1,861,000 984,100 760,200 5,055,200 2,691,700 2,607,900 341,600 301,700 4,034,200 3,480,100 693,000 2,418,400 323,100 310,100 3,645,200 3,418,500 581,000 273,600 1,639,500 615,200 763,000 19,700 13,800 700 700 65,700 68,800 69,600 61,600 11,490,300 8,362,100 8,213,600 7,836,600 564,000 244,100 Other Liabilities Deferred Long Term Liability Charges Minority Interest Negative Goodwill Total Liabilities Stockholders' Equity Misc. Stocks Options Warrants Redeemable Preferred Stock Preferred Stock Common Stock Retained Earnings Treasury Stock Capital Surplus Other Stockholder Equity Total stockholders' equity Net Tangible Assets 562,300 244,100 1,425.000 264,900 -889,800 1,466,600 139,000 -821,700 16,300 323,700 -738,500 6,007,500 -722.400 5,609,000 -1,853,800 561,400 -719,200 784,400 -708,500 626,600 -1,754,800 -881,700 800,100 -1,595,400 -800,200 783,900 -1,298,500 Complete the table below for the two companies for the year 2019 LIQUIDITY RATIO Armcor PLC Sealed Air PLC Cash Ratio Current Ratio Acid Test Ratio LEVERAGE RATIO Total Debt ratio Debt/Equity Ratio Debt/Equity Ratio (approximated) PROFITABILITY Gross profit margin Net Profit Margin Operating Income margin EFFICIENCY RATIO Inventory turnover Period Trade Receivable period Trade Payable Period MARKET/INVESTMENT RATIO Earnings per share (EPS) P/E ratio Interest cover ratio Dividend Cover ratio 1. Amcor plc (AMCR) NYSE - NYSE Delayed Price. Currency in USD 10.31+0.03 (+0.29%) At close: June 19 4:00PM EDT 2. Sealed Air Stock Price, Forecast & News $31.65 +0.23 (+0.73 %) (As of 06/19/2020 04:00 PM ET)
