Question

What are the answers to questions 9, 10, 11, and 12 and how do I do...

What are the answers to questions 9, 10, 11, and 12 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?

Homework Answers

Answer #1
return on assets net income / total assets
company 1 2 3
year 1 year 2 year 2
net income 960 440 8912
total assets 5255 4681 254725
return on assets 0.18 0.09 0.03
gross margin gross profit / sales * 100
company 1 2 3
year 2 year 2 year 2
gross profit 22585 1988 36277
sales 124959 5054 186506
gross margin 18.07% 39.34% 19.45%
company 2 has highest gross profit
quick ratio (current assets - inventory)/total current liabilities
company 1 year 1
current assets 3145
inventory 221
total current liabilities 873
quick ratio 3.35
current ratio current assets / current liabilities
company 2 year 2
current assets 1550
current liabilities 289
current ratio 5.36
net margin net income / sales * 100
company 3 year 2
net income 8912
sales 186506
net margin 4.78%
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
I need to calculate the following information for Allscripts (MDRX) but I do not know how....
I need to calculate the following information for Allscripts (MDRX) but I do not know how. 1. Liquidity of Short-Term Assets Current Ratio Cash Ratio Quick Ratio 2. Long-Term Debt-paying Ability Debt Ratio Debt-equity Ratio Times Interest Earned 3. Profitability Net Income / Sales (Profit Margin) Net Income / Assets (ROA) Net Income / Shareholder Equity (ROE) 4. Asset Utilization / Management Efficiency Total Asset Turnover Inventory Turnover Measures Accounts Receivable Turnover 5. Market Measures Price / Earnings Ratio Earnings...
The Smathers Company has a long-term debt ratio (i.e., the ratio of long-term debt to long-term...
The Smathers Company has a long-term debt ratio (i.e., the ratio of long-term debt to long-term debt plus equity) of .53 and a current ratio of 1.42. Current liabilities are $2,470, sales are $10,690, profit margin is 10 percent, and ROE is 15 percent.    What is the amount of the firm’s net fixed assets? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)    Net fixed assets            $
The Smathers Company has a long-term debt ratio (i.e., the ratio of long-term debt to long-term...
The Smathers Company has a long-term debt ratio (i.e., the ratio of long-term debt to long-term debt plus equity) of .55 and a current ratio of 1.44. Current liabilities are $2,480, sales are $10,720, profit margin is 12 percent, and ROE is 17 percent. What is the amount of the firm’s net fixed assets? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)
I am struggling with understanding what to use to complete this assignment. From textbook Strategic Management...
I am struggling with understanding what to use to complete this assignment. From textbook Strategic Management by David and David 16th edition, Complete Experiential Exercise 4C, Step 1, on textbook page 124. Once you have found Table 4-4, complete the first 18 ratios and then 2 of your choice from the remaining growth ratios (this will equal the 20 required in the Assurance of Learning Exercise). It is required that you show your work. Use the financial documents on pages...
Question 1 1a) A company has $1 billion of sales and $50 million of net income.  Its...
Question 1 1a) A company has $1 billion of sales and $50 million of net income.  Its total assets are $500 million, financed half by debt and half by common equity.  What is its profit margin?  What is its ROA? 4 Sales ($M) Net income ($M) Total assets ($M) Debt ratio Profit margin Sales ($M) Net income ($M) Total assets ($M) Debt ratio ROA 1b) A company has a profit margin of 6%, a total asset turnover ratio of 2, and an equity...
Express your answers in strictly numerical terms Round each answer to the third decimal space. A-...
Express your answers in strictly numerical terms Round each answer to the third decimal space. A- "Last Year, a corporation had a book value of equity of $400 million of USDs, 5 million shares outstanding, and a market price of $45 per share. The corporation also had cash of $5 million of USDs, and total debt of $300 million USDs. What was the corporation's market capitalization, in million USDs? Note: Express your answers in strictly numerical terms. " B- "Last...
Ratios and Fixed Assets [L{)2] The Maurer company has a long-term debt ratio of .35 and...
Ratios and Fixed Assets [L{)2] The Maurer company has a long-term debt ratio of .35 and a current ratio of 1.30. Current liabilities are $955, sales 'are $7,210, profit margin is 8.3 percent, and RoE is 17.5 percent. what is the amount of the firm's net fixed assets?
Konami Inc. Ratio Questions (show work) Questions: 1. What is the Current Ratio for 2014 &...
Konami Inc. Ratio Questions (show work) Questions: 1. What is the Current Ratio for 2014 & 2015? 2. What is the Net Operating profit percentage (%) for 2014 & 2015? 3. What is the Accounts Receivable Turnover in days for 2014 and 2015? 4. What is the Inventory Turnover in “times,” and days for 2014 and 2015?                                                 Konami Inc. assets 2015 2014 Current Assets:                         Cash and Cash Equivalents $56,540,000 $50,886,000 Receivables – net 14,000,000     11,200,000 Inventory...
I have different figures. I would like to see calculation workings for: a) Investment Rotation, to...
I have different figures. I would like to see calculation workings for: a) Investment Rotation, to arrive to 0.85. b) Economic and Financial returns (ROA Return On Assets, ROE Return On Equity, ROI Return On Investments) and if these are the correct requirements for reviewing economic and financial returns. Problem: The person in charge of the finances of the company MGT, S.A. wants to know the company's situation concerning the industrial sector to which it belongs. For this, it has...
I'm having a really hard time with my financial calculator/ excel. I just need the answers...
I'm having a really hard time with my financial calculator/ excel. I just need the answers $ and % Market Value Capital Structure Suppose the Schoof Company has this book value balance sheet: Current assets $30,000,000 Current liabilities $10,000,000 Fixed assets 50,000,000 Long-term debt 30,000,000   Common stock   (1 million shares) 1,000,000 Retained earnings 39,000,000 Total assets $80,000,000 Total claims $80,000,000 The current liabilities consist entirely of notes payable to banks, and the interest rate on this debt is 9%, the...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT