Please fill all required fields
    Dairy Project Model (Cattle) - Financial Calculator
     
     
    A. OVERVIEW

    How To Use DairyFarmGuide.com dairy financial calculator:

    • Its a live calculator based on semi-automatic cattle dairy
    • Adjust ORANGE color values according to your area and requirement
    • When you change any value, just click outside anywhere to do the re-calculation
    • You may also click RESET at the end of page to reset values
    • We have tried our level best to calculate all values but small changes are always possible
    • Send your suggesstions at: contact@dairyfarmguide.com
    • Go back to Home Page
    Dairy Unit Size  
    Breed Crossbreed HF  
    State North India  
    Project Cost Rs
    Bank Loan
    Margin Money Rs
    Repayment Period Year
    Interest Rate  
       
    Herd Planning Percentage  
    Adult Cow Death Loss 5%  
    Heifers Death Loss (Below 1 Year) 10%  
    Heifers Death Loss (1-2 Year) 5%  
    Female Heifer Percentage 50%  
    Female Heifer Infertility Rate 5%  
    Total Culling Rate Per Year (3rd year onwards) 25%  
    Value of Sold Cows (2/3 of original cost less transportation)  
                 
    Category of Animals Year 1 Year 2 Year 3 Year 4 Year 5
    Newly Purchased Cows 5 5 0 0
    Reared Cows 0 0 0
    Old Cows 0
    Cows Sold 0 0 0
    Total Cows
    Pregnant Heifers 0 0
    Heifers 1-2 Years 0
    Heifers Below 1 Year
    Total Herd Strength
    Total Adult Units
               
    B. TECHNO-ECONOMICAL PARAMETERS    
    Livestock Details
    Cost of Each Livestock including Transportation Rs
    Average Daily Milk Yeild Litre Per Day
    Selling Price of Milk Rs Per Litre
    Total Lactation Period Per Year Days
    Total Dry Period Per Year Days
         
    Land & Shed Details
      Year 1 Year 2 Year 3 Year 4 Year 5  
    Irrigated Land Required for Fodder Production (Acre)
    Rent of Land for Fodder Cultivation 15,000 Rs / Acre / Year      
    Shed Area Required Per Livestock SqFt For Cows
    Shed Area Required Per Heifers & Calfs SqFt For Heifers
    Shed Area Required for Fodder Storage SqFt For Cows
    Construction Cost of Storage, Heifers & Calfs Shed Rs Per SqFt  
    Cost of Construction of Shed with Flooring Rs Per SqFt
       
    Office, Storage & Staff Area Details
    Office Area Required SqFt
    Staff Quarters Required SqFt
    Tools & Machines Storage Area Required SqFt
    Construction Cost of Office and Staff Area Rs Per SqFt
       
    Fodder Details
    Cost of Purchase of Green Fodder Rs Per KG only use in case of green fodder is being purchased at market rate (set land rent & fodder production cost to 0)  
    Cost of Purchase of Dry Fodder Rs Per KG  
    Cost of Concentrated Feed Rs Per KG
    Cost of Mineral Mixture Rs Per KG
    Green Fodder Cultivation Cost Rs per acre
       
    Veterinary & Insurance Details
    Cost of Veterinary Per Animal Per Year Rs
    % Rate of Livestock Insurance Premium  
       
    Labour & Miscllaneous
      Year 1 Year 2 Year 3 Year 4 Year 5  
    Number of Supervisor/Manager
    Number of Skilled Labour Required
    Number of Unskilled Labour Required
    Annual Wages of Supervisor/Manager 144,000 Rs
    Annual Wages Per Skilled Labour Rs
    Annual Wages Per Un-Skilled Labour Rs
    Number of Empty Gunny Bags Per Animal Per Year  
    Sale Price of Empty Gunny Bags Rs
    Cost of Manure Per Animal Per Year Rs
    Cost of Electricity/Diesel Per Animal Per Year Rs
    Miscellaneous Expenses Per Animal Per Year Rs
    General Equipment Cost Per Animal Rs
       
    Macinery & Tools
    Milking Equipment 4 Cluster Can Rs
    1 Tractor Rs
    1 Trailor/Trolly/Attachements Rs
    1 Loader for Tractor Rs
    1 Green Fodder Chaff Cutter with Motor (10HP) Rs
    Feed Grinder with Motor Rs
    Mist Cooling System Rs
    Semen Container with Accessories Rs
    Milk Cans 40 Ltr 10 Nos Rs
    Generator 7.5 KVA Rs
    Borewell With Motor Rs
       
    C. LACTATION CHART                      
      Year 2 Year 3 Year 4 Year 5
      In Milk In Dry In Milk In Dry In Milk In Dry In Milk In Dry
    Total Days
    Total Milk Produced (Ltrs)        
                     
    D. FEED & FODDER CONSUMPTION                        
    FOR ADULT COWS Daily Requirements (Kg) Year 2 Year 3 Year 4 Year 5
      In Milk In Dry In Milk In Dry In Milk In Dry In Milk In Dry
    Green Fodder (cultivated in rented fields) 40 35
    Dry Fooder 5 6
    Formula Feed (Concentrate) 8 2
      Total Cost
                 
    FOR HEIFERS Green (Kg) Year 2 Year 3 Year 4 Year 5
    Pregnant Heifers (2 - 3 Year) 25
    Heifers Between 1 - 2 Year 15
    Heifers Less Than 1 Year 5
                 
      Dry (Kg) Year 2 Year 3 Year 4 Year 5
    Pregnant Heifers (2 - 3 Year) 3
    Heifers Between 1 - 2 Year 2
    Heifers Less Than 1 Year 1
                 
      C Feed (Kg) Year 2 Year 3 Year 4 Year 5
    Pregnant Heifers (2 - 3 Year) 2
    Heifers Between 1 - 2 Year 2
    Heifers Less Than 1 Year 1
                 
    Total Cost
               
    E. INVESTMENT COST Year 1 Year 2 Year 3 Year 4 Year 5
    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 and Tools Cost  
    Office & Staff Quarters Construction Cost  
    Total
         
    F. CASH FLOW ANALYSIS          
    1. COSTS Year 1 Year 2 Year 3 Year 4 Year 5
    a) Capital Cost refinance required for 2nd year onwards on capital invetment (not taken in account)
    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
    Total
               
    2. BENEFITS/INCOME Year 1 Year 2 Year 3 Year 4 Year 5
    Sale of Milk
    Sale of Gunny Bags
    Sale of Manure
    Sale of Old Cows
    Depriciated Value of Building rate  
    Depriciated Value of Macinery & Equipments rate
    Closing Stock Value rate
    Total  
               
    G. REPAYMENT SCHEDULE          
      Year 1 Year 2 Year 3 Year 4 Year 5
    Income
    Expenses
    Gross Surplus
    Equated Anuual Installment
    Net Surplus Before Tax
               
     

    Register

    Please provide your Name and Email Address in order to use this dairy financial model.

    All form fields are required.

    Your Name:
    Email Address:
     

    If you are already registered then just input your name and email id again to continue using. We will never rent or sell your details in any manner.