internal rate of return
Comments
Content
Calculation of IRR
Cash Flow Frequency:
#NAME?
0
1
2
3
4
5
6
7
8
9
10
11
12
#NAME?
12
Capital Flow
$0.00
$50,000.00
$50,000.00
$50,000.00
$50,000.00
$50,000.00
$50,000.00
$50,000.00
$50,000.00
$50,000.00
$50,000.00
$50,000.00
$50,000.00
IRR of Net Quarterly Flow
IRR p.a.
Check NPV
###
###
#NAME?
#NAME?
###
$50,000.00
$50,000.00
$50,000.00
$50,000.00
$50,000.00
$50,000.00
$50,000.00
$50,000.00
$50,000.00
$50,000.00
$50,000.00
###
Err:523 #NAME?
Err:523 per annum
Err:523
1 Annual
2 Semi-Annual
4 Quarterly
12 Monthly
13 Four Weekly
26 Bi-Weekly
52 Weekly
365 Daily
366 Leap Daily
IRR to Calculate Geometric Average Growth
Year
2003
2004
2005
2006
2007
Index
Growth P.A.
2003-2004 2004-2005 2005-2006 2006-2007
100.00
-100.00
-100.00
-100.00
-100.00
5.21%
105.21
105.21
0
0
0
4.86%
110.32
110.32
0
0
5.66%
116.56
116.56
0
2.90%
119.94
119.94
Average Growth Since 2007
5.210%
5.033%
5.241%
4.650%
4
Checking IRR & NPV Using Sum of PV Approach
Discount Rate for NPV
Period
0
1
2
3
4
5
6
7
8
NPV
IRR
Flow
###
14,000.00
14,000.00
14,000.00
14,000.00
14,000.00
15,000.00
15,000.00
15,000.00
(23,766.89)
Err:523
10%
PV IRR Check
PV NPV Check
Err:523 (100,000.00)
Err:523
12,727.27
13,153.68
11,570.25
12,749.90
10,518.41
12,358.52
9,562.19
11,979.15
8,692.90
12,440.82
8,467.11
12,058.92
7,697.37
11,688.75
6,997.61
Err:523
(23,766.89)
Sponsor Documents