|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |||
|
|
|
|
|
|
|
|
|
|
|
|
| Compound Interest | |||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Calculation Formulas |
|
|
|
|
|
|
|
| ||||||||||||
u | PV, PMT, FV, n |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| ||
| I% G 0 | – α ⋅ PMT – β ⋅ FV |
|
|
|
| ||||||||||||||
|
| PV = |
|
|
|
|
| γ |
|
|
|
|
|
|
|
| ||||
| PMT = |
|
|
|
|
|
| |||||||||||||
|
|
|
|
|
|
|
|
|
| α |
|
|
|
|
|
|
|
| ||
|
| FV = |
|
|
|
|
|
| ||||||||||||
|
|
|
|
|
|
|
|
| β |
|
|
|
|
|
|
|
| |||
|
|
|
|
| (1+ iS ) ⋅ PMT – FV ⋅ i | |||||||||||||||
|
|
| log { |
|
|
|
|
|
|
|
|
|
| } |
|
| ||||
|
| n = | (1+ iS ) ⋅ PMT + PV ⋅ i |
|
| |||||||||||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| ||||||
|
|
|
|
|
|
|
|
| log (1+ i) |
|
|
|
|
|
| |||||
| I% = 0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| ||
| PV = – (PMT ⋅ n + FV ) |
|
|
|
| |||||||||||||||
| PMT = – | PV + FV |
|
|
|
|
|
|
|
|
| |||||||||
|
|
| n |
|
|
|
|
|
|
|
| |||||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| ||||
| FV = – (PMT ⋅ n + PV ) |
|
|
|
| |||||||||||||||
|
| n = – | PV + FV |
|
|
|
|
|
|
|
|
| ||||||||
|
| PMT |
|
|
|
|
|
|
|
| ||||||||||
|
|
|
|
|
|
|
|
|
|
|
|
| ||||||||
|
| α = (1+ i ⋅ S ) ⋅ |
|
| 1 – β |
|
|
|
|
|
| |||||||||
| i |
|
|
|
|
|
| |||||||||||||
|
|
|
| (1+ i ) −n |
|
| Off (Format tab) | |||||||||||||
|
| ß = {(1+ i) −Intg(n) ............ |
| CI or SI (Format tab) | ||||||||||||||||
|
|
|
| 1 ........................... |
|
|
|
|
|
|
|
|
|
| Off (Format tab) | |||||
|
| γ = | (1+ i ) Frac (n) ........... |
| CI (Format tab) | |||||||||||||||
|
|
|
| {1+ i ⋅ Frac (n) ....... |
| SI (Format tab) | ||||||||||||||
|
| S = | 0 ............................ |
|
|
|
|
|
|
|
|
|
| Payment : End (Format tab) | ||||||
|
|
|
| 1 ............................ |
|
|
|
|
|
|
|
|
|
| Payment : Begin (Format tab) | |||||
|
|
|
|
| I% ............................... |
|
|
|
|
| (P/Y = C/Y = 1) | |||||||||
|
| i = |
| 100 |
|
|
|
|
|
| C/Y |
|
| |||||||
|
|
|
|
|
|
|
|
|
|
|
| |||||||||
|
|
|
| {(1+ |
|
| I% |
|
|
|
|
|
|
| ||||||
|
|
|
|
|
|
| ) | P/Y | ||||||||||||
|
|
|
| 100 ⋅ [C/Y ] |
|
| ||||||||||||||
uI%
i(effective interest rate)
i(effective interest rate) is calculated using Newton’s Method. γ ⋅ PV + α ⋅ PMT + β ⋅ FV = 0
To I% from i (effective interest rate)
i ⋅ 100 ................................. | (P/Y = C/Y = 1) | ||
I% = {{(1+ i ) | P/Y |
| |
|
| ||
C/Y | (Other than those above) | ||
Tip
•Interest (I%) calculations are performed using Newton’s Method, which produces approximate values whose precision can be affected by various calculation conditions. Interest calculation results produced by this application should be used keeping the above in mind, or results should be confirmed separately.
20060301