Purchase Solution

NPV and IRR Analysis

Not what you're looking for?

Ask Custom Question

Derek's Donuts is considering two mutually exclusive investments. The projects expected net cash flows are as follows:

Year Project A Project B
0 ($300) ($405)
1 ($387) $134
2 ($193) $134
3 ($100) $134
4 $500 $134
5 $500 $134
6 $850 $134
7 $100 $0

*** SEE ATTACHED EXCEL SPREADSHEET FOR THE DATA ***

A) Construct NPV profiles for Projects A and B

B) What is each project's IRR?

C) If you were told that each project's required rate of return was 12percent, which project should be selected? If the required rate of return was 15%, what would be the proper choice?

D) Looking at the NPV profiles constructed in part (a), what is the approximate crossover rate, and what is its significance?

Attachments
Purchase this Solution

Solution Summary

The solution compares two mutually exclusive investments by
1) Constructing NPV profiles for the projects
2) Computing IRR of the projects
and
3) Recommends which project should be selected
4) Finds the crossover rate

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.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Understanding Management

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

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.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce