Gardial Fisheries is considering two mutually exclusive investments. The projects' expected net cash flows are as follows: WACC - NPVA- Time 0 1 NPVB- 2 3 4 5 6 7 a. If each project's cost of capital is 12%, which project should be selected? If the cost of capital is 18%, what project is the proper choice? Provide your answer after you've completed all analyses. @ 12% cost of capital Expected Net Cash Flows Project A Project B ($375) ($575) ($300) $190 ($200) $190 ($100) $190 $600 $190 12% $600 $190 $926 $190 ($200) $0 T @ 18% cost of capital WACC = NPVA- NPV B= b. What is each project's IRR? 18% Use Excel's NPV function as explained in this chapter's Tool Kit. Note that the range does not include the costs, which are added separately. c. What is each project's MIRR at a cost of capital of 12 %? Atr=18% ? Hint: note that B is a 6-year project. @ 12% cost of capital MIRRA= MIRR B = Project B d. What is the regular payback period for these two projects? Project A Time period Cash flow Cumulative cash flow payback calculations Time period Cash flow Cumulative cash flow payback Payback using intermediate calculations 0 0 $0 0 1 1 $0 @18% cost of capital MIRRA- MIRR 8 = 0 2 2 $0 0 3 $0 0 4 4 $0 0 5 5 $0 $0 6 6 $0 $0 7 7 $0 $0

Financial Management: Theory & Practice
16th Edition
ISBN:9781337909730
Author:Brigham
Publisher:Brigham
Chapter10: The Basics Of Capital Budgeting: Evaluating Cash Flows
Section: Chapter Questions
Problem 23SP: Start with the partial model in the file Ch10 P23 Build a Model.xlsx on the textbooks Web site....
icon
Related questions
icon
Concept explainers
Topic Video
Question
100%

Comparing Investment Decision Criterion. Define each of the following investment rules and discuss any potential shortcomings of each.  In your definition, state the criteria for accepting or rejecting independent and mutually exclusive projects under each rule.

Payback period

Modified Internal rate of return

Internal rate of return

Profitability index

Net present value

e. At a cost of capital of 12%, what is the discounted payback period for these two projects?
WACC = 12%
Project A
Time period 0
Cash flow
Disc. cash flow
Disc. cum. cash flow
Intermediate
calculation for
payback
Payback using
intermediate
calculations
Project B
Time period
Cash flow
Disc. cash flow
Disc. cum. cash flow
Intermediate
calculation for
payback
Payback using
intermediate
calculations
-$375
0
$575
1
-$300
1
$190
2
-$200
2
$190
3
-$100
3
$190
4
$600
4
$190
5
$600
5
$190
6
$926
6
$190
7
-$200
7
h. What is the profitability index for each project if the cost of capital is 12%?
PV of future cash flows for A:
Pl of A:
PV of future cash flows for B:
PI of B:
a. If each project's cost of capital is 12%, which project should be selected? If the cost of capital is 18%, what
project is the proper choice? Provide your answer after you've completed all analyses.
Transcribed Image Text:e. At a cost of capital of 12%, what is the discounted payback period for these two projects? WACC = 12% Project A Time period 0 Cash flow Disc. cash flow Disc. cum. cash flow Intermediate calculation for payback Payback using intermediate calculations Project B Time period Cash flow Disc. cash flow Disc. cum. cash flow Intermediate calculation for payback Payback using intermediate calculations -$375 0 $575 1 -$300 1 $190 2 -$200 2 $190 3 -$100 3 $190 4 $600 4 $190 5 $600 5 $190 6 $926 6 $190 7 -$200 7 h. What is the profitability index for each project if the cost of capital is 12%? PV of future cash flows for A: Pl of A: PV of future cash flows for B: PI of B: a. If each project's cost of capital is 12%, which project should be selected? If the cost of capital is 18%, what project is the proper choice? Provide your answer after you've completed all analyses.
Gardial Fisheries is considering two mutually exclusive investments. The projects' expected net
cash flows are as follows:
WACC =
NPV A =
NPV B=
Time
0
1
2
3
4
5
6
7
a. If each project's cost of capital is 12%, which project should be selected? If the cost of capital is
18%, what project is the proper choice? Provide your answer after you've completed all analyses.
@ 12% cost of capital
@ 18% cost of capital
IRR A =
IRR B =
Expected Net Cash Flows
Project A Project B
12%
($375) ($575)
($300)
$190
($200) $190
($100)
$190
$600
$190
$190
$190
$600
$926
($200) $0
WACC =
NPV A
NPV B=
b. What is each project's IRR?
18%
Use Excel's NPV function as explained in this
chapter's Tool Kit. Note that the range does not
include the costs, which are added separately.
c. What is each project's MIRR at a cost of capital of 12%? At r = 18%? Hint: note that B is a 6-year project.
@ 12% cost of capital
Project B
MIRRA =
MIRR B=
d. What is the regular payback period for these two projects?
Project A
Time period
Cash flow
Cumulative cash flow
payback
calculations
Time period
Cash flow
Cumulative cash flow
payback
Payback using intermediate
calculations
0
0
$0
0
1
1
$0
@18% cost of capital
MIRR A=
MIRR B =
0
2
2
$0
0
3
3
$0
0
4
4
$0
0
5
5
$0
$0
6
6
$0
$0
7
7
$0
$0
Transcribed Image Text:Gardial Fisheries is considering two mutually exclusive investments. The projects' expected net cash flows are as follows: WACC = NPV A = NPV B= Time 0 1 2 3 4 5 6 7 a. If each project's cost of capital is 12%, which project should be selected? If the cost of capital is 18%, what project is the proper choice? Provide your answer after you've completed all analyses. @ 12% cost of capital @ 18% cost of capital IRR A = IRR B = Expected Net Cash Flows Project A Project B 12% ($375) ($575) ($300) $190 ($200) $190 ($100) $190 $600 $190 $190 $190 $600 $926 ($200) $0 WACC = NPV A NPV B= b. What is each project's IRR? 18% Use Excel's NPV function as explained in this chapter's Tool Kit. Note that the range does not include the costs, which are added separately. c. What is each project's MIRR at a cost of capital of 12%? At r = 18%? Hint: note that B is a 6-year project. @ 12% cost of capital Project B MIRRA = MIRR B= d. What is the regular payback period for these two projects? Project A Time period Cash flow Cumulative cash flow payback calculations Time period Cash flow Cumulative cash flow payback Payback using intermediate calculations 0 0 $0 0 1 1 $0 @18% cost of capital MIRR A= MIRR B = 0 2 2 $0 0 3 3 $0 0 4 4 $0 0 5 5 $0 $0 6 6 $0 $0 7 7 $0 $0
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 6 images

Blurred answer
Knowledge Booster
Capital Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT