AutoSave as: Q '9 G {fl} '3 HCA230 Project Part 3 Re sed 0822 (6) Q go Home Insert Draw Page Layout Formulas Data Review View Q Tell me I9 Share Ci Comments 23: Arial v 12 v A" AV E E : $9 gwIaprextv General v Jr' v 'v 'v a?\" LIJTXIV v 2V Avvpv @ [E v I J __{/ I I I I I I v Z Paste U v v (k v A v E E E : : I v v 0 e0 00 Conditional Format Cell Insert Delete Format Sort & Find & Analyze 6 B I L L 5': Merge 8' Center $ A) , '00 9 Formatting as Table Styles 9 V Filter Select Date A9 : f3: 1 A B c D E F G 9 1 Ratio Name Procedure Step 1. Write the formula Explain what the formula means 10 (Example) Current Ratio CurrentAssets/Current Liabilities The current ratio is a liquidity ratio that measures a company's ability to pay short-ten" obligations or those due within one year. lttells investors and analysts how a company can maximize the current assets on its balance sheetto satisfy its current debt and other 11 payables. 12 Pima Medical Center Tucson Regional 13 Procedure Step FY2019 FY2020 FY2021 FY2021 14 2. Use excel formulas to do the calculation 0.947566 0.592982 0.000020 1.659686 15 3. Format the answer 0.95 0,59 0.00 1,66 16 17 Calculate the given 15 Ratios for BOTH hospitals. 18 2 Ratio Name Procedure Step 1.Write the formula Explain what the formula means 19 Acid Test Ratio 20 u p.m.M.d....c..... 22 Procedure Step FY2019 FY2020 FY2021 FY2021 23 2. Use excel formulas to do the calculation 24 3. Format the answer _ _ _ _ 25 26 27 3 Ratio Name Procedure Step 1. Write the formula Explain what the formula means 28 Profit Margin 29 30 Tucson Regional 31 Procedure Step 32 2. Use excel formulas to do the calculation 33 3. Format the answer 34 35 36 4 Ratio Name Procedure Step 1: Write the formula Explain what the formula means I H Instructions Ratio List Hospital Financial Statements 01 ID Financial Stmts Needed Q2 Ratio Calculations 03 Summary and Analysis Q4 Common Size Fin Statement + Ready Circular References :3 7;)? Accessibility: Investigate E El 6] - + 100%