MARKET DATA, INC. - RISK REWARD ANALYSIS       Run on: 6/6/2007
Exit   Print   Back   Next
I. INFORMATION REVIEWED FOR:  MDI Example On Dry Land Acres
 
  FIXED COST + PROFIT TARGET AMOUNT PER ACRE   $
 for IV. REWARD
 recalculate with new target->
  (price used for email alerts)    
 
        KC WHEAT CORN MILO SOYBEANS
A. Crop share percentage share:    100.00%  100.00%  100.00%  100.00%
B. Actual Production History (APH): 38.0 70.0 65.0 28.0
C. Insurance Coverage Level on   70.00% 70.00% 70.00% 70.00%
D. Type of Insurance Coverage    ra+ ra+ crc ra+
E. Insurance Coverage Base Price    $5.11 $4.06 $3.83 $8.37
             
F. Actual yield planned of -click here to change B, C, D, or F 45.0 75.0 75.0 30.0
G. MDI Current Local Cash Price $4.31 $3.48 $3.20 $7.40
H. Enter your Cash Price Here: Use   Use   Use   Use  
  Enter your Yield Here:        
  Enter your Expenses Here:        
  * A -0- will default to the MDI numbers.      
        KC WHEAT CORN MILO SOYBEANS
               
II. MDI Variable Costs Per Acre $130.00 $170.24 $153.75 $138.35
               
III. CROP INSURANCE COVERAGE $136.03 $198.94 $174.27 $164.05
  LESS: Variable Costs of     $130.00 $170.24 $153.75 $138.35
  EQUALS NET RISK (-) $6.03 $28.70 $20.51 $25.71
           
IV. PROJECTED CASH CROP INCOME  $270.00 $261.00 $240.12 $222.00
  LESS: Variable Costs of $130.00 $170.24 $153.75 $138.35
  EQUALS NET REWARD (-) $140.00 $90.76 $86.37 $83.65
           
V. TARGET $ PER ACRE $180.00   $220.24  $203.75  $188.35         
                   
VI. CASH TARGET NEEDED
$3.00
$2.94
$2.72
$6.28
  Estimated Basis (minus) ($0.45) ($0.20) ($0.35) ($0.75)
  FUTURES TARGET OF $3.45 $3.14 $3.07 $7.03
           
VII. TARGET FUTURES
SEP KC
DEC CORN
DEC CORN
NOV BEANS
  Current Futures Price $5.11 $3.81 $3.81 $8.37
  MOVE NEEDED ($1.66) ($0.68) ($0.75) ($1.34)
  Move Probability 10 years 100.0% 100.0% 100.0% 100.0%
  Futures Target Probability 60.0% 10.0% 10.0% 40.0%
           
  Move Probability 20 years 100.0% 100.0% 100.0% 100.0%
  Futures Target Probability 60.0% 20.0% 20.0% 35.0%
           
  Move Probability 30 years 100.0% 100.0% 100.0% 100.0%
  Futures Target Probability 60.0% 26.7% 30.0% 46.7%
           
VIII. YIELD NEEDED TO COVER VARIABLE COSTS USING CASH PRICE: 28.89 48.92 48.02 18.70