internal rate of return

Published on November 2016 | Categories: Documents | Downloads: 54 | Comments: 0 | Views: 444
of 5
Download PDF   Embed   Report

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

Or use your account on DocShare.tips

Hide

Forgot your password?

Or register your new account on DocShare.tips

Hide

Lost your password? Please enter your email address. You will receive a link to create a new password.

Back to log-in

Close