{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Full Service"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Full Service","index":0,"n_rows":102,"n_cols":26,"rows_kept":102,"cut":false,"hidden":false,"merged":[[101,0,101,9],[96,0,96,1],[2,0,2,9],[88,0,88,1],[89,0,89,1],[90,0,90,1],[31,2,31,3],[50,0,50,5],[29,2,29,3],[30,2,30,3],[61,1,61,2],[60,1,60,2],[54,0,54,9],[57,0,57,5]]}
[]
[2023,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["Nellie's Horse Boarding Operation (Full Service)"]
[null,null,null,null,20,"Horses"]
[null,null,null,null,0.9,"Occupancy Rate"]
[]
[]
["ITEM",null,null,null,"UNIT","PRICE",null,"QUANTITY","TOTAL","Your Estimate",null,null,"",null,null,null,null,null,null,null,""]
["1. GROSS RECEIPTS",null,null,null,null,null,null,"Months"]
[" Number Boarded ",{"$f":"E4*E5-B12","v":18},"Head",12,"Months",500,"Per Month",{"$f":"D10","v":12},{"$f":"B10*F10*H10","v":108000}," __________"]
[" Lessons",0,"/month",12,"Months",35,"Per Lesson",{"$f":"D11","v":12},{"$f":"B11*F11*H11","v":0}," __________"]
[" Training",0,"/month",12,"Months",800,"Per Horse",{"$f":"D12","v":12},{"$f":"B12*F12*H12","v":0}," __________"]
[" Other: ________________",0,"/unit",0,"Months",0,"Per Unit",{"$f":"D13","v":0},{"$f":"B13*F13*H13","v":0}," __________"]
["2. TOTAL GROSS RECEIPTS",null,null,null,null,null,null,null,{"$f":"SUM(I10:I12)","v":108000}," __________"]
["3. VARIABLE COSTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Feed Loss",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"A64","v":" Alfalfa Hay"},0.05,null,null,{"$f":"IF(C64>99,\"Cwt\",IF(C64>0,\"Bushel\",\"Ton\"))","v":"Ton"},225,null,{"$f":"IF(C64<=0,(J64*(1+B17)),(J64*2000)/C64*(1+B17))","v":0},{"$f":"F17*H17","v":0}," __________"]
[" Timothy Hay",0.05,null,null,{"$f":"IF(C65>99,\"Cwt\",IF(C65>0,\"Bushel\",\"Ton\"))","v":"Ton"},180,null,{"$f":"IF(C65=0,(J65*(1+B18)),(J65*2000)/C65*(1+B18))","v":0},0," __________"]
[" Mixed Hay",0.05,null,null,"Ton",175,null,0,0," __________"]
[" Grass Hay",0.05,null,null,"Ton",185,null,56.912625000000006,10528.835625000002," __________"]
[" Mixed Feed",0.02,null,null,"Ton",480,null,18.428850000000001,8845.848," __________",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[" Rolled Oats",0.02,null,null,"Cwt",24,null,0,0," __________",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[" Other Feed",0.05,null,null,"Ton",0,null,0,0," __________",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[" Grinding & Mixing",null,null,null,"Cwt",1.4,null,0,0," __________"]
[" Salt & Mineral",91,"Lbs per Horse",null,"Cwt",30,null,{"$f":"B25/100*E4","v":18.2},546," __________"]
[" Vet & Medicine",null,"$/Horse",null,"Head",{"$f":"J99","v":156.22},null,{"$f":"$E$4","v":20},{"$f":"IF(B26=N(ISNUMBER(B26)),ROUND((F26*H26),2),ROUND((B26*H26),2))","v":3124.4}," __________"]
[" Farrier",8,"Trips/year",null,"Trip",{"$f":"B40*50","v":0},null,{"$f":"B40","v":0},{"$f":"IF(B27=N(ISNUMBER(B27)),ROUND((F27*H27),2),ROUND((B27*F27),2))","v":0}," __________"]
[" Supplies",null,null,null,"Head",27,null,{"$f":"$E$4","v":20},540," __________"]
[" Replacement Tack",0.15,"Annually",null,"Head",{"$f":"IF(B40=0,0,D76*B29/B40)","v":0},null,{"$f":"B40","v":0},{"$f":"F29*H29","v":0}," __________"]
[" Pasture Rent",null,"Acres per Horse",null,"Acre",21,null,{"$f":"B30*(E$4+B$40)","v":0},{"$f":"F30*H30","v":0}," __________"]
[" Pasture Clipping",0.2,"Acres per Horse",null,"Acre",17.5,null,{"$f":"B31*(E$4+B$40)","v":4},{"$f":"F31*H31","v":70}," __________"]
[" Fertilizer & Lime",2,"Acres per Horse",null,"Acre",32,null,{"$f":"B32*(B$40)","v":0},0," __________"]
[" Building & Fence Repairs",0.05,"of Facility Value",null,"Head",{"$f":"(($D$77+$D$79)*B33)/$E$4","v":210},null,{"$f":"$E$4","v":20},{"$f":"F33*H33","v":4200}," __________"]
[" Haul to Ride",null,null,null,"Miles",0.48,null,0,0," __________"]
[" Utilities",null,null,null,"Head",60,null,{"$f":"$E$4","v":20},1200," __________"]
[" Insurance - horses",0.1,"of Value",null,"Head",{"$f":"((((SUM(D75:D82))-($D$78+$D$79))*B36)/$E$4)","v":570},null,{"$f":"B40","v":0},0," __________"]
[" Bedding",null,null,null,"Head",200,null,{"$f":"$E$4","v":20},4000," __________"]
[" Property Insurance",null,null,null,"Year",2000,null,1,2000," __________"]
[" Liability Insurance",2,"Millions of Coverage",null,"Per Mil $",500,null,{"$f":"B39","v":2},1000," __________"]
[" Lessons Horses Upkeep",0,"Horses",null,"Head",2400,null,{"$f":"B40","v":0},0," __________"]
[" Other: Marketing/Advertising",null,null,null,"Year",1500,null,1,1500," __________"]
[" Other: ________________",null,null,null,"Head",0,null,{"$f":"$E$4","v":20},0," __________"]
[" Labor",300,"Hours per Horse",null,"Hours",10,null,{"$f":"E4*B43*E5","v":5400},54000," __________"]
[" Unexpected Expenses",0.05,"of variable costs (except labor)",null,null,null,null,{"$f":"SUM(I17:I42)","v":37555.083624999999},{"$f":"B44*H44","v":1877.7541812500001}," __________"]
[" Operating Interest",6,"Months",null,"Dollars",0.06,null,{"$f":"ROUND(SUM(I17:I44),0)","v":93433},{"$f":"B45/12*F45*H45","v":2802.99}," __________"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["4. TOTAL VARIABLE COSTS",null,null,null,null,null,null,null,{"$f":"SUM(I17:I45)","v":96235.827806250003}," __________"]
["5. RETURN ABOVE VARIABLE COSTS",null,null,null,null,null,null,null,{"$f":"I14-I47","v":11764.172193749997}," __________"]
["6. ANNUAL OVERHEAD COSTS",null,null,null,null,null,null,null,20000," __________"]
["7. TOTAL COSTS",null,null,null,null,null,null,null,{"$f":"I47+I49","v":116235.82780625}]
["8. RETURN ABOVE TOTAL COSTS",null,null,null,null,null,null,null,{"$f":"I14-I47-I49","v":-8235.8278062500031}," __________"]
[]
[]
["NOTE: This budget is for the stable owner."]
["Developed by Virginia Cooperative Extension Farm Business Management Staff"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"A3","v":"Nellie's Horse Boarding Operation (Full Service)"},null,null,null,null,null,null,null,null,"Page 2"]
["8. FEED RATIONS"]
[" ",null,null,"Horses",null,null,null,null,null,"Total"]
[null,"Number Head =",null,{"$f":"$E$4*E5","v":18},null,null,null,null,null,"Quantity"]
[" Feed","Days Fed =",null,365,0,0,0,0,0,"(Tons)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Unit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[" Alfalfa Hay","Lbs/Head/Day",null,0,0,0,0,0,0,{"$f":"(($E$61*$E$62*E64)+($F$61*$F$62*F64)+($G$61*$G$62*G64)+($H$61*$H$62*H64)+($I$61*$I$62*I64)+($D$61*$D$62*D64))/2000","v":0}]
[" Timothy Hay","Lbs/Head/Day",null,0,0,0,0,0,0,0]
[" Mixed Hay","Lbs/Head/Day",null,0,0,0,0,0,0,0]
[" Grass Hay","Lbs/Head/Day",null,16.5,0,0,0,0,0,54.202500000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[" Mixed Feed","Lbs/Head/Day",null,5.5,0,0,0,0,0,18.067499999999999]
[" Rolled Oats","Lbs/Head/Day",100,0,0,0,0,0,0,0]
[" Other Feed","Lbs/Head/Day",null,0,0,0,0,0,0,0]
[]
[" 9. ANNUAL DEBT SERVICE",null,null,"Amount",null,"Percent",null,"Length","Percent","Annual",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["  Item",null,null,"Borrowed",null,"Interest",null,"of Loan","to Horse","Payment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[" Lessons Horses",4000,"/horse",{"$f":"B40*B75","v":0},null,0.06,null,4,1,{"$f":"(IF(H75>0,PMT(F75,H75,-D75),0))*(I75)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[" Tack",null,null,0,null,0.06,null,0,1,{"$f":"(IF(H76>0,PMT(F76,H76,-D76),0))*(I76)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[" Barn",null,null,{"$f":"(25000+($E$4*2500))","v":75000},null,0.06,null,20,1,6538.8417732638582,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[" Land",null,null,{"$f":"(10000+($E$4*3000))","v":70000},null,0.06,null,20,1,6102.9189883796016,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[" Fencing",null,null,{"$f":"(3000+($E$4*300))","v":9000},null,0.06,null,7,1,1612.215162531098,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[" Truck",null,null,30000,null,0.06,null,5,1,{"$f":"(IF(H80>0,PMT(F80,H80,-D80),0))*(I80)","v":7121.8920129356884},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[" Trailer",null,null,9000,null,0.06,null,5,1,2136.5676038807069,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[" TOTAL DEBT",null,null,{"$f":"SUM(D74:D82)","v":193000},null,"       TOTAL ANNUAL DEBT PAYMENTS",null,null,null,{"$f":"SUM(J74:J82)","v":23512.435540990955},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[" 10. ANIMAL HEALTH PROGRAM"]
[{"$f":"E4","v":20},"Horses",null,"Health Program Provided by Owners",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["Fly Spray",null,null,4,"Pts @",18.95,"/Pt.",null,{"$f":"D86*F86","v":75.8},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["Deworming",1150,"Lbs",4,"Dose @",{"$f":"9.75/23*B87/50","v":9.75},"/Dose",null,39,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["E/W Flu tetanus",null,null,1,"Dose @",20.41,"/Dose",null,20.41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["West Nile Vaccine",null,null,1,"Dose @",18.63,"/Dose",null,18.63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["Rabies Vaccination",null,null,1,"Dose @",2.38,"/Dose",null,2.38]
[null,null,null,0,"Dose @",0,"/Dose",null,0]
["EIA/Coggins",null,null,0,"Test @",15,"/Test",null,0]
[]
[null,"SUB-TOTAL HORSES",null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I86:I93),2)","v":156.22}]
[]
[]
["Your Farm Veterinarian",null,null,0,"Trip(s) @",250,"Per Trip",".",null,{"$f":"D97*F97","v":0}]
[]
["TOTAL HEALTH COST FOR HERD =",null,".",null,null,null,null,null,null,{"$f":"J94+J96+J97","v":156.22}]
[]
[null,null,null,null,null,"Trade and brand names are used only for the purpose of providing information.  Virginia Cooperative Extension does not guarantee or warrant"]
["the standard of any product named to the exclusion of others which also may be suitable."]