Lampiran 14. Proyeksi Arus Kas dan Analisis Kelayakan Budidaya Bandeng
| 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 |
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 |
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 |
| Total cashflow |
3.000.000 |
-3.721.177 |
4.492.629 |
4.303.543 |
5.179.845 |
8.125.937 |
8.873.631 |
8.340.937 |
11.945.831 |
| Kumulatif cashflow |
3.000.000 |
-721.177 |
3.771.451 |
8.074.994 |
13.254.839 |
21.380.776 |
30.254.407 |
38.595.344 |
50.541.174 |
| Cashflow untuk IRR |
-26.010.776 |
1.837.188 |
9.646.749 |
9.053.418 |
9.525.475 |
8.125.937 |
8.873.631 |
8.340.937 |
11.945.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.677.115 |
8.038.957 |
6.887.169 |
6.614.913 |
5.151.341 |
5.135.203 |
4.406.365 |
5.760.914 |
| a. Discounted Cashflow positif |
0 |
1.677.115 |
8.038.957 |
6.887.169 |
6.614.913 |
5.151.341 |
5.135.203 |
4.406.365 |
5.760.914 |
| b. Discounted Cashflow negatif |
-26.010.776 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
| DF%*) |
1,0000 |
0,8111 |
0,6579 |
0,5336 |
0,4328 |
0,3511 |
0,2848 |
0,2310 |
0,1873 |
| Discounted Cashflow *) |
(26.010.776) |
1.490.156 |
6.346.545 |
4.831.113 |
4.122.868 |
2.852.755 |
2.526.798 |
1.926.470 |
2.237.907 |
| DF% **) |
1,0000 |
0,8058 |
0,6494 |
0,5233 |
0,4217 |
0,3398 |
0,2738 |
0,2206 |
0,1778 |
| Discounted Cashflow **) |
(26.010.776) |
1.480.448 |
6.264.122 |
4.737.307 |
4.016.476 |
2.761.033 |
2.429.625 |
1.840.316 |
2.123.897 |
| NPV DF % |
17.661.201 |
||||||||
| Net B/C ratio DF % |
1,68 |
||||||||
| IRR |
53,02% |
||||||||
| PBP (tahun) |
0,39 |
||||||||