第十八週期末考：沈育萍

沈育萍2021年1月期末考

現值
利率
期數
金流
終值

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

對照Excel金融計算

程式碼

<style>

h1{

  border: 15px outset skyblue;  

  background-color: pink;  

  color: white;

  text-align: center;

    }

</style>

<h1>沈育萍2021年1月期末考</h1>

<!--輸出現值計算結果到td--><table border="1">

<tbody>

<tr><td>現值</td><td><input id="p" type="number" /></td><td><input onclick="CompP()" type="button" value="計算現值" /></td><td id="p_" width="160"></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="CompQ()" type="button" value="計算期數" /></td><td id="q_"></td></tr>

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

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

</tbody></table>

<script>

function CompA(){

  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 a = p * fvif - m / y * (fvif - 1) ;

  document.getElementById("a_").innerHTML = a;

}

function CompP(){    //計算現值 p

  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;

}

function CompQ(){    //計算期數 q

  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 q = Math.log((f - m/y )/(p - m/y ))/Math.log( pvif )

  document.getElementById("q_").innerHTML = q;

}  

function CompM(){    //計算金流 m

  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++;         //pvif= 利率+1

  pvif =1/pvif**n;   //pvif= 1 / (利率+1)^n

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

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

}

</script>

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

<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQZhL9wBQUL-RCPKXEs_CXHGIii_YjjSaTM3f9WZ0bUAEIjolwu9on8Wxg4vMW1BERnKvYX3DG0WZq9wdC-Y8YXG7Ru_E8UyswGgL9Xoqjka60T_1G_VdIqC9cOXx-4QJQ5ER7088we2NY/s666/%25E5%25AE%259A%25E7%25BE%25A9.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="362" data-original-width="666" height="348" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQZhL9wBQUL-RCPKXEs_CXHGIii_YjjSaTM3f9WZ0bUAEIjolwu9on8Wxg4vMW1BERnKvYX3DG0WZq9wdC-Y8YXG7Ru_E8UyswGgL9Xoqjka60T_1G_VdIqC9cOXx-4QJQ5ER7088we2NY/w640-h348/%25E5%25AE%259A%25E7%25BE%25A9.JPG" width="640" /></a>

 

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

  

<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlwf_K-2Rm9A9l7LwHrIW7CGIMO8RxIvIh9mSYGubLXH6bEpZdUZlmfTIgu9aEcWBQHKlP5pZoA-bLwr_OkDotulKe9B9alvrMmWhkjA0GYhobQuiB9JccYQ5h0xBbm6W8qzJAwMdIHI34/s485/%25E5%25AE%259A%25E7%25BE%25A91.JPG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="224" data-original-width="485" height="296" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlwf_K-2Rm9A9l7LwHrIW7CGIMO8RxIvIh9mSYGubLXH6bEpZdUZlmfTIgu9aEcWBQHKlP5pZoA-bLwr_OkDotulKe9B9alvrMmWhkjA0GYhobQuiB9JccYQ5h0xBbm6W8qzJAwMdIHI34/w640-h296/%25E5%25AE%259A%25E7%25BE%25A91.JPG" width="640" /></a>