徐煒智2021年1月期末考

現值
利率
期數
金流
終值

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

對照EXCEL金融計算

程式碼

<style>

h1{border: 30px outset red;

background-color: green;

color: white;

text-align: center;}

</style>

<table border="1">

<tbody>

</tbody></table>

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

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

<h1>程式碼</h1><div><div><style></div><div>h1{border: 30px outset red;  </div><div>  background-color: green;  </div><div>  color: white;</div><div>  text-align: center;}</div><div></style></div><div><h1>徐煒智2021年1月期末考</h1></div><div><br /></div><div><table border="1"></div><div><tbody></div><div><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></div><div><tr><td>利率</td><td><input id="y" type="number" /></td></tr></div><div><tr><td>期數</td><td><input id="n" type="number" /></td><td><input onclick="CompN()" type="button" value="計算期數" /></td><td id="n_"></td></tr></div><div><tr><td>金流</td><td><input id="m" type="number" /></td><td><input onclick="CompM()" type="button" value="計算金流" /></td><td id="m_"></td></tr></div><div><tr><td>終值</td><td><input id="f" type="number" /></td><td><input onclick="CompF()" type="button" value="計算終值" /></td><td id="f_"></td></tr></div><div></tbody></table></div><div><br /></div><div><h1>對照EXCEL先打開從範圍定義名稱</h1></div><div><div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhl2tJVY6Cs5EK2Vzuw5qdmKqKWpCrLJKAcHsj6Ru1wSxVYAjZsIOkc0TBfoSSe5VzdRAgSpfg_VSGSBG4W0Gv9KLy5zp80cSGRwQYPqaXQcn02Qeueouq1wMhyGD-LVi0B80nYP_lUJ6kI/s752/1.JPG" style="display: block; padding: 1em 0px; text-align: center;"><img alt="" border="0" data-original-height="564" data-original-width="752" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhl2tJVY6Cs5EK2Vzuw5qdmKqKWpCrLJKAcHsj6Ru1wSxVYAjZsIOkc0TBfoSSe5VzdRAgSpfg_VSGSBG4W0Gv9KLy5zp80cSGRwQYPqaXQcn02Qeueouq1wMhyGD-LVi0B80nYP_lUJ6kI/s600/1.JPG" width="600" /></a></div></div><div><br /></div><div><h1>對照EXCEL金融計算</h1></div><div><div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEioTSBTeJ7J4rlF0QaXvEEmh9l65xydNfcNh7QAUoZJgsX5jOJieKhTmu26SGPRUXI7Fv25qLyLQ8f-ORA91Cszfqv5IZmj8CwwfpTLcfHQ6uNEop1bv_DrFcKDi_3VjW5OMTuSAWEJgNc5/s1072/2.JPG" style="display: block; padding: 1em 0px; text-align: center;"><img alt="" border="0" data-original-height="380" data-original-width="1072" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEioTSBTeJ7J4rlF0QaXvEEmh9l65xydNfcNh7QAUoZJgsX5jOJieKhTmu26SGPRUXI7Fv25qLyLQ8f-ORA91Cszfqv5IZmj8CwwfpTLcfHQ6uNEop1bv_DrFcKDi_3VjW5OMTuSAWEJgNc5/s600/2.JPG" width="600" /></a></div></div><div><br /></div><div><h1>程式碼</h1></div><div><br /></div><div><script></div><div>function CompF(){</div><div>  var y = document.getElementById("y").value; //輸入</div><div>  var m = document.getElementById("m").value;</div><div>  var p = document.getElementById("p").value;</div><div>  var n = document.getElementById("n").value;</div><div>  var fvif = y;</div><div>  fvif++;          // pvif = 1+y</div><div>  pvif = fvif ** n ; //pvif = 1/(1+y)^n</div><div>  var f = p * fvif - m / y * (fvif - 1) ;</div><div>  document.getElementById("f_").innerHTML = f.toFixed(6);</div><div>}</div><div>function CompN(){    //輸入y, m, p, f 計算 n </div><div>  var y = document.getElementById("y").value;</div><div>  var m = document.getElementById("m").value;</div><div>  var p = document.getElementById("p").value;</div><div>  var f = document.getElementById("f").value;</div><div>  var pvif = y;</div><div>  pvif++;        // pvif = 1+y</div><div>  var n = Math.log( ( f - m/y )/( p - m/y ) )/Math.log( pvif ) ;</div><div>  document.getElementById("n_").innerHTML = n.toFixed(2);</div><div>}</div><div>function CompM(){</div><div>  var y = document.getElementById("y").value;</div><div>  var n = document.getElementById("n").value;</div><div>  var p = document.getElementById("p").value;</div><div>  var f = document.getElementById("f").value;</div><div>  var pvif = y;</div><div>  pvif++;</div><div>  pvif =1/pvif**n;</div><div>  var m = y*( p - f * pvif )/( 1 - pvif ) ;</div><div>  document.getElementById("m_").innerHTML = m.toFixed(2);</div><div>}</div><div>function CompP(){</div><div>  var y = document.getElementById("y").value;</div><div>  var n = document.getElementById("n").value;</div><div>  var m = document.getElementById("m").value;</div><div>  var f = document.getElementById("f").value;</div><div>  var pvif = y;</div><div>  pvif++;</div><div>  pvif =1/pvif**n;</div><div>  var p = (1-pvif)*m/y + f * pvif;</div><div>  document.getElementById("p_").innerHTML = p.toFixed(2);</div><div>}</div><div><br /></div><div></script></div><div><br /></div></div>

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>

搜尋此網誌

徐煒智金一甲5號

第十八周期末考

徐煒智2021年1月期末考

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

對照EXCEL金融計算

程式碼

留言

張貼留言

這個網誌中的熱門文章

第九周流程圖與影片製作(徐煒智)

第二周

第九周