MCDL, LLC would like to invest $3M in Apple and needs you to analyze the financial data and provide the following items:

The analysis will be based on the last two years' of financial data for Apple:

1. Prepare a comparative P&L horizontal and vertical analysis using the financial information on the Income Statement "tab". (40 points)

2. Solvency & Profitability ratio - Provide a detailed analysis for each ratio listed below, comparing ratios to industry standards (if available)(20 points).

a. Solvency Times Interest Earned

b. Profitability Gross Margin

3. Liquidity ratio - Provide a detail analysis for each ratio listed below, comparing ratios to industry standards(if available). (20 points)

a. Working Capital, Quick Ratio, AR Turnover, DSO AR, Inventory Turnover and, DSO Inventory

4. Provide recommendations to the management and discuss why? (20 points)

. MBAA 501_Final Project FQ22 Home Insert Draw Page Layout Formulas Data Review View Acrobat Q Tell me Office Update To keep up-to-date with security updates, flxes, and improvements, choose Check for updates. Check for Upolates B12 xfx M MBAA 501_Final Project FQ22 Home Insert Draw Page Layout Formulas Data Review view Acrobat ? Tell me Office Update To keep up-to-date with security updetes, flxes, and improverments, choose Check for Updates. Check for Updates Harizontall Vertical Analysis Incame Statement Kay Ratios Select destination and press ENTER or chacse Faste AAPL Financial Ratio's FY2020 - FY2022