Intro Dated Project Returns

crown

This intro problem practices XIRR. XIRR finds the annualized rate that makes the net present value of dated cash flows equal to zero. Update the output cells to calculate each project's annualized internal rate of return. Cash 1 through Cash 3 are amounts paid or received on the corresponding Date 1 through Date 3. The initial investment is negative and later receipts are positive. Include all three cash flows and their matching dates. Keep negative results for projects that lose money. See Examples

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

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

XIRR
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