Worksheet Title How To Use Ratio List Reference for answering questions Hospital Financial Statements Reference for answering questions Q1 ID Financial Statements Needed dentify which financial statements are needed. Use the drop-down menu to make selections. Q2 Ratio Calculations Calculate the ratios provided using the data on the Hospital Financial Statement tab and your answers to Q1. Q3 Summary and Analysis Review the summary to ensure that your work automatically transferred to this sheet. Make quantitative and qualitative comments. What is the trend? Is it good or bad? How is Pima Medical Center doing compared to Tucson Regional? Q4 Common Size Financial Statements Prepare a common size income statement and balance sheet. Make quantitative and qualitative comments. What is the trend? Is it good or bad? How is Pima Medical Center doing compared to Tucson Regional? Hospital Financial Statements 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 5411 Supplies 8.48 8,369 9.481 1,963 Other Operating Expenses 9.481 9.307 9,96 2 857 Depreciation Amortization 2,596 2 72 2,853 458 Interest Expense 1.824 1.584 1.566 1.031 Total Operating Expenses 45.942 15 855 50 640 11 720 Operating Income 5,394 5.678 8 112 69 Income Taxes 1.099 1.043 2.112 14 Net Income 4,295 1 635 6,000 56 "Note Amounts in 1,000s of dollars Balance Sheets 2019 2020 2021 2021 Assets Cash 621 1,793 1,451 1.676 Short-Term Investments 147 116 103 Accounts Receivables, Net 7,333 7,159 8,095 1,927 Inventories 1.849 2 025 1,986 335 Other Current Assets 1,190 1 340 1,896 519 Total Current Assets 11,140 12,433 13,531 4 457 Net Property, Plant & Equipment 24,549 25.223 26.176 6.322 Long-Term Note Receivable 37 31 59 Intangible Assets 8,269 8.578 9,540 4 219 Total Assets 13,995 46.265 49,291 14 057 Liabilities & Shareholders' Equity Accounts Payable 2.357 2 581 2,842 383 Short Term Debt 145 209 237 980 Current Portion of Long Term Debt 4,905 5.535 6,111 533 Other Current Liabilities 2 303 2 267 2461 150 Accrued Payroll 2,054 2,314 2,381 6:37 Total Current Liabilities 11,764 12,906 14,032 2,683 Long-Term Debt 23, 107 20 301 23, 765 11,033 Total Liabilities 34,871 33,207 37,797 13,718 Total Shareholders' Equity 9. 124 13,058 11,494 341 Liabilities & Shareholders' Equity 13.995 46.265 49 291 14 057 Calculate the given 15 Ratios for BOTH hospitals. Ratio Name Procedure Step 1. Write the formula Explain what the formula means Acid Test Ratio Pima Medical Center Tucson Regional Procedure Stop FY2019 FY2020 FY2021 FY2021 2. Use excel formulas to do the calculation 3 Format the answer Ratio Name Procedure Step 1. Write the formula Explain what the formula means Profit Margin Pima Medical Center Procedure Step FY2019 Tucson Regional FY2020 FY2021 FY2021 2 Use excel formulas to do the calculation 3 Format the answer Ratio Name Procedure Step 1: Write the formula Explain what the formula means Operating Margin Pima Medical Center Tucson Regional Procedure Step FY2019 FY2020 FY202 FY2021 Use excel formulas to do the calculation 3. Format the
