Hi,

i have been racking my brains for several days trying to figure this out to no avail.

Here is what i want to do:

have a line of credit with 8000$ on it that I owe. On the same line of credit, there is a 10000$ portion that I pay 50/50 with the wife.
So we need to have an excel sheet that lays out how much each portion is devided and what is left to pay, on the same sheet.
Both amount are on the same line of credit at 4.15%.
Each portion will be deducted each time we make a payment. for example:
When I make a payment on my 8000$, then what is the balance left with interest.
Same, for the 10000$ portion, when we make a payment, what is the amount left to pay with interest.

This way we each pay our how portion with interest.

Can anyone help us figure this out? This could be on the same excel sheet as seperate columns since they have to be calculated seperatly and each row would be the date we paid, the amount and then show the balance with interest left to pay.