ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
🐄 DESI COW FARM — EXECUTIVE DASHBOARD | Sahiwal / Gir Breed | 30 Cows | ₹50 Lakh Budget
2
3
4
5
6
Total InvestmentMonthly Revenue
7
4,400,000.00 438,000.00
8
9
No. of CowsMonthly Net Profit
10
30 21,333.71
11
12
Monthly EMINet Profit Margin
13
 45,416.29 4.9%
14
15
 📋 KEY MONTHLY FINANCIALS SUMMARY
16
Total Revenue 438,000.00
17
 ↳ Milk Revenue (Direct) 234,000.00
18
 ↳ Milk Revenue (Dairy) 198,000.00
19
 ↳ Other Revenue 6,000.00
20
Total Fixed Costs 100,666.29
21
 ↳ Loan EMI 45,416.29
22
 ↳ Labour (total) 30,000.00
23
Total Variable Costs 286,000.00
24
 ↳ Feed Costs 286,000.00
25
Total Exceptional Provisions 30,000.00
26
GROSS PROFIT (before prov.) 51,333.71
27
NET PROFIT (after all prov.) 21,333.71
28
Annual Net Profit 256,004.53
29
30
 📌 IMPORTANT NOTES & ASSUMPTIONS
31
 1. Milk yield assumed at 10 litres/cow/day for 25 milking cows. Actual may vary (Gir: 10–15L, Sahiwal: 8–12L).
32
 2. A2 milk fetches ₹65–80/litre direct to consumer vs ₹50–58 to dairy cooperative.
33
 3. 30 cows split: 25 milking + 5 dry/pregnant. Dry cows rotate through lactation cycle.
34
 4. EMI of ₹86,134/month covers principal + interest on ₹50L @ 11% for 7 years.
35
 5. Exceptional provisions (₹30,000/month) build a reserve fund — unused amounts roll forward.
36
 6. Cow mortality risk is mitigated by insurance (3% premium). Provision covers uninsured portion.
37
 7. Year 2 onwards: EMI interest component reduces; net profitability improves progressively.
38
 8. Profitability does NOT include income tax (presumptive tax under Sec 44AD may apply).
39
 9. Feed costs can be reduced 30–40% by cultivating own fodder on 2–3 acres of land.
40
 10. Break-even reached when Revenue > Total Costs. Current model shows positive net profit.
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100