ambulatory surgery center

Feeling Stressed About Your Essay?

Get professional help in 5 minutes

WhatsApp Order Now

ambulatory surgery center

ambulatory surgery center.  Download the Case 20 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.

Try to write an academic paper with us
Click order now button to get the answer for your question
We guarantee professional assistance in completing papers of all academic levels and subjects.
Order Now

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?

[HINT: Think about the incremental cash flow, which is the difference between the cash flow with the project and cash flow without the project.]

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.

[HINT: For each input– number of procedures, average revenue per procedure, and building/equipment salvage value– use the spreadsheet to determine the NPV when the specific input changes by -30%, -20%, -10%, … 30%. Create a graph of the NPV versus percent change from the base case for each input (i.e. you should have three lines).]

b. What management information is provided by the sensitivity analysis?

 

ambulatory surgery center

Download the Case 20 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?

[HINT: Think about the incremental cash flow, which is the difference between the cash flow with the project and cash flow without the project.]

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.

[HINT: For each input– number of procedures, average revenue per procedure, and building/equipment salvage value– use the spreadsheet to determine the NPV when the specific input changes by -30%, -20%, -10%, … 30%. Create a graph of the NPV versus percent change from the base case for each input (i.e. you should have three lines).]

b. What management information is provided by the sensitivity analysis?

 

Feeling Stressed About Your Essay?

Get professional help in 5 minutes

WhatsApp Order Now