Financial analysis of the project
FINANCIAL ANALYSIS OF THE PROJECT
|
Particulars
|
I year
|
II year
|
III year
|
IV year
|
V year
|
VI year
|
VII year
|
VIII year
|
Capital Investment
|
13938000
|
|
|
|
|
|
|
|
Working Capital
|
7730930
|
27400772
|
28088531
|
28291049
|
28793589
|
27659817
|
29494600
|
28175978
|
Total Cost
|
21668930
|
27400772
|
28088531
|
28291049
|
28793589
|
27659817
|
29494600
|
28175978
|
Total Benefit
|
4772462
|
32325692
|
33258005
|
35364077
|
34190318
|
34431764
|
36296389
|
38632048
|
Net Cash Flow
|
-16896467
|
4924921
|
5169474
|
7073028
|
5396728
|
6771948
|
6801789
|
10456070
|
DCF at 20%
|
0.833
|
0.694
|
0.579
|
0.482
|
0.402
|
0.335
|
0.279
|
0.233
|
Disc. Benefit
|
3977052
|
22448397
|
19246531
|
17054435
|
13740322
|
11531128
|
10129656
|
8984580
|
Disc.cost
|
18057441
|
19028314
|
16254937
|
13643446
|
11571498
|
9263217
|
8231402
|
6552832
|
NPV at 20% DCF
|
-14080389
|
3420084
|
2991594
|
3410990
|
2168824
|
2267912
|
1898255
|
2431748
|
DCF at 25%
|
0.800
|
0.640
|
0.512
|
0.410
|
0.328
|
0.262
|
0.210
|
0.168
|
Disc. Benefit
|
3817970
|
20688443
|
17028099
|
14485126
|
11203483
|
9026080
|
7611905
|
6481382
|
Disc.cost
|
17335144
|
17536494
|
14381328
|
11588014
|
9435083
|
7250855
|
6185466
|
4727145
|
NVP at 25% DCV
|
-13517174
|
3151949
|
2646771
|
2897112
|
1768400
|
1775225
|
1426439
|
1754238
|
NPV at 20%
|
4509016
|
|
|
B:C ratio at 20%
|
1.044
|
:1
|
|
NPV at 25%
|
1902960
|
|
|
B:C ratio at 25%
|
1.022
|
:1
|
|
|
IRR
|
30%
|
|
|
|
|
|
|
|
Last modified: Thursday, 14 June 2012, 11:06 AM