Tony

Perhaps the free MS Loan Amortizer Template will suffice?

http://office.microsoft.com/en-us/te...CT011377171033


Gord Dibben Excel MVP

On Tue, 5 Jul 2005 08:36:06 -0700, "Tony Williams"
wrote:

I suspect this is easy but I am no expert in Excel so need your help.
I want to create a spreadsheet that keeps track of loan amounts I am making
and calculate the interest that is accruing. I want to charge interest at 1%
over UK bank rate and charge the interest on the balace outstanding at the
end of every month. So if I lend say £250 to someone on the first of every
month indefinately, how do I set up a spread sheet that calculates the
interest at the end of every month. Also I may lend additional amounts during
the month which need to be added to the balance outstanding.