A company is considering two mutually exclusive expansion plans. Plan A requires a $41 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.55 million per year for 20 years. Plan B requires a $12 million expenditure to build a somewhat less efficient, more labor-intensive plant with an expected cash flow of $2.69 million per year for 20 years. The firm's WACC is 10%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Calculate each project's NPV. Round your answers to two decimal places. Do not round your intermediate calculations. Enter your answers in millions. For example, an answer of $10,550,000 should be entered as 10.55. Plan A: $ fill in the blank 2 million Plan B: $ fill in the blank 3 million Calculate each project's IRR. Round your answer to two decimal places. Plan A: fill in the blank 4% Plan B: fill in the blank 5% By graphing the NPV profiles for Plan A and Plan B, approximate the crossover rate to the nearest percent. fill in the blank 6% Calculate the crossover rate where the two projects' NPVs are equal. Round your answer to two decimal places. fill in the blank 7%
A company is considering two mutually exclusive expansion plans. Plan A requires a $41 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.55 million per year for 20 years. Plan B requires a $12 million expenditure to build a somewhat less efficient, more labor-intensive plant with an expected cash flow of $2.69 million per year for 20 years. The firm's WACC is 10%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.
-
Calculate each project's NPV. Round your answers to two decimal places. Do not round your intermediate calculations. Enter your answers in millions. For example, an answer of $10,550,000 should be entered as 10.55.
Plan A: $ fill in the blank 2 million
Plan B: $ fill in the blank 3 million
Calculate each project's
IRR . Round your answer to two decimal places.Plan A: fill in the blank 4%
Plan B: fill in the blank 5%
-
By graphing the NPV profiles for Plan A and Plan B, approximate the crossover rate to the nearest percent.
fill in the blank 6%
-
Calculate the crossover rate where the two projects' NPVs are equal. Round your answer to two decimal places.
fill in the blank 7%
![1
2
3
4
5
6
7
8
9
U9
File
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
G Wizard Co. currently has only a real estat...
5
A
NPV profiles
WACC
Plan B
10
11 NPVA
NPVB
(Dollars in Millions)
Plan A
template Saved ✓
Project NPV Calculations:
NPV Profiles:
Discount
Project IRR Calculations:
IRRA
IRRB
$1.00
$0.90
$0.80
$0.70
$0.60
$0.50
$0.40
$0.30
$0.20
$0.10
$0.00
<>
Plan A
Plan B
Home Insert
0%
Project Delta
0%
5%
10%
15%
20%
22%
25%
B
Crossover Rate= IRRA
10.00%
NPVA
Calculation of Crossover Rate:
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
5%
Formulas
▼
Workbook Statistics
Arial
C
0
-$41.00
-$12.00
Formulas
#N/A
#N/A
#N/A
#N/A
NPVB
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
10%
0
-$41.00
#N/A
Formula
#N/A
Sheet1
Draw
D
fx
E
NPV Profiles
1
2
3
$6.55 $6.55 $6.55
Page Layout
$2.69 $2.69 $2.69
#N/A
F
15%
-$12.00 $2.69 $2.69 $2.69
+
V 10
1
2
3
$6.55 $6.55 $6.55
#N/A #N/A
20%
G
4
$6.55
$2.69
$6.55
$2.69
#N/A
H
Formulas
B
22%
I
5
6
$6.55 $6.55
$2.69 $2.69
MindTap - Cengage Learning
J
7
$6.55
$2.69
1
25%
5
6
7
$6.55 $6.55 $6.55
$2.69 $2.69 $2.69
#N/A #N/A #N/A
K
8
$6.55
8
$6.55
$2.69
Data
$2.69 $2.69
#N/A
L
9
$6.55
9
$6.55
$2.69
#N/A
M
10
$6.55
$2.69
10
$6.55
$2.69
#N/A
Review
V
✓
Search for tools, help, and more (Option + Q)
N
11
$6.55
O
11
12
13
$6.55 $6.55 $6.55
$2.69
$2.69 $2.69 $2.69
#N/A
View
P
12
13
$6.55 $6.55
#N/A
$2.69 $2.69
#N/A
ab
Q
Help
14
$6.55
→
$2.69
#N/A
R
$2.69 $2.69
15
$6.55
14
15
$6.55 $6.55
$2.69
#N/A
▼
ng.cengage.com
Excel Online Student Work
S
General
T
$2.69 $2.69
16
17
18
19
$6.55 $6.55 $6.55 $6.55
16
17
$6.55 $6.55
U
$2.69 $2.69
V
$2.69 $2.69
18
19
$6.55 $6.55
$2.69 $2.69
#N/A #N/A #N/A
#N/A
W
20
$6.55
$2.69
20
$6.55
$2.69
#N/A
X
V
Y
←0
.00
Z
.00
→.0
AA
AB
AC
Start Page
AD
AE
AF
ST
NTT
AG
AH
G how to screenshot on macbook - Google...
Al
Ev APV
AJ
Editing ✓
AK
AL
AM
Give Feedback to Microsoft
+
AN
Comments
AO
T
AP
50% +
AQ](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F7dc4ef70-ef30-445e-9bc3-fbd652f0f5db%2F98a614b2-6824-492c-ba88-2bec8c87708b%2Fyp39yt_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Foundations Of Finance](https://www.bartleby.com/isbn_cover_images/9780134897264/9780134897264_smallCoverImage.gif)
![Fundamentals of Financial Management (MindTap Cou…](https://www.bartleby.com/isbn_cover_images/9781337395250/9781337395250_smallCoverImage.gif)
![Corporate Finance (The Mcgraw-hill/Irwin Series i…](https://www.bartleby.com/isbn_cover_images/9780077861759/9780077861759_smallCoverImage.gif)