Purchase Solution

Choosing between two mutually exclusive projects

Not what you're looking for?

Ask Custom Question

Please help with the following problem. Provide your solutions in Excel.

Mutual exclusive investment
Here are the cash flow forecast for two mutually exclusive projects:
Cash Flows, Dollars

Year Project A Project B
0 -$100 -$100
1 30 49
2 50 49
3 70 49

Which project would you choose if the opportunity cost of capital is 2 percent?
Which would you choose if the opportunity cost of capital is 12 percent?
Why does you answer change?

Purchase this Solution

Solution Summary

This solution helps with a problem regarding choosing between two mutually exclusive projects. The answer are provided in Excel.

Solution Preview

NPV is defined as the difference between an investment's market value and its cost. It is only a good investment if it makes money for the company so a positive NPV will be needed. This quantitative ranking method is the best to use due to its consideration of the time value of money and its more accurate breakdown of value. Thus project having higher NPV will be ...

Purchase this Solution


Free BrainMass Quizzes
Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Introduction to Finance

This quiz test introductory finance topics.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking