Please help with this assignment. See attached the assignment and the excel template

______________INSERT Organization Name Statement of Operations (in thousands) for the Years Ended December 31, 20X1 and 20X0 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 Excess of revenues over expenses Increase (decrease) in net assets 20X0 ______________INSERT Organization Name Balance Sheet (in thousands) for the Years Ended December 31, 20X1 and 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 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 20X0 Answers A B D 12/31/20X1 [D/E] 12/31/20X0 [F/G] 20X1 Numerator (in '000) Ratio[a] 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 Turnover Ratio Age of Plant Ratio Long-Term Debt to Net Assets Net Assets to Total Assets E F G 20X1 Denominator 20X0 Numerator 20X0 Denominator Healthcare Financial Management and Economics Week 8 Assignment 1 Franklin 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 Franklin Community Hospital and analyze the organization's financial health. Franklin Community Hospital Franklin 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. Franklin Community Hospital Statement of Operations (in thousands) for the Years Ended December 31, 2016 and 2017 2016 Revenues Net patient service revenue $22,000 Net assets released from restriction 1,000 Total operating revenues 23,000 Expenses Salaries and benefits 11,000 Supplies and other expenses 7,000 Depreciation 2,500 General services 300 Total operating expenses 20,800 Operating income 1,250 Non-operating income 3,500 Excess of revenues over expenses 4,750 Increase (decrease) in net assets $4,750 Franklin Community Hospital Balance Sheet (in thousands) for the Current assets Cash and cash 2015 Laureate Education, Inc. 2017 $19,000 800 19,800 8,000 6,000 2,100 520 16,620 4,200 2,200 6,400 $6,400 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 1,000 5,600 3,500 900 4,800 25,000 23,000 (18,000) (17,000) 7,000 6,000 19,000 31,600 10,000 21,250 2,600 850 3,450 2,100 900 3,000 5,600 5,600 22,550 7,600 7,600 10,650 $31,600 $21,250 To prepare for this Assignment: Examine the financial statements from Franklin 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 Franklin 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