Financial Modeling Tutorials

- Financial Modeling Basics
- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- Sensitivity Analysis
- Capital Budgeting Techniques
- Time Value of Money
- Future Value Formula
- Present Value Factor
- Perpetuity Formula
- Present Value vs Future Value
- Annuity vs Pension
- Present Value of an Annuity
- Doubling Time Formula
- Annuity Formula
- Annuity vs Perpetuity
- Annuity vs Lump Sum
- Deferred Annuity Formula
- Internal Rate of Return (IRR)
- IRR Examples (Internal Rate of Return)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- NPV Profile
- NPV Examples
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Profitability Index
- Cash Burn Rate
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- CAGR Formula (Compounded Annual Growth Rate)
- Effective Interest Rate
- Loan Amortization Schedule
- Mortgage Formula
- Loan Principal Amount
- Interest Rate Formula
- Rate of Return Formula
- Effective Annual Rate
- Effective Annual Rate Formula (EAR)
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Rule of 72
- Geometric Mean Return
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- Average Rate of Return Formula
- Mean Formula
- Mean Examples
- Population Mean Formula
- Weighted Mean Formula
- Harmonic Mean Formula
- Median Formula in Statistics
- Range Formula
- Outlier Formula
- Decile Formula
- Midrange Formula
- Quartile Deviation
- Expected Value Formula
- Exponential Growth Formula
- Margin of Error Formula
- Decrease Percentage Formula
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Benefit Analysis Examples
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Opportunity Cost Examples
- Mortgage APR vs Interest Rate
- Normal Distribution Formula
- Standard Normal Distribution Formula
- Normalization Formula
- Bell Curve
- T Distribution Formula
- Regression Formula
- Regression Analysis Formula
- Multiple Regression Formula
- Correlation Coefficient Formula
- Correlation Formula
- Population Variance Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Standard Deviation Formula
- Volatility Formula
- Binomial Distribution Formula
- Quartile Formula
- P Value Formula
- Skewness Formula
- R Squared Formula
- Adjusted R Squared
- Regression vs ANOVA
- Z Test Formula
- F-Test Formula
- Quantitative Research

Related Courses

## IRR Examples (Internal Rate of Return)

The following IRR example provides an outline of the most common IRR Calculations. Here we list a few distinct examples to understand the applicability of the Internal Rate of Return method for evaluating the profitability of projects. Each example of IRR states the topic, the relevant calculations, and additional comments as needed

Internal rate of return is the rate which is used by management to take capital budgeting decisions while evaluating the profitability of prospective projects. It is calculated by equating the Net Present value to zero.

The formula to calculate the internal rate of return is:

Here N is the number of years of cash flows of the project & CF is the cash flow

### Examples of Internal Rate of Return (IRR)

The calculation for IRR can either be done manually by hit and trial method or by using the calculator or excel function of IRR. Below are some of the examples of Internal Rate of Return

4.9 (927 ratings)

#### IRR Example #1 – Project with Equal Cash Flows

Let’s consider a firm taking up a solar energy project i.e. replacing all its electrical power needs with solar power. The firm needs to make an initial cash outflow or investment of $100,000 for purchasing and installing the solar panels. Assuming that the project generates a cash inflow of $30,000 for the first 5 years in the form of saving electricity bill payments as per below table i.e. a total of $150,000 cash inflow. The calculation for IRR would be simply based on the above formula, which in this case comes out to be 15%. We can interpret this as an annualized profit of doing the project while also having considered the present values of future cash flows.

**Solution:**

The calculation of Internal Rate of Return can be done as follows-

**Internal Rate of Return=15%**

#### IRR Example #2 – Project with Uneven Cash Flows

Let’s reconsider the above example, with slightly higher overall cash inflow of $155,000 but unevenly distributed in different years due to maintenance costs in the first 4 years. The cash flows are as per below table. The IRR for this setup comes out to be 14% which is lower than the above example even when the overall cash inflow is more in this case. This illustrates that not only a project’s cash flows but also their timing play an important role when considering the present values of future cash flows for evaluating.

**Solution:**

The calculation of Internal Rate of Return can be done as follows-

**Internal Rate of Return =14%**

#### IRR Example #3 – Mutually Exclusive Projects

Let’s consider a situation where the management needs to choose any one project in between the two prospective projects as they are mutually exclusive. Assuming that a manufacturing company plans to increase its product line offering and has two options: product A and product B, out of which only one can be implemented due to limitations of the production facility. The cash flows of the two projects are as per below table. The investment for both the projects are the same but the cash inflow is different, Product A gives the bigger cash flows in the early years while B gives the bigger ones in the later years. The IRR of the project appears to highlight Product A as the more desirable one.

**Solution:**

The calculation of IRR can be done as follows-

**Internal Rate of Return =29% and 26%**

However, if there are other constraints that need to be considered as the cost of capital then the results might change. Let’s take a look at different scenarios with varying cost of capital and their results with the NPV method.

It is evident here that if the cost of capital is equal or below 10%, Product B is more desirable contradicting the results found by IRR. This happens because at lower interest rates the present values of cash flows appearing at the later stages are less penalized than at higher interest rates.

This discrepancy in the IRR method can be addressed by calculating incremental IRR i.e. finding the IRR of the extra cash flow of one project over the other. Like in this case as per below table:

**Incremental IRR =11%**

As per the above calculated incremental IRR of the differential cash flow of ‘A’ over ‘B’, we can conclude that if the cost of capital or interest rate is more than 11%, then choose ‘A’ otherwise ‘B’.

#### Example #4 – Multiple IRR

To understand this scenario let us consider a project which requires investment not only at the initial stage but also in the middle or the end. Assuming a mining company taking up a coal mining project which requires digging up the land to access the coal under it, here the company will have to invest money for digging in the beginning and then once the coal starts coming out there will be cash inflows for 5 years straight by selling it, then finally once all the coal has been extracted it needs to restore the land to its original condition by filling up soil which would again require some investment.

**Solution:**

The calculation of Internal Rate of Return can be done as follows-

The cash flows of the project are as per below table:

Since the IRR for this project gives two values: -6% & 38% it is difficult to evaluate the project using this method as it is unclear as to which IRR should be considered. Hence it is more convenient to use NPV over IRR to evaluate such projects that change the direction of cash flows more than once.

Based on the above examples we can say that on one hand IRR is a simple method and is easily interpretable while also considering the time value of money on the other hand sometimes it gives ambiguous results like in the case of multiple IRRs where other methods like NPV seem to be more appropriate and reliable. So depending on the nature of the project and its cash flows the IRR method provides an easy and quick way of evaluating.

**For the detailed calculation of IRR, you can download the Excel template here – IRR Examples Excel Template**

### Recommended Articles

This has been a Guide to IRR Examples. Here we discuss the Top 4 IRR Calculation examples along with detailed explanation and downloadable excel template. You may learn more about accounting from the following articles –

- Examples of Capital Budgeting Decisions
- Importance of Capital Budgeting – Top 10
- Top 5 Capital Budgeting Techniques (with Examples)
- Examples of Capital Budgeting Techniques
- NPV Profile
- NPV vs IRR
- Incremental IRR
- XIRR Excel Function
- MIRR Function

- 35+ Courses
- 120+ Hours of Videos
- Full Lifetime Access
- Certificate of Completion

- Basic Microsoft Excel Training
- MS Excel 2010 Training Course: Advanced
- Microsoft Excel Basic Training
- Microsoft Excel 2013 – Advanced
- Microsoft Excel 2016 – Beginners
- Microsoft Excel 2016 – Advanced

## Leave a Reply