How do you calculate IRR in Excel?

Excel has two IRR functions. Use =IRR(values) for annual cash flows at regular intervals; include the initial investment as a negative number in the range. Use =XIRR(values, dates) for irregular cash flow timing, which is more accurate for real estate deals. For modified IRR, use =MIRR(values, finance_rate, reinvest_rate) with separate rates for borrowing and reinvestment.

How do you calculate IRR manually without Excel?

Use the interpolation method: (1) Find a discount rate that gives positive NPV. (2) Find a rate that gives negative NPV. (3) Apply: IRR = r_low + [NPV_low / (NPV_low - NPV_high)] x (r_high - r_low). Example: at 15%, NPV = +$48,000; at 20%, NPV = -$27,000. IRR = 15% + [48/(48+27)] x 5% = 18.2%.

How do you calculate IRR on a financial calculator?

On the BA II Plus: Press CF, enter CF0 as negative, press Enter and the down arrow, then enter each cash flow and frequency. After all flows, press IRR then CPT. On the TI-84: use APPS > Finance > IRR and enter the initial investment and a list of cash flows. Both use the same iterative algorithm.

What is a good IRR for real estate?

Core stabilized real estate targets 8-12% IRR. Value-add investments target 15-18%. Opportunistic and development deals target 18-25%+. Single-family rentals typically target 10-16%. The relevant benchmark is your cost of capital and the risk of the deal, not an absolute number.

What is the difference between IRR and NPV?

IRR is a percentage that tells you the annualized return rate of an investment. NPV is a dollar amount that tells you how much value an investment adds at a specific discount rate. IRR does not require you to assume a discount rate upfront, but it can give misleading results when comparing investments of different sizes. NPV is more reliable for sizing decisions: a 20% IRR on a $50,000 investment creates less value than a 15% IRR on a $500,000 investment. Use both together for investment decisions.

Finance & Investment

IRR Calculator 2026

Free · No signup

Newton-Raphson IRR method

NPV at any discount rate

IRR & NPV CalculatorFree · No signup

Initial Investment (Year 0)

Entered as positive (treated as outflow)

Discount Rate for NPV (%)

Annual Cash Flows (Year 1 onward)

Year

Cash Flow ($)

IRR Calculation Formula: Newton-Raphson Method, Manual Interpolation, and a Worked Example

Internal Rate of Return is the discount rate that makes Net Present Value equal to zero across all cash flows. There is no closed-form algebraic solution for most cash flow series, so IRR is solved iteratively. This calculator uses the Newton-Raphson method, which converges to 8 decimal places in most cases.

The IRR Formula

0 = CF0 + CF1/(1+r) + CF2/(1+r)^2 + ... + CFn/(1+r)^n
Solve for r using Newton-Raphson iteration
r_next = r - NPV(r) / NPV'(r)
Repeat until |r_next - r| < 0.00000001

Manual Interpolation Method

For a quick estimate without a computer, use the interpolation method:

Calculate NPV at a low rate

Try 10% or 15%. If NPV is positive, your IRR is above this rate.

Calculate NPV at a high rate

Try 20% or 25%. If NPV is negative, IRR falls between the two rates.

Interpolate

IRR = r_low + [NPV_low / (NPV_low - NPV_high)] x (r_high - r_low)

Narrow the range for precision

Repeat with rates closer together until the estimate is accurate enough.

Worked Example: Rental Property Acquisition

You buy a rental property for $500,000. It generates $80K-$110K in annual cash flows over 5 years and you sell for $650,000 in Year 6 (included in the Year 6 cash flow).

Year 0: -$500,000  (purchase)
Year 1:  +$80,000  (net income after expenses)
Year 2:  +$90,000
Year 3:  +$95,000
Year 4: +$100,000
Year 5: +$110,000
Year 6: +$650,000  (sale proceeds + final year income)
IRR: approximately 18.4%
At 15%: NPV = +$48,000  |  At 20%: NPV = -$27,000
Interpolated: 15% + [48/(48+27)] x 5% = 18.2%  (exact: 18.4%)

Decision Rule

Accept a project if IRR exceeds your required rate of return (hurdle rate). If your cost of capital is 10% and the IRR is 18.4%, the investment adds value. NPV at 10% is positive. If IRR falls below your hurdle rate, NPV is negative and the project destroys value relative to alternatives.

How to Calculate IRR in Excel: IRR, XIRR, and MIRR

Excel offers three IRR functions. Choosing the right one matters more than most people realize, particularly for real estate and private equity deals where cash flows do not fall cleanly at year-end.

=IRR(values, [guess])  - annual cash flows at equal intervals
e.g. =IRR(B1:B7)  where B1 = -500000, B2:B7 = annual inflows
=XIRR(values, dates, [guess])  - irregular timing
e.g. =XIRR(B1:B7, C1:C7)  (more accurate for real deals)
=MIRR(values, finance_rate, reinvest_rate)  - modified IRR
e.g. =MIRR(B1:B7, 8%, 5%)  (separate rates for borrowing and reinvesting)

MIRR corrects a known flaw in standard IRR: the assumption that interim cash flows are reinvested at the same IRR rate. A deal returning 25% IRR does not mean you will reinvest those distributions at 25%. MIRR uses a realistic reinvestment rate (typically 5-8%) and is more conservative. Use MIRR when comparing projects with very different cash flow timing or when early distributions are large.

For most residential real estate models, =IRR works fine. For commercial deals with irregular closing dates and capital calls, =XIRR is the right choice.

IRR Calculation Table: How NPV Changes at Different Discount Rates

The table below shows how NPV changes as the discount rate increases for the default example ($500K investment, $80K-$110K annual cash flows, $650K exit in Year 6). IRR is the rate where NPV crosses zero.

Discount Rate	NPV	Decision
5%	+$390,000	Accept
10%	+$189,000	Accept
15%	+$48,000	Accept
18.4% (IRR)	$0	Breakeven
20%	-$27,000	Reject
25%	-$130,000	Reject

Building this table by hand is exactly how manual IRR interpolation works: find two rates that straddle zero NPV, then interpolate. At 15%, NPV is +$48K. At 20%, NPV is -$27K. Interpolated IRR = 15% + [48/(48+27)] x 5% = 18.2%, close to the exact 18.4%.

IRR Calculator for Real Estate: Annual Cash Flows, Debt Service, and Exit Value

Real estate IRR models have three components: the initial acquisition cost (Year 0 outflow), annual net operating income minus debt service (Years 1+), and sale proceeds minus selling costs in the exit year. Getting the annual cash flows right requires accurate NOI. Use the Cap Rate Calculator to determine your property's income before running the IRR model.

IRR by Real Estate Strategy

Strategy	Target IRR	Typical Hold
Core (stabilized, low risk)	8-12%	7-10 years
Core-Plus	10-14%	5-7 years
Value-Add	15-18%	3-5 years
Opportunistic / Development	18-25%+	2-4 years
Single-Family Rental (SFR)	10-16%	5-10 years

IRR models equity return after debt service, not property-level return. Subtract your annual mortgage payments from NOI to get each year's cash flow. Use the Commercial Mortgage Calculator to find annual debt service, then subtract it from each year's NOI before entering it above. For deals where lenders require income coverage analysis, the DSCR Loan Calculator shows whether your NOI is sufficient to qualify for the loan.

IRR vs NPV: How to Use Both Metrics to Evaluate an Investment

IRR and NPV answer different questions. IRR tells you the annualized return rate, which is easy to compare to a hurdle rate or benchmark. NPV tells you the total dollar value added at a specific cost of capital. They often agree on whether to accept or reject a project, but they can conflict when comparing investments of different sizes or cash flow timing.

Question	Use IRR	Use NPV
Does this beat my hurdle rate?	Yes, compare directly	Indirectly (positive NPV = yes)
Which investment creates more wealth?	Can mislead on different sizes	NPV is the right metric
Comparing investments of unequal size?	Use with caution	More reliable
Communicating return to investors?	Standard for fund reporting	Less intuitive for most
Irregular cash flow timing?	Use XIRR variant	Discount at any rate

A 25% IRR on a $50,000 investment produces $12,500 in Year 1 profit. A 15% IRR on a $500,000 investment produces $75,000. The larger deal creates six times the wealth despite the lower percentage return. When capital allocation matters, always run NPV alongside IRR before making a final decision.

Common Mistakes to Avoid

Entering the initial investment as a negative number

This calculator treats the initial investment as a negative cash flow automatically. If you enter -$500,000, the calculator inverts it to +$500,000, which produces a completely wrong IRR.

Forgetting to include the terminal sale value

For real estate and business investments, the exit sale proceeds are the largest cash flow. Leaving them out dramatically understates IRR. For a property held 5 years, the exit often represents 70-80% of total cash returned.

Confusing IRR with annual cash return

IRR is an annualized return that accounts for time value of money and the return of capital. A 15% IRR does not mean you receive 15% of your investment as cash each year.

Using IRR alone to compare unequal-sized investments

A 25% IRR on a $50,000 investment and a 20% IRR on a $500,000 investment produce very different wealth outcomes. Always compare NPV alongside IRR when evaluating investment sizing decisions.

Ignoring negative interim cash flows

Renovation costs, vacancy periods, and capital calls are negative cash flows that belong in the model. Omitting them inflates IRR and makes the investment look better than it actually is.

Frequently Asked Questions

IRR is the discount rate r that satisfies: 0 = CF0 + CF1/(1+r) + CF2/(1+r)^2 + ... + CFn/(1+r)^n. There is no algebraic solution for most cash flow series, so IRR is found by iteration. The Newton-Raphson method is the standard approach: start with a guess, calculate NPV and its derivative, then adjust the rate until NPV converges to zero. Most solvers converge within 20-50 iterations.

From Our Blog

IRR Calculator: How to Calculate Internal Rate of Return (2026)

IRR formula, rental property worked example, MIRR correction, and when IRR produces misleading results.

11 min read

Cap Rate vs IRR: Real Estate Return Metrics Explained (2026)

Cap rate measures a property's income yield today. IRR captures total return including leverage, appreciation, and timing.

12 min read

More Finance Calculators

Sources & References

Investopedia: Internal Rate of Return (IRR) ↗

Reference for IRR and NPV definitions, the Newton-Raphson calculation method, and the limitations of IRR including the multiple IRR problem.

CFA Institute: Fixed Income and Equity Analysis Study Materials ↗

Source for the professional application of IRR in investment analysis, including how IRR relates to MIRR and when each measure is appropriate.

Damodaran, Aswath: Investment Valuation and Valuation Data ↗

Reference for how IRR is applied in real estate and business valuation, including the relationship between IRR, NPV, and cost of capital in capital budgeting decisions.

Hassaan Rasheed

Developer and Researcher, CalculatorFlux

Researches and verifies the formulas, methodology, and source data behind each calculator on CalculatorFlux. All tools are built and checked against the cited references before publication.

Last updated: June 2026

IRR Benchmarks

Investment Type	Target IRR
Core real estate	8-12%
Value-add real estate	15-18%
Opportunistic real estate	18-25%
Buyout private equity	20-25%
Venture capital	25-35%
S&P 500 (long-run avg)	~10%

Pro Tip

Model two exit scenarios: selling at year 5 vs year 10. Long holds with low early cash flows often produce lower IRRs than shorter holds even if total profit is higher, because IRR penalizes slow returns. Total equity multiple and IRR together give a more complete picture.

Browse Categories

Payroll & Tax

50+

Construction & Materials