Farm investment QuikCalc

Considering a farm as an investment? A dairy conversion?
Do the sums before you commit! You may be surprised!

Note: The light coloured cells are user definable. 0 is an option in all cases. The default figures are from DairyBase®

What type of farm?

Revenue

Investment

Alternatively

Statistics

/ha

Investment in land & livestock

/ha

Conclusion Req'd equity return

Total investment

/ha

SpreadsheetConverter

2005-6 Benchmarking Summary from DairyBase® (click here)

	Northland	Waikato	Bay of Plenty	Taranaki	Lower North Island	West-coast Tasman	Marlb/ Canterbury	Otago Southland	NZ
Farm Count	38	118	26	34	33	21	41	53	364
Cows/ha	2.5	3.2	2.9	2.9	2.9	2.8	3.4	2.8	3.0
Milksolids/ha	758	1149	972	1017	1065	1007	1338	1144	1075
Milksolids/cow (kg)	309	356	330	346	372	356	397	408	360
Cows Milked Per Total FTE	136	141	146	128	132	119	142	148	138
Milksolids Per Total FTE	42021	50218	48199	44385	49209	42401	56266	60531	49551

Gross Farm Revenue/ha	3723	5262	4464	4660	4898	4616	6072	5244	4954
Operating Expenses/ha	2813	3806	3289	3557	3552	3750	4675	3814	3687
Operating Expenses/cow	1125	1189	1134	1227	1225	1339	1375	1362	1240
Operating Profit (EFS)/ha	910	1456	1175	1103	1345	866	1397	1430	1266
Gross Farm Revenue/kg MS	4.91	4.58	4.59	4.58	4.6	4.58	4.54	4.58	4.61
Operating Expenses/kg MS	3.71	3.31	3.38	3.5	3.34	3.72	3.49	3.33	3.43
Operating Profit (EFS)/kg MS	1.2	1.27	1.21	1.08	1.26	0.86	1.04	1.25	1.18
FWE/kg MS	2.73	2.6	2.55	2.68	2.68	2.7	2.82	2.62	2.66
Interest & Rent/GFR	22.30%	21.90%	25.60%	24.70%	23.30%	25.50%	22.70%	25.30%	23.30%
Interest & Rent/kg MS	1.1	1	1.18	1.13	1.07	1.17	1.03	1.16	1.07
Return on Dairy Assets	3.00%	3.40%	4.00%	3.10%	3.50%	3.10%	3.40%	5.00%	3.50%
Total Return on Assets	13.70%	9.80%	9.00%	18.70%	13.40%	19.90%	4.60%	6.30%	11.10%
Total Return on Equity	16.50%	11.60%	9.90%	25.50%	17.00%	29.70%	2.60%	4.70%	13.40%
Debt to asset %	31.60%	31.50%	43.60%	33.70%	36.40%	39.10%	40.20%	52.20%	36.30%
Liabilities/kg MS	12.07	12.18	13.66	13.24	12.39	12.88	11.97	13.88	12.62