Using the apple $10-$k

Step $1$: Calculate Ratios

Use the same company and $10-$K you worked with in Week $2$

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$--$You will actually use word and type the body of the email$)$ In this email, assume you are a top level manager of your chosen company.

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.any, calculate the depreciation expense: Sales $=$ $$89,000$; Costs $=$ $$44,400$; Addition to retained earnings $=$ $$13,800$; Dividends paid $=$ $$3,420$; Interest expense $=$ $$3,750$; Tax rate $=22$ percent. $($Do not round intermediate calculations and round your answer to the nearest whole number, e$.$g$.,32.)$