Answers

Search

Post your resume

Back

Print

how to caculate IRR, could u help me out

Asked by sfarooqui99

Posted in Interviews and Accounting

21 Jul 2008

Answer this question

Answers (4)

  • IRR is a very poor measure of a projects value - it assumes that positive cash flows are reinvested at the same return as the IRR that the project generates - use NPV instead - also consider option value before undertaking investments

    stuart 25 Jul 2008

    RECOMMEND Recommended 0 times | Alert Moderator

  • IRR computation = Positive Discount Rate+(Positive NPV/Positive NPV- negative NPV) * Negative NPV discount rate-Positive NPV discount rate. Eg. 10% discount rate NPV 1200 and 15% discount rate -250 so IRR = 10% +(1200/1200- -250)*15-10 = 14.14%

    M Abdulhameed 25 Jul 2008

    RECOMMEND Recommended 0 times | Alert Moderator

  • If you want to calculate on Excel then it very easy. Just make cash flow and put initial investment iwth negative sign on start. and then apply formula in separate box i.e. =IRR(xx : xx) Please note, XX : XX is equal to first filed to last field of your projected cash flow and initial investment. If answer will be less that Required Rate of Return then reject the project orther wise proceed with it.

    Financial Analyst 23 Jul 2008

    RECOMMEND Recommended 0 times | Alert Moderator

  • Please see http://en.wikipedia.org/wiki/Internal_rate_of_return

    Umashankar S 22 Jul 2008

    RECOMMEND Recommended 1 time | Alert Moderator

Answer this question

* Mandatory

You have 1200 characters left

Enter the code shown here or sign in / register to skip this step. (What is this?)

Answer question

eFinancialCareers does not evaluate or guarantee the accuracy of any answer on Answers.
See disclaimer.

Jobs

Col3
Col4
Col5
Col6
bottom

Site Information

eFinancialCareers is a Dice Holdings, Inc. company. Dice Holdings, Inc. is a publicly traded company listed on the New York Stock Exchange (Ticker: DHX)