This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
Update
Reset
Print All
Landowner
Landowner
Tenant
Rental Rate Calcs
Instructions: The landlowner enters values in the olive green cells, unless otherwise noted. See notes for explanation and more information.
Landowner Cost Estimate
Notes
Land and facility investments (long-term)
Agricultural Value
Useful life (years)
These costs are used to estimate the opportunity cost of land value, land taxes, depreciation, and interest.
Land value
n/a
Irrigation equipment and infrastructure
Liming
Long-term land prep/development
Grain bins
Other buildings
Machinery provided to tenant
Other long-term investments
Item
Valuation
Rate
Annual Charge
Land charges
Land interest
This is either the interest rate currently paid on the land loan OR an estimated alternative rate of return the land were sold and the value were invested instead. This rate generally drives the implied rental rate because land values are typically greater than other assets. This rate of return may be 0 if the landowner owns the land outright and is intent on keeping it; it may be more if they are weighing the option to sell. Potential rates include the estimated rate of return on a savings account, or if invested in the stock market, for example. In any case, this value is often subject of discussion and negotiation.)
Land taxes
Depreciation
This is estimated based on your entries above.
Interest on (non-land) long-term investment items
This is estimated based on your entries above and interest the rate you enter.
Hauling charges
Annual land development costs
Costs of running irrigation equipment annually
Repairs
Liability insurance
Road/access maintenance and repairs
Fertilizer
Weed control
Value of labor and management
Other contributions
Total land ownership charges
Landowner's contribution ($/bu)
This is the sum of the calculated total land ownership charges, above, divided by the number of bushels produced. The estimated yield and acreage are entered on the tenant tab.
Landowner's contribution ($/cropped acre)
This is the total land ownership charges (above), divided by the acres of the lease entered on the tenant's tab.
Instructions: The tenant enters values in the olive green cells, unless otherwise noted. See notes for explanation and more information.
Notes:
Tenant Cost Estimate
Revenue calculations
Yield (bu/acre)
Value ($/bu)
Acres
Gross value ($)
Estimate these if you are calculating payment in the future. Use actual values if you are calculating the rate at the end of the growing season.
Value of Production
Crop insurance payments
Additional value of farm program payments (ARC and PLC)
Total revenue
Tenant's Contribution: Long-term investments
Value/cost
Useful life (years)
Annual cost
Many conservation practices and land development charges imply a large up-front charge that provides benefits over several years. Here we assume the tenant holds a lease that is at least as long as the lifespan of their longest long-term investment and so can realize those benefits over time.
Liming
Perennial crop/tree establishment costs
Other long-term investments on leased land
Tenant's Contribution: Annual investments
You can find estimates of many of these costs from regional enterprise budgets, if you do not know your own. While Montana does not publish enterprise budgets regularly, Idaho and North Dakota offer good nearby resources. See
https://www.uidaho.edu/cals/idaho-agbiz/crop-budgets
and
https://www.ndsu.edu/agriculture/ag-hub/ag-topics/farm-management/crop-economics/projected-crop-budgets
Depreciation (annualized costs of long-term investments)
Seed
Herbicide
Fungicide
Insecticide
Fertilizer
Crop insurance premiums
Fuel & lube
Repairs
Drying
Hauling
Custom hires
Labor
Include hired labor and if desired, the value of your own time. Many tenants will consider the net return over the lease payment to be the return to their labor and management. In that case, to avoid counting twice, do not include the value of your time.
Irrigation costs
Road/access maintenance and repairs
Other direct expenses
Operating interest
Other expenses
To evaluate long term profitability, also add indirect costs such as office expenses and overhead. By leaving these items out, you are just evaluating the return to this lease during the growing seasons specifically.
Tenant's Contribution (operating costs in $)
Contribution per bushel
Net Returns ($) over direct expenses (not counting lease expense)
Net return over direct costs per acre (not counting lease expense)
Rental Rate Calculations
Notes:
Landowner
Tenant
Total
Value of production from leased land
This is the total value of production calculated from the tenant's estimated yield, value, and acreage.
Estimated contribution
These are the total contributions tallied from the landowner and tenant sheets, respectively.
Percent contribution (shares)
These percent contributions are calculated as each party's contribution, divided by the sum of the contributions from both the landowner and tenant.
Net return allocation (total lease payment)
This is the landowner's contribution share multiplied by the total value of production.
Implied Cash Rental Rate ($/acre)
This is the net return allocation above, divided by the number of cropped acres entered by the tenant. Note that the lease rate here is based on the number of cropped acres entered by the tenant.
Tenant net return to labor ($/acre)
over direct costs and lease p
ayment. Info button: This is the net returns over direct costs per acre from the tenant's sheet, minus the implied cash rental rate above.)
Landowner net return ($/acre) from lease over direct costs.
This is the implied cash rental rate above, minus the landowner's contribution per acre on the landowner sheet.
Print All Information
Please host the converted page in server to use Print All.