HP 12c Platinum - Modified Internal Rate of Return; Advance Payments; Interest Rate Conversions; Finite Compounding

Appendix E: Formulas Used 261
File name: HP 12c Pt Converted_user's guide_English_HDP0F123E02_080207 Page: 257 of 281
Printed Date: { 2007/8/2Dimension: 14.8 cm x 21 cm
L
FACT
RBVDPN
j
j
100
1
⋅=
−
for j ≠ 1
Modified Internal Rate of Return
n = number of compounding periods.
NFV
P
= Net future value of the positive cash flows.
NPV
N
= Net present value of the negative cash flows.
⎥
⎥
⎥
⎦
⎤
⎢
⎢
⎢
⎣
⎡
−
⎟
⎟
⎠
⎞
⎜
⎜
⎝
⎛
−
= 1100
1
n
N
P
NPV
NFV
MIRR
Advance Payments
A = number of payments made in advance.
⎥
⎥
⎦
⎤
⎢
⎢
⎣
⎡
+
+−
+−
=
−−
−
A
i
i
iFVPV
PMT
An
n
)(
)1(1
)1(
Interest Rate Conversions
C = number of compounding periods per year.
EFF
= the effective annual interest rate as a decimal.
NOM
= the nominal annual interest rate as a decimal.
Finite Compounding
11 −
⎟
⎠
⎞
⎜
⎝
⎛
+=
C
C
NOM
EFF
Continuous Compounding
)1( −=
NOM
eEFF