4. Set up your worksheet this way. 5. Set up your Comparison Table this way. 6. Use this formula to calculate NPV: =Outflow+NPV(Hurdle Rate, Highlight only Inflows) 7. Use this formula to calculate IRR: =IRR(Highlight both Ouflow and Inflows, Guess any rate) 8. Check figure: NPV $7,988; Payback, 1.248 years 4. Set up your worksheet this way. 5. Set up your Comparison Table this way. 6. Use this formula to calculate NPV: =Outflow+NPV(Hurdle Rate, Highlight only Inflows) 7. Use this formula to calculate IRR: =IRR(Highlight both Ouflow and Inflows, Guess any rate) 8. Check figure: NPV $7,988; Payback, 1.248 years