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

Du chapitre 7:

Now Playing

7.13 : Calculating Internal Rate of Return

Capital Budgeting

102 Vues

7.1 : Introduction to Capital Budgeting

Capital Budgeting

344 Vues

7.2 : Basics of Investment Decision-making

Capital Budgeting

192 Vues

7.3 : Importance of Capital Budgeting

Capital Budgeting

193 Vues

7.4 : Advantages and Limitations of Capital Budgeting

Capital Budgeting

486 Vues

7.5 : Capital Budgeting Techniques

Capital Budgeting

221 Vues

7.6 : Payback

Capital Budgeting

132 Vues

7.7 : Payback Period

Capital Budgeting

104 Vues

7.8 : Discounted Payback Period

Capital Budgeting

117 Vues

7.9 : Net Present Value

Capital Budgeting

479 Vues

7.10 : Net Present Value Method

Capital Budgeting

361 Vues

7.11 : Decision-making Through Net Present Value

Capital Budgeting

129 Vues

7.12 : Internal Rate of Return

Capital Budgeting

228 Vues

7.14 : Decision-making Through Internal Rate of Return

Capital Budgeting

99 Vues

7.15 : Average Rate of Return

Capital Budgeting

108 Vues

See More