all Sprint 10:25 PM 1 84% Notes Do a Ratio Analysis for Apple and Microsoft. Write a description on both companies and provide charts or graphs explaining the analysis Financial Metrics Apple Microsoft 2019 Five Yr Avg 2019 Five Yr Avg 2015 2016 2017 2018 2015 2016 2017 2018 Liquidity Current Ratio 0.96 124 1.11 1.35 1.28 1.12 154 1.28 131 1.10 1.14 IS Quick Ratio 1.33 1.50 1.25 0.75 089 1.05 0.97 1.08 1.23 109 1.16 0.96 Cash Ratio 0.52 0.85 0.74 0.57 0.95 0.72 0.52 022 0.37 0.53 034 039 Activity/Asset Utilization Receivable Turnover 13.87 13,69 12.82 11.45 11.35 12,64 11.47 9,62 10.81 10.75 11.46 1082 Inventory Turnover Payables Turnover Days Receivables 6.02 5.89 5.84 5,62 5.77 5.828 10.44 8.26 874 9.16 9.83 9.29 6.25 8.39 9.53 8.56 8.482 5.12 7.74 7.03 6.4 6.02 9.68 6.46 33.95 32.48 38.58 36.18 37.96 35.44 36.128 31.82 37.94 33.76 31.84 33.86 Days Inventory Days Payable 60.59 61.96 62.53 64.93 63.25 62.652 34,98 4421 41.77 3983 37.15 39.59 37.72 58.36 43.52 38.3 42.62 44,104 71.32 47.17 51.92 56.94 60.59 57.59 3.32 3.14 3.246 3.38 3.87 3.62 Fixed Asset Turmover 3.52 3.12 3.13 3.86 342 3.58 0.52 Total Asset Turnover 049 0.58 0.56 0.5 0.53 0.44 0.44 037 043 0.44 042 Leverage/Long Term Solvency Debt Ratios 60.44% 63.16 % 70.13 % (Total Debt Ratio) 71.64% 61.95% 67.05% 64.85 % 82.89% 71.75% 68,66% 75.27% 73.74% Debt/Equity 173 0.90 0,99 1.12 1.38 1.22 245 100 1,06 1,00 137 137 Equity Multplier Coverage Ratios Times Interest Earned 3.53 2.53 2.63 2.71 3,04 2.89 5.84 3.54 3.35 3.19 4.04 3.99 10.20 14.52 27.15 24.35 22.09 20.10 20.78 8.61 11.25 10.14 10.65 10.54 1024 35.74 187 EBITDA Coverage 33.12 30.06 24.40 27.57 1.53 1.75 1.71 1.68 1.71 Profitability Margin Based Gross Profit Margin 60.53% 60.86% 60.32 % 61.11% 60.70% 54.99% 52.49 % 52.22% $2.96% 53.69% 53.27 % 60.68% 21.83 % 21.11% 21.38 % 13.91% 14.61% Operating Profit Margin Net Profit Margin 19.70% 21.82% 22.45% 13.25% 14.48% 14.37% 9.77% 14.12% 16.60% 18.42% 18.78% 18.32% 15.43% 17.51% 8.65% 9,69% 9.43% 10.15% 9.54% Return Based 11.36 % 11.36 % 13.59 % Return on Operating Assets Retum on Assets 12.70% 10.55% 13.22% 12.53% 12.71% 9.69% 12.51% 11.99% 12.21% 10.72% 10.47% 9.53% 7.71% 9.32% 7.83% 8.28% 8.70% 9.24% 8.58% 8.16% 8.84% Retun on Invested Capital Return on Equity 13.84 % 10.54% 14.24% 13.79% 12.22% 9.85% 12.13% 759% 12.54% 13.01% 10.75% 1.54% 28.77% 25.88% 14 % 30% 25.60% 27.10% 27.51% 23.41% 26.53 % 33% 30% 21%) all Sprint 10:25 PM 1 84% Notes Do a Ratio Analysis for Apple and Microsoft. Write a description on both companies and provide charts or graphs explaining the analysis Financial Metrics Apple Microsoft 2019 Five Yr Avg 2019 Five Yr Avg 2015 2016 2017 2018 2015 2016 2017 2018 Liquidity Current Ratio 0.96 124 1.11 1.35 1.28 1.12 154 1.28 131 1.10 1.14 IS Quick Ratio 1.33 1.50 1.25 0.75 089 1.05 0.97 1.08 1.23 109 1.16 0.96 Cash Ratio 0.52 0.85 0.74 0.57 0.95 0.72 0.52 022 0.37 0.53 034 039 Activity/Asset Utilization Receivable Turnover 13.87 13,69 12.82 11.45 11.35 12,64 11.47 9,62 10.81 10.75 11.46 1082 Inventory Turnover Payables Turnover Days Receivables 6.02 5.89 5.84 5,62 5.77 5.828 10.44 8.26 874 9.16 9.83 9.29 6.25 8.39 9.53 8.56 8.482 5.12 7.74 7.03 6.4 6.02 9.68 6.46 33.95 32.48 38.58 36.18 37.96 35.44 36.128 31.82 37.94 33.76 31.84 33.86 Days Inventory Days Payable 60.59 61.96 62.53 64.93 63.25 62.652 34,98 4421 41.77 3983 37.15 39.59 37.72 58.36 43.52 38.3 42.62 44,104 71.32 47.17 51.92 56.94 60.59 57.59 3.32 3.14 3.246 3.38 3.87 3.62 Fixed Asset Turmover 3.52 3.12 3.13 3.86 342 3.58 0.52 Total Asset Turnover 049 0.58 0.56 0.5 0.53 0.44 0.44 037 043 0.44 042 Leverage/Long Term Solvency Debt Ratios 60.44% 63.16 % 70.13 % (Total Debt Ratio) 71.64% 61.95% 67.05% 64.85 % 82.89% 71.75% 68,66% 75.27% 73.74% Debt/Equity 173 0.90 0,99 1.12 1.38 1.22 245 100 1,06 1,00 137 137 Equity Multplier Coverage Ratios Times Interest Earned 3.53 2.53 2.63 2.71 3,04 2.89 5.84 3.54 3.35 3.19 4.04 3.99 10.20 14.52 27.15 24.35 22.09 20.10 20.78 8.61 11.25 10.14 10.65 10.54 1024 35.74 187 EBITDA Coverage 33.12 30.06 24.40 27.57 1.53 1.75 1.71 1.68 1.71 Profitability Margin Based Gross Profit Margin 60.53% 60.86% 60.32 % 61.11% 60.70% 54.99% 52.49 % 52.22% $2.96% 53.69% 53.27 % 60.68% 21.83 % 21.11% 21.38 % 13.91% 14.61% Operating Profit Margin Net Profit Margin 19.70% 21.82% 22.45% 13.25% 14.48% 14.37% 9.77% 14.12% 16.60% 18.42% 18.78% 18.32% 15.43% 17.51% 8.65% 9,69% 9.43% 10.15% 9.54% Return Based 11.36 % 11.36 % 13.59 % Return on Operating Assets Retum on Assets 12.70% 10.55% 13.22% 12.53% 12.71% 9.69% 12.51% 11.99% 12.21% 10.72% 10.47% 9.53% 7.71% 9.32% 7.83% 8.28% 8.70% 9.24% 8.58% 8.16% 8.84% Retun on Invested Capital Return on Equity 13.84 % 10.54% 14.24% 13.79% 12.22% 9.85% 12.13% 759% 12.54% 13.01% 10.75% 1.54% 28.77% 25.88% 14 % 30% 25.60% 27.10% 27.51% 23.41% 26.53 % 33% 30% 21%)