3. Construct a comparative ratio analysis worksheet.

1) Calculate the following ratios for both years' data, using the "Move or Copy" function and the "Copy" and "Paste" function.

2) Create worksheet as "Compare with Standard", which calls the value from "Ratio Analysis" sheets with hospital 20X1 and 20X0 financial ratios. Then, place the ratio values in a separate column to compare them.

3) Discuss this hospital's current financial position and future outlook based upon these results and the industry standard. (You have to have the following columns: Desired Position, Current Year Position, Trend Position, and Possible Explanation Current Year Relative to Standards).

KFC+B5:J50 Hospital Statement of Operations		KFC Hospital Balance Sheet
for Years Ended December 31, 20X1 and 20X0		for Years Ended December 31, 20X1 and 20X0
	12/31/20X1		12/31/20X0			12/31/20X1		12/31/20X0
Operating revenues					Assets
Net patient revenues	$10,778,272		$10,566,176		Current assets
Other operating revenues	233,749		253,517		Cash and marketable securities	$363,181		$158,458
Total operating revenues	11,012,021		10,819,693		Patient accounts receivables
					net of uncollectible accounts	1,541,244		1,400,013
Operating expenses					Inventories	346,176		316,875
Salaries and benefits	5,644,880		5,345,498		Prepaid expenses	163,734		78,788
Supplies	1,660,000		1,529,680		Other current assets	100,000		0
Insurance	1,536,357		1,551,579		Total current assets	2,514,335		1,954,134
Depreciation and amortization	383,493		420,238
Interest	500,000		276,379		Non-current assets
Bad debt	456,289		365,678		Gross plant, property, and equipment	7,088,495		6,893,370
Other	500,093		276,455		(less accumulated depreciation)	(2,781,741)		(2,398,248)
Total operating expenses	10,681,112		9,765,507		Net plant, property, and equipment	4,306,754		4,495,122
Operating income	330,909		1,054,186		Long-term investments	3,414,732		4,525,476
Non-operating revenue	185,000		165,000		Other assets	640,915		340,853
Excess of revenues over expenses	515,909		1,219,186		Total non-current assets	8,362,401		9,361,451
Increase (decrease) in					Total assets	$10,876,736		$11,315,585
unrestricted net assets	$515,909		$1,219,186
					Liabilities and net assets
					Current liabilities
					Accounts payable	$387,646		$166,600
					Salaries payable	135,512		529,298
					Notes payable	500,000		2,359,524
					Current portion of long-term debt	372,032		338,996
					Total current liabilities	1,395,190		3,394,418
					Long-term liabilities
					Bonds payable	6,938,891		6,009,484
					Total long-term liabilities	6,938,891		6,009,484
					Total liabilities	8,334,081		9,403,902
					Net assets
					Unrestricted	1,901,739		1,570,830
					Temporary restricted	328,000		40,853
					Permanently restricted	312,916		300,000
					Total net assets	2,542,655		1,911,683
					Total liabilities and net assets	$10,876,736		$11,315,585