User Manual

Appendix: Reference Information 117
PMT
i
G
PV
PV FV
i
i
N
=× +
+
+−






−
()11
where:
i
ƒ
0
PMT
=
L
(
PV
+
FV
)
P
N
where:
i
=0
PV
PMT G
i
FV
i
PMT G
i
i
N
i
=
×
−






×
+
−
×
1
1()
where:
i
ƒ
0
PV
=
L
(
FV
+
PMT
Q
N
)
where:
i
=0
FV
PMT G
i
iPV
PMT G
i
i
N
i
=
×
−+ × +
×






()
1
where:
i
ƒ
0
FV
=
L
(
PV
+
PMT
Q
N
)
where:
i
=0
Amortization
If computing
bal
(),
pmt
2 =
npmt
Let
bal
(0) =
RND
(
PV
)
Iterate from
m
= 1 to
pmt
2
( )
[]
I
I
m
m
=×−
=−−+





−
RND RND i bal m
bal m bal m RND PMT
12 1
1
()
() () ()
then:
bal
( ) =
bal
(
pmt
2)
G
Prn
( ) =
bal
(
pmt
2)
N
bal
(
pmt
1)
G
Int
( ) = (
pmt
2
N
pmt
1 +1)
Q
RND
(
PMT
)
N G
Prn
( )
where:
RND
= round the display to the number of decimal
places selected
RND
12 = round to 12 decimal places
Balance, principal, and interest are dependent on the values of
PMT
,
PV
,
I/Y
, and
pmt
1 and
pmt
2.