Purchase Solution

Cash flows of two investments

Not what you're looking for?

Ask Custom Question

Consider the following cash flows on two not mutually exclusive investments.
Year Investment A Investment B
0 -$100 -$100
1 44 69
2 56 51
3 65 32
The required return is 15%. The investments are not mutually exclusive.

a) Calculate the NPV and IRR on both. Are they desirable?
Now suppose you wanted to combine the two investments into a single investment C.
b) Calculate the combined cash flows.
c) What is the NPV of C?
d) How does the NPV of C relate to the NPV's of A and B considered separately?
e) Based on your answer to (d), is there an obvious shortcut that we could have used to calculate the NPV of C?
f) Based on the combined cash flows, calculate the IRR for C. How does your answer relate to the IRRs for A and B?
g) Is there an obvious shortcut that we could have used to calculate the IRR of C?

Purchase this Solution

Solution Summary

This solution provides calculations in Excel for various investment related questions.

Purchase this Solution


Free BrainMass Quizzes
Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Introduction to Finance

This quiz test introductory finance topics.

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.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

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.