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 ratio, NPV dan PBP                  
  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