s/sheet please

Robomitch

Could someone do an excell spread sheet showing the original money borrowed on a credit card, allowing me to put the interest rate in a "field" the s/sheet would then calculate the interest gained and therefore the capital increase. The s/sheet would then alow me to enter my next payament and would then calculate the next months capital...

Thanks in advance,

Robomitch

CannyJock

You can do it yourself. Replace APR with the APR% on your card.

Column A = opening balance
Column B = interest =ROUND(A * NOMINAL(APR,12)/12,2)
Column C = payment
Column D = closing balance =(A+B-C)

Opening balance in next row is closing balance from the previous one. Rinse and repeat.

EDIT: You'll need to insert row numbers to make those full cell references ....