80.2K

Verified Solution

Link Copied!

Can you help get the asset turnover ratio from December 2017 and the profit margin?

Fiscal Year ends in Dec - USD in Millions except per share data total revenue Operating Revenue excise taxes Cost of Revenue gross profit operating expense Expand/Collpaseselling general and administration general and administrative expense salaries and wages rent and landing fees insurance and claims other gand a selling and marketing expense research and development Expand/Collpasedepreciation and amortization depreciation amortization amortization of intangibles depletion provision for doubtful accounts other taxes other operating expenses Operating Income net non operating interest income expense interest income non operating interest expense non operating Dec 21 1161.82 1161.82 725.99 435.83 299.81 299.81 136.02 -0.89 0.89 Dec 20 1041.21 1041.21 692.04 349.17 272.91 275.41 -2.50 76.27 -1.88 1.88 Dec 19 996.50 996.50 684.47 312.02 297.19 297.19 14.83 -3.05 3.05 I Dec 18 987.58 987.58 686.73 300.85 302.08 302.08 -1.23 -3.37 3.37 Dec 17 1009.64 1009.64 686.30 323.33 306.99 306.99 16.34 -1.64 1.64 total other finance cost other income expense gain on sale of security earnings from equity interest securities amortization special income charges other non operating income expenses pretax income tax provision earnings from equity interest net of tax net income common stockholders Net Income preferred stock dividends diluted nia com stockholders basic eps basic continuous operations basic discontinuous operations basic extraordinary basic accounting change tax loss carryforward basic eps basic epso gains losses diluted eps diluted continuous operations diluted discontinuous operations diluted extraordinary diluted accounting change tax loss carryforward diluted eps 135.12 32.74 102.39 102.39 4.73 4.73 4.55 4.55 74.39 18.45 || 55.94 55.94 2.63 2.63 2.58 2.58 11.78 3.34 8.45 8.45 - 0.40 0.40 0.40 0.40 - -4.60 -1.07 -3.53 -3.53 -0.17 -0.17 - -0.17 -0.17 14.70 13.59 1.10 1.10 - - 0.05 0.05 0.05 0.05 Fiscal Year ends in Dec - USD in Millions except per share data Total Assets Expand/Collpasecurrent assets cash cash equivalents and short term investments cash and cash equivalents Cash cash equivalents Expand/Collpaseshort term investments Receivables accounts receivable gross accounts receivable allowance for doubtful accounts receivable loans receivable notes receivable accrued interest receivable Expand/Collpasetaxes receivable duefrom related parties current Other Receivables receivables adjustments allowances inventory raw materials work in process finished goods other inventories inventories adjustments allowances prepaid assets restricted cash Dec 21 753.95 407.35 97.42 97.42 13.65 13.65 279.98 279.98 16.29 Dec 20 699.99 347.40 64.65 64.65 - 19.88 19.88 251.18 251.18 11.68 I Dec 19 688.80 340.86 8.22 8.22 8.22 - 13.65 13.65 309.32 309.32 9.68 T Dec 18 419.56 325.07 6.77 6.77 6.77 - 14.18 14.18 294.90 294.90 9.22 Dec 17 445.06 350.89 7.17 7.17 7.17 10.89 10.89 313.91 313.91 18.93 I current deferred assets current deferred taxes assets assets held for sale current hedging assets current Other Current Assets Expand/Collpasetotal non current assets net ppe gross ppe properties land and improvements buildings and improvements machinery furniture equipment other properties construction in progress leases Accumulated Depreciation goodwill and other intangible assets goodwill other intangible assets investment properties investments and advances long term equity investment investmentsin subsidiariesat cost investmentsin associatesat cost investments in other ventures under equity method investmentsin joint venturesat cost investmentin financial assets |||| 346.61 352.60 347.94 94.49 330.51 335.85 331 76.49 632.36 626.49 610.80 345.03 - 2.75 2.75 2.75 2.75 1.78 1.78 1.78 1.78 179.83 171.77 174.57 173.69 270.11 278.61 262.59 - 1.84 0.89 1.15 0.84 176.07 170.70 167.97 165.98 -301.85 -290.64 -279.80 -268.54 94.17 77.27 333.27 171.07 1.25 160.95 -256.01 trading securities financial assets designatedas fair value through profitor loss total available for sale securities held to maturity securities other investments financial assets non current accounts receivable non current note receivables duefrom related parties non current non current deferred assets non current deferred taxes assets non current prepaid assets defined pension benefit other non current assets Total Liabilities Net Minority Interest Expand/Collpasecurrent liabilities payables and accrued expenses payables Accounts Payable total tax payable income tax payable dividends payable dueto related parties current other payable current accrued expenses interest payable current provisions 12.10 12.10 - - 4 486.64 269.80 189.40 116.47 104.36 12.11 72.93 13.83 13.83 - 2.91 467.36 239.59 163.76 92.49 80.88 11.61 71.27 13.62 13.62 3.32 508.43 222.81 148.59 93.26 83.66 9.61 55.33 14.54 14.54 - 3.46 244.70 150.59 148.27 90.81 80.61 10.20 57.46 14.17 14.17 - - 2.73 257.99 183.72 181.97 123.41 113.74 9.67 58.55 pensionand other post retirement benefit plans current current debt and capital lease obligation current debt current notes payable commercial paper line of credit other current borrowings current capital lease obligation current deferred liabilities current deferred taxes liabilities current deferred revenue Other Current Liabilities Expand/Collpasetotal non current liabilities long term provisions long term debt and capital lease obligation Long Term Debt long term capital lease obligation non current deferred liabilities non current deferred taxes liabilities non current deferred revenue tradeand other payables non current dueto related parties non current non current accrued expenses employee benefits non current pension and other postretirement benefit plans derivative product liabilities preferred securities outside stock equity 80.40 80.40 - 216.84 210.59 210.59 75.83 75.83 227.77 220.29 220.29 74.22 I 74.22 285.62 278.15 66.56 211.59 I 2.32 || - 2.32 94.11 69.82 65 4.82 14.62 - - I 1.75 1.75 74.27 47.80 45 2.80 15.95 restricted common stock liabilities heldfor sale non current other non current liabilities total equity gross minority interest Expand/Collpasestockholders equity capital stock preferred stock common stock other capital stock additional paid in capital retained earnings treasury stock gains losses not affecting retained earnings unrealized gain loss minimum pension liabilities foreign currency translation adjustments fixed assets revaluation reserve other equity adjustments other equity interest Minority Interest total capitalization preferred stock equity common stock equity Capital Lease Obligations net tangible assets working capital invested capital 6.25 267.31 267.31 0.26 0.26 124.91 192.26 -50.12 267.31 267.31 290.99 137.55 7.48 232.64 232.64 0.26 Z 0.26 121.84 153.07 -42.53 232.64 232.64 296.12 107.81 7.47 180.37 180.37 0.25 + 0.25 120.05 102.59 -42.53 246.93 180.37 285.81 118.05 - 9.67 174.86 174.86 0.25 Z 0.25 118.35 98.79 -42.53 - - 239.86 174.86 7.15 174.48 10.52 187.07 187.07 0.25 - 0.25 - 116.50 112.42 -42.10 232.07 187.07 4.55 167.17 Capital Lease Obligations net tangible assets working capital invested capital tangible book value total debt net debt share issued ordinary shares number preferred shares number treasury shares number 290.99 137.55 296.12 107.81 ||| I 285.81 7.15 4.55 118.05 174.48 167.17 I I I I I || tax loss carryforward diluted eps diluted epso gains losses basic average shares diluted average shares dividend per share total operating income as reported reported normalized basic eps reported normalized diluted eps rent expense supplemental total expenses net income from continuing and discontinued operation Normalized Income Interest Expense ebit ebitda reconciled cost of revenue reconciled depreciation net income from continuing operation net minority interest total unusual items excluding goodwill total unusual items normalized basic eps normalized diluted eps normalized ebitda tax rate for calcs tax effect of unusual items 21.67 22.51 0.83 136.02 1025.80 102.39 102.39 0.89 136.02 154.29 I 21.26 21.66 0.25 76.27 964.95 55.94 55.94 1.88 76.27 95.08 |||||| 21.10 21.15 0.20 14.83 I I 981.67 8.45 8.45 3.05 14.83 34.64 I || 20.98 20.98 0.50 -1.23 988.81 -3.53 -3.53 3.37 -1.23 18.31 I I 21.44 21.59 0.60 16.34 993.29 1.10 1.10 1.64 16.34 35.56 Fiscal Year ends in Dec - USD in Millions except per share data operating cash flow Expand/Collpasecash flow from continuing operating activities Net Income from Continuing Operations operating gains losses gain loss on sale of business gain loss on sale of ppe Expand/Collpasenet foreign currency exchange gain loss gain loss on investment securities earnings losses from equity investments pension and employee benefit expense depreciation amortization depletion depreciation and amortization depreciation amortization Expand/Collpaseamortization of intangibles depletion deferred tax Deferred Income Tax amortization of securities asset impairment charge provisionand write offof assets unrealized gain loss on investment securities stock based compensation excess tax benefit from stock based compensation other non cash items Dec 21 115.53 115.53 102.39 - 18.28 18.28 17.70 0.58 0.58 1.73 1.73 1.96 66.09 Dec 20 148.74 148.74 55.94 18.81 18.81 18.45 0.36 0.36 - -0.21 -0.21 - 1.71 I 62.33 Dec 19 14.28 14.28 8.45 -0.11 -0.11 19.81 19.81 19.54 0.27 0.27 1.05 1.05 0.52 1.93 61.67 Dec 18 24.52 24.52 -3.53 19.54 19.54 -0.58 -0.58 0.85 2.19 0.20 Dec 17 -4.38 -4.38 1.10 19.22 19.22 |||||| 9.53 9.53 5.04 2.30 0.15 change in receivables changes in account receivables change in inventory change in prepaid assets change in payables and accrued expense Expand/Collpasechange in payable change in tax payable change in income tax payable change in account payable change in dividend payable change in accrued expense change in interest payable change in other current assets change in other current liabilities change in other working capital dividend paid cfo dividend received cfo interest paid cfo interest received cfo taxes refund paid cash from discontinued operating activities investing cash flow Expand/Collpasecash flow from continuing investing activities capital expenditure reported net ppep and sale purchase of ppe 5.90 5.90 -28.80 -5.52 21.54 23.34 23.34 -1.81 -68.03 - -10.62 -10.62 -10.86 -10.86 -6.19 -6.19 58.14 -1.86 27.28 9.24 9.24 18.03 -67.20 -5.36 -5.36 -7.35 -7.35 1.33 1.33 -15.20 -0.83 -1.36 1.05 1.05 -2.41 -62.97 -9.20 -9.20 -9.36 -9.36 2.54 2.54 18.53 4.51 -19.71 -16.93 || - -16.93 -2.78 ||| -15.46 -15.46 -15.46 -15.46 1.31 1.31 -19.59 -8.96 -14.50 -3.90 || - -3.90 -10.60 -16.46 -16.46 -16.46 -16.46 sale of ppe net intangibles purchase and sale purchase of intangibles sale of intangibles net business purchase and sale purchase of business sale of business net investment properties purchase and sale purchase of investment properties sale of investment properties net investment purchase and sale purchase of investment sale of investment dividends received cfi interest received cfi net other investing changes Expand/Collpasecash from discontinued investing activities financing cash flow Expand/Collpasecash flow from continuing financing activities net issuance payments of debt net long term debt issuance long term debt issuance long term debt payments net short term debt issuance short term debt issuance short term debt payments net common stock issuance 0.25 -72.15 -72.15 -2.89 -2.89 -2.89 - -7.59 I 1.99 -86.95 -86.95 -69.42 -2.86 137.30 -2.86 -66.56 137.30 -203.86 I Cell Styles 0.17 -3.63 -9.46 -3.63 -9.46 0.99 1.96 -0.99 17.97 205.09 211.43 -206.08 -193.47 1.98 -16.01 -0.43 |||||||||||| 20.12 20.12 41.68 33.32 252.46 -219.14 8.37 -7.73 common stock issuance common stock payments net preferred stock issuance preferred stock issuance preferred stock payments Cash Dividends paid common stock dividend paid preferred stock dividend paid proceeds from stock option exercised interest paid cff net other financing charges cash from discontinued financing activities cash flow from discontinued operation Expand/Collpaseother cash adjustment inside change in cash end cash position changes in cash Effect of Exchange Rate Changes beginning cash position other cash adjustment outside change in cash income tax paid supplemental data interest paid supplemental data capital expenditure Issuance of Capital Stock Issuance of Debt Repayment of Debt Repurchase of Capital Stock free cash flow 1 -7.59 -61.79 2.17 -2.04 97.42 32.77 64.65 36.39 0.62 -10.86 -2.89 -7.59 104.66 -5.47 -5.47 0.17 -12.23 64.65 56.43 8.22 19.63 1.86 -7.35 137.30 -206.71 141.40 -4.40 -4.40 -0.22 I 8.22 1.46 6.77 2.32 2.91 -9.36 205.09 -206.08 4.92 -0.43 II -10.66 -10.66 - 0.03 -0.37 6.77 -0.41 7.17 0.02 3.16 -15.46 211.43 -193.47 -0.43 9.06 -7.73 -12.99 -12.99 0.07 -0.92 - 7.17 -0.73 7.90 14.29 1.19 -16.46 252.46 -219.14 -7.73 -20.85 beginning cash position other cash adjustment outside change in cash income tax paid supplemental data interest paid supplemental data capital expenditure Issuance of Capital Stock Issuance of Debt Repayment of Debt Repurchase of Capital Stock free cash flow adjusted geography segment data domestic sales foreign sales 64.65 36.39 0.62 -10.86 - -2.89 -7.59 104.66 I 6.77 7.17 2.32 0.02 2.91 3.16 -9.36 -15.46 205.09 211.43 -206.08 -193.47 -0.43 9.06 8.22 19.63 1.86 -7.35 137.30 -206.71 141.40 4.92 7.90 14.29 1.19 -16.46 252.46 -219.14 -7.73 -20.85

Answer & Explanation Solved by verified expert

See Answer