Hello, I really need help with this excel spreadsheet.
Hello, I really need help with this excel spreadsheet. I have attached both documents.
Healthcare Financial Management and EconomicsWeek 8 Assignment 1 — Louisville Community HospitalAssignment 1: Ratio AnalysisIt is important to understand that when interpreting financial statements, the numbersalone may not provide the whole financial picture of an organization. Instead, you mustanalyze the statements using ratios, which are then compared to benchmarks acrossthe healthcare industry. For this Assignment, you examine the financial documents forLouisville Community Hospital and analyze the organization’s financial health.Louisville Community HospitalLouisville Community Hospital is a small community hospital serving a rural population.Louisville Community HospitalStatement of Operations (in thousands) for theYears Ended December 31, 2016 and 201720162017RevenuesNet patient service revenue$23,000$19,000Net assets released from restriction1,000800Total operating revenues24,00019,800ExpensesSalaries and benefits13,0009,000Supplies and other expenses7,0006,000Depreciation2,5002,000General services200100Total operating expenses22,70017,100Operating income1,3002,700Non-operating income4,0002,500Excess of revenues over expenses5,3005,200Increase (decrease) in net assets$5,300$5,200Louisville Community HospitalBalance Sheet (in thousands)for the Years Ended December 31, 2016 and 2017© 2015 Laureate Education, Inc.Page 1 of 2
20162017Current assetsCash and cashequivalents$700$500Net patient receivables4,0003,500Inventory950750Total current assets5,6505,250Non-current assetsPlant, property, andequipmentGross plant, property,and equipment26,50024,000(less accumulateddepreciation)(18,000)(17,000)Net plant, property, andequipment8,5007,000Board-designated funds18,0009,000Total assets32,15021,250Current liabilitiesAccounts payable2,5002,000Accrued expenses900750Total current liabilities3,4002,750Long-term liabilitiesBonds payable6,5008,000Total long-term liabilities6,5008,000Net assets22,25010,500Total liabilities and netassets$32,150$21,250To prepare for this Assignment:Examine the financial statements from Louisville Community Hospital. Reflect on howyou will use this financial data to calculate and analyze the organization’s financialratios. Refer to Chapter 4 ofFinancial Management of Health Care Organizations: AnIntroduction to Fundamental Tools, Concepts and Applicationsfor 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 byDay 7 of Week 8.© 2015 Laureate Education, Inc.Page 2 of 2
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
