Explore BrainMass
Share

Financial ratio analysis comprehensive problem

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Ratio Analysis -Comprehensive problem 2008 data.

A) Compute the following profitability measures for the year ended December 27,2008:

1. Return on investment , based on net income (perform a DuPont analysis).
2. Return on equity, based on net income.
3. Price/earnings ratio. Use $14.18 as the year-end market price.
4. Dividend yield.
5. Dividend payout ratio.

B) Compute the following liquidity measures at December 27,2008:

1. Working Capital.
2. Current Ratio.
3. Acid-test Ratio.

C) Compute the following activity measures for the year ended December 27,2008:

1. Number of Days' sales in accounts receivable, based on a 365 - day year.
2 Number of days' sales in inventory, based on a 365 day year.
3. Accounts receivable turnover.
4. Inventory turnover.
5. Turnover of net property, plant and equipment.

D). Compute the following financial leverage measures at December 27,2008:

1. Debt Ratio
2. Debt/equity ratio.

E) Compute the following physical measures of Intel's profitability at December 27, 2008:

1. Net revenues per employee.

2. Operating income per employee.

Show work in excel. I have attached the 2008 Intel financial report to retrieve the data

© BrainMass Inc. brainmass.com October 17, 2018, 3:04 am ad1c9bdddf
https://brainmass.com/business/finance/financial-ratio-analysis-comprehensive-problem-407425

Attachments

Solution Summary

Solution explains illustration of financial ratio analysis

$2.19
Similar Posting

P11-14 Ratio analysis—comprehensive problem Campbell Soup 2011

P11.14

Ratio analysis—comprehensive problem, 2011 data This problem is based on the 2011 annual report of Campbell Soup Company in the appendix.
Required:
a. Compute the following profitability measures for the year ended July 31, 2011:
1. Return on investment, based on net earnings (perform a DuPont analysis).
2. Return on equity, based on net earnings and total equity.
3. Price/earnings ratio. Use $33.05 as the year-end market price.
4. Dividend yield.
5. Dividend payout ratio.

b. Compute the following liquidity measures at July 31, 2011:
1. Working capital.
2. Current ratio.
3. Acid-test ratio.

c. Compute the following activity measures for the year ended July 31, 2011:
1. Number of days' sales in accounts receivable, based on a 365-day year.
2. Number of days' sales in inventory, based on a 365-day year.
3. Accounts receivable turnover.
4. Inventory turnover.
5. Turnover of net property, plant, and equipment.

d. Compute the following financial leverage measures at July 31, 2011:
1. Debt ratio.
2. Debt/equity ratio.

e. Compute the following physical measures of Campbell's profitability at July 31, 2011:
1. Net sales per employee.
2. Operating income per employee. (Note: In a page not reproduced in the appendix, Campbell's 2011 annual report disclosed that on July 31, 2011, the company had approximately 17,500 employees.)

View Full Posting Details