JoVE Logo

Sign In

7.13 : Calculating Internal Rate of Return

The IRR is the discount rate that makes a project or investment's Net Present Value (NPV) equal to zero.

For instance, consider a renewable energy company evaluating a project that requires an initial investment of $200,000, with expected annual cash flows of $50,000 over the next six years.

To determine the IRR for this project, the NPV is computed for different rates on a trial-and-error basis using a financial calculator or an Excel spreadsheet.

  1. At a 10% discount rate, the NPV is $17,763, meaning the IRR can go higher than this.
  2. At a 12% discount rate, the NPV is approximately $5,570, which is still positive but close to zero. This suggests that the IRR is slightly higher than 12%.
  3. At a 13% discount rate, the NPV is—$122, which is negative and closer to zero and implies that the IRR is slightly lower.
  4. At a 12.978% discount rate, the NPV is zero, making it the correct internal rate of return for this investment.

Based on these projected cash flows, if the company proceeds with the investment, it can expect an annual return of 12.978%.

Tags

Internal Rate Of ReturnIRRNet Present ValueNPVDiscount RateRenewable Energy InvestmentCash FlowsFinancial CalculatorExcel SpreadsheetInvestment AnalysisAnnual Return

From Chapter 7:

article

Now Playing

7.13 : Calculating Internal Rate of Return

Capital Budgeting

71 Views

article

7.1 : Introduction to Capital Budgeting

Capital Budgeting

295 Views

article

7.2 : Basics of Investment Decision-making

Capital Budgeting

174 Views

article

7.3 : Importance of Capital Budgeting

Capital Budgeting

143 Views

article

7.4 : Advantages and Limitations of Capital Budgeting

Capital Budgeting

418 Views

article

7.5 : Capital Budgeting Techniques

Capital Budgeting

187 Views

article

7.6 : Payback

Capital Budgeting

112 Views

article

7.7 : Payback Period

Capital Budgeting

88 Views

article

7.8 : Discounted Payback Period

Capital Budgeting

95 Views

article

7.9 : Net Present Value

Capital Budgeting

318 Views

article

7.10 : Net Present Value Method

Capital Budgeting

208 Views

article

7.11 : Decision-making Through Net Present Value

Capital Budgeting

94 Views

article

7.12 : Internal Rate of Return

Capital Budgeting

206 Views

article

7.14 : Decision-making Through Internal Rate of Return

Capital Budgeting

81 Views

article

7.15 : Average Rate of Return

Capital Budgeting

92 Views

See More

JoVE Logo

Privacy

Terms of Use

Policies

Research

Education

ABOUT JoVE

Copyright © 2025 MyJoVE Corporation. All rights reserved