I need help with this question HCA 230 project 3

Question 2: Calculate the provided 15 ratios for BOTH hospitals - The first ratio calculation has been completed for you as an example. - Areas in which you are required to input data are shaded in blue. Ratio Calculation Procedure Steps 1. Write the formula. 2. Use excel formulas to do the calculation + See help video - link in Cell D4 3. Format the answer 4. In the cell immediately below each set of calculations it will say "Correct" if your calculated value in part 2 is correct. If it is incorrect a red highlight will show "incorre -inancial Statements Note Amounts in 1,000s of dollars Balance Sheets Assets Cash Short-Term Investments Accounts Receivables, Net Supplies Inventory Other Current Assets Total Current Assets Net Property, Plant \& Equipment Long-Term Note Receivable Intangible Assets Total Assets Liabilities \& Shareholders' Equity Accounts Payable Short Term Debt \begin{tabular}{|rrr|r|} & & & \\ 2019 & 2020 & 2021 & 2021 \\ 621 & 1,793 & 1,451 & 1,676 \\ 147 & 116 & 103 & - \\ 7,333 & 7,159 & 8,095 & 1,927 \\ 1,849 & 2,025 & 1,986 & 335 \\ 1,190 & 1,340 & 1,896 & 519 \\ 11,140 & 12,433 & 13,531 & 4,457 \\ 24,549 & 25,223 & 26,176 & 5,322 \\ 37 & 31 & 44 & 59 \\ 8,269 & 8,578 & 9,540 & 4,219 \\ 43,995 & 46,265 & 49,291 & 14,057 \\ & & & \\ 2,357 & 2,581 & 2,842 & 383 \\ 145 & 209 & 237 & 980 \end{tabular} Liabilities \& Shareholders' Equity Accounts Payable Short Term Debt Current Portion of Long Term Debt Other Current Liabilities Accrued Payroll Total Current Liabilities Long-Term Debt Total Liabilities Total Shareholders' Equity Liabilities \& Shareholders' Equity E F G H 2,3571452,5812092,842237 383 145 209 237 980 4,9055,5356,111 533 150 \begin{tabular}{lll|l} 2,303 & 2,267 & 2,461 & 150 \\ 2,054 & 2,314 & 2,381 & 637 \\ \hline 11,764 & 12,906 & 14,032 & 2,683 \end{tabular} \begin{tabular}{lll|r} 11,764 & 12,906 & 14,032 & 2,683 \\ 23,107 & 20,301 & 23,765 & 11,033 \\ \hline 34,871 & 33,207 & 37,797 & 13,716 \end{tabular} 13,716 34,87133,20737,797 13,058 11,494 341 43,99546,26549,291 1