Previous Page Table of Contents


Annex - Economic calculation

Benefits and Costs for fish farming on a plot of 125 m2 square metres.

Table 1. Calculation of Costs

With Project
 W/o12345678910
A.Investment Cost           
labour           
Clearing of land 4900100100100100100100100100100
- Excavation           
- Pitting, fixing poles structching of wire 1100110110110110110110110110110
Materials:           
Barbed fencing & Poles, nails(transport) 5652100100100100100100100100100
Sub total (A)
 11652310310310310310310310310310
Contingencies 10 %
 1165313131313131313131
 Total (A) 12817341341341341341341341341341
B.Operating Costs(Average)90          
Fingerlings 50.0050.0050.0050.0050.0050.0050.0050.0050.0050.00
Feed, Manure, Complex 271.50271.50271.50271.50271.50271.50271.50271.50271.50271.50
Labour (Family labour)           
Miscellaneous (Distribution and Repairs, Maintenance) 200.00200.00200.00200.00200.00200.00200.00200.00200.00200.00
 
Sub Total (B)
90521.50521.50521.50521.50521.50521.50521.50521.50521.50521.50
 
Contingencies 10 %
952.0052.0052.0052.0052.0052.0052.0052.0052.0052.00
 Total (B)(rounded)573.50573.50573.50573.50573.50573.50573.50573.50573.50573.50
 Total Benefits(rounded)1273937393739373937393739373937393739373937
 Incremental Benefits(IB) 3810381038103810381038103810381038103810
 Costs Investment(1) 12817341341341341341341341341341
 Operating and Maintenance(2)90573.50573.50573.50573.50573.50573.50573.50573.50573.50573.50
 Total Costs(1,2)9013390914.5914914914914914914914914
 Incremental Cost (TC - W/o)(IC) 13300824824824824824824824824824
 Incremental Net Benefit (IB - IC) (9490)298629862986298629862986298629862986

Table 2. Net Present Worth and Benefit Cost Ration Calculation before financing

YearIncremental BenefitsIncremental CostDiscount Factor 13%Present Worth
Incremental BenefitsIncremental Cost
  1381013300    0.885337111770    
  238108240.7832983645
  338108240.6532487538
  438108240.6132344505
  538108240.5432068447
  638108240.4801828395
  738108240.4251619350
  838108240.3761432309
  938108240.3331268274
1038108240.2951123243
1138108240.261  994215
1238108240.231  880190
1338108240.204  777168
1438108240.181  689147
1538108240.160  609131
1638108240.141  537116
1738108240.125  476103
1838108240.111  422  91
1938108240.098  373  80
2038108240.087  331  71
    26611  16788  

NPW = 9823
BCR = 1.6

Table 3. Internal Rate of Return Calculation before financing

YearIncremental Net BenefitDiscount Factor 35%Present WorthDiscount Factor at 40 %Present Worth
  1(9490)0.741(7032)0.714(7032)
  229860.54916390.5101522
  329860.40612120.3641212
  429860.301  8980.260  898
  529860.223  6660.186  665
  629860.165  4930.133  492
  729860.122  3640.095  364
  829860.091  2710.068  271
  929860.067  2000.048  200
1029860.050  1490.035  149
1129860.037  1100.025  110
1229860.027    800.018    80
1329860.020    590.013    59
1429860.015    440.009    44
1529860.011   320.006    32
1629860.008   230.005    23
1729860.006   170.003    17
1829860.005   140.002      5
1929860.003     90.002      5
2029860.002     90.001      2
   (746) (882)

IRR - 36 %

Table 4. Amortization of loan of Rs. 8200 @ 15 % for a period of 12 years with a monatorium period of 12 years

YearOutstanding Principal of beginning of each yearTotal Amount PaymentInterest due at end of yearAmount of Principal repaid annually
  18200-1230-
  28200-1230-
  38200     1633.441230    403.44
  477971633     1169.50     463.50
  5     7333.4816331100533
  6     6800.4816331020613
  761881633       928.15705
  854831633       822.45     810.55
  9     4672.451633  701     932.13
1037401633  5611072  
1126681633  4001233  
1214361633  2151417  

Difference of Rs. 19 is due to rounding.

Table 5. Calculation of Net Cash Flow after financing

Items W/o123456789101112
Cash In flow              
- Gross Value of Production1127  393739373937393739373937393739373937393739373937
- Loan2-  8200- ---------
- Total Cash in flow1+2-12137- 393739373937393739373937393739373937
Incremental Cash in flow              
(Incremental Benefit plus amount of loan)    381038103810381038103810381038103810381038103810
    820000000000000
Total Increment Cost in flowICI1271201038103810381038103810381038103810381038103810
Cash Out flow              
- Investment  12817  341  341  341  341  341  341  341  341  341  341  341
- Operating Cost   90   573  573  573  573  573  573  573  573  573  573  573  573
- Debt (loan) Servicing  --          
- Repayment  --  403  464  533  613  705  811  932107212331418
- Interest    123012301230116911001020  928  822  701  561  400  215
Total Cash Out flow   901462021442547254725472547254725472547254725472547
Incremental Cash Out flowICO             
Total Cash Out flow - W/o -1453020542457245724572457245724572457245724572457
Incremental Net Cash flows (ICI - ICO)  (2520)17561353135313531353135313531353135313531353

Table 6. Net Present Worth and Benefit Cost ratio after financing Calculation Table

YearIncremental Cash In flowIncremental Cash Out flowDiscount Factor 13%Present Net Worth
Incremental Cash In flowIncremental Cash Out flow
  112010   14620  0.8851062812938
  2381021440.783  2983  1678
  3381025470.693  2640  1765
  4381025470.613  2336  1561
  5381025470.543  2068  1383
  6381025470.480  1828  1222
  7381025470.425  1619  1082
  8381025470.376  1432    957
  9381025470.333  1268    840
10381025470.295  1123    751
11381025470.261    994    664
12381025470.231    880    588
13381025470.204    777    519
14381025470.181    689    461
15381025470.160    609    407
16381025470.141    537    359
17381025470.125    476    318
18381025470.111    422    282
19381025470.098    373    249
20381025470.087    331    221
    3401328245

NPW = 34013 - 28245 = 5786

Table 7. Interest Rate of Return after financing

YearIncremental Net Cash flowDiscount Factor 45%Present WorthDiscount Factor 50%Present Worth
  1(2520)0.690(1738)    0.667(1680)
  213560.476835   0.444  779
  313530.328443   0.294  397
  413530.226305   0.198  267
  513530.156211   0.132  178
  613530.108146    0.088  119
  713530.074100    0.059    79
  813530.05169  0.039    52
  913530.03547  0.026    35
1013530.02432  0.017    23
1113530.01723  0.012    16
1213530.01216  0.008    10
1313530.00810  0.005      6
1413530.00680.003      4
1513530.00450.002      2
1613530.00340.002      2
1713530.00220.001      1
1813530.00110.001      1
1913530.00110.000      -
2013530.00110.000      -
             521  291

IRR = 48 %


Previous Page Top of Page