Livestock and Forage Production, Finance, and Economics Downloads

Livestock and Forage Production, Finance, and Economics Downloads: "Livestock and Forage Production, Finance, and Economics"

• AUM Demand and Supply
  This program allows the user to estimate the amount of Animal Unit Months (AUMs) of forage required and tons of hay required for up to four different groups of livestock. The program estimates the forage required based on the weight of different types of animals (bulls, cows, calves, yearlings, horses, sheep and wildlife) and the length of time each type of animal gets its nutritional needs from grazing. This program does not account for the possible differences in range land production and animal needs. It only considers the needs of the various types of animals for the length of the grazing period desired. The basic assumption behind this approach is that management of the groups is assuring the actual range land is producing the forage required to meet the animals needs. Two separate estimates are provided for AUMs required. The first is based strictly on the length of time the animals get their nutritional needs from grazing. This estimate is done without regard to where the animals are grazing. The second estimate allows the user to enter a detailed pasture rotation using the number of animals of each type, the time on and time off of each pasture to help determine if the pasture rotation, based on management consideration for the actual forage available in a particular pasture, is supplying adequate forage for the entire group of animals. The requires for the groups entered are summarized for comparison and to show total AUMs required for the operation.
  
  
• Beef Cow Financial and Partial Budgeting (Formerly Livestock Partial Budgeting)
  This spreadsheet will analyze changes in a cow-calf operation using a financial analysis approach and a partial budgeting format. The user enters the income, expenses, and other cash inflows and outflows for a normal operation, then specifies up to 6 alternative production, marketing, or other methods of operation. Each alternative requires the user to specify what changes would be made "relative to the base operation." Revised January 2008
  
  
• Breakeven Prices
  Allows the calculation of break-even prices for a wide range of starting prices and costs of gain for feeder livestock. View/download a pdf file.
  
  
• Calf Wintering Background
  Calculates the profitability of putting calves on feed through the winter period. View/download a pdf file.
  
  
• Cash, Futures, Basis Data (Revised November 2010)
  Average monthly futures and feeder cattle prices and average monthly cash prices and basis data for selected weight groups for steers and heifers from 1983 through 2006. Steer cash price and basis data for 400 to 500 pounds, 500 to 600 pounds, 600 to 700 pounds and 700 to 800 pounds. Heifer cash price and basis data for 400 to 500 pounds, 500 to 600 pounds, 600 to 700 pounds.
  
  
• Cow Calf Feeder Stocker Budgeting
  This spreadsheet estimates enterprise budgets for cow-calf operations, back grounding/feeding for various lengths of time and running stockers on pasture. The spreadsheet uses an economic approach to estimating profitability of these three phases of commercial beef production faced by cow-calf producers in the northwest. The spreadsheet also allows the user to calculate a share lease percentage for the cow-calf enterprise. The cost contributions approach to leasing is used to estimate an equitable percentage share of the revenue for the cow owner and the person running the cows on a day-today basis. The cost contributions approach assumes that an equitable share of revenue is the same percentage share that each party pays for the costs of the cow-calf enterprise. The spreadsheet estimates the profitability for the cow-calf enterprise as a whole and also estimates the profitability for the both the cow owner and person running the cows if a lease is in place. The spreadsheet also estimates cash lease rates for the cow-calf enterprise using the share lease calculations as the starting point. Revised January 2008
  
  
• Cow Cost
  Calculates the ownership and operating costs for a commercial beef enterprise. View/download a pdf file.
  
  
• Ewe Cost
  Enterprise budgeting for a ewe flock operation. Calculates both variable and fixed costs and shows both cash flow and profitability analysis for a ewe flock enterprise.
  
  
• GRASSFAT
  Calculates the profitability of putting steers or heifers on summer pasture. Calculates the break-even prices necessary to cover all production costs and also calculates the break-even purchase price with a given sales price. Can be used in conjunction with CALFWINT to estimate break-even prices necessary for yearlings. View/download a pdf file.
  
  
• Hay Costs on Cow Calf Profitability
  This template allows users to enter average information about the revenue and expenses related to a cow calf enterprise. The user can then examine the impact on profitability of substituting hay purchases for a loss in AUMs of grazing for any r 11/24/10 etc. Average cow-calf enterprise costs are included as a guide for required data entry.
  
  

  Calculates calf performance statistics for cow-calf operations. This template will handle any number of cattle if mating is not known. Follows Beef Improvement Federation performance guidelines but breed specific adjustment factors can be entered by the user. Calculates one year of performance statistics and does not keep cow histories.

  If using Excel 97, both Microsoft patches/updates SR-1 and SR-2b must be installed. You may also want to install the Microsoft Date Migration Wizard. These can be downloaded from the Microsoft web site free of charge. Excel 2000 runs this template without the updates. View/download a pdf file.

• Haying System Enterprise Budgeting
  
  Updated to include calculating custom rates for haying systems.
  
  This spreadsheet allows the user to estimate the operating and ownership costs of a specific type of haying systems. The user must enter machinery and equipment information for various types of systems, round bale, small square bale, large square bale, or some combination of these systems they use to put up hay. The user must specify the type of machinery and equipment used for cutting, raking, baling and hauling and stacking. The program estimates the machinery costs for each of these steps and if desired, lets the user develop enterprise budgets for the haying and stand establishment enterprises.
  
  
• Herd Size and Cattle Cycle
  This template allows the user to evaluate changing herd sizes in response to cattle cycles or drought conditions. The user must enter information about their current situation and what they want to evaluate over time. Alternatives that can be considered include selling all or part of the breeding livestock and leasing the remaining resources (hay & grass), holding additional heifer calves at weaning, purchasing replacement animals which can be either young breeding stock or short term cows, or some combination of the above. The analysis shows both inflation adjusted income and expenses and a discounted (net present value) analysis of the income and expenses for a given herd management strategy.
  
  
• Noxious Weed Control
  Economic analysis of long-term weed control. Uses a capital investment analysis to determine the economic feasibility of controlling noxious weeds.
  
  
• Ranch Horse Enterprise Budget
  This program allows the user to estimate the development costs, or the profitability of a ranch horse development enterprise. The user is required to enter the operating and ownership costs that apply to a ranch horse enterprise. This budgeting software does not include a breeding program, only the development costs that follow a breeding program.
  
  
• Sheep Grazing Crops Partial Budgeting
  This program analyzes the use of sheep for grazing grain stubble to control insects. It can be sued to evaluate options for grazing sheep owned by someone else or sheep owned by yourself. Input in the program is collected for the small grain enterprises that might be grown on an operation and the changes in profitability and cash flow that would occur substituting sheep grazing for inset or weed control. The example included in this program is very simple, including only the possible changes that would occur if allowing someone else to bring sheep in to graze your grain for insect control. The program allows up to six alternative methods of operation to be compared side by side for profitability and cash flow analysis. Results of the changes are shown relative to the base case.