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 
Other questions asked by students
Q
Coffee Bean Inc. (CBI) processes and distributes a variety of coffee. CBI buys coffee beans from...
Accounting
Programming
Psychology
Biology
Basic Math
Accounting