Excel can find the internal rate of return (IRR) and use that as the discount rate for an NPV of zero. Let’s begin by examining each step of NPV in order. The formula is: NPV = ∑ {After-Tax ...

Follow these steps: This is explained in more ... To take advantage of Excel’s currency conversion capabilities, use formulas ...