Exhibit 1
The Investment Detective
Project Free Cash Flows (in $ Thousands)
1
Project Number
Discount Rate
Initial Investment
Year 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Sum of Cash Flow Benefits
10%
($2,000)
$330
330
330
330
330
330
330
1,000
10%
($2,000)
$1,666
334
165
10%
($2,000)
10,000
$3,310
$2,165
$10,000
$1,310
$165
$8,000
Excess of Cash Flow
Over Initial Investment
10%
($2,000)
$160
200
350
395
432
440
442
444
446
448
450
451
451
452
(2,000)
10%
($2,000)
280
280
280
280
280
280
280
280
280
280
280
280
280
280
280
10%
($2,000)
$2,200
10%
($2,000)
$1,200
900
300
90
70
10%
($2,000)
($350)
(60)
60
350
700
1,200
2,250
$3,561
$4,200
$2,200
$2,560
$4,150
$1,561
$2,200
$200
$560
$2,150
NPV Calculation
Project Number
Initial Investment
Year
SIGMA PV
NPV
Explaination
The result of NPV :
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
($2,000)
($2,000)
($2,000)
($2,000)
($2,000)
($2,000)
$300
$273
$248
$225
$205
$186
$169
$467
$0
$0
$0
$0
$0
$0
$0
$2,073
$73
$1,515
$276
$124
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$1,915
($85)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$2,394
$2,394
$394
$145
$165
$263
$270
$268
$248
$227
$207
$189
$173
$158
$144
$131
$119
-$479
$2,228
$228
$255
$231
$210
$191
$174
$158
$144
$131
$119
$108
$98
$89
$81
$74
$67
$2,130
$130
$2,000
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$2,000
$0
above 0 (not recommended to execute or invested)
upper 0 (recommended to execute or invested)
The result of NPV : above 0 (not recommended to execute or invested), upper 0 (recommended to execute or invested)
IRR CALCULATION
($2,000)
($2,000)
$1,091
$744
$225
$61
$43
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$2,165
$165
-$318
-$50
$45
$239
$435
$677
$1,155
$0
$0
$0
$0
$0
$0
$0
$0
$2,183
$183
Project Number
Discount Rate
Initial Investment
Year
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
SIGMA PV
NPV
10.87%
($2,000)
6.31%
($2,000)
11.33%
($2,000)
$298
$268
$242
$218
$197
$178
$160
$438
$0
$0
$0
$0
$0
$0
$0
$2,000
$0
$1,567
$296
$137
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$2,000
($0)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$2,000
$2,000
$0
Explaination
Project 1 - 8 has discount rate upper 10 % suitable to invested
The higher IRR will same as the amount of return that gain from the project
mended to execute or invested)
12.33%
($2,000)
11.12%
($2,000)
10.00%
($2,000)
15.26%
($2,000)
11.41%
($2,000)
$142
$159
$247
$248
$242
$219
$196
$175
$157
$140
$125
$112
$99
$89
-$350
$2,000
$0
$252
$227
$204
$184
$165
$149
$134
$120
$108
$98
$88
$79
$71
$64
$58
$2,000
$0
$2,000
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$2,000
$0
$1,041
$677
$196
$51
$34
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$2,000
$0
-$314
-$48
$43
$227
$408
$628
$1,056
$0
$0
$0
$0
$0
$0
$0
$0
$2,000
$0
table to invested
urn that gain from the project
PAYBACK PERIOD CALCULATION
Project Number
Discount Rate
Initial Investment
Year 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
10%
$2,000
$330
330
330
330
330
330
330
1,000
2
10%
$2,000
$1,666
334
165
3
10%
$2,000
10%
$2,000
280
280
280
280
280
280
280
280
280
280
280
280
280
280
280
10%
$2,000
$2,200
10,000
10%
$2,000
$160
200
350
395
432
440
442
444
446
448
450
451
451
452
(2,000)
Sum of Cash Flow Benefits
$3,310
$2,165
$10,000
$3,561
$4,200
$2,200
Excess of Cash Flow
Over Initial Investment
$5,310
$4,165
$12,000
$5,561
$6,200
$4,200
7
$2,310
$1,980
6.06
2
$2,000
$1,666
2.00
7
$2,419
$1,977
6.05
8
2,240
1,960
7.14
1
$2,200
0
0.91
BEP ( year )
Return BEP ( $ ) (SUM)
Return BEP-1 year ( SUM )
Payback Period (in year)
15
10000
0
14.20
Explaination
the more fast return time from capital that investate so the project much better and vice versa
PROFITABILITY INDEX CALCULATION
7
10%
$2,000
$1,200
900
300
90
70
8
10%
$2,000
($350)
(60)
60
350
700
1,200
2,250
Project Number
Initial Investment
Year
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
SIGMA PV
PROFITABILITY INDEX
$2,560
$4,150
$4,560
$6,150
($2,000)
($2,000)
($2,000)
$300
$273
$248
$225
$205
$186
$169
$467
$0
$0
$0
$0
$0
$0
$0
$2,073
1.04
$1,515
$276
$124
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$1,915
0.96
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$2,394
$2,394
1.20
Explaination
if the project have the probability index below than 1 so the project is not reco
2
7
$2,100
$4,150
$1,200
$1,900
1.89 6.044444
($2,000)
($2,000)
($2,000)
($2,000)
($2,000)
$145
$165
$263
$270
$268
$248
$227
$207
$189
$173
$158
$144
$131
$119
-$479
$2,228
1.11
$255
$231
$210
$191
$174
$158
$144
$131
$119
$108
$98
$89
$81
$74
$67
$2,130
1.06
$2,000
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$2,000
1.00
$1,091
$744
$225
$61
$43
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$2,165
1.08
-$318
-$50
$45
$239
$435
$677
$1,155
$0
$0
$0
$0
$0
$0
$0
$0
$2,183
1.09
n 1 so the project is not recommend to invistigate and vice versa
