Solve please

Using the provided Excel sheet (in D2L) show the income statements, balance sheets, and cash flow statements, calculate the financial ratios for Walt Disney Co and one of its Competitor/Peer VIACOM. You must calculate the financial ratios for the most recent five full years for Walt Disney Co. and VIACOM. Show how you calculated the ratios for both companies. Tax rate is 20%. 1. Explain your findings for each ratio (Current, Quick, ROA, ROE, TIE, and others). i.e. current ratio is deteriorating. 2. Explain your findings for category of ratios (Liquidity, Debt, Asset Management and others). i.e. Overall liquidty ratios are improving and show no sign of immediate liqudity problem. 3. Which of the ratios may indicate problems? For these, explain the potential problems. i.e. Quick ratio is declining and indicate that the firm is likely to have difficulty to cover its short term cash expenses. Using the provided Excel sheet (in D2L) show the income statements, balance sheets, and cash flow statements, calculate the financial ratios for Walt Disney Co and one of its Competitor/Peer VIACOM. You must calculate the financial ratios for the most recent five full years for Walt Disney Co. and VIACOM. Show how you calculated the ratios for both companies. Tax rate is 20%. 1. Explain your findings for each ratio (Current, Quick, ROA, ROE, TIE, and others). i.e. current ratio is deteriorating. 2. Explain your findings for category of ratios (Liquidity, Debt, Asset Management and others). i.e. Overall liquidty ratios are improving and show no sign of immediate liqudity problem. 3. Which of the ratios may indicate problems? For these, explain the potential problems. i.e. Quick ratio is declining and indicate that the firm is likely to have difficulty to cover its short term cash expenses