calculate basic financial statements, determine what it is telling us about the company, and write a professional email outlining your findings.

Step 1: Calculate Ratios

• The company you will use and 10-K is APPLE
• Use the excel template blow and fill out the first tab, the Summary Sheet, for the 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.
• 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.

Please please help me out. I would appreciate it so much! If you zoom in the numbers show perfectly and clear. This is my second time editing the question.

Your company name HERE \begin{tabular}{|lll|} \hline Profit Ratios & Date 1 & Date 2 \\ \cline { 2 - 3 } Profit Margin & & \\ Return on Assets & & \\ Return on Equity & & \\ \hline \end{tabular} \begin{tabular}{|lll|} \hline Asset Utilization Ratios & Date 1 & Date 2 \\ \cline { 2 - 3 } Receivable Turnover & & \\ Average Collection Days & & \\ Inventory Turnover & & \\ Fixed Asset Turnover & & \\ Total Asset Turnover & & \\ \hline \end{tabular} 1