# Farm Model Build a farm financial model with multi-crop rotation cycles, livestock lifecycle management, seasonal cash flow mechanics, and equipment capex. Designed for farm managers, agribusiness investors, and lenders. - Canonical: https://finamodel.com/templates/farm-model - Excel download: https://finamodel.com/templates/farm.xlsx - Category: Agriculture - Model type: Operating model - Difficulty: Intermediate - Audiences: Developers & sponsors, Founders & operators, Farmers, Agricultural lenders, Commodity traders, Land investors - Tags: farm, agriculture, commodity, yield, hedging ## Overview A livestock grazing operation model projects cash flows from a 5,000-hectare Australian beef and sheep property operating at 8 dry sheep equivalents (DSE) per hectare, supporting 1,200 breeding cattle and 4,500 breeding ewes. Revenue comes from three commodity streams: beef sales (steers at 450 kg live weight, 54% dressing percentage, $6.50/kg carcass), lamb sales (24 kg carcass weight, $7.50/kg), and wool (4.5 kg greasy fleece, 70% clean yield, $12/kg clean). The critical constraint is the carrying capacity of pasture: herd growth is physiologically limited and any excess animals trigger forced culls or agistment. Variable costs are modest for a pasture-based operation (supplementary feed only 60 days/year during drought or winter, at $350/tonne). Labor is the dominant opex (1 FTE per 2,000 head), plus fuel, repairs, insurance, rates, and administration. The model applies a realistic balance sheet: land at $4,000/hectare ($20m), PP&E at $3.5m, and opening debt of $10m (40% LVR mortgage on land, 70% equipment loan). Debt service consumes 40–50% of EBITDA in early years, improving as the operation scales and achieves 25–40% EBITDA margins at maturity. This template answers: what is the normalized cash-generating capacity of a grazing property? What debt service can it support? This model is calibrated for rural investors, farm advisors, and institutional agricultural funds evaluating pastoral asset purchases. ## What's included - Dynamic crop cycle and yield sensitivity modelling - Livestock herd growth and feed conversion tracking - Seasonal working capital and cash flow mapping - Equipment capex and depreciation schedules - Integrated P&L, balance sheet, and cash flow outputs - Crop acreage and type breakdown - Yield assumptions by crop and historical ranges - Commodity pricing: forward contract prices, hedging, and exposure analysis - Input costs: seed, fertilizer, pesticide, labor, equipment, and repairs - Operating expenses: land lease, insurance, interest, and depreciation - Profitability by crop and whole-farm contribution margin ## Farm Model: How Livestock, Land and Debt Interact This farm model is a three-statement financial template for a pasture-based Australian cattle and sheep grazing property. It links herd dynamics, land carrying capacity, seasonal costs and debt schedules to project cash flows and balance sheet outcomes over five years. The explanation below focuses on the operating drivers and calculation flow that determine those outputs. ### What drives the herd and biological asset value The model's biological engine starts with the property's carrying capacity in Dry Sheep Equivalents, calculated as farm size in hectares multiplied by DSE per hectare. This sets a maximum herd size. - Cattle and sheep numbers roll forward each year from opening head counts using births, sales, deaths and a forced cull. Cattle births in year one come from opening breeders multiplied by a weaning rate; from year two onward births use the prior year's closing breeder count, not a static opening figure. - Sheep follow a similar pattern. When total DSE exceeds the cap, a forced cull row removes the excess, preventing biologically impossible herd growth. Closing breeder numbers also set the biological asset value on the balance sheet, which is separate from working capital. ### How revenue and costs are calculated Revenue is built from physical animal numbers and market prices, never from a smooth growth percentage. Cattle revenue equals head sold multiplied by average live weight, dressing percentage and beef price per kilogram of carcass weight. - Lamb revenue uses head sold, carcass weight and lamb price. Wool revenue uses the average of opening and closing sheep numbers, fleece weight, clean yield and wool price. - Cost of goods sold includes supplementary feed, veterinary costs, shearing, transport and saleyard commission. Supplementary feeding is a winter or drought top-up calculated as total head multiplied by feeding days per year, daily intake and feed price per tonne; feeding days default to 60, reflecting a pasture-based system where pasture supplies most nutrition. Operating expenses such as labour, fuel, repairs, rates, insurance and administration are then deducted to reach EBITDA. ### How the debt schedule and cash flow work All debt is pre-existing at day zero, so the cash flow statement shows only principal repayments, never drawdowns. The land mortgage amortises over 25 years at a fixed rate, and the equipment loan over seven years. - A seasonal overdraft is drawn when free cash flow before overdraft is negative and repaid when positive. Interest is calculated on opening debt balances to avoid circular references. - The cash flow statement uses the indirect method, adding back depreciation to net income and adjusting for changes in receivables, inventory and payables. Biological asset fair value movements are excluded; only cash from actual animal and wool sales is recognised. Capital expenditure includes maintenance at a percentage of opening property, plant and equipment plus modest growth spending, while land value is held constant with no appreciation assumed. ### What the model outputs and how to use it The model produces an income statement, balance sheet and cash flow statement for each of five years, together with a checks sheet. Key outputs include EBITDA, net income, operating cash flow, free cash flow and debt service coverage ratio. - Validation checks confirm that the balance sheet balances, herd reconciliations sum to zero, the DSE cap is respected, cash remains non-negative, the mortgage declines and the DSCR stays above its covenant. Opening retained earnings are calculated from opening assets and liabilities rather than hardcoded. - Users can change named assumptions such as weaning rates, feeding days, prices and interest rates to test how the operation responds to different seasons or market conditions. The model is designed for evaluating an acquisition or operating plan, not for live trading. ## Built for agricultural operations Use this model when crop cycles, seasonal cash flow, and land utilisation drive the financial outcome of the farming business. ## Handles the complexity of farm economics A useful farm model connects planting-to-harvest timelines, variable yields, and heavy seasonal cash demands so the full operating picture is visible. ## Better for loan applications and planning This gives you bank-ready projections with proper seasonal cash flow visibility instead of a generic annual forecast that misses the agricultural rhythm. ## Built for agricultural operations Use this model when crop cycles, seasonal cash flow, and land utilisation drive the financial outcome of the farming business. ## Handles the complexity of farm economics A useful farm model connects planting-to-harvest timelines, variable yields, and heavy seasonal cash demands so the full operating picture is visible. ## Better for loan applications and planning This gives you bank-ready projections with proper seasonal cash flow visibility instead of a generic annual forecast that misses the agricultural rhythm. ## Features - **Yield and crop planning:** Model crop rotation, soil health, and insurance coverage to optimize yields and manage crop risk. - **Commodity price hedging:** Model forward contracts and futures hedges to lock in prices and reduce revenue volatility. - **Input cost and labor scheduling:** Budget seasonal input purchases and labor to manage cash flow and operational efficiency. ## Use cases - **Farmland investment underwriting:** Model net farm income to justify land acquisition and debt financing by lenders. - **Crop insurance and risk management:** Forecast yield and revenue risks, then model insurance coverage and hedging programs. - **Succession and expansion planning:** Model adding acreage, new crops, or livestock to project profitability and capital needs. ## Frequently asked questions ### What is a farm financial model? It is a model that forecasts crop and livestock revenue, input costs, seasonal working capital needs, and equipment investment for commercial farming operations. ### Who uses farm financial models? Farm managers, agribusiness investors, commercial lenders, and agricultural consultants use them for planning, lending, and investment decisions. ### What should a farm model include? It should include crop cycle assumptions, yield sensitivity, livestock tracking, seasonal cash flow mapping, equipment capex, and integrated financial statements. ### Does it handle crop rotation? Yes. The model includes a land use schedule where you can toggle acreage between different crops across multi-year horizons. ### Can I model both owned and leased farmland? Yes. The model supports owned land with mortgage tracking alongside cash-rent or crop-share lease agreements. ## Related templates - [Livestock Operation Model](https://finamodel.com/templates/livestock-model) - [Food Manufacturing Model](https://finamodel.com/templates/food-manufacturing-model) - [Timber REIT Model](https://finamodel.com/templates/timber-model)