Lampiran 18. Proyeksi Arus Kas untuk Analisis Sensitivitas Budiaya Bandeng, Biaya Operasional Naik 8%
| 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 |
||
| Inflow |
|||||||||
| a. Pendapatan |
0 |
44.800.000 |
51.100.000 |
56.000.000 |
51.100.000 |
56.000.000 |
51.100.000 |
56.000.000 |
51.100.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 |
44.800.000 |
51.100.000 |
56.000.000 |
51.100.000 |
56.000.000 |
51.100.000 |
56.000.000 |
54.172.200 |
| Inflow untuk IRR |
0 |
44.800.000 |
51.100.000 |
56.000.000 |
51.100.000 |
56.000.000 |
51.100.000 |
56.000.000 |
54.172.200 |
| 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 |
46.399.838 |
44.766.581 |
47.511.932 |
44.766.581 |
47.511.932 |
44.766.581 |
47.511.932 |
44.766.581 |
|
| 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 |
51.958.202 |
49.923.414 |
55.215.859 |
49.236.198 |
51.393.465 |
45.542.412 |
51.178.465 |
45.542.412 |
| Outflow untuk IRR |
26.010.776 |
46.399.838 |
44.769.294 |
50.465.984 |
44.890.568 |
51.393.465 |
45.542.412 |
51.178.465 |
45.542.412 |
| Total cashflow |
3.000.000 |
-7.158.202 |
1.176.586 |
784.141 |
1.863.802 |
4.606.535 |
5.557.588 |
4.821.535 |
8.629.788 |
| Kumulatif cashflow |
3.000.000 |
-4.158.202 |
-2.981.616 |
-2.197.476 |
-333.674 |
4.272.861 |
9.830.448 |
14.651.983 |
23.281.770 |
| Cashflow untuk IRR |
-26.010.776 |
-1.599.838 |
6.330.706 |
5.534.016 |
6.209.432 |
4.606.535 |
5.557.588 |
4.821.535 |
8.629.788 |
| 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.460.445 |
5.275.588 |
4.209.869 |
4.312.106 |
2.920.258 |
3.216.197 |
2.547.129 |
4.161.742 |
| a. Discounted Cashflow positif |
0 |
0 |
5.275.588 |
4.209.869 |
4.312.106 |
2.920.258 |
3.216.197 |
2.547.129 |
4.161.742 |
| b. Discounted Cashflow negatif |
-26.010.776 |
-1.460.445 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
| DF % *) |
1,0000 |
0,9206 |
0,8475 |
0,7801 |
0,7182 |
0,6611 |
0,6086 |
0,5603 |
0,5158 |
| Discounted Cashflow *) |
(26.010.776) |
(1.472.770) |
5.365.005 |
4.317.351 |
4.459.518 |
3.045.575 |
3.382.519 |
2.701.458 |
4.451.148 |
| DF % **) |
1,0000 |
0,9167 |
0,8403 |
0,7703 |
0,7062 |
0,6473 |
0,5934 |
0,5440 |
0,4987 |
| Discounted Cashflow **) |
(26.010.776) |
(1.466.569) |
5.319.921 |
4.263.045 |
4.384.883 |
2.981.995 |
3.297.960 |
2.622.835 |
4.303.405 |
| NPV DF % |
-828.334 |
||||||||
| Net B/C ratio DF % |
0,97 |
||||||||
| IRR |
18,44% |
||||||||
| PBP (tahun) |
2,12 |
||||||||