Lampiran 19 : Proyeksi Arus Kas untuk Analisis Sensitivitas Budidaya Udang Galah, Pendapatan Turun 15%
Pendapatan  85%
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.014.660 50.602.880 57.907.100 50.602.880 57.907.100 50.602.880 57.907.100 50.602.880
  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.014.660 50.602.880 57.907.100 50.602.880 57.907.100 50.602.880 57.907.100 58.799.560
  Inflow untuk IRR 0 39.014.660 50.602.880 57.907.100 50.602.880 57.907.100 50.602.880 57.907.100 58.799.560
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.648.044 -1.507.234 3.494.838 -698.532 7.663.370 3.280.649 7.878.370 11.477.329
4 Kumulatif cashflow 0 -9.648.044 -11.155.278 -7.660.440 -8.358.972 -695.602 2.585.047 10.463.417 21.940.746
5 Cashflow untuk IRR -26.612.980 -3.539.533 4.125.569 8.651.934 3.982.857 7.663.370 3.280.649 7.878.370 11.477.329
  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 -3.204.693 3.381.729 6.420.601 2.676.082 4.661.628 1.806.653 3.928.155 5.180.866
  DF15% 1,0000 0,9325 0,8696 0,8109 0,7561 0,7051 0,6575 0,6131 0,5718
  Discounted Cashflow  (26.612.980) (3.300.615)    3.587.595 7.015.854    3.011.438    5.403.442    2.157.027 4.830.229    6.562.737 2.654.727
  DF22% 1,0000 0,9054 0,8197 0,7421 0,6719 0,6083 0,5507 0,4986 0,4514  
  Discounted Cashflow  (26.612.980) (3.204.693)    3.381.729 6.420.601    2.676.082    4.661.628    1.806.653 3.928.155    5.180.866 -1.761.959
  NPV DF 22% -1.761.959                 4.416.686
  Net B/C ratio DF 22% 0,94                 0,60107
  IRR 19,21
  PBP (tahun) 2,61