HI tcb17,

Welcome to the forum.

I would suggest you to search some excel loan templates over internet, I am sure you can find some.. Else provide more information, if you need a formula / solution from this thread. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>