Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting Volume 2

Authors: Thomas H. Beechy, Joan E. Conrod, Elizabeth Farrell, Ingrid McLeod-Dick, Kayla Tomulka, Romi-Lee Sevel

8th Edition

1260881245, 9781260881240

More Books

Students also viewed these Accounting questions

Question

Experimental mortality: Did participants drop out during the study?

Answered: 1 week ago

Question

Define job pricing. What is the purpose of job pricing?

Answered: 1 week ago

Question

What are some companywide pay plans? Briefly discuss each.

Answered: 1 week ago