formualizer

Excel workbook · Catalog edition 2026

Kansas State 2026 Crop Budgets and Flexible Leases

Kansas State University Department of Agricultural Economics (AgManager.info)

Compare Kansas crop revenue, production costs, net returns and break-even prices, and estimate cash, crop-share and price-flex lease returns.

Inputs
18
Outputs
11
File size
383 KB
Verification
Independent scenario check

Try it

Try it loads a copy of this file from formualizer.com.

BudgetsB14:AA69

Saved workbook valuesInputOutput

RowBCEFIVZ
14BudgetOverrideOverride
15Tenant %Corn - North Central KS_Per Acre Tillable$ Tenant
16*120
17$4.57548.40361.94
19<Total Revenue>$548.40$548.40$361.94
22Seeds76.8076.8076.80
23Fertilizer (less lime)*105.06105.0669.34
58Cash rent ( $ / acre )$70.0070.0070.00

What was checked

Changed-input scenarios match an independent calculation.

Scope and limitations

Catalog calculations, not certification.

Try it uses Formualizer formulas that read crop labels from the corresponding rows and turn blank second-crop totals into zeros.

  • The source caches are stale: default corn price is now 4.72 rather than cached 4.57, and operating interest is 7.6% rather than cached 6.5%.
  • Full mapping supports two crop slots; remaining slots and granular expense overrides are available only through cellOverrides. Historical stochastic simulation summaries and solver sensitivity grids are not recalculated.
  • Legacy Table1 current-row references are rewritten to the identical current-row column A coordinate at runtime; inactive second-crop display blanks are normalized with N().

What it computes

Ports for the compact flow: quick_crop_lease_return. The full port contract includes all 29 ports.

Inputs (12)
Port / descriptionType / constraints / default
crop_1

Exact publisher budget name; trailing underscore is significant Default: Corn - North Central KS_.

Type: string

Constraints: one of: None, Alfalfa - Northwest KS_, Alfalfa - Southeast KS_, Alfalfa - Southwest KS_, Alfalfa - Western KS_Irrigated, Canola - South Central KS_, Canola - Southwest KS_Irrigated, Corn - North Central KS_, Corn - North Central KS_Irrigated, Corn - Northeast KS_, Corn - Northwest KS_Irrigated, Corn - Northwest KS_W-C-F rotation, Corn - South Central KS_, Corn - South Central KS_Irrigated, Corn - Southeast KS_, Corn - Southwest KS_Irrigated, Corn - Southwest KS_W-C-F rotation, Corn Silage - Northeast KS_, Cotton - South Central KS_, Cotton - Southeast KS_Irrigated, Cotton - Southwest KS_Irrigated, Cotton - Southwest KS_W-CT-F rotation, Forage Sorghum Hay - Western KS_W-H-F, Forage Sorghum Silage - South Central KS_, Grain Sorghum - North Central KS_, Grain Sorghum - North Central KS_Irrigated, Grain Sorghum - Northeast KS_, Grain Sorghum - Northwest KS_Irrigated, Grain Sorghum - Northwest KS_W-S-F rotation, Grain Sorghum - South Central KS_, Grain Sorghum - South Central KS_Irrigated, Grain Sorghum - Southeast KS_, Grain Sorghum - Southwest KS_Irrigated, Grain Sorghum - Southwest KS_W-S-F rotation, Soybeans - North Central KS_, Soybeans - North Central KS_Irrigated, Soybeans - Northeast KS_, Soybeans - Northwest KS_Irrigated, Soybeans - Northwest KS_W-SB_F rotation, Soybeans - South Central KS_, Soybeans - South Central KS_Irrigated, Soybeans - Southeast KS_, Soybeans - Southeast KS_Double crop, Soybeans - Southwest KS_Irrigated, Soybeans - Southwest KS_W-SB-F rotation, Sunflower (confectionary) - Double crop - Western KS_Irrigated - double crop, Sunflower (Confectionary) - Western KS_Irrigated, Sunflower (Confectionary) - Western KS_W-SF-F rotation, Sunflower (oil-type) - Central and Eastern_Double crop, Sunflower (oil-type) - Double crop - Western KS_Irrigated - double crop, Sunflower (oil-type) - Eastern KS_, Sunflower (oil-type) - Western KS_Irrigated, Sunflower (oil-type) - Western KS_W-SF-F rotation, Wheat - North Central KS_Continuous, Wheat - North Central KS_Rotation, Wheat - Northeast KS_Continuous, Wheat - Northeast KS_Rotation, Wheat - Northwest KS_W-F rotation, Wheat - Northwest KS_W-S_C-F rotation, Wheat - South Central KS_Continuous, Wheat - South Central KS_Rotation, Wheat - Southeast KS_, Wheat - Southwest KS_W-F rotation, Wheat - Southwest KS_W-S_C-F rotation, Wheat - Western KS_Irrigated, Wheat, Durum - Western KS_, Wheat, Durum - Western KS_Irrigated, None

Default: "Corn - North Central KS_"

crop_1_acres

Planted acres, positive acreage required Default: 1.

Type: number

Constraints: min: 0.01

Default: 1

yield_1

Yield override in crop units per acre (corn: bushels/acre); null retains publisher budget Default: None.

Type: number

Constraints: nullable: true; min: 0

Default: null

price_1

Selling price override in USD per crop unit; null retains budget Default: None.

Type: number

Constraints: nullable: true; min: 0

Default: null

cash_rent

USD per acre cash rent Default: 70.

Type: number

Constraints: min: 0

Default: 70

operating_interest_rate

Annual decimal fraction applied to half direct costs Default: 0.076.

Type: number

Constraints: min: 0; max: 1

Default: 0.076

tenant_share

Tenant crop share decimal fraction Default: 0.66.

Type: number

Constraints: min: 0; max: 1

Default: 0.66

seed_cost_1

Seed expense override USD/acre; null retains budget Default: None.

Type: number

Constraints: nullable: true; min: 0

Default: null

fertilizer_cost_1

Fertilizer expense override USD/acre; null retains budget Default: None.

Type: number

Constraints: nullable: true; min: 0

Default: null

lease_base_rent

USD/acre base rent for price-flex contract Default: 70.

Type: number

Constraints: min: 0

Default: 70

lease_base_price

USD/unit base price, must be positive Default: 5.5.

Type: number

Constraints: min: 0.01

Default: 5.5

lease_actual_price

USD/unit actual scenario price; deterministic single draw replaces Monte Carlo Default: 3.

Type: number

Constraints: min: 0

Default: 3

Outputs (6)
Port / descriptionType / constraints / default
crop_1_revenue

Gross crop revenue USD/planted acre

Type: number

crop_1_direct_cost

Direct expenses including interest USD/planted acre

Type: number

crop_1_total_cost

Total specified costs USD/planted acre

Type: number

crop_1_net_return

Signed return above specified costs USD/planted acre

Type: number

crop_1_breakeven_price

Breakeven USD/crop unit

Type: number

price_flex_rent

Price-flex landlord rent USD/tillable acre for supplied deterministic actual price

Type: number

Questions this workbook answers

  • Kansas State 2026 Crop Budgets and Flexible Leases
  • Compare farm lease returns
  • Evaluate farm investment cash flow

Questions and answers

What units do the inputs use?

USD per acre, bushels per acre and decimal fractions as documented in each port. Outputs preserve unrounded workbook values.

Does this execute Excel macros?

VBA never executes. Only the documented deterministic worksheet calculations and any explicit adapter run.

What are the model limitations?

Compare Kansas publisher crop budgets, cash/share returns and a deterministic price-flex lease scenario. Monte Carlo distributions and simulation summaries are excluded.

For agents

Connect an MCP client to the catalog endpoint:

https://catalog.formualizer.com/v1/mcp

Slug: ksu-crop-budgets-leasing · Edition: 2026

search_workbooks
Optional arguments: query (string), theme (string), tag (string).
inspect_workbook
Required: slug (string). Optional: edition (string), flow (string).
evaluate_workbook
Required: slug (string), inputs (object). Optional: edition (string), flow (string), cellOverrides (object), selectCells (array of strings), trace (boolean).
{
  "name": "evaluate_workbook",
  "arguments": {
    "slug": "ksu-crop-budgets-leasing",
    "edition": "2026",
    "flow": "quick_crop_lease_return",
    "inputs": {
      "crop_1_acres": 640,
      "yield_1": 150,
      "price_1": 5.1,
      "cash_rent": 100,
      "lease_actual_price": 6
    }
  }
}

cellOverrides sets individual cells. selectCells reads at most 256 cells per request. trace requests formula lineage.

Flows

quick_crop_lease_return

Quick crop lease return

12 input ports · 6 output ports. Full membership in the port contract.

full_crop_budget_comparison

Full crop budget comparison

18 input ports · 11 output ports. Full membership in the port contract.

REST example

Bundle scenario: quick_crop_lease_return_good_corn · Flow: quick_crop_lease_return

curl 'https://catalog.formualizer.com/v1/models/ksu-crop-budgets-leasing/2026/evaluate?flow=quick_crop_lease_return' \
  -H 'Content-Type: application/json' \
  --data '{"inputs":{"crop_1_acres":640,"yield_1":150,"price_1":5.1,"cash_rent":100,"lease_actual_price":6}}'

Expected response

Expected values from the bundle, subject to the check level above.

{
  "outputs": {
    "crop_1_revenue": 765,
    "crop_1_direct_cost": 370.43937483797316,
    "crop_1_total_cost": 528.2309514909955,
    "crop_1_net_return": 236.7690485090045,
    "crop_1_breakeven_price": 3.5215396766066367,
    "price_flex_rent": 76.36363636363636
  }
}

Looking for another spreadsheet? Request a workbook.