Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What are the answers to questions 5, 6, 7, and 8 and how do I do them? Below is are balance and income numbers for

What are the answers to questions 5, 6, 7, and 8 and how do I do them?

Below is are balance and income numbers for three companies. Answer the questions below.

1

2

3

Year 1

Year 2

Year 1

Year 2

Year 1

Year 2

Revenue

5674

5054

176896

124959

179083

186506

COGS

3442

3066

144924

102374

144249

150228

Gross Profit

2232

1988

31972

22585

34834

36277

EBITDA

1470

658

7962

2712

15990

20527

Taxes

510

218

6522

325

4309

11615

Net Income

960

440

1440

2387

11681

8912

Total Assets

5255

4681

275936

194921

244587

254725

Equity

3084

3235

13442

40922

89999

134333

Current Assets

3145

1550

62923

23413

91387

144135

Current Liabilities

873

289

53604

6438

85373

48307

Inventory

221

513

10271

2812

13799

81558

Long-Term Debt

1298

1156

208890

147560

69215

72084

  • The balance sheet items may not balance perfectly (they may be out ~$1) due to rounding error.

  • USE EXCEL to calculate the solutions and do the math calculators may throw off your rounding

  • Submit percentages as the percentage followed by two decimals. A number that appears as .04567 in excel should be

    submitted as 4.57%.

  • Responses will be marked correct if they are within 5% of the answer I calculated in Excel

    (Questions on next page)

  1. Which company has the best liquidity (highest current ratio) in Year 2?

  2. Which company does the best job generating profits for shareholders in Year 2? (ROE)

  3. Which company does the best job generating profits with its total investment in Year 2? (ROA)

  4. Which company is the most leveraged (high long-term debt to equity) in Year 2?

  5. Which company has the biggest current threat of being illiquid (lowest current ratio) in Year 2?

  6. Which company saw the biggest increase in its net profit margin from Year 1 to Year 2 (or smallest decrease if NI all

    negative)?

  7. What is company 2's ROA in Year 2?

  8. What is company 1's ROA in Year 1?

  9. What is company 3's ROA in Year 2?

  10. Which company has the highest gross margin in Year 2?

  11. What is company 1's quick ratio in Year 1?

  12. What is company 2's current ratio in Year 2?

  13. What is company 3's net margin in Year 2?

  14. What is company 2's inventory turnover in Year 2?

  15. What is company 3's long-term debt to assets ratio in Year 1?

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

Accounting Information Systems Connecting Careers Systems And Analytics

Authors: Arline A. Savage, Danielle Brannock, Alicja Foksinska

1st Edition

1119744474, 9781119744474

More Books

Students also viewed these Accounting questions

Question

How can emotions cause communication breakdown?

Answered: 1 week ago

Question

Differentiate tan(7x+9x-2.5)

Answered: 1 week ago

Question

Explain the sources of recruitment.

Answered: 1 week ago

Question

Differentiate sin(5x+2)

Answered: 1 week ago

Question

Compute the derivative f(x)=1/ax+bx

Answered: 1 week ago