Explore BrainMass
Share

Considering Two Projects: Calculate NPV, IRR, Payback Period

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

2. Your firm is considering two projects: Project A and Project B with the following cash flows:

A YEAR B YEAR
-$75 0 -$60 0
$15 1 $20 1
$33 2 $13 2
$44 3 $15 3
$55 4 $18 4

a. Calculate the NPVs based on WACCs of 5% and 7%.
b. What are the IRRs based on the WACCs?
c. Calculate the payback period and discounted payback period.
d. Which projects should the firm accept if they are independent, based on the NPV, IRR, payback period, and discounted payback period methods? Assume your firm requires projects to break even in three years.

© BrainMass Inc. brainmass.com October 25, 2018, 4:30 am ad1c9bdddf
https://brainmass.com/business/net-present-value/considering-projects-calculate-npv-irr-payback-period-381358

Solution Summary

The solution considers two projects and calculates NPV, IRR and payback period.

$2.19
See Also This Related BrainMass Solution

Caledonia: calculate payback period, NPV, IRR, and ranking conflict

I do not understand the NPV, or IRR. I have to answer these questions in an excel spreadsheet.

File is attached.

12. Caledonia is considering two additional mutually exclusive projects. The cash flows associated with these projects are as follows:
YEAR PROJECT A PROJECT B
0 −$100,000 −$100,000
1 32,000 0
2 32,000 0
3 32,000 0
4 32,000 0
5 32,000 $200,000

The required rate of return on these projects is 11 percent.

a. What is each project's payback period?
b. What is each project's net present value?
c. What is each project's internal rate of return?
d. What has caused the ranking conflict?
e. Which project should be accepted? Why?

View Full Posting Details