程式設計084曾柏勳

曾柏勳2021年1月期末考

現值
利率
期數
金流
終值

對照EXCEL先打開從範圍定義名稱

對照EXCEL金融計算

程式碼

<h1>曾柏勳2021年1月期末考</h1>

<table border="1">

<tbody>

<tr><td>現值</td><td><input id="p" type="number" /></td><td><input onclick="CompP()" type="button" value="計算現值" /></td><td width=100 id="p_"></td></tr>

<tr><td>利率</td><td><input id="y" type="number" value="0.001" /></td></tr>

<tr><td>期數</td><td><input id="n" type="number" value="240" /></td><td><input onclick="CompN()" type="button" value="計算期數" /></td><td id="n_"></td></tr>

<tr><td>金流</td><td><input id="m" type="number" /></td><td><input onclick="CompM()" type="button" value="計算金流" /></td><td id="m_"></td></tr>

<tr><td>終值</td><td><input id="f" type="number" /></td><td><input onclick="CompF()" type="button" value="計算終值" /></td><td id="f_"></td>

</tbody></table>

<h1>對照EXCEL先打開從範圍定義名稱</h1>

<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnxlK3OsKbHu5tgHqh9JCS4LD1A9pZKJLK7FG64_hFRv0fDMmb1KJedMWwgIG6LN9_9F5XgN74MDcTzj7okhGVhRx8q0zl7TNqT_-FFFRpwFNx7QnDVSa330btR5U9PDg9MiEskQdHuHc/s778/111111.JPG" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="320" data-original-height="724" data-original-width="778" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnxlK3OsKbHu5tgHqh9JCS4LD1A9pZKJLK7FG64_hFRv0fDMmb1KJedMWwgIG6LN9_9F5XgN74MDcTzj7okhGVhRx8q0zl7TNqT_-FFFRpwFNx7QnDVSa330btR5U9PDg9MiEskQdHuHc/s320/111111.JPG"/></a></div>

<h1>對照EXCEL金融計算</h1>

<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGW51JKcVLu46OGsnI8s81YRhHRG3Suqc7mRkJg0B0IO_g-j295zfEWOk96JclNLNxPvphkg1jRZf9r53HurtLpvZOSuYXc1C0pnoPdOhnK5owgQa8g6kd7GEsqz-WcZUfIxz7O1hJ3xc/s1000/22222.JPG" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="320" data-original-height="884" data-original-width="1000" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGW51JKcVLu46OGsnI8s81YRhHRG3Suqc7mRkJg0B0IO_g-j295zfEWOk96JclNLNxPvphkg1jRZf9r53HurtLpvZOSuYXc1C0pnoPdOhnK5owgQa8g6kd7GEsqz-WcZUfIxz7O1hJ3xc/s320/22222.JPG"/></a></div>

<h1>程式碼</h1>

<script>

  function CompF(){

  var y = document.getElementById("y").value; //輸入

  var m = document.getElementById("m").value;

  var p = document.getElementById("p").value;

  var n = document.getElementById("n").value;

  var fvif = y;

  fvif++;          // pvif = 1+y

  pvif = fvif ** n ; //pvif = 1/(1+y)^n

  var f = p * fvif - m / y * (fvif - 1) ;

  document.getElementById("f_").innerHTML = f.toFixed(6);

  

  

function CompM(){

  var y = document.getElementById("y").value;

  var n = document.getElementById("n").value;

  var p = document.getElementById("p").value;

  var f = document.getElementById("f").value;

  var pvif = y;

  pvif++;

  pvif =1/pvif**n;

  var m = y * (p - f * pvif ) / (1 - pvif);

  document.getElementById("m_").innerHTML = m.toFixed(2);

}

function CompP(){

  var y = document.getElementById("y").value;

  var n = document.getElementById("n").value;

  var m = document.getElementById("m").value;

  var f = document.getElementById("f").value;

  var pvif = y;

  pvif++;

  pvif =1/pvif**n;

  var p = (1-pvif)*m/y + f * pvif;

  document.getElementById("p_").innerHTML = p.toFixed(2);

}

function CompN(){

  var y = document.getElementById("y").value;

  var m = document.getElementById("m").value;

  var p = document.getElementById("p").value;

  var f = document.getElementById("f").value;

  var pvif = y;

  pvif++;  //新的pvif = 1+y

  var n = Math.log((f - m/y)/(p - m/y))/Math.log( pvif );

  document.getElementById("n_").innerHTML = n.toFixed(2);

}

</script>