Lovely Thanks again, this really is an awesome forum, very very helpful indeed Regards Murph

ok it now seems to be £2,673.19 I had to delete and re-enter the last payment, then it righted it's self

it is, I put it in as 12/02/2013

I have just changed it and it's put the amount at a minus?????? it now says -£9,355.51

Don't know if that has worked

I think you are confusing me with somebody who can use a computer lol I wouldn't know where to begin, I am more than grateful for your help so far and don't want to put you to any more trouble by having to teach me how to do PDF's etc Cheers

open office

Cheers dx it worked with office, if iv'e got it right it comes out @ £2657.76 Does that look about right? or have I made a hash of it Thanks again Guys

saved it to my computer then opened it, not sure why it wont let me type in it.

Yes I saved it to my computer then opened it, not sure which version i'm on or why it wont let me type.

Thank you very much, I really appreciate you taking time out to help me with this. However I have hit a snag, the spread sheet wont allow me to type in it, I have hit "enable editing" but still no joy. I assume my excel is out of date, grrrrrrrr Thanks again, and I will pop back with the results when I have them. Cheers

settlement fig for loan 1 was £2069.95

Little bump incase ims is busy cheers

Thanks a lot

Hope this helps Loan 1 for £2000 only 4 repayments made @ £95.09 with 6 lots of interest charged , they were £12.15 £30.73 £33.99 £30.04 £33.02 £14.83 Then it says acc closed BBA OVDRFT NO PROT 22/06/99 £2069 Then loan 2 starts , loan amount £3900 17 monthly payments made @ £139.09 with 19 interest payments of £40.32 £72.96 £74.14 £66.40 £69.70 £68.62 £65.44 £70.59 £58.92 £62.07 £60.83 £61.61 £58.54 £62.89 £54.13 £54.82 £57.04 £50.65 £17.38 With a final settlement payment to close the acc of £3462.35 on the 15/12/2000