Take Web Solutions: Deposit & Loan/EMI Calculator

Deposit & EMI Calculator
About the script :

This is a purely HTML / javascript that which can be implemented in your webpage / website.
[+] Click here for code/script
Please provide a link to this blog, when you implement this script/code in your webpage/website and also join me by clicking on "Join this site" link that is in left pane on this page.

<html>
<form name="formname" >
<table border="0" >
<tr><td bgcolor="#c3b992" > Select</td><td bgcolor="#c3b992"><select name="depositname" id="sltd" onfocus=blankmv()>
<option value="0" />Select
<option value="1" />Reinvestment(Qrly Comp)
<option value="2" />RecurringDep(Qrly Comp)
<option value="3" />MthlyIncDep (Qrly Comp)
<option value="4" />QrtlyIncDep (Qrly Comp)
<option value="5" />Cash Cert-Issue Prices
<option value="6" />Loan EMI calculate
</select>
</td></tr><tr><td bgcolor="#c3b992" > Amount</td><td bgcolor="#c3b992"><input type="NUMBER" name="depositamount" id="depositamount" onfocus="blankmv()" />
</td></tr><tr><td bgcolor="c3b992"> Period(mths)</td><td bgcolor="#c3b992"><input type="NUMBER" name="depositperiod" id="depositperiod" onfocus="blankmv()" />
</td></tr><tr><td bgcolor="#c3b992"> IntRate %</td><td bgcolor="#c3b992"><input type="NUMBER" name="interestrate" id="interestrate" onfocus="blankmv()" />
</td></tr></table><br />
<div id="otherresult" style="display: none;">
<table border="0" >
<tr><td bgcolor="#c3b992"> Result</td><td bgcolor="#c3b992"><input type="TEXT" name="maturityvalue" readonly id="="maturityvalue"" />
</td></tr></table>
</div>
<div id="emiinterest" style="display: none;">
<table border="0" >
<tr><td bgcolor="#c3b992" width="125px"> EMI Amt</td><td bgcolor="#c3b992"><input type="TEXT" name="maturityvalue1" readonly id="="maturityvalue1"" />
<tr><td bgcolor="#c3b992" width="125px"> Interest Amt</td><td bgcolor="#c3b992"><input type="NUMBER" name="interestamt" id="interestamt" readonly />
</td></tr></td></tr></table>
</div>
<br/><br/><br/><br/>
 <input type="button" value="Compute" style="background-color:#c3b992" onclick="compute()" />
<input type="Reset" value="Reset" style="background-color:#c3b992" />
</form>
<script language="JavaScript"><!--
function compute() {
var splitArray = new Array(4);
var depamt =0, intrate =0,depprd=0,matval=0,val1=0,val2=0,val3=0, val4=0,deptype=0;
              var e = document.getElementById("sltd");
              deptype = e.options[e.selectedIndex].value;
              depprd =  document.formname.depositperiod.value;
              intrate = document.formname.interestrate.value;
              depamt = document.formname.depositamount.value;

//-----------------------------------------------------------------
    //  value = 0  ie user has not selected valid selection
    if ( deptype == 0 ) { 
    document.formname.maturityvalue.value = "INVALID input";
                        }
//-----------------------------------------------------------------
     // Reinvestment , quarterly compounding
     // Formula used :
     //    MV = P * [ 1 + interestrate/(100*no_of_qrts_in_a_year)] to the power (no_of_years*no_of_qrts_in_a_year)
    else if ( deptype == 1 ) {
    val1=(1+intrate/(4*100));
 val2=4*(depprd/12);
 matval=depamt*(Math.pow(val1,val2));
 document.formname.maturityvalue.value = formatNumber(matval,4); 
 document.formname.maturityvalue.text = "Maturity Amt";
       }
     //-----------------------------------------------------------------
     // Deposit Name : value 2 :Recurring Deposit (Qrly Compounding)
     // Formula used :  Each monthly instalment is trated as reinvestment deposit
     //                   and computed for MV for the entire period
     //   MV = P * [ 1 + interestrate/(100*no_of_qrts_in_a_year)] to the power (no_of_years*no_of_qrts_in_a_year)
     else if ( deptype == 2 ) {
  var mth =0; tmpmatval=0;
  
  for ( mth= depprd; mth > 0; mth--)
  {
       val1=(1+intrate/(4*100));
    val2=4*(mth/12);
    matval=depamt*(Math.pow(val1,val2));
    tmpmatval = (tmpmatval*1)+(matval*1);  
  }   
  document.formname.maturityvalue.value = formatNumber(tmpmatval,4); 
          }
    //-----------------------------------------------------------------
    // DepositName : Value:3 : Monthly Income Deposit –(Qrly Compounding)
    //      formula for Rs100 deposit
    //      (i/4) / [(1+i/1200) to power2 + (1+i/1200) + 1]
    else if ( deptype == 3 ) {
    val1=intrate/4;
 val2=1+ intrate/1200;
 val3 = 2
 val4 = Math.pow(val2,val3);
 val5 = 1+(val4*1)+ (val2*1);
 matval=(depamt/100)*(val1/val5);
 document.formname.maturityvalue.value = formatNumber(matval,4); 
       }
    //-----------------------------------------------------------------
    // DepositName : Value:4 : Quarterly Income Deposit –(Qrly Compounding)
    //      formula 
    //      Interest = PNR/100  ( period is taken as 3/12 years)
    else if ( deptype == 4 ) {
 matval=(depamt/100)*(intrate)*(3/12);
 document.formname.maturityvalue.value = formatNumber(matval,4); 
       }       
    //-----------------------------------------------------------------
    // DepositName : Value:5 : Cash Certificates - Issue Prices
    //      formula
    //      P = MV / [ 1 + interestrate/(100*no_of_qrts_in_a_year)] to the power (no_of_years*no_of_qrts_in_a_year)
 else if ( deptype == 5 ) {      
    val1=(1+intrate/(4*100));
 val2=4*(depprd/12);
 matval=depamt/(Math.pow(val1,val2));
    document.formname.maturityvalue.value = formatNumber(matval,4); 
                          }
    //-----------------------------------------------------------------
    // Loan EMI : Value:6 : Loan EMI calculate
    //      formula
    //      EMI = (LoanAmt*intrate)*( (1+intrate)^n)
    //            __________________________________________________
    //               [ ( {1+r)^n - 1 ]
    //
    else if ( deptype == 6 ) {
    val1 = (1+ intrate/1200);
    val2 = (depprd);
    val3 = (depamt*intrate/1200);
    val4 = Math.pow(val1,val2);
    matval = (val3*val4)/(val4 - 1);
    document.formname.maturityvalue1.value = formatNumber(matval,0);
    var val5 = (formatNumber(matval,4))*(depprd*1) - (depamt*1);
    document.formname.interestamt.value = formatNumber(val5,0);
                             }
function formatNumber(myNum, numOfDec) {
    var decimal = 1
    for (i = 1; i <= numOfDec; i++)
        decimal = decimal * 10 //The value of decimal determines the number of decimals to be rounded off with (.5) up rule 
    var myFormattedNum = Math.round(myNum * decimal) / decimal
    return (myFormattedNum)
                                       }

 }
 
//--!></script> 
<script language="JavaScript"><!--
function blankmv() {
   document.formname.maturityvalue.value = "";
   document.formname.maturityvalue1.value = "";
   document.formname.interestamt.value = "";
}
//--!></script>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.5/jquery.min.js"></script>
<script>
$(document).ready(function(){
  $('#sltd').change(function(){
    $('#emiinterest')[$(this).val()=='6' ? 'show' : 'hide']();
    $('#otherresult')[$(this).val() !='6' ? 'show' : 'hide']();
  });
});
</script>

</html>
Please let me have your feedback. If you wish to implement this in your webpage, kindly provide a link to this blog, and also join me on Twitter/Google+.
Take Web Solutions

Deposit & Loan/EMI Calculator

No comments:

Post a Comment

Select
Amount
Period(mths)
IntRate %
EMI Amt
Interest Amt