Greenfields Feedlot DCF Model Template
This 20-Year, 3-Statement Greenfields Feedlot DCF Model Template in Excel includes revenue streams from Research & Development through to Precision Medicine, cost structures, and financial statements, Discounted Cash Flow (DCF) with Terminal Value, Sensitivity Analysis, and WACC to forecast the financial health of your Feedlot.
20-Year Financial Model for a Greenfields Feedlot
This very extensive 20 Year Greenfields Feedlot Model carries a highly integrated framework. It captures the dynamic biological realities of cattle growth, grain commodity market volatility, and heavy initial capital intensity. Includes: 20x Income Statements, Cash Flow Statements, Balance Sheets, CAPEX sheets, OPEX Sheets, Statement Summary Sheets, and Revenue Forecasting Charts with the revenue streams, BEA charts, sales summary charts, employee salary tabs and expenses sheets.
Core Driver & Operational Assumptions
Before the financial statements can function, the model relies on several key inputs:
Static Capacity & Turnover: Total One-Time Capacity (e.g., 20,000 head) and Turnover Rate (typically 2.0x to 2.5x per year, translating to ~40,000–50,000 total cattle finished annually).
Biological Metrics: Entry Weight (e.g., 600–750 lbs), Target Out-weight (e.g., 1,350–1,450 lbs), Average Daily Gain (ADG, typically 3.2–3.8 lbs/day), Days on Feed (DOF, typically 150–180 days), and Mortality Rate (typically 1.0%–1.5%).
Feed & Conversion Metrics: Dry Matter Intake (DMI), Feed Conversion Ratio (FCR, e.g., 6:1 ratio of feed to gain), and Diet Costs (as-fed vs. dry-matter basis).
Business Model Structure: Indicates whether the operation is Owned Cattle (buying feeders, taking full market risk, and selling finished cattle) or Custom Feeding/Yardage (charging third parties a daily yardage fee per head plus a markup on feed). The model below assumes an Owned Cattle model with secondary custom feeding.
Detailed Capital Expenditure (CAPEX) Architecture
A greenfield project requires establishing all physical infrastructure from raw land. CAPEX is categorized into distinct operational asset classes:
Purchase of Feeder Cattle (Biological Working Capital/Initial Asset)
Initial Placement Stock: Purchase of initial feeder calves (e.g., 600–750 lbs steers/heifers) to fill pens during the initial ramp-up phase.
Freight & Sourcing Logistics: Inbound trucking costs, buyer commissions, and pre-placement transit insurance.
Building of Livestock Areas (Pens & Yards)
Site Preparation & Earthworks: Heavy earthmoving, laser leveling, creating 2%–4% pen slopes for drainage, building mounds for heat/mud management, and alleyways.
Fencing & Gates: Heavy-duty steel post and pipe/cable pen perimeter fencing, sorting gates, and latching mechanisms designed for high cattle pressure.
Bunk & Apron Infrastructure: Continuous poured-concrete feed bunks along alleyways and concrete aprons (typically 8–10 ft wide) behind bunks to prevent mud build-up where cattle stand to feed.
Feed Infrastructure
Commodity Barns & Commodity Bays: Concrete-walled bays for storing dry commodities (distillers grains, canola meal, cottonseed) and bulk roughage (alfalfa, corn silage).
Grain Storage Silos: Vertical steel silos or bins for storing raw whole grain (corn, barley, or wheat) with aeration systems.
Liquid Storage Infrastructure: Heated tanks and pumping systems for liquid micro-ingredients (tallow, molasses, moisture blocks).
Water Systems
Water Sourcing & Storage: Deep-water wells, high-capacity pumps, raw water storage tanks/lagoons, and commercial water rights acquisition.
Distribution Network: Trenching and installation of frost-free, high-flow underground distribution lines to all pens.
Troughs & Heating: Concrete or continuous-flow water troughs shared between pens, fitted with automatic float valves and geothermal/electric heaters for freeze prevention.
Handling Facilities & Animal Health
Processing & Induction Barn: Fully covered, climate-controlled facility housing hydraulic squeezes, automatic sorting gates, weigh scales, and electronic ID (EID) readers.
Hospital & Recovery Yards: Dedicated low-stress quarantine pens equipped with shaded areas, specialized watering, and separate treatment squeezes.
Scale House & Receiving Yards: Commercial truck scale platform, loading/unloading ramps, and holding pens designed for swift intake and outbound shipping.
Feed Mill Construction
Processing Equipment: High-capacity steam flaker or tub grinder/roller mill, steam chests, boilers, and surge bins.
Batching & Mixing Systems: Computerized micro-ingredient batching systems, vertical/horizontal mixers, and drop hoppers.
Feed Delivery Fleet: High-capacity mixer trucks or tractor-pulled mixer wagons equipped with integrated real-time scale systems.
Environmental & Waste Infrastructure
Effluent & Runoff Control: Sedimentation basins to trap solids, clay-lined or synthetic-lined runoff holding ponds, and diversion channels compliant with environmental regulations.
Manure Management System: Concrete manure stacking pads, composting yards, and heavy machinery (wheel loaders, spreaders, scrapers).
Income Statement (Profit & Loss)
The Income Statement details the operational revenues and expenses generated over a specific accounting period.
Gross Revenue
Finished Cattle Sales: Revenue from selling fat cattle to beef processors on a live weight, dressed weight, or grid-pricing basis.
Custom Feeding / Yardage Fees: Fees collected from third-party producers for pen space (e.g., daily per-head rate).
Feed & Processing Markups: Revenue generated by applying a margin over cost on delivered feed rations, processing treatments, and vet services to custom clients.
By-Product Revenue: Sales of composted manure to local crop farms.
Cost of Goods Sold (COGS)
Feeder Cattle Purchase Cost: The single largest expense; the original cost of purchasing feeder calves.
Feed Grain & Commodity Costs: Purchase of corn, distillers grains, silage, hay, supplements, and processing additives.
Inbound Freight & Animal Sourcing: Transportation charges to move cattle and raw commodities to the yard.
Veterinary & Processing Supplies: Vaccines, parasiticides, implants, antibiotics, and tagging supplies used upon arrival and during stay.
Death Loss Expense: Cost recognition of animal mortality based on historical and modeled death percentages.
Gross Profit
Calculated as Total Gross Revenue minus Total COGS.
Operating Expenses (OPEX)
Direct Mill & Yard Labor: Wages, overtime, and benefits for pen riders, mill operators, yard mechanics, and processing teams.
Equipment Maintenance & Fuel: Diesel, oil, and repair expenses for feeding trucks, loaders, tractors, and scraping equipment.
Mill Utilities: Electricity, natural gas, or propane required for operating steam boilers, flakers, and mixers.
Administrative & Overhead: Office staff salaries, accounting, legal fees, IT, software subscriptions (e.g., bunk management software), and insurance (property, casualty, and livestock).
Environmental & Compliance Fees: Soil testing, water quality monitoring, environmental permitting, and waste management overhead.
EBITDA (Earnings Before Interest, Taxes, Depreciation, and Amortization)
Calculated as Gross Profit minus Operating Expenses.
Below-the-Line Items
Depreciation & Amortization: Non-cash expense tracking the wear-and-tear of mill machinery, concrete work, trucks, fencing, and water systems.
Interest Expense: Interest paid on long-term debt (construction loans, mortgage on real estate) and revolving operating lines of credit used to fund cattle inventory.
Tax Expense: Corporate income taxes based on local tax rates.
Net Income
Calculated as EBITDA minus Depreciation, Interest, and Tax Expense.
Greenfields Feedlot Cash Flow Statement
The Cash Flow Statement translates accrual accounting into cash reality. This is critical for feedlots because timing mismatches between purchasing feeder cattle and receiving cash upon fat cattle sale can create severe liquidity gaps.
Cash Flow from Operating Activities
Net Income: Starting point from the Income Statement.
Non-Cash Adjustments: Adding back non-cash Depreciation & Amortization expenses.
Changes in Working Capital:
(Increase)/Decrease in Cattle Inventory: Cash outlay required to purchase feeder cattle cohorts.
(Increase)/Decrease in Commodity Inventory: Cash tied up in bulk purchases of grains/silage stored in silos and bays.
(Increase)/Decrease in Accounts Receivable: Cash uncollected from custom feeding clients or meat packers.
Increase/(Decrease) in Accounts Payable: Deferred payments to grain suppliers, feed dealers, or utility providers.
Cash Flow from Investing Activities
Initial Greenfield CAPEX Outlay: Heavy cash outflows during the build phase for land purchase, civil earthworks, livestock pens, feed mill construction, water systems, handling facilities, and environmental infrastructure.
Sustaining/Maintenance CAPEX: Ongoing cash spent replacing worn-out feed trucks, loaders, pumps, and pen maintenance.
Cash Flow from Financing Activities
Equity Injections: Capital contributed by sponsors, private equity, or project owners to fund initial construction.
Senior Construction Loan Draws: Cash inflows from bank loans used to build physical infrastructure.
Revolving Operating Line of Credit (Draws/Repayments): Short-term debt capital drawn to purchase cattle and feed inventory, then repaid upon cattle sale.
Debt Service (Principal Repayments): Scheduled principal payments on long-term infrastructure and real estate debt.
Distributions/Dividends: Cash paid back to equity investors once debt covenants and liquidity requirements are satisfied.
Net Change in Cash
The sum of Operating, Investing, and Financing Cash Flows, which updates the Cash Balance on the Balance Sheet.
Greenfields Feedlot Balance Sheet
The Balance Sheet provides a snapshot of the feedlot’s financial standing at any specific point in time.
Current Assets
Cash and Cash Equivalents: Liquid funds held in bank accounts for emergency working capital.
Accounts Receivable: Outstandings due from meatpackers for delivered cattle or billed custom-feeding clients.
Livestock Inventory: Value of growing feeder cattle currently in pens, valued at historical purchase price plus capitalized cost of gain (feed/processing costs incurred to date).
Feed & Commodity Inventory: Dollar value of stored corn, silage, supplements, and micro-ingredients on site.
Prepaid Expenses: Upfront payments for facility insurance, leases, or pre-bought grain futures/options contracts.
Non-Current Assets (Fixed Assets)
Land: Acquisition cost of raw acreage where the facility sits.
Property, Plant & Equipment (PP&E): Gross value of built infrastructure (Pens, Water Systems, Feed Mill, Commodity Sheds, Handling Barns, Lagoons).
Less: Accumulated Depreciation: Net reduction in value of PP&E assets over time.
Net Property, Plant & Equipment: Gross PP&E minus Accumulated Depreciation.
Current Liabilities
Accounts Payable: Short-term money owed to grain farmers, veterinary supply vendors, and fuel distributors.
Revolving Operating Line of Credit: Outstanding balance on working capital debt used to purchase biological assets and feed.
Accrued Expenses: Unpaid wages, interest accrued on loans, and utility charges owed but not yet billed.
Current Portion of Long-Term Debt: Principal debt payments due within the next 12 months.
Non-Current Liabilities
Long-Term Debt / Term Loans: Principal balance remaining on bank loans used to build the greenfield infrastructure (excluding the current 12-month portion).
Deferred Tax Liabilities: Tax obligations deferred through accelerated depreciation methods on equipment and structures.
Shareholders’ Equity
Contributed Capital: Total initial cash invested by owners/sponsors to fund land, CAPEX, and initial operations.
Retained Earnings: Cumulative net income generated by the feedlot over time, minus any dividends or equity distributions paid out to owners.
Greenfields Feedlot CAPEX Schedule (The Build)
This is the initial cash outlay before cattle arrive. All costs include labor, materials, and professional fees, phased over the construction timeline.
Land Acquisition & Earthworks:
Cost per acre for purchase.
Grading and drainage installation to manage rainfall runoff.
Livestock Areas (Pens & Bunklines):
Concrete apron installation around feed bunks.
Fencing (pipe or cable) and shade structures.
Allocation: Cost per head of capacity (e.g., $600/head for a 10,000-head yard).
Feed Infrastructure (The Mill & Storage):
Grain receiving pits and legs (elevators).
Roller mills or steam-flaking equipment.
Vertical or horizontal feed mixers.
Ingredient Bins: Silos for high-moisture corn, supplement tanks for liquid molasses, and commodity sheds for hay/straw.
Water Systems:
Deep-water bore drilling and pumping stations.
Mainline PVC piping to each pen.
Water troughs (automatic fill valves).
Critical: Lagoon systems or holding dams for effluent/wastewater management.
Handling Facilities (The “Working” Chutes):
Squeeze chutes, hydraulic or manual.
Curved crowd pens and loading ramps.
Scales (platform and digital readouts) for weighing cattle in/out.
Environmental Infrastructure (EPA Compliance):
Runoff diversion berms.
Settling basins and anaerobic lagoons (lined to prevent groundwater contamination).
Composting pads for deadstock management.
Support Buildings:
Office, staff amenities, workshop, and veterinary clinic.
Contingency: A 15% buffer added to total hard costs for unforeseen site issues.
Value Your Greenfields Feedlot With A DCF
Discounted Cash Flow: Feedlot Timeline
This Discounted Cash Flow (DCF) model values a greenfield feedlot—a newly constructed cattle-fattening facility built from scratch—by projecting its future free cash flows and discounting them back to their present value. For a greenfield project, the timeline begins with a large initial capital expenditure layout for land acquisition, yard design, pen construction, and water/waste infrastructure, often followed by multi-year cash outflows or thin margins as operations ramp up. Once the facility achieves optimal capacity, cash flows are driven by revenues from feeder cattle sales or custom feeding fees, minus operating expenses like grain/forage feed costs, labor, veterinary supplies, and ongoing maintenance. Because greenfield assets lack historical financial performance, the DCF relies heavily on bottom-up operational assumptions—such as average daily gain (ADG), feed conversion ratios, and mortality rates—to map out the long-term path to profitability.
WACC: Pricing Your Feedlot
The Weighted Average Cost of Capital (WACC) serves as the discount rate in the DCF model, representing the minimum required rate of return that both debt holders and equity investors expect for financing the project. For a greenfield feedlot, WACC is typically higher than that of an established agricultural asset to reflect the substantial execution risk, construction delays, and ramp-up uncertainty inherent in a brand-new facility. The cost of equity component factors in high asset volatility driven by commodity price swings, while the cost of debt reflects the risk premium lenders demand on unproven operations. A higher WACC heavily discounts distant cash flows, emphasizing the need for the greenfield feedlot to quickly reach commercial scale and generate early operating cash flow to justify its initial investment.
Sensitivity Analysis: Feedlot
Sensitivity analysis stress-tests the DCF valuation by systematically altering key financial and operational inputs to evaluate their impact on Net Present Value (NPV) and Internal Rate of Return (IRR). In a feedlot context, performance is exceptionally sensitive to volatile market variables, particularly the “crush margin”—the spread between feeder cattle purchase prices, finished cattle sale prices, and corn/feed costs. Analysts typically construct sensitivity matrices adjusting these commodity spreads alongside occupancy rates (utilization) and WACC. By isolating these key variables, sensitivity analysis reveals the feedlot’s breakeven thresholds, highlights operational risk limits (such as a sudden spike in feed costs), and helps investors determine whether the greenfield project maintains a margin of safety under adverse agricultural cycles.
Final Notes on the Financial Model
This 20 Year Greenfields Feedlot DCF Model Template captures Livestock Inventory—New Stock, Cost Per Head, within this enterprise. Early-stage losses are driven by intentional investment, while long-term value emerges through scalable growth.
Download Link On Next Page