How to Prepare a DPR for Dairy Farming or Livestock Farming Business.

Starting a dairy or livestock farming business requires proper planning. Whether you are planning to purchase a few milch animals or establish a larger commercial livestock farm, a Detailed Project Report (DPR) helps convert the business idea into a practical and financially measurable project. Hence, we need to prepare a DPR for dairy farming business.

A well-prepared DPR for dairy farming explains the proposed activity, number and type of animals, production capacity, feed and fodder arrangements, project cost, expected income, operating expenses, profitability and loan repayment capacity. It is especially important when the project is being submitted to a bank or financial institution for finance.

This article explains how to prepare a DPR for dairy farming or livestock farming business in a simple and practical way.

What is a DPR for Dairy Farming?

A DPR, or Detailed Project Report, is a comprehensive document that explains how a proposed dairy or livestock farming business will be established and operated.

The report generally covers the promoter’s background, farm location, land and infrastructure, livestock details, production assumptions, feed and fodder requirements, veterinary arrangements, marketing, project cost, means of finance, income and expenditure, projected financial statements and repayment capacity.

The main purpose of a DPR is to determine whether the proposed project is technically feasible and financially viable.

A good DPR should therefore be based on realistic assumptions rather than simply showing high production and high profits.

Why is a DPR Important for Dairy Farming?

A dairy farming DPR is useful for both the farmer and the lending institution. For the farmer, it provides a clear estimate of how much money will be required and what level of income the business may generate.

For a bank or financial institution, the DPR helps assess whether the proposed investment is reasonable, whether the farmer can operate the activity successfully and whether the expected cash flow is sufficient to repay the loan.

The DPR should answer some basic questions:

  • What type of livestock will be maintained?
  • How many animals will be purchased?
  • What will the animals cost?
  • Is a suitable shed already available?
  • How much milk can be produced?
  • How will the milk be sold?
  • What will be the feed and other operating costs?
  • How much profit can the farm generate?
  • How much loan is required?
  • Can the project repay the proposed loan?

1. Start With the Basic Project Details

The first part of the DPR should provide a brief description of the proposed dairy or livestock farming activity.

It should mention the location of the farm, type of livestock, number of animals, purpose of the activity and whether the farm is new or an expansion of an existing business.

For example:

The proposed project involves establishing a dairy farming unit for production and sale of milk. The farm will maintain healthy milch animals and follow proper feeding, veterinary care, vaccination and hygienic milk-handling practices.

The description should be short but sufficient to explain what the borrower intends to establish.

2. Prepare the Promoter Profile

The next section should provide information about the person who will operate the farm.

Important details include:

  • Farming experience
  • Dairy or livestock farming experience
  • Existing agricultural activities
  • Existing livestock
  • Availability of land
  • Experience in animal management
  • Other sources of income
  • Existing loans and liabilities

Experience in livestock management is important because dairy farming requires regular feeding, cleaning, milking, breeding and health management.

If the applicant does not have previous experience, the DPR should explain how technical support and day-to-day management will be arranged.

3. Assess Land and Existing Infrastructure

Before calculating the project cost, check what facilities are already available with the farmer.

These may include:

  • Cattle shed
  • Animal resting area
  • Water facility
  • Electricity
  • Feed storage
  • Fodder storage
  • Drainage
  • Manure disposal facility
  • Milking area
  • Approach road

Does the DPR always need to include cattle shed cost?

No.

If the farmer already has a suitable cattle shed and it is adequate for the proposed number of animals, there may be no need to include the construction of a new shed in the project cost.

However, the DPR should clearly mention this.

For example:

Existing Infrastructure: A suitable cattle shed is already available with the farmer and is adequate for housing the proposed livestock. Therefore, no new cattle shed construction cost has been considered in the project cost.

On the other hand, if the farmer does not have a suitable shed, the estimated construction cost should be included in the project cost.

The same principle applies to other facilities. The DPR should reflect the actual additional investment required for the proposed project.

4. Decide the Number and Type of Animals

Dairy farming livestock selection for preparing a DPR
Selecting the right type and number of animals is an important step in preparing a dairy farming DPR.

The number and type of animals form the foundation of a dairy farming project.

The DPR should specify:

  • Type of animal
  • Breed
  • Number of animals
  • Average purchase price
  • Expected milk yield
  • Age
  • Lactation status
  • Source of procurement

For example, suppose a project proposes to purchase 5 milch buffaloes at an average cost of ₹1.20 lakh per animal.

The livestock investment would be:

5 × ₹1,20,000 = ₹6,00,000

The actual purchase price should be based on the quality, breed, age, lactation status and prevailing local market conditions.

5. Estimate Milk Production

After determining the number of animals and expected milk yield, the next step is to calculate annual milk production.

For a simple dairy project, the formula can be:

Annual Milk Production = Number of Animals × Average Milk Yield per Day × Milk Production Days

For DPR planning, 300 milk-production days per year can be used as an illustrative assumption to provide for the dry period and variation in the production cycle.

For example, if there are 5 animals and each produces an average of 11 litres per day:

5 × 11 × 300 = 16,500 litres per year

Therefore, the estimated annual milk production would be 16,500 litres.

The 300-day assumption is a planning example. Actual milk production days may vary depending on breed, calving cycle, animal health, management and other farm-specific factors.

This is why a DPR should avoid assuming that every animal will produce milk every day of the year.

6. Calculate Expected Milk Income

Once annual milk production has been estimated, calculate the expected sales.

The basic formula is:

Milk Income = Annual Milk Production × Selling Price per Litre

For example, if annual milk production is 16,500 litres and the assumed selling price is ₹40 per litre:

16,500 × ₹40 = ₹6,60,000

Therefore, estimated annual milk income would be ₹6.60 lakh.

If the farm plans to sell milk at different prices through different marketing channels, the calculation can be made separately for each channel.

7. Consider Other Sources of Income

Milk may not be the only source of income from a livestock farm.

Depending on the project, additional income may come from:

  • Sale of manure
  • Sale of calves
  • Sale of surplus animals
  • Sale of breeding animals
  • Sale of cream
  • Sale of ghee
  • Sale of curd
  • Sale of paneer
  • Other livestock products

However, these sources should be included only when they are actually relevant to the proposed activity.

The DPR should also avoid double counting. For example, milk used to manufacture ghee should not be counted once as milk sales and again as the entire ghee production unless the calculations properly account for the conversion.

8. Prepare the Feed and Fodder Plan

Feed and fodder are among the most important operating costs in dairy farming.

The DPR should explain how the animals will receive:

  • Green fodder
  • Dry fodder
  • Concentrate feed
  • Mineral mixture
  • Other supplements, where required

The requirement should be calculated based on the number and type of animals.

If the farmer has agricultural land, the DPR should also mention whether part of the land will be used for growing fodder.

A farm that produces a portion of its own fodder may have a different cost structure from a farm that purchases most of its feed from outside.

9. Calculate Labour Expenses

Labour requirements depend on the size of the farm.

For a small dairy unit, the farmer and family members may handle a significant portion of the work. A larger farm may require dedicated workers.

The DPR should consider expenses related to:

  • Feeding
  • Milking
  • Cleaning
  • Animal care
  • Fodder handling
  • Farm maintenance

The labour cost should be realistic and consistent with the size of the proposed farm.

10. Include Veterinary and Animal Health Expenses

Animal health is essential for maintaining production.

The DPR should make appropriate provision for:

  • Veterinary services
  • Medicines
  • Vaccination
  • Deworming
  • Breeding services
  • Routine health care
  • Insurance, where applicable

The report should also mention the availability of veterinary services near the farm.

A healthy animal is more likely to maintain good production, while disease or poor management can significantly affect the farm’s income.

11. Explain the Marketing Arrangement

A dairy project should have a clear plan for selling its milk.

Possible marketing channels include:

  • Local households
  • Milk collection centres
  • Dairy cooperatives
  • Private dairies
  • Hotels and restaurants
  • Local retailers
  • Direct consumers

The DPR should explain where the milk is expected to be sold and what price assumption has been used.

Instead of simply writing:

“There is good demand for milk.”

it is better to explain the actual proposed marketing arrangement.

For example:

The milk produced by the proposed dairy unit will be marketed through local consumers and available milk collection channels. The location of the farm provides access to the local market, supporting the proposed sales assumptions.

12. Calculate the Project Cost

Once the technical details are finalized, calculate the total project cost.

Depending on the project, the cost may include:

Livestock

Cost of purchasing the proposed animals.

Cattle Shed

Include this only if a new shed is required.

Equipment

This may include:

  • Milking equipment
  • Chaff cutter
  • Milk cans
  • Feed equipment
  • Water equipment
  • Other necessary machinery

Fodder Development

Include the cost of establishing fodder cultivation where applicable.

Other Infrastructure

Water, electricity, drainage and other facilities may be included if they require new investment.

Working Capital

Provision may be required for feed, medicines, labour and other operating expenses depending on the financing structure.

The important principle is that the project cost should reflect what is actually required to establish and operate the proposed unit.

13. Prepare the Means of Finance

After calculating the project cost, show how the investment will be financed.

For example:

Source of FinanceAmount
Farmer’s contribution₹60,000
Eligible assistance/subsidy, if applicable₹1,50,000
Bank loan₹3,90,000
Total₹6,00,000

The actual margin, loan amount and any subsidy or assistance should be based on the applicable lending terms and eligibility conditions.

A DPR should not assume that a subsidy will automatically be available.

14. Prepare the Sales Projection

The next step is to prepare a year-wise sales projection.

Suppose the first year’s milk sales are estimated at ₹6.60 lakh.

Future sales can be projected based on reasonable assumptions regarding:

  • Milk price
  • Production
  • Additional products
  • Changes in the number of productive animals

Any annual increase in selling price should be realistic.

It is better to use a conservative assumption than to increase the selling price aggressively just to improve projected profitability.

15. Calculate Operating Expenses

The DPR should calculate the expected annual expenses of running the farm.

These may include:

ExpenseBasis of Calculation
FeedQuantity × rate
Green fodderQuantity × rate
Dry fodderQuantity × rate
LabourMonthly cost × 12
Veterinary expensesEstimated annual cost
MedicinesEstimated annual cost
ElectricityEstimated consumption
WaterEstimated cost
InsuranceApplicable premium
RepairsEstimated annual cost
TransportationEstimated requirement
MiscellaneousReasonable estimate

The assumptions should be clearly explained wherever possible.

16. Prepare the Projected Profit and Loss Account

After calculating income and expenses, prepare the projected Profit and Loss Account.

A simplified format is:

ParticularYear 1Year 2Year 3
Milk and other income
Total Income
Less: Feed & fodder
Less: Labour
Less: Veterinary expenses
Less: Other operating expenses
Gross/Operating Profit
Less: Interest
Less: Depreciation
Profit Before Tax
Tax, if applicable
Profit After Tax

The exact presentation may vary depending on the accounting and appraisal format being followed.

17. Include Depreciation

Depreciation should be considered for applicable fixed assets.

The DPR should maintain consistency between:

  • Asset cost
  • Depreciation
  • Closing asset value
  • Projected balance sheet
  • Profit calculation

For example, if equipment is purchased for the project, depreciation on that equipment should be considered according to the applicable accounting methodology.

The treatment of livestock as an asset and the appropriate depreciation/accounting treatment should follow the applicable accounting and lending methodology.

18. Prepare the Projected Balance Sheet

A detailed DPR should ideally include a projected balance sheet.

Liabilities may include:

  • Capital
  • Term loan
  • Current liabilities
  • Creditors
  • Other borrowings

Assets may include:

  • Fixed assets
  • Inventory
  • Receivables
  • Cash and bank balance
  • Other current assets

The balance sheet should remain internally consistent with the Profit and Loss Account, loan repayment and other financial projections.

19. Prepare the Cash Flow

Profit does not always mean that the borrower will have sufficient cash to repay the loan.

Therefore, the DPR should also examine the project’s cash generation.

A simplified calculation is:

Profit After Tax + Depreciation + Other Non-Cash Expenses = Funds Available for Debt Servicing

This amount can then be compared with the annual loan repayment and interest obligation.

Cash flow analysis is particularly important in dairy farming because expenses such as feed and labour are incurred regularly throughout the year.

20. Prepare the Loan Repayment Schedule

If bank finance is proposed, the DPR should show how the loan will be repaid.

The repayment schedule may include:

  • Opening loan balance
  • Interest
  • Principal repayment
  • Total installment
  • Closing loan balance

For example:

ParticularYear 1Year 2Year 3
Opening loan
Principal repayment
Interest
Total debt obligation
Closing loan balance

The repayment period and installment frequency should be aligned with the project’s expected cash flow and the lender’s applicable terms.

21. Calculate DSCR

DSCR stands for Debt Service Coverage Ratio.

It is one of the important indicators used to assess the repayment capacity of a project.

A simplified formula is:

DSCR = Funds Available for Debt Servicing ÷ Total Debt Obligation

Suppose:

  • Funds available for debt servicing = ₹4,00,000
  • Principal repayment + interest = ₹1,00,000

Then:

DSCR = ₹4,00,000 ÷ ₹1,00,000 = 4.00

A higher DSCR generally indicates stronger debt-servicing capacity, but the acceptable level should be assessed according to the applicable lending norms and appraisal methodology.

The DPR should calculate DSCR for each projected year and, where required, an average DSCR.

22. Include Financial Ratios

A detailed DPR may include additional financial ratios to assess the financial position of the project.

Important ratios include:

Current Ratio

Current Ratio = Current Assets ÷ Current Liabilities

It indicates the project’s ability to meet short-term obligations.

Debt-Equity Ratio

It compares borrowed funds with the owner’s funds.

Interest Coverage Ratio

It indicates the ability of the business to meet its interest obligations.

Net Profit Margin

Net Profit Margin = Net Profit ÷ Sales × 100

Return on Capital Employed

This measures the return generated on the capital employed in the business.

These ratios provide additional information about the project’s financial strength.

23. Prepare a Break-Even Analysis

Break-even analysis determines the level of business activity at which total income covers total costs.

For a dairy farm, the analysis can help answer questions such as:

  • How much milk must be sold to cover costs?
  • What happens if milk production falls?
  • How much can the selling price decline before the project becomes unviable?

Break-even analysis is particularly useful for understanding the margin of safety in the project.

24. Include Sensitivity Analysis

A strong DPR should consider what happens when important assumptions change.

For example:

Scenario 1: Milk price decreases by 10%

Recalculate income and profitability.

Scenario 2: Feed cost increases by 10%

Recalculate operating expenses and profit.

Scenario 3: Milk production decreases by 10%

Recalculate sales and repayment capacity.

Scenario 4: Both milk price decreases and feed cost increases

This provides a more realistic picture of the project’s financial strength.

The purpose of sensitivity analysis is not to make the project look better. It is to understand how much stress the project can withstand.

25. Include Risks and Their Mitigation

Every livestock project has operational risks.

Animal disease

Mitigation: Proper vaccination, veterinary care, hygiene and insurance where appropriate.

Increase in feed prices

Mitigation: Own fodder cultivation and multiple sources of feed procurement.

Lower-than-expected milk yield

Mitigation: Selection of healthy animals, proper nutrition and regular veterinary care.

Milk price fluctuation

Mitigation: Diversified marketing channels and a realistic selling-price assumption.

Animal mortality

Mitigation: Proper animal management, veterinary care and suitable insurance.

Labour shortage

Mitigation: Family labour or availability of trained replacement workers.

A good DPR should acknowledge these risks rather than assuming that the business will operate under perfect conditions.

Example of a Simple Dairy Farming Calculation

Let’s take a simple illustrative example.

Suppose a farmer proposes:

  • 5 milch animals
  • Average milk yield: 11 litres per day
  • Milk production days: 300
  • Average selling price: ₹40 per litre

Step 1: Annual Milk Production

5 × 11 × 300 = 16,500 litres

Step 2: Annual Milk Income

16,500 × ₹40 = ₹6,60,000

Therefore, estimated annual milk income is:

₹6.60 lakh

Now suppose the annual operating expenses are estimated at ₹4.00 lakh.

The operating surplus before interest and depreciation would be:

₹6.60 lakh − ₹4.00 lakh = ₹2.60 lakh

If the project has a bank loan, interest and principal repayment must then be considered to determine whether the available cash flow is sufficient for debt servicing.

This is the basic logic behind a bankable dairy farming DPR:

Animals → Production → Sales → Expenses → Surplus → Debt Servicing → DSCR

Documents Required for a Dairy Farming DPR

Depending on the project and lender, the following documents may be required:

  • Identity and address documents
  • Land ownership or lease documents
  • Details of existing livestock
  • Animal purchase quotations
  • Equipment quotations
  • Shed estimate, where required
  • Photographs of existing infrastructure
  • Bank statements
  • Existing loan details
  • Income-related documents, where applicable
  • Insurance details
  • Veterinary or technical documents, where required
  • Details of water availability
  • Relevant registrations or licences, where applicable

The exact requirements may differ depending on the lender and nature of the project.

Common Mistakes While Preparing a Dairy Farming DPR

Using unrealistic milk yield

The projected milk yield should be reasonable for the proposed breed and management conditions.

Assuming 365 milk-production days

A dairy animal has a production cycle and dry period. Using 300 production days as an illustrative planning assumption can provide a more conservative starting point, although the actual period should be based on the proposed animals and farm conditions.

Ignoring existing infrastructure

If a suitable cattle shed is already available, there may be no need to include a new shed construction cost.

Excluding required infrastructure

If the farmer does not have an adequate shed, water supply or other essential facilities, the required investment should be included.

Underestimating feed costs

Feed and fodder can represent a major portion of operating expenditure. The requirement should be calculated carefully.

Showing income without a marketing plan

The DPR should explain how the milk or livestock products will actually be sold.

Ignoring loan repayment

A project may show a profit but still have insufficient cash flow for debt servicing. Loan repayment and DSCR should therefore be assessed separately.

Making overly optimistic future projections

Future milk prices, production and expenses should be based on reasonable assumptions.

Preparing the project around the desired loan amount

The project cost should be calculated from the actual requirements of the activity, rather than starting with a desired loan amount and adjusting the project cost to match it.

Final Checklist for a Dairy Farming DPR

Before finalizing the DPR, check the following:

Project Details

  • Type of livestock identified
  • Number of animals finalized
  • Breed and productivity assumptions established
  • Land availability verified
  • Existing infrastructure assessed

Project Cost

  • Animal cost supported by reasonable quotations
  • Shed requirement assessed
  • Equipment requirements identified
  • Working capital assessed
  • Existing infrastructure not unnecessarily included as new investment

Production

  • Milk yield calculated
  • 300-day production assumption considered where appropriate
  • Dry period considered
  • Production assumptions explained
  • Other sources of income properly calculated

Expenses

  • Green fodder included
  • Dry fodder included
  • Concentrate feed included
  • Labour calculated
  • Veterinary expenses included
  • Electricity and other operating costs included

Financial Analysis

  • Sales projection prepared
  • Profit and Loss prepared
  • Balance Sheet prepared
  • Cash flow prepared
  • Loan repayment schedule prepared
  • DSCR calculated
  • Financial ratios calculated
  • Break-even considered
  • Sensitivity analysis performed

Risk Assessment

  • Animal disease considered
  • Feed-price risk considered
  • Milk-price risk considered
  • Production risk considered
  • Mortality risk considered
  • Labour availability considered

Conclusion

A DPR for dairy farming or livestock farming should do much more than describe the proposed business. It should convert the farming activity into a structured financial model that clearly explains the investment, production, income, expenses and repayment capacity.

The process begins with assessing the number and type of animals and the infrastructure already available with the farmer. The expected production is then calculated using realistic assumptions. For a simple planning model, 300 milk-production days per year can be considered to account for the dry period, while actual production should depend on the animal’s production cycle.

The next steps are to calculate milk sales, other income, feed and fodder costs, labour, veterinary expenses and other operating costs. These figures are then used to prepare the projected Profit and Loss Account, balance sheet, cash flow and loan repayment schedule.

Finally, DSCR, financial ratios, break-even analysis and sensitivity analysis help determine whether the proposed project has adequate financial strength and repayment capacity.

Most importantly, a good DPR should be realistic, internally consistent and based on the actual requirements of the farm. If a suitable cattle shed is already available, there is no reason to automatically include a new shed in the project cost. Similarly, if infrastructure needs to be created, its cost should be properly provided for.

In simple terms, a well-prepared dairy farming DPR should answer one central question:

Can the proposed livestock business generate sufficient and sustainable cash flow to operate successfully and repay the proposed finance?

That is the foundation of a practical and bankable DPR for dairy farming.

You can also explore other featured article How to Prepare DPR for Agriculture Infrastructure Fund (AIF) Projects | AgriTechKart

Before you dive deep into the dairy farming business and apply loan for it, kindly first get through the Model Bankable Projects – NABARD – National Bank For Agriculture And Rural Development

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top