Hi, I recall an entry on The sum of numbers (From Shamus,I think). What I have is a loan I need to calculate the interest on for a client. I need figures for 09/10.(YE 31 March) What I have is a start date of Aug 08 at a rate of 7.5% and I know the repayments are £227.80 per Month. Balance as at August 10 is £7147 Loan over 5 years. Can someone remind me how it goes or if anyone knows a shortcut as it did seam long winded.