PROJECT REPORT OF A LARGE-SCALE CROSSBRED COW DAIRY FARM PREPARED BY
Dr. Vivek M. Patil Assistant Professor Department of Livestock Production Management, Veterinary College, Bidar Karnataka Veterinary, Animal & Fisheries Sciences University http://sites.google.com/site/viveklpm/
A
B
Overview Name of the Proprietor Address Unit size Project Cost (Rs.) Bank Loan (Rs.) Margin Money (Rs.) Repayment period (years) Loan rate of interest (%)
vcbcvb sdf 100 12,160,000 11,552,000 608,000 5 12
Techno-Economic Parameters Cost of each cow (Rs.) Average daily milk yield of each cow (lit) Sale price of milk (Rs./lit) Irrigated land required for fodder production (acres) Cost of construction of cow sheds (Rs/sq.ft.) Cost of construction of young stock sheds (Rs/sq.ft.) Cost of construction of store rooms (Rs/sq.ft.) Cost of production/purchase of green fodder (Rs/kg) Cost of production/purchase of dry fodder (Rs/kg) Cost of concentrate feed (Rs/kg) Cost of veterinary aid per animal per year (Rs.) Cost of electricity and water per animal per year (Rs.) Rate of livestock insurance premium (%) Annual wages of each farm labourer (Rs.) (Rs.) Sale price of empty livestock feed gunny bags (Rs.)
60,000 10 60 20.00 400 250 200 0.40 3.00 14.00 1000 1000 4 5,000 8.00
Expenditure on rearing of calves will be offset by the income realized from their sale. Heifers will be retained on the farm as replacement stock. Farmyard manure shall be used for fertilizing the fodder plots.
C
Lactation Chart (cows are purchased in 2 batches at an interval of 5-6 months) Year 1 No. of animals First Batch 50 Second Batch 50
in milk
Total (days)
D
15000 9000 24000
Year 2 dry 3250 0 3250
in milk 15000 15000 30000
Year 3 dry 3250 3250 6500
Year 4 dry
15000 15000 30000
3250 3250 6500
in milk 15000 15000 30000
Year 5 dry 3250 3250 6500
in milk 15000 15000 30000
dry 3250 3250 6500
Feed and Fodder Daily Year 1 Year 2 Requirement Rate/kg in milk dry in milk dry in milk dry Green fodder 0.40 30.00 25.00 288,000 32,500 360,000 65,000 Dry fodder 3.00 4.00 7.00 288,000 68,250 360,000 136,500 Concentrates 14.00 4.33 1.00 1,456,000 45,500 1,820,000 91,000 Total (Rs) 2,032,000 146,250 2,540,000 292,500
E
in milk
Year 3 in milk 360,000 360,000 1,820,000 2,540,000
Year 4 dry 65,000 136,500 91,000 292,500
in milk 360,000 360,000 1,820,000 2,540,000
Investment Cost
Cost of animals Construction of cow shed Construction of young stock sheds Construction of stores/misc rooms Cost of milking equipment Cost of liquid milk storage equipment Cost of fodder cutting equipment Cost of standby power supply Cost of misc. equipment Initial fodder cultivation cost Misc. expenses
Specificatio ns Phy. units 100 sq. ft. 8000 sq. ft. 4000 sq. ft. 1000 1 set 1 set 1 set 1 set 100 1 set acres 20 100
Unit cost 60,000 400 250 200 1 ,0 ,0 00 00 ,0 ,0 00 00 250,000 200,000 150,000 500 3,000 500 Tota Totall
Total 6,000,000 3,200,000 1,000,000 200,000 1 ,0 ,0 00 00 ,0 ,0 00 00 250,000 200,000 150,000 50,000 60,000 50,000 12,1 12,160 60,0 ,000 00
Year 5 dry 65,000 136,500 91,000 292,500
in milk 360,000 360,000 1,820,000 2,540,000
dry 65,000 136,500 91,000 292,500
Cash Flow Analysis
F
I 1 Costs a) Capital cost b) Recurring cost Feeding during lactation period Feeding during dry period Veterinary aid Cost of electricity & water Insurance Labour wages
G
DF @ 10% Discounted Costs @ 10% Discounted Benefits @ 10% NPW @ 10% BCR @ 10% DF @ 50% Net Benefits Discounted Net Benefits @ 50% IRR
Years III
IV
V
12,160,000
Total
2,032,000 146,250 100,000 100,000 240,000 65,000 14,843,250
2,540,000 292,500 100,000 100,000 240,000 65,000 3,337,500
2,540,000 292,500 100,000 100,000 240,000 65,000 3,337,500
2,540,000 292,500 100,000 100,000 240,000 65,000 3,337,500
2,540,000 292,500 100,000 100,000 240,000 65,000 3,337,500
Total
14,400,000 17,160 0 0 0 14,417,160
18,000,000 21,840 0 0 0 18,021,840
18,000,000 21,840 0 0 0 18,021,840
18,000,000 21,840 0 0 0 18,021,840
18,000,000 21,840 3,300,000 825,000 3,000,000 25,146,840
0.91 13,493,864 13,106,509 46,352,512 3.01 0.67 - 42 6, 09 0 -284,060 3446%
0.83 2,758,264 14,894,083
0.75 2,507,513 13,540,075
0.68 2,279,557 12,309,159
0.62 2,072,325 23,111,524 15,614,209 69,464,035
0.44 1 4, 68 4, 34 0 6,526,373
0.30 1 4, 68 4, 34 0 4,350,916
0.20 1 4, 68 4, 34 0 2,900,610
0.13 2 1, 80 9, 34 0 2,872,012 16,365,851
Expenses
Gross Surplus
2 Benefits Sale of milk Sale of gunny bags Depreciated value of buildings Depreciated value of equipments Closing stock value
3 4 5 6 7 8 9 10 11
II
Repayment Schedule Year I II III IV V Capital Recovery Factor
Income 14,417,160 18,021,840 18,021,840 18,021,840 18,021,840
2,683,250 3,337,500 3,337,500 3,337,500 3,337,500
11,733,910 14,684,340 14,684,340 14,684,340 14,684,340
Equated Annual Installment
Net Surplus
3,142,144 3,142,144 3,142,144 3,142,144 3,142,144
0.27
Date : 7/23/2016 10:27:41 Note : Data in highlighted cells are outside the parameters of this sheet. Please modify and re-enter the same in the Form. Disclaimer : The data provided in the Project Report is for reference purposes and uses standard assumptions. For customized Project Reports please contact the author at
[email protected] or your nearest Veterinarian.
8,591,766 11,542,196 11,542,196 11,542,196 11,542,196