UNL-Meat Goat Budget Tool - 2021-04-01 - Excel spreadsheet for revenue, expenses, and profitability

Sep 12, 2026

Upload by Stanley

UNL-Meat Goat Budget Tool is an Excel-based enterprise budget template designed to help meat goat producers evaluate expected production revenue, variable and fixed expenses, taxes, and non-farm adjustments. The tool aggregates totals into a “Summary Budget” view with breakeven calculations while requiring user inputs only in yellow-highlighted cells across dedicated worksheets. It uses market price and average cost estimate assumptions and encourages producers to adjust parameters and local prices to match their own operation and management decisions.

LanguageEnglish

CategoryForms

FormatPDF

Pages9

Reading Time3 min

AccessFree to download

Introduction

Budget Instructions

How to Use

Methods

Assumptions

Goat Budget

Annual Meat Goat Budget Summary

UNL-Meat Goat Budget Tool An Excel spreadsheet for evaluating the value of potential meat goat production revenue, expenses, and profitability Version: 2021-04-01 INTRODUCTION The University of Nebraska-Lincoln meat goat budget tool was developed to help producers determine the value of goat production. This tool is NOT intended to represent any one operation but rather market prices and average costs estimates. Each individual operation should adjust key inputs and local market prices to reflect their own situation. FOR MORE INFORMATION: Developed by: Daniel Gertner, Graduate Student, Department of Agricultural Economics, University of Nebraska – Lincoln Elliott Dennis, PhD, Department of Agricultural Economics, University of Nebraska – Lincoln Randy Saner, Lincoln-Logan-McPherson County Extension, University of Nebraska-Lincoln Glennis McClure, Department of Agricultural Economics, University of Nebraska-Lincoln ACKNOWLEDGEMENTS: The authors would like to thank the Nebraska Sheep and Goat Producers Association members and the Nebraska Meat Goat Producers for assistance in developing this budget information. UNL-Meat Goat Budget Tool An Excel spreadsheet for evaluating the value of potential meat goat production revenue, expenses, and profitability Version: 2021-04-01 Budget Instructions | (1) The "Summary Budget" tab includes total income, total costs, and net revenue, plus breakeven calculations. | | --- | | | | (2) DO NOT input numbers directly in the "Summary Budget" tab. | | | | (3) Instead, input numbers directly into "Production Parameters", "Revenue", "Expenses-Variable", "Expenses-Fixed", "Non-Farm Adjustments", and "Taxes" tabs. | | | | (4) Only input numbers and data into the yellow cells. Other numbers will automatically calculate and fill. | | | Introduction The University of Nebraska-Lincoln Department of Agricultural Economics Extension and Outreach program has developed sheep and goat budget templates for use by producers in Nebraska. The budget templates contain an interface in which producers can customize production parameters to their specific operations. Enterprise budgets can serve as a useful guide for producers as they make management decisions. How to Use Both the sheep and goat production budgets are organized identically and are designed to operate in the same way. The budgets include: 1) Instructions – Provides instructions for how to navigate the spreadsheet. 2) Summary Budget – Includes total income, variable cost, fixed cost, and breakeven calculations. 3) Production Parameters – Contains customizable general flock, feed, and asset value information. 4) Revenue – Contains a breakdown of the revenue components of sheep/goat production. 5) Expenses-Variable – Includes a breakdown of production expenses that vary from year-to-year. 6) Expenses-Fixed – Includes a breakdown of fixed and overhead expenses. 7) Taxes – Contains common taxes paid by sheep/goat producers. 8) Non-Farm Adjustments – Contains sources of other on and off-farm income that producers may include in their sheep or goat budgets. To use, please follow the following guidelines: The “Summary Budget” tab summarizes totals from the various budget worksheets or tabs. Worksheet users should input numbers directly into the yellow highlighted cells in the “Production Parameters”,“Revenue”,“Expenses – Variable”,“Expenses – Fixed”,“Non-Farm Adjustments”, and “Taxes” tabs. Methods The market prices, average cost estimates, and production parameters outlined in the budget are obtained through input from producers. First, sample production budgets from Nebraska sheep and goat producers were reviewed. Second, a sample production budgets were built using data provided by the producers. Third, the budget template and figures were presented at the annual Nebraska sheep and goat producer meetings. Fourth, adjustments were made to the budgets according to producers’ comments. F

FAQs

What does the UNL-Meat Goat Budget Tool help producers calculate?

It helps producers evaluate potential meat goat production value by estimating total revenue, variable costs, fixed costs, taxes, and net revenue, including breakeven calculations.

Where should users enter numbers in the spreadsheet?

Do not input numbers in the “Summary Budget” tab. Enter numbers only in the yellow cells within “Production Parameters”, “Revenue”, “Expenses-Variable”, “Expenses-Fixed”, “Non-Farm Adjustments”, and “Taxes” tabs.

How are the budget figures and assumptions developed?

Market prices, average cost estimates, and production parameters are based on input from producers, reviewed sample Nebraska budgets, and iterative presentations and adjustments from annual producer meetings.

Sep 12, 2026

Upload by Stanley