Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions

Question

Define observational learning.

Answered: 1 week ago