Oakland CPM Archive/oakcpm.iso/sigm/vol193/paf-tab.cal

SuperCalc Worksheet | 1985-02-10 | 11.0 KB | 321 lines

SuperCalc Ver.  1.05
    INTEREST TABLES by W.D. Stainton [phone]
"    INTEREST TABLES by W.D. Stainton [phone]
"INTEREST TABLES by W.D. Stainton [phone]
"DISCRETE COMPOUNDING
nterest
"CONTINUOUS (EXPONENTIAL) COMPOUNDING
"Interest Rate (%)=
"(1+i)=
1+D3/100
"e^i=
'IhQW
EXP(D3/100)
"PAF.TAB
"[F/P]
"[P/F]
"[F/A]
"[A/F]
"[P/A]
"[A/P]
"[F/P]
"[P/F]
"[F/A]
"[A/F]
"[P/A]
"[A/P]
"--------
F3^A6
(B6-1)/(D3/100)
D6/B6
/(B3*D1/100)
'IhQW
EXP(A6*D3/100)
(I6-1)/(D3/100)
#)i@#h
K6/I6
/(B3*D1/100)
F3^A7
(B7-1)/(D3/100)
D7/B7
EXP(A7*D3/100)
(I7-1)/(D3/100)
K7/I7
F3^A8
(B8-1)/(D3/100)
D8/B8
EXP(A8*D3/100)
@ivv2`q
(I8-1)/(D3/100)
@'i%X
K8/I8
@9i%X
F3^A9
(B9-1)/(D3/100)
D9/B9
EXP(A9*D3/100)
3Q`tB
(I9-1)/(D3/100)
Ph(!Y
K9/I9
F3^A10
1/B10
(B10-1)/(D3/100)
1/D10
D10/B10
@'t    s
1/F10
EXP(A10*D3/100)
1/I10
(I10-1)/(D3/100)
1/K10
K10/I10
@&Yd0X
1/M10
F3^A11
1/B11
(B11-1)/(D3/100)
1/D11
@s#tY
D11/B11
@$2%q
1/F11
A TC2
EXP(A11*D3/100)
@HgR%YY
1/I11
(I11-1)/(D3/100)
1/K11
K11/I11
1/M11
F3^A12
@E#I!S
1/B12
(B12-1)/(D3/100)
1/D12
AEcue9    !
D12/B12
1/F12
EXP(A12*D3/100)
1/I12
(I12-1)/(D3/100)
1/K12
AG5tV8
K12/I12
1/M12
F3^A13
1/B13
(B13-1)/(D3/100)
0(A6ii
1/D13
D13/B13
1/F13
idsB1
EXP(A13*D3/100)
1/I13
(I13-1)/(D3/100)
1/K13
K13/I13
DUpgR
1/M13
24-1)/(D1/100)
F3^A14
1/B14
wVV19 e
(B14-1)/(D3/100)
1/D14
D14/B14
1/F14
EXP(A14*D3/100)
1/I14
(I14-1)/(D3/100)
?aph$b
1/K14
K14/I14
1/M14
F3^A15
s#eb'p
1/B15
(B15-1)/(D3/100)
1/D15
AVP"0(dv
D15/B15
1/F15
i"seH
EXP(A15*D3/100)
1/I15
(I15-1)/(D3/100)
1/K15
K15/I15
1/M15
"--------
F3^A17
@%fu    )
1/B17
13'FcY
(B17-1)/(D3/100)
1/D17
D17/B17
1/F17
AB iX
EXP(A17*D3/100)
@#i'u
1/I17
(I17-1)/(D3/100)
1/K17
SD1VG
K17/I17
1/M17
F3^A18
1/B18
(B18-1)/(D3/100)
1/D18
D18/B18
1/F18
EXP(A18*D3/100)
1/I18
(I18-1)/(D3/100)
>q6y7eQ
1/K18
AxeT6C
K18/I18
q6y7eQ
1/M18
F3^A19
1/B19
(B19-1)/(D3/100)
1/D19
D19/B19
1/F19
EXP(A19*D3/100)
1/I19
(I19-1)/(D3/100)
1/K19
"P    pG
K19/I19
1/M19
F3^A20
1/B20
(B20-1)/(D3/100)
=R1$x#
1/D20
D20/B20
1/F20
C1sH2
EXP(A20*D3/100)
1/I20
D&6#`t1T
(I20-1)/(D3/100)
1/K20
K20/I20
1/M20
F3^A21
1/B21
ERROR
(B21-1)/(D3/100)
1/D21
ERROR
D21/B21
1/F21
EXP(A21*D3/100)
1/I21
ERROR
(I21-1)/(D3/100)
1/K21
ERROR
K21/I21
1/M21
"--------
F3^A23
qt     u
1/B23
(B23-1)/(D3/100)
BdWVu
1/D23
D23/B23
1/F23
EXP(A23*D3/100)
1/I23
(I23-1)/(D3/100)
1/K23
K23/I23
1/M23
F3^A24
1/B24
J`&Fw
(B24-1)/(D3/100)
1/D24
D24/B24
1/F24
EXP(A24*D3/100)
7Aa9s
1/I24
S$RT8
(I24-1)/(D3/100)
1/K24
K24/I24
1/M24
F3^A25
1/B25
(B25-1)/(D3/100)
HeG!5
1/D25
33332
D25/B25
1/F25
EXP(A25*D3/100)
1/I25
(I25-1)/(D3/100)
1/K25
33333
K25/I25
1/M25
OX&Hrsw
F3^A26
1/B26
PHU@`aH%
(B26-1)/(D3/100)
1/D26
333333
D26/B26
1/F26
EXP(A26*D3/100)
R(0$6
1/I26
(I26-1)/(D3/100)
1/K26
3333332
K26/I26
1/M26
F3^A27
TA"su
1/B27
(B27-1)/(D3/100)
Re)G(P
1/D27
3333333
D27/B27
1/F27
SWtYafc7%
EXP(A27*D3/100)
1r('&U
1/I27
(I27-1)/(D3/100)
1/K27
3333334
K27/I27
1/M27
"--------
"[F/P]
"[P/F]
"[F/A]
"[A/F]
"[P/A]
"[A/P]
"[F/P]
"[P/F]
"[F/A]
"[A/F]
"[P/A]
"[A/P]