Explore BrainMass

NPV & IRR Analysis

This content was STOLEN from BrainMass.com - View the original, and get the solution, here!

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

© BrainMass Inc. brainmass.com September 21, 2018, 9:43 am ad1c9bdddf - https://brainmass.com/business/annuity/npv-irr-analysis-595061

Solution Summary

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