| Lampiran 18 : Proyeksi Arus Kas untuk Analisis Sensitivitas Budidaya Udang Galah, Pendapatan Turun 14% | |||||||||||
| Pendapatan | 86% | ||||||||||
| 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.473.656 | 51.198.208 | 58.588.360 | 51.198.208 | 58.588.360 | 51.198.208 | 58.588.360 | 51.198.208 | ||
| 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.473.656 | 51.198.208 | 58.588.360 | 51.198.208 | 58.588.360 | 51.198.208 | 58.588.360 | 59.394.888 | ||
| Inflow untuk IRR | 0 | 39.473.656 | 51.198.208 | 58.588.360 | 51.198.208 | 58.588.360 | 51.198.208 | 58.588.360 | 59.394.888 | ||
| 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.189.048 | -911.906 | 4.176.098 | -103.204 | 8.344.630 | 3.875.977 | 8.559.630 | 12.072.657 | |
| 4 | Kumulatif cashflow | 0 | -9.189.048 | -10.100.954 | -5.924.856 | -6.028.060 | 2.316.570 | 6.192.547 | 14.752.177 | 26.824.834 | |
| 5 | Cashflow untuk IRR | -26.612.980 | -3.080.537 | 4.720.897 | 9.333.194 | 4.578.185 | 8.344.630 | 3.875.977 | 8.559.630 | 12.072.657 | |
| 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 | -2.789.118 | 3.869.720 | 6.926.164 | 3.076.083 | 5.076.038 | 2.134.500 | 4.267.832 | 5.449.597 | ||
| DF22% | 1,0000 | 0,9054 | 0,8197 | 0,7421 | 0,6719 | 0,6083 | 0,5507 | 0,4986 | 0,4514 | ||
| Discounted Cashflow | (26.612.980) | (2.789.118) | 3.869.720 | 6.926.164 | 3.076.083 | 5.076.038 | 2.134.500 | 4.267.832 | 5.449.597 | ||
| DF25% | 1,0000 | 0,8944 | 0,8000 | 0,7155 | 0,6400 | 0,5724 | 0,5120 | 0,4579 | 0,4096 | ||
| Discounted Cashflow | (26.612.980) | (2.755.316) | 3.776.718 | 6.678.290 | 2.930.039 | 4.776.745 | 1.984.500 | 3.919.854 | 4.944.960 | ||
| NPV DF 22% | 1.397.835 | ||||||||||
| Net B/C ratio DF 22% | 1,05 | ||||||||||
| IRR | 22,00 | ||||||||||
| PBP (tahun) | 2,36 | ||||||||||