Caledonia: calculate payback period, NPV, IRR, and ranking conflict
Not what you're looking for?
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?
Purchase this Solution
Solution Summary
The solution explains how to calculate the Payback, Net Present Value, and Internal Rate of Return for the given projects and make the acceptance/rejection decision
Solution Preview
Please see the attached file.
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?
a. Payback period is the time taken to recover the initial investment. To calculate the
payback period, we calculate the cumulative cash flow and find the time period needed
for the cumulative cash flow to become ...
Purchase this Solution
Free BrainMass Quizzes
Basics of corporate finance
These questions will test you on your knowledge of finance.
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
Operations Management
This quiz tests a student's knowledge about Operations Management
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.