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 ~ 12 ~ A" A Insert Arial al Wrap Text General Ex AY O x Delete Paste Cell Merge & Center $ ~ % 9 08 40 Conditional Format as Sort & Find & Analyze Formatting Table Styles Format Filter ~ Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis J4 X v fx Analysis: What stands out; what should be investigated further C D E F G H K M N O P Q - W N Analysis: What stands out; what should be investigated further Pima Medical Center Tucson Regional 2019 2020 2021 2021 7 Revenues 100.0% 100.0% 100.0% 100.0% 100 Salaries and Benefits 23,560 23,874 26,779 5.411 10 Supplies 8,481 8,369 9.481 1,963 11 Other Operating Expenses 9,481 9,307 9,96 2,857 12 Depreciation/Amortization 2,596 2,721 2,853 458 13 Interest Expense 1,824 1,584 1,566 1,031 14 Total Operating Expenses 45,942 45,855 50,640 11,720 15 Operating Income 5,394 5,678 8, 112 69 16 Income Taxes 1,099 1,043 2, 112 14 17 Net Income 4,295 4,635 6,000 55 18 19 20 2010 2020 2021 ... Q3 Summary and Analysis Hospital Financial Statements Q4 Common Size Fin Statement + Ready Accessibility: Investigate + 80% Type here to search O M W 4:48 PM Rain... ~ EGG 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 Insert Arial ~ 12 ~ A" A al Wrap Text General Ex AY O Ex Delete Paste Conditional Format as Cell Sort & Find & Analyze E Merge & Center $ ~ % 9 08 20 Formatting " Table Styles Format Filter ~ Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis J4 X V Analysis: What stands out; what should be investigated further C D G H K M N P Q 21 2019 2020 2021 2021 22 Assets 23 Cash 1.4% 3.9% 2.9% 11.9% 24 Short-Term Investments 147 116 103 25 Accounts Receivables, Net 7,333 7,159 8,095 1,927 26 Inventories 1,849 2,025 1,986 335 27 Other Current Assets 1, 190 1,340 1,896 519 28 Total Current Assets 10,519 10,640 12,080 2,781 29 30 Net Property, Plant & Equipment 24,549 25,223 26, 176 5,322 31 Long-Term Note Receivable 37 31 44 59 32 Intangible Assets 8,269 8,578 9.540 4,219 33 Total Assets 100.0% 100.0% 100.0% 100.0% 34 35 Liabilities & Shareholders' Equity 36 Accounts Payable 2,357 2,581 2,842 383 37 Short Term Debt 145 209 237 980 38 Current Portion of Long Term Debt 4,905 5,535 6,111 533 39 Other Current Liabilities 2,303 2,267 2,461 150 Q3 Summary and Analysis Hospital Financial Statements Q4 Common Size Fin Statement (+ Ready Ex Accessibility: Investigate + 80% 4:50 PM Type here to search O W Rain... 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 Arial ~ 12 ~ A" A Insert al Wrap Text General Ex AY O Ex Delete Paste E Conditional Format as Cell Analyze Merge & Center $ ~ % 9 08 20 Sort & Find & Formatting " Table Styles Format Filter ~ Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis J4 X v fx Analysis: What stands out; what should be investigated further C D E F G H K M N P Q 34 35 Liabilities & Shareholders' Equity 36 Accounts Payable 2,357 2,581 2,842 383 37 Short Term Debt 145 209 237 980 38 Current Portion of Long Term Debt 4,905 5,535 6, 111 533 39 Other Current Liabilities 2,303 2,267 2,461 150 40 Accrued Payroll 2,054 2,314 2,381 637 41 Total Current Liabilities 11,764 12,906 14,032 2,683 42 Long-Term Debt 23, 107 20,301 23,765 11,033 43 Total Liabilities 34,871 33,207 37,797 13,716 44 45 46 Total Shareholders' Equity (34,870) (33,206) (37,796 (13,715 47 48 Liabilities & Shareholders' Equity 100.0% 100.0% 100.0% 100.0% 49 50 51 52 53 Q3 Summary and Analysis Hospital Financial Statements Q4 Common Size Fin Statement + : 4 Ready x Accessibility: Investigate + 80% O W 4:50 PM Type here to search Rain... 11/19/2022