Appendix B: Reference Information
390
Internal rate of return is dependent on the values of the initial cash flow (
CF
0) and subsequent
cash flows (
CFj
).
i
=
I
%
÷
100
Interest Rate Conversions
100 (
e
CP
x
1
+
(
)
ln
×
1)
–
×
.
01
×
Nom
÷
CP
100
CP
[
×
×
e
1
CP
÷
x
1
+
(
)
ln
×
1
]
–
Days between Dates
With the
dbd(
function, you can enter or compute a date within the range Jan. 1, 1950, through
Dec. 31, 2049.
Actual/actual day-count method
(assumes actual number of days per month and actual number
of days per year):
dbd
( (days between dates) = Number of Days II
-
Number of Days I
4
Eff
=
where:
x
=
4
Nom
=
where:
x
= .
01
×
Eff
Eff
=
effective rate
CP
=
compounding periods
Nom
=
nominal rate
Number of Days I
= (
Y1
-
YB
)
×
365
+ (number of days
MB
to
M
1
)
+
DT1
+
Number of Days II = (
Y
2
-
YB
)
×
365
+ (number of days
MB
to
M
2
)
+
DT
2
+
Y
1
YB
–
(
)
4
------------------------
Y
2
YB
–
(
)
4
------------------------
