Dairy Farm Project Report (FOR 100 CROSSBREED HF COW - Including Agricultural Land) (Project Report is Prepared in Indian Currency)
A. Overview Dairy Unit Size Breed State Project Cost Bank Loan Margin Money Repayment Period Interest Rate Herd Planning Adult Cow Death Loss
Heifers Death Loss (Below 1 Year) Heifers Death Loss (1-2 Year) Female Heifer Percentage Female Heifer Infertility Rate
Total Non-Productive cow Rate Per Year (3rd year onwards) Value of Sold Cows (2/3 of original cost less transportation)
Category of Animals Newly Purchased Cows Reared Cows Old Cows Cows Sold Total Cows Pregnant Heifers Heifers 1-2 Years Heifers Below 1 Year Total Herd Strength Total Adult Units
B. TECHNO-ECONOMICAL PARAMETERS Livestock Details
Cost of Each Livestock including Transportation Average Daily Milk Yeild
Selling Price of Milk
Total Lactation Period Per Year Total Dry Period Per Year
Land & Shed Details
Irrigated Land Required for Fodder Production (Acre) Rent of Land for Fodder Cultivation
Shed Area Required Per Livestock Shed Area Required Per Heifers & Calfs Shed Area Required for Fodder Storage
Construction Cost of Storage, Heifers & Calfs Shed Cost of Construction of Shed with Flooring
Office, Storage & Staff Area Details Office Area Required
Staff Quarters Required
Tools & Machines Storage Area Required Construction Cost of Office and Staff Area
Fodder Details
Cost of Purchase of Green Fodder Cost of Purchase of Dry Fodder Cost of Concentrated Feed Cost of Mineral Mixture Green Fodder Cultivation Cost Veterinary & Insurance Details Cost of Veterinary Per Animal Per Year % Rate of Livestock Insurance Premium
Labour & Miscllaneous Number of Supervisor/Manager Number of Skilled Labour Required Number of Unskilled Labour Required Annual Wages of Supervisor/Manager Annual Wages Per Skilled Labour Annual Wages Per Un-Skilled Labour
Number of Empty Gunny Bags Per Animal Per Year Sale Price of Empty Gunny Bags
Cost of Manure Per Animal Per Year
Cost of Electricity/Diesel Per Animal Per Year Miscellaneous Expenses Per Animal Per Year General Equipment Cost Per Animal
Macinery,Tools, Electricity Connection & Land Purchase Milking Equipment 4 Cluster Can
1 Tractor
1 Trailor/Trolly/Attachements 1 Loader for Tractor
1 Green Fodder Chaff Cutter with Motor (10HP) Feed Grinder with Motor
Mist Cooling System
Semen Container with Accessories Milk Cans 40 Ltr 30 Nos
Generator 15 KVA Borewell With Motor
Electricity Connection Charges Purchase of Agricultural Land
C. LACTATION CHART
Total Days
D. FEED & FODDER CONSUMPTION FOR ADULT COWS
Green Fodder (cultivated in rented fields) Dry Fooder
Formula Feed (Concentrate)
FOR HEIFERS
Pregnant Heifers (2 - 3 Year) Heifers Between 1 - 2 Year Heifers Less Than 1 Year
Pregnant Heifers (2 - 3 Year) Heifers Between 1 - 2 Year Heifers Less Than 1 Year
Pregnant Heifers (2 - 3 Year) Heifers Between 1 - 2 Year Heifers Less Than 1 Year
Total Cost
E. INVESTMENT COST Cost of Animals
Milking Animals Shed & Storage Area Construction Cost Heifers and Calfs Shed Area Construction Cost
Storage Area Construction Cost General Equipments Cost Miscellaneous Expenses
Macinery,Tools, Electricity and land Cost Office & Staff Quarters Construction Cost Total
F. CASH FLOW ANALYSIS 1. COSTS
a) Capital Cost b) Recurring Costs
Feeding During Milking Period Feeding During Dry Period Feeding Expenses on Heifers Veterinary Aid
Cost of electricity and water Insurance
Labour wages
Rent of Land for Fodder Cultivation Fodder Cultivation Cost
2. BENEFITS/INCOME Sale of Milk
Sale of Gunny Bags Sale of Manure Sale of Old Cows
Depriciated Value of Building
Depriciated Value of Macinery & Equipments Closing Stock Value
Total
G. REPAYMENT SCHEDULE Income
Expenses Gross Surplus
Equated Anuual Installment Net Surplus Before Tax
Dairy Farm Project Report (FOR 100 CROSSBREED HF COW - Including Agricultural Land) A. Overview 100 Crossbreed HF Gujarat 16,129,688 Rs. 13,710,235 85% 2,419,453 Rs. 5 Year 13.5% Percentage 5% 10% 5% 50% 5% 25% 36,000
Year 1 Year 2 Year 3 Year 4 Year 5
100 5 5 0 0 - 0 0 41 41 - 95 95 95 119 - 0 0 11 11 100 100 100 125 149 - 0 41 41 41 - 43 43 43 53 45 45 45 56 67 145 188 228 265 309 116 137 161 190 223 B. TECHNO-ECONOMICAL PARAMETERS 60,000 Rs
20 Litre Per Day 26 Rs Per Litre 300 Days 65 Days
Year 1 Year 2 Year 3 Year 4 Year 5
23 27 32 38 45 15,000 Rs / Acre / Year 65 SqFt For 100 Cows 30 SqFt For 50 Heifers 1,000 SqFt For 100 Cows 150 Rs Per SqFt 250 Rs Per SqFt
400 SqFt 1,000 SqFt 400 SqFt 800 Rs Per SqFt - Rs Per KG 2 Rs Per KG 13 Rs Per KG 50 Rs Per KG 5,000 Rs per acre 1,500 Rs 4%
Year 1 Year 2 Year 3 Year 4 Year 5
2 2 2 2 2 5 5 6 8 9 6 7 8 10 11 144,000 Rs 72,000 Rs 36,000 Rs 20 5 Rs 1,200 Rs 1,000 Rs 500 Rs 1,000 Rs 100,000 500,000 200,000 100,000 50,000 Rs 100,000 120,000 Rs 90,000 Rs 60,000 Rs 200,000 Rs 500,000 Rs 150,000 4,500,000 Rs
Year 1 Year 2 Year 3
In Milk In Dry In Milk In Dry In Milk
30,000 6,500 30,000 6,500 30,000
Daily Requirements (Kg) Year 1 Year 2
In Milk In Dry In Milk In Dry In Milk
40 35 - ###
5 6 300,000 78,000 300,000 8 2 3,120,000 169,000 3,120,000 Total Cost 3,420,000 247,000 3,420,000
Green (Kg) Year 1 Year 2 Year 3 Year 4
25 0 0 0 0
15 0 0 0 0
5 0 0 0 0
Dry (Kg) Year 1 Year 2 Year 3 Year 4
3 0 0 88941 88941
2 0 62415 62415 62415
1 32850 32850 32850 41038
C Feed (Kg) Year 1 Year 2 Year 3 Year 4
2 0 0 385413 385413
2 0 405698 405698 405698
1 213525 213525 213525 266746
246375 714488 1188842 1250251
Year 1 Year 2 Year 3 Year 4 Year 5
6,000,000 300,000 ### 1,625,000 86,813 150,000 100,000 57,875 6,670,000 1,440,000 16,129,688 300,000 300,000 - -
Year 1 Year 2 Year 3 Year 4 Year 5
16,129,688 300,000 ### 0 0 3,420,000 ### 3,420,000 4,272,435 5,082,248 247,000 ### 247,000 308,565 367,051 246,375 714,488 1,188,842 1,250,250 1,425,266 173,625 205,688 242,239 285,515 334,619 115,750 137,125 161,493 190,343 223,079 240,000 ### 240,000 299,820 356,649 829,710 929,745 1,043,785 1,178,806 1,332,010 347,250 411,375 484,478 571,030 669,237 115,750 137,125 161,493 190,343 223,079 21,865,148 6,442,546 7,189,330 8,547,107 10,013,238
Year 1 Year 2 Year 3 Year 4 Year 5 15,600,000 ### 15,600,000 19,488,300 23,182,185 11,575 13,713 16,149 19,034 22,308 138,900 164,550 193,791 228,412 267,695 384,750 384,750 2,363,859 3,385,000 3,000,000 15,750,475 15,778,263 15,809,940 20,120,496 32,605,797
Year 1 Year 2 Year 3 Year 4 Year 5
15,750,475 15,778,263 15,809,940 20,120,496 23,472,188 5,735,460 6,442,545 7,189,328 8,547,107 10,013,238 10,015,015 9,335,718 8,620,612 11,573,389 13,458,950 3,828,158 ### 3,828,158 ### 3,828,158 6,186,857 5,507,560 4,792,454 7,745,231 9,630,792
Year 3 Year 4 Year 5
In Dry In Milk In Dry In Milk In Dry
6,500 37,478 8,120 44,581 9,659 749,550 891,623
Year 2 Year 3 Year 4 Year 5
In Dry In Milk In Dry In Milk In Dry In Milk
78,000 300,000 78,000 374,775 97,442 445,811 169,000 3,120,000 169,000 3,897,660 211,123 4,636,437 247,000 3,420,000 247,000 4,272,435 308,565 5,082,248 Year 5 0 0 0 Year 5 88941 77972 48816 Year 5 385413 506818 317306 1425266
75% rate 50% rate 50% rate
Year 5 In Dry
115,911 251,140 367,051