 Quote:
Originally Posted by Alan
The Excel IRR calculation gives -33.44% for those figures, and my simple calculation gives -33.56%.
But I agree that your formula giving -29% taking into account inflation looks pretty good to me.
|
Yeah I have to use an 8.42% inflation to get your numbers.
I'm wondering how you are putting in your values for excels IRR. When I use your numbers in excel I get -23%
Why are you dividing your gain by the average (which is much easier to calculate as (33266 + 41202)/2= 37234 BTW) instead of the final value in your simple equation?
|