72
Appendix
Financial Calculation Form
ulas
TVM solver
PMT
, PV
, FV
, N
Err
or
I/Y
If PMT
= 0 then
If N = 1 then
If PMT
0 or N 1 then
nd i using the fol-
lowing equations:
+
Err
or
i –1
Amor
tization calculations
Calculations
(for PV
, PMT
, and i, see the TVM solver)
END
INT(1) = ROUND(–PV
×
i)
BGN
INT(1) = 0
PRN(1) = –INT(1) + ROUND(PMT)
BAL(1) = PRN(1) + PV
INT(m) = ROUND(–BAL(m – 1)
×
i)
PRN(m) = –INT(m) + ROUND(PMT)
BAL(m) = PRN(m) + BAL(m – 1)
ROUND(NUM): If a display notation tab
setting has been chosen, NUM is r
ounded and
truncated to the speci
ed number of places
after the decimal point.
Results
Err
or
AMRT
P1 >
AMRT
P2
Discounted cash fl
ow
anal
ysis
m
m
CF
wher
e i =
RA
TE(I/Y)
100
, CFimax = the maxi-
mum data set number
IRR is obtained as i, which satis
es NPV
= 0
in the above equations.
Appendix.indd 72
06.7.10 8:41:48 PM