Farm Futures
   Search Site:  Search Site Thursday, May 23, 2013 | Bookmark This Site   
Skip Navigation Links
Home
Markets
News
Weather
Farm Futures NOW!
Magazine Online
RSS News
Mobile
Subscribe
Reprints
Register
Login
About Us
Advertise
 
  • Post to Your Wall.
 

Flex Rent Tool

Rethinking cash rents can help with market volatility.
Paul Burgener Read latest updates on Twitter
Published: Jan 7, 2013

Market prices in the fall and winter when cash lease rates are negotiated may not be there when the next crop is harvested.

With cash rents going higher every year with the expectation that corn and soybean prices will never come down, farmers are taking on added risk with each crop. Bruce Johnson and Tyler Rosener at the University of Nebraska-Lincoln developed a simple spreadsheet that will allow adjustments to the cash rent based on corn and soybean prices.

The spreadsheet sets a base cash rental rate that is adjusted on the actual harvest price once the crop is in the bin. It is a price only tool with the base rental rate set using projected yields that are set for the year. Prices have been the big player in rising cash rental rates across the Midwest, and this tool allows for an adjustment for both increases and decreases in the harvest price of corn and soybeans.

MANAGE RENTS: Latest Spreadsheet of the Month helps you set flex rents.

MANAGE RENTS: Latest Spreadsheet of the Month helps you set flex rents.
We're featuring the spreadsheet as our Farm Futures Spreadsheet of the Month. The 20-kilobyte spreadsheet should work with Excel 2000, 2002, 2010 or Excel XP. You can download it by clicking on the link below.

Do you have a spreadsheet that's made a difference on your operation that you'd be willing to share with other readers? Drop us a line at FarmFutures@farmprogress.com with a description of the spreadsheet. We'll pay $75 if we feature your farmer-written noncommercial program as our Spreadsheet of the Month.


Download file: FlexRents.xls
Size: 49.664 KB (Kilobytes)
Created: 01/07/2013 04:09 PM
Last Modified: 01/07/2013 04:09 PM
Click here to download this file.



Permalink: Click here

Tagged: farmprogress, farmprogress.com

Comments
Read comments from others and share your own thoughts.
Please provide the answer to the following question:

 = 
 
Search this site:   

Read More Stories
Ag Already Impacted by Climate Change
Read this storyEfforts should move toward mitigation and adaptation, say experts.
Read this story

Testing the Waters
Read this storyProject identifies fields at risk for sending phosphorous to streams.
Read this story

Agriculture's Aerial Patrol
Read this storyUnmanned drone technology may be next step for crop and grassland scouting.
Read this story

   
Morning Market Review by Bryce Knorr
Afternoon Recap by Paul Burgener
EPA Proposes Wide Range of Changes to RFS
Sugar Policy Dominates Farm Bill Discussion
Weekly Fertilizer Review
Economic Nitrogen Fertilizer for Corn
Senate Judiciary Committee Passes Immigration Reform Bill
Super Farm Planning Tool
Sugar Policy, SNAP Key Points of Farm Bill Debate Day Two
Custom Rates Change with Fuel Cost
Top 50 Tags
2008 farm bill 4-H American Farm Bureau Federation American Soybean Association animal health biofuel biofuels BSE checkoff Corn Belt crop insurance department of agriculture Drought dryland Environmental Protection Agency EPA extension service farm bill Farm Bureau farm programs farm progress farm progress show Farm Service Agency farm show farmprogress farmprogress.com farmprogressshow farmprogressshow.com FDA FFA Food and Drug Administration free trade agreement hay expo House Agriculture Committee husker harvest Husker Harvest Days huskerharvestdays.com livestock livestock producers National Cattlemen's Beef Association National Corn Growers Association NCGA New York Farm Show Progress show Senate Agriculture Committee soybean association the farm bill usda winter wheat www.farmprogress.com