function showupload() 
{
  var field = document.editform.accounttype;
  var upload = document.getElementById("logoupload");
  if (field.value == 2 || field.value == 4) {
    upload.style.display = "";
  } else {
    upload.style.display = "none";
  }
}

function rate(numpayments,paymentamount,presentvalue,futurevalue,type) 
{
  var y1, y2, rate;
  var a=0.000001;
  var b=1;
  var tolerance=0.000001
  var tempa = a;

  for(var k = 1; k<=100; k++) {
    rate = a;
    y1 = presentvalue * Math.pow(1+rate, numpayments) - (paymentamount * (1 + rate * type) * (Math.pow(1+rate, numpayments)-1)/rate + futurevalue);
    rate = b;
    y2 = presentvalue * Math.pow(1+rate, numpayments) - (paymentamount * (1 + rate * type) * (Math.pow(1+rate, numpayments)-1)/rate + futurevalue);
    if (y1*y2>0) {
      b = a;
      a = tempa; 
      a = (a+b)/2;
    } else {
      if (((b-a)/2) < tolerance) {
        break;
      } else {
        tempa = a;
        a = (a+b)/2;
      }
    }
  }
  a = (a+b)/2;
  a = a * 100;
  return (a);
}

function Format(total,decimals) 
{
 var num = "" + parseFloat(total);
 var zeros = "";

 for (var i=0; i < decimals; i++){
   zeros = zeros + "0";
 }
 if ( num == "NaN" )
   return num = "0." + zeros;

 if ( num.indexOf(".") == -1 )
   return num += "." + zeros;

 return (num+zeros).substring(0,num.indexOf(".")+1+decimals);
}

function updateform()
{
  form = document.calc;
  var J4 = 36;
  var J5 = 48;
  var J6 = 60;

  var J1 = parseFloat(form.J1.value); 

  var C3 = parseInt(form.C3.value);
  form.C3.value = C3;
  var C4 = parseInt(form.C4.value);
  form.C4.value = C4;
  var C5 = parseInt(form.C5.value);
  form.C5.value = C5;
  var C12 = parseInt(form.C12.value)
  form.C12.value = C12;
  var G6 = parseInt(form.G6.value);
  form.G6.value = G6;

  var J19 = 8;
  var J20 = 7;
  var J21 = 6;
  var J22 = 5.75;
  var J23 = 5;

  var J11 = J1+J19;
  var J12 = J1+J20;
  var J13 = J1+J21;
  var J14 = J1+J22;
  var J15 = J1+J23;

  var K19 = 7.75;
  var K20 = 7.2;
  var K21 = 5.5;
  var K22 = 5.25;
  var K23 = 5;

  var K11 = J1+K19;
  var K12 = J1+K20;
  var K13 = J1+K21;
  var K14 = J1+K22;
  var K15 = J1+K23;

  var L19 = 7.7;
  var L20 = 7.4;
  var L21 = 5.45;
  var L22 = 5.2;
  var L23 = 4.9;

  var L11 = J1+L19;
  var L12 = J1+L20;
  var L13 = J1+L21;
  var L14 = J1+L22;
  var L15 = J1+L23;
 
  var B9;
  var B10;
  var B11;
  if (C3<5000) {
    B9 = "too small";
    B10 = "too small";
    B11 = "too small";
  } else if(C3<10000) {
    B9 = J11;
    B10 = K11;
    B11 = L11;
  } else if(C3<20000) {
    B9 = J12;
    B10 = K12;
    B11 = L12;
  } else if (C3<30000) {
    B9 = J13;
    B10 = K13;
    B11 = L13;
  } else if (C3<75000) {
    B9 = J14;
    B10 = K14;
    B11 = L14;
  } else {
    B9 = J15;
    B10 = K15;
    B11 = L15;
  }

  var K4 = B9/100/12;
  var K5 = B10/100/12;
  var K6 = B11/100/12;
  var K7 = C3 * (1+(C12 / 100));
  var K8 = K7 - C4;

  var D32;
  var D34;
  var D36;
  if (C5 < 5) {
    D32 = 1;
    D34 = 1;
    D36 = 1;
  } else if (C5 > 30) {
    D32 = "too high";
    D34 = "too high";
    D36 = "too high";
  } else {
    D32 = C3*C5/100;
    D34 = C3*C5/100;
    D36 = C3*C5/100;
  }

  var B26 = C3 - C4;

  var C32 =(K8-D32*Math.pow(1+K4,-J4))/(((1-Math.pow(1+K4,-(J4-G6)))/K4)+G6);
  var C34 =(K8-D34*Math.pow(1+K5,-J5))/(((1-Math.pow(1+K5,-(J5-G6)))/K5)+G6);
  var C36 =(K8-D36*Math.pow(1+K6,-J6))/(((1-Math.pow(1+K6,-(J6-G6)))/K6)+G6);

  var D12 = C3 * C12 / 100;

  var C9=rate(J4,C32,B26,D32,1)*12;
  var C10=rate(J5,C34,B26,D34,1)*12;
  var C11=rate(J6,C36,B26,D36,1)*12;

  var B32 = C32/B26;
  var B34 = C34/B26;
  var B36 = C36/B26;

  var F32 = C32/160;
  var F34 = C34/160;
  var F36 = C36/160;

  B9 = Format(Math.round(B9 * 100)/100,2);
  form.B9.value = B9;
  document.getElementById('B9').innerHTML = B9;

  B10 = Format(Math.round(B10 * 100)/100,2);
  form.B10.value = B10;
  document.getElementById('B10').innerHTML = B10;

  B11 = Format(Math.round(B11 * 100)/100,2);
  form.B11.value = B11;
  document.getElementById('B11').innerHTML = B11;

  C9 = Format(Math.round(C9 * 100)/100,2);
  form.C9.value = C9;
  document.getElementById('C9').innerHTML = C9;

  C10 = Format(Math.round(C10 * 100)/100,2);
  form.C10.value = C10;
  document.getElementById('C10').innerHTML = C10;

  C11 = Format(Math.round(C11 * 100)/100,2);
  form.C11.value = C11;
  document.getElementById('C11').innerHTML = C11;

  D12 = Format(Math.round(D12 * 100)/100,2);
  form.D12.value = D12;
  document.getElementById('D12').innerHTML = D12;

  B32 = Format(Math.round(B32 * 100000)/100000,5);
  form.B32.value = B32;
  document.getElementById('B32').innerHTML = B32;
  
  B34 = Format(Math.round(B34 * 100000)/100000,5);
  form.B34.value = B34;
  document.getElementById('B34').innerHTML = B34;

  B36 = Format(Math.round(B36 * 100000)/100000,5);
  form.B36.value = B36;
  document.getElementById('B36').innerHTML = B36;

  C32 = Format(Math.round(C32 * 100000)/100000,2);
  form.C32.value = C32;
  document.getElementById('C32').innerHTML = C32;
  
  C34 = Format(Math.round(C34 * 100000)/100000,2);
  form.C34.value = C34;
  document.getElementById('C34').innerHTML = C34;

  C36 = Format(Math.round(C36 * 100000)/100000,2);
  form.C36.value = C36;
  document.getElementById('C36').innerHTML = C36;

  D32 = Format(Math.round(D32 * 100000)/100000,2);
  form.D32.value = D32;
  document.getElementById('D32').innerHTML = D32;
  
  D34 = Format(Math.round(D34 * 100000)/100000,2);
  form.D34.value = D34;
  document.getElementById('D34').innerHTML = D34;

  D36 = Format(Math.round(D36 * 100000)/100000,2);
  form.D36.value = D36;
  document.getElementById('D36').innerHTML = D36;

  F32 = Format(Math.round(F32 * 100000)/100000,2);
  form.F32.value = F32;
  document.getElementById('F32').innerHTML = F32;
  
  F34 = Format(Math.round(F34 * 100000)/100000,2);
  form.F34.value = F34;
  document.getElementById('F34').innerHTML = F34;

  F36 = Format(Math.round(F36 * 100000)/100000,2);
  form.F36.value = F36;
  document.getElementById('F36').innerHTML = F36;

  document.getElementById('C2_D').innerHTML = form.C2.value;
  C3 = Format(Math.round(C3 * 100)/100,2);
  form.C3.value = C3;
  document.getElementById('C3_D').innerHTML = C3;
  C4 = Format(Math.round(C4 * 100)/100,2);
  form.C4.value = C4;
  document.getElementById('C4_D').innerHTML = C4;

  B26 = Format(Math.round(B26 * 100)/100,2);
  form.B26.value = B26;
  document.getElementById('B26').innerHTML = B26;
}

function updatevendform()
{

  var M4 = 36;
  var M5 = 48;
  var M6 = 60;
  var K9 = 1;

  form = document.calc;
  var B5 = form.B5.value;
  var B6 = form.B6.value;
  var B7 = form.B7.value;
  var B9 = form.B9.value;
  B9 = B9 / 100;

  var B10 = form.B10.value;
  var B8 = 0.1 * B10;
  var F5 = form.F5.value;
  var F6 = form.F6.value;

  var B22 = B10 - B8;

  var I5=0;
  var I6=0;
  var I7=0;

  if (B10 < 5000) {
    I5 = "too small";
    I6 = "too small";
    I7 = "too small";
  } else if (B10 < 10000) {
    I5 = B5 + 4.5;
    I6 = B6 + 4.5;
    I7 = B7 + 4.5;
  } else if (B10 < 15000) {
    I5 = B5 + 3.65;
    I6 = B6 + 3.65;
    I7 = B7 + 3.65;
  } else if (B10 < 20000) {
    I5 = B5 + 3.4;
    I6 = B6 + 3.4;
    I7 = B7 + 3.4;
  } else if (B10 < 30000) {
    I5 = B5 + 2.4;
    I6 = B6 + 2.4;
    I7 = B7 + 2.4;
  } else if (B10 < 75000) {
    I5 = B5 + 1;
    I6 = B6 + 1;
    I7 = B7 + 1;
  } else {
    I5 = B5;
    I6 = B6;
    I7 = B7;
  }

  var I8 = 0;
  if (B10 < 30000) {
     I8 = B10 * 1.1;
  } else if (B10 < 50000) {
     I8 = B10 * 1.06;
  } else if (B10 < 75000) {
     I8 = B10 * 1.05;
  } else if (B10 < 125000) {
     I8 = B10 * 1.045;
  } else if (B10 < 250000) {
     I8 = B10 * 1.035;
  } else if (B10 < 350000) {
     I8 = B10 * 1.03;
  } else if (B10 < 500000) {
     I8 = B10 * 1.025;
  } else if (B10 < 5000000) {
     I8 = B10 * 1.02;
  } else {
     I8 = B10 * 1.02;
  }

  var K4 = I5 / 1200;
  var K5 = I6 / 1200;
  var K6 = I7 / 1200;

  var I9 = I8 - B8;

  var C28;
  var C30;
  var C32;
  if (B9 < 0.05) {
    C28 = 1;
    C30 = 1;
    C32 = 1;
  } else if (B9 > 0.3) {
    C28 = "to high";
    C30 = "to high";
    C32 = "to high";
  } else {
    C28 = B9 * B10;
    C30 = B9 * B10;
    C32 = B9 * B10;
  }

  var B28 = ((I9)-C28*Math.pow((1+K4),-M4))/(((1-Math.pow((1+K4),-(M4-K9)))/K4)+K9);
  var B30 = ((I9)-C30*Math.pow((1+K5),-M5))/(((1-Math.pow((1+K5),-(M5-K9)))/K5)+K9);
  var B32 = ((I9)-C32*Math.pow((1+K6),-M6))/(((1-Math.pow((1+K6),-(M6-K9)))/K6)+K9);

  document.getElementById('A18').innerHTML = "" + F6;
  document.getElementById('A19').innerHTML = "" + F5;

  B10 = Format(Math.round(B10 * 100)/100,2);
  B8 = Format(Math.round(B8 * 100)/100,2);
  form.B8.value = B8;
  document.getElementById('B8').innerHTML = B8;

  document.getElementById('B20').innerHTML = B10;
  document.getElementById('B21').innerHTML = B8;

  B22 = Format(Math.round(B22 * 100)/100,2);
  form.B22.value = B22;
  document.getElementById('B22').innerHTML = B22;

  B28 = Format(Math.round(B28 * 100)/100,2);
  B30 = Format(Math.round(B30 * 100)/100,2);
  B32 = Format(Math.round(B32 * 100)/100,2);
  form.B28.value = B28;
  form.B30.value = B30;
  form.B32.value = B32;
  document.getElementById('B28').innerHTML = B28;
  document.getElementById('B30').innerHTML = B30;
  document.getElementById('B32').innerHTML = B32;

  C28 = Format(Math.round(C28 * 100)/100,2);
  C30 = Format(Math.round(C30 * 100)/100,2);
  C32 = Format(Math.round(C32 * 100)/100,2);
  form.C28.value = C28;
  form.C30.value = C30;
  form.C32.value = C32;
  document.getElementById('C28').innerHTML = C28;
  document.getElementById('C30').innerHTML = C30;
  document.getElementById('C32').innerHTML = C32;
}