Lampiran 15 . Proyeksi Arus Kas untuk Analisis Sensitivitas Budidaya Bandeng, Pendapatan Turun 5%
| 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 |
42.560.000 |
48.545.000 |
53.200.000 |
48.545.000 |
53.200.000 |
48.545.000 |
53.200.000 |
48.545.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 |
42.560.000 |
48.545.000 |
53.200.000 |
48.545.000 |
53.200.000 |
48.545.000 |
53.200.000 |
51.617.200 |
|
| Inflow untuk IRR |
0 |
42.560.000 |
48.545.000 |
53.200.000 |
48.545.000 |
53.200.000 |
48.545.000 |
53.200.000 |
51.617.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 |
|||||||||
| 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 |
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 |
|
| 3 |
Total cashflow |
3.000.000 |
-5.961.177 |
1.937.629 |
1.503.543 |
2.624.845 |
5.325.937 |
6.318.631 |
5.540.937 |
9.390.831 |
| 4 |
Kumulatif cashflow |
3.000.000 |
-2.961.177 |
-1.023.548 |
479.995 |
3.104.839 |
8.430.776 |
14.749.407 |
20.290.344 |
29.681.175 |
| 5 |
Cashflow untuk IRR |
-26.010.776 |
-402.813 |
7.091.749 |
6.253.418 |
6.970.475 |
5.325.937 |
6.318.631 |
5.540.937 |
9.390.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 |
-367.716 |
5.909.791 |
4.757.136 |
4.840.608 |
3.376.315 |
3.656.615 |
2.927.176 |
4.528.757 |
|
| a. Discounted Cashflow positif |
0 |
0 |
5.909.791 |
4.757.136 |
4.840.608 |
3.376.315 |
3.656.615 |
2.927.176 |
4.528.757 |
|
| b. Discounted Cashflow negatif |
-26.010.776 |
-367.716 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
| DF % *) |
1,0000 |
0,8909 |
0,7937 |
0,7070 |
0,6299 |
0,5611 |
0,4999 |
0,4454 |
0,3968 |
|
| Discounted Cashflow *) |
(26.010.776) |
(358.854) |
5.628.372 |
4.421.419 |
4.390.574 |
2.988.613 |
3.158.721 |
2.467.666 |
3.725.820 |
|
| DF % **) |
1,0000 |
0,8874 |
0,7874 |
0,6987 |
0,6200 |
0,5502 |
0,4882 |
0,4332 |
0,3844 |
|
| Discounted Cashflow **) |
(26.010.776) |
(357.438) |
5.584.054 |
4.369.300 |
4.321.703 |
2.930.129 |
3.084.692 |
2.400.326 |
3.609.850 |
|
| NPV DF % |
3.617.906 |
|||||||||
| Net B/C ratio DF % |
1,14 |
|||||||||
| IRR |
26,86% |
|||||||||
| PBP (tahun) |
1,71 |
|||||||||