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