CASE 30 ST. BENEDICT’S TEACHING HOSPITAL Merger Analysis. ***EXCEL SHEET***

Use the data contained in the case to estimate the postmerger cash flows for 2018 through 2022 assuming that Lafayette General Hospital is acquired by St. Benedict’s Teaching Hospital. You have very limited data on which to base your forecasts. The key is to make supportable assumptions about the potential synergies that can be obtained from the merger.The attached documents are just to support you in completing the excel sheet.