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) AAPL income Statement FY2020 - FY2022 (in millions) 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) AAPL income Statement FY2020 - FY2022 (in millions)