Week 7 - Assignment 1: Perform Scenario Analysis Instructions In a project to purchase a surgical robot, NCU AMC has asked you to conduct an analysis to determine the impact that the number of cases has on NPV. Given a 12% cost of capital and the following information: Table 6. Example Data Most Likely Worst Case Best Case Year # of case 1 Prob.= 25 # of cases 2 Prob. =.50 # of case 3 Prob.= 25 0 ($2,000,000) ($2.000.000) ($2,000,000) 1 $750,000 $1,300.000 $1,500,000 2 $1,600.000 $1,800,000 $1,900,000 3 $1.100.000 $1.000.000 $1,200,000 Create an Excel workbook with two tabs in which you answer/solve the following (be sure to label tabs accordingly): 1. What is the project's expected NPV on the basis of scenario analysis? 2. What is the project's standard deviation of NPV? Length: One Excel Workbook