Question
can you work out the following? Rate of return Return on Investment DuPont model Return on Investment Return on Equity Balance sheet ratios Working Capital
can you work out the following?
Rate of return Return on Investment DuPont model Return on Investment Return on Equity Balance sheet ratios Working Capital Current Ratio Acid Test Ratio Trend analysis Liquidity ratios Inventory turnover Receivables turnover PP&E turnover Liquidity ratios (contd.) Days Sales Outstanding (DSO) Days Sales in Inventory Days Payable Outstanding (DPO) Profitability Ratios Earnings per share (EPS) Dividend Yield Preferred Dividend Coverage Debt Ratio Financial Leverage Debt to Equity Ratio Times Interest Earned Book Value per Share
Fiscal year is January-December. All values USD Millions. | 2021 | 2020 | 2019 | 2018 | 2017 | |
---|---|---|---|---|---|---|
Cash & Short Term Investments | 736 | 988 | 743 | 443 | 1,723 | |
Cash Only | 736 | 988 | 743 | 443 | 1,723 | |
Cash & Short Term Investments Growth | -25.51% | 32.97% | 67.72% | -74.29% | - | |
Cash & ST Investments / Total Assets | 12.34% | 16.88% | 14.20% | 10.73% | 32.44% | |
Total Accounts Receivable | 646 | 569 | 623 | 597 | 575 | |
Accounts Receivables, Net | 596 | 534 | 584 | 561 | 400 | |
Accounts Receivables, Gross | 632 | 579 | 656 | 592 | 419 | |
Bad Debt/Doubtful Accounts | (36) | (45) | (72) | (31) | (19) | |
Other Receivables | - | 35 | 39 | 36 | 175 | |
Accounts Receivable Growth | 13.53% | -8.67% | 4.36% | 3.83% | - | |
Accounts Receivable Turnover | 10.19 | 9.93 | 8.98 | 9.53 | 10.22 | |
Inventories | - | - | - | - | 13 | |
Progress Payments & Other | - | - | - | - | 13 | |
Other Current Assets | 150 | 132 | 161 | 167 | 196 | |
Miscellaneous Current Assets | 150 | 132 | 161 | 167 | 196 | |
Total Current Assets | 1,532 | 1,689 | 1,527 | 1,207 | 2,507 | |
Net Property, Plant & Equipment | 2,016 | 2,086 | 1,812 | 1,237 | 1,697 | |
Property, Plant & Equipment - Gross | 3,286 | 3,316 | 2,948 | 2,353 | 3,177 | |
Buildings | 1,403 | 1,423 | 1,325 | 1,349 | 1,661 | |
Land & Improvements | 412 | 428 | 408 | 422 | 452 | |
Machinery & Equipment | 595 | 543 | 505 | 523 | 941 | |
Leases | 67 | 71 | 68 | 59 | 123 | |
Accumulated Depreciation | 1,270 | 1,230 | 1,136 | 1,116 | 1,480 | |
Total Investments and Advances | 277 | 75 | 137 | 214 | - | |
LT Investment - Affiliate Companies | 118 | - | 137 | 214 | - | |
Other Long-Term Investments | 159 | 75 | - | - | - | |
Long-Term Note Receivable | - | - | - | - | 38 | |
Intangible Assets | 1,016 | 940 | 774 | 767 | 622 | |
Net Goodwill | 657 | 597 | 530 | 525 | 512 | |
Net Other Intangibles | - | 343 | 244 | 242 | 110 | |
Other Assets | 401 | 509 | 534 | 510 | 308 | |
Tangible Other Assets | 401 | 509 | 534 | 510 | 308 | |
Total Assets | 5,966 | 5,852 | 5,231 | 4,130 | 5,311 | |
Assets - Total - Growth | 1.95% | 11.87% | 26.66% | -22.24% | - | |
Asset Turnover | 1.11 | - | - | - | - | |
Return On Average Assets | 26.65% | - | - | - | - |
Liabilities & Shareholders' Equity
All values USD Millions. | 2021 | 2020 | 2019 | 2018 | 2017 | |
---|---|---|---|---|---|---|
ST Debt & Current Portion LT Debt | 156 | 550 | 498 | 321 | 375 | |
Short Term Debt | - | 97 | 71 | 321 | 375 | |
Current Portion of Long Term Debt | 68 | 453 | 427 | - | - | |
Accounts Payable | 227 | 215 | 173 | 202 | 119 | |
Accounts Payable Growth | 5.58% | 24.28% | -14.36% | 69.75% | - | |
Income Tax Payable | 13 | 33 | 150 | 69 | 123 | |
Other Current Liabilities | 1,019 | 877 | 720 | 709 | 895 | |
Accrued Payroll | 292 | 225 | 223 | 206 | 252 | |
Miscellaneous Current Liabilities | 727 | 652 | 497 | 503 | 643 | |
Total Current Liabilities | 1,415 | 1,675 | 1,541 | 1,301 | 1,512 | |
Current Ratio | 1.08 | 1.01 | 0.99 | 0.93 | 1.66 | |
Quick Ratio | 1.08 | 1.01 | 0.99 | 0.93 | 1.65 | |
Cash Ratio | 0.52 | 0.59 | 0.48 | 0.34 | 1.14 | |
Long-Term Debt | 11,971 | 11,095 | 10,771 | 9,751 | 9,429 | |
Long-Term Debt excl. Capitalized Leases | 11,121 | 10,207 | 10,061 | 9,751 | 9,429 | |
Non-Convertible Debt | 11,121 | 10,207 | 10,061 | 9,751 | 9,429 | |
Capitalized Lease Obligations | 57 | 65 | 70 | - | - | |
Deferred Taxes | (724) | (553) | (447) | (195) | (133) | |
Deferred Taxes - Credit | - | - | - | - | 6 | |
Deferred Taxes - Debit | 724 | 553 | 447 | 195 | 139 | |
Other Liabilities | 953 | 973 | 935 | 1,004 | 698 | |
Other Liabilities (excl. Deferred Income) | 953 | 973 | 935 | 1,004 | 698 | |
Total Liabilities | 14,339 | 13,743 | 13,247 | 12,056 | 11,645 | |
Total Liabilities / Total Assets | 240.35% | 234.84% | 253.24% | 291.91% | 219.26% | |
Common Equity (Total) | (8,373) | (7,891) | (8,016) | (7,926) | (6,334) | |
Retained Earnings | (8,048) | (7,480) | (7,628) | (7,592) | (6,063) | |
Cumulative Translation Adjustment/Unrealized For. Exch. Gain | (206) | (182) | (221) | (245) | (174) | |
Other Appropriated Reserves | (119) | (229) | (167) | (89) | (97) | |
Common Equity / Total Assets | -140.35% | -134.84% | -153.24% | -191.91% | -119.26% | |
Total Shareholders' Equity | (8,373) | (7,891) | (8,016) | (7,926) | (6,334) | |
Total Shareholders' Equity / Total Assets | -140.35% | -134.84% | -153.24% | -191.91% | -119.26% | |
Total Equity | (8,373) | (7,891) | (8,016) | (7,926) | (6,334) | |
Liabilities & Shareholders' Equity | 5,966 | 5,852 | 5,231 | 4,130 | 5,311 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started