Top Tutors
The team is composed solely of exceptionally skilled graduate writers, each possessing specialized knowledge in specific subject areas and extensive expertise in academic writing.
Order for this Paper or Similar Assignment Writing Help
Click to fill the order details form in a few minute.
Posted: May 15th, 2024
Module 6 Assignment: Traditional Project Analysis
Module 6 Assignment: Traditional Project Analysis
CASE 20: CORAL BAY HOSPITAL
Directions: Fully answer each question regarding Case 20: Coral Bay Hospital.
1. What are the NPV, IRR, MIRR, and payback of the proposed ambulatory surgery center? Do the measures indicate acceptance or rejection of the proposed ambulatory surgery center?
2. Inflation is one of the most difficult factors to deal with in project analysis. Complete the inflation impact table shown in exhibit 20.2 (Hint: see Note at end of document for What-If analysis. What management information is provided by the inflation impact table?
3. Perform a sensitivity analysis by computing the impact of an increase (10%, 20% and 30%) and decrease (10%, 20% and 30%) on three variables (Number of Procedures, Avg Revenue per Procedure and Bldg/Equip Salvage Value) on the NPV. Plot the results. What management information is provided by the sensitivity analysis?
4. Perform a scenario analysis by computing NPV in different scenarios assuming the values given in the Excel file. What management information is provided by the scenario analysis? Why is the expected NPV obtained in the scenario analysis different from the base case NPV?
5. A board member is interested in the utilization breakeven of the Center. What are the breakeven values of the three input variables (Number of Procedures, Avg Revenue per Procedure and Bldg/Equip Salvage Value) that are highly uncertain? (Hint: you can change the values of these variables to see when NPV changes to zero or you can use What-if Analysis/Goal Seek) What management information is provided by the breakeven analysis?
6. Jules is aware that some qualitative factors are relevant to the surgery center decision.
a. What qualitative factors might support project acceptance?
b. What qualitative factors might preclude project acceptance?
c. Can you think of any costs that might be associated with the project that have not been included in the analysis?
d. Are there any potential benefits that have not been included?
e. What additional data would you seek from other hospital staff members to conduct a more thorough analysis?
7. Considering all points, would you build the ambulatory surgery center?
Note:
The What-If Analysis in Excel can be used to produce a table that shows the impact of inflation on the project’s NPV. Here are the steps:
– In cell H25, enter “=F25”
– In cells I25 to O25, enter 0%, 1%, 2%, 3%, 4%, 5% and 6%, respectively
– In cells H26 to H32, enter 0%, 1%, 2%, 3%, 4%, 5% and 6%, respectively
– Highlight cells H25 to O32
– Click on What-If Analysis and then Data Table
– Row Input Cell: D35
– Column Input Cell: D36
– Click OK
(Hint: Check to make sure that when column and row values are both 3%, it should give you the NPV value in Cell F25, which is the base case value. Also remember 1% = 0.01)
Why Choose our Custom Writing Services
We prioritize delivering top quality work sought by students.
Discounted Pricing
Our writing services uphold the utmost quality standards while remaining budget-friendly for students. Our pricing is not only equitable but also competitive in comparison to other writing services available.
0% similarity Index
Guaranteed Plagiarism-Free Content: We assure you that every product you receive is entirely free from plagiarism. Prior to delivery, we meticulously scan each final draft to ensure its originality and authenticity for our valued customers.
How it works
When you decide to place an order with HomeworkAceTutors, here is what happens:
Expert paper writers are just a few clicks away
Place an order in 3 easy steps. Takes less than 5 mins.