The chosen company is apple inc

Reference no: EM13231613

The chosen company is Apple Inc.

1. Compute the following ratios in Excel for two years.
1. Debt ratio
2. Gross profit margin
3. Free cash flow
4.Times interest earned
5. Accounts receivable turnover
6. Inventory turnover

2. Prepare a DuPont Analysis of ROE for two years, including computations of
1. Return on Sales
2. Asset Turnover
3. Return on Assets
4. Financial Leverage
5. Return on Equity

3. Briefly evaluate the ratio trends. Indicate on your worksheet whether each ratio is:
1. stronger /weaker
2.quicker /slower
3. more / less liquid
4. more / less risk

4. Submit a report. Write a 2-4 page report evaluating trends in all of the above ratios. Discuss whether your company's profitability, efficiency, liquidity, and solvency are improving or deteriorating.

Format: Double-spaced, one-inch margins, using a 12-point Times New Roman font Required minimum-2 page

Reference no: EM13231613

Questions Cloud

Explain and identify the acid-base conjugate pairs : For each reaction, identify the acid-base conjugate pairs. Then rank all reactions in order of increasing tendency for the reaction to go to completion (to the right).

Define the locus alleles and synapsis : the maximum number of different alleles for any one gene anindividual, When during meiosis independent assortment occurs, What is a locus

Concepts in the design and analysis of the operations : Concepts in the Design and Analysis of the Operations,Transformation processes in manufacturing and services,Operations Planning

How long did the average passenger have to wait in line : Moreover, based on counting the number of passengers waiting in line, airport management found that the average number of passengers waiting for check-in was 35. How long did the average passenger have to wait in line?

The chosen company is apple inc : Compute the following ratios in Excel for two years.

Why bob and joe are always in a state of equilibrium : In city A, the value of an apartment falls in direct proportion to its distance from the business center. Thus an apartment one kilometer away will lose 20 percent of its value and an apt 2 kilometers away will lose 40 percent of its value.

Explain what is the value of kp for the dissociation of so3 : When a 0.0200 mol sample of SO3 is introduced into an evacuated 1.67 L vessel at 900K, 0.0132 mol SO3 is found to be present at equilibrium. What is the value of Kp for the dissociation of SO3 at this temperature?

Explain the great cultural outburst : How can you explain the great cultural outburst (art, architecture, literature, etc.) that occured during the renaissance? in other words, why did it happen at this particular time in history (15th-16th centuries)

Defend role of it department strategic and operational : Defend the role of the IT department as both a strategic and operational asset for the company.

User Account

All Pages