Project for setting up Patchouli crop            
CASH FLOW STATEMENT            
            (Rs In Thousands)
             
PARTICULARS   Year 0 Year I Year II Year III  
             
             
SOURCES OF FUNDS            
             
             
 INCREASE IN FARMER'S SHARE                      110.00                           -                           -                        -    
             
 NET PROFIT                             -                        23.64                    34.26                 35.70  
             
             
 INCREASE IN SUBSIDY                        44.00                           -                           -                        -    
              
 DEPRECIATION                          19.30                    19.30                 19.30  
             
 PRELIMINARY EXP.W/O                               -                           -                        -    
             
 INCREASE IN  TERM LOAN                        66.00                           -                           -                        -    
             
 INCREASE IN WC                              -                             -                           -                        -    
             
             
             
             
   TOTAL                    220.00                      42.94                    53.56                 55.00  
             
             
 DEPLOYMENT            
              
             
 INCREASE IN FIXED ASSETS                      220.00                           -                           -                        -    
             
 PRELIMINARY EXPENSES                             -                             -                           -                        -    
             
 DECREASE IN TERM LOAN                             -                         6.00                    12.00                 12.00  
             
 INCREASE IN CURRENT ASSETS                             -                             -                           -                        -    
             
 INTEREST PAYMENT                               -                           -                        -    
             
 TAXES                               -                           -                        -    
             
 DIVIDEND                               -                           -                        -    
             
             
             
             
 TOTAL                      220.00                       6.00                    12.01                 12.01  
             
                 
               
             
 OPENING BALANCE                               -                      36.94                 78.48  
              
 SURPLUS/DEFICIT                             -                        36.94                    41.55                 42.99  
             
 CLOSING BALANCE                             -                        36.94                    78.48               121.47  
             
Project for setting up Patchouli crop           (Rs In Thousands)
PROJECTED BALANCE SHEET            
             
             
PARTICULARS   Year 0 Year I Year II Year III  
             
             
LIABILITIES            
             
 FARMER'S SHARE                        110.0                      110.0                    110.0                 110.0  
             
 CAPITAL SUBSIDY                         44.0                       44.0                     44.0                   44.0  
             
 RESERVES & SURPLUSES                             -                         23.6                     57.9                   93.6  
             
 TERM LOAN                         66.0                       60.0                     48.0                   36.0  
             
 WC                              -                             -                           -                        -    
             
             
             
 TOTAL                        220.0                      237.6                    259.9                 283.6  
             
             
 ASSETS            
             
 FIXED ASSETS                        220.0                      220.0                    200.7                 181.4  
             
 LESS DEPRECIATION                           19.3                     19.3                   19.3  
             
 NET BLOCK                        220.0                      200.7                    181.4                 162.1  
             
             
 CURRENT ASSETS                             -                             -                           -                        -    
             
 PRELIMINARY EXP.NOT W/O                             -                             -                           -                        -    
             
             
 CASH & BANK BALANCE            
                            36.9                     78.5                 121.5  
             
             
 TOTAL                        220.0                      237.6                    259.9                 283.6  
                              -                           0.0                         -                      (0.0)  
                 
             
 Project for setting up Patchouli crop            
             
PROJECTED PROFIT AND LOSS ACCOUNT           (Rs In Thousands)
             
             
    Year I Year II Year III    
             
             
SALES REALISATION                         72.0                       84.4                     84.4    
             
             
TOTAL COSTS                         21.1                       24.0                     24.0    
             
             
GROSS PROFIT                         50.9                       60.4                     60.4    
             
DEPRECIATION                         19.3                       19.3                     19.3    
             
INTEREST ON TERM LOAN                           7.9                         6.8                       5.4    
             
PROFIT BEFORE TAX                         23.6                       34.3                     35.7    
             
TAXES                             -                             -                           -      
             
PROFIT AFTER TAX                         23.6                       34.3                     35.7    
             
DIVIDEND                             -                             -                           -      
             
RETAINED PROFIT                         23.6                       34.3                     35.7    
             
NET CASH ACCRUALS                         42.9                       53.6                     55.0    
             
             
             
             
PROFIT & LOSS ACCOUNT            
             
             
OPENING BALANCE   0.0 23.6 57.9    
             
             
CLOSING BALANCE   23.6 57.9 93.6    
             
 
Project for setting up Patchouli crop                        
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 TOTAL
                         
                         
                         
                         
CAPITAL COST   220.0                           -   33.4                 -            33.4      
                         
GROSS REVENUE   72.0 84.4 84.4 72.0 84.4 84.4          72.0          84.4          84.4    72.0  
                         
PROD & OTHER COSTS   21.1 24.0 24.0 21.1 24.0 24.0          21.1          24.0          24.0    21.1  
                         
Salvage Value                        27.0  
                         
                         
GROSS SURPLUS   -169.1 60.4 60.4 17.5 60.4 60.40          50.9          27.0          60.4          77.8  
                         
                         
DF @ 15%                        0.870                      0.756                    0.658                 0.572              0.497        0.432            0.4            0.3            0.3            0.2  
                         
PW @ 15%   -147.1 45.7 39.7 10.0 30.0 26.1          19.1            8.8          17.2          19.2     68.8
                         
DF @ 30%   0.769 0.592 0.455 0.350 0.269 0.234            0.2            0.2            0.2            0.1  
                         
PW @ 30%   -130.1 35.7 27.5 6.1 16.3 14.1          10.4            4.8            9.3          10.4      4.5
                         
                         
                         
                         
                         
                         
    IRR  =                        27.23                  
                         
                         
DF @ 11%                        0.901                      0.812                    0.731                 0.659              0.593        0.535        0.482        0.434        0.391        0.352  
                         
PW  OF OPERATIONAL CASH FLOW   45.8 49.0 44.2 33.5 35.8 32.3 24.5 26.2 23.6 17.9 332.88
                         
NPV OF OERATIONAL CASH FLOW   332.9                    
                         
INITIAL INVESTMENT   220.0                    
                         
BENEFIT COST RATIO   1.5                    
                         
                         
Project for setting up Patchouli crop          
BREAK EVEN ANALYSIS          
        (Rs In Thousands)  
           
PARTICULARS         Year III
           
        (At Optimum Level)
           
           
GROSS SALES         84.4
           
FIXED COST(INCL DEP.& INT.)         48.7
           
VARIABLE COST         0.0
           
CONTRIBUTION         84.4
           
BREAK EVEN POINT (%)         57.7
           
CASH BEP (%)         57.7
           
           
           
 
Project for setting up Patchouli crop            
DEBT SERVICE COVERAGE RATIO       (Rs In Thousands)    
             
             
    Year I Year II Year III    
             
             
NET PROFIT after tax   23.6 34.3 35.7    
             
DEPRECIATION   19.3 19.3 19.3    
             
PRELIMINARY EXP.W/O ADDED BACK   0.0 0.0 0.0    
             
INTEREST   7.9 6.8 5.4    
             
             
TOTAL   50.9 60.4 60.4    
             
             
             
TERM LOAN INTEREST   7.9 6.8 5.4    
             
TERM LOAN REPAYMENT   6.0 12.0 12.0    
             
             
             
TOTAL   13.9 18.8 17.4    
             
             
DSCR   3.7 3.2 3.5    
             
AVERAGE DSCR         3.42  
             
Project for setting up Patchouli crop            
PAY BACK PERIOD         (Rs In Thousands)  
             
             
PARTICULARS     Year I Year II Year III  
             
             
             
CAPITAL INVESTMENT     220.0   0.0  
             
NET CASH ACCRUALS     42.9 53.6 55.0  
             
CUMULATIVE INCOME     42.9 96.5 151.5  
             
             
             
             
             
             
    PAYBACK PERIOD   4.23 YEARS  
             
             
Project for setting up Patchouli crop
COST OF PRODUCTION & PROFITABILITY ( Rupees In thousands)
             
         
PARTICULARS     Year I Year II Year III  
             
INCOME                           72.0                     84.4                   84.4  
             
Sales                           72.0                     84.4                   84.4  
             
COST                           21.1                     24.0                   24.0  
             
VARIABLE                               -                           -                        -    
             
FREIGHT                               -                           -                        -    
             
FIXED                           21.1                     24.0                   24.0  
             
PLANTING MATERIAL                               -                           -                        -    
MANURE/FERTILIZERS/CHEMICALS                             3.6                       3.6                     3.6  
DIRECT LABOUR COST                             4.2                       4.2                     4.2  
OTHER COST                             3.6                       3.6                     3.6  
HARVESTING & TRANSPORTATION COST                             9.2                     12.1                   12.1  
GENERAL EXPENSES                             0.5                       0.5                     0.5  
             
             
GROSS PROFIT                           50.9                     60.4                   60.4  
             
DEPRECIATION                           19.3                     19.3                   19.3  
             
INTEREST -TERM LOAN                             7.9                       6.8                     5.4  
PRE- OPERATIVE EXP.W/O                               -                           -                        -    
PROFIT BEFORE TAX                           23.6                     34.3                   35.7  
TAXES                               -                           -                        -    
             
PROFIT AFTER TAXES                           23.6                     34.3                   35.7  
             
DIVIDEND %                               -                           -                        -    
DIVIDEND AMOUNT                               -                           -                        -    
             
RETAINED PROFIT                           23.6                     34.3                   35.7  
             
NET CASH ACCRUAL                           42.9                     53.6                   55.0