Project for Cultivation of  Orange( With Drip Irrigation)            
CASH FLOW STATEMENT            
          (Rs In Thousands)  
             
PARTICULARS   Year 0 Year I Year II Year III Year IV
             
             
SOURCES OF FUNDS            
             
             
 INCREASE IN FARMER'S SHARE                        87.50                           -                           -                        -                     -  
             
 NET PROFIT                             -                         5.67                    15.87                 16.16              17.30
             
             
 INCREASE IN SUBSIDY                        35.00                           -                           -                        -                     -  
              
 DEPRECIATION                           7.83                     7.83                   7.83                7.83
             
 PRELIMINARY EXP.W/O                               -                           -                        -                     -  
             
 INCREASE IN  TERM LOAN                        52.50                           -                           -                        -                     -  
             
 INCREASE IN WC                              -                             -                           -                        -                     -  
             
             
             
             
   TOTAL                    175.00                      13.50                    23.70                 23.99              25.13
             
             
 DEPLOYMENT            
              
             
 INCREASE IN FIXED ASSETS                      175.00                           -                           -                        -                     -  
             
 PRELIMINARY EXPENSES                             -                             -                           -                        -                     -  
             
 DECREASE IN TERM LOAN                             -                             -                       9.55                   9.55                9.55
             
 INCREASE IN CURRENT ASSETS                             -                             -                           -                        -                     -  
             
 INTEREST PAYMENT                               -                           -                        -                     -  
             
 TAXES                               -                           -                        -                     -  
             
 DIVIDEND                               -                           -                        -                     -  
             
             
             
             
 TOTAL                      175.00                           -                       9.56                   9.56                9.56
             
                 
               
             
 OPENING BALANCE                               -                      13.50                 27.63              42.07
              
 SURPLUS/DEFICIT                             -                        13.50                    14.14                 14.43              15.58
             
 CLOSING BALANCE                             -                        13.50                    27.63                 42.07              57.64
             
Project for Cultivation of  Orange( With Drip Irrigation)         (Rs In Thousands)  
PROJECTED BALANCE SHEET            
             
             
PARTICULARS   Year 0 Year I Year II Year III Year IV
             
             
LIABILITIES            
             
 FARMER'S SHARE                         87.5                       87.5                     87.5                   87.5                87.5
             
 CAPITAL SUBSIDY                         35.0                       35.0                     35.0                   35.0                35.0
             
 RESERVES & SURPLUSES                             -                           5.7                     21.5                   37.7                55.0
             
 TERM LOAN                         52.5                       52.5                     43.0                   33.4                23.9
             
 WC                              -                             -                           -                        -                     -  
             
             
             
 TOTAL                        175.0                      180.7                    187.0                 193.6              201.4
             
             
 ASSETS            
             
 FIXED ASSETS                        175.0                      175.0                    167.2                 159.4              151.5
             
 LESS DEPRECIATION                             7.8                       7.8                     7.8                  7.8
             
 NET BLOCK                        175.0                      167.2                    159.4                 151.5              143.7
             
             
 CURRENT ASSETS                             -                             -                           -                        -                     -  
             
 PRELIMINARY EXP.NOT W/O                             -                             -                           -                        -                     -  
             
             
 CASH & BANK BALANCE            
                            13.5                     27.6                   42.1                57.6
             
             
 TOTAL                        175.0                      180.7                    187.0                 193.6              201.4
                              -                           0.0                         -                      (0.0)                 (0.0)
                 
             
 Project for Cultivation of  Orange( With Drip Irrigation)            
             
PROJECTED PROFIT AND LOSS ACCOUNT         (Rs In Thousands)  
             
             
    Year I Year II Year III Year IV Year V
             
             
SALES REALISATION                         48.0                       60.0                     60.0                   60.0                60.0
             
             
TOTAL COSTS                         28.2                       30.0                     30.0                   30.0                30.0
             
             
GROSS PROFIT                         19.8                       30.0                     30.0                   30.0                30.0
             
DEPRECIATION                           7.8                         7.8                       7.8                     7.8                  7.8
             
PRE-OPERATIVE EXPENSES W/O                             -                             -                           -                        -                     -  
             
INTEREST ON TERM LOAN                           6.3                         6.3                       6.0                     4.9                  3.7
             
PROFIT BEFORE TAX                           5.7                       15.9                     16.2                   17.3                18.5
             
TAXES                             -                             -                           -                        -                     -  
             
PROFIT AFTER TAX                           5.7                       15.9                     16.2                   17.3                18.5
             
DIVIDEND                             -                             -                           -                        -                     -  
             
RETAINED PROFIT                           5.7                       15.9                     16.2                   17.3                18.5
             
NET CASH ACCRUALS                         13.5                       23.7                     24.0                   25.1                26.3
             
             
             
             
PROFIT & LOSS ACCOUNT            
             
             
OPENING BALANCE   0.0 5.7 21.5 37.7 55.0
             
             
CLOSING BALANCE   5.7 21.5 37.7 55.0 73.5
             
 
Project for Cultivation of  Orange( With Drip Irrigation)                                  
DISCOUNTED CASHFLOW STATEMENT         (Rs In Thousands)                        
                                   
                                   
PARTICULARS   Year I Year II Year III Year IV Year V Year VI Year VII Year VIII Year IX Year X Year X I Year X II Year X III Year X IV Year X V TOTAL
                                   
                                   
                                   
                                   
CAPITAL COST   175.0                           -                            
                                   
GROSS REVENUE   48.0 60.0 60.0 60.0 60.0 60.0 60.0 60.0 60.0 60.0 60.0 60.0 60.0 60.0 60.0  
                                   
PROD & OTHER COSTS   28.2 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0 30.0  
                                   
Salvage Value                               57.61  
                                   
                                   
GROSS SURPLUS   -155.2 30.0 30.0 30.0 30.0 30.00 30.0 30.00 30.00 30.0 30.0 30.0 30.0 30.0 87.6  
                                   
                                   
DF @ 15%                        0.870                      0.756                    0.658                 0.572              0.497              0.432          0.376         0.327        0.284          0.247          0.215          0.187          0.163          0.141          0.123  
                                   
PW @ 15%   -135.0 22.7 19.7 17.2 14.9 13.0 11.3 9.8 8.5 7.4 6.4 5.6 4.9 4.2 10.8 -10.48
                                   
DF @ 30%   0.769 0.592 0.455 0.350 0.269 0.234 0.204 0.177 0.154 0.134 0.116 0.101 0.088 0.077 0.067  
                                   
PW @ 30%   -119.4 17.8 13.7 10.5 8.1 7.0 6.1 5.3 4.6 4.0 3.5 3.0 2.6 2.3 5.8 -42.31
                                   
                                   
                                   
                                   
                                   
                                   
    IRR  =                        18.10                            
                                   
                                   
DF @ 11%                        0.901                      0.812                    0.731                 0.659              0.593              0.535          0.482         0.434        0.391          0.352          0.317          0.286          0.258          0.232          0.209  
                                   
PW  OF OPERATIONAL CASH FLOW   17.8 24.3 21.9 19.8 17.8 16.0 14.4 13.0 11.7 10.6 9.5 8.6 7.7 7.0 6.3 206.54
                                   
NPV OF OERATIONAL CASH FLOW   206.5                              
                                   
INITIAL INVESTMENT   175.0                              
                                   
BENEFIT COST RATIO   1.2                              
                                   
                                   
Project for Cultivation of  Orange( With Drip Irrigation)          
BREAK EVEN ANALYSIS          
        (Rs In Thousands)  
           
PARTICULARS         Year III
           
        (At Optimum Level)
           
           
GROSS SALES         60.0
           
FIXED COST(INCL DEP.& INT.)         43.8
           
VARIABLE COST         0.0
           
CONTRIBUTION         60.0
           
BREAK EVEN POINT (%)         73.1
           
CASH BEP (%)         60.0
           
           
           
 
Project for Cultivation of  Orange( With Drip Irrigation)                
DEBT SERVICE COVERAGE RATIO       (Rs In Thousands)        
                 
                 
    Year I Year II Year III Year IV Year V Year VI Year VII
                 
                 
NET PROFIT after tax   5.7 15.9 16.2 17.3 18.5 18.5 18.5
                 
DEPRECIATION   7.8 7.8 7.8 7.8 7.8 7.8 7.8
                 
PRELIMINARY EXP.W/O ADDED BACK   0.0 0.0 0.0 0.0 0.0 0.0 0.0
                 
INTEREST   6.3 6.3 6.0 4.9 3.7 2.6 0.9
                 
                 
TOTAL   19.8 30.0 30.0 30.0 30.0 28.9 27.1
                 
                 
                 
TERM LOAN INTEREST   6.3 6.3 6.0 4.9 3.7 2.6 0.9
                 
TERM LOAN REPAYMENT   0.0 9.5 9.5 9.5 9.5 9.5 4.8
                 
                 
                 
TOTAL   6.3 15.8 15.6 14.4 13.3 12.1 5.6
                 
                 
DSCR   3.1 1.9 1.9 2.1 2.3 2.4 4.8
                 
AVERAGE DSCR         2.35      
                 
Project for Cultivation of  Orange( With Drip Irrigation)            
PAY BACK PERIOD         (Rs In Thousands)  
             
             
PARTICULARS     Year I Year II Year III Year IV
             
             
             
CAPITAL INVESTMENT     175.0      
             
NET CASH ACCRUALS     13.5 23.7 24.0 25.1
             
CUMULATIVE INCOME     13.5 37.2 61.2 86.3
             
             
             
             
             
             
    PAYBACK PERIOD   7.73 YEARS  
             
             
Project for Cultivation of  Orange( With Drip Irrigation)
COST OF PRODUCTION & PROFITABILITY ( Rupees In thousands)
             
               
PARTICULARS     Year I Year II Year III Year IV Year V to XV
               
     
INCOME                           48.0                     60.0                   60.0                60.0               60.0
               
Sales                           48.0                     60.0                   60.0                60.0               60.0
               
COST                           28.2                     30.0                   30.0                30.0               30.0
               
VARIABLE                               -                           -                        -      
               
FREIGHT                               -                           -                        -      
               
FIXED                           28.2                     30.0                   30.0                30.0               30.0
               
MANURE/FERTILIZERS/CHEMICALS                           12.0                     12.0                   12.0                12.0               12.0
DIRECT LABOUR COST                             5.6                       5.6                     5.6                  5.6                 5.6
OTHER COST                             3.6                       3.6                     3.6                  3.6                 3.6
HARVESTING & TRANSPORTATION COST                             6.5                       8.3                     8.3                  8.3                 8.3
GENERAL EXPENSES                             0.5                       0.5                     0.5                  0.5                 0.5
               
               
GROSS PROFIT                           19.8                     30.0                   30.0                30.0               30.0
               
DEPRECIATION                             7.8                       7.8                     7.8                  7.8                 7.8
               
INTEREST -TERM LOAN                             6.3                       6.3                     6.0                  4.9                 3.7
PRE- OPERATIVE EXP.W/O                               -                           -                        -                     -                     -  
PROFIT BEFORE TAX                             5.7                     15.9                   16.2                17.3               18.5
TAXES                               -                           -                        -                     -                     -  
               
PROFIT AFTER TAXES                             5.7                     15.9                   16.2                17.3               18.5
               
DIVIDEND %                               -                           -                        -                     -                     -  
DIVIDEND AMOUNT                               -                           -                        -                     -                     -  
               
RETAINED PROFIT                             5.7                     15.9                   16.2                17.3               18.5
               
NET CASH ACCRUAL                           13.5                     23.7                   24.0                25.1               26.3