How to design a prepayment tracker
 

I need to know how to design formulas in excel to track my prepayments. It
should give me the amounts for monthly allocations and as to when I need to
make other payment from which I can draw a journal for posting.

How to design a prepayment tracker
 

a1= total amount owed
a2= number of months to pay over
monthly payment = +a1/a2


"Kavin" wrote:

I need to know how to design formulas in excel to track my prepayments. It
should give me the amounts for monthly allocations and as to when I need to
make other payment from which I can draw a journal for posting.