Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Below, find 2018 financial data for several companies. Darden Kimberly Clark Lowe's Co Nielsen Royal Caribbean Sherwin Williams Revenues 8,510 18,486 71,309 6,515 9,494 17,534
Below, find 2018 financial data for several companies. | |||||||||
Darden | Kimberly Clark | Lowe's Co | Nielsen | Royal Caribbean | Sherwin Williams | ||||
Revenues | 8,510 | 18,486 | 71,309 | 6,515 | 9,494 | 17,534 | |||
Cost of Revenues | 6,661 | 12,889 | 48,401 | 2,805 | 1,058 | 10,116 | |||
EBIT | 833 | 2,229 | 4,018 | -475 | 1,895 | 1,741 | |||
Interest Expense | 54 | 263 | 652 | 394 | 334 | 367 | |||
Net Income | 713 | 1,410 | 2,314 | -712 | 1,811 | 1,109 | |||
Cash & Marketable Securities | 457 | 539 | 729 | 524 | 288 | 156 | |||
Accounts Receivable | 88 | 2,164 | - | 1,118 | 325 | 2,019 | |||
Inventories | 207 | 1,813 | 12,561 | - | 154 | 1,815 | |||
Accounts Payables | 333 | 3,190 | 8,279 | 288 | 488 | 1,799 | |||
Current Assets | 893 | 5,041 | 14,228 | 2,003 | 1,242 | 4,344 | |||
PP&E | 2,553 | 7,159 | 18,432 | 468 | 23,466 | 1,777 | |||
Intangible Assets | 2,209 | 1,474 | 303 | 12,011 | 1,378 | 12,158 | |||
Current Liabilities | 1,474 | 6,536 | 14,497 | 1,657 | 7,112 | 4,298 | |||
Debt | 1,103 | 7,455 | 16,223 | 8,387 | 10,778 | 9,344 | |||
Equity | 2,393 | 18 | 3,644 | 3,043 | 11,647 | 3,731 | |||
Dividends | 374 | 1,392 | 1,500 | 494 | 547 | 323 |
Use the data above to calculate the Balance Sheet ratios below. | |||||||||
Insert the correct formula for Company 1 (column E) and calculate the answer. | |||||||||
Correctly copy formulas from Company 1 (column E) to Company 2-6 (columns E-J) | |||||||||
Darden | Kimberly Clark | Lowe's Co | Nielsen | Royal Caribbean | Sherwin Williams | ||||
Days of Inventory (DIO) | |||||||||
Receivable Days (DSO) | |||||||||
Days Payables Outstanding (DPO) | |||||||||
Current Ratio | |||||||||
Cash to Current Liabilities | |||||||||
Acid Test Ratio | |||||||||
Interest Coverage | |||||||||
Debt / Equity |
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