Using the provided Excel sheet $($in D$2$L$)$ show the income statements, balance sheets, and cash flow statements, calculate the financial ratios for Walt Disney Co and one of its Competitors$/$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.BALANCE SHEET$\backslash$table$[[$Statement of CASH FLOW,$2014-09,2015-09,2016-09,2017-09,2018-09],[],[$Cash Flows From Operating Activities$],[$Net income,$8004,8852,9790,9366,13066],[$Depreciation & amortization,$2288,2354,2527,2782,3011],[$Deferred income taxes,$517,-102,1214,334,-1573],[$Stock based compensation,$408,410,393,364,393],[$Change in working capital,$-1236,-793,-1003,-1185,-1360],[$Inventory$,-81,1,186,-5,-17],[$Other working capital,$-1155,-794,-1189,-1180,-1343],[$Other non$-$cash items,$-201,188,292,682,758],[$Net cash provided by operating activities,$9780,10909,13213,12343,14295],[$Cash Flows From Investing Activities$],[$Investments in property, plant, and equipment,$-3311,-4265,-4773,-3623,-4465],[$Acquisitions$,$ net,$-7,166,-805,-417,-1581],[$Other investing activities,$-27,-146,-180,-71,710],[$Net cash used for investing activities,$-3345,-4245,-5758,-4111,-5336],[$Cash Flows From Financing Activities$],[$Debt issued,$2231,2550,6065,4820,1056],[$Debt repayment,$-1648,-2221,-2205,-2364,-1871],[$Common stock repurchased,$-6527,-6095,-7499,-9368,-3577],[$Dividend paid,$-1508,-3063,-2313,-2445,-2515],[$Other financing activities,$742,3315,-1039,398,-1936],[$Net cash provided by $($used for$)$ financing activit,$-6710,-5514,-6991,-8959,-8843],[$Effect of exchange rate changes,$-235,-302,-123,31,-25],[$Net change in cash,$-510,848,341,-696,91],[$Cash at beginning of period,$3931,3421,4269,4760,4064],[$Cash at end of period,$3421,4269,4610,4064,4155],[$Free Cash Flow$],[$Operating cash flow,$9780,10909,13213,12343,14295],[$Capital expenditure,$-3311,-4265,-4773,-3623,-4465],[$Free cash flow,$6469,6644,8440,8720,9830],[$Number of Shares Outstanding and Price per Share,$2014-09,2015-09,2016-09,2017-09,2018-09],[$Shares$,1759,1709,1639,1578,1818],[$Price per Share,$89\mathrm{.}03,102\mathrm{.}2,92\mathrm{.}86,98\mathrm{.}57,116\mathrm{.}94]]$