Don’t start from scratch! We’ve rounded up Farm Gross Margin Templates for you!

All this week on Table Talk we are talking budgeting.

Did you catch our last post on Gross Margin Analysis? We promised to round up some fantastic excel gross margin spreadsheets to help you get started, so here we are!

Just remember the data provided is a guide and you must adapt the assumptions and model based on your own circumstances. 

Beef Cattle

Gross Margins for NSW Beef Enterprises: Provides an indicative GM/ha and GM/DSE for different cattle enterprises. The highest GM/ha is growing out early weaned calves 160-340kg.

Gross Margin Guide 2017 – Livestock: Don’t miss this! Helps to assess the potential profitability of alternatives when making enterprise selection decisions. Just choose your enterprise to get started and then change assumptions as per your situation. Super handy spreadsheet to use in your own Gross Margin analysis, whether in South Australia or not.

Farm Forms – Livestock: Gross margin templates for beef breeding, trading, wool, lamb, sheep trading and feedlotting.

Livestock Gross Margins – High Rainfall: Assists in determining returns from a range of livestock enterprises including breeding cows, cattle trading, dairy heifer agistment, prime lambs and lamb finishing. Data is Tasmania high-rainfall relevant. Also looks at t DM/Ha needed under different livestock enterprise scenarios.

Coastal Weaners Unimproved Beef Cattle Gross Margin Budget: Outlines the likely GM/Ha ($134/ha) of this enterprise (sell at 7 months) based on a number of assumptions. Some interesting sensitivity tables too.

Feeder Steers Beef Cattle Gross Margin Budget: Outlines the likely GM/Ha including ($207/ha) of this enterprise (feeder steers at 18 months) based on a number of assumptions.

Coastal Weaners Improved Beef Cattle Gross Margin Budget: Outlines the likely GM/Ha including and excluding pasture costs ($316/ha and $378/ha respectively) of this enterprise based on a number of assumptions.

Growing out early weaned calves Beef Cattle Gross Margin Budget: Outlines the likely GM/Ha including and excluding pasture costs ($348/ha and $448/ha respectively) of this enterprise (160kg-340kg)based on a number of assumptions.

Jap Ox (grassfed) Beef Cattle Gross Margin Budget: Outlines the likely GM/Ha including and excluding pasture costs ($197/ha and $211/ha respectively)

Growing out steers Beef Cattle Gross Margin Budget: Outlines the likely GM/Ha including and excluding pasture costs ($279/ha and $379/ha respectively) of this enterprise (240kg – 460kg )based on a number of assumptions.

MSA at 20 months Beef Cattle Gross Margin Budget: Outlines the likely GM/Ha including and excluding pasture costs ($206/ha and $222/ha respectively) of this enterprise based on a number of assumptions.

Inland Store Weaners Beef Cattle Gross Margin Budget: Outlines the likely GM/Ha ($189/ha) of this enterprise based on a number of assumptions. Some interesting sensitivity tables too.

Butcher Vealers Beef Cattle Gross Margin Budget: Outlines the likely GM/Ha including and excluding pasture costs ($231/ha and $331/ha respectively) of this enterprise based on a number of assumptions.

Goats

Meat goats gross margin (western): Outlines the likely GM/Ha ($9/ha) of this enterprise based on a number of assumptions.

Meat goats gross margin (less arid areas/inner): Outlines the likely GM/Ha excluding and including fodder costs ($43/ha and $46/ha respectively) of this enterprise based on a number of assumptions.

Sheep

Agricultural business financial tools (Dairy, pigs, poultry and sheep): Great range of excel templates for operational decisions – check out if in dairy, pig, poultry and sheep industries.

Gross Margin Guide 2017 – Livestock: Don’t miss this! Helps to assess the potential profitability of alternatives when making enterprise selection decisions. Just choose your enterprise to get started and then change assumptions as per your situation. Super handy spreadsheet to use in your own Gross Margin analysis, whether in South Australia or not.

Sheep Gross Margin Template: Simple sheep gross margin template.

Farm Forms – Livestock: Gross margin templates for beef breeding, trading, wool, lamb, sheep trading and feedlotting.

Livestock Gross Margins – High Rainfall: Assists in determining returns from a range of livestock enterprises including breeding cows, cattle trading, dairy heifer agistment, prime lambs and lamb finishing. Data is Tasmania high-rainfall relevant. Also looks at t DM/Ha needed under different livestock enterprise scenarios.

Merino ewes (18 micron)/Merino rams gross margin: Outlines the likely GM/Ha excluding and including fodder costs ($391/ha and $356/ha respectively) of this enterprise based on a number of assumptions.

Merino wethers (20 micron): Outlines the likely GM/Ha excluding and including fodder costs ($309/ha and $287/ha respectively) of this enterprise based on a number of assumptions.

Merino ewes (20 micron)/Merino rams gross margin: Outlines the likely GM/Ha excluding and including fodder costs ($383/ha and $350/ha respectively) of this enterprise based on a number of assumptions.

Merino ewes (20 micron)/Merino rams, wether lambs finished: Outlines the likely GM/Ha excluding and including fodder costs ($432/ha and $384/ha respectively) of this enterprise based on a number of assumptions.

Merino ewes (20 micron)/75% Merino rams, 25% Terminal rams gross margin: Outlines the likely GM/Ha excluding and including fodder costs ($420/ha and $372/ha respectively) of this enterprise based on a number of assumptions.

Merino ewes (20 micron)/Terminal rams gross margin: Outlines the likely GM/Ha excluding and including fodder costs ($427/ha and $368/ha respectively) of this enterprise based on a number of assumptions.

Merino ewes (20 micron)/Maternal meat rams gross margin: Outlines the likely GM/Ha excluding and including fodder costs ($422/ha and $382/ha respectively) of this enterprise based on a number of assumptions.

1st cross ewes/Terminal meat rams gross margin: This outlines the likely GM/Ha excluding and including fodder costs ($392/ha and $346/ha respectively) of this enterprise based on a number of assumptions.

Merino wethers (18 micron): Outlines the likely GM/Ha excluding and including fodder costs ($344/ha and $321/ha respectively) of this enterprise based on a number of assumptions.

Dorper ewes/Dorper rams gross margin: Outlines the likely GM/Ha excluding and including fodder costs ($409/ha and $361/ha respectively) of this enterprise based on a number of assumptions.

Dairy

Dairy Gross Margins and Profitability Analysis: Assists in determining returns from a spring calving dairy herd. Data entered is Tasmanian related.

 

 

Cropping

Gross Margin Guide 2017 – Cropping: Choose your crop, rainfall zone, and machinery type and the gross margins prefill for you. Super handy spreadsheet to use in your own Gross Margin analysis, whether in South Australia or not. Excel version 2007 and above (Windows Only).

AgMargins: Amazing web-based tool to find gross margin data and even input your own data. Worth a look even if not based in Queensland. The commodities covered are barley, broccoli, cabbage, canola, carrots, cauliflower, chickpeas, cotton, faba beans, garlic, lentils, lettuce, lucerne, maize, mungbean, navy beans, onion brown, peanut, pecan, pumpkin, sorghum, soybean, sugarcane, sunflower, sweet corn, table grapes, wheat.

Simple Gross Margin Calculator: Great little cropping calculator online. In addition to a simple GM, you will also need to enter crop insurance (if applicable), interest on working capital, opportunity cost and depreciation costs on machinery owned (if applicable).

Agbiz tools – Plants – Field Crops and Pastures: Over 50 Gross Margin templates, including: barley, canola, carrots, bananas, chickpeas, cotton, lucerne, maize, mango, millet, mung bean, oats, hay, peanut, ryegrass, sorghum, soybean, sugarcane, sunflower, wheat.

Crop Gross Margins – high rainfall: Assists in determining returns from a range of cropping enterprises including winter grains (dryland and irrigation) and fruit and nut crops. Data is Tasmania high-rainfall relevant.

Organic Grains-Gross Margins: Spreadsheet to assist calculationg of gross margins for irrigated organic wheat and barley. Data entered is Tasmanian specific.

Crop Gross Margin Template: Simple cropping gross margin template.

Crop Gross Margins – low rainfall: Assists in determining returns from a range of cropping enterprises including winter grains (dryland and irrigation) and fruit and nut crops. A handy summary sheet brings together all the enterprises in one sheet. Data is Tasmania low-rainfall relevant.

Generic crop summary: Simple crop budget worksheet. Includes fixed cost so is for an enterprise budget. US-based.

Farm Economic Analysis Tool (FEAT): Excel spreadsheet free after subscribing. Assists with gross margin analysis for sugarcane growers.

Cotton Gross Margins Calculator: Pretty nifty web-based calculator to compare returns to dryland cotton versus sorghum.

Cotton gross margin budgets: These cotton gross margins are in PDF format and cover furrow irrigated (with and without contracting), dryland (single and double skip), semi-irrigated and overhead irrigated.

Independent Southern NSW Irrigated Crop Options Paper: Rice or Cotton? Be armed to make decisions by reading this report. Note: data a little outdated.

Rice$cenario: Great web-based interactive tool to help plan irrigation, water cost, gross margin, cashflow for your rice operation.

Horticulture

Blueberry Gross Margin Analysis: Assists in determining returns from an irrigated blueberry enterprise. Data entered is Tasmanian related.

Strawberry Gross Margin Analysis: Assists in determining returns from an irrigated strawberry enterprise. Data entered is Tasmanian related.

Raspberry Gross Margin Analysis: Assists in determining returns from an irrigated raspberry enterprise. Data entered is Tasmanian related.

Cherries Gross Margin & Profitability Analysis: Assists in determining returns from an irrigated cherry enterprise. The spreadsheet also enables estimation of investing and establishing cherries and provides a 20year expected cashflow. Data entered is Tasmanian related.

Olives (for Oil) Gross Margin & Profitability Analysis: Assists in determining returns from a olives (for oil) enterprise. The spreadsheet also enables estimation of investing and establishing olives and provides a 20year expected cash flow. Data entered is Tasmanian related.

Hazelnut Gross Margin & Profitability Analysis: Assists in determining returns from a hazelnut enterprise. The spreadsheet also enables estimation of investing and establishing hazelnuts and provides a 20 year expected cash flow. Data entered is Tasmanian related.

AgMargins: Amazing web-based tool to find gross margin data and even input your own data. Worth a look even if not based in Queensland. The commodities covered are barley, broccoli, cabbage, canola, carrots, cauliflower, chickpeas, cotton, faba beans, garlic, lentils, lettuce, lucerne, maize, mungbean, navy beans, onion brown, peanut, pecan, pumpkin, sorghum, soybean, sugarcane, sunflower, sweet corn, table grapes, wheat.

Viticulture

Wine Grapes (Chardonnay & Pinot Noir) Gross Margin & Profitability Analysis: Assists in determining returns from a wine grapes enterprise. The spreadsheet also enables estimation of investing and establishing grapes and provides a 20year expected cashflow. Data entered is Tasmanian related.


Sick of excel? There are budgeting software tools on the market – check out our Accelerate page.