Lampiran 20. Proyeksi Arus Kas untuk Analisis Sensitivitas Budidaya Bandeng Pendapatan Turun dan Biaya Naik masing-masing 4%
|
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 |
43.008.000 |
49.056.000 |
53.760.000 |
49.056.000 |
53.760.000 |
49.056.000 |
53.760.000 |
49.056.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 |
43.008.000 |
49.056.000 |
53.760.000 |
49.056.000 |
53.760.000 |
49.056.000 |
53.760.000 |
52.128.200 |
|
| Inflow untuk IRR |
0 |
43.008.000 |
49.056.000 |
53.760.000 |
49.056.000 |
53.760.000 |
49.056.000 |
53.760.000 |
52.128.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 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
| c. Biaya operasional |
0 |
44.681.325 |
43.108.559 |
45.752.231 |
43.108.559 |
45.752.231 |
43.108.559 |
45.752.231 |
43.108.559 |
|
| d. Angsuran pokok |
0 |
4.042.447 |
4.042.447 |
4.042.447 |
4.042.447 |
0 |
0 |
0 |
0 |
|
| e. Biaya bunga bank |
0 |
1.515.918 |
1.111.673 |
707.428 |
303.184 |
0 |
0 |
0 |
0 |
|
| f. Pajak % |
0 |
0 |
2.714 |
417.052 |
123.987 |
1.129.533 |
775.832 |
1.129.533 |
775.832 |
|
| Jumlah |
26.010.776 |
50.239.690 |
48.265.393 |
53.456.158 |
47.578.177 |
49.633.764 |
43.884.391 |
49.418.764 |
43.884.391 |
|
| Outflow untuk IRR |
26.010.776 |
44.681.325 |
43.111.273 |
48.706.283 |
43.232.546 |
49.633.764 |
43.884.391 |
49.418.764 |
43.884.391 |
|
| 3 |
Total cashflow |
3.000.000 |
-7.231.690 |
790.607 |
303.842 |
1.477.823 |
4.126.236 |
5.171.609 |
4.341.236 |
8.243.809 |
| 4 |
Kumulatif cashflow |
3.000.000 |
-4.231.690 |
-3.441.083 |
-3.137.241 |
-1.659.418 |
2.466.818 |
7.638.427 |
11.979.663 |
20.223.472 |
| 5 |
Cashflow untuk IRR |
-26.010.776 |
-1.673.325 |
5.944.727 |
5.053.717 |
5.823.454 |
4.126.236 |
5.171.609 |
4.341.236 |
8.243.809 |
| 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.527.530 |
4.953.939 |
3.844.493 |
4.044.065 |
2.615.778 |
2.992.829 |
2.293.396 |
3.975.602 |
|
| a. Discounted Cashflow positif |
0 |
0 |
4.953.939 |
3.844.493 |
4.044.065 |
2.615.778 |
2.992.829 |
2.293.396 |
3.975.602 |
|
| b. Discounted Cashflow negatif |
-26.010.776 |
-1.527.530 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
| DF % *) |
1,0000 |
0,9366 |
0,8772 |
0,8216 |
0,7695 |
0,7207 |
0,6750 |
0,6322 |
0,5921 |
|
| Discounted Cashflow *) |
(26.010.776) |
(1.567.212) |
5.214.673 |
4.151.965 |
4.480.959 |
2.973.664 |
3.490.689 |
2.744.394 |
4.880.997 |
|
| DF % **) |
1,0000 |
0,9325 |
0,8696 |
0,8109 |
0,7561 |
0,7051 |
0,6575 |
0,6131 |
0,5718 |
|
| Discounted Cashflow **) |
(26.010.776) |
(1.560.384) |
5.169.328 |
4.097.927 |
4.403.368 |
2.909.440 |
3.400.417 |
2.661.773 |
4.713.425 |
|
| NPV DF % |
-2.818.203 |
|||||||||
| Net B/C ratio DF % |
0,90 |
|||||||||
| IRR |
14,63% |
|||||||||
| PBP (tahun) ***) |
2,26 |
|||||||||
|
|
||||||||||