Lampiran 17. Proyeksi Arus Kas untuk Analisis Sensitivitas Budidaya Bandeng, Biaya Operasional Naik 5%
| 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 |
45.110.953 |
43.523.064 |
46.192.157 |
43.523.064 |
46.192.157 |
43.523.064 |
46.192.157 |
43.523.064 |
|
| 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 |
50.669.318 |
48.679.898 |
53.896.083 |
47.992.682 |
50.073.690 |
44.298.896 |
49.858.690 |
44.298.896 |
| Outflow untuk IRR |
26.010.776 |
45.110.953 |
43.525.778 |
49.146.208 |
43.647.052 |
50.073.690 |
44.298.896 |
49.858.690 |
44.298.896 |
| Total cashflow |
3.000.000 |
-5.869.318 |
2.420.102 |
2.103.917 |
3.107.318 |
5.926.311 |
6.801.104 |
6.141.311 |
9.873.304 |
| Kumulatif cashflow |
3.000.000 |
-2.869.318 |
-449.216 |
1.654.701 |
4.762.018 |
10.688.329 |
17.489.433 |
23.630.743 |
33.504.047 |
| Cashflow untuk IRR |
-26.010.776 |
-310.953 |
7.574.222 |
6.853.792 |
7.452.948 |
5.926.311 |
6.801.104 |
6.141.311 |
9.873.304 |
| DF % |
1,0000 |
0,9129 |
0,8333 |
0,7607 |
0,6944 |
0,6339 |
0,5787 |
0,5283 |
0,4823 |
| Discounted Cashflow |
-26.010.776 |
-283.860 |
6.311.851 |
5.213.856 |
5.175.659 |
3.756.914 |
3.935.824 |
3.244.342 |
4.761.431 |
| DF % **) |
1,0000 |
0,8704 |
0,7576 |
0,6594 |
0,5739 |
0,4995 |
0,4348 |
0,3784 |
0,3294 |
| Discounted Cashflow **) |
(26.010.776) |
(270.650) |
5.738.047 |
4.519.288 |
4.277.404 |
2.960.394 |
2.957.043 |
2.324.087 |
3.252.122 |
| NPV DF % |
6.105.242 |
||||||||
| Net B/C ratio DF % |
1,23 |
||||||||
| IRR |
31,44% |
||||||||
| PBP (tahun) |
1,60 |
||||||||