Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. The Blake Computer Business is trying to choose between the following two mutually exclusive projects: (note this may be done in Excel!) Year A

1. The Blake Computer Business is trying to choose between the following two mutually exclusive projects: (note this may be done in Excel!)

Year A B
0 -$40,000 -$15,000
1 21,000 8,500
2 21,000 8,500
3 21,000 8,500

The cost of capital is 10%.

a. Calculate the payback period, IRR, MIRR, and NPV of each investment. For MIRR assume the reinvestment rate is equal to the companys cost of capital.

b. Assess the acceptability of each project based on each result in (a). That is, go through each answer and decide whether or not the project is acceptable under each models specific decision criteria.

c. Graph the NPV profiles of each investment. This needs to be done in Excel. You should present the discount rate on the x-axis (use a large array of potential discount rates) and the NPV should be on the y-axis. Both NPV profiles (for A and B) should be presented in the same graph.

d. Calculate the cross-over rate for these two projects.

e. Ultimately, which project would you recommend and why? Please be specific and detailed in your response.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Corporate Finance

Authors: Richard Brealey

10th Global Edition

0071314172, 9780071314176

More Books

Students also viewed these Finance questions

Question

How does nonverbal communication express cultural values?

Answered: 1 week ago