Intro Dated Project Values

crown

This intro problem practices XNPV. XNPV discounts cash flows on specific dates and adds their present values as of the first date. Update the output cells to calculate each project's net present value. Rate is the effective annual discount rate. Cash 1 through Cash 3 are dollar amounts paid or received on the corresponding Date 1 through Date 3. Costs are negative and receipts are positive. Include all three cash flows, including the initial investment, which occurs on the first date and is not discounted. Return the result directly using the supplied signs. See Examples

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

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

XNPV
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