Payment Schedule

[Guest.Visitor]

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

[Guest.Visitor]

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

[Guest.Visitor]

Bill, Here it is 6 months later and I'm finally getting back to this forum. Many thanx for the response. I ended getting something off the web somewhere.