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:

Expand|Select|Wrap|Line Numbers

 
<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...

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

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

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

Similar JavaScript / Ajax / DHTML bytes

/bytes/development

/bytes/it

/bytes/about