SAPOTA: annexure-IX
DISCOUNTED CASHFLOW STATEMENT
(Rs. in thousand)
Particulars |
Year I |
Year II |
Year III |
Year IV |
Year V |
Year VI |
Year VII |
Year VIII |
Year IX |
Year X |
Year XI |
Year XII |
Year XIII |
Year XIV |
Year XV |
Total |
Capital
Cost |
175.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Gross
Revenue |
40.00 |
50.00 |
60.00 |
80.00 |
80.00 |
80.00 |
80.00 |
80.00 |
80.00 |
80.00 |
80.00 |
80.00 |
80.00 |
80.00 |
80.00 |
|
Prod &
Other Costs |
31.60 |
34.70 |
37.70 |
40.50 |
40.50 |
40.50 |
40.50 |
40.50 |
40.50 |
40.50 |
40.50 |
40.50 |
40.50 |
40.50 |
40.50 |
|
Salvage
Value |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
57.49 |
|
Gross
Surplus |
-166.60 |
15.40 |
22.30 |
39.50 |
22.30 |
22.27 |
39.50 |
39.51 |
39.51 |
39.50 |
39.50 |
39.50 |
39.50 |
39.50 |
97.00 |
|
DF @ 15% |
0.870 |
0.756 |
0.658 |
0.572 |
0.497 |
0.432 |
0.376 |
0.327 |
0.284 |
0.247 |
0.215 |
0.187 |
0.163 |
0.141 |
0.123 |
|
PW @ 15% |
-144.80 |
11.60 |
14.60 |
22.60 |
11.10 |
9.60 |
14.90 |
12.90 |
11.20 |
9.80 |
8.50 |
7.40 |
6.40 |
5.60 |
11.90 |
-26.54 |
DF @ 30% |
0.769 |
0.592 |
0.455 |
0.350 |
0.269 |
0.234 |
0.204 |
0.177 |
0.154 |
0.134 |
0.116 |
0.101 |
0.088 |
0.077 |
0.067 |
|
PW @ 30% |
-128.10 |
9.10 |
10.10 |
13.80 |
6.00 |
5.20 |
8.00 |
7.00 |
6.10 |
5.30 |
4.60 |
4.00 |
3.50 |
3.00 |
6.50 |
-57.45 |
IRR |
|
16.57 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DF @ 11% |
0.901 |
0.812 |
0.731 |
0.659 |
0.593 |
0.535 |
0.482 |
0.434 |
0.391 |
0.352 |
0.317 |
0.286 |
0.258 |
0.232 |
0.209 |
|
PW of Operational Cash flow |
7.60 |
12.50 |
16.30 |
26.00 |
23.40 |
21.10 |
19.00 |
17.10 |
15.40 |
13.90 |
12.50 |
11.30 |
10.20 |
9.20 |
8.30 |
223.90 |
NPV of
Operational Cash flow |
223.90 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Initial
Investment |
175.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Benefit
Cost Ratio |
1.30 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|