Assignment:
Coral Bay Hospital
Download the Case excel spreadsheet from here.This spreadsheet contains a model that will assist you in answering the following questions. You should replace the cells in red with the "appropriate" numbers, which may depend on your assumptions.
1. Fill out the "Input Data" section in the spreadsheet to answer:
a. What are the NPV, IRR, MIRR, and payback of the proposed ambulatory surgery center?
b. Do the measures indicate acceptance or rejection of the proposed ambulatory surgery center?
2. One board member wants to make sure that a complete risk analysis, including sensitivity and scenario analyses is performed before the proposal is sent to the board.
a. Perform a sensitivity analysis.
b. What management information is provided by the sensitivity analysis?
Attachment:- Case-Coral Bay Hospital.rar