I need a lot of help. I've looked all over the Internet for a template for what I am looking for, but I can't find anything. I've been close but not really.

Let me explain. I am looking for an amortization formula sheet for a boat loan that I have. That is easy enough, and I found that, but here is the hard part.

I went in on the loan with 4 different people all paying different prices a month. Let me get specific - I have a loan where one person is paying $55 a month, another $30, and three more $35 each. For a total of $190/month for the boat loan.

I want to be able to keep track how much each individual person owes in principal and in interest. Those prices a month are the minimum they will pay each month, but if someone decides to make more than the minimum payment, then it will mess everyone up with the total amount that they still owe.

So basically even though it is more one big loan, it is actually a total of 5 smaller loans as well with the same interest rate, but different minimum payments a month.

Is there anyone out there that can help me?

Thank you! If you need any more information, or more specifics on the numbers, please let me know. I don't mind posting that.

Thanks again.