0
0
0
 
Worksheets  08/30/12 4:41:59 PM










Livestock Worksheets:

For livestock breakeven analysis and futures/options risk analysis Click Here.

This analysis allows the user to input various feedstuffs with the ability to enter cost per unit and quanity. If the user desires, they can also plug in futures and or options prices and create what if scenarios if prices move high or lower. The end result of the analysis other than knowing a breakeven, is to see the different risk the user/producer will have doing nothing, selling futures or purchasing put options. Cash contracting results will be similar to to selling futures without risk of margin calls.This analysis can be used for all livestock enterprises. Enter data only in fields with a white background.

For livestock breakeven, feeder cattle vs live cattle analysis, Click Here.

This analysis will show breakevens and potential profit/loss if the cattle are grown to feeder cattle weight or finished and sold as slaughter cattle. The slaughter cattle analysis is not a combination of feeder cattle profit or loss and slaughter weight profit or loss, but mearly a computation of P & L from the time of entry into the feedlot until slaughter weight. This is a simple cost of gain analysis. It contains no way to plug in individual feedstuffs, costs or quantities. It also offers the ability to enter put options strike prices and costs to analyze the effectiveness of using put options vs. futures or cash sales. Enter data only in fields with a white background.
 
Grain Analysis:

To analayze storing cash grain vs. selling and reowning with futures or call options Click Here.

This interactive spreadsheet allows for multiple inputs of current prices, cost of storage, interest rates, etc. With all data inputed it will analyze what if scenarios of storing grain under CCC loan, selling cash and buying futures and selling cash and buying call options. The user has the ability to see various scenarios if prices should go higher or lower. Enter data only in fields with a white background. Crop production, breakeven, marketing and financial analysis, Click Here. This interactive spreadsheets purpose is to give a grain producer a detail cost analysis of corn, wheat and soybeans. It will also analyze selling the crop at harvest or storing it along with 3 different marketing strategies for harvest sales or storing the crop. The spreadsheet has the ability to estimate LDP payments when applicable. Each of the above scenarios are on a tab at the bottom of the spreadsheet. (basis financial info can be entered on all spreadsheets at one time by holding down the "Crtl key" and clicking on each tab you wish to update. When all information is entered there is a cash flow sheet which will show a summary for each crop and for each scenario for quick review by grower and lender.


This material has been prepared by a sales or trading employee or agent of Farmers Trading
Company and is, or is in the nature of, a solicitation. This material is not a research report prepared
by Farmers Trading Company’s Research Department. By accepting this communication, you agree
that you are an experienced user of the futures markets, capable of making independent trading
decisions, and agree that you are not, and will not, rely solely on this communication in making
trading decisions.
 
DISTRIBUTION IN SOME JURISDICTIONS MAY BE PROHIBITED OR RESTRICTED BY
LAW. PERSONS IN POSSESSION OF THIS COMMUNICATION INDIRECTLY SHOULD
INFORM THEMSELVES ABOUT AND OBSERVE ANY SUCH PROHIBITION OR
RESTRICTIONS. TO THE EXTENT THAT YOU HAVE RECEIVED THIS COMMUNICATION
INDIRECTLY AND SOLICITATIONS ARE PROHIBITED IN YOUR JURISDICTION
WITHOUT REGISTRATION, THE MARKET COMMENTARY IN THIS COMMUNICATION
SHOULD NOT BE CONSIDERED A SOLICITATION.
 
The risk of loss in trading futures and/or options is substantial and each investor and/or trader must
consider whether this is a suitable investment. Past performance, whether actual or indicated by
simulated historical tests of strategies, is not indicative of future results. Trading advice is based on
information taken from trades and statistical services and other sources that Farmers Trading
Company believes are reliable. We do not guarantee that such information is accurate or complete
and it should not be relied upon as such. Trading advice reflects our good faith judgment at a
specific time and is subject to change without notice. There is no guarantee that the advice we give
will result in profitable trades.

Copyright DTN. All rights reserved. Disclaimer.
Powered By DTN