Find the Solvecy Ratios (debt to equity ratio and times interest ratio) for 2022 and 2023 using this balance sheet. Please show the formula (instructions down below)

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. A B C D E F KOHL'S CORPORATION CONSOLIDATED BALANCE SHEETS Period End: Jan 28, 2023 Date Filed: Mar 16, 2023 KOHL'S CORPORATION CONSOLIDATED BALANCE SHEETS (Dollars in Millions) Assets Current assets: Cash and cash equivalents Merchandise inventories Other Total current assets Property and equipment, net Operating leases Other assets Total assets Liabilities and Shareholders 'Equity Current liabilities: Accounts payable Accrued liabilities Borrowings under revolving credit facility Current portion of: Long-term debt Finance leases and financing obligations Operating leases Total current liabilities Long-term debt Finance leases and financing obligations Operating leases Deferred income taxes Other long-term liabilities Total liabilities Shareholders' equity: Common stock - 378,377,377, and 375 million shares issued, respectively Paid-in capital Treasury stock, at cost, 267, 246, 219, and 219 million shares, respectively Retained earnings Total shareholders' equity Total liabilities and shareholders' equity 2022 2021 \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline$ & 153 & $ & 1,587 & $ & 2,271 & $ & 723 \\ \hline & 3,189 & & 3,067 & & 2,590 & & 3,537 \\ \hline & 394 & & 369 & & 974 & & 389 \\ \hline & 3,736 & & 5,023 & & 5,835 & & 4,649 \\ \hline & 7,926 & & 7,304 & & 6,689 & & 7,352 \\ \hline & 2,304 & & 2,248 & & 2,398 & & 2,391 \\ \hline & 379 & & 479 & & 415 & & 163 \\ \hline$ & 14,345 & $ & 15,054 & $ & 15,337 & $ & 14,555 \\ \hline \end{tabular} 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. A B C D E F KOHL'S CORPORATION CONSOLIDATED BALANCE SHEETS Period End: Jan 28, 2023 Date Filed: Mar 16, 2023 KOHL'S CORPORATION CONSOLIDATED BALANCE SHEETS (Dollars in Millions) Assets Current assets: Cash and cash equivalents Merchandise inventories Other Total current assets Property and equipment, net Operating leases Other assets Total assets Liabilities and Shareholders 'Equity Current liabilities: Accounts payable Accrued liabilities Borrowings under revolving credit facility Current portion of: Long-term debt Finance leases and financing obligations Operating leases Total current liabilities Long-term debt Finance leases and financing obligations Operating leases Deferred income taxes Other long-term liabilities Total liabilities Shareholders' equity: Common stock - 378,377,377, and 375 million shares issued, respectively Paid-in capital Treasury stock, at cost, 267, 246, 219, and 219 million shares, respectively Retained earnings Total shareholders' equity Total liabilities and shareholders' equity 2022 2021 \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline$ & 153 & $ & 1,587 & $ & 2,271 & $ & 723 \\ \hline & 3,189 & & 3,067 & & 2,590 & & 3,537 \\ \hline & 394 & & 369 & & 974 & & 389 \\ \hline & 3,736 & & 5,023 & & 5,835 & & 4,649 \\ \hline & 7,926 & & 7,304 & & 6,689 & & 7,352 \\ \hline & 2,304 & & 2,248 & & 2,398 & & 2,391 \\ \hline & 379 & & 479 & & 415 & & 163 \\ \hline$ & 14,345 & $ & 15,054 & $ & 15,337 & $ & 14,555 \\ \hline \end{tabular}