Feed Fed Purchases
- Monthly Feed Fed Record – September to August PDF Description
- Monthly Feed Fed Record – September to August Excel Spreadsheet
- Hay Value Based on Chemical Analysis – Protein Cost PDF Description
- Hay Value Based on Chemical Analysis – Protein Cost Excel Spreadsheet
- Monthly Purchased Feed Record PDF Description
- Monthly Purchased Feed Record Excel Spreadsheet
- Annual Reconciled Feed Inventory PDF Description
- Annual Reconciled Feed Inventory Excel Spreadsheet
User Manual for Monthly Feed Inventory
Hay and Grazing
- Hay Produce or Purchase and Hay Loss Calculator Excel Spreadsheet
- Grazing and Hay Budget Excel Spreadsheet
- Fencing Cost Estimator PDF Description
- Fencing Cost Estimator Excel Spreadsheet
- Hay Harvest Custom Hire Versus Ownership Cost Evaluator PDF Description
- Custom Hay Hire Versus Ownership Example Excel Spreadsheet
- Custom Hay Hire Versus Ownership Blank Excel Spreadsheet
Cow-Calf Grazing Lease Economic Evaluation and Production Records
- Cow-Calf Grazing Lease Economic Evaluation of Alternatives PDF Description
- Cow-Calf Grazing Lease Records to Measure Productivity, Income and Costs PDF Description
- Owner Land Inventory and Land Productivity – Owned and Leased Excel Spreadsheet
- Description of Leased Land and Lessee Cost Excel Spreadsheet
- Total Leased Ranch Lessor Income Calculator Excel Spreadsheet
- Lessee Grazing Acre or AUM Cost Calculator Excel Spreadsheet
- Grazing Lease Responsibilities Checklist For Owner and Lessee Example Excel Spreadsheet
- Grazing Lease Responsibilities Checklist For Owner and Lessee Blank Excel Spreadsheet
- AUM Monthly Lease Payment Data Excel Spreadsheet
- AUM Monthly Lease Payment Data with AUM Calculation Excel Spreadsheet
- AUM Grazing Lease Monthly and Annual Record Excel Spreadsheet
- AUM Grazing Lease Monthly and Annual Record Blank Excel Spreadsheet
- Monthly Cattle Inventory & AMU Lease Calculated Excel Spreadsheet
- Blank Cattle Inventory Based Lessee Record
- 400 Cattle Head Inventory Based Lesse Record
- Fertilizer Price and Use Cost Calculator PDF Description
- Fertilizer and Lime Nutrients Price Calculator Example Excel Spreadsheet
- Fertilizer and Lime Nutrients Price Calculator Blank Excel Spreadsheet
- Fertilizer Cost Calculator Example Excel Spreadsheet
- Fertilizer Nutrient Cost Calculator Example Excel Spreadsheet
- Coastal by Pounds of Fertilizer Cost Calculator Example Excel Spreadsheet
- Fertilizer Cost Calculator Example Excel Spreadsheet Blank Excel Spreadsheet
Grazing Economics Decision Aids:
Grazing Land Inventory Owned, Leased and Lease Check List
Grazing Lease Price and Economic Evaluator
Acre Based Lease Record Measuring Production Income
AUM Based Lease Record Measuring Production and Income
Lessee Cattle Inventory Based Grazing Lease Record
Lessee Cattle Inventory Based Lease Monthly and Annual Record
Land Owner Lease Description by Tenant and Net Income
Grazing Land Record of Fertilizer, Herbicide and Pesticide Use
Fertilizer Price of Alternatives and Cost Calculator
Labor and Management
Vehicle and Freight Cost
- Vehicle or Pickup Cost Calculator PDF Description
- Vehicle or Pickup Cost Calculator Excel Spreadsheet
- Pickup, Trailer and Freight Cost Calculator PDF Description
- Pickup, Trailer and Freight Cost Calculator Excel Spreadsheet
- Vehicle Replacement Plan Excel Spreadsheet
Vehicle Mileage, Fuel Use and Costs
Preconditioning Profitability Decision Aid
- Evaluating Preconditioning Profitability – User Manual
- Raised Calf Preconditioning Profit Projection Calculator Excel Spreadsheet
- Purchased Calf Preconditioning Profit Projection Calculator Excel Spreadsheet
- Vac 24 – 34 -45 Raised Calf Preconditioning Profit Projection Calculator Excel Spreadsheet
- Preconditioning Health and Feed Cost Calculator Excel Spreadsheet
- Preconditioned Cattle Price-Weight Slide Calculator Excel Spreadsheet
- Preconditioning Facilities or Grow Yard Cost Calculator PDF Description
- Preconditioning Facilities or Grow Yard Cost Calculator Excel Spreadsheet
- Hired Labor or Management Cost Calculator PDF Spreadsheet
- Hired Labor or Management Cost Calculator Excel Spreadsheet
- Pickup, Trailer and Freight Cost Calculator PDF Description
- Pickup, Trailer and Freight Cost Calculator Excel Spreadsheet
Projection:
Closeout:
Supporting Spreadsheets:
Developing Financial Statements to Measure Ranch Profitability
- Steps to Take IRS Tax Conversion to Managerial Financial Statements PDF Description
- Ranch Financial Statements and Cattle Performance Reporting PDF Description
- Measuring Financial Profit is Beyond IRS Tax Reporting PDF Description
- Herd Size and Financial Report Preparation for Cow Calf Producers PDF Description
- Increasing Ranchers’ Financial Management Information PDF Description
- Grain Farm Steps to Follow to Prepare Financial Statements PDF Description
- Measuring Farm Financial Profit is Beyond Cash Tax Reporting PDF Description
- Grain Farm IRS Tax Compliance to Accrual Adjusted Financial Statements PDF Description
- Grain Farm Schedule F Financial State. TUC Example Excel Spreadsheet
- Grain Farm Schedule F Financial State. TUC Blank Excel Spreadsheet
- Ranch of Farm Business or Personal Balance Sheet Preparation and Loans PDF Description
- Loan Description Example Excel Spreadsheet
- Loan Description Blank Excel Spreadsheet
- The Ranch or Farm Business Balance Sheet and Loans Example Excel Spreadsheet
- The Ranch or Farm Business Balance Sheet and Loans Blank Excel Spreadsheet
- The Personal or Family Balance Sheet and Loan Example Excel Spreadsheet
- The Personal or Family Balance Sheet and Loans Blank Excel Spreadsheet
- Ranch Management Objectives and Goals
- Strategic Ranch Management and Planning
- Business Manager Evaluating Alternatives
- Measuring Profitability is Beyond Tax Cash Reporting
- Five Activities to Measure Farm-Ranch Profitability
- Ranch MIS Capabilities Checklist
- You Manage What You Measure
- Secrets to Success – Investors Business Daily
- Management Notes – Reminder of Reality
- Beef Cattle Information References and Decision Aid Sources
- IRS Schedule F’s Cash Reporting Use for Preparation of Ranch Financial Statements and Performance Information
- Financial Statement Basics
Ranch Financial Statements to Measure Profit is Beyond IRS Tax Reporting
Steps to Take IRS Tax Conversion to Managerial Financial Statements
Increasing Ranchers’ Financial Management Reporting
User Guide Addressing Additional Data Needs for Preconditioning Retained Ownership
User Guide Addressing Additional Data Needs for Feeder Cattle Retained Ownership
Ranch Owner Family Living Expenses/Withdrawals Accounting
User Guide IRS Schedule F to Financial Statements no Production Benchmarks
Grain Farm Steps to Follow to Prepare Financial Statements
Cow-Calf Ranch Data Generating Spreadsheets
QuickBooksPro™ Setup for a Ranch
Accrual Adjustments to IRS Schedule F Recording Sheet
Cow-Calf Sales by Category of Cattle
Cattle and Horse Beginning and Ending Annual Inventory
Standardize Performance Analysis (SPA) Herd Reproduction and Production Data
Cow-Calf Herd Production, Sales, Death Loss and Transfer Data
Feed Beginning and Ending Inventory
Capital Asset Recovery to Replace IRS Depreciation for Cost Calculation
Ranch of Farm Business or Personal Balance Sheet Preparation and Loans
Supporting Publications
Grassfed Beef Accounting, Profit Projection and Closeout
- Grassfed Beef Ranch QuickBooks™ Setup Accounts PDF Description
- Grassfed Beef Profit Projection and Closeout PDF User Manual
- Grassfed Profit Projection Live Sales Excel Spreadsheet
- Grassfed Profit Projection Live, Carcass or Meat Sales Excel Spreadsheet
- Grassfed Beef Live or Carcass Closeout Performance Excel Spreadsheet
- Grassfed Beef Meat Sales Closeout Performance Excel Spreadsheet
Standardized Performance Analysis (SPA) Reproduction, Production and Grazing Calculations
- SPA Reproduction Critical Dates, Data and Calculations User Manual
- SPA Reproduction Critical Dates, Data and Calculations Excel Spreadsheet
- SPA Reproduction, Grazing, Feed Use and SPA Calculations User Manual
- SPA Reproduction, Grazing, Feed Use and SPA Calculations Excel Spreadsheet
- Reproduction & Calving Distribution Calculator Example Excel Spreadsheet
- Reproduction & Calving Distribution Calculator Blank Excel Spreadsheet
Capital Asset Replacement Calculator to Replace IRS Depreciation
- Capital Asset Replacement Calculator to Replace IRS Depreciation PDF Description
- Capital Asset Replacement Vehicles, Machinery, Improvement and Breeding Stock Excel Spreadsheet
- Capital Asset Replacement Vehicles, Machinery, Equipment. Improvement Excel Spreadsheet
- Non-cattle Depreciation Schedule Data Update Record Excel Spreadsheet
- Herd Bull Depreciation Schedule Data Update Record Excel Spreadsheet
- Breeding Cow and Replacement Heifer Depreciation Schedule Data Update Record Excel Spreadsheet
IRS Depreciation Schedule Data Record
Cattle Sales Record and Net Price Calculations
- Cow-Calf Ranch Cattle Sales Data Summary and Net Price Calculations PDF Description
- Cow-Calf Ranch Cattle Sales Data Summary and Net Price Calculations Excel Spreadsheet
- Purchases Cattle for Resale, Sales and Transfer Record and Net Price Calculations PDF Description
- Purchases Cattle for Resale, Sales and Transfer Record and Net Price Calculations Excel Spreadsheet
- Owned Pickup and Trailer or Contract Freight Cost Calculator PDF Description
- Owned Pickup and Trailer or Contract Freight Cost Calculator Excel Spreadsheet
- Replacement Heifer Sales Record Summary and Net Price Calculations PDF Descriptions
- Replacement Heifer Sales Record Summary and Net Price Calculations Excel Spreadsheet
- Cow-calf to Finished Raised and Purchased Sales Record Excel Spreadsheet
- Cattle Net Sales Calculator Example Excel Spreadsheet
- Cattle Net Sales Calculator Blank Excel Spreadsheet
*Disclaimer: These spreadsheets are provided by Texas A&M AgriLife Extension for educational use and solely on an “AS IS” basis. Texas A&M AgriLife Extension assumes no liability for the use of these programs.