Purchase Solution

Comparing Mutually Exclusive Project Investment Criteria

Not what you're looking for?

Ask Custom Question

Consider the following two mutually exclusive project:

Year Cash Flow (A) Cash Flow (B)
0 -$322,574 -$23,426
1 29,000 9,699
2 54,000 8,919
3 55,000 13,478
4 395,000 11,486

Whichever project you choose, if any, you require a 15 percent return on your investment.

a) The payback period for projects A and B. (round answers to decimal places, e.g. 32.16)
b) The discounted payback period for A and B. (round answers to decimal places, e.g. 32.16)
c) The NPV for projects A and B. (round answers to decimal places, e.g. 32.16)
d) The IRR for projects A and B. (round answers to decimal places, e.g. 32.16)
e) The profitability index for projects A and B. (round answers to decimal places, e.g. 32.161)
f) Based on your answers in (a) through (e) which project will you finally choose?

Purchase this Solution

Solution Summary

This solution calculates values for each project as requested in each question. The Solution is provided in a Microsoft Excel document.

Solution Preview

Note:
*** Remember, this service is not intended to be used as "homework completion, I am giving you the ...

Purchase this Solution


Free BrainMass Quizzes
Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Operations Management

This quiz tests a student's knowledge about Operations Management