Thank you for replying to my post.
I am actually a business analyst defining amortization for developers
therefore I need to provide them the full mathematical formulas. I
cannot use any built in functions of any application. They need to know
the exact formulas.

Let me know if you know what the PMT function involves. Thanks for the
sample, it works nicely.