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 South Shore Community Hospital and analyze the organization$$s financial health. South Shore Community Hospital South Shore Community Hospital is a small community hospital serving a rural population. The adjusted discharges are $3\mathrm{.}30$for the $1$st year and $3\mathrm{.}10$for the $2$nd $.$North Shore Community Hospital Statement of Operations $($in thousands$)$for the Years Ended December $31,2022$and $202320222023$Revenues Net patient service revenue $$23,000$$$22,500$Net assets released from restriction $1,000800$Total operating revenues $24,00023,300$Expenses Salaries and benefits $10,5009,000$Supplies and other expenses $7,0005,000$Depreciation $3,5002,500$General services $300520$Total operating expenses $21,30017,020$Operating income $4,5201,200$Non$-$operating income $3,5002,200$Excess of revenues over expenses $8,0203,400$Increase $($decrease$)$in net assets $$8,020$$$3,400$South Shore Community Hospital Balance Sheet $($in thousands$)$for the Years Ended December $31,2022$and $202320222023$Current assets Cash and cash equivalents $$1,100$$$800$Net patient receivables $4,2003,500$Inventory $1,2001,100$Total current assets $6,5005,400$Non$-$current assets Plant, property, and equipment Gross plant, property, and equipment $35,00032,000($less accumulated depreciation$)(18,000)(17,000)$Net plant, property, and equipment $17,00015,000$Board$-$designated funds $19,00010,000$Total assets $42,50030,400$Current liabilities Accounts payable $3,5003,400$Accrued expenses $850900$Total current liabilities $4,3504,300$Long$-$term liabilities Bonds payable $6,5006,550$Total long$-$term liabilities $6,5006,550$Net assets $31,65019,550$Total liabilities and net assets $$42,500$$$30,400.$

Complete the Assignment using a ratio analysis excel spreadsheet as under

A

B

D

E

F

G

$($in $\text{'}000)$