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.