Spreadsheet: 867a6dab-9f5f-4fd3-b006-bbdb0ee6b0ba
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20
 | Cow-calf Share Decision Aid
 | Written by [NAME] and [NAME]
 | Parties |  |  |  |  |  |  | Cash Value |  |  |  |  | Key
 |  | Owner |  |  | Operator |  |  | (depreciation, death loss, interest, and insurance)
 |  | Name 1 |  |  | Name 2 |  |  | Cows Only |  | 225.12 |  |  |  | [NAME]
 |  | 0.3545765617033102 |  |  | 0.6454234382966899 |  |  | Cows and Bulls |  | 253.32 |  |  |  | Calculated Cells
 | General, Replacement, and Breeding Inputs
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Shares
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Name 1 |  | Name 2
 | What interest rate do you expect? |  |  |  |  |  |  |  | 0.08
 | How many cows are covered by this lease? |  |  |  |  |  |  |  | 100 | cows |  |  |  | 1 |  | 0
 | To maintain this herd, how many females will/would be replaced each year? |  |  |  |  |  |  |  | 16 | females
 | What is the average value of cows in the herd? |  |  |  |  |  |  |  | 1200 | dollars/head
 | How much does the average cull cow weigh when you sell her? |  |  |  |  |  |  |  | 1000 | pounds
 | What is the expected price for cull cows |  |  |  |  |  |  |  | 50 | dollars/cwt.
 | How much does it cost to market cull cows |  |  |  |  |  |  |  | 30 | head
 | What is the estimated death loss? |  |  |  |  |  |  |  | 0.02 | percent
 | How many bulls are needed for the cows in this lease? |  |  |  |  |  |  |  | 4 | bulls
 | How many bulls are culled? |  |  |  |  |  |  |  | 1
 | How much do bulls cost? (including delivery) |  |  |  |  |  |  |  | 3000 | dollars/head |  |  |  | 0.5 |  | 0.5 |  |  | Replacement cost / cow | 192
 | How long are bulls kept? |  |  |  |  |  |  |  | 4 | years |  |  |  |  |  |  |  |  | Cull cow income/head | 75.2
 | How much does the average cull bull weigh when you sell him? |  |  |  |  |  |  |  | 2000 | pounds |  |  |  |  |  |  |  |  | Bull Cost Factor | 1.6
 | What is the expected price for cull bulls? |  |  |  |  |  |  |  | 60 | dollars/cwt.
 | How much are cull bulls worth? (less marketing costs) |  |  |  |  |  |  |  | 1200 | dollars/head
 | What is the total spent on artificial Insemination each year for all females? |  |  |  |  |  |  |  | 2400 | dollars/year |  |  |  | 1 |  | 0
 | Budgeted Amounts and Shares
 |  |  |  |  |  |  |  |  |  |  |  |  | Name 1 |  | Name 2
 |  |  |  |  |  | Amount |  |  | Price |  | Cost/Cow |  | Share | Amount | Share | Amount
 | Feed Costs |  |  |  |  |  |  |  |  |  |  |  | * |  | **
 |  | Growing Season Grazing (Pairs) |  |  |  |  | 6 | months | 35 | / mo. | 210 |  | 0 | 0 | 1 | 210
 |  | Growing Season Grazing (Cows) |  |  |  |  | 0 | months | 0 | / mo. | 0 |  | 0 | 0 | 0 | 0
 |  | Dormant Season Grazing (Pairs) |  |  |  |  | 0 | months | 0 | / mo. | 0 |  | 0 | 0 | 0 | 0
 |  | Dormant Season Grazing (Cows) |  |  |  |  | 3 | months | 18 | / mo. | 54 |  | 0 | 0 | 1 | 54
 |  | Crop Residual (ie. Corn stalks) |  |  |  |  | 60 | days | 0.4 | / day | 24 |  | 0 | 0 | 1 | 24
 |  | Irrigated Pasture |  |  |  |  | 0 | months | 15 | / mo. | 0 |  | 0 | 0 | 0 | 0
 |  | Hay |  |  |  |  | 0.5 | ton | 65 | / ton | 32.5 |  | 0 | 0 | 1 | 32.5
 |  | DDG |  |  |  |  | 0 | pounds | 0 | / ton | 0 |  | 0 | 0 | 0 | 0
 |  | Corn |  |  |  |  | 0 | bu | 0 | / bu. | 0 |  | 0 | 0 | 0 | 0
 |  | Supplement |  |  |  |  | 20 | lbs | 220 | / ton | 2.2 |  | 0 | 0 | 1 | 2.2
 |  | Salt & Mineral |  |  |  |  | 60 | lbs | 0.05 | / lb. | 3 |  | 0 | 0 | 1 | 3
 |  | Other |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0
 |  | Estimated Bull Feed Costs |  |  |  |  |  |  |  |  | 20.8448 |  | 0 | 0 | 1 | 20.8448
 | Total Feed Costs |  |  |  |  |  |  |  |  |  | 346.5448 |  |  | 0 |  | 346.5448
 | Other Cash Costs
 |  | Veterinary and medicine |  |  |  |  |  |  |  |  | 20 |  | 0.5 | 10 | 0.5 | 10
 |  | Cash costs on bldgs & equip |  |  |  |  |  |  |  |  | 3 |  | 0 | 0 | 1 | 3
 |  | [NAME] cash cost -Name 1 |  |  |  |  |  |  |  |  | 5 |  | 1 | 5 | 0 | 0
 |  | [NAME] cash cost -Name 2 |  |  |  |  |  |  |  |  | 6.5 |  | 0 | 0 | 1 | 6.5
 |  | AI Costs |  |  |  |  |  |  |  |  | 24 |  | 1 | 24 | 0 | 0
 |  | Estimated Other Bull Cash Costs |  |  |  |  |  |  |  |  | 2.208 |  | 0.4347826086956522 | 0.96 | 0.565217391304348 | 1.248
 |  | Int. on pur. feed & cash costs 0.5 yr. |  |  |  |  | 252.3764 |  | 0.08 |  | 10.095056 |  | 0.07916746573768386 | 0.7992 | 0.920832534262316 | 9.295856
 | Total Other Cash Costs |  |  |  |  |  |  |  |  |  | 70.803056 |  | 0.5756700671225264 | 40.7592 | 0.4243299328774736 | 30.043856
 | Total Labor Costs |  |  |  |  |  | 6.5 | hrs | 15 |  | 97.5 |  | 0 | 0 | 1 | 97.5
 | Total Operating Costs |  |  |  |  |  |  |  |  |  | 514.847856 |  | 0.07916746573768388 | 40.7592 | 0.9208325342623161 | 474.088656
 | Cow and Bull Ownership Costs
 |  | Cow Depreciation |  |  |  |  |  |  |  |  | 116.8 |  | 1 | 116.8 | 0 | 0
 |  | Cow Death Loss |  |  |  |  |  |  |  |  | 21.664 |  | 0.5 | 10.832 | 0.5 | 10.832
 |  | Interest on Cows |  |  |  |  | 1083.2 |  | 0.08 |  | 86.656 |  | 1 | 86.656 | 0 | 0
 |  | Bull Depreciation |  |  |  |  |  |  |  |  | 18 |  | 0.5 | 9 | 0.5 | 9
 |  | Bull Death Loss |  |  |  |  |  |  |  |  | 2.04 |  | 0.5 | 1.02 | 0.5 | 1.02
 |  | Interest on Bulls |  |  |  |  | 102 |  | 0.08 |  | 8.16 |  | 0.5 | 4.08 | 0.5 | 4.08
 |  | Cattle Insurance |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | Total Ownership Costs |  |  |  |  |  |  |  |  |  | 253.32 |  | 0.9015790304752883 | 228.388 | 0.09842096952471184 | 24.932
 | Management |  |  |  |  |  |  |  |  |  | 5 |  | 1 | 5 | 0 | 0
 | Total Cost |  |  |  |  |  |  |  |  |  | 773.167856 |  | 0.3545765617033102 | 274.1472000000001 | 0.6454234382966899 | 499.020656
 |  | *Items charged interest