please help me fill out this excel template. thank you.
Week 8 Assignment 1 Ratio Template A B D E F G (in '000) 12/31/18 12/31/19 2018 2018 2019 2019 Ratiolal [D/E] [F/G] Numerator Denominator Numerator Denominator Current Ratio Quick Ratio Acid Test Ratio Days in Accounts Receivable Days Cash on Hand Average Payment Period (Days) 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 Total Asset Turnover Ratio Fixed Asset Tumover Ratio Age of Plant Ratio Long-Term Debt to Net Assets Net Assets to Total AssetsHealthcare Financial Management and Economics Week 8 Assignment 1 - Jackson 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 Jackson Community Hospital and analyze the organization's financial health. Jackson Community Hospital Jackson Community Hospital is a small community hospital serving a rural population. The adjusted discharges are 3.30 for the 1* year and 3.10 for the 2nd. Jackson Community Hospital Statement of Operations (in thousands) for the Years Ended December 31, 2018 and 2019 2018 2019 Revenues Net patient service revenue $22,000 $19,000 Net assets released from restriction 1,000 800 Total operating revenues 23,000 19,800 Expenses Salaries and benefits 11,000 8,000 Supplies and other expenses 7,000 6,000 Depreciation 2,500 2,100 General services 300 520 Total operating expenses 20,800 16,620 Operating income 1,250 4,200 Non-operating income 3,500 2,200 Excess of revenues over expenses 4,750 6,400 Increase (decrease) in net assets $4,750 $6,400 @ 2020 Laureate Education, Inc. Page 1 of 3Jackson Community Hospital Balance Sheet (in thousands) for the Years Ended December 31, 2018 and 2019 2016 2017 Current assets Cash and cash equivalents $600 $400 Net patient receivables 4,000 3,500 Inventory 1,000 900 Total current assets 5,600 4,800 Non-current assets Plant, property, and equipment Gross plant, property, and 25,000 23,000 equipment (less accumulated depreciation) (18,000) (17,000) Net plant, property, and 7,000 6,000 equipment Board-designated funds 19,000 10,000 Total assets 31,600 20,800 Current liabilities Accounts payable 2,600 2,100 Accrued expenses 850 900 Total current liabilities 3,450 3,000 Long-term liabilities Bonds payable 5,600 7,150 Total long-term liabilities 5,600 7,150 Net assets 22,550 10,650 Total liabilities and net assets $31,600 $20,800 To prepare for this Assignment: Examine the financial statements from Jackson Community Hospital. Reflect on how you will use this financial data to calculate and analyze the organization's financial ratios. Refer to Chapter 13 of Gapinski's Understanding Healthcare Financial Management for additional guidance. @ 2020 Laureate Education, Inc. Page 2 of 3
