No problem Henry, I'm glad to see you got it working as needed. I am taking the time to incorporate all of the great hints I got on this one into my dusty old code, and I hope you have done the same.

Now, to all, and this has nothing to do with anything in the code itself, it's just one of those thing that happen to you in life that make you wonder about the nature of coincidence. I hope the mods will forgive an indiscretion if this kind of thing should be posted elsewhere...

I had not thought about this amortization problem since probably about a week after the activity originally died down back in July of 2011. I literally wrote the code to see if I could and forgot about it. Then last Monday, February 23rd, a friend comes to my desk to see if I knew how to calculate a loan schedule. Well, I thought, indeed I believe I do have something that will do that. Imagine my surprise when the very next day I see the email indicating someone had posted to this thread. I know, it would have been a much better story had the two events occurred on the same day, but still, what are the chances?