Software Tools

2016 Crop Profitability Analyzer [Excel spreadsheet]

Cash Flow Projection for Operating Loan Determination [Excel spreadsheet]


Beef Cattle Decision Aids

    1. Cow-Calf Bid Price and Budgets
      1. Cow Bid Price [PDF description] [Excel spreadsheet]
      2. Cow-Calf Costs and Necessary Calf Price for Target ROA [PDF description] [Excel spreadsheet]
    2. Replacement Heifer Budgets (replacement heifer, AI heifers, bred heifers and pairs, SPA reproduction)
      1. Replacement Heifer Budget [PDF description] [Excel spreadsheet]
      2. Artificial Insemination (AI) Replacement Heifer [PDF description] [Excel spreadsheet]
      3. Bred Replacement Heifers and Pairs Budget [PDF description] [Excel spreadsheet]
      4. Standardized Performance Analysis (SPA) Reproduction [PDF description] [Excel spreadsheet] [Excel spreadsheet with sample data]
    3. Cow-Calf Budgeting
      1. Cow-Calf Budget [PDF description] [Excel spreadsheet]
      2. Herd Bull Investment and Cost Analysis [PDF description] [Excel spreadsheet]
    4. Retained Ownership (cull cows, stocker/feeder and custom finish)
      1. Sell or Keep to Upgrade Cull Cows [PDF description] [Excel spreadsheet]
      2. Stocker/Feeder Retained Ownership [PDF description] [Excel spreadsheet]
      3. Stocker Closeout [Excel spreadsheet]
      4. Fed Cattle Custom Finished [PDF description] [Excel spreadsheet]
      5. Fed Cattle Custom Finish Closeout [Excel Spreadsheet]
    5. Cattle Inventories
      1. Monthly Cattle Inventory, Head Day and AUM [PDF description][Excel spreadsheet]
      2. Registered and Commercial Cattle and Horse Inventory for Balance Sheet Report [PDF description] [Excel spreadsheet]
      3. Cattle and Horse Inventory for Balance Sheet Report [PDF description] [Excel spreadsheet]
    6. Feed Fed & Purchases
      1. Monthly Feed Fed Record – September to August [PDF description] [Excel spreadsheet]
      2. Hay Value Based on Chemical Analysis – Protein Cost [PDF description] [Excel spreadsheet]
      3. Monthly Purchased Feed Record [PDF description] [Excel spreadsheet]
      4. Annual Reconciled Feed Inventory [Excel spreadsheet]
    7. Hay and Grazing
      1. Hay Produce or Purchase and Hay Loss Calculator [Excel spreadsheet]
      2. Grazing and Hay Budget [Excel spreadsheet]
      3. Fencing Cost Estimator [PDF description] [Excel spreadsheet]
      4. Animal Unit Calculator [Excel spreadsheet]
    8. Ranch Land Use and Carrying Capacity
      1. Owned and Leased Grazing and Raised Feed Land Use Production, Cost and Value [PDF description] [Excel spreadsheet]
      2. Owned and Leased Grazing and Raised Feed Land Use and AU Carrying Capacity [PDF description] [Excel spreadsheet]
    9. Labor and Management
      1. Labor and Management Resources and Annual Compensation [PDF description] [Excel spreadsheet]
      2. Projected Salary and Benefits Calculator [PDF description] [Excel spreadsheet]
      3. Job Description Outline [PDF description]
    10. Vehicle and Freight Cost
      1. Vehicle or Pickup Cost Calculator [PDF description] [Excel spreadsheet]
      2. Pickup, Trailer and Freight Cost Calculator [PDF description] [Excel spreadsheet]
      3. Loan Repayment Calculator [PDF description] [Loan Payment Schedule Calculator]
    11. Preconditioning Profitability Decision Aid
      Evaluating Preconditioning Profitability – User Manual [PDF User manual for projection and closeout]
    1. Projection:
      1. Raised Calf Preconditioning Profit Projection Calculator [Excel spreadsheet]
      2. Purchased Calf Preconditioning Profit Projection Calculator [Excel spreadsheet]
      3. Vac 24 – 34 -45 Raised Calf Preconditioning Profit Projection Calculator [Excel spreadsheet]
      4. Preconditioning Health and Feed Cost Calculator [Excel spreadsheet]
    2.  Closeout:
      1. Closeout Summary Data Preconditioning Profit Evaluation [Excel spreadsheet]
      2. Closeout Detailed Feed and Health Data Preconditioning Profit Evaluation [Excel spreadsheet]
    3. Supporting Spreadsheets:
      1. Preconditioned Cattle Price-Weight Slide Calculator [Excel spreadsheet]
      2. Preconditioning facilities or Grow Yard Cost Calculator [PDF description] [Excel spreadsheet]
      3. Hired Labor or Management Cost Calculator [PDF description] [Excel spreadsheet]
      4. Pickup, Trailer and Freight Cost Calculator [PDF description] [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.

Comments are closed.