Intro Project Returns

crown

This intro problem practices IRR. IRR finds the rate per period that makes a cash-flow series have a net present value of zero. Update the output cells to calculate each project's annual internal rate of return. Today is the initial investment paid now, shown as a negative amount. Year 1 through Year 3 are receipts at the end of each year; zero means no receipt that year. 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 IRR details and syntax? Review the IRR function guide first.

IRR
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