# 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

## Zimbabwe Sugar Farmers Get Dam 50 Years After Proposal

By Bloomberg
•  Michigan Drill Team to Be in Inaugural Parade 01/20/2017 02:13 PM
•  More of the Same for RMI, 17 Months of Below Neutral Growth 01/20/2017 01:07 PM
•  Pro Farmer: Multi-Month Highs in the Grain/Soy and Cattle Markets 01/20/2017 12:33 PM
•  Bayer, Monsanto Pledge to Add 3,000 US Jobs 01/20/2017 12:15 PM
•  Trump Puts WOTUS on Notice 01/20/2017 12:06 PM
•  Falling USDA Crop Survey Repsonse Rates Prove Problematic 01/20/2017 11:32 AM
•  Mars Investigating Spilled Skittles Headed for Cattle Feed 01/20/2017 11:30 AM
•  Robot Crop Pickers Limit Loss of Farm Workers to Trump Wall 01/20/2017 10:44 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