I have attached the balance sheet with all information needed to answer the boxes in blue. Acid ratio , percentages. Please help fill in the blue boxes in each year goven

AutoSave 10 HCA230_Project_P.. . Last Modified: 32m ago v File Home Insert Page Layout Formulas Data Review View Automate Help Arial 12 A 2b Wrap Text General Merge & Center * % " Clipboard Font Alignment Number 136 A D E F G H 23 Balance Sheets 24 2019 2020 2021 2021 25 Assets 26 Cash 621 1,793 1,451 1,676 27 Short-Term Investments 147 116 103 28 Accounts Receivables, Net 7,333 7,159 8,095 1,927 29 Supplies Inventory 1,849 2,025 1,986 335 30 Other Current Assets 1,190 1,340 1,896 519 31 Total Current Assets 11,140 12,433 13,531 4,457 32 33 Net Property, Plant & Equipment 24,549 25,223 26, 176 5,322 34 Long-Term Note Receivable 37 31 44 59 35 Intangible Assets 8,269 8,578 9,540 4,219 36 Total Assets 43,995 46,265 49,291 14,057 37 38 Liabilities & Shareholders' Equity 39 Accounts Payable 2,357 2,581 2,842 383 40 Short Term Debt 145 209 237 980 41 Current Portion of Long Term Debt 4,905 5,535 6,111 533 42 Other Current Liabilities 2,303 2,267 2,461 150 Hospital Financial Statements Q1 ID Financial Stets Needed Q2 Ratio Calculations Q3 5 ... Ready Circular References: H51 Accessibility: Investigate Q Search c. dynabookGener Arial 12 A 25 Wrap Text B I U v A Merge & Center $ Alignment Clipboard Font 136 fx A D E F G H 34 Long-Tem Note Receivable 35 Intangible Assets 8.269 8,578 9,540 4,219 36 Total Assets 43,995 46,265 49,291 14,057 37 38 Liabilities & Shareholders' Equity 39 Accounts Payable 2,357 2,581 2,842 383 40 Short Term Debt 145 209 237 980 41 Current Portion of Long Term Debt 4,905 5,535 6, 111 533 42 Other Current Liabilities 2,303 2,267 2,461 150 43 Accrued Payroll 2,054 2,314 2,381 637 44 Total Current Liabilities 11,764 12,906 14,032 2,683 45 Long-Term Debt 23, 107 20,301 23,765 11,033 46 Total Liabilities 34,871 33,207 37,797 13,716 Total Shareholders' Equity 9,124 13,058 11,494 341 + Liabilities & Shareholders' Equity 43,995 46.265 49.291 Hospital Financial Statements Q1 ID Financial Stmts Needed | Q2 Ratio Calculations Q Ready Circular References: H51 1% Accessibility: Investigate Search co dynaboo ESC F1 F2 F3 F5 F6 F7Home Insert Data Review View Automate Help File Page Layout Formulas Arial 12 ab, Wrap Text General A Merge & Center 9 F Clipboard Font Alignment N F21 XVfx B C D E Incorrect Incorrect Incorrect Incorrect 5 Ratio Name Procedure Step 1. Write the formula | Explain what the formula means Return on Assets Pima Medical Center Tueson Regional Procedure Step FY2019 FY2020 FY2021 FY2021 2. Use excel formulas to do the calculation 3. Format the answer Incorrect Incorrect Incorrect Incorrect 6 Ratio Name Procedure Step 1: Write the formula | Explain what the formula means Inventory Turnover Pima Medical Center Tueson Regional Procedure Step FY2019 FY2020 FY2021 FY 2021 2. Use excel formulas to do the calculation 3. Format the answer Incorrect ncorrect ncorrect Incorrect Ratio Name Procedure Step 1: Write the formula kplain what the formula means Days in Inventory 67 68 Pima Medical Center Procedure Steps Tucson Regiona FY2019 69 FY2020 Y2021 FY2021 70 2. Use excel formulas to do the calculation 3. Formal the answer Hospital Financial Statements Q1 ID Financial Stmts Needed Q2 Ratio Calculations Ready Circular References: A82 Box Accessibility: Investigate Q Search c dynabooAutoSave HCA230_Project_P... . Last Modified: 3 Automate File Home Page Layout Formulas Data Review View Help Insert Aria 12 29 Wrap Text General B Merge & Center $ * % Number Clipboard Font Alignment F21 B C D E 73 8 Ratio Name Procedure Step 1 Write the formula | Explain what the formula means 74 in Accounts Receiv 75 Pima Medical Center Tueson Regiona Procedure Steps FY 2019 FY2020 FY2021 FY2021 2. Use excel formulas to do the calculation 3. Format the answer 8 3 2 2 23 43 Incorrect Incorrect Incorrect Incorrect Ratio Name Procedure Step 1: Write the formula | Explain what the formula means AR Turnover 84 BS Pima Medical Center Tucson Regiona 86 Procedure Steps FY 2019 FY2020 FY2021 FY 2021 BT as to do the calculation Incorrect Incorrect correct Incorrect Ratio Name Procedure Step 1: Write the formula | Explain what the formula means #s in Accounts Paya 93 Pima Medical Center Tueson Regiona Procedure Steps FY2015 FY2020 FY2021 FY2021 97 2. Use excel formulas to do the calculation 3. Format the answer Incorrect Incorrect Incorrect ncorrect Hospital Financial Statements Q1 ID Financial Stmts Needed Q2 Ratio Calculations Ready Circular References: A82 1 Accessibility: Investigate Q Search c. dynabookAutosave Review File Page Layout Formulas View Automate Home Insert Data Help General Arial 12 A 25 Wrap Text BI UV A E Merge & Center $ % Clipboard Font F Alignment Number D117 fx D E Incorrect Incorrect Incorrect Incorrect 98 100 Ratio Name Procedure Step 1. write the formula | Explain what the formula means 107 ash Conversion Cyc 102 Pima Medical Center Tueson Regional 104 Procedure Steps FY2019 FY2020 FY2021 FY 2021 105 2. Use excel formulas to do the calculation 106 3. Format the answer 107 Incorrect Incorrect Incorrect Incorrect 108 109 12 Ratio Name Procedure Step 1: Write the formula | Explain what the formula means 710 Debt Ratio 112 Pima Medical Center Tucson Regiona Procedure Steps FY2019 FY2020 FY2021 FY2021 e excel formulas to do the calculation 3. Format the answer 116 Incorrect Incorrect ncorrect 118 13 Ratio Name Procedure Step 1: Write the formula | Explain what the formula means 119 imes Interest Earned 120 141 Pima Medical Center Tucson Regions 12 Procedure Steps FY 2019 FY2020 FY2021 FY2021 123 2. Use excel formulas to do the calculation 124 3. Format the answer 125 Incorrect Incorrect Incorrect Incorrect Hospital Financial Statements Q1 ID Financial Stmts Needed Q2 Ratio Calculations Q3 S Ready Circular References: A82 Accessibility. Investigate Q Search c. dynabook ESC F1 F2 F3 F4 F5 F6Data Home Insert Page Layout Formulas Review View Automate Help File Arial 12 A A 25 Wrap Text General BIUV A Merge & Center Clipboard Font Alignment D117 X V fx B C D E 3. Format the answer 125 Incorrect Incorrect Incorrect Incorrect 126 127 14 Ratio Name Procedure Step 1. write the formula | Explain what the formula means 128 Debt to Equity Ratio 129 130 Pima Medical Center Tucson Regional 151 Procedure Steps FY 2019 FY2020 FY2021 FY2021 Use excel formulas to do the calculation 3. Format the answer Incorrect Incorrect Incorrect Incorrect 136 15 Ratio Name |Procedure Step 1: Write the formula | Explain what the formula means 137 Days Cash on Hand 138 139 Pima Medical Center Tucson Regiona 140 ocedure Steps FY2019 FY2020 FY2021 FY2021 141 2. Use excel formulas to do the calculation + 142 Format the answer 143 Incorrect Incorrect Incorrect Incorrect 148 149 151 Hospital Financial Statements |Q1 ID Financial Stmts Needed Q2 Ratio Calculations Q3 Ready Circular References; A82 1x Accessibility: Investigate Q Search c. dynaboo