Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

Payment Schedule

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Payment Schedule

    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

  • #2
    Payment Schedule

    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

    Comment


    • #3
      Payment Schedule

      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.

      Comment

      Working...
      X