the feedback from my professor was "Scenario Summary Tab: Your approach is incorrect. You were expected to recalculate NPV and IRRin Basic Analysisseparately for each set of electricity prices and sales volume and then copy values into the summary tables." I have attached pictures of both the Basic Analysis tab in my assignment and the two Scenario Summary tabs - I cannot figure out how to calculate the NPV or IRR. The professors guidance is not very clear to me. Any assistance is greatly appreciated.

I've attached the pertinent information from the basic analysis tab included my original calculation for the electricity price per year and the electricity cost per unit. The Electricity Scenario Summary tab and the Sales Scenario summary tab are also attached. I am unsure as to what i should be doing to find the NPV and IRR on each.

This is for my FIN 630 Investment valuation class, Major Project 1.

\f\f\f\f