186 Appendix : Formulas Used
0 =
With compound interest used for an odd period:
0 =
Amortization
ΣINT =
ΣPRN =
PV
n
=
Discounted Cash Flow Analysis
Net Present Value
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
NPV = net present value of a discounted cash flow.
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