Lampiran 16. Proyeksi Arus Kas untuk Analisis Sensitivitas Budidaya Bandeng, Pendapatan Turun 7%
| No |
Uraian |
Tahun 0 |
Tahun 1 |
Tahun 2 |
Tahun 3 |
Tahun 4 |
||||
| smt 1 |
smt 2 |
smt 1 |
smt 2 |
smt 1 |
smt 2 |
smt 1 |
smt 2 |
|||
| 1 |
Inflow |
|||||||||
| a. Pendapatan |
0 |
41.664.000 |
47.523.000 |
52.080.000 |
47.523.000 |
52.080.000 |
47.523.000 |
52.080.000 |
47.523.000 |
|
| b. Dana sendiri |
12.840.988 |
|||||||||
| c. Kredit investasi |
5.825.400 |
|||||||||
| d. Kredit modal kerja |
10.344.388 |
|||||||||
| e. Nilai sisa |
3.072.200 |
|||||||||
| Jumlah |
29.010.776 |
41.664.000 |
47.523.000 |
52.080.000 |
47.523.000 |
52.080.000 |
47.523.000 |
52.080.000 |
50.595.200 |
|
| Inflow untuk IRR |
0 |
41.664.000 |
47.523.000 |
52.080.000 |
47.523.000 |
52.080.000 |
47.523.000 |
52.080.000 |
50.595.200 |
|
| 2 |
Outflow |
|||||||||
| a. Biaya investasi |
5.322.000 |
0 |
0 |
2.537.000 |
0 |
2.752.000 |
0 |
2.537.000 |
0 |
|
| b. Biaya modal kerja |
20.688.776 |
|||||||||
| c. Biaya operasional |
42.962.813 |
41.450.538 |
43.992.530 |
41.450.538 |
43.992.530 |
41.450.538 |
43.992.530 |
41.450.538 |
||
| d. Angsuran pokok |
4.042.447 |
4.042.447 |
4.042.447 |
4.042.447 |
||||||
| e. Biaya bunga bank |
1.515.918 |
1.111.673 |
707.428 |
303.184 |
||||||
| f. Pajak % |
0 |
2.714 |
417.052 |
123.987 |
1.129.533 |
775.832 |
1.129.533 |
775.832 |
||
| Jumlah |
26.010.776 |
48.521.177 |
46.607.371 |
51.696.457 |
45.920.155 |
47.874.063 |
42.226.369 |
47.659.063 |
42.226.369 |
|
| Outflow untuk IRR |
26.010.776 |
42.962.813 |
41.453.251 |
46.946.582 |
41.574.525 |
47.874.063 |
42.226.369 |
47.659.063 |
42.226.369 |
|
| 3 |
Total cashflow |
3.000.000 |
-6.857.177 |
915.629 |
383.543 |
1.602.845 |
4.205.937 |
5.296.631 |
4.420.937 |
8.368.831 |
| 4 |
Kumulatif cashflow |
3.000.000 |
-3.857.177 |
-2.941.548 |
-2.558.005 |
-955.161 |
3.250.776 |
8.547.407 |
12.968.344 |
21.337.175 |
| 5 |
Cashflow untuk IRR |
-26.010.776 |
-1.298.813 |
6.069.749 |
5.133.418 |
5.948.475 |
4.205.937 |
5.296.631 |
4.420.937 |
8.368.831 |
| DF % |
1,0000 |
0,9129 |
0,8333 |
0,7607 |
0,6944 |
0,6339 |
0,5787 |
0,5283 |
0,4823 |
|
| Discounted Cashflow |
-26.010.776 |
-1.185.648 |
5.058.124 |
3.905.124 |
4.130.886 |
2.666.304 |
3.065.180 |
2.335.501 |
4.035.894 |
|
| a. Discounted Cashflow positif |
0 |
0 |
5.058.124 |
3.905.124 |
4.130.886 |
2.666.304 |
3.065.180 |
2.335.501 |
4.035.894 |
|
| b. Discounted Cashflow negatif |
-26.010.776 |
-1.185.648 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
| DF% *) |
1,0000 |
0,9285 |
0,8621 |
0,8004 |
0,7432 |
0,6900 |
0,6407 |
0,5948 |
0,5523 |
|
| Discounted Cashflow *) |
(26.010.776) |
(1.205.917) |
5.232.542 |
4.108.844 |
4.420.686 |
2.902.136 |
3.393.327 |
2.629.731 |
4.622.031 |
|
| DF % **) |
1,0000 |
0,9245 |
0,8547 |
0,7902 |
0,7305 |
0,6754 |
0,6244 |
0,5772 |
0,5337 |
|
| Discounted Cashflow **) |
(26.010.776) |
(1.200.753) |
5.187.819 |
4.056.279 |
4.345.442 |
2.840.522 |
3.307.060 |
2.551.901 |
4.466.027 |
|
| NPV DF % |
-1.999.413 |
|||||||||
| Net B/C ratio DF % |
0,93 |
|||||||||
| IRR |
16,17% |
|||||||||