Project for Cultivation of  Aonla( 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		62.50	-	-	-	-
NET PROFIT		-	(4.10)	6.10	18.20	33.22
INCREASE IN SUBSIDY		25.00	-	-	-	-
DEPRECIATION			5.75	5.75	5.75	5.75
PRELIMINARY EXP.W/O			-	-	-	-
INCREASE IN  TERM LOAN		37.50	-	-	-	-
INCREASE IN WC		-	-	-	-	-
	TOTAL	125.00	1.65	11.85	23.95	38.97
DEPLOYMENT
INCREASE IN FIXED ASSETS		125.00	-	-	-	-
PRELIMINARY EXPENSES		-	-	-	-	-
DECREASE IN TERM LOAN		-	-	6.82	6.82	6.82
INCREASE IN CURRENT ASSETS		-	-	-	-	-
INTEREST PAYMENT			-	-	-	-
TAXES			-	-	-	-
DIVIDEND			-	-	-	-
TOTAL		125.00	-	6.83	6.83	6.83
OPENING BALANCE			-	1.65	6.66	23.79
SURPLUS/DEFICIT		-	1.65	5.02	17.13	32.14
CLOSING BALANCE		-	1.65	6.66	23.79	55.93
Project for Cultivation of  Aonla( With Drip Irrigation)					(Rs In Thousands)
PROJECTED BALANCE SHEET
PARTICULARS		Year 0	Year I	Year II	Year III	Year IV
LIABILITIES
FARMER'S SHARE		62.5	62.5	62.5	62.5	62.5
CAPITAL SUBSIDY		25.0	25.0	25.0	25.0	25.0
RESERVES & SURPLUSES		-	(4.1)	2.0	20.2	53.4
TERM LOAN		37.5	37.5	30.7	23.9	17.0
WC		-	-	-	-	-
TOTAL		125.0	120.9	120.2	131.6	158.0
ASSETS
FIXED ASSETS		125.0	125.0	119.3	113.5	107.8
LESS DEPRECIATION			5.8	5.8	5.8	5.8
NET BLOCK		125.0	119.2	113.5	107.8	102.0
CURRENT ASSETS		-	-	-	-	-
PRELIMINARY EXP.NOT W/O		-	-	-	-	-
CASH & BANK BALANCE
			1.7	6.7	23.8	55.9
TOTAL		125.0	120.9	120.2	131.6	157.9
		-	0.0	-	(0.0)	(0.0)
Project for Cultivation of  Aonla( With Drip Irrigation)
PROJECTED PROFIT AND LOSS ACCOUNT					(Rs In Thousands)
		Year I	Year II	Year III	Year IV	Year V
SALES REALISATION		28.0	40.0	54.0	70.0	80.0
TOTAL COSTS		21.9	23.7	25.8	27.6	28.7
GROSS PROFIT		6.2	16.4	28.3	42.5	51.4
DEPRECIATION		5.8	5.8	5.8	5.8	5.8
PRE-OPERATIVE EXPENSES W/O		-	-	-	-	-
INTEREST ON TERM LOAN		4.5	4.5	4.3	3.5	2.7
PROFIT BEFORE TAX		(4.1)	6.1	18.2	33.2	42.9
TAXES		-	-	-	-	-
PROFIT AFTER TAX		(4.1)	6.1	18.2	33.2	42.9
DIVIDEND		-	-	-	-	-
RETAINED PROFIT		(4.1)	6.1	18.2	33.2	42.9
NET CASH ACCRUALS		1.7	11.9	24.0	39.0	48.7
PROFIT & LOSS ACCOUNT
OPENING BALANCE		0.0	-4.1	2.0	20.2	53.4
CLOSING BALANCE		-4.1	2.0	20.2	53.4	96.4
Project for Cultivation of  Aonla( 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		125.0		-
GROSS REVENUE		28.0	40.0	54.0	70.0	80.0	80.0	80.0	80.0	80.0	80.0	80.0	80.0	80.0	80.0	80.0
PROD & OTHER COSTS		21.9	23.7	25.8	27.6	28.7	28.7	28.7	28.7	28.7	28.7	28.7	28.7	28.7	28.7	28.7
Salvage Value																38.75
GROSS SURPLUS		-118.9	16.4	28.3	42.5	28.3	28.25	51.4	51.35	51.35	51.4	51.4	51.4	51.4	51.4	90.1
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%		-103.3	12.4	18.6	24.3	14.0	12.2	19.3	16.8	14.6	12.7	11.0	9.6	8.3	7.3	11.1	41.50
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%		-91.4	9.7	12.9	14.9	7.6	6.6	10.5	9.1	7.9	6.9	6.0	5.2	4.5	3.9	6.0	-5.47
		IRR  =	27.78
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		5.5	13.3	20.7	28.0	30.5	27.5	24.7	22.3	20.1	18.1	16.3	14.7	13.2	11.9	10.7	277.37
NPV OF OERATIONAL CASH FLOW		277.4
INITIAL INVESTMENT		125.0
BENEFIT COST RATIO		2.2
Project for Cultivation of  Aonla( With Drip Irrigation)
BREAK EVEN ANALYSIS
				(Rs In Thousands)
PARTICULARS					Year III
				(At Optimum Level)
GROSS SALES					54.0
FIXED COST(INCL DEP.& INT.)					35.8
VARIABLE COST					0.0
CONTRIBUTION					54.0
BREAK EVEN POINT (%)					66.3
CASH BEP (%)					55.6
Project for Cultivation of  Aonla( 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		-4.1	6.1	18.2	33.2	42.9	42.9	42.9
DEPRECIATION		5.8	5.8	5.8	5.8	5.8	5.8	5.8
PRELIMINARY EXP.W/O ADDED BACK		0.0	0.0	0.0	0.0	0.0	0.0	0.0
INTEREST		4.5	4.5	4.3	3.5	2.7	1.8	0.6
TOTAL		6.2	16.4	28.3	42.5	51.4	50.5	49.3
TERM LOAN INTEREST		4.5	4.5	4.3	3.5	2.7	1.8	0.6
TERM LOAN REPAYMENT		0.0	6.8	6.8	6.8	6.8	6.8	3.4
TOTAL		4.5	11.3	11.1	10.3	9.5	8.7	4.0
DSCR		1.4	1.4	2.5	4.1	5.4	5.8	12.3
AVERAGE DSCR					4.12
Project for Cultivation of  Aonla( With Drip Irrigation)
PAY BACK PERIOD					(Rs In Thousands)
PARTICULARS			Year I	Year II	Year III	Year IV
CAPITAL INVESTMENT			125.0
NET CASH ACCRUALS			1.7	11.9	24.0	39.0
CUMULATIVE INCOME			1.7	13.5	37.5	76.4
		PAYBACK PERIOD		6.63	YEARS
Project for Cultivation of  Aonla( With Drip Irrigation)
COST OF PRODUCTION & PROFITABILITY					( Rupees In thousands)
PARTICULARS			Year I	Year II	Year III	Year IV	Year V to XV
INCOME			28.0	40.0	54.0	70.0	80.0
Sales			28.0	40.0	54.0	70.0	80.0
COST			21.9	23.7	25.8	27.6	28.7
VARIABLE			-	-	-
FREIGHT			-	-	-
FIXED			21.9	23.7	25.8	27.6	28.7
MANURE/FERTILIZERS/CHEMICALS			8.0	8.0	9.0	9.0	9.0
DIRECT LABOUR COST			2.8	2.8	2.8	2.8	2.8
OTHER COST			3.6	3.6	3.6	3.6	3.6
HARVESTING & TRANSPORTATION COST			7.2	9.0	10.1	11.9	13.0
GENERAL EXPENSES			0.3	0.3	0.3	0.3	0.3
GROSS PROFIT			6.2	16.4	28.3	42.5	51.4
DEPRECIATION			5.8	5.8	5.8	5.8	5.8
INTEREST -TERM LOAN			4.5	4.5	4.3	3.5	2.7
PRE- OPERATIVE EXP.W/O			-	-	-	-	-
PROFIT BEFORE TAX			(4.1)	6.1	18.2	33.2	42.9
TAXES			-	-	-	-	-
PROFIT AFTER TAXES			(4.1)	6.1	18.2	33.2	42.9
DIVIDEND %			-	-	-	-	-
DIVIDEND AMOUNT			-	-	-	-	-
RETAINED PROFIT			(4.1)	6.1	18.2	33.2	42.9
NET CASH ACCRUAL			1.7	11.9	24.0	39.0	48.7