Purchase Solution

Scenario Analysis for Mutually Exclusive Projects

Not what you're looking for?

Ask Custom Question

Basic scenario analysis Murdock Paints is in the process of evaluating two mutually exclusive additions to its processing capacity. The firm's financial analysts have developed pessimistic, most likely, and optimistic estimates of the annual cash inflows associated with each project.

Project A Project B
Initial investment (CF0) $8,000 $8,000
Outcome Annual cash inflows (CF)
Pessimistic $ 200 $ 900
Most likely 1,000 1,000
Optimistic 1,800 1,100

a. Determine the range of annual cash inflows for each of the two projects.

b. Assume that the firm's cost of capital is 10% and that both projects have 20-year lives. Construct a table similar to this for the NPVs for each project. Include the range of NPVs for each project.

c. Do parts a and b provide consistent views of the two projects? Explain.

d. Which project do you recommend? Why?

Purchase this Solution

Solution Summary

This solution illustrates how to perform scenario analysis (regarding net present value) for two mutually exclusive projects. Attached as Excel.

Purchase this Solution


Free BrainMass Quizzes
Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Lean your Process

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

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.