7. IRR (S5.3) Calculate the IRR (or IRRS) for the following project: Co C1 +3,500 -3,000 For what range of discount rates does the project have a positive NPV? C₂ +4,000 C3 -4,000

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
### Calculating the Internal Rate of Return (IRR)

#### Example Problem on IRR Calculation:

#### Problem Statement:
Calculate the IRR (or IRRs) for the following project:

#### Cash Flow Schedule:
| C<sub>0</sub>  | C<sub>1</sub>  | C<sub>2</sub>  | C<sub>3</sub>  |
|---------------|---------------|---------------|---------------|
| -3,000        | +3,500        | +4,000        | -4,000        |

#### Question:
For what range of discount rates does the project have a positive NPV?

#### Explanation:
- **Initial Investment (C<sub>0</sub>)**: -3,000
- **Cash Flow in Year 1 (C<sub>1</sub>)**: +3,500
- **Cash Flow in Year 2 (C<sub>2</sub>)**: +4,000
- **Cash Flow in Year 3 (C<sub>3</sub>)**: -4,000

#### Steps to Calculate IRR:
1. Formulate the Net Present Value (NPV) equation for the given project.
2. Set the NPV equation to zero and solve for the discount rate 'r', which is the IRR.

#### NPV Equation:
\[ NPV = \left( -3,000 \right) + \frac{3,500}{(1+r)^1} + \frac{4,000}{(1+r)^2} + \frac{-4,000}{(1+r)^3} \]

Solve the equation for 'r' to find the IRR.

#### Range of Discount Rates for Positive NPV:
Once the IRR is determined, the range of discount rates for which the project has a positive NPV can be discussed. Generally, the project will have a positive NPV for discount rates less than the calculated IRR.
Transcribed Image Text:### Calculating the Internal Rate of Return (IRR) #### Example Problem on IRR Calculation: #### Problem Statement: Calculate the IRR (or IRRs) for the following project: #### Cash Flow Schedule: | C<sub>0</sub> | C<sub>1</sub> | C<sub>2</sub> | C<sub>3</sub> | |---------------|---------------|---------------|---------------| | -3,000 | +3,500 | +4,000 | -4,000 | #### Question: For what range of discount rates does the project have a positive NPV? #### Explanation: - **Initial Investment (C<sub>0</sub>)**: -3,000 - **Cash Flow in Year 1 (C<sub>1</sub>)**: +3,500 - **Cash Flow in Year 2 (C<sub>2</sub>)**: +4,000 - **Cash Flow in Year 3 (C<sub>3</sub>)**: -4,000 #### Steps to Calculate IRR: 1. Formulate the Net Present Value (NPV) equation for the given project. 2. Set the NPV equation to zero and solve for the discount rate 'r', which is the IRR. #### NPV Equation: \[ NPV = \left( -3,000 \right) + \frac{3,500}{(1+r)^1} + \frac{4,000}{(1+r)^2} + \frac{-4,000}{(1+r)^3} \] Solve the equation for 'r' to find the IRR. #### Range of Discount Rates for Positive NPV: Once the IRR is determined, the range of discount rates for which the project has a positive NPV can be discussed. Generally, the project will have a positive NPV for discount rates less than the calculated IRR.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 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