Rick, This can be done with a spreadsheet. The following was done in Excel.
A1 = "Bal Due"B1 = "Date Due"C1 = "Payment"D1 = "New Bal"E1 = " "F1 = "Dollar Amt"G1 = "Start Date"H1 = "Monthly Amt"A2 = F2B2 = G2C2 = H2D2 = A2 - C2F2 = the beginning balanceG2 = DATEVALUE(the beginning date in quotes)H2 = the monthly payment Then copy the following cells down as necessary
a3 = d2b3 = IF(DAY(B2+28)=1,B2+28,IF(DAY(B2+29)=1,B2+29,IF(DAY (B2+30)=1,B2+30,B2+31)))c3 = IF(A3-H$2>0,H$2,A3)d3 = a3 - c3 Bill Rick Castaneda wrote: Hello There, Does anybody have a program (freeware) I can use that will create the following payment schedule when given the following parms: Dollar amt ie:50,000.00 Payment start date 7/1/99 Payment amt per month 400.00 Produce the following report: Bal Due Date Due Payment New Bal 50,000.00 7/1/99 400.00 49,600.00 49,600.00 8/1/99 400.00 49,200.00 ect. Many thanx in advance