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 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.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