Whats the best way to do an IRR calc in your head? is there a simple calculation and relationship when you think about initial investment, sale price and time period? just for back of envelope calcs when youre sitting in a meeting or an interview.

thank you

### How To Calculate Internal Rate of Return

The following is a brief refresher on IRR.*From the Wall Street Oasis Finance Dictionary*

Internal Rate of Return or IRR is a financial metric used to discount capital budgeting and to make the net present value of all future cash flows equal to zero. For this reason, it is used alongside a Discounted Cash Flow analysis.

Calculating IRR cannot be calculated by hand unless you use a trial and error method to until you reach a solution in which net present value equals zero. Otherwise, you will need a special calculator or a program like Microsoft Excel. However, you can estimate IRR by memorizing simplified outputs of an IRR table.

### How to Estimate IRR

The following is an introduction to estimating IRR by certified user @Marcus_Halberstram", an industry CEO. Once you understand the concept you can memorize the internal rate of return table below. Then you will be able to estimate IRR off of the top of your head!

The best way to approximate IRR is by memorizing simple IRRs.

- Double your money in 1 year, IRR = 100%
- Double your money in 2 years, IRR = 41%; about 40%
- Double your money in 3 years, IRR = 26%; about 25%
- Double your money in 4 years, IRR = 19%; about 20%
- Double your money in 5 years, IRR = 15%; about 15%
That's really all you need to know. So if you 1.5x you money in 2 years, you know that if you double your money in 2 years its a 40% return and if you only get your initial investment after 2 years, its a 0% return... mid-point of 0% and 40% is 20%... so your IRR is roughly 20%... now take into account that the 0% return scenario doesn't include any compounding... so you need to upwardly adjust that 20% figure... so make it 21 or 22%. Just did the IRR calc, what does it come out to? 22%.

No one expects you to be able to nail an IRR number in your head. But if you can get pretty close, you're fine.

### IRR Table

**X Axis: Number of Years****Y Axis: Multiple**

1 Year | 2 Years | 3 Years | 4 Years | 5 Years | |
---|---|---|---|---|---|

1 | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% |

2 | 100.0% | 41.4% | 26.0% | 18.9% | 14.9% |

3 | 200.0% | 73.2% | 44.2% | 31.6% | 24.6% |

4 | 300.0% | 100.0% | 58.7% | 41.4% | 32.0% |

5 | 400.0% | 123.6% | 71.0% | 49.5% | 38.0% |

View the full table at http://willprice.blogspot.com/2007/06/irr-multipli...

**Recommended Reading**

- Unlevered and Levered IRR for Real Estate
- Relationship Between Cap Rate Discount Rate and NPV
- What is Internal Rate of Return?

#### Interviewing for Private Equity Jobs?

Want to land at an elite private equity fund try our comprehensive PE Interview Prep Course. Our course includes 2,447 questions across 203 private equity funds that have been crowdsourced from over 500,000 members. The WSO Private Equity Interview Prep Guide has everything you'll ever need to land the most coveted jobs on Wall Street.

## Comments (51)

First, guesstimate IRR in your head. than pick a number lower than this presumed IRR and discount the cashflows, see what NPV you get. Send, pick another number, higher than your presumed IRR and discount the cashflows, note the NPV you get. Now you have to discount rates and 2 coresponding NPVs - you can linearly extrapolate this for NPV=0 and see what discount rate that yields. It will be a reasonable approximation of the IRR.

that must be a joke, whats the diff btwn running an NPV and an IRR calc in your head? seriously

someone has GOT to be most useful than that

Say you have a project that pays

t=0: -1000

t=1: 100

t=2: 1000

Can you guess or calculate the IRR in your head? I can't.

But NPV for d=0% is 100, and NPV for d=10% is -110 (100/1.1 is about 90, 1000/1.21 is about 800). Based on this I'd guess the IRR is about 5%. It so happens that it is exactly 5% in this example, but that doesn't matter.

If you find a better method please share.

Alright, I'll take a crack at the back-of-the-envelope approach. Take sale proceeds / initial investment in your head. Let's say that comes to 2.5. Take an approximate nth-root of that (e.g.. 5 year period, 5th root) and subtract 1.

Or, alternatively, calc some ballpark #s at some point and memorize them so you don't have to do the hard math - e.g. 2.5x = 20% for 5 years, etc.

I have just the academic paper you need to solve this problem. PM me.

After reading this puppy you will be able to work it out in your head in a matter of seconds.

Can you please send that to me as well?

tandaradei - your method would be needed for projects with more than 2 cash flows, but most IRR calcs are simply entry and exit from a sponsor's perspective (at least in theory). As such, you can simplify the calculation a bit...

IRR Multiplication Table(Originally Posted: 06/20/2007)When you are on the phone you can impress your friends/boss by quickly reeling off the IRR on a 5x over 5 years (38%), 10x over 6 years (46.8%), 3x over 3 years (44.2%) etc.

http://willprice.blogspot.com/2007/06/irr-multipli...

Marijuana leads to Doritos, not harder drugs.

Useful tool, yes. But being able to convert IRR to money multiple is about as impressive as being able to say that 100 / 10 = 10. Use it because the monkey in the next cube is using it, but don't get fooles that this will impress.

"Living the dream 24/7 on http://theallnighter.blogspot.com"

"LIVING THE DREAM 24/7 ON http://THEALLNIGHTER.BLOGSPOT.COM"

tandaradei thats a stupid approach. Primarily because you're guestimating the IRR to begin with... if you can guetsimate the IRR why would you need to go through your way of calculating NPV twice and triangulating what the actual IRR is?

In addition to that, your example is created to make NPV calculation easy. How about this...

CF0= -360

CF1= 0

CF2 = 0

Cf3 = 720

Discount rate is 7%

Do that NPV in your head and triangulate the IRR for me. Then change your discount rate and re-calculate in your head.

The best way to approximate IRR is by memorizing simple IRRs.

Thats really all you need to know. So if you 1.5x you money in 2 years, you know that if you double your money in 2 years its a 40% return and if you only get your initial investment after 2 years, its a 0% return... mid-point of 0% and 40% is 20%... so your IRR is roughly 20%... now take into account that the 0% return scenario doesn't include any compounding... so you need to upwardly adjust that 20% figure... so make it 21 or 22%. Just did the IRR calc, what does it come out to? 22%.

No one expects you to be able to nail an IRR number in your head. But if you can get pretty close, you're fine.

Mental calculation of IRR(Originally Posted: 10/12/2014)I heard from a friend that in his interview, he got asked to calculate the IRR of an investment.

Assume initial investment is 100. Annual cash flow is 50. Exit after 7 years at 110.

How do you calculate the IRR for that in your head?

Pretty easy to do since the cash flow is constant and there is only a small gain on exit. They're not looking for an exact answer but a close approximation during interviews.

Think about it in terms of the yield you earn annually. You are getting $50 on a $100 investment, which is a 50% return annually. When you exit, you are making a small gain of $10 which would boost IRR just a tad higher. You could estimate IRR around 51 or 52%.

Thanks for the reply. I'm still not understanding how you got to an estimate of 51% - 52% though. In general, if the exit price is low and the number of years is 5 - 7, can you just assume the % is the same value as the cash flow?

I think I'm just stuck mathematically because I don't know how to work out the effect of the discount rate, especially when there are powers involved...

Then it would be ~20%.

As NorthSider mentioned, I think you may be confusing discount rates/DCF with IRR calculations. I'd recommend that you read into the basics of the LBO, specifically how one is structured/modeled, as this will probably better help you understand how the returns (IRR) are calculated and how the cash flow amount and timing will impact IRR.

Thanks for the reply. I will do that.

So just as a general rule, if the cash flow is 60 and the exit value is negligible, a close approximation of the IRR is 60%? Does this also apply if the time horizon is shorter or longer than 7?

You need to figure out the exit and entry equity values (you assume you're an investor). Then you figure out the IRR using the formula IRR = (FV/PV)^(1/years)-1. As NorthSider said, this formula allows you to find the discount rate at which the present value of all future cash flow is equal to the initial investment, i.e. if you rearrange the above formula, you get the formula to calculate future value: FV = PV*(1+IRR)^years. Since finding the nth root of a number is pretty tough to do in your head, most people just memorize an IRR table. Google these or simply use the formula above to create your own Excel version. Then memorize the 4-7 year columns.

For this case, assuming you're talking about equity values, you have +350 gain in equity from cash flow and +10 gain from multiple expansion. Thus, your exit equity is 460. Your multiple on invested capital is 4.6x, so your IRR formula should be 4.6^(1/7)-1. An IRR table will tell you that at 7 years, 4x MOIC is ~22% and 5x MOIC is ~26%, so you can approximate to ~24%. If you actually calculate this out, it comes out to 24.3%.

But isn't (FV/PV)^(1/years)-1 the formula for CAGR which isn't the same as IRR if there are interim cash flows.

This is not correct.

The formula you are using is a shortcut that assumes all equity proceeds are received at exit. This shortcut can be relevant for a back-of-the-envelope IRR calculation for an LBO where we assume all interim cash flows received are swept to pay down debt.

But this is not the case here. We are receiving $50 equity cash flows every year until maturity. The IRR is 50.31% as stated above. Calculate yourself using the IRR function in excel if you don't believe.

OP, be careful when using the CAGR function to estimate IRR if there are interim cash flows. There is a massive difference between a 50% IRR and 24%.

Very fair - and I definitely agree that the paper LBO method is much more common in interviews.

OP I don't know how to else to put it. If you gave me $100 and I offered to give you $50 in return every year what is your return? Ignore the $10 gain on exit. Let's say you invested in a bond. The bond is at par and you pay $100 for it. It pays you $50 annually until maturity. What would you say the interest rate on that bond is? 50%. It doesn't matter how long the maturity of the bond would be. The interest rate would always be 50%. Another way to think about it was mentioned above - what discount rate equates the future cash flows to the PV? 100 = 50 / x , solve for x = .50

Sometimes it's easier to think of IRR conceptually as an equivalent interest rate. So let's say you are valuing an LBO. Let's say it costs $1 billion to acquire the company and after 5 years you calculate an expected IRR of 20% (forget about cash flows received and exit price for now - all that matters is it returns 20%). Another way to think of that 20% is the rate you would require to be indifferent between two investments. So if you had the opportunity to invest that $1 billion today in a bond with equivalent maturity at a 20% interest rate, you would be indifferent towards buying the company or investing in the bond.

So in this case because the cash flow is constant, every year, calculating IRR is as easy as pretending it were a fixed income investment and determining what the interest rate would be.

You would not be able to use this as a shortcut if the cash flows were uneven. If CF in year 1 was $50, but then year 2 CF was $20, and then in year 3 CF was $40, etc. you would have to solve for this using excel or a financial calculator. You could set up the equation by hand but it would be near impossible for the average person to actually calculate it out by hand.

You would also not be able to use this as a shortcut if the investment was an LBO where CF is swept to pay down debt and equity is assumed to be received at exit. In this case you would use the MOC method and IRR tables that iamfromcanada mentioned. As he stated, these are the most common types of IRR questions in interviews. There are IRR "rules of thumb" that can be memorized (BIWS guides have them).

Just go into excel, set up a variety of different cash flow patterns and solve for IRR. The more you play around with it the quicker you'll understand it.

I wish there were a way to tag WSO posts to come up first in searches. Marcus' quick and dirty IRR calc is just a great post.

How to calculate IRR for a project?(Originally Posted: 09/28/2009)How do you calculate IRR for a project assuming equity raise of 10mm and exit at 7x Ebitda multiple in 5 yrs? Do you take into consideration the cash -flows that the company gets in between or just do the IRR function in excel and put the $-10mm zeroes for the 5 yrs and the discounted cash flow net of taxes after exit?

The answer depends on where the cash flows go over those 5 years. IRR, in my opinion is only relevant in the context of who's return you are interested in. Assuming you are interested in returns to equity, you would have to be concerned with whether or not there is debt service (interest or amort.) that needs to come out first. Long story short, those cash flows are part of someone's return, so yes, they should be included and accounted for one way or another.

For shorter-term stuff, I will make a quick estimate by figuring out what the linear interest would be and then adjusting as necessary. Two years in fixed income analytics basically had me answer hundreds and hundreds of questions about "Does this number make sense?" For shorter-term stuff, you can get a decent estimate by figuring out the simple interest, guessing the impact of the compounding, and going from there. In Marcus's example, I'd take off 21% from the 720 and then adjust up maybe 1-2% to figure out the PV of the $720 cashflow. You can also invert this strategy to get a somewhat reasonable estimate of IRR/yield. There's also some similar mental tricks, of course, to look at a combination of an annuity and final cashflow. To get the IRR on -360 to 720 in three years, I'd look at 33% simple interest but then look quick look at the extra benefit from compounding and spread a reduction of (1.33

1.33-1.66~=10%)2=20% across the three years or about 26%.It won't be exact, but 99% of the time, I'll be able to give the trader or researcher a definitive answer in five seconds rather than getting the TI-89 and pencil/paper out and taking five minutes.

For stuff with lots of compounding going on, you obviously go with the rule of 70/72 and then try and guess it by looking at squares or square roots. This method is less precise but you don't always have to be quite as exact for longer-term stuff.

IRR Calculation Question(Originally Posted: 10/11/2014)How would you answer this?

If you make an investment, and pay 10% premium to book value and receive a 5% dividend, book value CAGR = 10% and you sell it at 10% premium after 5 years, what would your approximate IRR be?

Would it be 1.1^5*1.1+0.05-1.1?

Thanks!

BUMP

BUMP

BUMP

( (5% * (sigma k=1 to 5 (1,1)^k) + 1,1^6 ) / 1,1) and all that to the power 1/5 then -1

Just simplify that equation and you got it

Ah, thank you.

That's a bit confusing but I'll try and work through it.

Thanks!

Wait, isn't that just the CAGR formula? I was under the impression that you can't use CAGR to work out IRR except in certain circumstances.

JJSaurel put it all right.

Here are the separate items that will make it all clear:

1) Initial investment 1.1

2) Dividend income = 5%*1.1+5%*1.1^2+5%*1.1^3+5%*1.1^4+5%*1.1^5 = 5%*(sigma k=1 to 5 1.1^k)

3) Exit value = 1.1^5*1.1 = 1.1^6

IRR = ((Dividend income + Exit value)/Initial investment)^(1/5))

IRR = ((5%*(sigma k=1 to 5 1.1^k) + 1.1^6)/(1.1))^(1/5)

.

Thanks for all the replies guys.

@HarvardOrBust: Thanks for the reply but that was the point I was trying to make - you can't use CAGR for this example. I can't use XIRR because I heard this was an interview question.

@WhatInTheName: Thanks for the reply but I don't think you can use the method to work out the IRR because it doesn't take into account the timing of the cash flows, right? It looks like the CAGR formula and HarvardOrBust made a point about that.

@new_analyst1 @NorthSider

Any thoughts on this?

As previously mentioned, if you want an exact answer, use XIRR excel formula

Result is c. 15%

IRR Estimation(Originally Posted: 11/18/2017)Is there a quick way to estimate how accretive or dilutive cash flow timing would be to your IRR without excel (just back of the envelope)? For example, say you have cash flows which look like the following:

100 = 10 / (1+IRR) + 10 / (1+IRR)^2 + 110 / (1+IRR)^3

The IRR above is 10%. Now if we assume we get $50 of the $110 in year 1 instead of year 3, roughly how accretive would the IRR be (without a calculator or excel):

100 = 60 / (1+IRR) + 10 / (1+IRR)^2 + 60 / (1+IRR)^3

Note total money received is unchanged, you simply get $50 earlier. What would be the best way to approximate this?

jllx, pure crickets, that's where I come in. Any of these useful?

internalrateofreturnmeasures thereturnon the outstanding "internal" investment amount ... gives a positive NPV and anIRRof5.5% even though the investment has a compoundedreturnrateof5%. ... Investopedia'sIRRarticle says "Oneofthe disadvantratesofreturn? Many thanks!IRRReturn... annualrateofreturnofthis investment. My first simple approach only considers one period as follows: ... Then it is a cash flow).Rateofreturn: 530 Euros / 14.000 Euros = 3.8% (which I intuitively ...rateofreturnis 25%? I appreciate any and all responses.IRRDCF ... trouble wrapping my head around this concept. I understand thatIRRis the discountratethat makes your ... COC, but an NPVof0 at yourIRR. Maybe I am just thinking about this the wrong way, but I just do not ...IRRisinternalrateof...return(i think it gives annualisedreturnfor everydollar (internallyinvested- used with where periodic ... hell is averageIRR? OR average XIRR? THANKS IN advanceIRRTO totalreturnor overallreturn<return(IRRis effectively the blendedrateofthe ... is defined as the annualrateofreturnthat generates NPVofzero. The formulaofnet present value ... Seeking a high-level explanation to explain the relationships among caprate,IRR, discountinternalrateofreturnwhen numberofcash flows exceed 5? For example, is it possible to ... I am told there are noIRRformulas when numberofcash flows excess 5 Is it so? Is there anIRR... findIRRofthe following investment using a "formula" rather than "iterative ...returnoffer since there are so manyinternsand ... group is fairly large with a biginternclass. Does anyone have any specific advice for the summer? ... becauseofhow competitive it may be. summer internship ...of2-4% and potential additional upside toIRRfrom warrants, etc. My question is HOW can they ... achieve 15+%IRRswhile providing debt at c.10% coupon? Would theirreturnsnot be limited to the coupon ... early stage companies ($15-30MM tickets). They talk about 15+% grossIRR(YTM) (before carry and ...No promises, but maybe one of our professional members will share their wisdom: @NiuShi" @Chaunce" @TudorM"

You're welcome.

Here's a list of IRRs that I found based on different cash multiples/years

http://tinyurl.com/37kk3w2

IRR Calc for purchase(Originally Posted: 02/22/2014)I'm trying to calculate IRR on purchase of business. 5 yr NPV of cash flows below, with 70 paid as purchase of private co, fully funded by term debt.

Yr 0 Yr 1 Yr 2 Yr 3 Yr 4 Yr 5

-70 23 20 14 11 7

Questions:

1. Do I use -70 in calculation if fully funded (this is the purchase price), not included additional debt required for transaction fees?

2. In order to arrive at NPV of cash flows (used DCF calculation), I used 35% tax rate but company is C Corp. Do I use this tax rate when running projections or do I use 0 since equity holders will pay individually for profits? Or do I not understand this correctly.

3. What about any terminal value - is this normally included to arrive at IRR?

Clearly I dont fully understand mechanics to run this, appreciate any advice - as well as beyond questions. Hopefully I've included enough info to answer.

your IRR is infinite in the case you described

you spend 0 of your own money (100% debt and no equity) and you make money.

why would anybody lend you 100% of a purchase price? this situation doesn't make much sense...

not entirely sure that I understand your second question, but if you buy the company, you are the 100% equity holder. if this is the case, you'll have to pay taxes one way or another before you can pocket the cash.

yes, you include TV in your IRR calc.

"Success means having the courage, the determination, and the will to become the person you believe you were meant to be"

Thx PSD92

So how should I view the required return if these are my cash flows and the deal is going to cost me 70? Lender has secured position on assets, gets its interest payments at a high rate, and believes the business has ability to payback in 5 yrs. how do I show TV does it go in yr 6? Appreciate help, I'm an ops guy trying to at least understand finance folks.

## See All Comments - 100% Free

WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)

or Want to

Unlockby signing in with your social account?## Want to Vote on this Content?! No WSO Credits?

Join Us

Already a member? Login