Step $1$: Calculate Ratios

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

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.

$\backslash$table$[[\backslash$table$[[$Profit Ratios$],[$Profit Margin$]],$Date $1,$ Date $2],[,],[$Return on Assets$],[$Return on Equity$],[$Asset Utilization Ratios,Date $1,$Date $2],[$Receivable Turnover$],[$Average Collection Days$],[$Inventory Turnover$],[$Fixed Asset Turnover$],[$Total Asset Turnover$],[\{$

$\backslash$table$[[$Liquidity Ratios$],[$Current Ratio$]]\}],[],[$Quick Ratio$],[\{$

$\backslash$table$[[$Debt Utilization Ratios$],[$Debt to Total Assets$]]\}],[$Debt to Total Assets$],[$Times Interest Earned$],[$Debt to Equity$],[$Dupont Analysis,Date $1,$Date $2],[$Profit Margin$],[x$