Challenge You have been hired as a consultant to advise Heru Resources on the opening of a new mine. The attached spreadsheet should be used to calculate the projections based on the details of the case. There are two sets of financials, side by side, so you can give a comparison using different variable. You can manipulate the information in the green input cells to adjust projections to the income statement. You will need to create formulas to calculate the NPV and IRR calculations. The sheet is not protected, so you can see the formulas. Use the spreadsheet and any other resources you would like to complete the following: 1. What is the NPV and IRR of the base scenario? (10 points) 2. Which scenario is a better financial decision for the company; pay a higher opening cost and lower operating expenses, or pay a lower opening and higher operating costs? (10 Points) 3. Looking at the base scenario, at what discount rate is the project feasible? What information did you use to determine the rate? (10 Points) 4. Open the Best Case Scenario, and Worst Case Scenario tabs on this sheet. Complete the spreadsheet using information from the case to complete each. How does each scenario effect the decision to open the mine? What factor makes the biggest impact on the financial Analysis? (10 Points) 5. Given your analysis, would you choose to open the mine? Why or why not? (10 Points)