Using an Excel spreadsheet (to be submitted), perform the following tasks (hint: re-use Excel file already provided) Find the NPV and the IRR of the project using the pro forma financial statement method to determine cash flows. Set up the necessary equations by referencing to the input variable cells. The spreadsheet must be formula driven; do not put any numbers in cell equations, only cell references. Keep the spreadsheeted clean2.g. no color). Conduct a NPV sensitivity analysis to +/- 1% changes to i) the sale volume, ii) the price per unit, iii) the variable cost per unit, iv) the fixed costs and v) the hurdle rate to populate a table structured as follows: NPV with -1% of forecasted value Forecasted value NPV with +1% of forecasted value sale volume = 14,000 ? price per unit = 10,000 ? variable cost per unit = 7,800 ? fixed costs = 11,000,000 ? hurdle rate = 20% (-1% is 19.80%) ? Write a report to be submitted, up to one page of text maximum) summarizing your analytical findings (NPV and sensitivity analysis) and your recommendation (recommend to proceed or decline the project, and why) Using an Excel spreadsheet (to be submitted), perform the following tasks (hint: re-use Excel file already provided) Find the NPV and the IRR of the project using the pro forma financial statement method to determine cash flows. Set up the necessary equations by referencing to the input variable cells. The spreadsheet must be formula driven; do not put any numbers in cell equations, only cell references. Keep the spreadsheeted clean2.g. no color). Conduct a NPV sensitivity analysis to +/- 1% changes to i) the sale volume, ii) the price per unit, iii) the variable cost per unit, iv) the fixed costs and v) the hurdle rate to populate a table structured as follows: NPV with -1% of forecasted value Forecasted value NPV with +1% of forecasted value sale volume = 14,000 ? price per unit = 10,000 ? variable cost per unit = 7,800 ? fixed costs = 11,000,000 ? hurdle rate = 20% (-1% is 19.80%) ? Write a report to be submitted, up to one page of text maximum) summarizing your analytical findings (NPV and sensitivity analysis) and your recommendation (recommend to proceed or decline the project, and why)