譚惟心JavaScript 金融計算

劉任昌2021年1月期末考

現值
利率
期數
金流
終值

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

對照EXCEL金融計算

程式碼

譚惟心JavaScript 金融計算

1

<h1>劉任昌2021年1月期末考</h1>

2

​

3

<table border="1">

4

<tbody>

5

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

6

<tr><td>利率</td><td><input id="y" type="number" value="0.001" /></td></tr>

7

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

8

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

9

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

10

</tbody></table>

11

​

12

<h1>對照EXCEL先打開從範圍定義名稱</h1><div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSM31HJNovqNfr6xau8o3w0wm_ZrZSdt3koYoYPVYOqJI2v8rUvP8UQ2zfepxqXr-UO6Mch3pEDDah8F_r7dTKBPsO8u3lUv6IYKKTKRKBzgq451lq-bSKf2px2RU__6ZqAZgd7sy7Nysb/s722/%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="344" data-original-width="722" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSM31HJNovqNfr6xau8o3w0wm_ZrZSdt3koYoYPVYOqJI2v8rUvP8UQ2zfepxqXr-UO6Mch3pEDDah8F_r7dTKBPsO8u3lUv6IYKKTKRKBzgq451lq-bSKf2px2RU__6ZqAZgd7sy7Nysb/s600/%25E6%2593%25B7%25E5%258F%25962.JPG"/></a></div>

13

​

14

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

15

<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhy29h-A5I6_4hdkEGCnVRSCBNXBM6s-odL23T98JFMtWoXCzxSVFsLqdx4biUqjG0BrGcPSbYMiXzw3-mAjy_D4cf_ol0ZyotULkaXEo6-SqCLucQtJUYHyOQu20rd-zFRr6tArvlPJTcf/s722/%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="344" data-original-width="722" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhy29h-A5I6_4hdkEGCnVRSCBNXBM6s-odL23T98JFMtWoXCzxSVFsLqdx4biUqjG0BrGcPSbYMiXzw3-mAjy_D4cf_ol0ZyotULkaXEo6-SqCLucQtJUYHyOQu20rd-zFRr6tArvlPJTcf/s600/%25E6%2593%25B7%25E5%258F%25962.JPG"/></a></div>

16

<h1>程式碼</h1>

17

<script>

18

function CompF(){

19

  var y = document.getElementById("y").value; //輸入

20

  var m = document.getElementById("m").value;

21

  var p = document.getElementById("p").value;

22

  var n = document.getElementById("n").value;

23

  var fvif = y;

24

  fvif++;          // pvif = 1+y

25

  pvif = fvif ** n ; //pvif = 1/(1+y)^n

26

  var f = p * fvif - m / y * (fvif - 1) ;

27

  document.getElementById("f_").innerHTML = f.toFixed(6);

28

}

29

function CompN(){    //輸入y, m, p, f 計算 n 

30

  var y = document.getElementById("y").value;

31

  var m = document.getElementById("m").value;

32

  var p = document.getElementById("p").value;

33

  var f = document.getElementById("f").value;

34

  var pvif = y;

35

  pvif++;        // pvif = 1+y

36

  var n = Math.log( ( f - m/y )/( p - m/y ) )/Math.log( pvif ) ;

37

  document.getElementById("n_").innerHTML = n.toFixed(2);

38

}

39

function CompM(){

40

  var y = document.getElementById("y").value;

41

  var n = document.getElementById("n").value;

42

  var p = document.getElementById("p").value;

43

  var f = document.getElementById("f").value;

44

  var pvif = y;