林佑儒2021年1月期末考

現值
利率
期數
金流
終值

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

林佑儒對照EXCEL金融計算

程式碼

<style>

h1{border: 30px outset red;  

  background-color: green;  

  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" /></td><td><input onclick="CompY()" type="button" value="計算利率" /></td><td id="y_" width="160"></td></tr>

<tr><td>期數</td><td><input id="n" type="number" /></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></tr>

</tbody></table>

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

<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBzbvMvZQzRXhFGs0cDiCsBXbHDQ_FSseCrnmZZmZS1UxOPnmysZ07SciFqoBsxVI9CUlBI-Q3ANOteJ0XqARFZP3PdG7esCJV6QJR3z1cDxehgF0rlt7H9YDvL2nQMzHEgWtQg0Blw48/s773/%25E6%2593%25B7%25E5%258F%25961.JPG" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="600" data-original-height="478" data-original-width="773" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBzbvMvZQzRXhFGs0cDiCsBXbHDQ_FSseCrnmZZmZS1UxOPnmysZ07SciFqoBsxVI9CUlBI-Q3ANOteJ0XqARFZP3PdG7esCJV6QJR3z1cDxehgF0rlt7H9YDvL2nQMzHEgWtQg0Blw48/s600/%25E6%2593%25B7%25E5%258F%25961.JPG"/></a></div>

<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3jL1Xmt62iiQvv2rTgbjn8CF7No4zRComIBlWrl2Su5Ql3TQmi5Ry8clCd3Rre-tTYajUOGOFGHC4UtI5xW5Yoojaf5anZtqZT5nxgg7_C8oRN4DYjuOT8HTPst6a22RxBcGH2W5XAFQ/s690/%25E6%2593%25B7%25E5%258F%2596.PNG" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="600" data-original-height="538" data-original-width="690" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3jL1Xmt62iiQvv2rTgbjn8CF7No4zRComIBlWrl2Su5Ql3TQmi5Ry8clCd3Rre-tTYajUOGOFGHC4UtI5xW5Yoojaf5anZtqZT5nxgg7_C8oRN4DYjuOT8HTPst6a22RxBcGH2W5XAFQ/s600/%25E6%2593%25B7%25E5%258F%2596.PNG"/></a></div>

<h1>林佑儒對照EXCEL金融計算</h1>

<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgN2luWR0w3vjO7Tv03GBatTkBNP2tvf8I-kuPIDNDwd8TYXzUfLp1SSqXpTBAYd2V7-9KLoQkDmadwu4yG8NUAOkPPCLrCoxZXFOoJcKtmUw_rZQ4ti-GlkHObd8SN8uwR6vyZeUmXOBs/s791/%25E6%2593%25B7%25E5%258F%25962.JPG" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="600" data-original-height="403" data-original-width="791" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgN2luWR0w3vjO7Tv03GBatTkBNP2tvf8I-kuPIDNDwd8TYXzUfLp1SSqXpTBAYd2V7-9KLoQkDmadwu4yG8NUAOkPPCLrCoxZXFOoJcKtmUw_rZQ4ti-GlkHObd8SN8uwR6vyZeUmXOBs/s600/%25E6%2593%25B7%25E5%258F%25962.JPG"/></a></div>

<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibwmZaE99bpjGqBmCiz19nZerNsXpH0CbAzVeRwocsJHKRMNVA5WcEsvPyUApiOQ6qmlo3hQ1cOxcVYYbaqehgYHQK_mlUjxk-FQXbCG4JSNkl-7fQd7Wn3LuZ1bYmGg1ed0UyWIPYPAQ/s835/%25E6%2593%25B7%25E5%258F%25962.PNG" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="600" data-original-height="446" data-original-width="835" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibwmZaE99bpjGqBmCiz19nZerNsXpH0CbAzVeRwocsJHKRMNVA5WcEsvPyUApiOQ6qmlo3hQ1cOxcVYYbaqehgYHQK_mlUjxk-FQXbCG4JSNkl-7fQd7Wn3LuZ1bYmGg1ed0UyWIPYPAQ/s600/%25E6%2593%25B7%25E5%258F%25962.PNG"/></a></div>

<h1>程式碼</h1>

<script>

function CompY(){

  document.getElementById("y_").innerHTML = "像兒童一般的學";   //輸出字串  老師說以後學 像兒童一般的學

}

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 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>