| Lampiran 20 : Proyeksi Arus Kas untuk Analisis Sensitivitas Budidaya Udang Galah, Biaya Operasional Naik 19% | ||||||||||||||
| Biaya Operasional | 119% | |||||||||||||
| 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 | 50.639.490 | 54.468.958 | 52.705.685 | 54.468.958 | 52.705.685 | 54.468.958 | 52.705.685 | 54.468.958 | ||||||
| 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 | 56.748.000 | 60.806.839 | 62.827.455 | 59.998.137 | 58.658.923 | 56.018.956 | 58.443.923 | 56.018.956 | |||||
| Outflow untuk IRR | 26.612.980 | 50.639.490 | 55.174.035 | 57.670.359 | 55.316.747 | 58.658.923 | 56.018.956 | 58.443.923 | 56.018.956 | |||||
| 3 | Total cashflow | 0 | -10.848.400 | -1.274.039 | 5.298.545 | -465.337 | 9.467.077 | 3.513.844 | 9.682.077 | 11.710.524 | ||||
| 4 | Kumulatif cashflow | 0 | -10.848.400 | -12.122.439 | -6.823.894 | -7.289.231 | 2.177.846 | 5.691.690 | 15.373.767 | 27.084.291 | ||||
| 5 | Cashflow untuk IRR | -26.612.980 | -4.739.890 | 4.358.765 | 10.455.641 | 4.216.053 | 9.467.077 | 3.513.844 | 9.682.077 | 11.710.524 | ||||
| Perhitungan IRR, B/C r | ||||||||||||||
| 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.291.496 | 3.572.880 | 7.759.131 | 2.832.766 | 5.758.823 | 1.935.074 | 4.827.483 | 5.286.131 | |||||
| DF22% | 1,0000 | 0,9054 | 0,8197 | 0,7421 | 0,6719 | 0,6083 | 0,5507 | 0,4986 | 0,4514 | |||||
| Discounted Cashflow | (26.612.980) | (4.291.496) | 3.572.880 | 7.759.131 | 2.832.766 | 5.758.823 | 1.935.074 | 4.827.483 | 5.286.131 | 1.067.812 | ||||
| DF25% | 1,0000 | 0,8944 | 0,8000 | 0,7155 | 0,6400 | 0,5724 | 0,5120 | 0,4579 | 0,4096 | |||||
| Discounted Cashflow | (26.612.980) | (4.239.486) | 3.487.012 | 7.481.448 | 2.698.274 | 5.419.271 | 1.799.088 | 4.433.875 | 4.796.631 | -736.867 | ||||
| NPV DF 22% | 1.067.812 | 1.804.679 | ||||||||||||
| Net B/C ratio DF 22% | 1,03 | 0,59169 | ||||||||||||
| IRR | 23,78 | |||||||||||||
| PBP (tahun) | 2,38 | |||||||||||||