
Sales, return on, 721
Salvage value.
See also Trade-
in
value
a
nd
capi
ta
l recovery,
221
defined,
10
, 220
and depreciation, 533, 537, 539, 543, 557
a
nd
market va
lu
e, 388, 392, 397
a
nd
public projects, 319
a
nd
PW over LCM, 175
in
replaceme
nt
ana
ly
si
s,
386, 388, 391- 92
updating
fo
r study period, 349
Sampling, 666-71
Monte Carlo, 677- 84, 685
-88
Savings, tax, 576, 595
Scatter charts.
S
ee
xy
Excel® cha
rt
s
Screening project
s,
186, ] 88- 89
Section
179
property, 533- 34
Section
12
31 transaction
s,
583
Securitie
s,
defined, 361
Selection
of
evaluation method, 348-
51
Sens
iti
vity analysis. See also Breakeven analysis;
SOLVER
approach, 7-
8,
623
and Excel® ce
ll
referenc
in
g,
247, 698
-9
9
of
one parameter, 622- 29
with three est
im
ates, 629- 31
tw
o a
lt
ernatives, 626- 29
Service a
lt
e
rn
atives, 172, 279
a
nd
in
cremental rate
of
return, 59 I
Service life, 174- 75. See also Economic
service life
Shifted gradients.
See Gradie
nt
s,
arithmetic
Shifted se
ri
es, 94- 103
Sign changes, number of, 249- 54
Simple cash
fl
ow se
ri
es, 249
Simple inte
re
st, 17- J
8,
36- 37
Simulation, 659, 678- 86
Single-payment compound amount factor,
50
S
in
gle payment factors, 50- 56
Single-payment present worth f
ac
tor,
51
- 52
Sinking fund
(A
/F) factor, 60- 63
SLN function, 535,
711
Social discount rate, 316, 333
Solvency rati.os, 7 19
SOLVER,434-36, 455- 59, 712- 13
Spreadsheet.
See also Excel®
absolute ce
ll
referenc
in
g,
247, 703
annual worth, 225, 227- 28
and
B/C analysi
s,
323, 330- 31
and breakeven analysi
s,
451
- 52
and CFAT w
ith
depreciation, 578- 79
a
nd
EVA
TM, 601- 3
INDEX
and independent projects, 430, 434
-36
and inflation, 480
and present worth, 197- 202
and rate
of
return, 75- 77,
247,252,263,287
, 289,
297- 300
replacement anal
ys
i
s,
395-97, 402- 5
after-tax, 598- 99
a
nd
sensitivity analysis, 625- 26, 628- 29
and shifted uniform series,
11
0-
11
for s
im
ple and compound interest, 36- 39
incremental, after tax, 592
-9
5
Standard deviation
for continuous variable, 676-77
definition, 673- 74
for discrete variable, 673- 76
Standard normal distribution, 688- 89
Stocks
CAPM model, 360-61
common, 352, 359
in
equi
ty
financing, 352, 359
preferred, 352, 359
Straight line alternative,
in
MACRS,
541-42, 549
Straight line depreciation, 535- 36, 580-
86.
See also Alternatives
Straight line rate, 533, 535
Study period
and annual worth, 218, 226-28
and capital budgeting, 425
equal service, 173, 427
and
FW
ana
ly
si
s,
177
a
nd
PW
evaluation, 174- 77
a
nd
replacement analysis, 390, 400, 404-
10
and salvage value, 220
spreadsheet example, 197-200
SUM function,
703
Sum-
of
-year
di
gits depreciation, 533,
535- 57
,711
Sunk costs, 389
SYD function, 556,
711
Symbol
s,
23
System, phases of, 190-91
T
Tables
compound interest factor
s,
727- 55
effective
in
terest rates, 133
interpolation, 63-65
Tax
depreciation, 532
769