Click to See Complete Forum and Search --> : COnvert excel based debt settlement calc to java


hhedaya
08-20-2008, 09:06 AM
need help converting this to a java/web-based calc...
Input fields are:
Debt Amount:
# Of Months
lowest Single Debt Amt:
Debt Pay-off Amt: .42 default val (non changeable)
Mo maint Fees: (not a drop down, but a text box) default val $50.00
Service fees defaulted to 15% of total debt

30% of 15% service fees collected in 1st 3 months
70% of 15% service fees collected in months 4-15

Monthly payment = Mo maint fee + (service fee + .42 X total debt)/#of months
Ignote state specefic logic

savings = mo. pmt-service fee - mo. maint fee

(in months 1-3 savings will be -ve or $0, if -ve, incrementally increase monthly payment in mos 1-3 to make savings $0 (i.e a higher payment in mos 1-3)