Farm Futures
   Search Site:  Search Site Saturday, May 25, 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
Economic Nitrogen Fertilizer for Corn
Read this storyTool helps manage fertilizer costs and figure in residual values too.
Read this story

Acquiring Farm Machinery Resources
Read this storyFarm spreadsheet offers a way for you to determine best approach from leasing to buying.
Read this story

Custom Rates Change with Fuel Cost
Read this storySpreadsheet helps fine-tune pricing for buyers and sellers in the custom farm market.
Read this story

   
Morning Market Review by Bryce Knorr
Afternoon Recap by Paul Burgener
Weekly Soybean Review
Weekly Wheat Review
Weekly Corn Review
Chinese Soy Ceremony in Iowa
7 Things You Might Have Missed this Week
Sharing the Farm Equipment Load
Super Farm Planning Tool
CRP Decisions Made Simple
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 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 NCBA NCGA New York Farm Show Progress show Senate Agriculture Committee soybean association the farm bill usda winter wheat www.farmprogress.com