The following table provides the income statement and balance sheet for Simpson Community hospital (amounts in 000s).
Fantastic news! We've Found the answer you've been seeking!
Question:
The following table provides the income statement and balance sheet for Simpson Community hospital (amounts in 000s).
Complete the ratio worksheet. Explain the change in the ratios that increased or decreased 10% or more from the prior year.
Revenue | For the December 31, 2021 | Year Ending December 31, 2022 | Assets | For the December 31, 2021 | Year Ending December 31, 2022 |
Net Patient Service Revenue | $95,000 | $98,000 | Current Assets | ||
Total Operating Revenue | $95,000 | $98,000 | Cash and Cash Equivalents | $5,000 | $6,000 |
Accounts Receivable (net) | 18,000 | 18,500 | |||
Operating Expenses | Inventories | 12,000 | 13,000 | ||
Salaries and wages | $56,000 | $57,900 | Prepaid insurance | 2,000 | 2,100 |
Fringe Benefits | 12,000 | 12,900 | Total Current Assets | $37,000 | $39,600 |
Supplies | 10,000 | 10,500 | Property, Plant, and Equipment | ||
Depreciations | 5,000 | 5,100 | Equipment (net) | $20,000 | $21,000 |
Interest | 2,000 | 1,900 | Buildings (net) | 40,000 | 41,000 |
Other | 6,000 | 6,300 | Land | 5,000 | 5,000 |
Total Operating Expenses | $91,000 | $94,600 | Net Property, Plant, and Equipment | $65,000 | $67,000 |
Investments | $4,000 | $3,500 | |||
Income from Operations | $4,000 | $3,400 | Total Assets | $106,000 | $110,000 |
Nonoperating Gains/ Losses | Liabilities | ||||
Investment Income | $500 | $700 | Current Liabilities | ||
Net Nonoperating Gains | $500 | $700 | Current maturities of LT Debt | $3,000 | $3,100 |
Accounts payable | 5,500 | 5,300 | |||
Net income | $4,500 | $4,100 | Total Current Liabilities | $8,500 | $8,400 |
Long-Term Debt | $50,000 | $51,000 | |||
Less Current maturities of long-term debt | -3,000 | -3,100 | |||
Net Long-term debt | $47,000 | $47,900 | |||
Total Liabilities | $55,500 | $56,300 | |||
Net Worth | $50,500 | $53,800 | |||
Profitability | Dec. 31, 2021 | Dec. 31, 2022 | |||
Operating Margin | ? | ? | |||
Total Margin | ? | ? | |||
ROA | ? | ? | |||
ROE | ? | ? | |||
Liquidity | |||||
Current Ratio | ? | ? | |||
Days Cash on Hand | ? | ? | |||
Days in Accounts Receivable | ? | ? | |||
Capital Structure | |||||
Times interest earned | ? | ? | |||
Debt service coverage | ? | ? | |||
Equity financing | ? | ? | |||
Turnover | |||||
total Asset Turnover | ? | ? | |||
Current Asset Turnover | ? | ? | |||
Fixed Asset Turnover | ? | ? |
Related Book For
Financial Accounting
ISBN: 9780078110825
2nd Edition
Authors: J. David Spiceland, Wayne Thomas, Don Herrmann
Posted Date: