I have a spreadsheet that is a mortgage calculator that
does this. The formula's can be looked at in the
schedual sheets. The VBA just makes those sheets, the
formulas do the work. It is at
www.kjtfs.com in the
downloads section, it is called mortgage calculator.
Hope it helps.
Keith
www.kjtfs.com
-----Original Message-----
Can anyone help me with the formula that will allow me
to figure out the balance on a loan or credit card after
each payment, without creating a loop? i.e.
BALANCE=1000.00 PAYMENT=-100.00 INTEREST=+10.00 NEW
BALANCE=910.00(The problem is the "NEW BALANCE" needs to
go to the "BALANCE" now. and each "PAYMENT" is an
accumulated total.(In January "PAYMENT"=100.00, in
February "PAYMENT" equals 200.00, etc.) At the end of the
year the result will display the current balance, total
of monthly payments, total interest paid.
.