Internal Rate of Return Calculator

Calculate your investment's profitability with our free, easy-to-use IRR calculator

Regular IRR
Fixed IRR

Use this calculator for investments with different cash flows in each period.

Enter as a positive value (e.g., 10000 for a $10,000 investment)
Format: (Cash Flow Amount) * (Number of Periods)
* periods
Enter cash flow amount and number of periods for each cash flow
Each period equals months
Enter the number of months for each period (e.g., 12 for yearly, 1 for monthly, 3 for quarterly)

How to use this option:

If your investment is "interest-only" (principal repaid at the end), check this box. If cash flows already include principal repayments, leave it unchecked.

Use this calculator for investments with the same cash flow amount in each period (annuity).

Enter as a positive value (e.g., 10000 for a $10,000 investment)
Enter the same cash flow amount for each period
Enter the total number of periods
Each period equals months
Enter the number of months for each period (e.g., 12 for yearly, 1 for monthly, 3 for quarterly)

How to use this option:

If your investment is "interest-only" (principal repaid at the end), check this box. If cash flows already include principal repayments, leave it unchecked.

Your Investment Results
Ready when you are!
IRR: Ready when you are!

Higher rates indicate more profitable investments

Quick Start Guide

1 Choose Calculator

Select "Regular IRR" for varying cash flows or "Fixed IRR" for equal cash flows.

2 Enter Details

Input your initial investment and cash flow information.

3 Set Options

Specify period length and principal repayment option.

4 Calculate

Click "Calculate IRR" and evaluate the result.

Understanding IRR: A Complete Guide

What is Internal Rate of Return (IRR)?

The Internal Rate of Return (IRR) is a financial metric used to estimate the profitability of potential investments. It represents the discount rate that makes the net present value (NPV) of all cash flows equal to zero in a discounted cash flow analysis.

In simpler terms, IRR is the annualized effective compounded return rate which can be expected from an investment. It's expressed as a percentage and helps investors compare different investment opportunities.

Why is IRR Important?

  • Investment Comparison: IRR allows you to compare the profitability of different investments regardless of their size or duration.
  • Decision Making: Projects with an IRR higher than the required rate of return are generally considered good investments.
  • Benchmarking: IRR provides a standardized way to evaluate investment performance.

IRR Formula

The IRR is calculated by finding the discount rate (r) that satisfies the following equation:

NPV = Σ [Ct / (1 + r)t] = 0

Where:
Ct = Net cash inflow during period t
r = Discount rate (IRR)
t = Time period

This formula sets the Net Present Value (NPV) of cash flows to zero and solves for the discount rate (r), which is the IRR.

How to Calculate IRR

  1. Identify Cash Flows: List all cash flows associated with the investment, including the initial investment (usually negative) and subsequent returns (positive).
  2. Determine Time Periods: Assign time periods to each cash flow (typically years).
  3. Apply the Formula: Use the IRR formula or financial calculator to find the rate that sets NPV to zero.
  4. Interpret Results: Compare the IRR to your required rate of return or other investment options.

IRR Example

Let's say you're considering an investment that requires an initial outlay of $10,000 and is expected to generate the following cash flows:

Year Cash Flow
0 -$10,000
1 $3,000
2 $4,000
3 $5,000
4 $6,000

Using our calculator above, the IRR for this investment is 14.49%. This means the investment is expected to generate an annualized return of 14.49%.

Limitations of IRR

  • Assumption of Reinvestment: IRR assumes that all cash flows are reinvested at the same rate as the IRR, which may not be realistic.
  • Multiple IRRs: Some cash flow patterns can produce multiple IRRs, making interpretation difficult.
  • Scale Ignorance: IRR doesn't consider the size of the investment, so a small project with a high IRR might be less valuable than a larger project with a lower IRR.

Frequently Asked Questions

What is a good IRR?

A "good" IRR depends on the industry, risk level, and opportunity cost of capital. Generally, an IRR that exceeds the company's cost of capital or hurdle rate is considered acceptable. For example, if a company's cost of capital is 10%, an IRR of 13% would be favorable.

How does IRR differ from ROI?

Return on Investment (ROI) measures total growth from start to finish without considering time periods, while IRR accounts for the time value of money and provides an annualized rate of return. IRR is more precise for evaluating long-term investments.

Can IRR be negative?

Yes, a negative IRR indicates that the investment is expected to lose money. This happens when the total cash inflows are less than the initial investment.

When should I use IRR vs NPV?

NPV is generally preferred for comparing projects of different sizes because it shows absolute dollar value. IRR is useful for comparing projects of similar size or when communicating results to stakeholders who prefer percentages.

What's the difference between Regular IRR and Fixed IRR?

Regular IRR is used when cash flows vary from period to period. Fixed IRR is used when the same cash flow amount is received in each period (annuity). Fixed IRR is simpler to calculate and is common in cases like bond investments or equal annual dividends.

How does the period type affect the IRR calculation?

When using custom period lengths, the IRR calculation gives a rate for that specific period. To make it comparable to annual rates, we annualize it using the formula: (1 + period_rate)^(12/months_per_period) - 1. This allows you to compare investments with different cash flow frequencies.

What does "Principal Repayment at Maturity" mean?

This option is for investments where only interest payments are made during the term, with the full principal repaid at the end (like bonds). If checked, the calculator automatically adds the principal as a final cash flow. If your cash flows already include principal repayments, leave this unchecked.

Why is my calculated IRR negative?

A negative IRR indicates that your investment is expected to lose money. This can happen for several reasons:

Example: If you invest $10,000 and only receive $8,000 in total returns over several years, your IRR will be negative, indicating a loss.

How do I calculate IRR?

To calculate IRR manually, you need to solve for the discount rate that makes the net present value (NPV) of all cash flows equal to zero. Our free online IRR calculator simplifies this complex calculation. For manual calculations, you can use the formula: NPV = Σ [Ct / (1 + r)^t] = 0, where Ct is the cash flow at time t and r is the IRR. You can calculate IRR using our free calculator tool above, or by using financial calculators, Excel (using the IRR function), or manual calculations for simple cash flows. The easiest method is to use our online IRR calculator which provides instant results. IRR is calculated by finding the discount rate that sets the Net Present Value (NPV) of cash flows to zero. The mathematical formula is: NPV = Σ [Ct / (1 + r)^t] = 0. This requires iterative calculations which our calculator performs automatically.

How to calculate IRR in Excel?

To calculate IRR in Excel, use the =IRR() function. Simply enter your cash flows in a column (with initial investment as a negative value) and use the formula =IRR(range_of_cash_flows). For more complex scenarios, you can use the =XIRR() function for irregular cash flows. Make sure to include the initial investment as the first value in your cash flow series. This is the same method as our how to calculate IRR in Excel guide, but specifically focused on the Excel application. For irr calculation in Excel, this method is widely used by financial professionals.

Calcul irr

Calcul irr (Internal Rate of Return calculation) is a financial method used to evaluate the profitability of investments. Our irr calculator tool helps you determine the rate of return for a series of cash flows. The calcul irr is essential for investment analysis and decision making. When calculating irr or doing an irr calculation, this approach provides valuable insights into investment performance.

How to find IRR on financial calculator?

To calculate IRR on a financial calculator, you need to input all cash flows including the initial investment (as a negative value) and then use the IRR or CF (Cash Flow) function. The exact steps vary by calculator model, but generally involve: 1) Clearing previous cash flows, 2) Entering the initial investment, 3) Entering subsequent cash flows, 4) Computing the IRR. Finding IRR on financial calculators typically involves using the cash flow (CF) function. Enter all cash flows including the initial investment, then use the IRR computation function. Most financial calculators have a dedicated IRR button or it's accessed through the cash flow menu. Refer to your calculator's manual for specific key sequences.

How to calculate IRR on BA II Plus?

To calculate IRR on a BA II Plus financial calculator: 1) Press CF to enter cash flow mode, 2) Clear previous data with 2nd CLR WORK, 3) Enter initial investment as a negative value using +/- key, 4) Enter subsequent cash flows, 5) Press IRR then CPT to compute the result. This specialized calculator is widely used by finance professionals for IRR calculations and other financial computations.