Overview and Description
- Cow-Calf Bid Price and Budgets
- Cow Bid Price [PDF description] [Excel spreadsheet]
- Cow-Calf Costs and Necessary Calf Price for Target ROA [PDF description] [Excel spreadsheet]
- Replacement Heifer Budgets
Replacement Cost and Returns Calculation Decision Aids
Commercial Bred Heifer Buyer’s Guide- Replacement Heifer Natural Service Budget
- Natural Service Projection [Excel spreadsheet]
- Natural Service Closeout [Excel spreadsheet]
- Bred Replacement Heifers Natural Service and Pairs [Excel spreadsheet]
- Conventional Artificial Insemination (AI) Heifer Budget
- AI Heifer Projection [Excel spreadsheet]
- AI Heifer Closeout [Excel spreadsheet]
- AI Heifer Contract Breeding Services [Excel spreadsheet]
- Replacement Heifer SPA Reproduction Performance
Replacement Heifer Critical Dates and Data- Heifer Data Collection [Excel spreadsheet]
- Replacement Heifer SPA Reproduction Calculator [Excel spreadsheet]
- Example Replacement Heifer SPA Reproduction Calculator [Excel spreadsheet]
- Replacement Heifer Budgeting Support Aids
- Feed and Grazing Cost Calculator [Excel spreadsheet]
- Replacement Heifer Purchase and Sales Record [PDF description] [Excel spreadsheet]
- Replacement Heifer Monthly Inventory – Hd. Days & AUMs [PDF description] [Excel spreadsheet]
- Indirect Cost Calculator
- Replacement Heifer Indirect Cost Calculator [Excel spreadsheet]
- IRS Based Ranch Direct and Indirect Costs [Excel spreadsheet]
- Replacement Females Marketing Alternatives and Auction Costs [PDF Description] [Excel Spreadsheets]
- Sexed Semen Artificial Insemination (AI) Heifer Budget
Sexed Semen Beef Cattle Breeding Decision Aid User Guide - Replacement Heifer Purchase and Sales Record [PDF description] [Excel spreadsheet]
- Cow-Calf Herd Age Distribution Calculator [Excel Spreadsheet] [Blank Excel Spreadsheet]
- Beef Cow Herd Replacements Requirement Calculator [PDF Description] [Excel Spreadsheet]
- Replacement Heifer Cleanup Bull Economics [PDF description] [Excel spreadsheet]
- Replacement Heifer Natural Service Budget
- Cow-Calf Budgeting and Herd Bull Investment
- Cow-Calf Budget [PDF description] [Excel spreadsheet]
- Bull Investment and Cost Analysis [PDF description] [Excel spreadsheet]
- Breeding Service Exam (BSE) [PDF Description] [Excel Spreadsheet]
- Bull Ownership or Lease Bull Cost [PDF Description] [Excel Spreadsheet]
- Cattle and Horse Beginning and Ending Fiscal Year Inventory by Category [PDF Description] [Excel Spreadsheet]
- Retained Ownership (cull cows, stocker/feeder and custom finish)
- Sell or Keep to Upgrade Cull Cows [PDF description] [Excel spreadsheet]
- Calves Stocker/Feeder Retained Ownership [PDF description]
- Stocker-Feeder Profit Projection Budget [Excel spreadsheet]
- Projected Profitability of Purchased Calves or stockers [Excel spreadsheet]
- Calculated Total Cattle, Feedings Costs and Net Margin [Excel spreadsheet]
- Calves, Stocker/Feeder and Health Feeding Cost Calculator [Excel spreadsheet]
- Value of Gain Calculator [Excel spreadsheet]
- Stocker Closeout [PDF description] [Excel spreadsheet] [Blank Excel spreadsheet]
- Fed Cattle Custom Finish Profit Projection [PDF description] [Excel spreadsheet]
- Fed Cattle Custom Finish Closeout
- Custom Finish Closeout [PDF description] [Excel spreadsheet] [Blank Excel spreadsheet]
- Custom Finish and Carcass Closeout [Example Excel spreadsheet] [Blank Excel Spreadsheet]
- Finishing Cattle –Calculate Total Costs and Net Margin [PDF description] [Excel Spreadsheet]
- Finishing Cattle Value of Gain Calculator (VOG) [Excel Spreadsheet]
- Cattle Inventories
- Monthly Cattle Inventory, Head Day and AUM [PDF description][Excel spreadsheet]
- Registered and Commercial Cattle and Horse Inventory for Balance Sheet Report [PDF description] [Excel spreadsheet]
- Cattle and Horse Inventory for Balance Sheet Report [PDF description] [Excel spreadsheet]
- Market Cattle Stocker and Fed Cattle Inventory – [PDF Description]
- Stocker Cattle Monthly Inventory [Excel spreadsheet]
- Feedyard Cattle Monthly Inventory [Excel spreadsheet]
- Market Cattle Stocker and Fed Cattle Balance Sheet – [PDF Description] [Excel spreadsheet]
- Stocker Cattle Monthly and Annual Inventory [PDF Description] [Excel Spreadsheet]
- Feed Fed & Purchases
- Monthly Feed Fed Record – September to August [PDF description] [Excel spreadsheet]
- Hay Value Based on Chemical Analysis – Protein Cost [PDF description] [Excel spreadsheet]
- Monthly Purchased Feed Record [PDF description] [Excel spreadsheet]
- Annual Reconciled Feed Inventory [PDF description] [Excel spreadsheet]
- User Manual for Monthly Feed Inventory [PDF Description]
- Monthly Feed Data Collection Sheet [Blank Excel Spreadsheet]
- Blank Annual Monthly Feed Inventory [Blank Excel Spreadsheet]
- Hay and Grazing
- Hay Produce or Purchase and Hay Loss Calculator [Excel spreadsheet]
- Grazing and Hay Budget [Excel spreadsheet]
- Fencing Cost Estimator [PDF description] [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] Grazing Economics Decision Aids:- Grazing Land Inventory Owned, Leased and Lease Check List
- [Excel Spreadsheet]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][Blank Excel Spreadsheet]
- Grazing Lease Price and Economic Evaluator
- Acre Versus AUM Lease Costs and Net Income [Excel Spreadsheet] (blank lease [Excel Spreadsheet])
- AUM Based Lessee and Lessor Cost and Income Calculator [Excel Spreadsheet]
- Acre Based Lease Record Measuring Production and Income
- Acre Monthly Lease Payment Data [Excel Spreadsheet]
- Acre Monthly Lease Payment Data With AUM Calculator [Excel Spreadsheet]
- Acre Grazing Lease Monthly and Annual Record [Excel Spreadsheet] (blank lease [Excel Spreadsheet])
- AUM Based Lease Record Measuring Production and Income
- 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] (blank lease [Excel Spreadsheet])
- Monthly Cattle Inventory & AMU Lease Calculated [Excel Spreadsheet]
- Lessee Cattle Inventory Based Grazing Lease Record
- Lessee Cattle Inventory Based Lease Monthly and Annual Record
- Blank Cattle Inventory Based Lessee Record [Excel Spreadsheet]
- 400 Cattle Head Inventory Based Leese Record [Excel Spreadsheet]
- Lessee Cattle Inventory Based Lease Monthly and Annual Record
- Land Owner Lease Description by Tenant and Net Income
- Land Owner Lease Description by Tenant – Net Income [Excel spreadsheet]
- Grazing Land Record of Fertilizer, Herbicide and Pesticide Use
- Owner Record of Fertilizer, Herbicide and Pesticide Use [Excel Spreadsheet]
- Lessee Record of Fertilizer, Herbicide and Pesticide Use [Excel Spreadsheet]
- Fertilizer Price of Alternatives and Cost Calculator
Fertilizer Price and Use Cost Calculator [PDF Description]
- Fertilizer and Lime Nutrients Price Calculator [Example Excel Spreadsheet] [Blank Excel spreadsheet]
- Fertilizer Cost Calculator [Example Excel Spreadsheet] [Example Excel Spreadsheet] [Example Excel Spreadsheet] [Blank Excel spreadsheet]
- Grazing Land Inventory Owned, Leased and Lease Check List
- Labor and Management
- Labor and Management Resources and Annual Compensation [PDF description] [Excel spreadsheet]
- Projected Salary and Benefits Calculator [PDF description] [Excel spreadsheet]
- Job Description Outline [PDF description]
- Vehicle and Freight Cost
- Vehicle or Pickup Cost Calculator [PDF description] [Excel spreadsheet]
- Pickup, Trailer and Freight Cost Calculator [PDF description] [Excel spreadsheet]
- Vehicle Replacement Plan [Excel spreadsheet]
- Vehicle Mileage, Fuel Use and Costs [PDF description]
- Data worksheet [Example Excel Spreadsheet] [Blank Excel Spreadsheet]
- Monthly and Annual Summary [Example Excel Spreadsheet] [Blank Excel Spreadsheet]
- Preconditioning Profitability Decision Aid
Evaluating Preconditioning Profitability – User Manual [PDF User manual for projection and closeout]
-
- Projection:
- 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]
- Closeout:
- Closeout Summary Data Preconditioning Profit Evaluation [Excel spreadsheet]
- Closeout Detailed Feed and Health Data Preconditioning Profit Evaluation [Excel spreadsheet]
- Supporting Spreadsheets:
- Preconditioned Cattle Price-Weight Slide Calculator [Excel spreadsheet]
- Preconditioning facilities or Grow Yard Cost Calculator [PDF description] [Excel spreadsheet]
- Hired Labor or Management Cost Calculator [PDF description] [Excel spreadsheet]
- Pickup, Trailer and Freight Cost Calculator [PDF description] [Excel spreadsheet]
- Projection:
- Developing Financial Statements to Measure Ranch Profitability
- Ranch Financial Statements to Measure Profit is Beyond IRS Tax Reporting
- 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] - Increasing Ranchers’ Financial Management Reporting [PDF description],
Cow-Calf Production Data Supporting Fiscal Year Financial Closeout Summary [PDF description],
Cow-Calf Financial-Cattle Benchmarks [Example Excel spreadsheet] [Blank Excel spreadsheet] - User Guide Addressing Additional Data Needs for Preconditioning Retained Ownership [PDF description],
Cow-Calf-Preconditioning Financial-Cattle Benchmarks [Example Excel spreadsheet] [Blank Excel spreadsheet] - User Guide Addressing Additional Data Needs for Feeder Cattle Retained Ownership [PDF description],
Cow-Calf Feeder & Horse Inventory [Example Excel spreadsheet],
Cow-Calf-Feeder Cattle Financial-Cattle Benchmarks [Example Excel spreadsheet] [Blank Excel spreadsheet] - Ranch Owner Family Living Expenses/Withdrawals Accounting [PDF description] [Excel spreadsheet]
- User Guide IRS Schedule F to Financial Statements no Production Benchmarks [PDF description] [Example Excel spreadsheet] [Blank Excel spreadsheet]
- 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] [Blank Excel spreadsheet]
- Steps to Take IRS Tax Conversion to Managerial Financial Statements [PDF description],
- Cow-Calf Ranch Data Generating Spreadsheets
- QuickBooksPro™ Setup for a Ranch [PDF description]
- Chart of accounts IRS Sub-accounts Ranch Expenses [PDF description]
- Chart of Cattle Sales Accounts Raised – Purchased [PDF description]
- Cow-Calf Production Data Supporting Fiscal Year Financial Closeout Summary [PDF description]
- Accrual Adjustments to IRS Schedule F Recording Sheet [PDF description] [Excel spreadsheet]
- Cow-Calf Sales by Category of Cattle [PDF description] [Blank Excel spreadsheet] [Blank Worksheet Excel spreadsheet]
- Cattle and Horse Beginning and Ending Annual Inventory [PDF description] [Excel spreadsheet]
- Standardize Performance Analysis (SPA) Herd Reproduction and Production Data [PDF description] [Blank Excel spreadsheet] [Example Excel spreadsheet]
- Cow-Calf Herd Production, Sales, Death Loss and Transfer Data [PDF description] [Excel spreadsheet]
- Feed Beginning and Ending Inventory [PDF description] [Excel spreadsheet]
- Capital Asset Recovery to Replace IRS Depreciation for Cost Calculation [PDF description] [Excel spreadsheet]
- Ranch of Farm Business or Personal Balance Sheet Preparation and Loans [PDF description],
Loan Description [Blank Excel spreadsheet] [Example Excel spreadsheet],
The Ranch or Farm Business Balance Sheet and Loans [Blank Excel spreadsheet] [Example Excel spreadsheet],
The Personal or Family Balance Sheet and Loans [Blank Excel spreadsheet] [Example Excel spreadsheet]
- QuickBooksPro™ Setup for a Ranch [PDF description]
- Supporting Publications
- 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 Check List
- You Manage What You Measure
- SECRETS TO SUCCESS – Investor’s 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
- 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 [PDF description] SPA Reproduction Critical Dates, Data and Calculations [Excel Spreadsheet]
- SPA Reproduction, Grazing, Feed Use and SPA Calculations User Manual [PDF description] SPA Reproduction, Grazing, Feed Use and SPA Calculations [Excel Spreadsheet]
- Reproduction & Calving Distribution Calculator [Example Excel Spreadsheet] [Blank Excel Spreadsheet]
- Cow-Calf Herd Health Economics
- Cow-Calf Health Economics and Planning [PDF description]
- Cow-Calf Health Economics [Excel spreadsheet]
- Example Cow-Calf Health Plan [Excel spreadsheet]
- Blank Cow-Calf Health Plan [Excel spreadsheet]
- Cattle Health & Treatment Record [Excel spreadsheet]
- Delayed Pregnancy Impact on Calf Revenue [Excel spreadsheet]
- Cow-Calf Health Economics and Planning [PDF description]
- Program Cattle Economics
Program Cattle Partial Budget and Data- Current Versus Program Cattle Marketing-Added Revenue Versus Added Costs [PDF description] Example Weaned Calf Program Evaluation [Excel spreadsheet] Example Stocker Cattle Program Evaluation [Excel spreadsheet] Blank Program Cattle Evaluation [Excel spreadsheet]
- Example Program Cattle Source and Age Record Verification Costs [Excel spreadsheet] Blank Program Cattle Source and Age Record Verification Costs [Excel spreadsheet]
- Health, Treatment, Feed and Grazing Cost Calculator [Excel spreadsheet]
- Cattle Health Record by Group or Lot [Excel spreadsheet]
- Program Cattle Retained Ownership Economic Evaluation
- Precondition Cattle Projection and Closeout [PDF description]
- Example Precondition Projection [Excel spreadsheet]
- Precondition Closeout [Excel spreadsheet]
- Stocker-Feeder Projection and Closeout [PDF description] a. Stocker-Feeder Example [Excel spreadsheet] b. Stocker-Feeder Example [Excel spreadsheet] c. Purchased Calf or Stocker Example/Feeder Example [Excel spreadsheet]
- Custom Finished Cattle Projection and Closeout [PDF description] a. Custom Finish Projection Example [Excel spreadsheet] Custom Finish Projection Blank [Excel spreadsheet] b. Custom Finish Closeout Example [Excel spreadsheet] Custom Finish Closeout Blank [Excel spreadsheet] c. Custom Finish Closeout – Detailed Carcass Example [Excel spreadsheet] Custom Finish Closeout Blank – Detailed Carcass [Excel spreadsheet]
- Precondition Cattle Projection and Closeout [PDF description]
- Herd Bull Replacement Economics of Alternatives
Herd Bull Replacement Cost [PDF Description]- Sexed Semen Bull Cost [Excel spreadsheet]
- Conventional AI Bull Cost [Excel spreadsheet]
- Sexed Embryo Transfer Bull Cost [Excel spreadsheet]
- Non-Sexed Embryo Transfer Bull Cost [Excel spreadsheet]
- Purchased or Raised Bull Investment Cost and Planning [Excel spreadsheet]
- Replacement Heifer Cleanup Bull Economics [PDF description] [Excel spreadsheet]
- Bull Purchase, Sales & Death Record [PDF Description] [Example Excel Spreadsheet] [Blank Excel Spreadsheet]
- Beef Sexed Semen Based Breeding Systems – Economics of Alternative Uses
Sexed Semen Beef Cattle Breeding System Economics Decision Aids Guide- Sexed Semen AI Advantage Steers Vs. Heifers [PDF Description] [Excel spreadsheet]
- Replacement Heifers Sexed AI Vs. Natural Service [PDF Description] [Excel spreadsheet]
- Replacement Heifer Sexed Semen Vs. Conventional AI [PDF Description] [Excel spreadsheet]
- Seedstock Sexed Vs. Conventional AI Bulls Vs. Heifers AI [PDF Description] [Excel spreadsheet]
- Sexed Semen AI Heifer Budget [PDF Description] [Excel spreadsheet].
- Replacement Heifer Standardized Performance Analysis (SPA) [PDF Description] [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]
- IRS Depreciation Schedule Data Record
- 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]
- Cattle Sales Record and Net Price Calculations
- Cow-Calf Ranch Cattle Sales Data Summary and Net Price Calculations [PDF description] [Excel Spreadsheet]
- Purchases Cattle for Resale, Sales and Transfer Record and Net Price Calculations [PDF description] [Excel Spreadsheet]
- Owned Pickup and Trailer or Contract Freight Cost Calculator [PDF description] [Excel Spreadsheet]
- Replacement Heifer Sales Record Summary and Net Price Calculations [PDF description] [Excel Spreadsheet]
- Cow-calf to Finished Raised and Purchased Sales Record [Excel Spreadsheet]
- Cattle Net Sales Calculator [Example Excel Spreadsheet] [Blank Excel Spreadsheet]
- Ranch Hunting Lease Income, Costs & Net Lease Income Budgets
Overview of Ranch Hunting Lease Income, Costs and & Net Income Budget Decision Aids [PDF Description]- Multiple Species Hunting Lease Income, Costs & Net Income Budget [PDF Description] Multiple Species Hunting Lease Income, Costs & Net Income Budget Example [Excel Spreadsheet] Multiple Species Hunting Lease Income, Costs & Net Income Budget Blank [Excel Spreadsheet]
- Deer Hunting Lease Income, Costs & Net Income Budget [PDF Description] Deer Hunting Lease Income, Costs & Net Income Budget Example [Excel Spreadsheet] Deer Hunting Costs Lease Income & Net Income Budget Blank [Excel Spreadsheet]
- Dove Hunting Lease Income Costs & Net Income Budget [PDF Description] Dove Hunting Lease Income, Costs & Net Income Budget Example [Excel Spreadsheet] Dove Hunting Lease Income, Costs & Net Income Budget Blank [Excel Spreadsheet]
- Quail Hunting Lease Income & Net Income Budget [PDF Description] Quail Hunting Lease Income, Costs & Net Income Budget Example [Excel Spreadsheet] Quail Hunting Lease Income, Costs & Net Income Budget Blank [Excel Spreadsheet]
- Dairy Cattle Retained Ownership Economics
Measuring the Profitability of Dairy Retained Ownership [PDF description] Dairy Feeder Cattle Retained Ownership Profit Projection [PDF description]- Day-Old Calf Raising Phase of Retained Ownership
- Quick Dairy Calf Raising Costs and Net Margin [Excel Spreadsheet]
- Dairy Calf Raising Profit Projection [Excel Spreadsheet]
- Dairy Calf Raising Lot Closeout [Excel Spreadsheet]
- Feeder Phase of Retained Ownership
- Quick Dairy Feeder Costs and Net Margin [Excel Spreadsheet]
- Dairy Feeder Profit Projection [Excel Spreadsheet]
- Dairy Feeder Lot Closeout [Example Excel Spreadsheet] [Blank Excel Spreadsheet]
- Finishing Phase of Retained Ownership
Retained Owners Finished Cattle – Calculating Total Costs and Net Income [PDF description] User Manual – Custom Finish Cattle Profit Projection [PDF description]- Quick Dairy Finishing Costs and Net Margin [Excel Spreadsheet]
- Dairy Finishing Profit Projection [Excel Spreadsheet]
- Dairy Finishing Lot Closeout [Example Excel Spreadsheet] [Blank Excel Spreadsheet]
- Day-Old Calf Raising Phase of Retained Ownership
- Dairy Breeding – Economics of Alternatives
Dairy Breeding – Economics Decision Aids [PDF Description]- Dairy Virgin Heifer Breeding Economics [Excel Spreadsheet]
- Dairy Milking Cow Breeding Economics [Excel Spreadsheet]
- Beef-Dairy Cross Sexed Versus Conventional AI [Excel Spreadsheet]
- Beef-Dairy Breeding Economics [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.