instructionsforusingstockerfeedercattlespreadsheettools.docVIP

Instructions for Using Stocker/Feeder Cattle Spreadsheet Tools University of Missouri Extension, Commercial Agriculture Beef Focus Team Evaluation of Buying Feeders This spreadsheet was written in Microsoft Microsoft( Excel. Conversion to other spreadsheet programs is not guaranteed. You will be asked if you want to enable macros in the spreadsheet. Click on the Enable Macros button. The file has been scanned for viruses and is considered safe as it leaves my office. The starting point for this spreadsheet is the upper left corner (A1) of the Feeder Calculations Page. If you are not at this location as the file is brought up, press ControlHome, or use the scroll bars to go to that location. Many of the calculations for this spreadsheet are done on the Sheet 1 page. This page is available for you to look at and to examine the equations used, however you don’t need to enter any information on the page and it is locked. If the page is too small or too large for your screen, you can change the magnification by going to the View menu and selecting Zoom and then changing the setting. Depending on what you want to calculate, select (left click) one of the three buttons: Return to Ownership and Management, Purchase Price to Attain Given Return, or Sale Price to Attain Given Return. As with any spreadsheet tool – the answers generated are only as accurate as the accuracy of the inputs. Although the mathematical calculations were evaluated by a number of specialists and were tested on thousands of test examples, no warrantee is expressed or implied about the accuracy of the spreadsheet. PLEASE USE THE SPREADSHEET AT YOUR OWN RISK. To Calculate Return to Ownership and Management You will be asked to fill in several variables concerning the feeding situation you are evaluating, all variables are on a per head basis (not the entire group) Variable Description Price paid per pound ($) The incoming cattle’s price per pound. Four decimal places are available so that ca