Intro Project Values

crown

This intro problem practices NPV. NPV calculates the present value of equally spaced future cash flows, using a constant discount rate. Update the output cells to calculate each project's net present value. Rate is the annual discount rate. Today is the initial cost paid now, shown as a negative amount. Year 1 through Year 3 are the amounts paid or received at the end of each year. Costs are negative and receipts are positive; zero means no cash flow that year. Use NPV to discount Year 1 through Year 3, then add Today separately because it occurs now and should not be discounted. See Examples

Your solution should use cell references so it updates automatically if the input cells change values.

Need help with NPV details and syntax? Review the NPV function guide first.

NPV
A1
fx

This cell cannot be edited

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50