s Springfield Community Hospital Statement of Operations (in thousands) for the Years Ended December 31, 20X1 and 20X0 Louisville Community Hospital Balance Sheet (in thousands) for the Years Ended December 31, 20X1 and 20X0 A Ratio[a] 20X1 Revenues Net patient service revenue Net assets released from restriction Total operating revenues Expenses Salaries and benefits Supplies and other expenses Depreciation General services Total operating expenses Operating income Non-operating income 20X0 20X1 Current assets Cash and cash equivalents Net patient receivables Inventory Total current assets Non-current assets Plant, property, and equipment Gross plant, property, and equipment (less accumulated depreciation) Net plant, property, and equipment Board-designated funds B D E F G 12/31/20X1 [D/E] 12/31/20X0 [F/G] 20X1 Numerator 20X1 Denominator 20X0 Numerator 20X0 Denominato (in '000) 20X0 Current Ratio Quick Ratio Acid Test Ratio Days in Accounts Receivable Days Cash on Hand Average Payment Period (Days) $5,250 $4,000 $500 $3,500 $9,500 $2,750 $2,750 $2,750 $2,750 $52 $41 $41 Operating Revenue per Adjusted Discharge Operating Expense per Adjusted Discharge Salary & Benefit Exp. as % of Operating Exp. Operating Margin Non-Operating Revenue Return on Total Assets Return on Net Assets $19,800 $17,100 $9,000 $2,700 $3,300 $5,200 $5,200 3.10 3.10 $17,100 $19,800 $19,800 $21,250 $10,500 Total Asset Turnover Ratio Fixed Asset Turnover Ratio Age of Plant Ratio $19,800 $19,800 $17,000 $21,250 $7,000 $2,000 Long-Term Debt to Net Assets Net Assets to Total Assets $8,000 $10,500 $10,500 $21,250 Total assets Excess of revenues over expenses Increase (decrease) in net assets Current liabilities Accounts payable Accrued expenses Total current liabilities Long-term liabilities Bonds payable Total long-term liabilities Net assets Total liabilities and net assets tor Healthcare Financial Management and Economics Week 8 Assignment 1 Springfield Community Hospital Assignment 1: Ratio Analysis It is important to understand that when interpreting financial statements, the numbers alone may not provide the whole financial picture of an organization. Instead, you must analyze the statements using ratios, which are then compared to benchmarks across the healthcare industry. For this Assignment, you examine the financial documents for Springfield Community Hospital and analyze the organization's financial health. Springfield Community Hospital Springfield Community Hospital is a small community hospital serving a rural population. The adjusted discharges are 3.30 for the 1st year and 3.10 for the 2nd. Springfield Community Hospital Statement of Operations (in thousands) for the 2016 Revenues Net patient service revenue $21,000 Net assets released from restriction 1,000 Total operating revenues 22,000 Expenses Salaries and benefits 12,000 Supplies and other expenses 6,000 Depreciation 2,300 General services 200 Total operating expenses 20,500 Operating income 1,500 Non-operating income 3,500 Excess of revenues over expenses 5,000 Increase (decrease) in net assets $5,000 Springfield Community Hospital Balance Sheet (in thousands) for the Current assets Cash and cash 2015 Laureate Education, Inc. 2017 $17,000 800 17,800 8,000 5,000 1,900 100 15,000 2,800 2,200 5,000 $5,000 2016 2017 $600 $400 Page 1 of 2 equivalents Net patient receivables Inventory Total current assets Non-current assets Plant, property, and equipment Gross plant, property, and equipment (less accumulated depreciation) Net plant, property, and equipment Board-designated funds Total assets Current liabilities Accounts payable Accrued expenses Total current liabilities Long-term liabilities Bonds payable Total long-term liabilities Net assets Total liabilities and net assets 4,000 900 5,500 3,500 800 5,250 25,000 23,000 (18,000) (17,000) 7,000 6,000 18,000 30,500 9,000 20,250 2,500 850 3,350 2,000 900 2,900 5,500 5,500 21,650 7,500 7,500 9,850 $30,500 $20,250 To prepare for this Assignment: Examine the financial statements from Springfield Community Hospital. Reflect on how you will use this financial data to calculate and analyze the organization's financial ratios. Refer to Chapter 4 of Financial Management of Health Care Organizations: An Introduction to Fundamental Tools, Concepts and Applications for additional guidance. The Assignment: Using the statement of operations and balance sheet for Springfield Community Hospital below, complete the \"Week 8 Assignment 1 Ratio Excel Template\". Your Assignment is due by Day 7 of Week 8. 2015 Laureate Education, Inc. Page 2 of 2