期末考
周信佑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" 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><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/AVvXsEh8eXNyzk61AeqsEX3P9XXAiC12J5PhcReKSGu6fpw8IuhZzIQQZsAe8BJS0dU8p6MrW131S2vWfFmCigWSg9dO0MHlEiAI1boKAUEwUv8qX-FOwEVECuNF7hODM0XFJMMUw4qJRgP2I4s/s737/%25E6%2593%25B7%25E5%258F%2596.JPG" style="display: block; padding: 1em 0px; text-align: center;"><img alt="" border="0" data-original-height="352" data-original-width="737" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8eXNyzk61AeqsEX3P9XXAiC12J5PhcReKSGu6fpw8IuhZzIQQZsAe8BJS0dU8p6MrW131S2vWfFmCigWSg9dO0MHlEiAI1boKAUEwUv8qX-FOwEVECuNF7hODM0XFJMMUw4qJRgP2I4s/s600/%25E6%2593%25B7%25E5%258F%2596.JPG" width="600" /></a></div>
<h1>對照EXCEL金融計算</h1>
<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxz-PhEP7bjZwQs6-jSw9ESIlHpnSOKxa45gchKUZnUm0auMsI0WadJY1kZUXAbu9rdLoht88S83aY5zI9-wAP-WwtQSUN3Y2Y2xh3_dB7panwnaoAfEISM3msrThXET0jF1xQJqyKNvU/s575/%25E6%2593%25B7%25E5%258F%25961.JPG" style="display: block; padding: 1em 0px; text-align: center;"><img alt="" border="0" data-original-height="204" data-original-width="575" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxz-PhEP7bjZwQs6-jSw9ESIlHpnSOKxa45gchKUZnUm0auMsI0WadJY1kZUXAbu9rdLoht88S83aY5zI9-wAP-WwtQSUN3Y2Y2xh3_dB7panwnaoAfEISM3msrThXET0jF1xQJqyKNvU/s600/%25E6%2593%25B7%25E5%258F%25961.JPG" width="600" /></a></div>
<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><!--輸出現值計算結果到 td--><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/AVvXsEh8eXNyzk61AeqsEX3P9XXAiC12J5PhcReKSGu6fpw8IuhZzIQQZsAe8BJS0dU8p6MrW131S2vWfFmCigWSg9dO0MHlEiAI1boKAUEwUv8qX-FOwEVECuNF7hODM0XFJMMUw4qJRgP2I4s/s737/%25E6%2593%25B7%25E5%258F%2596.JPG" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="600" data-original-height="352" data-original-width="737" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8eXNyzk61AeqsEX3P9XXAiC12J5PhcReKSGu6fpw8IuhZzIQQZsAe8BJS0dU8p6MrW131S2vWfFmCigWSg9dO0MHlEiAI1boKAUEwUv8qX-FOwEVECuNF7hODM0XFJMMUw4qJRgP2I4s/s600/%25E6%2593%25B7%25E5%258F%2596.JPG"/></a></div></div><div><h1>對照EXCEL金融計算</h1></div><div><div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxz-PhEP7bjZwQs6-jSw9ESIlHpnSOKxa45gchKUZnUm0auMsI0WadJY1kZUXAbu9rdLoht88S83aY5zI9-wAP-WwtQSUN3Y2Y2xh3_dB7panwnaoAfEISM3msrThXET0jF1xQJqyKNvU/s575/%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="204" data-original-width="575" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxz-PhEP7bjZwQs6-jSw9ESIlHpnSOKxa45gchKUZnUm0auMsI0WadJY1kZUXAbu9rdLoht88S83aY5zI9-wAP-WwtQSUN3Y2Y2xh3_dB7panwnaoAfEISM3msrThXET0jF1xQJqyKNvU/s600/%25E6%2593%25B7%25E5%258F%25961.JPG"/></a></div></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>
<script>
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>
做得很好！https://www.facebook.com/robertjcliu/posts/3976749985669533
回覆刪除