Equipment Lease Analyzer

The University of Missouri equipment lease analyzer is designed to answer 2 questions regarding leasing farm equipment.

  1. First it seeks to determine whether a lease or a purchase is more profitable and feasible from a cash flow perspective.
  2. Second it helps decide the annual contract hours for a lease.

A lease affects a farmer’s financial position differently than a purchase. Whenever another piece of equipment is needed both the lease option and the purchase option should be investigated. By entering the appropriate information gathered from your implement dealer and banker, “Equipment Lease Analyzer” provides the net after tax expense of each. The cash needed for each option is also displayed.

The expenses and cash flow are both discounted back to the present to determine what is the present value of each option. By looking at the expenses and cash, a farmer can make a more informed decision.

Should a farmer choose to lease a piece of equipment, one of the questions faced regards the annual hours of use. The lease agreements usually specify hundreds of hours (e.g. 400 hours or 600 hours). If a farmer exceeds the hours on the contract an hourly charge is incurred. If the farmer uses less than the hours on the contract, no benefit is accrued.

Using the spreadsheet requires MicroSoft Excel. Open the program and go to the page entitled “Purchase”. Complete the information needed in all of the yellow cells. The tables below give the results of the lease and purchase. The first table is a summary providing sufficient information to analyze the options. The tables below are more detailed and can be referenced if you want to see the details behind the summary.

To determine the optimum number of hours for a lease, go to the page entitled “Hours Max”. Complete the information needed in all of the purple cells and use the left mouse button to click on the box labeled “Compute Breakeven Hours”. The breakeven number of hours will appear in cell B7. If you expect to use the equipment less than that number of hours, choose the smaller hour option. If more, choose the larger hour option.

This spreadsheet is available for downloading from the AgEBB system using several methods: 1) through the Internet at the following address, http://agebb.missouri.edu/download/university/EquipmentLeaseAnalyzer.xls and 2) from the standard BBS system under the tigers spreadsheets file transfer area. If you have any questions regarding downloading this spreadsheet please contact the AgEBB office at 573-882-4827 or e-mail.

 

Disclaimer: This worksheet is for educational purposes. The University of Missouri and Ray Massey are not responsible for any actions taken as a result of using this template.

TAGS:

TEAM LINKS:

RELATED RESOURCES

Long-run Cash Rent

September 13, 2023

Examine breakeven prices, earnings per acre, breakeven cash rents, and trends in working capital with this spreadsheet tool.

READ MORE

Comparing Net Returns for Alternative Leasing Arrangements

August 10, 2023

This article used a case farm in west central Indiana to compare the net return to land for crop share, fixed cash rent, and flexible cash leases. The average net returns to land from a landowner perspective were similar among the three lease arrangements.

READ MORE

Farm Lease Types, Side X Side Digital Webinar

August 8, 2023

Michael Langemeier introduced the types of leases (cash rent, flex rent, and share rent) and discussed the advantages and disadvantages of each leasing arrangement during the August 2, 2023 Side By Side Digital Webinar. A comparison with risk/return tradeoffs between lease types was also included in the webinar discussion.

READ MORE

UPCOMING EVENTS

Commodity Classic 2024

The Purdue University Center for Commercial Agriculture will present a Learning Center Session on Thursday, February 29 entitled Positioning Your Farm for Long-Term Success during Commodity Classic in Houston, Texas.

Read More