Appendix — Reference Information 85
where: i ƒ0
FV = L(PV + PMT Q N)
where: i =0
Amortization
If computing bal(), pmt2 = npmt
Let bal(0) = RND(PV)
Iterate from m = 1 to pmt2
then: bal( ) =bal(pmt2)
GPrn( ) =bal(pmt2) N bal(pmt1)
GInt( ) =(pmt2 N pmt1 +1) Q RND(PMT) N GPrn( )
where: RND =round the display to the number of decimal
places selected
RND12 =round to 12 decimal places
Balance, principal, and interest are dependent on the values of PMT, PV,
I/Y, and pmt1 and pmt2.
Cash Flow
where:
FV PMT Gi
×
i
------------------------ 1i+()
N
PV PMT Gi
×
i
------------------------
+
⎝⎠
⎛⎞
×=
ImRND RND12 i bal m 1()×()[]=
bal m() bal m 1()Im
RND PMT() +=
NPV CF0CFj1i+()
-Sj111i+()
-nj
()
i
----------------------------------
j1=
N
+=
S
jni
i1=
j
j1
0j0=
=