AutoSave OFF A ? CE ... HCA230_Project_Part_3 Revised 0822 (6) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial v 12 AA = ap Wrap Text v Number LIX V V Paste BIUVV DVAv E Merge & Center v $ ~ % 9 Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data C10 4 X V fx 9481 A B C D E F G H K L M N 0 3 Financial Statements Income Statements Pima Medical Center Tucson Regional 2019 2020 2021 2021 Revenues $51,336 $51,533 58,752 11,789 Salaries and Benefits 23,560 23,874 26,779 5,411 Supplies 8,481 8,369 9,481 1,963 Other Operating Expenses 9,481_ 9,307 9,961 2,857 11 Depreciation/Amortization 2,596 2,721 2,853 458 12 Interest Expense 1,824 1,584 1,566 1,031 Total Operating Expenses 5,942 45,855 50,640 11,720 Operating Income 5,394 5,678 8,112 69 15 Income Taxes 1,099 1,043 2,112 14 16 Net Income 4,295 4,635 6,000 55 17 18 19 20 Note: Amounts in 1,000s of dollars 21 22 Balance Sheets 23 2019 2020 2021 2021 24 Assets 25 Cash 621 1,793 1,451 1,676 26 Short-Term Investments 147 116 103 27 Accounts Receivables, Net 7,333 7,159 8,095 1,927 28 Inventories 1,849 2,025 1,986 335 29 Other Current Assets 1,190 1,340 1,896 519 Total Current Assets 11,140 12,433 13,531 4,457 31 Net Property, Plant & Equipment 24,549 25,223 26,176 5.32 Long-Term Note Receivable 37 31 44 59 Intangible Assets 8,269 8,578 9,54 4,219 Total Assets 43,995 46,265 49,291 14,057 Liabilities & Shareholders' Equity 38 Accounts Payable 2,357 2,581 2,842 383 39 Short Term Debt 145 209 237 980 Current Portion of Long Term Debt 4,905 6,535 6,111 533 Other Current Liabilities 2,303 2,267 2,461 150 42 Accrued Payrol 2,054 2.314 2.381 637 Total Current Liabilities 11,764 12,906 14,032 2,683 44 Long-Term Debt 23, 107 20,301 23,765 11,033 45 Total Liabilities 34,871 33,207 37,797 13,716 46 D Instructions Ratio List Hospital Financial Statements Q1 ID Financial Stmts Needed Q2 Ratio Calculations Q3 Summary and Analysis Q4 Common Size Fin Statement + Ready iT Accessibility: Investigate + 100%AutoSave OFF A ? CE ... HCA230_Project_Part_3 Revised 0822 (6) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial v 12 AA = ap Wrap Text v Number LIX V V Paste BIUVV DVAv E Merge & Center v $ ~ % 9 Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data C10 4 X V fx 9481 A B C D E F G H K L M N 0 3 Financial Statements Income Statements Pima Medical Center Tucson Regional 2019 2020 2021 2021 Revenues $51,336 $51,533 58,752 11,789 Salaries and Benefits 23,560 23,874 26,779 5,411 Supplies 8,481 8,369 9,481 1,963 Other Operating Expenses 9,481_ 9,307 9,961 2,857 11 Depreciation/Amortization 2,596 2,721 2,853 458 12 Interest Expense 1,824 1,584 1,566 1,031 Total Operating Expenses 5,942 45,855 50,640 11,720 Operating Income 5,394 5,678 8,112 69 15 Income Taxes 1,099 1,043 2,112 14 16 Net Income 4,295 4,635 6,000 55 17 18 19 20 Note: Amounts in 1,000s of dollars 21 22 Balance Sheets 23 2019 2020 2021 2021 24 Assets 25 Cash 621 1,793 1,451 1,676 26 Short-Term Investments 147 116 103 27 Accounts Receivables, Net 7,333 7,159 8,095 1,927 28 Inventories 1,849 2,025 1,986 335 29 Other Current Assets 1,190 1,340 1,896 519 Total Current Assets 11,140 12,433 13,531 4,457 31 Net Property, Plant & Equipment 24,549 25,223 26,176 5.32 Long-Term Note Receivable 37 31 44 59 Intangible Assets 8,269 8,578 9,54 4,219 Total Assets 43,995 46,265 49,291 14,057 Liabilities & Shareholders' Equity 38 Accounts Payable 2,357 2,581 2,842 383 39 Short Term Debt 145 209 237 980 Current Portion of Long Term Debt 4,905 6,535 6,111 533 Other Current Liabilities 2,303 2,267 2,461 150 42 Accrued Payrol 2,054 2.314 2.381 637 Total Current Liabilities 11,764 12,906 14,032 2,683 44 Long-Term Debt 23, 107 20,301 23,765 11,033 45 Total Liabilities 34,871 33,207 37,797 13,716 46 D Instructions Ratio List Hospital Financial Statements Q1 ID Financial Stmts Needed Q2 Ratio Calculations Q3 Summary and Analysis Q4 Common Size Fin Statement + Ready iT Accessibility: Investigate + 100%