interest rate - power vs exp

4
r Q t Qt1 Qt2 DIFF %DEFF 0.05 1 1 1.05 1.051271 0.001271 0.12% 2 1.1025 1.105171 0.002671 0.24% 3 1.157625 1.161834 0.004209 0.36% 4 1.215506 1.221403 0.005897 0.48% 5 1.276282 1.284025 0.007744 0.60% 6 1.340096 1.349859 0.009763 0.72% 7 1.4071 1.419068 0.011967 0.84% 8 1.477455 1.491825 0.014369 0.96% 9 1.551328 1.568312 0.016984 1.08% 10 1.628895 1.648721 0.019827 1.20% 11 1.710339 1.733253 0.022914 1.32% 12 1.795856 1.822119 0.026262 1.44% 13 1.885649 1.915541 0.029892 1.56% 14 1.979932 2.013753 0.033821 1.68% 15 2.078928 2.117 0.038072 1.80% 16 2.182875 2.225541 0.042666 1.92% 17 2.292018 2.339647 0.047629 2.04% 18 2.406619 2.459603 0.052984 2.15% 19 2.52695 2.58571 0.058759 2.27% 20 2.653298 2.718282 0.064984 2.39% 21 2.785963 2.857651 0.071689 2.51% 22 2.925261 3.004166 0.078905 2.63% 23 3.071524 3.158193 0.086669 2.74% 24 3.2251 3.320117 0.095017 2.86% 25 3.386355 3.490343 0.103988 2.98% 26 3.555673 3.669297 0.113624 3.10% 27 3.733456 3.857426 0.123969 3.21% 28 3.920129 4.0552 0.135071 3.33% 29 4.116136 4.263115 0.146979 3.45% 30 4.321942 4.481689 0.159747 3.56% 31 4.538039 4.71147 0.173431 3.68% 32 4.764941 4.953032 0.188091 3.80% 33 5.003189 5.20698 0.203791 3.91% 34 5.253348 5.473947 0.220599 4.03% 35 5.516015 5.754603 0.238587 4.15% 36 5.791816 6.049647 0.257831 4.26% 37 6.081407 6.35982 0.278413 4.38% 38 6.385477 6.685894 0.300417 4.49% 39 6.704751 7.028688 0.323936 4.61% 40 7.039989 7.389056 0.349067 4.72% 41 7.391988 7.767901 0.375913 4.84% 42 7.761588 8.16617 0.404582 4.95% 43 8.149667 8.584858 0.435191 5.07% 44 8.55715 9.025013 0.467863 5.18% 45 8.985008 9.487736 0.502728 5.30% 46 9.434258 9.974182 0.539924 5.41% 47 9.905971 10.48557 0.579599 5.53% 48 10.40127 11.02318 0.621907 5.64% 49 10.92133 11.58835 0.667014 5.76% 0.00% 2.00% 4.00% 6.00% 8.00% 10.00% 12.00% 14.00% 0 20

Upload: newscribdmember

Post on 13-Dec-2015

215 views

Category:

Documents


1 download

DESCRIPTION

Interest Rate - Power vs Exp

TRANSCRIPT

Page 1: Interest Rate - Power vs Exp

r Q t Qt1 Qt2 DIFF %DEFF

0.05 1 1 1.05 1.051271 0.001271 0.12%

2 1.1025 1.105171 0.002671 0.24%

3 1.157625 1.161834 0.004209 0.36%

4 1.215506 1.221403 0.005897 0.48%

5 1.276282 1.284025 0.007744 0.60%

6 1.340096 1.349859 0.009763 0.72%

7 1.4071 1.419068 0.011967 0.84%

8 1.477455 1.491825 0.014369 0.96%

9 1.551328 1.568312 0.016984 1.08%

10 1.628895 1.648721 0.019827 1.20%

11 1.710339 1.733253 0.022914 1.32%

12 1.795856 1.822119 0.026262 1.44%

13 1.885649 1.915541 0.029892 1.56%

14 1.979932 2.013753 0.033821 1.68%

15 2.078928 2.117 0.038072 1.80%

16 2.182875 2.225541 0.042666 1.92%

17 2.292018 2.339647 0.047629 2.04%

18 2.406619 2.459603 0.052984 2.15%

19 2.52695 2.58571 0.058759 2.27%

20 2.653298 2.718282 0.064984 2.39%

21 2.785963 2.857651 0.071689 2.51%

22 2.925261 3.004166 0.078905 2.63%

23 3.071524 3.158193 0.086669 2.74%

24 3.2251 3.320117 0.095017 2.86%

25 3.386355 3.490343 0.103988 2.98%

26 3.555673 3.669297 0.113624 3.10%

27 3.733456 3.857426 0.123969 3.21%

28 3.920129 4.0552 0.135071 3.33%

29 4.116136 4.263115 0.146979 3.45%

30 4.321942 4.481689 0.159747 3.56%

31 4.538039 4.71147 0.173431 3.68%

32 4.764941 4.953032 0.188091 3.80%

33 5.003189 5.20698 0.203791 3.91%

34 5.253348 5.473947 0.220599 4.03%

35 5.516015 5.754603 0.238587 4.15%

36 5.791816 6.049647 0.257831 4.26%

37 6.081407 6.35982 0.278413 4.38%

38 6.385477 6.685894 0.300417 4.49%

39 6.704751 7.028688 0.323936 4.61%

40 7.039989 7.389056 0.349067 4.72%

41 7.391988 7.767901 0.375913 4.84%

42 7.761588 8.16617 0.404582 4.95%

43 8.149667 8.584858 0.435191 5.07%

44 8.55715 9.025013 0.467863 5.18%

45 8.985008 9.487736 0.502728 5.30%

46 9.434258 9.974182 0.539924 5.41%

47 9.905971 10.48557 0.579599 5.53%

48 10.40127 11.02318 0.621907 5.64%

49 10.92133 11.58835 0.667014 5.76%

0.00%

2.00%

4.00%

6.00%

8.00%

10.00%

12.00%

14.00%

0 20

Page 2: Interest Rate - Power vs Exp

50 11.4674 12.18249 0.715094 5.87%

51 12.04077 12.8071 0.766334 5.98%

52 12.64281 13.46374 0.82093 6.10%

53 13.27495 14.15404 0.87909 6.21%

54 13.9387 14.87973 0.941036 6.32%

55 14.63563 15.64263 1.007001 6.44%

56 15.36741 16.44465 1.077234 6.55%

57 16.13578 17.28778 1.151999 6.66%

58 16.94257 18.17415 1.231573 6.78%

59 17.7897 19.10595 1.316253 6.89%

60 18.67919 20.08554 1.406351 7.00%

61 19.61315 21.11534 1.502199 7.11%

62 20.5938 22.19795 1.604149 7.23%

63 21.62349 23.33606 1.712572 7.34%

64 22.70467 24.53253 1.827863 7.45%

65 23.8399 25.79034 1.950439 7.56%

66 25.0319 27.11264 2.080743 7.67%

67 26.28349 28.50273 2.219243 7.79%

68 27.59766 29.9641 2.366435 7.90%

69 28.97755 31.50039 2.522844 8.01%

70 30.42643 33.11545 2.689026 8.12%

71 31.94775 34.81332 2.865571 8.23%

72 33.54513 36.59823 3.0531 8.34%

73 35.22239 38.47467 3.252275 8.45%

74 36.98351 40.4473 3.463794 8.56%

75 38.83269 42.52108 3.688396 8.67%

76 40.77432 44.70118 3.926864 8.78%

77 42.81304 46.99306 4.180027 8.89%

78 44.95369 49.40245 4.448761 9.01%

79 47.20137 51.93537 4.733994 9.12%

80 49.56144 54.59815 5.036709 9.23%

81 52.03951 57.39746 5.357944 9.33%

82 54.64149 60.34029 5.698799 9.44%

83 57.37356 63.434 6.060437 9.55%

84 60.24224 66.68633 6.44409 9.66%

85 63.25435 70.10541 6.851059 9.77%

86 66.41707 73.69979 7.282723 9.88%

87 69.73792 77.47846 7.740538 9.99%

88 73.22482 81.45087 8.226048 10.10%

89 76.88606 85.62694 8.740882 10.21%

90 80.73037 90.01713 9.286766 10.32%

91 84.76688 94.63241 9.865525 10.43%

92 89.00523 99.48432 10.47909 10.53%

93 93.45549 104.585 11.1295 10.64%

94 98.12826 109.9472 11.81891 10.75%

95 103.0347 115.5843 12.54961 10.86%

96 108.1864 121.5104 13.32401 10.97%

97 113.5957 127.7404 14.14466 11.07%

98 119.2755 134.2898 15.01426 11.18%

99 125.2393 141.175 15.93567 11.29%

Page 3: Interest Rate - Power vs Exp

100 131.5013 148.4132 16.9119 11.40%

Page 4: Interest Rate - Power vs Exp

y = 0.0011x + 0.0012 R² = 0.9998

20 40 60 80 100 120

%DEFF

%DEFF

Linear (%DEFF)