I need assistance with the input values for the merger analysis in the spreadsheet. It requires input data that is not part of the historical data. Case # 23 St. Benedict's Teaching Hospital from the text Cases In Healthcare Finance fifth edition.

Thank you

CASE23 Inpatient revenue Outpatient revenue Net patient service revenue Nonoperating revenue Total revenues Patient services expenses Interest expense Depreciation Total expenses Net income 2009 $42.472 28.314 $70.786 1.922 $72.708 $60.245 3.045 3.466 $66.756 2010 $46.014 30.676 $76.690 1.515 $78.205 $73.858 3.147 3.689 $80.694 2011 $53.410 35.606 $89.016 1.367 $90.383 $81.525 3.093 4.395 $89.013 2012 $58.650 39.100 $97.750 1.725 $99.475 $90.645 3.002 4.258 $97.905 $5.952 ($2.489) $1.370 $1.570 Page 1 CASE23 2013 $59.513 39.675 $99.188 1.048 $100.236 $89.505 2.980 6.031 $98.516 $1.720 Page 2