Explore BrainMass
Share

NPV & IRR Analysis

This content was STOLEN from BrainMass.com - View the original, and get the already-completed 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 October 25, 2018, 10:01 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.

$2.19
See Also This Related BrainMass Solution

CTC Mining Corporation -
Capital Budgeting Decision-decide whether to mine the deposit-NPV & IRR Analysis

After discovering a new gold vein in the Colorado mountains, CTC Mining Corporation must decide whether to mine the deposit. The most cost-effective method of mining gold is sulfuric extraction, a process that results in environmental damage. To go ahead with the extraction, CTC must spend $900,000 for new mining equipment and pay $165,000 for it's installation. The gold mined will net the firm an estimated $350,000 each year over the 5 year life of the vein. CTC's cost of capital is 14 percent. For the purposes of this problem, assume that the cash inflows occur at the end of the year.

a. What are the NPV and IRR of this project?
b. Should this project be undertaken, ignoring environmental concerns?
c. How should environmental effects be considered when evaluating this, or any other project? How might these effects change your decision in part B?

View Full Posting Details