Operation Manual

186 Appendix E: Formulas Used
With simple interest used for an odd period:
0 =
With compound interest used for an odd period:
0 =
Amortization
ΣINT =
ΣPRN =
PV
n
=
n = number of payment periods to be amortized.
INT
j
= amount of PMT applied to interest in period j.
PRN
j
= amount of PMT applied to principal in period j.
PV
j
= present value (balance) of loan after payment in
period j.
j = period number.
INT
1
= {0 if n = 0 and payment mode is set to Begin.
|PV
0
× i|
RND
(sign of PMT)
PRN
1
= PMT – INT
1
PV
1
= PV
0
+ PRN
1
INT
j
=|PV
j –1
× i|
RND
× (sign of PMT) for j > 1.
PRN
j
= PMT – INT
j
PV
j
= PV
j –1
+ PRN
j
PV 1 iFRAC n()+[]1 iS+()PMT
11i+()
INTG n()–
–
i
----------------------------------------------
FV 1 i+()
INTG n()–
++
PV 1 i+()
FRAC n()
1 iS+()PMT
11i+()
INTG n()–
–
i
----------------------------------------------
FV 1 i+()
INTG n()–
++
INT
j
j
1=
n
∑
INT
1
INT
2
… INT
n
+++=
PRN
j
j
1=
n
∑
PRN
1
PRN
2
… PRN
n
+++=
PV
0
PRN
∑
+