FORMAT FOR PROJECT REPORT PREPARATION - DAIRY FARM

Annexure I FORMAT FOR PROJECT REPORT PREPARATION - DAIRY FARM 1. GENERAL i) Nature and objectives of the proposed scheme ii) Details of proposed investments iii) Specification of the project area iv) Name of the financing bank branch v) Status of beneficiary: (individual/Partnership/Company/Corporation/Co-operative Society / Others) vi) Details of borrowers profile (a) Capability (b) Experience (c) Financial Soundness (d) Technical/Other special Qualifications (e) Technical/Managerial Staff and adequacy thereof 2. TECHNICAL ASPECTS : a) Location, Land and Land Development : i) Location details of the project ii) Total Area of land and its cost iii) Site map iv) Particulars of land development, fencing, gates, etc. b) Civil Structures : Detailed cost estimates along with measurements of various civil structures - Sheds - Store room - Milk room - Quarters, etc. c) Equipment/Plant and Machinery : i) Chaff cutter ii) Silo pit iii) Milking machine iv) Feed grinder and mixer v) Milking pails/milk cans vi) Biogas plant vii) Bulk coolers viii)Equipment for manufacture of products ix) Truck/van (price quotations for the above equipments) d) Housing : i) Type of housing ii) Area requirement - Adults - Heifers (1-3 years) - Calves (less than 1 year) e) Animals : i) Proposed species ii) Proposed breed iii) Source of purchase iv) Place of purchase v) Distance (km.) vi) Cost of animal (Rs.) f) Production parameters : i) Order of lactation ii) Milk yield (ltrs. per day) iii) Lactation days iv) Dry days v) Conception rate vi) Mortality(%) - Adults - Young stock g) Herd projection (with all assumptions) : h) Feeding : i) Source of fodder and feed - Green fodder - Dry fodder - Concentrates ii) Fodder crop rotations - Kharif - Rabi - Summer iii) Fodder cultivation expenses iv) Requirement and costs : Quantity required (kg./day) Cost(Rs. / Kg) Lactation Dry Period Young Stock Green Fodder Dry Fodder Concentrates i) Breeding Facilities : i) Source : ii) Location : iii) Distance (km.) : iv) Availability of semen : v) Availability of staff : vi) Expenditure per animal/year j) Veterinary Aid : i) Source ii) Location iii) Distance (km.) iv) Availability of labour and other staff v) Types of facilities available vi) If own arrangements are made - a) Employed a veterinary doctor/stockman/consultant b) Periodicity of visit c) Amount paid/visit (Rs.) vii)Expenditure per animal per year (Rs.) k) Electricity : i) Source ii) Approval from SEB iii) Connected load iv) Problems of power failure v) Arrangements for generator l) Water : i) Source ii) Quality of water iii) Availability of sufficient quantity for drinking, cleaning and fodder production iv) If investment has to be made, type of structure, design and cost m) Marketing of milk : i) Source of sales ii) Place of disposal iii) Distance (km.) iv) Price realised - (Rs. per liter of milk) v) Basis of payment vi) Periodicity of payment n) Marketing of other products : i) Animal - age - place of sale - price expected ii) Manure - Qty./animal Price/unit (Rs.) iii) Empty gunny bags - Number - Cost/bag (Rs.) o) Beneficiary's experience : p) Comments on technical feasibility : q) Government restrictions, if any : 3. FINANCIAL ASPECTS : i) Project Cost Sr. No. Item Physical Unit and Specification Cost  (Rs.) Capital Costs Total Capital Costs(A) Recurring Costs Total Recurring Costs (B) Total Project Cost (A+B) ii) Down payment/margin/subsidy (Indicate source & extent of subsidy): iii) Financial viability (comment on the cash flow projection on a farm model/unit and enclose the same.) Particulars : a) Internal Rate of Return (IRR) : b) Benefit Cost Ratio (BCR) : c) Net Present Worth (NPW) : iv) Financial position of the borrowers (to be furnished in case of corporate bodies/partnership firms) a) Profitability Ratio : i) GP Ratio ii) NP Ratio b) Debt Equity Ratio : c) Whether Income Tax & other tax obligations are paid upto date : d) Whether audit is upto date (enclose copies of audited financial statements for the last three years) v) Lending Terms : i) Rate of Interest : ii) Grace Period : iii) Repayment Period : iv) Nature of Security : v) Availability of Government guarantee wherever necessary : 4. INFRASTRUCTURAL FACILITIES : a) Availability of technical staff with bank/implementing authority for monitoring b) Details of - i) technical guidance ii) training facilities iii) Govt. support /extension support c) Tie-up arrangements with marketing agencies for loan recovery d) Insurance - - Type of policy - Periodicity - Rate of premium e) Whether any subsidy is available, if so amount per unit f) Arrangements for supply of green fodder and cattle feed Model Unit Cost and Economics of a 10 Buffalo Unit A. Project Cost Rs. Cost of milch animals including transportation cost : 330000 Cost of construction of shed for adult animals : 60000 Cost of construction of shed for calves : 20000 Cost of chaff cutter : 50000 Cost of equipment : 10000 Capital cost : 470000 Cost of concentrate feed for first batch for first month : 4800 Cost of fodder cultivation in 2 acres : 9000 Insurance of first batch of milch animals : 16000 Recurring cost : 29800 Total cost : 499800 or say : 500000 Margin (15%) : 75000 Bank Loan : 425000 B. Techno economic parameters Type of Animal : Graded Murrah Buffalo No. of Animals : 10 Cost of Animal (Rs./animal) : 32000 Transportation Cost/Animal : 1000 Average Milk Yield (litre/day) : 8 Floor space (sqft) per adult animal : 60 Floor space (sqft) per calf : 20 Cost of construction per sqft (Rs.) : 100 Cost of chaff cutter (power operated) (Rs.) : 50000 Cost of equipment per animal (Rs.) : 1000 Cost of fodder cultivation (Rs./acre/season) : 4500 Insurance premium (% per annum) : 5 Veterinary aid/animal/ year (Rs.) : 250 Cost of concentrate feed (Rs./kg) : 8 Cost of dry fodder (Rs./kg) : 1.50 No. of labourers : 1 Salary of labourer per month (Rs.) : 3000 Cost of electricity and water/animal/year (Rs.) : 150 Margin (%) : 15 Rate of interest (%) : 12 Repayment period (years) : 7 Selling price of milk/litre (Rs./kg) : 16.50 Sale price of gunny bags (Rs. per bag) : 10 Lactation days : 270 Dry days : 150 Freshly calved animals in 1st or 2nd lactation are purchased in two batches of five animals each at an interval of 5 to 6 months. Cost of rearing calves not considered as it will be nullified by their sale value or retention value. Fodder cultivation considered in two acres and working capital for one crop / season considered. Two crops considered per year. Manure utilised for fodder cultivation. Feeding Schedule Per Day Lactation Dry Price (Rs.) Qty. (kg) Cost Per Day  (Rs.) Qty. (kg) Cost Per Day (Rs.) Concentrate Feed 8.00 4 32.00 1 8.00 Green Fodder Home grown 25 0.00 20 0.00 Dry Fodder 1.50 4 6.00 5 7.50 Total 38.00 15.50 Lactation Chart Years 1 2 3 4 5 6 7 Lactation Days 2100 2425 2425 2425 2200 2425 2425 Dry Days 625 1225 1225 1425 1450 1225 1075 Gunny Bags available for sale 171 208 208 196 195 200 195 C.  Economics Particulars Years 1 2 3 4 5 6 7 Sale of Milk 277200 320100 320100 293700 290400 320100 320100 Sale of Gunny bags 1710 2080 2080 1960 1950 2000 1950 Total 278910 322180 322180 295660 292350 322100 322050 Cost of feeding during lactation 79800 92150 92150 84550 83600 92150 92150 Cost of feeding during dry period 9690 18990 18990 22090 22480 18990 16660 Cost of fodder cultivation 18000 18000 18000 18000 18000 18000 18000 Veterinary aid and breeding charges 2500 2500 2500 2500 2500 2500 2500 Labour charges 36000 36000 36000 36000 36000 36000 36000 Electricity and misc. charges 750 1500 1500 1500 1500 1500 1500 Insurance charges 16000 16000 16000 16000 16000 16000 16000 Total 162740 185140 185140 180640 180080 185140 182810 Surplus 145970 137040 137040 115020 112270 136960 139240 D. Calculation of BCR and IRR 1 2 3 4 5 6 7 Capital Costs 470000 Recurring Cost 162740 185140 185140 180640 180080 185140 182810 Total Costs 632740 185140 185140 180640 180080 185140 182810 Benefit 278910 322180 322180 295660 292350 322100 322050 Net Benefit -353830 137040 137040 115020 112270 136960 139240 PW Costs @ 15% 1153513 PW Benefits @ 15% 1272701 NPW 119187.8 B.C. Ratio 1.10 : 1 I.R.R. (%) 28.66 E. Repayment schedule Year Loan Outstanding Gross Surplus Interest Principal Total Repayment Surplus 1 425000 145970 51000 51200 102200 43770 2 373800 137040 44856 51044 95900 41140 3 322756 137040 38731 57169 95900 41140 4 265587 115020 31870 48630 80500 34520 5 216957 112270 26035 52565 78600 33670 6 164392 136960 19727 76173 95900 41060 7 88219 139240 10586 88219 98805 40435