Personal Revolving Loans

Awesome,

Thank you so much! I learned a few new functions from your formula. I
wonder how we get it to only charge interest on the outstanding
principle, since this always charges $300 interest, even when your
total due is down to 1000. Hmm...

Patrick

Oops,

I forgot to see that the E2 reference is relative...

I still wonder how one could have the interest only on the principle,
as I think this compounds the interest. Hmmm...

Lots of hmmmms

Patrick

Additional columns, my friend. You will have to create a column for
withdrawals, one for repayments, one for interest, one for principle debt
balance, and then one for total balance. Do your interest calcs on the
principle debt column, and the total balance one can use the formula I
previously posted. To determine the principle debt, add all withdrawals,
subtract all repayments and leave out the interest column in your calcs.

"santafedisplay@hotmail.com" wrote:

> Oops,
>
> I forgot to see that the E2 reference is relative...
>
> I still wonder how one could have the interest only on the principle,
> as I think this compounds the interest. Hmmm...
>
> Lots of hmmmms
>
> Patrick
>
>