Please see the attachment.
submit answers to the following questions/problems in your textbook on a EXCEL
spreadsheet
Chapter 10
Problem 10-5
Chapter 11
Question 11-4
Problem 11-1
Problem 11-2
Problem 11-6
Problem 11-12
10-5 PROJECT SELECTION Midwest Water Works estimates that its WACC is 10.5%. The company is
considering the following capital budgeting projects:
Project Size Rate of Return
A $1 million 120%
B 2 million 11.5
C 2 million 11.2
D 2 million 11.0
E 1 million 10.7
F 1 million 10.3
G 1 million 10.2
QUESTION
11- 4 What is a mutually exclusive project? How should managers rank
mutually exclusive projects
Problems
11-1 NPV Project L costs $65,000, its expected cash inflows are $12,000 per
year for 9 years, and its WACC is 9%. What is the project’s NPV?
11-2 IRR Refer to problem 11-1. What is the project’s IRR?
11.6 NPV Your division is considering two projects with the following cash
flows (in millions):
• 0 1 2 3
Project A -$25 $5 $10 $17
Project B -$20 $10 $9 $6
a. What are the projects’ NPVs assuming the WACC is 5%? 10%? 15%? b. What
are the projects’ IRRs at each of these WACCs? c. If the WACC was 5% and A and
B were mutually exclusive, which project would you
choose? What if the WACC was 10%? 15%? (Hint: The crossover rate is 7.81%.)
11-12 RR AND NPV A company is analyzing two mutually exclusive projects,
S and L, with the following cash flows:
0 1 2 3 4
Project S -$1,000 $870 $250 $25 $25
Project L
-$1,000 $0 $250 $400 $845
The company’s WACC is 8.5%. What is the IRR of the better project? (Hint: The
better project may or may not be the one with the higher IRR.)