Bedknobs and Broomsticks: Two projects. What is IRR, NPV for each?

Bedknobs and Broomsticks, Inc., has the following two projects available. The required return is 14%

PLEASE SEE ATTACHED SPREADSHEET

a) What is the IRR for each project?
b) What is the NPV for each project?
c) Which, if either, of these two projects should the company choose?

© SolutionLibrary Inc. solutionlibary.com 9836dcf9d7 https://solutionlibrary.com/business/finance/bedknobs-and-broomsticks-two-projects-what-is-irr-npv-for-each-2mk
Attachments

Solution Preview

...30,000 70,000
2 30,000 50,000
3 30,000 60,000
4 20,000 30,000
IRR 4.156% 16.934%
PV of ...