Perform sensitivity analysis to analyze the effect of expenses on the project’s NPV and IRR. In your analysis, allow costs to vary between $0 and $100,000, in $5,000 increments. Use Goal Seek to find what level of expenses Lewis Industries needs to just break even from a NPV perspective (i.e., what level of expenses produces a NPV of $0)? Use the following information to complete.
Please post Excel screenshot