Hello,

I really need help with this excel spreadsheet. I have attached both documents.

Healthcare Financial Management and Economics Week 8 Assignment 1 Louisville 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 Louisville Community Hospital and analyze the organization's financial health. Louisville Community Hospital Louisville Community Hospital is a small community hospital serving a rural population. Louisville Community Hospital Statement of Operations (in thousands) for the Years Ended December 31, 2016 and 2017 2016 2017 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 $23,00 0 1,000 24,000 13,000 7,000 2,500 200 22,700 1,300 4,000 5,300 $5,300 $19,000 800 19,800 9,000 6,000 2,000 100 17,100 2,700 2,500 5,200 $5,200 Louisville Community Hospital Balance Sheet (in thousands) for the Years Ended December 31, 2016 and 2017 2015 Laureate Education, Inc. Page 1 of 2 2016 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 2017 $700 $500 4,000 950 5,650 3,500 750 5,250 26,500 24,000 (18,000) (17,000) 8,500 7,000 18,000 32,150 9,000 21,250 2,500 900 3,400 2,000 750 2,750 6,500 6,500 22,250 8,000 8,000 10,500 $32,150 $21,250 To prepare for this Assignment: Examine the financial statements from Louisville 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 Louisville Community Hospital, complete the Week 8 Ratio Excel Template located in the Week 8 Learning Resources. Your Assignment is due by Day 7 of Week 8. 2015 Laureate Education, Inc. Page 2 of 2 Week 8 Ratio Template A B 12/31/20X1 [D/E] 12/31/20X0 [F/G] D E F G (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 20X1 20X1 Numerator Denominator 20X0 20X0 Numerator Denominator