Lampiran 19. Proyeksi Arus Kas untuk Analisis Sensitivitas Budiaya Bandeng, Penerimaan Turun 3% dan Biaya Operasional Naik 3%
| 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.456.000 |
49.567.000 |
54.320.000 |
49.567.000 |
54.320.000 |
49.567.000 |
54.320.000 |
49.567.000 |
|
| b. Dana sendiri |
12.840.988 |
|||||||||
| c. Kredit investasi |
5.825.400 |
|||||||||
| d. Kredit modal kerja |
10.344.388 |
|||||||||
| e. Nilai sisa |
0 |
3.072.200 |
||||||||
| Jumlah |
29.010.776 |
43.456.000 |
49.567.000 |
54.320.000 |
49.567.000 |
54.320.000 |
49.567.000 |
54.320.000 |
52.639.200 |
|
| Inflow untuk IRR |
0 |
43.456.000 |
49.567.000 |
54.320.000 |
49.567.000 |
54.320.000 |
49.567.000 |
54.320.000 |
52.639.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.251.697 |
42.694.054 |
45.312.306 |
42.694.054 |
45.312.306 |
42.694.054 |
45.312.306 |
42.694.054 |
|
| 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 |
2.714 |
417.052 |
123.987 |
1.129.533 |
775.832 |
1.129.533 |
775.832 |
||
| Jumlah |
26.010.776 |
49.810.062 |
47.850.887 |
53.016.233 |
47.163.671 |
49.193.839 |
43.469.886 |
48.978.839 |
43.469.886 |
|
| Outflow untuk IRR |
26.010.776 |
44.251.697 |
42.696.768 |
48.266.358 |
42.818.041 |
49.193.839 |
43.469.886 |
48.978.839 |
43.469.886 |
|
| 3 |
Total cashflow |
3.000.000 |
-6.354.062 |
1.716.113 |
1.303.767 |
2.403.329 |
5.126.161 |
6.097.115 |
5.341.161 |
9.169.315 |
| 4 |
Kumulatif cashflow |
3.000.000 |
-3.354.062 |
-1.637.949 |
-334.182 |
2.069.147 |
7.195.308 |
13.292.422 |
18.633.583 |
27.802.898 |
| 5 |
Cashflow untuk IRR |
-26.010.776 |
-795.697 |
6.870.232 |
6.053.642 |
6.748.959 |
5.126.161 |
6.097.115 |
5.341.161 |
9.169.315 |
| DF % |
1,0000 |
0,9129 |
0,8333 |
0,7607 |
0,6944 |
0,6339 |
0,5787 |
0,5283 |
0,4823 |
|
| Discounted Cashflow |
-26.010.776 |
-726.369 |
5.725.194 |
4.605.162 |
4.686.777 |
3.249.669 |
3.528.423 |
2.821.638 |
4.421.930 |
|
| a. Discounted Cashflow positif |
0 |
0 |
5.725.194 |
4.605.162 |
4.686.777 |
3.249.669 |
3.528.423 |
2.821.638 |
4.421.930 |
|
| b. Discounted Cashflow negatif |
-26.010.776 |
-726.369 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
| DF % *) |
1,0000 |
0,8980 |
0,8065 |
0,7242 |
0,6504 |
0,5840 |
0,5245 |
0,4710 |
0,4230 |
|
| Discounted Cashflow *) |
(26.010.776) |
(714.557) |
5.540.510 |
4.384.138 |
4.389.281 |
2.993.905 |
3.197.859 |
2.515.705 |
3.878.378 |
|
| DF % **) |
1,0000 |
0,8944 |
0,8000 |
0,7155 |
0,6400 |
0,5724 |
0,5120 |
0,4579 |
0,4096 |
|
| Discounted Cashflow **) |
(26.010.776) |
(711.693) |
5.496.186 |
4.331.634 |
4.319.334 |
2.934.386 |
3.121.723 |
2.445.967 |
3.755.751 |
|
| NPV DF % |
2.301.648 |
|||||||||
| Net B/C ratio DF % |
1,09 |
|||||||||
| IRR |
24,35% |
|||||||||
| PBP (tahun) |
1,80 |
|||||||||