Take a look at the IPMT function. It does most of what you need with respect
to interest calculations.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"PeterH" wrote in message
...
Hi
has anyone done a spreadsheet that details a line of credit facility? A
line of credit facility is where you get a loan and all your income is
banked against the loan while you use your credit card for your expenses.
At the end of the month you pay the credit card but it the mean time your
loan balance has reduced.