| Lampiran 19 : Proyeksi Arus Kas untuk Analisis Sensitivitas Budidaya Udang Galah, Pendapatan Turun 15% | |||||||||||||
| Pendapatan | 85% | ||||||||||||
| 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 | 39.014.660 | 50.602.880 | 57.907.100 | 50.602.880 | 57.907.100 | 50.602.880 | 57.907.100 | 50.602.880 | ||||
| b. Dana sendiri | 9.314.543 | ||||||||||||
| c. Kredit investasi | 3.745.300 | ||||||||||||
| d. Kredit modal kerja | 13.553.137 | ||||||||||||
| e. Nilai sisa | 8.196.680 | ||||||||||||
| Jumlah | 26.612.980 | 39.014.660 | 50.602.880 | 57.907.100 | 50.602.880 | 57.907.100 | 50.602.880 | 57.907.100 | 58.799.560 | ||||
| Inflow untuk IRR | 0 | 39.014.660 | 50.602.880 | 57.907.100 | 50.602.880 | 57.907.100 | 50.602.880 | 57.907.100 | 58.799.560 | ||||
| 2 | Outflow | ||||||||||||
| a. Biaya investasi | 5.762.000 | 0 | 0 | 2.677.000 | 0 | 2.892.000 | 0 | 2.677.000 | 0 | ||||
| b. Biaya modal kerja | 20.850.980 | ||||||||||||
| c. Biaya operasional | 42.554.193 | 45.772.234 | 44.290.491 | 45.772.234 | 44.290.491 | 45.772.234 | 44.290.491 | 45.772.234 | |||||
| d. Angsuran pokok | 4.324.609 | 4.324.609 | 4.324.609 | 4.324.609 | |||||||||
| e. Biaya bunga bank | 1.783.901 | 1.308.194 | 832.487 | 356.780 | |||||||||
| f. Pajak 15% | 0 | 705.077 | 2.287.674 | 847.789 | 3.061.239 | 1.549.997 | 3.061.239 | 1.549.997 | |||||
| Jumlah | 26.612.980 | 48.662.704 | 52.110.114 | 54.412.262 | 51.301.412 | 50.243.730 | 47.322.231 | 50.028.730 | 47.322.231 | ||||
| Outflow untuk IRR | 26.612.980 | 42.554.193 | 46.477.311 | 49.255.166 | 46.620.023 | 50.243.730 | 47.322.231 | 50.028.730 | 47.322.231 | ||||
| 3 | Total cashflow | 0 | -9.648.044 | -1.507.234 | 3.494.838 | -698.532 | 7.663.370 | 3.280.649 | 7.878.370 | 11.477.329 | |||
| 4 | Kumulatif cashflow | 0 | -9.648.044 | -11.155.278 | -7.660.440 | -8.358.972 | -695.602 | 2.585.047 | 10.463.417 | 21.940.746 | |||
| 5 | Cashflow untuk IRR | -26.612.980 | -3.539.533 | 4.125.569 | 8.651.934 | 3.982.857 | 7.663.370 | 3.280.649 | 7.878.370 | 11.477.329 | |||
| Perhitungan IRR, B/C | |||||||||||||
| DF 22% | 1,0000 | 0,9054 | 0,8197 | 0,7421 | 0,6719 | 0,6083 | 0,5507 | 0,4986 | 0,4514 | ||||
| Discounted Cashflow | -26.612.980 | -3.204.693 | 3.381.729 | 6.420.601 | 2.676.082 | 4.661.628 | 1.806.653 | 3.928.155 | 5.180.866 | ||||
| DF15% | 1,0000 | 0,9325 | 0,8696 | 0,8109 | 0,7561 | 0,7051 | 0,6575 | 0,6131 | 0,5718 | ||||
| Discounted Cashflow | (26.612.980) | (3.300.615) | 3.587.595 | 7.015.854 | 3.011.438 | 5.403.442 | 2.157.027 | 4.830.229 | 6.562.737 | 2.654.727 | |||
| DF22% | 1,0000 | 0,9054 | 0,8197 | 0,7421 | 0,6719 | 0,6083 | 0,5507 | 0,4986 | 0,4514 | ||||
| Discounted Cashflow | (26.612.980) | (3.204.693) | 3.381.729 | 6.420.601 | 2.676.082 | 4.661.628 | 1.806.653 | 3.928.155 | 5.180.866 | -1.761.959 | |||
| NPV DF 22% | -1.761.959 | 4.416.686 | |||||||||||
| Net B/C ratio DF 22 | 0,94 | 0,60107 | |||||||||||
| IRR | 19,21 | ||||||||||||
| PBP (tahun) | 2,61 | ||||||||||||