Choosing a Project Based on ROR, Payback, NPV, etc.
Not what you're looking for?
A company 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.
1. What is each project's payback period?
2. What is each project's net present value?
3. What is each project's internal rate of return?
4. What has caused the ranking conflict?
5. Which project should be accepted? Why?
Please use excel so I can see how the formulas worked.
Purchase this Solution
Solution Summary
Solution attached in Excel finds the payback period, net present value, internal rate of return and any ranking conflicts in order to pick the best of two projects.
Education
- BA, Ain Shams University, Cairo Egypt
- MBA, California State University, Sacramento
Recent Feedback
- "ty i have more need help with"
- "ty i have jmore i need help with"
- "great help"
- "excellent help"
- "Very helpful and easy to understand."
Purchase this Solution
Free BrainMass Quizzes
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Basic Social Media Concepts
The quiz will test your knowledge on basic social media concepts.
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.
Motivation
This tests some key elements of major motivation theories.