COMPREHENSIVE PROJECT REPORT
BHAVYA DAIRY FARM
PROPRIETOR: HINGLAJ DAN ASHIYA
FARM NAME: BHAVYA DAIRY FARM
ADDRESS: BIJALIYAWAS, SOJAT CITY, DIST. PALI – 306103, RAJASTHAN
BANK: STATE BANK OF INDIA (SBI)
LOAN TENURE: 5 YEARS
Project Summary:
Total Number of Cows: 18 Hybrid (Jersey/Crossbreed)
Milk Production per Cow: 14 Litres/day
Total Milk Production: 252 Litres/day
Milk Selling Price: ₹40 per Litre
Daily Income: ₹10,080
Monthly Income: ₹3,02,400
Total Project Cost: ₹20,00,000
Loan Amount Required: ₹18,00,000
Self-Margin Money: ₹2,00,000
Fixed Assets:
Cost of Cows: (18 Cows x 50,000): ₹9,00,000
Shed Construction (25ft x 100ft Tin Shed): ₹2,50,000
Electric Equipment (Motor, Pump, Cooler etc.): ₹50,000
Recurring Monthly Expenses:
Dry Feed Expense: ₹35,000
Cattle Feed Expense (68 Bags @ ₹1500): ₹1,02,000
Labour (4 Workers): ₹35,000
Electricity (Agriculture Connection): ₹2,500
Water Supply: Self Borewell (No Cost)
Total Monthly Expenses: ₹1,74,500
1. INCOME STATEMENT (PROFIT & LOSS) – 5 YEARS
YEAR REVENUE (MILK SALES) TOTAL EXPENSES NET PROFIT
1 ₹25,92,000 ₹21,90,000 ₹4,02,000
2 ₹27,21,600 ₹22,62,600 ₹4,59,000
3 ₹28,57,680 ₹23,40,000 ₹5,17,680
4 ₹30,00,564 ₹24,22,000 ₹5,78,564
5 ₹31,50,592 ₹25,08,770 ₹6,41,822
2. BALANCE SHEET – 5 YEARS
PARTICULARS YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5
FIXED ASSETS ₹3,70,000 ₹3,33,000 ₹2,99,700 ₹2,69,730 ₹2,42,757
COWS (LIVESTOCK) ₹16,20,000 ₹14,58,000 ₹13,12,200 ₹11,80,980 ₹10,62,882
WORKING CAPITAL ₹87,000 ₹1,00,000 ₹1,20,000 ₹1,35,000 ₹1,50,000
LOAN OUTSTANDING ₹15,60,000 ₹12,00,000 ₹8,40,000 ₹4,80,000 ₹0
OWNER’S EQUITY ₹2,00,000 ₹3,92,000 ₹5,84,000 ₹7,88,000 ₹10,04,000
3. LOAN REPAYMENT SCHEDULE – 5 YEARS
YEAR PRINCIPAL REPAYMENT INTEREST TOTAL EMI
1 ₹3,60,000 ₹1,98,000 ₹5,58,000
2 ₹3,60,000 ₹1,58,400 ₹5,18,400
3 ₹3,60,000 ₹1,18,800 ₹4,78,800
4 ₹3,60,000 ₹79,200 ₹4,39,200
5 ₹3,60,000 ₹39,600 ₹3,99,600
4. WORKING CAPITAL REQUIREMENT – 5 YEARS
YEAR MONTHLY EXPENSES RESERVE WORKING CAPITAL NEED
1 ₹1,82,500 ₹2,73,750 ₹87,000
2 ₹1,88,000 ₹2,82,000 ₹1,00,000
3 ₹1,95,000 ₹2,92,500 ₹1,20,000
4 ₹2,01,000 ₹3,01,500 ₹1,35,000
5 ₹2,09,000 ₹3,13,500 ₹1,50,000
5. RATIO ANALYSIS (KEY FINANCIAL RATIOS)
Ratio Type Year 1 Year 2 Year 3 Year 4 Year 5
Net Profit Margin (%) 15.5% 16.9% 18.1% 19.3% 20.4%
Debt Equity Ratio 9.0 3.06 1.43 0.61 0
Current Ratio 1.20 1.35 1.45 1.55 1.65
Return on Investment (ROI) 19.3% 22.9% 25.8% 27.8% 30.1%