Appendix A: Tables and Reference Information 161
then:
Balance, principal, and interest are dependent on the values of PMT, PV,
æ, and pmt1 and pmt2.
Cash Flow
where:
Net present value is dependent on the values of the initial cash flow
(CF0), subsequent cash flows (CFj), frequency of each cash flow (nj), and
the specified interest rate (i).
irr() = 100 × i, where i satisfies npv() = 0
Internal rate of return is dependent on the values of the initial cash flow
(CF0) and subsequent cash flows (CFj).
i=I% ÷ 100
Interest Rate Conversions
where: RND = round the display to the number of decimal places
selected
RND12 = round to 12 decimal places
4Eff =
where: x=.01 × Nom ÷ CP
4Nom =
where: x=.01 × Eff
bal( ) bal pmt2()=
Σ
Prn( ) bal pmt2()bal pmt1(
)
–=
ΣInt( ) pmt2pmt1–1+()RND PMT()×ΣPrn( )–=
npv( ) CF0CFj1i+()
-Sj1–11i+()
-nj
–()
i
----------------------------------
j1=
N
∑
+=
Sj
ni
i1=
j
∑j1≥
0j0=
=
100 (eCP x 1+()ln×1)–×
100 CP [×× e1CP÷x1+()ln×1]–