50.1K

Verified Solution

Link Copied!

I need help calculating Gross profit margin and net profit margin for the two most recent rfrom the attached Excel sheet for 3M company. I need it put into a table.

---------- Noncontrolling interest Total equity 0.14% 1 27.31% Balance Sheet Exchange rate used is that of the Year End reported date 12/31/2020 12/31/2013 As Reported Annual Balance Sheet Report Date Currency Audit Status USD Not Qualified ---- USD Not Qualified Consolidated Scale Cash & cash equivalents Marketable securities - curren Accounts receivable, gross Less allowances ---- Accounts receivable.net Finished goods Work in process Raw materials & Supplies Total inventories RE Prepaids Derivative assets-current Held-to-maturity debt security held in trust Insurance related receivables, prepaid expenses & other) Other current assets Other current assets Tatal current assets Land Buildings & leasehold improvements Machinery & equipment -22 Construction in progress Capital leases Property, plant & equipment, gross Less: accumulated depreciation Property, plant & equipment, net Operating lease right of use assets Goodwill Intangible assets.net ---- Deferred income taxes Prepaid pension & post retirement Insurance related receivables & other assets & Cash surrender value of life insurance policies Equity method investments Cost method & other investments Other assets Other assets Total assets Yea Minions 9.79% 0.85% 10.43% 0.49% 9.94% 4.40% 2.59% 1.97% 8.95% 1.43% 0.079 NM 0.28% 0.35% 0.69% 31.64% 0.71% 16.94% 35.62% 3.01% NM 58.29% 36.39% Yes Tanfona 5.27% 0.22% 11.09% 0.36% 10.73% 4.49% 2.67% 2.10% 9.26% 1.58% 0.17% 1.0592 1.UDA 0.39% 0.39% 2.00% 29.04% 0.79% 17.64% 37.14% : 2.93% NM 58.50% 37.60% 20.90% 1.92% 30.10% 14.28% 1.17% 0.52% Current portion of long-term debt U.S. dollar commercial paper Japan subsidiary credit facility Germany subsidiary credit facility Other short-term borrowings Short-term borrowings & current portion of long-term debit Accounts payable Accrued payroll Accrued income taxes Operating lease liabilities.current Accrued rebates Deferred revenue Derivative liabilities Employee benefits & withholdings Contingent ability claims & other current abilities Property, sales-related & other taxes Pension & postretirement benefits Other current liabilities Other current liabilities Tatal current liabilities Eurobond Medium-term nate Registered note Senior secured notes Bond Debentures ---- Floating rainnote Other borrowings Total long-term debt Less: current portion of long-term debt Long-term debit Pension & postretirement benefits Operating lease liabilities Long term income taxes payable Employee benefits Contingent liability claims & other liabilities & Finance lease obligations Deferred income taxes Other liabilities Total other liabilities Total abilities Common stock Additional paid in capital Treasury stock at cost Cumulative translation adjustment Defined benefit persion & pastretirement plans adjustment Cash flow hedging instruments, unrealized gain (loss) Accumulated other comprehensive income (lass) Total 3M Company shareholders' equity 1.68% NM NM NM 0.03% 1.70% 5.41% 1.58% 0.63% 0.54% 1.35% 1.05% 0.17% 0.41% 1.17% 0.65% 0.15% 1.97% 6.92% 16.79% 1.57% 25.59% 10.42% NM 1.64% NM 0.31% 0.15% 39.67% 1.68% 38.00% 9.30% 1.29% 3.19% 0.87% 1.72% 0.20% 0.70% 0.63% 7.31% 72.69% 0.02% 13.02% 92.43% 62.11% 3.06% -12.75% -0.37% 16.18% 27.18% 4.12% 149 0.34% 1.42% 0.38% 0.01% 6.26% 4.99% 1.57% 0.43% 0.56% 1.33% 0.96% 0.04% 0.51% 1.27% 0.56% 0.15% 2.03% 6,84% 20.65% 1.52% 31.40% 7.15% 1.04% 1.23% 0.51% - 0.33% 0.17% 43.35% 4.12% 39 23% 8.76% 1.36% 3.37% 0.70% 1.76% 0.25% 19.90% 0.15% Retained earnings 1.82% 29.15% 12.32% 1.84% 1.33% 0.109 0.54% 0.28% 0.179 0.88% 5.15% 100.00% 0.87% 0.58% 7.33 77.33% 0.02% 13.23% 94.35% 66.84% -4.25% -13.90% -0.07% -18.22% 22.53% ------- 0.57% 0.16% 0.28% 0.91% % 3.75% 10000%

Answer & Explanation Solved by verified expert

See Answer