Cost-Benefit Analysis Template Page 3
ADVERTISEMENT
1
2
3For this exercise enter the following formula.
B22:
=irr(d4:d14)
Your completed spreadsheet should look like the one below.
A
B
C
D
E
F
1
Cost-Benefit Analysis: City Stadium
2
Total
Discount Present
3
Year
Costs
Benefits
Benefits
Factor
Value
4
0
$60.00
$0.00
($60.00)
1.00
($60.00)
5
1
$1.00
$3.00
$2.00
0.91
$1.82
6
2
$1.00
$3.00
$2.00
0.83
$1.65
7
3
$1.00
$10.00
$9.00
0.75
$6.76
8
4
$1.00
$10.00
$9.00
0.68
$6.15
9
5
$1.50
$12.50
$11.00
0.62
$6.83
10
6
$1.50
$12.50
$11.00
0.56
$6.21
11
7
$1.50
$12.50
$11.00
0.51
$5.64
12
8
$1.50
$15.00
$13.50
0.47
$6.30
13
9
$2.00
$15.00
$13.00
0.42
$5.51
14
10
$2.00
$15.00
$13.00
0.39
$5.01
15
16
NPV =
($8.11)
17
Discount
18
Rate =
10.00%
19
20
Shortcut:
21
NPV =
($8.11)
22
IRR =
7.398%
16. Save the spreadsheet:
A:CBASTAD.XLS
3
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Business