AutoSave O Off ) HCA230_Project_Part_3 9 Search (Alt+Q) ashley travers AT X File Home Insert Page Layout Formulas Data Review View Automate Help Comments Share Insert Arial ~ 12 ~ A" A ap Wrap Text Text Ex AY O x Delete Paste Conditional Format as Cell Sort & Find & Analyze E Merge & Center $ ~ % 9 08 20 Formatting Table ~ Styles v Format Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis F8 X V A B C D E F G H J K Pima Medical Center Tucson Regional Ratio FY2019 FY2020 FY2021 FY2021 Analysis Tucson is more liquid than Pima as it has 1.7X current assets to cover any cas 6 Current Ratio 0.9 1.0 1.0 1.7 compared to Pima, which just has 1X. 7 Acid Test Ratio 8.3 1.5 4.2 6.6 8 Profit Margin 8.4% 9.0% 10.2% 0.5% 9 Operating Margin 10.5% 11.0% 10.2% 0.5% 10 Return on Assets 38.6% 37.3% 44.3% 1.2% 11 Inventory Turnover 4.6 4.1 4.8 5.9 12 Days in Inventory 79.6 88.3 76.5 62.3 13 Days AR 52.1 50.7 50.3 59.7 Q2 Ratio Calculations Q3 Summary and Analysis Q4 Common Size Fin Statement + Ready TX Accessibility: Investigate + 100% 10:55 AM Type here to search O The w DEl 11/19/2022AutoSave O Off ) HCA230_Project_Part_3 9 Search (Alt+Q) ashley travers AT X File Home Insert Page Layout Formulas Data Review View Automate Help Comments Share ~ 12 ~ A" A Insert Arial ap Wrap Text Text Ex AY O x Delete Paste E = Merge & Center $ ~ % 9 08 20 Conditional Format as Cell Sort & Find & Analyze Formatting Table ~ Styles v Format Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis F8 X V fix A B C D E F G H K LA 14 AR Turnover 7.0 7.2 7.3 6.1 15 Days Payable 101.4 112.6 109.4 71.2 16 Cash Conversion Cycle 30.3 26.5 29.6 50.7 17 Debt Ratio 79.3% 71.8% 76.7% 97.6% 18 Times Interest Earned 3.0 3.6 5.2 0.1 19 Debt to Equity Ratio 382.2% 254.3% 328.8% 4022.3% 20 Days Cash on Hand 21 22 23 24 25 Q2 Ratio Calculations Q3 Summary and Analysis Q4 Common Size Fin Statement + Ready TX Accessibility: Investigate + 100% Type here to search O W 10:56 AM DEl 11/19/2022