Explore BrainMass

NPV & IRR Analysis

here are the cash flows for two mutually exclusive projects
Project C0 C1 C2 C3
A (20,000) 8,000 8,000 8,000
B (20,000) 0 0 25,000

a) at what interest rates would you prefer project A to B
b) what is the IRR of each of each project

the response has to be in excel format

Solution Summary

The solution find out between two mutually exclusive project which will chosen when compared with their NPV as well as their IRR.