# Compare Rate of Return on Your Investments

April 17, 2012 08:01 AM

The following information is a Web Extra from the pages of Farm Journal. It corresponds with the article "Do the Best You Can with the Land You Have." You can find the article in Farm Journal's Late Spring 2012 issue.

There are many different calculations that you can use to compare on-farm investments to see which one will give you the best ROI. The Modified Internal Rate of Return (MIRR) is one of the best to determine where to put your money. In "The Bottom Line" column, Moe Russell compares the ROI between an investment of more land or a land improvement project like tiling, which will increase grain crop yields.

MIRR is the rate at which your initial expenses equals the present value of your expected cash flows that are appreciated at the average cost of borrowed money (WACC).

This WACC can be complicated if there are many different forms of collateral which are weighted by market or perceived value, but to keep it simple, this can be the interest rate you expect to pay.

You also need the percentage you expect to receive on each year’s positive cash flows, or the rate at which those returns are reinvested. This is typically the same percentage as the weighted borrowing costs.

The math of the MIRR calculation can look scary, but thanks to Microsoft Excel, the heavy lifting is done for you. It’s really quite simple, once you know something about your borrowing costs and returns over the number of years of the investment.

WACC = (cell B2)the cost of money borrowed was set at 4% and re-investment on our return was equal to 4%.

Time = (cells B3 to L3) the number of years of cost and returns you will reinvest back into the project (i.e. 10 yrs.)

Cash Flow= (cells B4 to L4) Moe’s tiling example cost was \$500 per acre or \$50,000 per 100 acres. Based on his research from Ohio State University, he estimated corn would increase by 25 bu. per acre with tiling and he would yield another 10 bu. per acre of beans. His price was set at \$5 per bu. for corn (100 acres X \$5 X 250 bu.= \$125,000) and \$12.50 per bu. for soybeans (100 acres X \$12.5 X 65 bu.= \$81,250)

MIRR= (type in cell B5) =MIRR(B4:L4,B2,B2)

A MIRR of 38% beats a 8-9% return from the stock market any day. To compare the returns on tiling the land you own versus buying more land, you would run a MIRR computation on the land you are looking to purchase and then compare the two MIRR values.

Back to news

No comments have been posted to this News Article

## Hogs and Pigs Report Preview

By Ashley Davenport
•  Brazil Meat Scandal Could Be Beneficial to U.S. Producers 03/28/2017 02:35 PM
•  Dairy Farmers Express Brexit Concerns 03/28/2017 01:45 PM
•  Students Send Notes, Jokes to Family Impacted by Wildfire 03/28/2017 01:13 PM
•  Market Is Justified in Breaking Because of What's Known in Brazil 03/28/2017 12:05 PM
•  Monsanto Accused of Ghostwriting Safety Studies 03/28/2017 11:56 AM
•  Big Climate Change Policy Changes Coming 03/28/2017 11:28 AM
•  Analyst: 40 to 50 Percent of Old Crop Corn Isn't Priced 03/28/2017 08:36 AM
•  2017 Plant Preview: Weather Favors Early Planting in Upper Midwest 03/28/2017 07:00 AM

## Corn College TV Education Series

Get nearly 8 hours of educational video with Farm Journal's top agronomists. Produced in the field and neatly organized by topic, from spring prep to post-harvest. Order now!

## Markets

Market Data provided by Barchart.com
 Cash Bids
 LDP Quotes
 ©2017 Farm Journal, Inc. All Rights One Penn Square West 30 S. 15th Street, Suite 900 Philadelphia, PA 19102
Close