Pierre and JoanneK
I was looking at this, and there seems to be something odd with the IIR calc...
I play with the interest rate on the loan, and the moment the interest rate falls below 7%, the IIR comes up with an error.
Excel isn't my forte, so I'm not sure what's happening here...