陳聖武

發表文章

目前顯示的是 12月, 2020的文章

第17周

12月 27, 2020

陳聖武2021年1月期末考現值利率期數金流終值 <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="180"></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_" width="100"></td></tr> <tr><td>金流</td><td><input id="m" type="number" value="0"/></td><td><input oncl...

閱讀完整內容

第十五

12月 13, 2020

利率y(rate) 期數n(nper) 金流m(pmt) 終值f(fv) 參考劉任昌金融市場講義https://drive.google.com/file/d/17z6UZgN5fC2XCO1L8_BQs57dgQXzbwou/view?usp=sharing 陳聖武學習HTML+CSS+JavaScript程式碼 <style> h1{border: 30px outset red; background-color: green; 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" ty...

閱讀完整內容

第十四

12月 13, 2020

Dim n As Integer Dim spec As String Const period As Integer = 4 Const maxerror As Double = 0.0000001 Dim payment(period) As Double '廣域變數 4 維度的陣列 Private Sub CommandButton1_Click() Dim a, b, c, f, gap As Double Dim loopNumber As Integer n = n + 1 '第幾次計算+1 a = 0 '報酬率0 b = 1 '報酬率1 gap = 10 loopNumber = 10 payment(0) = TextBox1.Value payment(1) = TextBox2.Value payment(2) = TextBox3.Value payment(3) = TextBox4.Value f = npv(a) If f = 0 Then Label9.Caption = 0 ElseIf f < 0 Then Label9.Caption = "內部報酬率小於 0." Else Do While gap > mexerror And Abs(f) > maxerror And loopNumber < 100 loopNumber = loopNumber + 1 c = (a + b) / 2 f = npv(c) If Abs(f) > maxerror And gap >...

閱讀完整內容

第十三周

12月 13, 2020

<pre> Const period As Integer = 4 Const maxerror As Double = 0.0000001 Dim payment(period) As Double '廣域變數 4 維度的陣列 Private Sub CommandButton1_Click() Dim a, b, c, f, gap As Double Dim loopNumber As Integer a = 0 b = 1 gap = 10 loopNumber = 10 payment(0) = TextBox1.Value payment(1) = TextBox2.Value payment(2) = TextBox3.Value payment(3) = TextBox4.Value f = npv(a) If f = 0 Then Label9.Caption = 0 ElseIf f < 0 Then Label9.Caption = "內部報酬率小於 0." Else Do While gap > mexerror And Abs(f) > maxerror And loopNumber < 100 loopNumber = loopNumber + 1 c = (a + b) / 2 f = npv(c) If Abs(f) > maxerror And gap > maxerror Then If f > 0 Then ...

閱讀完整內容

第十二周

12月 06, 2020

躉繳第1期第2期第3期注意，包含首期躉繳的現金流量都大於0。報酬率: 淨現值: 迴圈次數: 陳聖武向劉任昌學習的程式碼 <head> <style> .Takming { border: 20px outset red; background-color: green; color: white; text-align: center; } .qwe{ width: 80pt; height: 20pt; background-color: purple; color: white; font-weight:bold; text-align: right; } </style> </head> <table border="1"> <tbody><tr align="center"><td>躉繳</td><td>第1期</td><td>第2期</td><td>第3期</td></tr> <tr><td><input class="qwe" type="number" /></td> <td><input class="qwe" type="number" /></td> <td><input class="qwe" type="number" /> </td><td><input class="qwe" type="number" /></td></tr>...

閱讀完整內容