| Lampiran 21 : Proyeksi Arus Kas untuk Analisis Sensitivitas Budidaya Udang Galah, Biaya Operasional Naik 20% | ||||||||||||||
| Biaya Operasi | 120% | |||||||||||||
| 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 | 45.899.600 | 59.532.800 | 68.126.000 | 59.532.800 | 68.126.000 | 59.532.800 | 68.126.000 | 59.532.800 | |||||
| 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 | 45.899.600 | 59.532.800 | 68.126.000 | 59.532.800 | 68.126.000 | 59.532.800 | 68.126.000 | 67.729.480 | |||||
| Inflow untuk IRR | 0 | 45.899.600 | 59.532.800 | 68.126.000 | 59.532.800 | 68.126.000 | 59.532.800 | 68.126.000 | 67.729.480 | |||||
| 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 | 51.065.032 | 54.926.680 | 53.148.589 | 54.926.680 | 53.148.589 | 54.926.680 | 53.148.589 | 54.926.680 | ||||||
| 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 | 57.173.542 | 61.264.561 | 63.270.360 | 60.455.859 | 59.101.828 | 56.476.678 | 58.886.828 | 56.476.678 | |||||
| Outflow untuk IRR | 26.612.980 | 51.065.032 | 55.631.757 | 58.113.264 | 55.774.469 | 59.101.828 | 56.476.678 | 58.886.828 | 56.476.678 | |||||
| 3 | Total cashflow | 0 | -11.273.942 | -1.731.761 | 4.855.640 | -923.059 | 9.024.172 | 3.056.122 | 9.239.172 | 11.252.802 | ||||
| 4 | Kumulatif cashflow | 0 | -11.273.942 | -13.005.703 | -8.150.063 | -9.073.122 | -48.951 | 3.007.172 | 12.246.343 | 23.499.145 | ||||
| 5 | Cashflow untuk IRR | -26.612.980 | -5.165.432 | 3.901.043 | 10.012.736 | 3.758.331 | 9.024.172 | 3.056.122 | 9.239.172 | 11.252.802 | ||||
| Perhitungan IRR, B/C rati | ||||||||||||||
| 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 | -4.676.782 | 3.197.685 | 7.430.452 | 2.525.222 | 5.489.404 | 1.683.006 | 4.606.651 | 5.079.515 | |||||
| DF15% | 1,0000 | 0,9325 | 0,8696 | 0,8109 | 0,7561 | 0,7051 | 0,6575 | 0,6131 | 0,5718 | |||||
| Discounted Cashflow | (26.612.980) | (4.816.765) | 3.392.347 | 8.119.328 | 2.841.674 | 6.362.944 | 2.009.400 | 5.664.536 | 6.434.352 | 3.394.836 | ||||
| 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) | (4.676.782) | 3.197.685 | 7.430.452 | 2.525.222 | 5.489.404 | 1.683.006 | 4.606.651 | 5.079.515 | -1.277.827 | ||||
| NPV DF 22% | -1.277.827 | 4.672.663 | ||||||||||||
| Net B/C ratio DF 22% | 0,96 | 0,72653 | ||||||||||||
| IRR | 20,09 | |||||||||||||
| PBP (tahun) | 2,51 | |||||||||||||