# What is IRR and how is it calculated?

by on November 23, 2010

It’s impossible to understand IRR without understanding the concept of Net Present Value (NPV) first, so let’s begin with NPV.

You know that the cash that you receive today is more valuable than the cash you receive two years down the line or anytime in the future due to inflation. So, anytime you see cash flows going out in the future you will ask yourself how much is all this money worth today? We are all familiar with this concept because we see it every day in our life, and is relevant to a lot of things especially retirement planning, and looking at things such as how much money you will need for retirement.

So let’s say I come to you with a proposal for a project and say that you invest Rs. 1 million in the beginning and after that the project will start generating cash without any further investment, and here is how the cash flows will look like.

 Time Period Project A 0 (1,000,000.00) 1 450,000.00 2 400,000.00 3 350,000.00 4 300,000.00 5 250,000.00

Since it’s me you’d say why did I go through all this trouble of digging up the numbers; take out your check book, and write me a check – thank you!

But imagine for a moment, it was a family member – you would be on your guard then wouldn’t you?

You would obviously want to know if this is a better deal than what your bank gives you, and for that you can calculate the Net Present Value of these cash flows on the rate of interest your bank gives you which is also called the Discount Rate for this purpose. Let’s assume that the discount rate is 8% in this case.

To calculate the NPV of this project you will discount each cash flow with the discount rate keeping in mind the time lapse.

Your calculations will look something like this.

 Time Period (T) Project A Discount Rate (DR) DR + 1 (DR + 1) ^ T NPV of Cash Flow{Cash Flow / (DR +1)^T} 0 (1,000,000.00) 0.08 – – (1,000,000.00) 1 450,000.00 0.08 1.08 1.08 416,666.67 2 400,000.00 0.08 1.08 1.17 342,935.53 3 350,000.00 0.08 1.08 1.26 277,841.28 4 300,000.00 0.08 1.08 1.36 220,508.96 5 250,000.00 0.08 1.08 1.47 170,145.80 NPV 428,098.23

An NPV of more than 0 means that you will make more than your alternative investment (the fixed deposit) in your case, so looking at this number makes you really happy.

To sum up – NPV is the sum of all cash flows at a discount rate that represents your alternative investment potential.

## What is IRR?

Internal Rate of Return (IRR) is that rate of return at which the NPV from the above investments will become zero. It is that rate of interest that makes the sum of all cash flows zero, and is useful to compare one investment to another.

In the above example if you replace the 8% with a 25% the NPV will become zero, and that’s your IRR. Hence, the statement that IRR is the discount rate at which the NPV of a project becomes zero. How did I know that the I need to use 25%? I used the Excel formula called IRR to find that out. Manually, you will have to do a bit of a hit and trial to arrive at that, and if you have Excel handy then that’s the easiest way to calculate IRR.

Input your cash flows, select IRR from formulas, and get the result. This link explains how to calculate IRR using Excel.

 Time Period Project A IRR IRR + 1 (IRR + 1) ^ T NPV of Cash Flow 0 (1,000,000.00) 0.25 – – (1,000,000.00) 1 450,000.00 0.25 1.25 1.25 360,000.00 2 400,000.00 0.25 1.25 1.56 256,000.00 3 350,000.00 0.25 1.25 1.95 179,200.00 4 300,000.00 0.25 1.25 2.44 122,880.00 5 250,000.00 0.25 1.25 3.05 81,920.00 Total of Cash Flows 0

The IRR is useful if you have to compare with one project with another that has different cash flows at different times.

So, to add to our example – let’s say you are presented with the following two options to invest your money in – which project will you choose?

 Time Period Project A Project B 0 (1,000,000.00) (1,000,000.00) 1 450,000.00 250,000.00 2 400,000.00 300,000.00 3 350,000.00 450,000.00 4 300,000.00 450,000.00 5 250,000.00 450,000.00

Quick mental calculation will show you that the cash flows from the second project exceed the first one, but you also notice that they do’t exceed by much and are also at later years, so it might be worth your time to calculate the IRR. In this case the IRR is 22.99% as shown by the table below because that is the discount rate at which the NPV becomes zero, or close to zero in this case due to rounding errors.

 Time Period Project A IRR IRR + 1 (IRR + 1) ^ T NPV of Cash Flow 0 -1000000 0.23 – – (1,000,000.00) 1 250000 0.23 1.2299 1.23 203,268.56 2 300000 0.23 1.2299 1.51 198,326.91 3 450000 0.23 1.2299 1.86 241,881.75 4 450000 0.23 1.2299 2.29 196,667.82 5 450000 0.23 1.2299 2.81 159,905.54 Total of Cash Flows 51

Your new information tells you that one project has an IRR of 25% while the other has an IRR of 23% so that gives you more information to make your decision from.

So, this is the way IRR helps you in making a decision when comparing different projects, and is one of the several tools that can be used in evaluating any project that has cash flows distributed over the years.

L November 24, 2010 at 12:16 AM

The site http://www.rupeetalk.com/calculators/pf-calculator.php gives pointers about retirement amount you need to have… found this to be another useful tool.

Manshu November 24, 2010 at 9:26 AM

Ajit Vadnerkar December 6, 2010 at 5:22 PM

Very good explanation. Thanks..

Rahul December 21, 2010 at 4:56 AM

However, at times IRR can mislead and it may be better to look at MIRR. The article below puts the three in perspective.
http://finaticsonline.com/blog/2010/11/npv_vs_irr_vs_mirr/

anamika July 25, 2011 at 1:05 AM

This site is really worth visiting…..The way everything is explained is so organized and so clear.
Thnx a lot!!!! keep posting more š

Manshu July 27, 2011 at 6:43 PM

Great to hear that Anamika – thanks!

sarath May 1, 2012 at 10:16 PM

haii..can u please give me some important bank interview topics…

hazara November 9, 2011 at 8:06 AM

I didnt get how to get 25% and 23% its the same problem i have in my notes, and printouts i have table of two projects but IRR is not given š

Manshu November 9, 2011 at 7:35 PM

You have to enter the cash flows in an Excel or something and calculate IRR using the Excel function. You can Google up stuff on how to calculate IRR using Excel and that will help you.

Amar February 11, 2012 at 8:51 PM

You explained IRR in very clear and concise way. Can’t forget it now……thanks.

Nouman April 26, 2013 at 8:52 PM

Sorry Amar this is not very clear and concise method this is very complicated method I know better from this………..

NAIM MUNSHI February 23, 2012 at 4:42 PM

HI DEAR SOMETHING WRONG IN THE ABOVE DISOUNT RATE USED ( THAT IS 8%)

DISCOUNT RATE can NEVER BE EQUAL TO BANK FIXED DEPOSIT RATE

THE REASON BEHIND THAT IS SO SIMPLE THAT PROJECT INVOLVES RISK AND WE SHOULD ADD RISK PREMIUM TO THE NON RISKY RATE OF RETURN(fixed rate of return) THAT MEANS DISCOUNT RATE SHOULD BE RISK FREE RATE PLUS RISK PREMIUM. IN THE ABOVE EXAMPLE IT SHOULD BE 8% + LETS SAY RISK PREMIUM 6%= 14% SHOULD BE THE DISCOUNT RATE.( This is the same thing that has been conveyed in CAPM model as well and the same thing (14%) is also known as investors expected rate of return or required rate of return)

You are absolutely foolish if u use discount rate equal to 8% . if you are taking 8% discount rate it shows that you are taking risk and inspite of that you are ready to accept 8% return ! How silly and stupidity! Your risk must be compensated with higher return. otherwise you are better with 8%. Why u take more tension ( risk )? enjoy FD interest at no risk.

Taha July 17, 2012 at 10:50 AM

Naim,
the website has given a simplest explanation to a starter about the IRR, when you go in detail I am sure that there are many more details. and even if there are things to which you dont agree, we have to be polite about them and not to forget the effort the person made to explain the issue.

Sunil October 1, 2012 at 3:41 PM

I would like to see you try to do better.

The author has elegantly explained the concept of IRR. You on the other hand have added nothing to the discussion. You called the author stupid, when you cannot even type out a decent sentence…

Naim Munshi April 17, 2013 at 2:39 PM

really sorry for the language , my intentions was not to pass any comment on the author , really sorry for the remark. To just give u further knowledge about IRR , it is said that IRR is using the reinvestment assumptions , this reinvestment assumptions about IRR has devided the finance community into two groups , one accepting reinvestment , other not accepting the reinvestment. There are certain problems in Capital Budgeting that can be solved only by assuming the reinvestment assumptions when there is a conflict between two projects one is good in terms of IRR and other is good in terms of NPV. in that case by assuming various reinvestment rate we decide which project is the better one. The point would be achieved when even by assuming vaious reinvestment rate we come to a rate where we are indifferent between the two project. That rate is called Fisher’s Rate . If somebody wants that research paper , i can provide that . again sorry for whatever language i have written , thanks

Manshu April 18, 2013 at 1:01 AM

Yes, please share the link, that will be useful, I only knew of Fisher’s Equation about real and nominal interest rates, and this might be something useful to learn.

Naim Munshi April 18, 2013 at 6:33 PM

let me know if there is any comment about that paper
thanks

Manshu April 18, 2013 at 7:53 PM

This doesn’t open up the link to the paper, just the SSRN page, what’s the name of the paper?

Naim Munshi April 19, 2013 at 10:21 AM

name of the paper is revisiting the reinvestment rate by kunal khairnar , thanks

Manshu April 19, 2013 at 9:16 PM

This doesn’t seem to have anything to do with Fisher’s rate, what am I missing?

Naim Munshi April 23, 2013 at 1:28 PM

fisher rate means rate at which both the projects are indifferent as far as reinvestment rate are assumed you do not compare with the Whatever fisher rate u are talking about , this fisher rate is in terms of capital budgeting and reinvestment and conflict between IRR and NPV criteria.

Naim Munshi April 26, 2013 at 9:28 AM

Hey Manshu , you got the point or not please do reply

Naim Munshi April 26, 2013 at 9:25 AM

Hey sunil look I have added the most controversial topic in IRR : that is reinvestment assumption , I have also mentioned the name of the paper below . I am sorry about my language ,but your argument is wrong , as I have added very good topic of IRR that is its reinvestment assumption , please go through that research paper.thanks

John November 20, 2013 at 3:45 PM

Naim Munshi – try to be a little more constructive in future. This is an ‘IRR for beginners’ piece. We can all start going on about more complicated things if we like but that was not the point of this article. You would do well to realise this.

Ramamurthy January 16, 2013 at 8:52 AM

Please appreciate the patience and time which Manshu has taken to do this post.Look at the target readers.It is not for an IIT MBA Finance reader.You talk of risk factor. I have many other more significant factors.I immensely like One Mint because of its simplicity and the reactions from the readers which are always polite.Calling some one who is doing an excellent job as stupid is certainly not in my opinion, a sign of politeness.I have always wondered what Manshu gets out of this.

Rajeev Srivastava March 24, 2012 at 5:13 AM

Very informative! really appreciate your website š

Altough, I calculated IRR of the LIC Moneyback Policy I have with me. It is giving me a return of 5% only. Before visiting this page I was under impression that the policy was best choice with their periodic returns.

Thanks a lot!

Manshu March 24, 2012 at 11:22 PM

I’m sure a lot of people share that misconception Rajeev – I’m glad you found this page and were able to clear it. Perhaps you could help out a few friends by talking to them about this as well. Thanks for your comment!

sameer May 3, 2012 at 3:30 PM

hi, when calculating project irr, is the cash flow before or after interest? how would this differ from equity irr?

Naresh May 13, 2012 at 11:59 AM

XL is returning an error while calculating for IRR with 37 rows. however when I reduce the rws to a maximum of 20, i am getting an IRR output. Any idea why this is happening?
Thanks,
naresh

Manshu May 13, 2012 at 5:56 PM

It’s nothing to do with the rows I’m sure, but rather I think there is something between your 21st and 37th row that’s causing the formula to not work. Double check to see if it’s all numbers only, and also to see if the numbers are such that there is no IRR to show, i.e. they are only negative numbers. Look for anything odd.

Manshu May 14, 2012 at 12:30 AM

I’ve never looked at this product and am not knowledgeable about ULIPs in general so I won’t be able to comment about this. Sorry.

Shaun May 20, 2012 at 1:54 PM

This video will show you in 3 minutes what IRR is and how to use it in Excel.

Abhinav Gulechha June 19, 2012 at 3:35 PM

Hi Manshu

Thanks just saw your post on IRR..its very nicely presented. Its an invaluable tool for financial planners also, to calculate the returns from insurance policies and mutual fund SIP investments.

Manshu June 19, 2012 at 5:00 PM

Thanks Abhinav, a lot of people have in fact started realizing that this is how you calculate returns from SIP or insurance policies and I have separate posts on that topic in here somewhere too.

Christine August 20, 2012 at 4:44 PM

After reading the explanation of the IRR it kind of made sense but still am a little confused as to where to begin assuming the rate to get to zero?
Can anyone help me further??

Any help would be greatly appreciated.
thanks

Manshu August 20, 2012 at 7:15 PM

I’m not sure what you mean, the rate will remain constant, the rate won’t change or get to zero….the NPV of cash flows will become zero.

You can assume any rate to begin with and see what happens to your numbers, and adjust accordingly. The starting point will just be a guess.

Christine August 21, 2012 at 4:13 PM

Ok great thank you for your response Manshu š

Omkar Sapre August 26, 2012 at 5:08 PM

In the THREE tables, the % sign within the rows in the THIRD COLUMN might mislead the readers. You’ve already converted the percentages to decimals, so you might want to delete the % sign from the columns; that is if I am not wrong on this.

Manshu August 28, 2012 at 5:41 AM

Thanks for pointing that out – I’ve made the edits.

Christine September 12, 2012 at 2:36 PM

Hey,
Im still struggling with the IRR! I cant get me head around it.

I have three different cash flows all of which increase from year one two and three. Im not sure
what im meant to do exactly. When i try to figure out what the IRR is are the cash flows meant to decrease or increase to get the total to 0 and how do i get to that and am i subtracting this from my NPV???
Can someone help? im finding this quite confusing… š

Sekhar September 24, 2012 at 8:15 PM

Hi Manshu,
Thanks for coming up with this article on IRR and for explain in great detail. I’m sure readers will find it valuable and interesting too.
I’ve a few suggestions (pls. dont take it as a critic view).
1. I think you could drop the explanation about IRR being the rate at which NPV is zero. Instead of the detailed calculations you could have directly computed IRR using the IRR function in one shot and display it below the cash flows. The detailed calculation in my view is not required. However, I’d be wrong too because it also educates or helps people learn how IRR works. But today given the availability of spreadsheet the calculation part is important but not that critical.
2. I feel explaining the decision making part is important too, though it may sound theoretical it has a lot of practical relevance. What Im trying to say is
– When you look at a project’s viability using NPV method using your required discount rate then it has to be positive for a project to be selected. I think this has to be mentioned though obvious for you and me. For this you could have taken another project showing negative NPV to illustrate it.
– When you talked about IRR for decision making you could have explained a little more that IRR of 25% for project. I think the last table should be titled “Project B” – please verify. You could have concluded that Project A, which provides superior returns of 25% is better than Project B. Ofcourse this is based on one criteria….and discussion other factors is beyond the scope.
– Lastly, though its obvious I request you to also say in simple layman’s language that IRR is the annual rate of return expected from the project. This makes their understanding easier. If FD provides 8% and investment in this project provides 25% then the project is more attractive than the FD though the project may carry higher risk. And if project A provides 25% and project B provides 20% return then assuming all other factors are constant project A is better.

In simple terms IRR and NPV can be seen as two different measures.
NPV just tells you if the project (s) at its present value generates more money than your original investment.
IRR indicates the compounding rate of return for 1 year or one period for the project.
NPV tells you if its viable or not, while IRR tells you the quantum of return (or how good the return is in terms of a %age).

Sorry for the lengthy comment. Just wanted to share my gyan, which I hope makes sense.

Bekhruz Nurnazarov October 18, 2012 at 12:15 AM

Unfortunately, the indexes mentioned above, i.e. IRR1=25% and IRR2=23% does not give you any idea to make a decision. Such comparison may be done for NPV1 and NPV2.

The problem is that, the projects which are being offered may be negative (Benefit-Cost<0), but they are "required" to be positive in the other periods, year2, year3, … IN AGAINST CASE IRR BECOMES STUPID/FOOLISH METHOD TO MAKE ANY DECISION!!!!

Therefore, NPV is most convenient method to make decisions, but also this method has a lot of negative points (e.g. the factors are "assumed" for several years, based on experience, trends, data forecasts… )

Faith October 25, 2012 at 5:35 PM

Zanele November 2, 2012 at 3:16 PM

Your explanation of the IRR is very good makes even those of us who are not financially inclined understand. By far the best explanation I’ve come across. Excellent!!

Shodhan November 11, 2012 at 6:14 PM

Thanks a lot manshu for your highly informative article. It was explained clearly and it helped me a lot into understanding what IRR is and also Sekar comment was also incisive. Thanks Manshu and Sekar.

Asir November 26, 2012 at 4:52 PM

My Name Asir Mohamed Ahmed
From Sudan woking in UAE from 1997 Till now

Mustapha Taoheed December 5, 2012 at 7:50 PM

thanks Manshu. You have done a good job.
GOD’s blessings. Pls explain WACC AND CAPM TOO.

Frikkie December 6, 2012 at 8:31 PM

Can you do this calculation in exell in spreadsheet format, where you insert the values and get the answer?
I am an mechanic so for me to do this calculations is out. I need someone to do this for me!!!!
I did like the reading by the way and it helped me understand what IRR means, thanks

bemoneyaware December 13, 2012 at 5:29 AM

We make investments to earn returns. Investment return is the change in value of an investment over a given period of time. For example

Mr Sharma invested Rs 10,000 in a mutual fund and 2 years of holding it became Rs 20,000

Mr. Patil invested Rs 50,000 in Gold for 7 years and it became Rs 4,00,000

Who earned more? How to calculate returns so that we do not end up comparing apple to oranges! There are many different measures such as, absolute return, simple annualised return, compounded annual growth, among others. Our article Understanding Returns: Absolute return, CAGR, IRR etc covers different ways to compare returns.

selometsi January 8, 2013 at 4:58 PM

I still don’t get it how to calculate IRR other than excell

Ron C. January 24, 2013 at 10:55 AM

The last IRR of 23% is NOT the “IRR”!

Because your NPV is not zero. Higher the IRR, better the return on investment.

Vivian February 10, 2013 at 8:20 PM

Hi dat explanation is d boomb. Pls can u send me concrete examples on,these; Cost benefit analysis,NPV,& IRR. Thanx

Amit February 12, 2013 at 11:37 PM

Hey thank you for the explanation. I have one doubt. In the 2nd table where you have explained how to calculate the NPV, Can u please tell me in the end how did you get the figure of 428,098.23?

Manshu February 13, 2013 at 7:21 AM

That is the total of all the values above it.

mohammad haider talat February 15, 2013 at 5:03 PM

so i got it now, my quest for everything i always wanted to know about finance and economics ends here………..!!!!!!!!!!

N.R. PANIGRAHY February 18, 2013 at 2:03 PM

The explanation is very strategic and helpful. Suggest you may add how the IRR is interpreted in various industrial segment. Certainly this will be a value addition

Manshu February 19, 2013 at 7:30 AM

It is used the same manner everywhere which is to see how the returns from one fund compares with another.

Viva March 27, 2013 at 3:41 PM

nice explanation….bt hav doubt with discount rate n calculations

Manshu March 27, 2013 at 8:06 PM

What is the doubt?

rehriuh April 5, 2013 at 8:00 PM

Very good explanation.

Manshu April 9, 2013 at 5:49 AM

Thanks!

Nitesh Matta May 6, 2013 at 10:22 PM

Thank you so much. i fully understood it.. You explained so nice and in simple words.. thank you..

CSE TUBE May 18, 2013 at 6:16 AM

Thanks for the useful explanation…
Your explanation is initiated interest for me to study the topic of project Evaluation techniques in BE. CSE..

Thanks a lot.. š

pratik June 3, 2013 at 12:18 AM

i would like to know that while calculating the irr or npv why do we

IRR

1 250000 0.23 1.2299 1.23 203,268.56
2 300000 0.23 1.2299 1.51

form were did i got 1.23 and 1.51 why there is a difference

NPV

1 450,000.00 0.08 1.08 1.08 416,666.67
2 400,000.00 0.08 1.08 1.17

from were did we got 1.08 and 1.17

can u pls explain me in detail from were did we got this amt and also why we have to divide the this (1.08 or 1.17) with the number called outflow why i cant multiply why we have to divide pls pls pls it is a request to explain me this myth.

god bless u .

naim munshi June 5, 2013 at 9:31 AM

Dear pratik ,

we are in a process of finding out present value of the future cash flow. you know the equation that FV= PV(1+r)^n , now if we want to find the present value then we need to divide the future value by (1+r)^n and not multiply.

Jayanta Chakrabarti June 7, 2013 at 8:56 AM

Many thanks for making it so very clear to me in such a short time. I have tried so very hard to understand and resorted to lot of approaches. But indeed it is explained in a lucid language.
Regards.

ramanathan dwarakanathan June 18, 2013 at 9:54 PM

Very interesting. can you make it little simpler for the benefit of all. http://ddramanathan.blogspot.in/

Sonal July 14, 2013 at 10:37 AM

Thanks Manshu, for your informative post, can you help me out regarding the following:
How we calculate / estimate the cash flow for calculating IRR
Cash flow is not expected to consider the inflation, does that meen cash flow series in normal cases will remain constant for all future years (no cost escalation, no price escalation, and assuming constant rate of production)
Does it include interest rate on which one had taken loan
Does it consider depreciation and the scrap value at the end of the project.
Sonal

Manshu July 15, 2013 at 8:15 PM

Hi Sonal,

You have to make a series of assumptions about cash flows and then estimate it. You can have it increase at a rate of say 10% for the next 5 years and then a terminal rate of 2% or some other thing. This varies hugely from one person to another and is dependent on what set of assumptions you make.

Salil August 5, 2013 at 4:31 PM

Useful information.

Sridhar Raghunath September 3, 2013 at 1:25 PM

Thanks for the article, its explained so perfectly and so simple.

Sandaru Indrajith Kumara September 4, 2013 at 11:22 AM

Murali Krishnan October 3, 2013 at 2:48 PM

Hi,

Thanks for the content, it’s very useful. But, you didn’t mention which project among a set of projects are really profitable – the one with a lower IRR or the higher?

Jason January 4, 2014 at 9:36 AM

Thank you for your great explanation on IRR calculation. There is a tool to calculate internal rate of return, if reader wants to calculate it or check result.
http://dailycalculators.com/irr-calculator

Jayanta February 25, 2014 at 7:07 PM

Dear Manshu,
Thanks a lot for all your efforts in educating people. It could not have been simpler for a non-finance guy to understand the finance in such a lucid way. I really appreciate. I now understand the importance of NPV and IRR. I have one doubt. Could you pls help. Suppose i make an initial investment of say 1.5 MM\$ to build a plant. The plant life is say 25 yrs. Do we look at NPV, IRR or we look at how quickly we break even? How do we find the break even point. Say we want to break even in 10th year. SO we calculate the NPV at 10th year which will be either zero or -ve for a certain discount rate. Pls correct me if i am wrong.
Thnaks.
Regards.

Manshu February 28, 2014 at 9:19 PM

There’s no one thing that you can look at and say that yes that makes sense and base your decision on that. It is really a combination of factors and what alternatives you have available to you.

Suresh @ Best Investments February 28, 2014 at 12:05 AM

This is probably one of the old article I visited today Manshu and Shiv. I like the way you articulated it.

Sushil Bhan March 3, 2014 at 3:44 PM

Can you develop the financial model for my project. A model that is pitched at investor prospects. If you send me your number I could explain my business.

atul verma March 6, 2014 at 12:36 PM

Excellent explanation !!

keep it up !

Mrityunjoy Chatterjee April 25, 2014 at 7:42 PM

Dear Manshu,
Really very informative and very nice example that has been set to make the users understand IRR and NPV. I’d like to add to the same that there is another way that we can predict any project with high IRR that would be by pay back period. If you look at the example above for Project A(\$1,200,000) the pay back period is less than 3 years which is just 3 years in case of project B (\$1,000,000). So by this we could say like Project has a more probability of higher IRR than Project B.

Kinjal May 12, 2014 at 11:29 AM

Hello.. I would really like to know how to calculate IRR without assuming or trial n error method. I need to know how to arrive to exact interest rate while using PVIFA Table.

yashfa May 19, 2014 at 10:58 PM

thnx it help me alot

Manshu May 20, 2014 at 1:59 AM

Mrityunjoy Chatterjee May 20, 2014 at 4:24 PM

Dear Manshu,
Really very informative and very nice example that has been set to make the users understand IRR and NPV. Iād like to add to the same that there is another way that we can predict any project with high IRR that would be by pay back period. If you look at the example above for Project A(\$1,200,000) the pay back period is less than 3 years which is just 3 years in case of project B (\$1,000,000). So we could say that Project A has a higher profitability due to its lower payback periods compared to Project B. So Projects with lower pay back periods has higher IRR, and vise versa.

Manshu May 20, 2014 at 8:49 PM

Yes, that’s right – thanks for your comment.

Puneet May 24, 2014 at 4:55 PM

Hi Manshu.
Really good article. really good for someone like me (who has lil knowledge of finance) .
Just one querry – can i use IRR to calculate how much my monthly MF SIP has returned ? For example : I have invested approx 2000/month in a SIP 21 months & current value of this is 62k. If i calculate by IRR – it is 4% – am i right. Where as if i calculate returns by weighted avg (my avg purchase value is 42k) so gain is of approx 48%.
Could you comment which is correct ?

Phil September 2, 2014 at 3:50 PM

Nicely explained…corp. finance 101 was many years ago and I just got a prospectus on Real Estate deal all based on IRR. Was racking my memory- thanks.

Sanjay February 3, 2015 at 9:42 AM

There is a (free) online IRR calculator at uxfin.com. It can handle varying amounts and varying periods. It can also calculate the balancing amount to achieve required IRR

rav February 18, 2015 at 6:58 PM

good explanation. thanks

ubaid May 28, 2015 at 11:59 AM

Great Job

Swapnil October 7, 2015 at 5:17 PM

What a simple way of explaining IRR…anybody can understand !! Thank you very much Manshu !!

Yogesh Shinde November 21, 2015 at 9:26 AM

Hi,

How to calculate when your portfolio is in Loss i.e. Negative Rate of Return?

Jai February 24, 2016 at 7:37 PM

can anybody telll me the last interest rate of sip?

amandeep March 28, 2016 at 11:51 AM

suppose we have a 20 year project.can we calculate the IRR after every year or is it calculated for all the years collectively?means i wanted to ask that there is only one value of IRR for the project or there will be IRR for every year?

PAWAN SHARMA August 28, 2016 at 4:06 PM

Hi,

Can you pl. explain the returns calculation in the most simplied way, let us say, for someone, who has invested Rs. 1000/- per month for the last month, say in HDFC TOP 200, so how is the calculation would be, and what would be rate of returns in case of SIP investment. Pl. revert back and guide suitably in the most simple possible way.

Manshu April 27, 2013 at 9:21 PM

I am sorry I didn’t follow it.

Jayanta February 27, 2014 at 7:52 PM

What i wanted to mean is how important is the payback period. What is the relevance of NPV and IRR vis-a-vis Payback period. Or Payback is of little importance when wee are talking about the IRR and NPV.
Thanking you.
Regards.