How to add all values of a specific variable using do-while and Javascript?

[shiloh]

Hi.

I need help. I am using javascript to come up with a loan's amortization schedule. Everything is already in place except for adding up the values of a certain field that is generated by a do-while loop (in this case all the interest payments so i can come up with a TOTAL INTEREST PAID).. i have been playing around with the code for a couple of hours but i seem to hit a brick wall...

Thank you very much...

My part of my code is pasted below:

<script type="text/javascript">
 
<!-- var mlibor=document.calculator1.mlibor.value
var loan=document.calculator1.loan.value
var margin=document.calculator1.margin.value
var mincome=document.calculator1.mincome.value
var mortgage1=document.calculator1.mortgage1.value
var mortgage2=document.calculator1.mortgage2.value
var mortgage3=document.calculator1.mortgage3.value
var livingexpenses=document.calculator1.livingexpenses.value
var miscexpenses=document.calculator1.miscexpenses.value
var totalmapaccount=document.calculator1.totalmapaccount.value
var month=document.calculator1.month.value
var day=document.calculator1.day.value 
var year=document.calculator1.year.value 
 
var begbal_simpleinterest2 = (loan - mincome) + parseFloat(mortgage1) + parseFloat(mortgage2) + parseFloat(mortgage3) + parseFloat(livingexpenses) + parseFloat(miscexpenses)
var int_minpayment2 = begbal_simpleinterest2 * (fir/1200)
 
var fir = parseFloat(mlibor) + parseFloat(margin)
var loan1=r2(loan) 
 
var count = 0; 
var month1=month-1;
do { 
count++; 
month1++;
 
var newbalance = loan
var begbal_simpleinterest = (loan - mincome) + parseFloat(mortgage1) + parseFloat(mortgage2) + parseFloat(mortgage3) + parseFloat(livingexpenses) + parseFloat(miscexpenses)
var int_minpayment = begbal_simpleinterest * (fir/1200)
var ending_bal = begbal_simpleinterest + parseFloat(int_minpayment)
var avail_bal = totalmapaccount - ending_bal
 
var mincome1=r2(mincome)
var mortgage11=r2(mortgage1)
var mortgage22=r2(mortgage2)
var mortgage33=r2(mortgage3)     
var livingexpenses1=r2(livingexpenses)
var miscexpenses1=r2(miscexpenses)
var newbalance1=r2(newbalance)
var begbal_simpleinterest1=r2(begbal_simpleinterest)
var int_minpayment1=r2(int_minpayment)
var ending_bal1=r2(ending_bal)
var avail_bal1=r2(avail_bal)
 
var int_minpayment2 = int_minpayment + parseFloat(int_minpayment)
 
if (month1 >=13 ) { 
month1 = month1 - 12 
}
 
document.write ("<tr bgcolor=33CCFF>")
 
document.write ("<td><font color=003399 face=arial size=2><b>" + count + "</b></font></td>")
document.write ("<td><font color=003399 face=arial size=2><b>" + month1 + "/" + day + "/" + year + "</b></font></td>")
 
document.write ("<td align=right><font color=000066 face=arial size=2>$ " + newbalance1 + "</font></td>" + "<td align=right><font color=000066 face=arial size=2>$ " + mincome1 + "</font></td>" )
 
document.write ("<td align=right><font color=000066 face=arial size=2>$ " + mortgage11 + "</font></td>" + "<td align=right><font color=000066 face=arial size=2>$ " + mortgage22 + "</font></td>" )
document.write ("<td align=right><font color=000066 face=arial size=2>$ " + mortgage33 + "</font></td>" + "<td align=right><font color=000066 face=arial size=2>$ " + livingexpenses1 + "</font></td>" )
document.write ("<td align=right><font color=000066 face=arial size=2>$ " + miscexpenses1 + "</font></td>" )
document.write ("<td align=right><font color=000066 face=arial size=2>$ " + begbal_simpleinterest1 + "</font></td>" )
document.write ("<td align=right><font color=red face=arial size=2>$ " + int_minpayment1 + "</font></td>" )
document.write ("<td align=right><font color=000066 face=arial size=2>$ " + ending_bal1 + "</font></td>" )
document.write ("<td align=right><font color=000066 face=arial size=2>$ " + avail_bal1 + "</font></td>" )
 
loan = ending_bal
 
}
while 
(ending_bal > 0) 
 
var newcount= count
var numyear = newcount/12
var numyear1=r2(numyear)
 
document.write ("</tr><tr align=center bgcolor=0066CC><td colspan=13><font face=arial size=3 color= white><b>Years to pay-off:" + numyear1 + "<br>Original Loan Amount: $" + loan1 +"<br>") 
document.write ("Total Interest Paid: $" + sum+"</b></font></td>") 
document.write ("</tr>") 
document.write ("<tr><td colspan=13 bgcolor=0066CC height=25 align=center>")
    document.write("<a href=javascript:history.back();><font color=CCFFFF size=1 face=arial>::Back::</font></a> <a href=javascript:window.close();><font color=CCFFFF size=1 face=arial>::Close::</font></a> <a href=index.html><font color=CCFFFF size=1>::Calculator Index::</font></a></td></tr></table>") 
 
}
//-->
</script>
 

[iam_clint]

what exactly do you need this todo? sorry I just don't get your question I guess.

[shiloh]

Hi. I'm sorry if my question sounded vague. This code line:

var int_minpayment2 = int_minpayment + parseFloat(int_minpayment)

does not add up all my int_minpayment (This is the minimum interest payment that is generated by the loop)

I need help in adding up all the values of int_minpayment to come up with the total interest paid.

I am pasting a hyperlink of the screen cap here and the column that is encircled in red will be the values that i need to add up.

Thanks again...