University of Wyoming Extension
Wyoming Ranch Tools

Tools

Home

Partial Budget

NPV Tool

Aum Value Tool

Genetic Investment

Sprayer Calibration

Stocking Tool



Fact Sheets

Partial Bugdet

Pasture Leasing

Genetic Investment Sheet

Sprayer Calibration

Stocking Rate



External Links

Cattle Market Analysis
genetic investment.xlsx
Please fill all required fields
Wyoming Master Stockman
Bull Investment Tool
 
Standard bull cost  
Cost for a better bull  
     
Increased cost  
   
Years in Service  
Calves per year  
   
  Interest/Discount Rate  
Break-even Analysis 3% 5% 7% 9% 12% 18%  
Additional Annual Revenue Required  
Revenue Required per Calf  
Wyoming Master Stockman
Bull Investment Tool
 
Enter the cost of an average bull that you would purchase.  
Enter the cost of an improved bull (or a "better bull") that you intend to purchase.  
 
Enter the number of years that you keep your bulls in service on average.  
Enter the average number of calves you expect the bull to produce per year.  
 
The results table calculates to sets of values to help with your decision. The first value is the total
revenue increase that the improved bull needs to generate to break-even. The second value is the
annual revenue per required per calf to break-even. Each value is calculated at numerous interest
rates. If you are purchasing bulls as part of an operating loan your interest rate should be fairly low.
However, if you purchase bulls with your credit card you can see the break-even becomes more
challenging.  
   
Powered By SpreadsheetConverter