Excel 2007 : IRR function

Have a look here
http://office.microsoft.com/en-us/ex...091461033.aspx

Hi

You were using the wrong row in the IRR: formula in B14 should have been:

=IRR(A8:F8)

which returns 29.42%.

You want to take the net cash flow in each period (in your case a year) rather than the cumulative cash flow.

Richard