Localfund.com - All about Fund and Investment
*Home>>>Equity Investment

What is IRR and how is it calculated?


Is this calculated on equity / investment only? Or can this also apply to any kind of debt calculation?

Internal Rate of Return

The Internal Rate of Return is the estimated yield from a specified number of cash flows over time. The simplified formula is FCF/(1+IRR)^1+ FCF/(1+IRR)^2 + ... + FCF/(1+IRR)^n

The unknown variable is IRR, where you plug in FCF over n periods. You can either get it by trial and error, or use MS Excel (=IRR(array of cash flows)).

It is calculated on cash flows only.

Use the Newton Method http://en.wikipedia.org/wiki/Newton_meth...
to estimate the IRR. Take each independent cash flow to present value.

Warning, if for every change in sign in cash flows (such as cash outflow, to inflow, to outflow, to inflow) you will have a root that is a potential answer. Answers must be checked against reality.

DO NOT USE e^rt in your calculations as the derivative of any exponential function is that same exponential function creating no solution. So if $50 went out one year into the future it is not 50E^(1*r) it is $50(1+r)^1. The later has a first derivative that will work in the algorithm the other does not.

Tags
  Fidelity Investment   Fidelity Fund   Exchange Traded Funds   Equity Investment   E-gold   Ebullion   Easy Money   Easy Investing
Related information
  • Career move?

    It sounds like you are ready for a change. This could be a good way to use your current skills and develop some new ones, so I'd say go for it! Best of luck!

    ...
  • I am looking for a service that a provides a daily liquidity ranking of US public company stocks.?

    Try www.nystockexc.com.

    ...
  • Looking for Investors for investments in indian booming retail and real estate industry?

    Then perhaps you should look into genuine investors and not people on a Q & A forum nice try!

    ...
  • I want an investment partner to buy into my current residence. What is the best way to do this?

    So many ways to do this. Here's just a few: 1. Equity share contract where he comes onto title with you based on some type of agreement. 2. Transfer the home into a trust where you are the r...

  • Investment banking job. What to do?

    You should be a writer - This is really entertaining.

    ...
  • SunCity Equities and Investments - has anyone made any profits with them? http://www.suncityei.com/?

    You've got to be totally nuts to invest your hard earned money with any company that is clearly a scam.

    ...
  • How does this look on my resume if I am applying for a job at an investment firm?

    Well...so much for the "uninformed" trying to give "amateurish and nonsensical advice". Geez. Sorry, I'm tired, should have been in bed already...but "hey"......

  • What are the key tools and/or framework used by a Strategic Planner?

    Aside from the ones you mentioned, you can also use the Strategic Control Map and the TRS analysis, but this is heavily used by listed companies.

    ...
  •  

    Categories--Copyright/IP Policy--Contact Webmaster