Goto: Home Crop Insurance  
 
  2005 Crop Insurance Payment Calculator   
  (Calculates insurance payments for alternative insurance products.)  
  Crop/County Input          
    Crop:        
    County:        
  APH yield:   Actual Production History yield -- used to set guarantees  
  Protection level:   Percent of maximum protection level, Used to calculate GRP  
          and GRIP payments.    
     
  2005 Crop Insurance Parameters    
    APH price:   Price for calculating payments on yield shortfalls for yield products  
  Base price:   Set in February, sets guarantees on revenue products  
  Expected price:   Set last 5-days of February, sets guarantees on GRIP  
  Expected county yield:  Set guarantees on GRP and GRIP  
    Max protection level:      
       - GRP   Used in payment calculation on GRP    
       - GRIP   Used in payment calculation on GRIP    
 
   Yields and Harvest Prices    
  Actual farm yield:   Yield at harvest    
  Actual county yield:   Yield at harvest    
  Harvest price:    
  Basis:   Futures minus cash price    
    Cash price:   Harvest price minus basis    
  (Click off cell for calculations to occur)  
 
  Estimated insurance payments, $ per acre  **    
  Coverage                
  Level APH RA-BP RA-HP CRC GRP GRIP-NoHR GRIP-HR  
             
             
             
         
   
   
   
   
           
 
  Crop revenue plus insurance payment, $ per acre **    
  Coverage                
  Level APH RA-BP RA-HP CRC GRP GRIP-NoHR GRIP-HR  
             
             
             
         
   
   
   
   
           
 
  ** Insurance products are as follows.  More information is provided by clicking here.  
      APH -- Actual Production History insurance -- yield insurance  
     RA-BP -- Revenue Assurance with the base price option insurance -- revenue insurance without a guarantee  
                  increase.  
     RA-BP -- Revenue Assurance with the harvest price option insurance -- revenue insurance with a guarantee  
                  increase.  
     CRC -- Crop Revenue Coverage insurance -- revenue insurance with a guarantee increase.  
     GRP -- Group Risk Plan -- yield insurance at a county level.  
     GRIP-NoHR -- Group Risk Income Plan without the harvest revenue option -- revenue insurance without a   
                 guarantee increase at a county level.  
     GRIP-HR -- Group Risk Income Plan without the harvest revenue option -- revenue insurance with a   
                 guarantee increase at a county level.  
 

Powered By ExcelEverywhere