Step $1$: Calculate Ratios

Use the Apple and $10-$K you worked with in Week $1$

Download this Excel template Download this Excel templateand fill out the first tab, the Summary Sheet, for your company.

Ideally, you would compare your company across time and against the competition. In the interest of valuing your time, please only calculate the ratios for the past two fiscal years rather than the five that is typical.

Step $2$: DuPont Analysis

On the second tab of the sheet is a DuPont Analysis of a competitor of each of the companies you could choose from.

Please look at your favored competitor and use them for comparison purposes.

Step $3$: Summary Email

Write an email to your boss $($in this case, your instructor$)$ In this email, assume you are a top level manager of your chosen company. $($Do not send the email. You will upload the email through the assignment link.$)$

Outline how your company is doing in the most recent year compared to the prior year. Make sure to discuss profit, utilization, liquidity, and debt ratios. Also, compare how you are doing against your nearest competitor $($using the DuPont analysis$).$

Points will be given based both on your use of numbers $($you cannot just say direction $--$ i$.$e$.$ "ROA dropped", you need to show numbers $--$ i$.$e$.$ "ROA dropped from $15\%$ to $10\%$ because..."$)$ and your explanation as to WHY that is happening. This should be a professional email. Therefore, formatting, grammar, and spelling are important.