• 0 Vote(s) - 0 Average
• 1
• 2
• 3
• 4
• 5
computation of IRR
06-19-2010, 05:33 PM,
 Abuzar Qazi Junior Member Posts: 27 Threads: 6 Joined: Apr 2010 Reputation: 0
computation of IRR
Please guide me regarding the computation of iRR
06-24-2010, 04:10 PM,
 huma_ahmed Junior Member Posts: 3 Threads: 1 Joined: Jun 2010 Reputation: 0

IRR calculation involves the same equation that we used for the calculation of NPV.[)]
The only difference is that while calculating IRR we would set the value of NPV equal to zero and then solve the equation for the value if âiâ. In other words, the value of âiâ, at which the net present value of the project equals zero would be considered as the internal rate of return of the project.

NPV= -IO +CF1/ (1+IRR) + CF2/ (1+IRR) 2
= 0= -200,000 + 120,000/ (1+0.1) + 240,000/ (1+0.1)2
07-07-2010, 07:49 PM,

Abuzar saeen how r u?
well dear IRR is computed by the follwing steps
1)plot cash flows year wise
2)discount cash flow by any rate "x%" eg 10%
3) if present value is posative when discounted by X% above we will chose a rate higher than X% lets say 15% in order to bring the present value discounted at new rate NEGATIVE
4) now we have two rates and two values (one posative and one negative)
now put in the following formula to get IRR

IRR=a+{p/(p-n)}*(b-a)

a=lower rate
b=higher rate
p=posative value (value we got using lower rate)
n=negative value(value we got using higher rate)
abuzar hope your query solved )
Huma do u agree with my response ??

<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica, san" id="quote">quote<hr height="1" noshade id="quote"><i>Originally posted by Abuzar Qazi</i>
<br />Please guide me regarding the computation of iRR
<hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">
07-10-2010, 04:53 PM,
 Abuzar Qazi Junior Member Posts: 27 Threads: 6 Joined: Apr 2010 Reputation: 0

Imdad AOA.........It means the next rate should bring down the negative PV....means k agr 15% pe bhy negative me nahi ati PV so we have to select another rate that should result in neagtive PV..
07-11-2010, 12:29 AM,

Absolutely !!! ur right!!! this process is called interpolation however we can also compute irr by using two negative values by the same formula this process is called Extrapolation but their are issues with extrapolation regarding accuracy and correctnesss thus we always do interpolation
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica, san" id="quote">quote<hr height="1" noshade id="quote"><i>Originally posted by Abuzar Qazi</i>
<br />Imdad AOA.........It means the next rate should bring down the negative PV....means k agr 15% pe bhy negative me nahi ati PV so we have to select another rate that should result in neagtive PV..

<hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">
07-12-2010, 03:34 AM,
 IFRSbox.com Junior Member Posts: 3 Threads: 0 Joined: Jul 2010 Reputation: 0

<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica, san" id="quote">quote<hr height="1" noshade id="quote"><i>Originally posted by Abuzar Qazi</i>
<br />Please guide me regarding the computation of iRR
<hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">
Dear Abuzar,

I just add to the previous comments. Why not trying to calculate it with simple excel formula? Simple steps
1. Put your cash flows in the table year by year, or period by period (careful - periods between individual rows should be the same, not irregular).
2. Use formula =IRR(here you enter the range of cells where your cash flows are, e.g. A1A13). The result is your internal rate of return.
Best regards
Silvia M./www.ifrsbox.com
08-13-2010, 08:33 PM,
 yasir_live Posting Freak Posts: 2,326 Threads: 8 Joined: Oct 2009 Reputation: 0

KamranACA ki bharpoor kaamyabi k baad Abb ICAP pesh karta hay aap ki khidmat main KawishACA.

Regards.
08-14-2010, 03:53 AM,
 WARDAH Posting Freak Posts: 3,337 Threads: 22 Joined: Sep 2009 Reputation: 0

hahahahaha good one yasir

Forum Jump:

Users browsing this thread: 1 Guest(s)