|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Year |
Production |
selling price |
Incomes |
Total oper. |
Annual cash |
|
Net annual |
total |
Annual net cash |
fd |
Net annual |
Net Present |
IRR |
|
|
H2 lt/year |
H2 £/lt |
from H2 £ |
cost £ |
income £ |
tax 40% |
cash income |
capital cost £ |
flow after tax |
1/(1+I)^n |
discounted cash flow |
Value (NPV) |
|
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1,246,500 |
-1,246,500 |
1 |
-1,246,500 |
-1,246,500 |
15% |
|
1 |
40,332,500 |
0.03000 |
1,209,975 |
709,755 |
500,220 |
200,088 |
300,132 |
0 |
300,132 |
0.9090909 |
272,847 |
-973,653 |
|
|
2 |
40,332,500 |
0.03000 |
1,209,975 |
709,755 |
500,220 |
200,088 |
300,132 |
0 |
300,132 |
0.8264463 |
248,043 |
-725,610 |
|
|
3 |
40,332,500 |
0.03000 |
1,209,975 |
709,755 |
500,220 |
200,088 |
300,132 |
0 |
300,132 |
0.7513148 |
225,494 |
-500,116 |
|
|
4 |
40,332,500 |
0.03000 |
1,209,975 |
709,755 |
500,220 |
200,088 |
300,132 |
0 |
300,132 |
0.6830135 |
204,994 |
-295,122 |
|
|
5 |
40,332,500 |
0.03200 |
1,290,640 |
709,755 |
580,885 |
232,354 |
348,531 |
0 |
348,531 |
0.6209213 |
216,410 |
-78,712 |
|
|
6 |
40,332,500 |
0.03400 |
1,371,305 |
709,755 |
661,550 |
264,620 |
396,930 |
0 |
396,930 |
0.5644739 |
224,057 |
145,345 |
|
|
7 |
40,332,500 |
0.03600 |
1,451,970 |
709,755 |
742,215 |
296,886 |
445,329 |
0 |
445,329 |
0.5131581 |
228,524 |
373,869 |
|
|
8 |
40,332,500 |
0.03800 |
1,532,635 |
709,755 |
822,880 |
329,152 |
493,728 |
0 |
493,728 |
0.4665074 |
230,328 |
604,197 |
|
|
9 |
40,332,500 |
0.04000 |
1,613,300 |
709,755 |
903,545 |
361,418 |
542,127 |
0 |
542,127 |
0.4240976 |
229,915 |
834,112 |
|
|
10 |
40,332,500 |
0.04080 |
1,645,566 |
709,755 |
935,811 |
374,324 |
561,487 |
0 |
561,487 |
0.3855433 |
216,477 |
1,050,589 |
|
|
11 |
40,332,500 |
0.04080 |
1,645,566 |
709,755 |
935,811 |
374,324 |
561,487 |
0 |
561,487 |
0.3504939 |
196,798 |
1,247,387 |
|
|
12 |
40,332,500 |
0.04080 |
1,645,566 |
709,755 |
935,811 |
374,324 |
561,487 |
0 |
561,487 |
0.3186308 |
178,907 |
1,426,294 |
|
|
13 |
40,332,500 |
0.04080 |
1,645,566 |
709,755 |
935,811 |
374,324 |
561,487 |
0 |
561,487 |
0.2896644 |
162,643 |
1,588,936 |
|
|
14 |
40,332,500 |
0.04080 |
1,645,566 |
709,755 |
935,811 |
374,324 |
561,487 |
0 |
561,487 |
0.2633313 |
147,857 |
1,736,793 |
|
|
15 |
40,332,500 |
0.04162 |
1,678,477 |
709,755 |
968,722 |
387,489 |
581,233 |
0 |
581,233 |
0.239392 |
139,143 |
1,875,936 |
|
|
16 |
40,332,500 |
0.04162 |
1,678,477 |
709,755 |
968,722 |
387,489 |
581,233 |
0 |
581,233 |
0.2176291 |
126,493 |
2,002,429 |
|
|
17 |
40,332,500 |
0.04162 |
1,678,477 |
709,755 |
968,722 |
387,489 |
581,233 |
0 |
581,233 |
0.1978447 |
114,994 |
2,117,423 |
|
|
18 |
40,332,500 |
0.04162 |
1,678,477 |
709,755 |
968,722 |
387,489 |
581,233 |
0 |
581,233 |
0.1798588 |
104,540 |
2,221,963 |
|
|
19 |
40,332,500 |
0.04162 |
1,678,477 |
709,755 |
968,722 |
387,489 |
581,233 |
0 |
581,233 |
0.163508 |
95,036 |
2,316,999 |
|
|
20 |
40,332,500 |
0.04245 |
1,712,047 |
709,755 |
1,002,292 |
400,917 |
601,375 |
0 |
601,375 |
0.1486436 |
89,391 |
2,406,390 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|