Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
computation of IRR
06-19-2010, 05:33 PM
Post: #1
computation of IRR
Please guide me regarding the computation of iRR
Visit this user's website Find all posts by this user
Quote this message in a reply
06-24-2010, 04:10 PM
Post: #2
 
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
Visit this user's website Find all posts by this user
Quote this message in a reply
07-07-2010, 07:49 PM
Post: #3
 
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">
Visit this user's website Find all posts by this user
Quote this message in a reply
07-10-2010, 04:53 PM
Post: #4
 
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..
Visit this user's website Find all posts by this user
Quote this message in a reply
07-11-2010, 12:29 AM
Post: #5
 
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">
Visit this user's website Find all posts by this user
Quote this message in a reply
07-12-2010, 03:34 AM
Post: #6
 
<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
Visit this user's website Find all posts by this user
Quote this message in a reply
08-13-2010, 08:33 PM
Post: #7
 
KamranACA ki bharpoor kaamyabi k baad Abb ICAP pesh karta hay aap ki khidmat main KawishACA.

Regards.
Visit this user's website Find all posts by this user
Quote this message in a reply
08-14-2010, 03:53 AM
Post: #8
 
hahahahaha good one yasir
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)