Fundamentals of Corporate Finance
Fundamentals of Corporate Finance
11th Edition
ISBN: 9780077861704
Author: Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Bradford D Jordan Professor
Publisher: McGraw-Hill Education
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 9, Problem 12QP

NPV versus IRR [LO1, 5] Garage, Inc., has identified the following two mutually exclusive projects:

Year Cash Flow (A) Cash Flow (B)
0 $43,500 $43,500
1 21,400 6,400
2 18,500 14,700
3 13,800 22,800
4 7,600 25,200

a. What is the IRR for each of these projects? Using the IRR decision rule, which project should the company accept? Is this decision necessarily correct?

b. If the required return is 11 percent, what is the NPV for each of these projects? Which project will the company choose if it applies the NPV decision rule?

c. Over what range of discount rates would the company choose project A? Project B? At what discount rate would the company be indifferent between these two projects? Explain.

a)

Expert Solution
Check Mark
Summary Introduction

To calculate: The IRR (Internal rate of return) for the proposed projects of Company G, the project that the company must accept and discuss whether the decision made is appropriate.

Introduction:

The IRR (Internal rate of return) is a rate of discount, which makes the predictable investment’s NPV equal to zero.

The NPV (Net present value) is a capital budgeting technique, which is used to assess the investment, and it is utilized to identify the profitability in a proposed investment.

Answer to Problem 12QP

As IRR is higher in Project A when compared to Project B, then Project A can be accepted. However, it is not the appropriate decision because the criterion of IRR has a problem in ranking of mutually exclusive projects.

Explanation of Solution

Given information:

Company G has identified two mutually exclusive projects where the cash flows of Project A are $21,400, $18,500, $13,800, and $7,600 for the years 1, 2, 3, and 4, respectively. The cash flows of Project B are $6,400, $14,700, $22,800, and $25,200 for the years 1, 2, 3, and 4, respectively. The initial costs for both the project are $43,500, respectively.

Note:

  • NPV is the difference between the present values of the cash inflows from the present value of cash outflows.
  • The IRR is the rate of interest, which makes the project’s NPV equal to zero. Hence, using the available information, assume that the NPV is equal to zero and form an equation to compute the IRR.

Equation of NPV to compute IRR assuming that NPV is equal to zero:

NPV=0=$13,900+$6,400(1+IRR)+$8,700(1+IRR)2+$5,900(1+IRR)30=$13,900+$6,400(1+IRR)+$8,700(1+IRR)2+$5,900(1+IRR)3

Compute IRR for Project A using a spreadsheet:

Step 1:

Fundamentals of Corporate Finance, Chapter 9, Problem 12QP , additional homework tip  1

  • Type the equation of NPV in H6 in the spreadsheet and consider the IRR value as H7.

Step 2:

Fundamentals of Corporate Finance, Chapter 9, Problem 12QP , additional homework tip  2

  • Assume the IRR value as 0.10%.

Step 3:

Fundamentals of Corporate Finance, Chapter 9, Problem 12QP , additional homework tip  3

  • In the spreadsheet, go to the data and select the what-if analysis.
  • In what-if analysis, select goal seek.
  • In “Set cell”, select H6 (the formula).
  • The “To value” is considered as 0 (the assumption value for NPV).
  • The H7 cell is selected for the “By changing cell”.

Step 4:

Fundamentals of Corporate Finance, Chapter 9, Problem 12QP , additional homework tip  4

  • Following the previous step, click OK in the goal seek. The goal seek status appears with the IRR value.

Step 5:

Fundamentals of Corporate Finance, Chapter 9, Problem 12QP , additional homework tip  5

  • The value appears to be 18.3340455879954%.

Hence, the IRR value is 18.33%.

Compute IRR for Project B using a spreadsheet:

Step 1:

Fundamentals of Corporate Finance, Chapter 9, Problem 12QP , additional homework tip  6

  • Type the equation of NPV in H6 in the spreadsheet and consider the IRR value as H7.

Step 2:

Fundamentals of Corporate Finance, Chapter 9, Problem 12QP , additional homework tip  7

  • Assume the IRR value as 0.10%.

Step 3:

Fundamentals of Corporate Finance, Chapter 9, Problem 12QP , additional homework tip  8

  • In the spreadsheet, go to the data and select the what-if analysis.
  • In what-if analysis, select goal seek.
  • In “Set cell”, select H6 (the formula).
  • The “To value” is considered as 0 (the assumption value for NPV).
  • The H7 cell is selected for the “By changing cell”.

Step 4:

Fundamentals of Corporate Finance, Chapter 9, Problem 12QP , additional homework tip  9

  • Following the previous step, click OK in the goal seek. The goal seek status appears with the IRR value.

Step 5:

Fundamentals of Corporate Finance, Chapter 9, Problem 12QP , additional homework tip  10

  • The value appears to be 17.3742651839301%.

Hence, the IRR value is 17.37%.

b)

Expert Solution
Check Mark
Summary Introduction

To calculate: The NPV for the projects to choose the best project for the company.

Introduction:

The IRR (Internal rate of return) is a rate of discount, which makes the predictable investment’s NPV equal to zero.

The NPV (Net present value) is a capital budgeting technique, which is used to assess the investment, and it is utilized to identify the profitability in a proposed investment.

Answer to Problem 12QP

As NPV is greater in Project B, the company must accept Project B.

Explanation of Solution

Given information:

Company G has identified two mutually exclusive projects where the cash flows of Project A are $21,400, $18,500, $13,800, and $7,600 for the years 1, 2, 3, and 4, respectively. The cash flows of Project B are $6,400, $14,700, $22,800, and $25,200 for the years 1, 2, 3, and 4, respectively. The initial costs for both the project are $43,500, respectively.

Note:

  • NPV is the difference between the present values of the cash inflows from the present value of cash outflows.
  • The IRR is the rate of interest, which makes the project’s NPV equal to zero. Hence, using the available information, assume that the NPV is equal to zero and form an equation to compute the IRR.

Formula to calculate the NPV:

NPV=Present value of cash inflowPresent value of cash outflow

Compute NPV for Project A:

NPV at 11%=$21,400(1+0.11)+$18,500(1+0.11)2+$13,800(1+0.11)3+$7,600(1+0.11)4$43,500=$21,4001.11+$18,5001.2321+$13,8001.367631+$7,6001.51807041$43,500=($19,279.2792792792+$15,015.0150150150+$10,090.4410619531+$5,006.35540350200$43,500)=$5,891.09

Hence, the NPV for Project A is $5,891.09.

Compute NPV for Project B:

NPV at 11%=$6,400(1+0.11)+$14,700(1+0.11)2+$22,800(1+0.11)3+$25,200(1+0.11)4$43,500=$6,4001.11+$14,7001.2321+$22,8001.367631+$25,2001.51807041$43,500=($5,765.76576576576+$11,930.8497686876+$16,671.1634936616+$16,600.0205484540$43,500)=$7,467.80

Note: The rate is given at 11%.

Hence, the NPV for project B is $7,467.80.

c)

Expert Solution
Check Mark
Summary Introduction

To calculate: The rates of discount at which the company will select Project A and Project B, and the discount rate in which the company will be indifferent in selecting between the two projects.

Introduction:

The IRR (Internal rate of return) is a rate of discount, which makes the predictable investment’s NPV equal to zero.

The NPV (Net present value) is a capital budgeting technique, which is used to assess the investment, and it is utilized to identify the profitability in a proposed investment.

Answer to Problem 12QP

At the rate of discount above 15.19%, the company must choose Project A and for the rate below 15.19%, the company should choose Project B. Hence, it is indifferent at the discount rate of 15.19%.

Explanation of Solution

Given information: Company G has identified two mutually exclusive projects where the cash flows of Project A are $21,400, $18,500, $13,800, and $7,600 for the years 1, 2, 3, and 4, respectively. The cash flows of Project B are $6,400, $14,700, $22,800, and $25,200 for the years 1, 2, 3, and 4, respectively. The initial costs for both the project are $43,500, respectively.

Note:

  • NPV is the difference between the present values of the cash inflows from the present value of cash outflows.
  • The IRR is the rate of interest, which makes the project’s NPV equal to zero. Hence, using the available information, assume that the NPV is equal to zero and form an equation to compute the IRR.

Equation to calculate the crossover rates:

0=$15,000(1+R)+$3,800(1+R)2$9,000(1+R)3$17,600(1+R)4

Compute the discount rate using spreadsheet:

Step 1:

Fundamentals of Corporate Finance, Chapter 9, Problem 12QP , additional homework tip  11

  • Type the equation of NPV in H6 in the spreadsheet and consider the R value as H7.

Step 2:

Fundamentals of Corporate Finance, Chapter 9, Problem 12QP , additional homework tip  12

  • Assume the R value as 10%.

Step 3:

Fundamentals of Corporate Finance, Chapter 9, Problem 12QP , additional homework tip  13

  • In the spreadsheet, go to the data and select the what-if analysis.
  • In what-if analysis, select goal seek.
  • In “Set cell”, select H6 (the formula).
  • The “To value” is considered as 0 (the assumption value for NPV).
  • The H7 cell is selected for the “By changing cell”.

Step 4:

Fundamentals of Corporate Finance, Chapter 9, Problem 12QP , additional homework tip  14

  • Following the previous step, click OK in the goal seek. The goal seek status appears with the R value.

Step 5:

Fundamentals of Corporate Finance, Chapter 9, Problem 12QP , additional homework tip  15

  • The value appears to be 15.1876364952186%.

Hence, the R value is 15.19%.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
10. NPV versus IRR Piercy, LLC, has identified the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) -$77,500 -$77,500 1 43,000 21,000 29,000 28,000 3. 23,000 34,000 21,000 41,000 What is the IRR for each these projects? If you apply the IRR a. decision rule, which project should the company accept? Is this decision necessarily correct? b. If the required return is 11 percent, what is the NPV for each of the projects? Which project will you choose if you apply the NPV decision rule? Over what range of discount rates would you choose Project A? Project B? At what discount rate would you be indifferent between these two projects? Explain. с. roiects:
Garage, Inc., has identified the following two mutually exclusive projects:   Year Cash Flow (A) Cash Flow (B) 0 -$43,500 -$43,500 1 21,400 6,400 2 18,500 14,700 3 13,800 22,800 4 7,600 25,200   What is the IRR for each of these projects? Using the IRR decision rule, which project should the company accept? Is this decision necessarily correct? If the required return is 11 percent, what is the NPV for each of these projects? Which project will the company choose if it applies the NPV decision rule? Over what range of discount rates would the company choose project? A? Project B? At what discount rate would the company be indifferent between these two projects? Explain.
Bruin, Incorporated, has identified the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 −$ 66,000 −$ 66,000 1 42,000 28,400 2 36,000 32,400 3 24,000 38,000 4 15,200 24,400 a-1. What is the IRR for each of these projects?   a-2. If you apply the IRR decision rule, which project should the company accept? b-1. Assume the required return is 12 percent. What is the NPV for each of these projects?   b-2. Which project will you choose of you apply the NPV decision rule? c-1. Over what range of discount rates would you choose Project A?   c-2. Over what range of discount rates would you choose Project B?   d. At what discount rate would you be indifferent between these two projects?

Chapter 9 Solutions

Fundamentals of Corporate Finance

Ch. 9.6 - What does the profitability index measure?Ch. 9.6 - How would you state the profitability index rule?Ch. 9.7 - Prob. 9.7ACQCh. 9.7 - If NPV is conceptually the best procedure for...Ch. 9 - Prob. 9.1CTFCh. 9 - Prob. 9.2CTFCh. 9 - Prob. 9.3CTFCh. 9 - Prob. 9.4CTFCh. 9 - What is a benefitcost ratio?Ch. 9 - Prob. 9.7CTFCh. 9 - Prob. 1CRCTCh. 9 - Net Present Value [LO1] Suppose a project has...Ch. 9 - Prob. 3CRCTCh. 9 - Prob. 4CRCTCh. 9 - Prob. 5CRCTCh. 9 - Net Present Value [LO1] Concerning NPV: a....Ch. 9 - Prob. 7CRCTCh. 9 - Profitability Index [LO7] Concerning the...Ch. 9 - Payback and Internal Rate of Return [LO2, 5] A...Ch. 9 - Prob. 10CRCTCh. 9 - Capital Budgeting Problems [LO1] What difficulties...Ch. 9 - Prob. 12CRCTCh. 9 - Modified Internal Rate of Return [LO6] One of the...Ch. 9 - Net Present Value [LO1] It is sometimes stated...Ch. 9 - Internal Rate of Return [LO5] It is sometimes...Ch. 9 - Calculating Payback [LO2] What is the payback...Ch. 9 - Calculating Payback [LO2] An investment project...Ch. 9 - Calculating Payback [LO2] Siva, Inc., imposes a...Ch. 9 - Calculating Discounted Payback [LO3] An investment...Ch. 9 - Calculating Discounted Payback [LO3] An investment...Ch. 9 - Calculating AAR [LO4] Youre trying to determine...Ch. 9 - Calculating IRR [LO5] A firm evaluates all of its...Ch. 9 - Calculating NPV [LO1] For the cash flows in the...Ch. 9 - Calculating NPV and IRR [LO1, 5] A project that...Ch. 9 - Calculating IRR [LO5] What is the IRR of the...Ch. 9 - Prob. 11QPCh. 9 - NPV versus IRR [LO1, 5] Garage, Inc., has...Ch. 9 - Prob. 13QPCh. 9 - Problems with IRR [LO5] Light Sweet Petroleum,...Ch. 9 - Prob. 15QPCh. 9 - Problems with Profitability Index [LO1, 7] The...Ch. 9 - Comparing Investment Criteria [LO1, 2, 3, 5, 7]...Ch. 9 - NPV and Discount Rates [LO1] An investment has an...Ch. 9 - MIRR [L06] RAK Corp. is evaluating a project with...Ch. 9 - Prob. 20QPCh. 9 - Prob. 21QPCh. 9 - Cash Flow Intuition [LO1, 2] A project has an...Ch. 9 - Payback and NPV [LO1, 2] An investment under...Ch. 9 - Prob. 24QPCh. 9 - NPV Valuation [LO1] The Yurdone Corporation wants...Ch. 9 - Problems with IRR [LO5] A project has the...Ch. 9 - Problems with IRR [LO5] McKeekin Corp. has a...Ch. 9 - Prob. 28QPCh. 9 - Prob. 1MCh. 9 - Prob. 2MCh. 9 - Bullock Gold Mining Seth Bullock, the owner of...
Knowledge Booster
Background pattern image
Finance
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
Text book image
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
Capital Budgeting Introduction & Calculations Step-by-Step -PV, FV, NPV, IRR, Payback, Simple R of R; Author: Accounting Step by Step;https://www.youtube.com/watch?v=hyBw-NnAkHY;License: Standard Youtube License