Recommendation of Kohl's ? Basic information about Kohl's organized as an easy-to-read table: ? Ticker symbol and stock exchange ? Number of employees ? Number of stores ? Size (total assets as of most recent fiscal year end) ? Net income or loss (as of most recent fiscal year end) ? Financial analysis should include: ? Discussion of Kohl's liquidity, solvency, and profitability ? A minimum of three charts and/or graphs

2020 2021 LIQUIDITY RATIOS Current ratio 1.93 1.53 Acid test (or quick ratio) 0.81 0.54 SOLVENCY RATIOS Debt to equity ratio 1.95 2.23 Times interest earned ratio (0.92) 5.69 PROFITABILITY RATIOS Return on assets (%) -1.09% 6.17% Return on equity (%) -3.06% 19.03% 2022 2023 Instructions: Column E --> Using the financial data provided in the different tabs, calculate the six missing financial ratios for fiscal year 2022. The financial ratios should be calculated using a formula and not keyed in. Input should look like this: "=K120/D370" Input should NOT look like this: 0.49 Column F-> Develop an estimate for the six missing financial ratios for fiscal year 2023. These inputs do not need to be formulas.