WEBVTT
1
00:00:00.250 --> 00:00:00.500
An Excel spreadsheet is shown. The presenter narrates
as she works with the program. Information is listed in
cells B 2 and B 3 as follows. B 2, $25,000 first cost.
B 3, 8 percent interest. Below is a table starting in
cell C 5 with two columns labeled life uniform distribution
and annual benefit normal distribution, and two rows labeled
min and max. The values are as follows. Min. Life, 8.
Annual benefit, $5,300 mean. Max. Life, 15. Annual benefit,
$1,200 standard deviation.
2
00:00:48.750 --> 00:00:49.000
Below the information is another
table starting in cell A 9. It has four columns labeled
iteration, life, A, and P W. Iterations 1 through 6 are
entered, with life values 1 through 20. The first row
of values are entered as follows. Iteration, 1. Life,
13. A, $5,328.80. P W, negative 66,931.89.
3
00:00:48.750 --> 00:00:49.000
The formula in cell B 10, Life 14, reads = dollar sign
C dollar sign 6 + I N T left parenthesis 7 asterisk
R A N D left parenthesis right parenthesis right
parenthesis.
4
00:01:46.500 --> 00:01:46.750
The values for Life, A, and P W in iteration 1 change to
14, $5,071.55, and negative 66,811.04, respectively.
5
00:02:32.750 --> 00:02:33.000
The formula reads equals NORM I N V left parenthesis
R A N D left parenthesis right parenthesis comma
dollar sign E dollar sign 6 comma dollar sign E dollar
sign 7 right parenthesis.
6
00:03:26.750 --> 00:03:27.000
The formula reads equals P V left parenthesis dollar
sign B dollar sign 3 comma B 10 comma C 10 right
parenthesis minus B 2.