{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Menu","Description","Bred Heifer Budget","Bred Heifer SensitivityAnalysis","PairBudget","Pair Sensitivity Analysis","Summary","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":13,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Menu","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Description","index":1,"n_rows":58,"n_cols":18,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"Replacement Heifer and First-Calf Pair Production Description"]
[]
[null,"Ranch: ","Example of bred and 3 in one pair cost",null,null,null,"Date Printed:"]
[null,null,null,null,null,null,{"$f":"NOW()","v":"2013-03-01T08:09:59.590"}]
[]
[null,"Weaned Replacement Heifers - Raised or Purchased"]
[null,"Date - Weaned or Production Started",null,null,null,null,"2012-10-15"]
[null,"Number of Head",null,null,null,null,100]
[null,"Beginning Weight",null,null,"Lbs/Head ",null,560]
[null,"Heifer Cost or Sales Value",null,null,"$/Cwt",null,132]
[null,"Other Costs if Sold  - Commissions",null,null,"% ",null,4]
[null,"Purchase Costs - Per Head Charges",null,null,"$/Head",null,1]
[null,"Death Loss Starting to Breeding Season- % & Hd.",null,null,0.5,"%",{"$f":"E13*0.01*G8","v":0.5}]
[null,"Heifers Culled Before Breeding"]
[null,"   Average Date Culled",null,null,null,null,"2013-03-15"]
[null,"   Number of Head",null,null,"Head",null,5,null,null,"Bred Heifer Head Days"]
[null,"   Weight",null,null,"Lbs/Head",null,650,null,null,"Head Days","   Head","Total Days"]
[null,"   Net Value",null,null,"$/Cwt",null,128]
[null,"   Total Value",null,null,"$",null,{"$f":"G18*G17*G16*0.01","v":4160},null,null,{"$f":"G15-G7","v":151},{"$f":"G8","v":100},{"$f":"J19*K19","v":15100},"Weaning To Breeding",null,null,"Total Gain",{"$f":"(G17-G9)*G16","v":450},"Cull Sales"]
[null,"Beginning Breeding Season Date",null,null,null,null,"2013-04-27",null,null,{"$f":"G20-G15","v":43},{"$f":"G16","v":5},{"$f":"J20*K20","v":215},"Culling Adjustment"]
[null,null,null,null,null,null,null,null,null,{"$f":"J19-J20","v":108},{"$f":"K19-K20","v":95},{"$f":"L19-L20","v":14885},"Net Days to Breeding"]
[null,"Heifers Exposed",null,null,"Head",null,{"$f":"(G8-(G13*0.01*G8)-G16)","v":94.5},null,null,{"$f":"G35-G20","v":188},{"$f":"G22","v":94.5},{"$f":"J22*K22","v":17766},"Breeding to Bred Heifer Sale"]
[null,"Pregnancy Testing Date",null,null,null,null,"2013-08-01",null,null,{"$f":"G28-G23","v":75},{"$f":"G29","v":9.4500000000000028},{"$f":"J23*K23","v":708.75000000000023},"Culling Adjustment"]
[null,"Percent Pregnant",null,null,"%",null,90,null,null,{"$f":"J22-J23","v":113},{"$f":"K22-K23","v":85.05},{"$f":"L22-L23","v":17057.25},"Net to Bred Heifer Sales"]
[]
[null,"Pregnant Heifers",null,null,"Head",null,{"$f":"G22*G24*0.01","v":85.05},null,null,"Total Days",null,{"$f":"L21+L24","v":31942.25}]
[null,"Heifers Culled After Pregnancy Testing",null,null,null,null,null,null,null,"Average per Head In",null,{"$f":"L26/G8","v":319.42250000000001},"Bred Heifers"]
[null,"   Average Date Culled",null,null,null,null,"2013-10-15"]
[null,"   Number of Head",null,null,"Head",null,{"$f":"G22-G26","v":9.4500000000000028},null,null," Replacement Heifer Pair Sale Head Days",null,null,null,null,null,"Total Gain",{"$f":"(G30-G9)*G29","v":2740.5000000000009},"Cull Sales"]
[null,"   Weight",null,null,"Lbs/Head",null,850]
[null,"   Net Value",null,null,"$/Cwt",null,122,null,null,{"$f":"G48-G23","v":304},{"$f":"G34","v":85.05},{"$f":"J31*K31","v":25855.200000000001},"Pregnant Test to Pair Sale"]
[null,"   Total Value",null,null,"$",null,{"$f":"G31*G30*G29*0.01","v":9799.6500000000033},null,null,{"$f":"G40-G23","v":208},{"$f":"G39","v":8.5050000000000008},{"$f":"J32*K32","v":1769.0400000000002},"Culled"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L31-L32","v":24086.16},"Net to Pair Sale"]
[null,"Potential Sales of Bred Replacement Heifers",null,null,null,null,{"$f":"G26","v":85.05}]
[null,"Sales Date for Bred Replacement Heifers",null,null,null,null,"2013-11-01",null,null,"Total Days",null,{"$f":"L26+L33","v":56028.41}]
[null,null,null,null,null,null,null,null,null,"Average per Head In",null,{"$f":"L35/G8","v":560.28410000000008},"Sales of Pairs"]
[null,"Calving Replacement Heifers"]
[null,"Heifers Losing Pregnancy or Calf Loss Based"]
[null,"   on Bred Replacements - % & Head",null,null,10,"%",{"$f":"E39*G34*0.01","v":8.5050000000000008}]
[null,"   Average Date Culled",null,null,null,null,"2014-02-25",null,null,null,null,null,null,null,null,"Total Gain",{"$f":"(G41-G9)*G39","v":3742.2000000000003},"Cull Sales"]
[null,"   Weight",null,null,"Lbs/Head",null,1000]
[null,"   Net Value",null,null,"$/Cwt",null,118]
[null,"   Total Value",null,null,"$",null,{"$f":"G42*G41*G39*0.01","v":10035.900000000001},null,null,null,null,null,null,null,null,"Total Gain",{"$f":"('Bred Heifer Budget'!E25-Description!G9)*Description!G34","v":40611.375},"Final  Bred Heifer Sales "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q29+Q30+Q43","v":43351.875},"Total Net Payweight Gain Pairs"]
[null,"Death Loss of Bred Repl. Heifers - % & Hd.",null,null,1,"%",{"$f":"E45*0.01*G34","v":0.85050000000000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Gain",{"$f":"(PairBudget!E25-Description!G9)*Description!G47","v":38318.87291289751},"Final  Sales Pairs"]
[null,"Pairs Available for Sale",null,null,null,null,{"$f":"(1-G45*0.01)*(G34-G39)","v":75.893984775000007}]
[null,"Sales Date for Pairs",null,null,null,null,"2014-06-01",null,null,null,null,null,null,null,null,null,{"$f":"Q29+Q40+Q46","v":44801.572912897507},"Total Net Payweight Gain Pairs"]
[]
[null,"Performance Measures",null,null,null,"Started","Exposed"]
[null,"Head of Heifers",null,null,null,{"$f":"G8","v":100},{"$f":"G22","v":94.5}]
[null,"Pregnancy Percent Based on Exposed Heifers",null,null,null,{"$f":"G26/G8","v":0.85049999999999992},{"$f":"G26/G22","v":0.9}]
[null,"Calving Percent",null,null,null,{"$f":"G47/G8","v":0.75893984775000012},{"$f":"G47/G22","v":0.8031109500000001}]
[null,"Calving Percent Based on Bred Heifers",null,null,{"$f":"G47/G34","v":0.89234550000000012}]
[]
[null,"Death Loss of Replacements Through Pairs",null,null,"Head",{"$f":"G45+G13","v":1.3505},{"$f":"(F56/G8)","v":1.3505E-2}]
[null,"Culls Marketed - Starting Through Pairs",null,null,null,null,{"$f":"G16+G29+G39","v":22.955000000000005}]
[null,"-"]

{"sheet":"Bred Heifer Budget","index":2,"n_rows":69,"n_cols":28,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,6],[0,16,0,22],[62,5,62,6]]}
["Bred Replacement Heifer Production Budget",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This Section IS Not to Be Changed - a Zero Purchase Price Is for Analysis"]
[]
[]
["Decision Description","Raised Replacement Heifer Sold Bred",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Decision Description","Custom Fed Heifers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date of Analysis",null,null,{"$f":"TODAY()","v":"2013-03-01"}]
["Weaned Heifer Calf",null,null,"Heifer Raised",null,null,null,null,null,null,null,null,null,null,null,null," Purchase Heifer Calf to Grow    "]
["   At Best Sell or Buy Option - Describe",null,null,"Direct Sale Comparison",null,null,null,null,null,null,null,null,null,null,null,null,"   At Best Buy Option - Describe"]
["     Date Started",null,null,null,{"$f":"Description!G7","v":"2012-10-15"},null,null,null,null,null,null,null,null,null,null,null,"     Date Purchased",null,null,null,{"$f":"'Bred Heifer Budget'!E8","v":"2012-10-15"}]
["     No. of Cattle Retained or Purchased","Head",null,null,{"$f":"Description!G8","v":100},null,null,null,null,null,null,null,null,null,null,null,"     No. of Cattle Purchased","Head",null,null,{"$f":"'Bred Heifer Budget'!E9","v":100}]
["     Beginning Weight","Lbs/Head ",null,null,{"$f":"Description!G9","v":560},null,null,null,null,null,null,null,null,null,null,null,"     Beginning Weight",null,null,null,{"$f":"'Bred Heifer Budget'!E10","v":560}]
["     Heifer Cost or Sales Value","$/Cwt",null,null,{"$f":"Description!G10","v":132}]
["     Heifer Cost","$/Head",null,null,{"$f":"E10*E11*0.01","v":739.2},null,null,null,null,null,null,null,null,null,null,null,"     Gross Heifer Cost","$/Head",null,null,0]
["     Other Costs if Sold - Commissions","% - $/Head",null,{"$f":"Description!G11","v":4},{"$f":"((E12*0.01)*D13)","v":29.568000000000001},null,null,null,null,null,null,null,null,null,null,null,"     Other Purchase or Costs - Commissions","% - $/Head",null,{"$f":"'Bred Heifer Budget'!D13","v":4},{"$f":"'Bred Heifer Budget'!E13","v":29.568000000000001}]
["     Purchase Costs - Per Head Charges","$/Head",null,null,{"$f":"Description!G12","v":1},null,null,null,null,null,null,null,null,null,null,null,"     Purchase Costs - Per Head Charges","$/Head",null,null,0]
[]
["     Net Purchase Cost Per Head","$/Head",null,null,{"$f":"(E12-E13+E14)","v":710.63200000000006},null,null,null,null,null,null,null,null,null,null,null,"     Net Purchase Cost Per Head","$/Head",null,null,0]
[]
["    Total Cost","$",null,null,{"$f":"(E16*E9)","v":71063.200000000012},null,null,null,null,null,null,null,null,null,null,null,"    Total Cost","$",null,null,0]
["-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["Description of Alternative  ",null,null,"Direct Sale",null,null,null,null,null,null,null,null,null,null,null,null,"Description of Alternative  ",null,null,"Direct Sale"]
[]
["     Date Bred Heifers Marketed",null,null,null,{"$f":"Description!G35","v":"2013-11-01"},null,null,null,null,null,null,null,null,null,null,null,"     Date Marketed",null,null,null,{"$f":"U8+U23","v":"2013-11-01"},"   Months"]
["     Days Held - Adjusted for Culling",null,null,null,{"$f":"E22-E8","v":382},null,null,null,null,null,null,null,null,null,null,null,"      Days Held",null,null,null,{"$f":"E23","v":382},{"$f":"U23/30.47","v":12.536921562192321}]
["     Average Daily Gain ","Lbs/Day",null,null,1.25,null,null,null,null,null,null,null,null,null,null,null,"     Average Daily Gain ","Lb./Day",null,null,{"$f":"E24","v":1.25}]
["     Weight at Sales","Lbs/Head",null,null,{"$f":"(E23*E24+E10)","v":1037.5},null,null,null,null,null,null,null,null,null,null,null,"     Weight  at Sales","Lb./Head",null,null,{"$f":"(U23*U24+U10)","v":1037.5}]
["     Net Gain","Lbs/Head",null,null,{"$f":"(E25-E10)","v":477.5},null,null,null,null,null,null,null,null,null,null,null,"     Net Gain","Lb./Head ",null,null,{"$f":"(U25-U10)","v":477.5}]
["     Culled Heifers","Head",null,null,{"$f":"Description!G16+Description!G29","v":14.450000000000003},null,null,null,null,null,null,null,null,null,null,null,"     Culled Heifers","Head"]
["     Value of Culls","$",null,null,{"$f":"Description!G19+Description!G32","v":13959.650000000003},null,null,null,null,null,null,null,null,null,null,null,"     Value of Culls","$"]
["     Death Loss","Head",null,null,{"$f":"Description!G13","v":0.5},null,null,null,null,null,null,null,null,null,null,null,"     Death Loss","   Head"]
["     Gross Sales Income","$/Head",null,null,1350,null,null,null,null,null,null,null,null,null,null,null,"     Gross Sales Income","$/Head",null,null,{"$f":"E30","v":1350}]
["     Marketing Costs - Commissions","% - $/Head",null,0,{"$f":"((E30*D31*0.01))","v":0},null,null,null,null,null,null,null,null,null,null,null,"     Marketing Costs - Commissions","% - $/Head",null,{"$f":"D31","v":0},{"$f":"((U30*T31*0.01))","v":0}]
["     Marketing Costs Total Charges","$/Head",null,null,1,null,null,null,null,null,null,null,null,null,null,null,"     Marketing Costs Total Charges","$/Head",null,null,{"$f":"E32","v":1}]
["     Number Marketed (Net of Death Loss)","Head",null,null,{"$f":"Description!G34","v":85.05},null,null,null,null,null,null,null,null,null,null,null,"     Number Marketed (Net of Death Loss)","Head",null,null,{"$f":"E33","v":85.05}]
["     Net Sales Revenue Per Head","$/Head",null,null,{"$f":"((E30-E32-E31))","v":1349},null,null,null,null,null,null,null,null,null,null,null,"     Net Sales Revenue Per Head","$/Head",null,null,{"$f":"((U30-U32-U31))","v":1349}]
[]
["Total Sales Value (Based on Head Marketed)","$",null,null,{"$f":"(E34*E33)+E28","v":128692.1},null,null,null,null,null,null,null,null,null,null,null,"Total Sales Value (Based on Head Marketed)","$",null,null,{"$f":"(U34*U33)","v":114732.45}]
[]
[null,null,null,null,"Financial","Financial","Economic*",null,null,null,null,null,null,null,null,null,null,null,null,null,"Financial","Financial","Economic*"]
["Total Difference in Gross Revenue (Marginal Revenue)",null,null,null,"Total","$/Head","Total",null,null,null,null,null,null,null,null,null,"Total Difference in Gross Revenue (Marginal Revenue)",null,null,null,"    Total","  $/Head","    Total"]
["Total Projected Expenses",null,null,null,null,"Rate of Interest",null,null,null,null,"Annualized",null,null,null,null,null,"Total Projected Expenses",null,null,null,null,"Rate of Interest",null,null,null,null,"Annualized"]
["   Borrowed or Opportunity Cost of Equity Capital"," % Borrowed ",null,0,"%        Rate",5,"%",null,null,null,"Interest Rate",null,null,null,null,null,"   Borrowed or Opportunity Cost of Equity Capital"," % Borrowed ",null,{"$f":"D41","v":0},"%       Rate",{"$f":"F41","v":5},"%",null,null,null,"Interest Rate"]
["   Opportunity Cost of Equity Capital If Invested","$",null,null,"Total","$/Hd Out",{"$f":"K51","v":3829.6061255265422},null,null,null,{"$f":"($F$41*($C$46/365))","v":4.3756506849315073},"%",null,null,null,null,"   Opportunity Cost of Equity Capital If Invested","$",null,null,"Total","  $/Head",{"$f":"AA51","v":829.51999511558233},null,null,null,{"$f":"($F$41*($S$46/365))","v":4.3756506849315073},"%"]
["   Cash Interest Cost","$/Hd",null,{"$f":"(E43/E9)","v":0},{"$f":"(D41*G42*0.01)","v":0},{"$f":"E43/$E$33","v":0},null,null,null,null,"Economic Interest Cost",null,null,null,null,null,"   Cash Interest Cost","$/Hd.",null,{"$f":"(U43/U9)","v":0},{"$f":"(T41*W42*0.01)","v":0},{"$f":"U43/$E$33","v":0},null,null,null,null,"Economic Interest Cost"]
["   Total Purchase Cost of Cattle","$",null,null,{"$f":"E18","v":71063.200000000012},{"$f":"E44/$E$33","v":835.54614932392724},{"$f":"E44","v":71063.200000000012},null,null,null,{"$f":"((SUM($E$45:$E$52)*0.5*(($C$46/365)*$F$41*0.01)))","v":720.12872799229467},"Feed",null,null,null,null,"   Total Purchase Cost of Cattle","$",null,null,0,{"$f":"U44/$E$33","v":0},{"$f":"U44","v":0},null,null,null,{"$f":"((SUM($U$45:$U$52)*0.5*(($S$46/365)*$V$41*0.01)))","v":829.51999511558233},"Feed"]
["Cost of Nutrition, Health and Other Costs",null,"Units/Hd","$/Unit  ",null,null,null,null,null,null,null,null,null,null,null,null,"Cost of Nutrition, Health and Other Costs",null,"Units/Hd","$/Unit"]
["   Cost Based on Days Fed and/or Grazed","     Days ",{"$f":"Description!L27","v":319.42250000000001},1.3,{"$f":"C46*D46*$E$9","v":41524.925000000003},488.24132863021759,{"$f":"E46","v":41524.925000000003},null,null,null,{"$f":"($E$16*$E$9)*(($C$46/365)*$F$41*0.01)","v":3109.4773975342478},"Cattle",null,null,null,null,{"$f":"A46","v":"   Cost Based on Days Fed and/or Grazed"},{"$f":"B46","v":"     Days "},{"$f":"C46","v":319.42250000000001},{"$f":"J57","v":1.1869944978828981},{"$f":"S46*T46*$U$9","v":37915.275000000001},{"$f":"U46/$E$33","v":445.79982363315702},{"$f":"U46","v":37915.275000000001},null,null,null,{"$f":"($U$16*$U$9)*(($S$46/365)*$V$41*0.01)","v":0},"Cattle"]
["   Processing and Health","$/Hd",1,16,{"$f":"(C47*D47*$E$9)","v":1600},18.812463256907701,1600,null,null,null,null,null,null,null,null,null,{"$f":"A47","v":"   Processing and Health"},"$/Hd",null,null,{"$f":"(S47*T47*$E$9)","v":0},0,0]
["   Breeding","$/Hd",1,30,3000,35.273368606701943,{"$f":"E48","v":3000},null,null,null,null,null,null,null,null,null,"   Breeding","$/Hd",null,null,0,0,0]
["   Pregnancy. Test","$/Hd",1,2.5,250,2.9394473838918285,{"$f":"E49","v":250},null,null,null,null,null,null,null,null,null,"   Pregnancy. Test","$/Hd",null,null,0,0,0]
["   Other","$/Hd",1,0,0,0,{"$f":"E50","v":0},null,null,null,null,null,null,null,null,null,"   Other","$/Hd",null,null,0,0,0]
["   General and Administrative","$/Hd",1,5,500,5.8788947677836569,500,null,null,null,{"$f":"(K44+K46)","v":3829.6061255265422},"Total",null,null,null,null,"   General and Administrative","$/Hd",null,null,0,0,0,null,null,null,{"$f":"(AA44+AA46)","v":829.51999511558233},"Total"]
["   Cost Adjustment for Value of Culled Heifers","$/Hd",1,{"$f":"(E28/E9)*-1","v":-139.59650000000002},-13959.650000000001,-164.13462669018227,{"$f":"E52","v":-13959.650000000001},null,null,null,null,null,null,null,null,null,"   Cost Adjustment for Value of Culled Heifers","$/Hd",null,null,0,0,0]
["   Management Cost or Return","$/Hd",1,25,{"$f":"(D53*$E$9)","v":2500},29.394473838918284,2500,null,null,null,null,null,null,null,null,null,"   Management Cost or Return","$/Hd",{"$f":"C53","v":1},{"$f":"D53","v":25},0,0,0]
["Target Net Financial Margin Per Head Objective","$/Hd",1,25,{"$f":"(C54*D54*$E$9)","v":2500},29.394473838918284,2500,null,null,null,"Financial Performance",null,null,null,null,null,"Target Net Margin Per Head Objective","$/Hd.",{"$f":"C54","v":1},{"$f":"D54","v":25},0,0,0,null,null,null,"Financial Performance"]
["Total Specified Costs",null,null,null,{"$f":"SUM(E43:E54)","v":108978.47500000001},null,{"$f":"SUM(G42:G54)","v":112808.08112552654},null,null,"Non - Cattle - Head In",null,null,null,null,null,null,"Total Specified Added Costs (Marginal Cost)",null,null,null,{"$f":"SUM(U43:U54)","v":37915.275000000001},null,{"$f":"SUM(W42:W54)","v":38744.794995115582},null,"Total Cost "]
[null,null,null,null,null,null,null,null,null,"      $/Day - Head In",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per Day"]
["Total Production Adjusted Cost Per Head including Target Margin",null,null,"$/Hd",null,{"$f":"((E55)/$E$33)","v":1281.3459729570841},{"$f":"((G55)/$E$33)","v":1326.3736757851445},null,null,{"$f":"(E43+SUM(E46:E54))/(C46*E9)","v":1.1869944978828981},null,null,null,null,null,null,"Production Cost Per Head","$/Hd.",null,null,null,{"$f":"(U55/$U$33)","v":445.79982363315702},{"$f":"(W55/$E$33)","v":455.55314515127083},null,{"$f":"SUM($U$43:$U$54)/($S$46*$U$9)","v":1.1869944978828981}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$23=0,0,((($E$55-$E$43)*0.5+$E$18)*($C$46/365)))","v":109874.72182833905},"Total Assets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($U$23=0,0,((($U$55-$U$43)*0.5+$U$18)*($S$46/365)))","v":16590.399902311645},"Total Assets"]
["Non-Cattle Cost Per Day Including Target Return","$/Hd/Day",{"$f":"J57","v":1.1869944978828981},null,null,null,null,null,null,{"$f":"(E43+SUM(E46:E54))/E33","v":445.79982363315702},{"$f":"(E61+E54+E43)","v":8253.9749999999967},"Return to Assets = Net + Target Margin + Cash Interest",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($W$42:$W$54)/($S$46*$U$9)","v":1.2129638643212541},null,{"$f":"(U61+U54+U43)","v":76817.174999999988},"Return to Assets = Net + Target Margin + Cash Interest"]
[null,null,null,null,"Financial",null," Economic",null,null,null,{"$f":"(K59/K58)*100","v":7.5121691892840081},"Return on Assets %",null,null,null,null,null,null,null,null,"Financial",null," Economic",null,null,null,{"$f":"(AA59/AA58)*100","v":463.02184065675578},"Return on Assets %"]
["Net Income Over Target Return",null,null,null,{"$f":"(E36-E55)-E28","v":5753.9749999999967},null,{"$f":"(E36-G55)-E28","v":1924.3688744734591},null,null,null,null,null,null,null,null,null,"Net Income",null,null,"$",{"$f":"(U36-U55)","v":76817.174999999988},null,{"$f":"(U36-W55)","v":75987.655004884407}]
[]
[null,null,null,null,null,"Economic",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"         Economic"]
[null,null,null,null,null,"Target","Actual",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Target","    Actual"]
["Annualized Return on Assets - ROA - (Including Net Margin Objective)      %",null,null,null,{"$f":"IF($E$23=0,0,(($E$43+$E$54+$E$61)/((($E$55-$E$43)*0.5+$E$18)*($E$23/365)))*100)","v":6.281559850429506},{"$f":"IF(E23=0,0,((($K$51+$G$54)/((($G$55-G43)*0.5+$E$18)*($E$23/365)))*100))","v":4.7446873852369515},{"$f":"IF($E$23=0,0,(($K$51+$G$54+$G$61)/((($G$55)*0.5+$E$18)*($E$23/365)))*100)","v":6.1871987425289205},null,null,null,null,null,null,null,null,null,"Annualized Return on Assets - ROA - (Including Net Margin Objective)      %",null,null,null,{"$f":"IF($U$23=0,0,(($U$43+$U$54+$U$61)/((($U$55-$U$43)*0.5+$U$18)*($U$23/365)))*100)","v":387.17171177272928},{"$f":"IF(U23=0,0,((($AA$51+$W$54)/((($W$55-W43)*0.5+$U$18)*($U$23/365)))*100))","v":4.0914098728076791},{"$f":"IF($U$23=0,0,(($AA$51+$W$54+$W$61)/((($W$55)*0.5+$U$18)*($U$23/365)))*100)","v":378.88242603772687}]
[]
["-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["*Economic costs include an opportunity cost for capital invested in cattle on feed and other cost of gain adjusted for the time",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Economic costs include an opportunity cost for capital invested in cattle on feed and other cost of gain adjusted for the time"]
[" on feed. Ensure costs are full costs (don't include interest to prevent double counting; do include business overhead).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," on feed. Ensure costs are full costs (don't include interest to prevent double counting; do include business overhead)."]

{"sheet":"Bred Heifer SensitivityAnalysis","index":3,"n_rows":30,"n_cols":18,"rows_kept":30,"cut":false,"hidden":false,"merged":[[14,3,14,4],[14,6,14,7],[20,3,20,7],[0,0,0,7],[10,3,10,7],[9,3,9,7],[12,3,12,7]]}
["Bred Replacement Heifer Costs and Necessary Sales Price Sensitivity Analysis"]
[]
[]
["Cost of Gain, In-Price of Cattle and Sales Price Necessary to Reach Targeted Net Margin*"]
[]
[]
[{"$f":"'Bred Heifer Budget'!A54","v":"Target Net Financial Margin Per Head Objective"},"$/Head",null,{"$f":"'Bred Heifer Budget'!D54","v":25},"Per Head In"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"('Bred Heifer Budget'!$F$41*('Bred Heifer Budget'!$E$23/365))","v":5.2328767123287667},"Annualized Interest Rate"]
[null,null,null,"Sales Price Necessary For Bred Repl. Heifer per Head For",null,null,null,null,null,"Economic Interest Cost",null,null,"Cash Cost",null,null,{"$f":"B23","v":660.63200000000006},{"$f":"($P10*'Bred Heifer Budget'!$E$9)*(('Bred Heifer Budget'!$C$46/365)*'Bred Heifer Budget'!$F$41*0.01)","v":2890.6948632876724},{"$f":"($Q10*'Bred Heifer Budget'!$D$41*0.01)+$M$11","v":0}]
["Interval of Change For Analysis Table ",null,null,"Different In-Price, Cost and Necessary Out-Prices*",null,null,null,null,null,{"$f":"((SUM('Bred Heifer Budget'!$E$45:$E$51)*0.5*(('Bred Heifer Budget'!$C$46/365)*'Bred Heifer Budget'!$F$41*0.01)))","v":1025.5414884118154},"Feed & Other Costs",null,{"$f":"('Bred Heifer Budget'!$K$44*'Bred Heifer Budget'!$D$41*0.01)","v":0},null,null,{"$f":"B24","v":685.63200000000006},{"$f":"($P11*'Bred Heifer Budget'!$E$9*(('Bred Heifer Budget'!$C$46/365)*'Bred Heifer Budget'!$F$41*0.01))","v":3000.0861304109599},{"$f":"($Q11*'Bred Heifer Budget'!$D$41*0.01)+$M$11","v":0}]
[null,"$/Head",null,null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"B25","v":710.63200000000006},{"$f":"($P12*'Bred Heifer Budget'!$E$9)*(('Bred Heifer Budget'!$C$46/365)*'Bred Heifer Budget'!$F$41*0.01)","v":3109.4773975342478},{"$f":"($Q12*'Bred Heifer Budget'!$D$41*0.01)+$M$11","v":0}]
["    Total Production Cost",50,null,"Change and Associated Calculated Values",null,null,null,null,null,{"$f":"('Bred Heifer Budget'!$E$16*'Bred Heifer Budget'!$E$9)*(('Bred Heifer Budget'!$C$46/365)*'Bred Heifer Budget'!$F$41*0.01)","v":3109.4773975342478},"Cattle",null,{"$f":"('Bred Heifer Budget'!$K$46*'Bred Heifer Budget'!$D$41*0.01)","v":0},null,null,{"$f":"B26","v":735.63200000000006},{"$f":"($P13*'Bred Heifer Budget'!$E$9)*(('Bred Heifer Budget'!$C$46/365)*'Bred Heifer Budget'!$F$41*0.01)","v":3218.8686646575352},{"$f":"($Q13*'Bred Heifer Budget'!$D$41*0.01)+$M$11","v":0}]
["    Heifer Cost",25,null,"-",null,null,null,null,null,null,null,null,null,null,null,{"$f":"B27","v":760.63200000000006},{"$f":"($P14*'Bred Heifer Budget'!$E$9)*(('Bred Heifer Budget'!$C$46/365)*'Bred Heifer Budget'!$F$41*0.01)","v":3328.2599317808231},{"$f":"($Q14*'Bred Heifer Budget'!$D$41*0.01)+$M$11","v":0}]
[null,null,null,"Decrease",null,"Input","Increase",null,null,{"$f":"(L19+J13)","v":4135.5658422816796},"Total Interest",null,{"$f":"(M11+M13)","v":0}]
["Non-Cattle Costs With Cash Interest","$/Head",null,null,null,{"$f":"'Bred Heifer Budget'!J59","v":445.79982363315702},null,null,null,null,"Cost of Gain",null,"Added","Net Added"," Total"]
["Change in Cost Per Head","$/Head",null,{"$f":"B13*2*-1","v":-100},{"$f":"B13*-1","v":-50},null,{"$f":"B13*1","v":50},{"$f":"B13*2","v":100},null,null,"Change","Interest","Investment","Interest","Added"]
[null,"$/Day",null,{"$f":"D17/'Bred Heifer Budget'!$C$46","v":-0.31306498446415015},{"$f":"E17/'Bred Heifer Budget'!$C$46","v":-0.15653249223207508},null,{"$f":"G17/'Bred Heifer Budget'!$C$46","v":0.15653249223207508},{"$f":"H17/'Bred Heifer Budget'!$C$46","v":0.31306498446415015}]
["Calculated Non-Cattle Cost Per Head","$/Head",null,{"$f":"($F$19+D17)","v":345.79982363315702},{"$f":"($F$19+E17)","v":395.79982363315702},{"$f":"F16","v":445.79982363315702},{"$f":"($F$19+G17)","v":495.79982363315702},{"$f":"($F$19+H17)","v":545.79982363315708},null,null,{"$f":"G17","v":50},{"$f":"((SUM('Bred Heifer Budget'!$E$45:$E$51)+M19)*0.5*(('Bred Heifer Budget'!$C$46/365)*'Bred Heifer Budget'!$F$41*0.01))","v":1026.0884447474318},{"$f":"($B$13*0.5)","v":25},{"$f":"L19-$J$11","v":0.54695633561641444},{"$f":"(B13+N19)*'Bred Heifer Budget'!E33","v":4299.0186363441762}]
[]
[null,null,null,"Necessary Net Sales Price per Bred Replacement Heifer Out",null,null,null,null,null,null,{"$f":"H17","v":100},{"$f":"((SUM('Bred Heifer Budget'!$E$45:$E$51)+M21)*0.5*(('Bred Heifer Budget'!$C$46/365)*'Bred Heifer Budget'!$F$41*0.01))","v":1026.6354010830482},{"$f":"($H$17*0.5)","v":50},{"$f":"L21-$J$11","v":1.0939126712328289},{"$f":"(H17+N21)*'Bred Heifer Budget'!E33","v":8598.0372726883525}]
[null,"Cost",null,"-"]
[null,{"$f":"B25-2*B14","v":660.63200000000006},null,{"$f":"($B23*'Bred Heifer Budget'!$E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R10+$O$25+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31*0.01))/'Bred Heifer Budget'!$E$33","v":1122.4631126080146},{"$f":"($B23*'Bred Heifer Budget'!$E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R10+$O$23+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31*0.01))/'Bred Heifer Budget'!$E$33","v":1173.0100689436313},{"$f":"($B23*'Bred Heifer Budget'!$E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R10+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31))/'Bred Heifer Budget'!$E$33","v":1223.5570252792477},{"$f":"($B23*'Bred Heifer Budget'!E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R10+$O$19+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31*0.01))/'Bred Heifer Budget'!$E$33","v":1274.1039816148641},{"$f":"($B23*'Bred Heifer Budget'!$E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R10+$O$21+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31*0.01))/'Bred Heifer Budget'!$E$33","v":1324.6509379504805},null,null,{"$f":"E17","v":-50},{"$f":"((SUM('Bred Heifer Budget'!$E$45:$E$51)+M23)*0.5*(('Bred Heifer Budget'!$C$46/365)*'Bred Heifer Budget'!$F$41*0.01))","v":1024.994532076199},{"$f":"($E$17*0.5)","v":-25},{"$f":"L23-$J$11","v":-0.54695633561641444},{"$f":"(E17+N23)*'Bred Heifer Budget'!$E$33","v":-4299.0186363441762}]
[null,{"$f":"(B25-B14)","v":685.63200000000006},null,{"$f":"($B24*'Bred Heifer Budget'!$E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R11+$O$25+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31*0.01))/'Bred Heifer Budget'!$E$33","v":1151.8575864469331},{"$f":"($B24*'Bred Heifer Budget'!$E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R11+$O$23+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31*0.01))/'Bred Heifer Budget'!$E$33","v":1202.4045427825495},{"$f":"($B24*'Bred Heifer Budget'!$E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R11+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31))/'Bred Heifer Budget'!$E$33","v":1252.9514991181659},{"$f":"($B24*'Bred Heifer Budget'!E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R11+$O$19+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31*0.01))/'Bred Heifer Budget'!$E$33","v":1303.4984554537823},{"$f":"($B24*'Bred Heifer Budget'!$E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R11+$O$21+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31*0.01))/'Bred Heifer Budget'!$E$33","v":1354.0454117893987}]
["Total Heifer Calf Cost ($/Head)*--------------->",{"$f":"('Bred Heifer Budget'!E16)","v":710.63200000000006},null,{"$f":"($B25*'Bred Heifer Budget'!$E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R12+$O$25+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31*0.01))/'Bred Heifer Budget'!$E$33","v":1181.2520602858513},{"$f":"($B25*'Bred Heifer Budget'!$E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R12+$O$23+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31*0.01))/'Bred Heifer Budget'!$E$33","v":1231.7990166214679},{"$f":"($B25*'Bred Heifer Budget'!$E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R12+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31))/'Bred Heifer Budget'!$E$33","v":1282.3459729570843},{"$f":"($B25*'Bred Heifer Budget'!E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R12+$O$19+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31*0.01))/'Bred Heifer Budget'!$E$33","v":1332.8929292927007},{"$f":"($B25*'Bred Heifer Budget'!$E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R12+$O$21+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31*0.01))/'Bred Heifer Budget'!$E$33","v":1383.4398856283169},null,null,{"$f":"D17","v":-100},{"$f":"((SUM('Bred Heifer Budget'!$E$45:$E$51)+M25)*0.5*(('Bred Heifer Budget'!$C$46/365)*'Bred Heifer Budget'!$F$41*0.01))","v":1024.4475757405824},{"$f":"($D$17*0.5)","v":-50},{"$f":"L25-$J$11","v":-1.0939126712330562},{"$f":"(D17+N25)*'Bred Heifer Budget'!E33","v":-8598.0372726883706}]
[null,{"$f":"B25+B14","v":735.63200000000006},null,{"$f":"($B26*'Bred Heifer Budget'!$E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R13+$O$25+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31*0.01))/'Bred Heifer Budget'!$E$33","v":1210.6465341247695},{"$f":"($B26*'Bred Heifer Budget'!$E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R13+$O$23+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31*0.01))/'Bred Heifer Budget'!$E$33","v":1261.1934904603861},{"$f":"($B26*'Bred Heifer Budget'!$E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R13+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31))/'Bred Heifer Budget'!$E$33","v":1311.7404467960025},{"$f":"($B26*'Bred Heifer Budget'!E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R13+$O$19+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31*0.01))/'Bred Heifer Budget'!$E$33","v":1362.2874031316189},{"$f":"($B26*'Bred Heifer Budget'!$E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R13+$O$21+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31*0.01))/'Bred Heifer Budget'!$E$33","v":1412.8343594672353}]
[null,{"$f":"B25+2*B14","v":760.63200000000006},null,{"$f":"($B27*'Bred Heifer Budget'!$E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R14+$O$25+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31*0.01))/'Bred Heifer Budget'!$E$33","v":1240.0410079636879},{"$f":"($B27*'Bred Heifer Budget'!$E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R14+$O$23+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31*0.01))/'Bred Heifer Budget'!$E$33","v":1290.5879642993043},{"$f":"($B27*'Bred Heifer Budget'!$E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R14+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31))/'Bred Heifer Budget'!$E$33","v":1341.1349206349207},{"$f":"($B27*'Bred Heifer Budget'!E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R14+$O$19+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31*0.01))/'Bred Heifer Budget'!$E$33","v":1391.6818769705371},{"$f":"($B27*'Bred Heifer Budget'!$E$9+SUM('Bred Heifer Budget'!$E$45:$E$54)+$R14+$O$21+'Bred Heifer Budget'!$E$32*'Bred Heifer Budget'!$E$33)/(1-('Bred Heifer Budget'!$D$31*0.01))/'Bred Heifer Budget'!$E$33","v":1442.2288333061535}]
[]
["-"]
["*Price necessary to achieve targeted net margin objective. Includes marketing costs in addition to production costs."]

{"sheet":"PairBudget","index":4,"n_rows":69,"n_cols":28,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,6],[0,16,0,22],[62,5,62,6]]}
["Replacement Heifer Pair Production Budget",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This Section IS Not to Be Changed - a Zero Purchase Price Is for Analysis"]
[]
[]
["Decision Description","First calf heifer sold as a pair  bred back for second calf",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Decision Description","Custom Fed Heifers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date of Analysis",null,null,{"$f":"TODAY()","v":"2013-03-01"}]
["Weaned Heifer Calf",null,null,"Heifer Raised",null,null,null,null,null,null,null,null,null,null,null,null," Purchase Heifer Calf to Grow    "]
["   At Best Sell or Buy Option - Describe",null,null,"Direct Sale ",null,null,null,null,null,null,null,null,null,null,null,null,"   At Best Buy Option - Describe"]
["     Date Started",null,null,null,{"$f":"Description!G7","v":"2012-10-15"},null,null,null,null,null,null,null,null,null,null,null,"     Date Purchased",null,null,null,{"$f":"'Bred Heifer Budget'!E8","v":"2012-10-15"}]
["     No. of Cattle Retained or Purchased","Head",null,null,{"$f":"Description!G8","v":100},null,null,null,null,null,null,null,null,null,null,null,"     No. of Cattle Purchased","Head",null,null,{"$f":"'Bred Heifer Budget'!E9","v":100}]
["     Beginning Weight","Lbs/Head ",null,null,{"$f":"Description!G9","v":560},null,null,null,null,null,null,null,null,null,null,null,"     Beginning Weight",null,null,null,{"$f":"'Bred Heifer Budget'!E10","v":560}]
["     Heifer Cost or Sales Value","$/Cwt",null,null,{"$f":"Description!G10","v":132}]
["     Heifer Cost","$/Head",null,null,{"$f":"E10*E11*0.01","v":739.2},null,null,null,null,null,null,null,null,null,null,null,"     Gross Heifer Cost","$/Head",null,null,0]
["     Other Costs if Sold - Commissions","% - $/Head",null,{"$f":"Description!G11","v":4},{"$f":"((E12*0.01)*D13)","v":29.568000000000001},null,null,null,null,null,null,null,null,null,null,null,"     Other Purchase or Costs - Commissions","% - $/Head",null,{"$f":"'Bred Heifer Budget'!D13","v":4},{"$f":"'Bred Heifer Budget'!E13","v":29.568000000000001}]
["     Purchase Costs - Per Head Charges","$/Head",null,null,{"$f":"Description!G12","v":1},null,null,null,null,null,null,null,null,null,null,null,"     Purchase Costs - Per Head Charges","$/Head",null,null,0]
[]
["     Net Purchase Cost Per Head","$/Head",null,null,{"$f":"(E12-E13+E14)","v":710.63200000000006},null,null,null,null,null,null,null,null,null,null,null,"     Net Purchase Cost Per Head","$/Head",null,null,0]
[]
["    Total Cost","$",null,null,{"$f":"(E16*E9)","v":71063.200000000012},null,null,null,null,null,null,null,null,null,null,null,"    Total Cost","$",null,null,0]
["-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["Description of Alternative  ",null,null,"Direct Sale - 3 in one",null,null,null,null,null,null,null,null,null,null,null,null,"Description of Alternative  ",null,null,"Direct Sale"]
[]
["     Date Pair Marketed",null,null,null,{"$f":"Description!G48","v":"2014-06-01"},"Months",{"$f":"(E22-E8)/30.47","v":19.494584837545126},null,null,null,null,null,null,null,null,null,"     Date Marketed",null,null,null,{"$f":"U8+U23","v":"2014-06-01"},"   Months"]
["     Days Held - Not Adjusted for Culling",null,null,null,{"$f":"E22-E8","v":594},null,null,null,null,null,null,null,null,null,null,null,"      Days Held",null,null,null,{"$f":"E23","v":594},{"$f":"U23/30.47","v":19.494584837545126}]
["     Average Daily Gain ","Lbs/Day",null,null,0.85,null,null,null,null,null,null,null,null,null,null,null,"     Average Daily Gain ","Lb./Day",null,null,{"$f":"E24","v":0.85}]
["     Weight  at Sales","Lbs/Head",null,null,{"$f":"(E23*E24+E10)","v":1064.9000000000001},null,null,null,null,null,null,null,null,null,null,null,"     Weight  at Sales","Lb./Head",null,null,{"$f":"(U23*U24+U10)","v":1064.9000000000001}]
["     Net Gain","Lbs/Head",null,null,{"$f":"(E25-E10)","v":504.90000000000009},null,null,null,null,null,null,null,null,null,null,null,"     Net Gain","Lb./Head ",null,null,{"$f":"(U25-U10)","v":504.90000000000009}]
["     Culled Heifers","Head",null,null,{"$f":"Description!G16+Description!G29+Description!G39","v":22.955000000000005},null,null,null,null,null,null,null,null,null,null,null,"     Culled Heifers","Head"]
["     Value of Culls","$",null,null,{"$f":"Description!G19+Description!G32+Description!G43","v":23995.550000000003},null,null,null,null,null,null,null,null,null,null,null,"     Value of Culls","$"]
["     Death Loss","Head",null,null,{"$f":"Description!F56","v":1.3505},null,null,null,null,null,null,null,null,null,null,null,"     Death Loss","   Head"]
["     Gross Sales Income","$/Head",null,null,1925,null,null,null,null,null,null,null,null,null,null,null,"     Gross Sales Income","$/Head",null,null,{"$f":"E30","v":1925}]
["     Marketing Costs - Commissions","% - $/Head",null,0,{"$f":"((E30*D31*0.01))","v":0},null,null,null,null,null,null,null,null,null,null,null,"     Marketing Costs - Commissions","% - $/Head",null,{"$f":"D31","v":0},{"$f":"((U30*T31*0.01))","v":0}]
["     Marketing Costs Total Charges","$/Head",null,null,1,null,null,null,null,null,null,null,null,null,null,null,"     Marketing Costs Total Charges","$/Head",null,null,{"$f":"E32","v":1}]
["     Number Marketed (Net of Death Loss)","Head",null,null,{"$f":"Description!G47","v":75.893984775000007},null,null,null,null,null,null,null,null,null,null,null,"     Number Marketed (Net of Death Loss)","Head",null,null,{"$f":"E33","v":75.893984775000007}]
["     Net Sales Revenue Per Head","$/Head",null,null,{"$f":"((E30-E32-E31))","v":1924},null,null,null,null,null,null,null,null,null,null,null,"     Net Sales Revenue Per Head","$/Head",null,null,{"$f":"((U30-U32-U31))","v":1924}]
[]
["Total Sales Value (Based on Head Marketed)","$",null,null,{"$f":"(E34*E33)+E28","v":170015.57670710003},null,null,null,null,null,null,null,null,null,null,null,"Total Sales Value (Based on Head Marketed)","$",null,null,{"$f":"(U34*U33)","v":146020.02670710001}]
[]
[null,null,null,null,"Financial","Financial","Economic*",null,null,null,null,null,null,null,null,null,null,null,null,null,"Financial","Financial","Economic*"]
["Total Difference in Gross Revenue (Marginal Revenue)",null,null,null,"Total","$/Head","Total",null,null,null,null,null,null,null,null,null,"Total Difference in Gross Revenue (Marginal Revenue)",null,null,null,"    Total","  $/Head","    Total"]
["Total Projected Expenses",null,null,null,null,"Rate of Interest",null,null,null,null,"Annualized",null,null,null,null,null,"Total Projected Expenses",null,null,null,null,"Rate of Interest",null,null,null,null,"Annualized"]
["   Borrowed or Opportunity Cost of Equity Capital"," % Borrowed ",null,0,"%         Rate",0,"%",null,null,null,"Interest Rate",null,null,null,null,null,"   Borrowed or Opportunity Cost of Equity Capital"," % Borrowed ",null,{"$f":"D41","v":0},"%       Rate",{"$f":"F41","v":0},"%",null,null,null,"Interest Rate"]
["   Opportunity Cost of Equity Capital If Invested","$",null,null,"Total","$/Hd Out",{"$f":"K51","v":0},null,null,null,{"$f":"($F$41*($C$46/365))","v":0},"%",null,null,null,null,"   Opportunity Cost of Equity Capital If Invested","$",null,null,"Total","  $/Head",{"$f":"AA51","v":0},null,null,null,{"$f":"($F$41*($S$46/365))","v":0},"%"]
["   Cash Interest Cost","$/Hd",null,{"$f":"(E43/E9)","v":0},{"$f":"(D41*G42*0.01)","v":0},{"$f":"E43/$E$33","v":0},null,null,null,null,"Economic Interest Cost",null,null,null,null,null,"   Cash Interest Cost","$/Hd.",null,{"$f":"(U43/U9)","v":0},{"$f":"(T41*W42*0.01)","v":0},{"$f":"U43/$E$33","v":0},null,null,null,null,"Economic Interest Cost"]
["   Total Purchase Cost of Cattle","$",null,null,{"$f":"E18","v":71063.200000000012},{"$f":"E44/$E$33","v":936.34825224526503},{"$f":"E44","v":71063.200000000012},null,null,null,{"$f":"((SUM($E$45:$E$52)*0.5*(($C$46/365)*$F$41*0.01)))","v":0},"Feed",null,null,null,null,"   Total Purchase Cost of Cattle","$",null,null,0,{"$f":"U44/$E$33","v":0},{"$f":"U44","v":0},null,null,null,{"$f":"((SUM($U$45:$U$52)*0.5*(($S$46/365)*$V$41*0.01)))","v":0},"Feed"]
["Cost of Nutrition, Health and Other Costs",null,"Units/Hd","$/Unit  ",null,null,null,null,null,null,null,null,null,null,null,null,"Cost of Nutrition, Health and Other Costs",null,"Units/Hd","$/Unit"]
["   Cost Based on Days Fed and/or Grazed","     Days ",{"$f":"Description!L36","v":560.28410000000008},1.3,{"$f":"C46*D46*$E$9","v":72836.933000000005},959.71944569700577,{"$f":"E46","v":72836.933000000005},null,null,null,{"$f":"($E$16*$E$9)*(($C$46/365)*$F$41*0.01)","v":0},"Cattle",null,null,null,null,{"$f":"A46","v":"   Cost Based on Days Fed and/or Grazed"},{"$f":"B46","v":"     Days "},{"$f":"C46","v":560.28410000000008},{"$f":"J57","v":1.246535159573509},{"$f":"S46*T46*$U$9","v":69841.383000000002},{"$f":"U46/$E$33","v":920.24925568285914},{"$f":"U46","v":69841.383000000002},null,null,null,{"$f":"($U$16*$U$9)*(($S$46/365)*$V$41*0.01)","v":0},"Cattle"]
["   Processing and Health","$/Hd",1,24,{"$f":"(C47*D47*$E$9)","v":2400},31.623059549649266,2400,null,null,null,null,null,null,null,null,null,{"$f":"A47","v":"   Processing and Health"},"$/Hd",null,null,{"$f":"(S47*T47*$E$9)","v":0},0,0]
["   Breeding - two when bred back","$/Hd",1,60,6000,79.05764887412316,{"$f":"E48","v":6000},null,null,null,null,null,null,null,null,null,"   Breeding - two when bred back","$/Hd",null,null,0,0,0]
["   Calving","$/Hd",1,40,4000,52.705099249415447,{"$f":"E49","v":4000},null,null,null,null,null,null,null,null,null,"   Calving","$/Hd",null,null,0,0,0]
["   Pregnancy Check - two when bred back","$/Hd",1,6,600,7.9057648874123165,{"$f":"E50","v":600},null,null,null,null,null,null,null,null,null,"   Pregnancy Check - two when bred back","$/Hd",null,null,0,0,0]
["   General and Administrative","$/Hd",1,5,500,6.5881374061769309,500,null,null,null,{"$f":"(K44+K46)","v":0},"Total",null,null,null,null,"   General and Administrative","$/Hd",null,null,0,0,0,null,null,null,{"$f":"(AA44+AA46)","v":0},"Total"]
["   Cost Adjustment for Value of Culled Pairs","$/Hd",1,{"$f":"(E28/E9)*-1","v":-239.95550000000003},-23995.550000000003,-316.17196107357773,{"$f":"E52","v":-23995.550000000003},null,null,null,null,null,null,null,null,null,"   Cost Adjustment for Value of Culled Pairs","$/Hd",null,null,0,0,0]
["   Management Cost or Return","$/Hd",1,50,{"$f":"(D53*$E$9)","v":5000},65.881374061769307,5000,null,null,null,null,null,null,null,null,null,"   Management Cost or Return","$/Hd",{"$f":"C53","v":1},{"$f":"D53","v":50},0,0,0]
["Target Net Financial Margin Per Head Objective","$/Hd",1,25,{"$f":"(C54*D54*$E$9)","v":2500},32.940687030884654,2500,null,null,null,"Financial Performance",null,null,null,null,null,"Target Net Margin Per Head Objective","$/Hd.",{"$f":"C54","v":1},{"$f":"D54","v":25},0,0,0,null,null,null,"Financial Performance"]
["Total Specified Costs",null,null,null,{"$f":"SUM(E43:E54)","v":140904.58300000004},null,{"$f":"SUM(G42:G54)","v":140904.58300000004},null,null,"Non - Cattle",null,null,null,null,null,null,"Total Specified Added Costs (Marginal Cost)",null,null,null,{"$f":"SUM(U43:U54)","v":69841.383000000002},null,{"$f":"SUM(W42:W54)","v":69841.383000000002},null,"Total Cost "]
[null,null,null,null,null,null,null,null,null,"      $/Day",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per Day"]
["Total Production Adjusted Cost Per Head including Target Margin",null,null,"$/Hd",null,{"$f":"(E55/$E$33)","v":1856.5975079281245},{"$f":"(G55/$E$33)","v":1856.5975079281245},null,null,{"$f":"(E43+SUM(E46:E54))/(C46*E9)","v":1.246535159573509},null,null,null,null,null,null,"Production Cost Per Head","$/Hd.",null,null,null,{"$f":"(U55/$U$33)","v":920.24925568285914},{"$f":"(W55/$E$33)","v":920.24925568285914},null,{"$f":"SUM($U$43:$U$54)/($S$46*$U$9)","v":1.246535159573509}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$23=0,0,((($E$55-$E$43)*0.5+$E$18)*($E$23/365)))","v":230301.92315342469},"Total Assets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($U$23=0,0,((($U$55-$U$43)*0.5+$U$18)*($U$23/365)))","v":56829.837673972601},"Total Assets"]
["Non-Cattle Cost Per Day Including Target Return","$/Hd/Day",{"$f":"J57","v":1.246535159573509},null,null,null,null,null,null,{"$f":"(E43+SUM(E46:E54))/E33","v":920.24925568285914},{"$f":"(E61+E54+E43)","v":7615.4437070999847},"Return to Assets = Net + Target Margin + Cash Interest",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($W$42:$W$54)/($S$46*$U$9)","v":1.246535159573509},null,{"$f":"(U61+U54+U43)","v":76178.643707100011},"Return to Assets = Net + Target Margin + Cash Interest"]
[null,null,null,null,"Financial",null," Economic",null,null,null,{"$f":"(K59/K58)*100","v":3.3067217167902925},"Return on Assets %",null,null,null,null,null,null,null,null,"Financial",null," Economic",null,null,null,{"$f":"(AA59/AA58)*100","v":134.04691413009073},"Return on Assets %"]
["Net Income ",null,null,null,{"$f":"(E36-E55)-E28","v":5115.4437070999847},null,{"$f":"(E36-G55)-E28","v":5115.4437070999847},null,null,null,null,null,null,null,null,null,"Net Income",null,null,"$",{"$f":"(U36-U55)","v":76178.643707100011},null,{"$f":"(U36-W55)","v":76178.643707100011}]
[]
[null,null,null,null,null,"Economic",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"         Economic"]
[null,null,null,null,null,"Target","Actual",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   Target","    Actual"]
["Annualized Return on Assets - ROA - (Including Net Margin Objective)      %",null,null,null,{"$f":"IF($E$23=0,0,(($E$43+$E$54+$E$61)/((($E$55-$E$43)*0.5+$E$18)*($E$23/365)))*100)","v":3.3067217167902925},{"$f":"IF(E23=0,0,((($K$51+$G$54)/((($G$55-G43)*0.5+$E$18)*($E$23/365)))*100))","v":1.0855315343304912},{"$f":"IF($E$23=0,0,(($K$51+$G$54+$G$61)/((($G$55)*0.5+$E$18)*($E$23/365)))*100)","v":3.3067217167902925},null,null,null,null,null,null,null,null,null,"Annualized Return on Assets - ROA - (Including Net Margin Objective)      %",null,null,null,{"$f":"IF($U$23=0,0,(($U$43+$U$54+$U$61)/((($U$55-$U$43)*0.5+$U$18)*($U$23/365)))*100)","v":134.04691413009073},{"$f":"IF(U23=0,0,((($AA$51+$W$54)/((($W$55-W43)*0.5+$U$18)*($U$23/365)))*100))","v":0},{"$f":"IF($U$23=0,0,(($AA$51+$W$54+$W$61)/((($W$55)*0.5+$U$18)*($U$23/365)))*100)","v":134.04691413009073}]
[]
["-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["*Economic costs include an opportunity cost for capital invested in cattle on feed and other cost of gain adjusted for the time",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Economic costs include an opportunity cost for capital invested in cattle on feed and other cost of gain adjusted for the time"]
[" on feed. Ensure costs are full costs (don't include interest to prevent double counting; do include business overhead).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," on feed. Ensure costs are full costs (don't include interest to prevent double counting; do include business overhead)."]

{"sheet":"Pair Sensitivity Analysis","index":5,"n_rows":30,"n_cols":18,"rows_kept":30,"cut":false,"hidden":false,"merged":[[14,3,14,4],[14,6,14,7],[20,3,20,7],[0,0,0,7],[9,3,9,7],[10,3,10,7],[12,3,12,7]]}
["Replacement Pair Costs and Necessary Sales Price Sensitivity Analysis"]
[]
[]
["Cost of Gain, In-Price of Cattle and Sales Price Necessary to Reach Targeted Net Margin*"]
[]
[]
[{"$f":"'Bred Heifer Budget'!A54","v":"Target Net Financial Margin Per Head Objective"},"$/Head",null,{"$f":"PairBudget!D54","v":25},"Per Head In"]
[null,null,null,null,null,null,null,null,null,{"$f":"'Bred Heifer Budget'!D41","v":0},"% Borrowed",null,null,null,null,"Cattle",null,"Total Cash"]
[null,null,null,null,null,null,null,null,null,{"$f":"('Bred Heifer Budget'!$F$41*('Bred Heifer Budget'!$C$46/365))","v":4.3756506849315073},"Annualized Interest Rate"]
[null,null,null,"Sales Price Necessary Pair per Head For",null,null,null,null,null,"Economic Interest Cost",null,null,"Cash Cost",null,null,{"$f":"B23","v":660.63200000000006},{"$f":"($P10*PairBudget!$E$9)*((PairBudget!$C$46/365)*PairBudget!$F$41*0.01)","v":0},{"$f":"($Q10*PairBudget!$D$41*0.01)+$M$11","v":0}]
["Interval of Change For Analysis Table ",null,null,"Different In-Price, Cost and Necessary Out-Prices*",null,null,null,null,null,{"$f":"((SUM(PairBudget!$E$45:$E$51)*0.5*((PairBudget!$C$46/365)*PairBudget!$F$41*0.01)))","v":0},"Feed & Other Costs",null,{"$f":"(PairBudget!$K$44*PairBudget!$D$41*0.01)","v":0},null,null,{"$f":"B24","v":685.63200000000006},{"$f":"($P11*PairBudget!$E$9*((PairBudget!$E$23/365)*PairBudget!$F$41*0.01))","v":0},{"$f":"($Q11*PairBudget!$D$41*0.01)+$M$11","v":0}]
[null,"$/Head",null,null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"B25","v":710.63200000000006},{"$f":"($P12*PairBudget!$E$9)*((PairBudget!$C$46/365)*PairBudget!$F$41*0.01)","v":0},{"$f":"($Q12*PairBudget!$D$41*0.01)+$M$11","v":0}]
["    Total Production Cost",50,null,"Change and Associated Calculated Values",null,null,null,null,null,{"$f":"(PairBudget!$E$16*PairBudget!$E$9)*((PairBudget!$C$46/365)*PairBudget!$F$41*0.01)","v":0},"Cattle",null,{"$f":"(PairBudget!$K$46*PairBudget!$D$41*0.01)","v":0},null,null,{"$f":"B26","v":735.63200000000006},{"$f":"($P13*PairBudget!$E$9)*((PairBudget!$E$23/365)*PairBudget!$F$41*0.01)","v":0},{"$f":"($Q13*PairBudget!$D$41*0.01)+$M$11","v":0}]
["    Heifer Cost",25,null,"-",null,null,null,null,null,null,null,null,null,null,null,{"$f":"B27","v":760.63200000000006},{"$f":"($P14*PairBudget!$E$9)*((PairBudget!$C$46/365)*PairBudget!$F$41*0.01)","v":0},{"$f":"($Q14*PairBudget!$D$41*0.01)+$M$11","v":0}]
[null,null,null,"Decrease",null,"Input","Increase",null,null,{"$f":"(L19+J13)","v":0},"Total Interest",null,{"$f":"(M11+M13)","v":0}]
["Non-Cattle Costs With Cash Interest","$/Head",null,null,null,{"$f":"PairBudget!J59","v":920.24925568285914},null,null,null,null,"Cost of Gain",null,"Added","Net Added"," Total"]
["Change in Cost Per Head","$/Head",null,{"$f":"B13*2*-1","v":-100},{"$f":"B13*-1","v":-50},null,{"$f":"B13*1","v":50},{"$f":"B13*2","v":100},null,null,"Change","Interest","Investment","Interest","Added"]
[null,"$/Day",null,{"$f":"D17/PairBudget!$C$46","v":-0.1784808813957062},{"$f":"E17/PairBudget!$C$46","v":-8.9240440697853099E-2},null,{"$f":"G17/PairBudget!$E$23","v":8.4175084175084181E-2},{"$f":"H17/PairBudget!$C$46","v":0.1784808813957062}]
["Calculated Non-Cattle Cost Per Head","$/Head",null,{"$f":"($F$19+D17)","v":820.24925568285914},{"$f":"($F$19+E17)","v":870.24925568285914},{"$f":"F16","v":920.24925568285914},{"$f":"($F$19+G17)","v":970.24925568285914},{"$f":"($F$19+H17)","v":1020.2492556828591},null,null,{"$f":"G17","v":50},{"$f":"((SUM(PairBudget!$E$45:$E$51)+M19)*0.5*((PairBudget!$C$46/365)*PairBudget!$F$41*0.01))","v":0},{"$f":"($B$13*0.5)","v":25},{"$f":"L19-$J$11","v":0},{"$f":"(B13+N19)*PairBudget!E33","v":3794.6992387500004}]
[]
[null,null,null,"Necessary Net Sales Price per Pair Heifer Out",null,null,null,null,null,null,{"$f":"H17","v":100},{"$f":"((SUM(PairBudget!$E$45:$E$51)+M21)*0.5*((PairBudget!$C$46/365)*PairBudget!$F$41*0.01))","v":0},{"$f":"($H$17*0.5)","v":50},{"$f":"L21-$J$11","v":0},{"$f":"(H17+N21)*PairBudget!E33","v":7589.3984775000008}]
[null,"Cost",null,"-"]
[null,{"$f":"B25-2*B14","v":660.63200000000006},null,{"$f":"($B23*PairBudget!$E$9+SUM(PairBudget!$E$45:$E$54)+$R10+$O$25+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31*0.01))/PairBudget!$E$33","v":1691.716133866355},{"$f":"($B23*PairBudget!$E$9+SUM(PairBudget!$E$45:$E$54)+$R10+$O$23+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31*0.01))/PairBudget!$E$33","v":1741.7161338663548},{"$f":"($B23*PairBudget!$E$9+SUM(PairBudget!$E$45:$E$54)+$R10+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31))/PairBudget!$E$33","v":1791.716133866355},{"$f":"($B23*PairBudget!E$9+SUM(PairBudget!$E$45:$E$54)+$R10+$O$19+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31*0.01))/PairBudget!$E$33","v":1841.716133866355},{"$f":"($B23*PairBudget!$E$9+SUM(PairBudget!$E$45:$E$54)+$R10+$O$21+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31*0.01))/PairBudget!$E$33","v":1891.716133866355},null,null,{"$f":"E17","v":-50},{"$f":"((SUM(PairBudget!$E$45:$E$51)+M23)*0.5*((PairBudget!$C$46/365)*PairBudget!$F$41*0.01))","v":0},{"$f":"($E$17*0.5)","v":-25},{"$f":"L23-$J$11","v":0},{"$f":"(E17+N23)*PairBudget!$E$33","v":-3794.6992387500004}]
[null,{"$f":"(B25-B14)","v":685.63200000000006},null,{"$f":"($B24*PairBudget!$E$9+SUM(PairBudget!$E$45:$E$54)+$R11+$O$25+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31*0.01))/PairBudget!$E$33","v":1724.6568208972396},{"$f":"($B24*PairBudget!$E$9+SUM(PairBudget!$E$45:$E$54)+$R11+$O$23+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31*0.01))/PairBudget!$E$33","v":1774.6568208972394},{"$f":"($B24*PairBudget!$E$9+SUM(PairBudget!$E$45:$E$54)+$R11+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31))/PairBudget!$E$33","v":1824.6568208972396},{"$f":"($B24*PairBudget!E$9+SUM(PairBudget!$E$45:$E$54)+$R11+$O$19+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31*0.01))/PairBudget!$E$33","v":1874.6568208972396},{"$f":"($B24*PairBudget!$E$9+SUM(PairBudget!$E$45:$E$54)+$R11+$O$21+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31*0.01))/PairBudget!$E$33","v":1924.6568208972396}]
["Total Heifer Calf Cost ($/Head)*--------------->",{"$f":"(PairBudget!E16)","v":710.63200000000006},null,{"$f":"($B25*PairBudget!$E$9+SUM(PairBudget!$E$45:$E$54)+$R12+$O$25+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31*0.01))/PairBudget!$E$33","v":1757.5975079281241},{"$f":"($B25*PairBudget!$E$9+SUM(PairBudget!$E$45:$E$54)+$R12+$O$23+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31*0.01))/PairBudget!$E$33","v":1807.5975079281241},{"$f":"($B25*PairBudget!$E$9+SUM(PairBudget!$E$45:$E$54)+$R12+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31))/PairBudget!$E$33","v":1857.5975079281243},{"$f":"($B25*PairBudget!E$9+SUM(PairBudget!$E$45:$E$54)+$R12+$O$19+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31*0.01))/PairBudget!$E$33","v":1907.5975079281243},{"$f":"($B25*PairBudget!$E$9+SUM(PairBudget!$E$45:$E$54)+$R12+$O$21+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31*0.01))/PairBudget!$E$33","v":1957.5975079281243},null,null,{"$f":"D17","v":-100},{"$f":"((SUM(PairBudget!$E$45:$E$51)+M25)*0.5*((PairBudget!$E$23/365)*PairBudget!$F$41*0.01))","v":0},{"$f":"($D$17*0.5)","v":-50},{"$f":"L25-$J$11","v":0},{"$f":"(D17+N25)*PairBudget!E33","v":-7589.3984775000008}]
[null,{"$f":"B25+B14","v":735.63200000000006},null,{"$f":"($B26*PairBudget!$E$9+SUM(PairBudget!$E$45:$E$54)+$R13+$O$25+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31*0.01))/PairBudget!$E$33","v":1790.5381949590087},{"$f":"($B26*PairBudget!$E$9+SUM(PairBudget!$E$45:$E$54)+$R13+$O$23+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31*0.01))/PairBudget!$E$33","v":1840.5381949590087},{"$f":"($B26*PairBudget!$E$9+SUM(PairBudget!$E$45:$E$54)+$R13+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31))/PairBudget!$E$33","v":1890.5381949590089},{"$f":"($B26*PairBudget!E$9+SUM(PairBudget!$E$45:$E$54)+$R13+$O$19+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31*0.01))/PairBudget!$E$33","v":1940.5381949590089},{"$f":"($B26*PairBudget!$E$9+SUM(PairBudget!$E$45:$E$54)+$R13+$O$21+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31*0.01))/PairBudget!$E$33","v":1990.5381949590089}]
[null,{"$f":"B25+2*B14","v":760.63200000000006},null,{"$f":"($B27*PairBudget!$E$9+SUM(PairBudget!$E$45:$E$54)+$R14+$O$25+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31*0.01))/PairBudget!$E$33","v":1823.4788819898934},{"$f":"($B27*PairBudget!$E$9+SUM(PairBudget!$E$45:$E$54)+$R14+$O$23+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31*0.01))/PairBudget!$E$33","v":1873.4788819898934},{"$f":"($B27*PairBudget!$E$9+SUM(PairBudget!$E$45:$E$54)+$R14+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31))/PairBudget!$E$33","v":1923.4788819898936},{"$f":"($B27*PairBudget!E$9+SUM(PairBudget!$E$45:$E$54)+$R14+$O$19+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31*0.01))/PairBudget!$E$33","v":1973.4788819898936},{"$f":"($B27*PairBudget!$E$9+SUM(PairBudget!$E$45:$E$54)+$R14+$O$21+PairBudget!$E$32*PairBudget!$E$33)/(1-(PairBudget!$D$31*0.01))/PairBudget!$E$33","v":2023.4788819898936}]
[]
["-"]
["*Price necessary to achieve targeted net margin objective. Includes marketing costs in addition to production costs."]

{"sheet":"Summary","index":6,"n_rows":64,"n_cols":13,"rows_kept":64,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Replacement Heifer and First-Calf Pair Production and Pricing Summary"]
[]
["Ranch: ",{"$f":"Description!C3","v":"Example of bred and 3 in one pair cost"},null,null,null,"Date Printed:"]
[null,null,null,null,null,{"$f":"NOW()","v":"2013-03-01T08:09:59.590"}]
[]
["Replacement Heifers - Bred or First-Calf Pairs Description"]
["Date - Weaned or Purchased Heifers Started",null,null,null,null,{"$f":"Description!G7","v":"2012-10-15"}]
["Number of Head",null,null,"Head ",null,{"$f":"Description!G8","v":100}]
["Beginning Weight",null,null,"Lbs/Head ",null,{"$f":"Description!G9","v":560}]
[{"$f":"Description!B22","v":"Heifers Exposed"},null,null,null,null,{"$f":"Description!G22","v":94.5}]
["Beginning Breeding Season Date",null,null,null,null,{"$f":"Description!G20","v":"2013-04-27"}]
["Potential Sales of Bred Replacement Heifers",null,null,"Head ",null,{"$f":"Description!G34","v":85.05}]
["Sales Date for Bred Replacement Heifers",null,null,null,null,{"$f":"Description!G35","v":"2013-11-01"}]
[]
["First-Calf Pairs Available for Sale",null,null,"Head ",null,{"$f":"Description!G47","v":75.893984775000007}]
["Sales Date for First-Calf Pairs",null,null,null,null,{"$f":"Description!G48","v":"2014-06-01"}]
[]
["Performance Measures",null,null,null,"Started","    Exposed"]
["Replacement Heifers",null,null,"Head ",{"$f":"Description!F51","v":100},{"$f":"Description!G51","v":94.5}]
["Pregnancy Percent Based on Exposed Heifers",null,null,null,{"$f":"Description!F52","v":0.85049999999999992},{"$f":"Description!G52","v":0.9}]
["Calving Percent",null,null,null,{"$f":"Description!F53","v":0.75893984775000012},{"$f":"Description!G53","v":0.8031109500000001}]
["Calving Percent Based on Bred Heifers",null,{"$f":"Description!E54","v":0.89234550000000012}]
["Death Loss of Replacements - Starting Through Pairs",null,null,"Head - %",{"$f":"Description!F56","v":1.3505},{"$f":"Description!G56","v":1.3505E-2}]
["Culls Marketed - Starting Through First-Calf Pairs Sales",null,null,"Head - %",{"$f":"Description!G57","v":22.955000000000005},{"$f":"E24/F8","v":0.22955000000000006},null,null,null,null,null,{"$f":"SUM(E24+E23+F15)","v":100.19948477500002},"Check on numbers"]
[]
["-------------------------------------------------------------------------------------------------------------------------------------------------------"]
[]
["Cost and Net Income - Bred Heifer Sales","Head",null,{"$f":"F12","v":85.05}]
[null,null,null,null,"    Financial ","   Economic"]
["Target Net Financial Margin Per Head Objective","$/Hd",null,{"$f":"'Bred Heifer Budget'!D54","v":25},"Per Head In"]
["Rate or Return or Interest Rate","%",null,null,null,{"$f":"'Bred Heifer Budget'!F41*0.01","v":0.05}]
["Total Production Adjusted Cost Per Head*","$/Hd",null,null,{"$f":"'Bred Heifer Budget'!F57","v":1281.3459729570841},{"$f":"'Bred Heifer Budget'!G57","v":1326.3736757851445}]
[]
["Projected Net Price ","$/Hd",null,null,{"$f":"'Bred Heifer Budget'!E34","v":1349},{"$f":"E34","v":1349}]
["Net Income Over Target Return",null,null,null,{"$f":"E34-E32","v":67.654027042915914},{"$f":"F34-F32","v":22.626324214855458}]
[]
["Total Net Income Over Target Return","$",null,null,{"$f":"'Bred Heifer Budget'!E61","v":5753.9749999999967}]
["Total Net to Equity Including Target Return","$",null,null,{"$f":"('Bred Heifer Budget'!E61+'Bred Heifer Budget'!E54)","v":8253.9749999999967}]
[]
["Annualized Return on Assets - ROA - (Including Net Margin Objective)      %",null,null,null,{"$f":"'Bred Heifer Budget'!E65*0.01","v":6.2815598504295064E-2}]
[]
[null,null,null,"Months"]
["Months Bred Heifers Sold are Held",null,null,{"$f":"((F13-F7)/(365/12))","v":12.55890410958904}]
[]
["------------------------------------------------------------------------------------------------------------------------------------------------------"]
[]
["Cost and Net Income - Pair Sales","  Head",null,{"$f":"Description!G47","v":75.893984775000007}]
[null,null,null,null,"    Financial ","   Economic"]
["Target Net Financial Margin Per Head Objective","$/Hd",null,{"$f":"PairBudget!D54","v":25}]
["Rate of Return or Interest Rate","%",null,null,null,{"$f":"PairBudget!F41*0.01","v":0}]
["Total Production Adjusted Cost Per Head*","$/Hd",null,null,{"$f":"PairBudget!F57","v":1856.5975079281245},{"$f":"PairBudget!G57","v":1856.5975079281245}]
[]
["Projected Price ","$/Hd",null,null,{"$f":"PairBudget!E34","v":1924},{"$f":"E53","v":1924}]
["Net Income Over Target Return",null,null,null,{"$f":"E53-E51","v":67.402492071875486},{"$f":"F53-F51","v":67.402492071875486}]
[]
["Total Net Income Over Target Return","$",null,null,{"$f":"PairBudget!E61","v":5115.4437070999847}]
["Total Net to Equity Including Target Return","$",null,null,{"$f":"PairBudget!E54+PairBudget!E61","v":7615.4437070999847}]
[]
["Annualized Return on Assets - ROA - (Including Net Margin Objective)      %",null,null,null,{"$f":"PairBudget!E65*0.01","v":3.3067217167902924E-2}]
[]
[null,null,null,"Months"]
["Months First Calf Pairs Sold are Held",null,null,{"$f":"((F16-F7)/(365/12))","v":19.528767123287672}]
["-------------------------------------------------------------------------------------------------------------------------------------------------------"]
["*Price necessary to achieve targeted net margin objective. Includes marketing costs in addition to production costs."]

{"sheet":"Sheet1","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}