陳鈺晴程式設計期末考

2021年1月期末考

現值
利率
期數
金流
終值

程式碼

<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 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="CompN()" type="button" value="計算期數" /></td><td id="n_"></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></tr>

</tbody></table>

<h1>對應的EXCEL</h1>

<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigSMb1Fkx1laiqIiBdrrpNSYOBhYB46Hvx_GC3UDqSBADMx3Cb8TrbmBZJDVmsbia4La6K2hF6YkzvTACreHcdBpV23xpzZA4ahw6BftlZIJ6PLnFkr8FOk_T_oIjMs-Eandh7dH1K60XN/s907/1.JPG" style="display: block; padding: 1em 0px; text-align: center;"><img alt="" border="0" data-original-height="410" data-original-width="907" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigSMb1Fkx1laiqIiBdrrpNSYOBhYB46Hvx_GC3UDqSBADMx3Cb8TrbmBZJDVmsbia4La6K2hF6YkzvTACreHcdBpV23xpzZA4ahw6BftlZIJ6PLnFkr8FOk_T_oIjMs-Eandh7dH1K60XN/s600/1.JPG" width="600" /></a></div>

<h2>開啟從選取範圍建立名稱</h2>

<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiW8hLzp3r2MIAlPc6n7y4DDa_h_jRkz1GhSStNXQe91mLtehgbAjBQC_F2dFhKWcBlFyUtZ0dZH9iK48VPAbuVmfo-a1opMhqEr6asnUonCj2YbNQrdGjWV53ynEVCvus1ci4PI8mK_MB_/s899/2.JPG" style="display: block; padding: 1em 0px; text-align: center;"><img alt="" border="0" data-original-height="490" data-original-width="899" height="349" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiW8hLzp3r2MIAlPc6n7y4DDa_h_jRkz1GhSStNXQe91mLtehgbAjBQC_F2dFhKWcBlFyUtZ0dZH9iK48VPAbuVmfo-a1opMhqEr6asnUonCj2YbNQrdGjWV53ynEVCvus1ci4PI8mK_MB_/w640-h349/2.JPG" width="640" /></a></div>

<h1>程式碼</h1><br /><script>

function CompN(){     //輸入y,m,p,f 計算 n

  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)

}  

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)

}

</script>