Tracking payments of one loan made by different people

**danielcv** · 11-24-2012, 01:13 AM

hi
I am not a math person. I think I am way over my head here.
This is the problem:
Three people are paying school loans. There are several loans, each one with a different disbursement date. Each loan has an interest rate, of course. If interest is not paid it gets added to the principal.
I would like to set up an excel table that will allow me to do the following:
a. entering payments to the different loans indicating who made the payment
b. being able to enter more than one payment per month
b. keeping track of how much interest and principal each person has paid per loan and all loans combined

To me this seems very complicated. Perhaps it is not. If this entails a lot of work I am willing to pay somebody a reasonable amount. I am using excel 2010
Thanks in advance
Daniel

**dogberry** · 11-24-2012, 02:00 PM

Hi

This is a free site however you will be very lucky to find someone that will do all the work for you. Can you provide a sample worksheet that does not contain any confidential information of the layout you want and where the expected result will go that will give the gurus a chance to work out what is required to suit your circumstances.

Chris

**danielcv** · 11-24-2012, 02:04 PM

That is why I said that I was willing to pay. I understand it is a lot of work.
D.

Originally Posted by dogberry

Hi

This is a free site however you will be very lucky to find someone that will do all the work for you. Can you provide a sample worksheet that does not contain any confidential information of the layout you want and where the expected result will go that will give the gurus a chance to work out what is required to suit your circumstances.

Chris