Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…
I do not know if this is the right room but any help from anyone will be much appreciated.
I have prepared an Excel spreadsheet where the interest and income periods are quarterly (they could be monthly)
The excel formulae is: IRR(values,guess)where value is a range. However this is for a one year period. If I block each group of four quarters together as a year and, assuming a four year period for the plan, I get a completely different result to that which I get using a different formulae which is:
where I leave the columns as quarters and insert "4" in "periods pa"
However this second formulae gives the same result to that given by the Excel one where I blocked the four quarterly periods into one period pa.
So the formulae is right but seems to be more flexible. The question is - which is the right answer - to block into yearly periods or to leave in quarterly ones?
The reason I am going to this trouble is the difference is not insignificant.
In my case blocking into yearly periods gives an IRR of 57.18% and leaving as quarters an IRR of 42.84%
OR - am I doing something WRONG!!!!!!!!!!!!
Sorry, I don't use the financial functions in Excel.
However click here
Thanks VoG and cezar for your comments. Unfortunately I still have to resolve the point. Does anyone else have any thoughts.
A note of caution.
It's not a good idea to use powerful tools such as those found in Excel unless you are confident about their application.
You should test functions on simple models for which you can calculate - by hand - the expected result.
I know this from my early engineering experiences when I had to know the ball-park results for very complex calculations (done by slide rule, Facit or pocket calculator) - I continue to apply the principle.
Thanks for the word of caution. Point well made and I will bear it clearly in mind!
I have not used this function before, but, like your equation it is, or is the equivalent of, a power series of some sort. These will often give different results with only small changes in parameters.
The best explanation I can give for my waffle is building society interest paid monthly: if they paid 1% per month (I wish!), you may think you get 12% per year, WRONG, its12.6%. 2% per month is not 24% its 26.8% (because you get interest on the interest, or in your case, cash flow on the cash flow).
You have to be very careful to understand the exact meaning of each parameter. I agree with Alan, try to do a manual calc in the way you want the numbers to work.
Sorry if you know this and its another problem entirely!
Thanks to both Skeletal and jazzypop for the input. I will go away and use the grey matter now!
This thread is now locked and can not be replied to.