<style>
h1{border: 30px outset lightgreen;
background-color: lightpink;
color: white;
text-align: center;}
</style>
<script>
function computePV(){
var r = document.getElementById("rate").value;
var n = document.getElementById("nper").value;
var m = document.getElementById("pmt").value;
var f = document.getElementById("fv").value;
pvif =r;
pvif++;
pvif =1/pvif**n;
var pv = (1-pvif)*m/r + f * pvif;
document.getElementById("pv").innerHTML = pv;
}
</script>
<body>
<table border="1">
<tr><td>利率y(rate)</td><td>期數n(nper)</td><td>金流m(pmt)</td><td>終值f(fv)</td></tr>
<td><input id="rate" type="number"/></td>
<td><input id="nper" type="number" /></td>
<td><input id="pmt" type="number" /></td>
<td><input id="fv" type="number" /></td></tr>
</table>
<input onclick="computePV()" type="button" value="計算現值" />
<p id="pv"></p>
<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHB9hSuK2rlwMySJc9KMfYAoa6W8TjMA8NQ5V_jx5mMi4F89JYVvk5fi74T2TVDu5a5amXgcygiMkHJCE4zzRPF-9FAoosiL_BchBMEgsEPj1W0qis5Y4hPMlIWAPEQ2X5sbG4CAc8q3d3/s291/%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="49" data-original-width="291" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHB9hSuK2rlwMySJc9KMfYAoa6W8TjMA8NQ5V_jx5mMi4F89JYVvk5fi74T2TVDu5a5amXgcygiMkHJCE4zzRPF-9FAoosiL_BchBMEgsEPj1W0qis5Y4hPMlIWAPEQ2X5sbG4CAc8q3d3/s600/%25E6%2593%25B7%25E5%258F%2596.PNG"/></a></div>
<p>參考劉任昌金融市場講義https://drive.google.com/file/d/17z6UZgN5fC2XCO1L8_BQs57dgQXzbwou/view?usp=sharing<p>
<h1>劉任昌學習HTML+CSS+JavaScript程式碼<h1/>
</body>
import openpyxl #蔣姿如輸入import openpyxl處理EXCEL的函式庫 book = openpyxl.load_workbook(r'wb.xlsx') #開啟EXCEL工作簿wb.xlsx print("1. 列出所...
沒有留言:
張貼留言