{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Intro","Information","Income Statement","Crop Revenue","Livestock Revenue","Other Income","Crop Expenses","Livestock Expenses","Other Expenses","Next Year Projections","UT Budgets"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"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":"Intro","index":0,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[[10,0,10,9],[11,1,12,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Income Statement"]
[null,"There are nine worksheets in this workbook. Instructions on how to complete each worksheet are listed below."]
[]
[null,null,"1. On the information tab, enter your farm name or personal information."]
[null,null,"2. The income statement tab will depict the entire picture of what has happened on the operation. (Nothing needs to be entered on this tab)"]
[null,null,"3. Enter any crops grown and their acres on the Crop Revenue tab, and any livestock sold on the Livestock Revenue tab."]
[null,null,"4. Any income that was not received from the sale of crops or livestock should be entered on the Other Income tab. (including personal)"]
[null,null,"5. Enter any expenses experienced from crop production on the Crop Expenses tab, and any livestock expenses on the Livestock Expenses tab."]
[null,null,"6. Any expenses incurred that are not associated with crop or livestock production can be entered on the Other Expenses tab. (including personal)"]
[null,null,"7. After everything is entered you should have a completed view of your operation using the Income Statement tab. "]
[null,null,"8. In addition to the Income Statement, the Next Year Projections tab can be used to evaluate future business decisions using previous operation expenses. "]
[]
[]
[]
[]
[]
[]
[null,null,"For additional information on this tool, click the link below and contact your MANAGE specialist. "]
[null,null,"The MANAGE Program | Department of Agricultural and Resource Economics (tennessee.edu)"]

{"sheet":"Information","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,0,11,0],[10,1,11,1],[16,3,18,5]]}
[]
["Date",null,{"$f":"IF(B2>0,B2,TODAY())","v":"2024-03-25"},"Income Statement"]
["Name",null,null,"Crop Revenue"]
["Address",null,null,"Livestock Revenue"]
["City ",null,null,"Other Income"]
["State ",null,null,"Crop Expenses"]
["ZIP",null,null,"Livestock Expenses"]
["Phone",null,null,"Other Expenses"]
["Beginning Date"]
["End Date"]
["Business Name (if different)"]

{"sheet":"Income Statement","index":2,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":false,"merged":[[45,4,45,5],[39,3,39,4],[40,3,40,4],[36,5,36,6],[37,5,37,6],[38,5,38,6],[41,3,41,4],[42,5,42,6],[42,2,42,4],[56,4,56,5],[47,5,47,6],[49,5,49,6],[47,3,47,4],[48,3,48,4],[49,3,49,4],[52,5,52,6],[53,5,53,6],[54,5,54,6],[55,5,55,6],[52,3,52,4],[54,3,54,4],[7,5,7,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[46,5,46,6],[34,5,34,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[33,5,33,6],[35,5,35,6],[44,6,44,7],[44,4,44,5],[39,5,39,6],[40,5,40,6],[36,3,36,4],[58,6,58,7],[58,3,58,5],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[51,5,51,6],[50,4,50,5],[37,3,37,4],[38,3,38,4],[56,6,56,7],[33,3,33,4],[35,3,35,4],[26,5,26,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[34,3,34,4],[27,3,27,4],[28,3,28,4],[32,3,32,4],[25,5,25,6],[27,5,27,6],[28,5,28,6],[32,5,32,6],[29,3,29,4],[30,3,30,4],[7,1,7,2],[18,1,18,2],[46,1,46,2],[51,1,51,2],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[31,3,31,4],[5,1,5,2],[4,1,4,2],[3,1,3,2],[2,5,2,6],[0,1,0,6],[2,1,2,2],[3,5,3,6],[16,1,16,3],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[17,4,17,5],[21,5,21,6]]}
[null,"Income Statement"]
[]
[null,{"$f":"+Information!B3&\" (\"&Information!B11&\")\"","v":" ()"},null,null,null,"Beginning Date:",null,{"$f":"Information!B9","v":"00:00:00"}]
[null,{"$f":"+Information!B4","v":0},null,null,null,"End Date:",null,{"$f":"Information!B10","v":"00:00:00"},null,"Crop Revenue"]
[null,{"$f":"CONCATENATE(Information!B5, \", \", Information!B6, \", \",  Information!B7)","v":", , "},null,null,null,null,null,null,null,"Livestock Revenue"]
[null,{"$f":"IF(Information!B8>0, Information!B8,\" \")","v":" "},null,null,null,null,null,null,null,"Other Income"]
[null,null,null,null,null,null,null,null,null,"Crop Expenses"]
[null,"Farm Income",null,null,null,"Value",null,null,null,"Livestock Expenses"]
[null,null,"Income from Crop Sales","…...........................",null,{"$f":"'Crop Revenue'!F34","v":0},null,null,null,"Other Expenses"]
[null,null,"Income from Livestock Sales","…...........................",null,{"$f":"'Livestock Revenue'!F35","v":0}]
[]
[null,null,"Crop/Livestock Insurance","…...........................",null,{"$f":"SUMIF('Other Income'!C4:C34,'Other Income'!H5,'Other Income'!E4:E34)","v":0}]
[null,null,"Custom Hire Income","…...........................",null,{"$f":"SUMIF('Other Income'!C4:C34,'Other Income'!H4,'Other Income'!E4:E34)","v":0}]
[null,null,"Government Payments","…...........................",null,{"$f":"SUMIF('Other Income'!D4:D34,'Other Income'!H6,'Other Income'!E4:E34)","v":0}]
[null,null,"Other Farm Income","…...........................",null,{"$f":"'Other Income'!E35-(F12+F13)-(SUMIF('Other Income'!C4:C34,'Other Income'!H8,'Other Income'!E4:E34))","v":0}]
[]
[null,"Total Income",null,null,null,{"$f":"SUM(F9:F16)","v":0}]
[]
[null,"Farm Expenses",null,null,null,"Value"]
[null,null,"Chemical","…...........................",null,{"$f":"SUMIF('Crop Expenses'!C5:C34,'Crop Expenses'!G5,'Crop Expenses'!E5:E34)","v":0}]
[null,null,"Custom Hire","…...........................",null,{"$f":"(SUMIF('Crop Expenses'!C5:C34,'Crop Expenses'!G6,'Crop Expenses'!E5:E34))+(SUMIF('Livestock Expenses'!C4:C34,'Livestock Expenses'!G5,'Livestock Expenses'!E4:E34))","v":0}]
[null,null,"Employee Benefits","…...........................",null,{"$f":"(SUMIF('Crop Expenses'!C5:C34,'Crop Expenses'!G7,'Crop Expenses'!E5:E34))+(SUMIF('Livestock Expenses'!C4:C34,'Livestock Expenses'!G6,'Livestock Expenses'!E4:E34))","v":0}]
[null,null,"Equipment (Purchases & Lease)","…...........................",null,{"$f":"(SUMIF('Crop Expenses'!C5:C34,'Crop Expenses'!G8,'Crop Expenses'!E5:E34))+(SUMIF('Livestock Expenses'!C4:C34,'Livestock Expenses'!G7,'Livestock Expenses'!E4:E34))","v":0}]
[null,null,"Feed","…...........................",null,{"$f":"SUMIF('Livestock Expenses'!C4:C34,'Livestock Expenses'!G8,'Livestock Expenses'!E4:E34)","v":0}]
[null,null,"Fertilizer (Nutrients)","…...........................",null,{"$f":"SUMIF('Crop Expenses'!C5:C34,'Crop Expenses'!G9,'Crop Expenses'!E5:E34)","v":0}]
[null,null,"Freight/Trucking","…...........................",null,{"$f":"(SUMIF('Crop Expenses'!C5:C34,'Crop Expenses'!G10,'Crop Expenses'!E5:E34))+(SUMIF('Livestock Expenses'!C4:C34,'Livestock Expenses'!G9,'Livestock Expenses'!E4:E34))","v":0}]
[null,null,"Fuel","…...........................",null,{"$f":"(SUMIF('Crop Expenses'!C5:C34,'Crop Expenses'!G11,'Crop Expenses'!E5:E34))+(SUMIF('Livestock Expenses'!C4:C34,'Livestock Expenses'!G10,'Livestock Expenses'!E4:E34))","v":0}]
[null,null,"Hired Labor","…...........................",null,{"$f":"(SUMIF('Crop Expenses'!C5:C34,'Crop Expenses'!G12,'Crop Expenses'!E5:E34))+(SUMIF('Livestock Expenses'!C4:C34,'Livestock Expenses'!G11,'Livestock Expenses'!E4:E34))","v":0}]
[null,null,"Insurance","…...........................",null,{"$f":"(SUMIF('Crop Expenses'!C5:C34,'Crop Expenses'!G13,'Crop Expenses'!E5:E34))+(SUMIF('Livestock Expenses'!C4:C34,'Livestock Expenses'!G12,'Livestock Expenses'!E4:E34))","v":0}]
[null,null,"Interest Paid","…...........................",null,{"$f":"(SUMIF('Crop Expenses'!C5:C34,'Crop Expenses'!G14,'Crop Expenses'!E5:E34))+(SUMIF('Livestock Expenses'!C4:C34,'Livestock Expenses'!G13,'Livestock Expenses'!E4:E34))","v":0}]
[null,null,"Livestock Purchase","…...........................",null,{"$f":"SUMIF('Livestock Expenses'!C4:C34,'Livestock Expenses'!G14,'Livestock Expenses'!E4:E34)","v":0}]
[null,null,"Other Expenses","…...........................",null,{"$f":"(SUMIF('Crop Expenses'!C5:C34,'Crop Expenses'!G23,'Crop Expenses'!E5:E34))+(SUMIF('Livestock Expenses'!C4:C34,'Livestock Expenses'!G23,'Livestock Expenses'!E4:E34))","v":0}]
[null,null,"Rent or Lease Payments","…...........................",null,{"$f":"(SUMIF('Crop Expenses'!C5:C34,'Crop Expenses'!G15,'Crop Expenses'!E5:E34))+(SUMIF('Livestock Expenses'!C4:C34,'Livestock Expenses'!G15,'Livestock Expenses'!E4:E34))","v":0}]
[null,null,"Repairs/Maintenance","…...........................",null,{"$f":"(SUMIF('Crop Expenses'!C5:C34,'Crop Expenses'!G16,'Crop Expenses'!E5:E34))+(SUMIF('Livestock Expenses'!C4:C34,'Livestock Expenses'!G16,'Livestock Expenses'!E4:E34))","v":0}]
[null,null,"Seed","…...........................",null,{"$f":"SUMIF('Crop Expenses'!C5:C34,'Crop Expenses'!G17,'Crop Expenses'!E5:E34)","v":0}]
[null,null,"Storage","…...........................",null,{"$f":"(SUMIF('Crop Expenses'!C5:C34,'Crop Expenses'!G18,'Crop Expenses'!E5:E34))+(SUMIF('Livestock Expenses'!C4:C34,'Livestock Expenses'!G17,'Livestock Expenses'!E4:E34))","v":0}]
[null,null,"Supplies","…...........................",null,{"$f":"(SUMIF('Crop Expenses'!C5:C34,'Crop Expenses'!G19,'Crop Expenses'!E5:E34))+(SUMIF('Livestock Expenses'!C4:C34,'Livestock Expenses'!G18,'Livestock Expenses'!E4:E34))","v":0}]
[null,null,"Taxes (Farm)","…...........................",null,{"$f":"(SUMIF('Crop Expenses'!C5:C34,'Crop Expenses'!G20,'Crop Expenses'!E5:E34))+(SUMIF('Livestock Expenses'!C4:C34,'Livestock Expenses'!G19,'Livestock Expenses'!E4:E34))","v":0}]
[null,null,"Utilities","…...........................",null,{"$f":"(SUMIF('Crop Expenses'!C5:C34,'Crop Expenses'!G21,'Crop Expenses'!E5:E34))+(SUMIF('Livestock Expenses'!C4:C34,'Livestock Expenses'!G20,'Livestock Expenses'!E4:E34))","v":0}]
[null,null,"Vehicle(s)","…...........................",null,{"$f":"(SUMIF('Crop Expenses'!C5:C34,'Crop Expenses'!G22,'Crop Expenses'!E5:E34))+(SUMIF('Livestock Expenses'!C4:C34,'Livestock Expenses'!G21,'Livestock Expenses'!E4:E34))","v":0}]
[null,null,"Vet/Medical/AI","…...........................",null,{"$f":"SUMIF('Livestock Expenses'!C4:C34,'Livestock Expenses'!G22,'Livestock Expenses'!E4:E34)","v":0}]
[]
[null,null,"Total Farm Expenses",null,null,{"$f":"SUM(F20:G41)","v":0}]
[]
[null,null,null,null,"Net Farm Income",null,{"$f":"F17-F43","v":0}]
[]
[null,"Off-Farm Income",null,null,null,"Value"]
[null,null,"Personal Income","…...........................",null,{"$f":"SUMIF('Other Income'!D4:D34,'Other Income'!H8,'Other Income'!E4:E34)","v":0}]
[]
[null,null,null,"Total Personal Income",null,{"$f":"SUM(F48:G49)","v":0}]
[]
[null,"Off-Farm Expenses",null,null,null,"Value"]
[null,null,"Personal Expenses","…...........................",null,{"$f":"SUMIF('Other Expenses'!C4:C34,'Other Expenses'!H4,'Other Expenses'!E4:E34)","v":0}]
[]
[null,null,null,"Total Personal Expense",null,{"$f":"SUM(F53)","v":0}]
[]
[null,null,null,null,"Net Personal Income",null,{"$f":"F50-F55","v":0}]
[]
[null,null,null,"Total Net Income",null,null,{"$f":"G45+G57","v":0}]

{"sheet":"Crop Revenue","index":3,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,2,1,5]]}
[null,null,"Crops Sold"]
["Livestock Revenue"]
["Other Income",null,"Crop Type*","Description (optional)","Quantity","Value*",null,"Crop Type"]
["Crop Expenses",null,null,null,null,null,null,"Corn"]
["Livestock Expenses",null,null,null,null,null,null,"Cotton"]
["Other Expenses",null,null,null,null,null,null,"Hay"]
["Income Statement",null,null,null,null,null,null,"Sorghum or Milo"]
[null,null,null,null,null,null,null,"Tobacco"]
[null,null,null,null,null,null,null,"Wheat"]
[null,null,null,null,null,null,null,"Other"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Total",{"$f":"SUM(F4:F33)","v":0}]

{"sheet":"Livestock Revenue","index":4,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,2,1,5]]}
[null,null,"Livestock Sold"]
["Crop Revenue"]
["Other Income",null,"Livestock Type*","Number of head*","Value per head","Value* ",null,"Livestock Type"]
["Crop Expenses",null,null,null,{"$f":"IFERROR(F4/D4,0)","v":0},null,null,"Purchased Cattle"]
["Livestock Expenses",null,null,null,{"$f":"IFERROR(F5/D5,0)","v":0},null,null,"Raised Cattle"]
["Other Expenses",null,null,null,0,null,null,"Purchased Small Ruminant"]
["Income Statement",null,null,null,0,null,null,"Raised Small Ruminant"]
[null,null,null,null,0,null,null,"Purchased Swine"]
[null,null,null,null,0,null,null,"Raised Swine"]
[null,null,null,null,0,null,null,"Purchased Poultry"]
[null,null,null,null,0,null,null,"Raised Poultry"]
[null,null,null,null,0,null,null,"Purchased Other"]
[null,null,null,null,0,null,null,"Raised Other"]
[null,null,null,null,0,null,null,"Breeding Expenses (AI)"]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,"Total",{"$f":"SUM(F4:F34)","v":0}]

{"sheet":"Other Income","index":5,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,2,1,4]]}
[null,null,"Other Income"]
["Crop Revenue"]
["Livestock Revenue",null,"Description","Type*","Value*",null,null,"Types of Other Income"]
["Crop Expenses",null,null,null,null,null,null,"Custom Hire"]
["Livestock Expenses",null,null,null,null,null,null,"Crop / Livestock Insurance"]
["Other Expenses",null,null,null,null,null,null,"Government Payments"]
["Income Statement",null,null,null,null,null,null,"Investments Income (Real Estate, CD's, Dividends)"]
[null,null,null,null,null,null,null,"Personal"]
[null,null,null,null,null,null,null,"Other Income"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Total",{"$f":"SUM(E4:E34)","v":0}]

{"sheet":"Crop Expenses","index":6,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,2,2,4]]}
[]
["Crop Revenue",null,"Crop Expenses"]
["Livestock Revenue"]
["Other Income",null,"Expense Type*","Description (optional)","Value*",null,"Expense Type"]
["Livestock Expenses",null,null,null,null,null,"Chemical"]
["Other Expenses",null,null,null,null,null,"Custom Hire"]
["Income Statement",null,null,null,null,null,"Employee Benefits"]
[null,null,null,null,null,null,"Equipment (Purchases & Lease)"]
[null,null,null,null,null,null,"Fertilizer (Nutrients)"]
[null,null,null,null,null,null,"Freight / Trucking"]
[null,null,null,null,null,null,"Fuel"]
[null,null,null,null,null,null,"Hired Labor"]
[null,null,null,null,null,null,"Insurance"]
[null,null,null,null,null,null,"Interest Paid"]
[null,null,null,null,null,null,"Rent or Lease Payments"]
[null,null,null,null,null,null,"Repairs / Maintenance"]
[null,null,null,null,null,null,"Seed"]
[null,null,null,null,null,null,"Storage"]
[null,null,null,null,null,null,"Supplies"]
[null,null,null,null,null,null,"Taxes (Farm)"]
[null,null,null,null,null,null,"Utilities"]
[null,null,null,null,null,null,"Vehicle(s)"]
[null,null,null,null,null,null,"Other Expenses"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Total",{"$f":"SUM(E5:E34)","v":0}]

{"sheet":"Livestock Expenses","index":7,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,2,1,4]]}
[null,null,"Livestock Expense"]
["Crop Revenue"]
["Livestock Revenue",null,"Expense Type*","Description (optional)","Value* ",null,"Expense Type"]
["Other Income",null,null,null,null,null,"Breeding Expenses (AI)"]
["Crop Expenses",null,null,null,null,null,"Custom Hire"]
["Other Expenses",null,null,null,null,null,"Employee Benefits"]
["Income Statement",null,null,null,null,null,"Equipment (Purchases & Lease)"]
[null,null,null,null,null,null,"Feed"]
[null,null,null,null,null,null,"Freight/Trucking"]
[null,null,null,null,null,null,"Fuel"]
[null,null,null,null,null,null,"Hired Labor"]
[null,null,null,null,null,null,"Insurance"]
[null,null,null,null,null,null,"Interest Paid"]
[null,null,null,null,null,null,"Livestock Purchase"]
[null,null,null,null,null,null,"Rent or Lease Payments"]
[null,null,null,null,null,null,"Repairs/Maintenance"]
[null,null,null,null,null,null,"Storage"]
[null,null,null,null,null,null,"Supplies"]
[null,null,null,null,null,null,"Taxes (Farm)"]
[null,null,null,null,null,null,"Utilities"]
[null,null,null,null,null,null,"Vehicle(s)"]
[null,null,null,null,null,null,"Vet/Medical"]
[null,null,null,null,null,null,"Other Expenses"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Total",{"$f":"SUM(E4:E34)","v":0}]

{"sheet":"Other Expenses","index":8,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,2,1,4]]}
[null,null,"Other Expenses"]
["Crop Revenue"]
["Livestock Revenue",null,"Expense Type*","Description","Value*",null,null,"Types of Other Expense"]
["Other Income",null,null,null,null,null,null,"Personal "]
["Crop Expenses",null,null,null,null,null,null,"Real Estate"]
["Livestock Expenses",null,null,null,null,null,null,"Investment"]
["Income Statement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Total",{"$f":"SUM(E4:E34)","v":0}]

{"sheet":"Next Year Projections","index":9,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[[7,1,7,2],[48,3,48,4],[49,5,49,6],[51,6,52,6],[51,4,52,5],[25,5,25,6],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[45,5,45,6],[46,5,46,6],[47,5,47,6],[45,3,45,4],[46,3,46,4],[47,3,47,4],[42,5,42,6],[43,5,43,6],[44,5,44,6],[42,3,42,4],[43,3,43,4],[44,3,44,4],[39,5,39,6],[40,5,40,6],[41,5,41,6],[39,3,39,4],[40,3,40,4],[41,3,41,4],[37,5,37,6],[38,5,38,6],[37,3,37,4],[38,3,38,4],[34,5,34,6],[35,5,35,6],[36,5,36,6],[32,5,32,6],[33,5,33,6],[31,5,31,6],[6,0,6,2],[23,4,23,5],[24,0,24,2],[0,0,1,7],[27,5,27,6],[28,5,28,6],[29,5,29,6],[30,5,30,6],[2,0,5,7],[26,5,26,6],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2]]}
["Income and Expense Projections"]
[]
[]
[]
[]
[]
["Income"]
[null,"Crops",null,"Acreage*","Proj. Yield*","$/ Unit*","Gross Income/Crop"]
[null,"Corn",null,null,null,null,{"$f":"((D9*E9)*F9)","v":0}]
[null,"Cotton",null,null,null,null,{"$f":"((D10*E10)*F10)","v":0}]
[null,"Milo",null,null,null,null,0]
[null,"Soybeans",null,null,null,null,0]
[null,"Wheat",null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"SUM(G9:G13)","v":0}]
[]
[null,"Livestock","Livestock","# of Head to be sold*","cwt at time of Sale*","$/cwt.*","Gross Income/Stock"]
[null,"Market Stock",null,null,null,null,{"$f":"((E17*F17)*D17)","v":0}]
[null,"Market Stock",null,null,null,null,{"$f":"((E18*F18)*D18)","v":0}]
[null,"Market Stock",null,null,null,null,{"$f":"((E19*F19)*D19)","v":0}]
[null,null,null,"# of Head to be sold*","Value per head*"]
[null,"Breeding Stock",null,null,null,null,{"$f":"((E21*D21))","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G17:G21)","v":0}]
[]
[null,null,null,null,"Projected Gross Income",null,{"$f":"G14+G22","v":0}]
["Expenses"]
[null,null,"Crop & Livestock",null,null,"Value"]
[null,null,"Chemical","…...........................",null,0,0]
[null,null,"Custom Hire","…...........................",null,0,0]
[null,null,"Employee Benefits","…...........................",null,0,0]
[null,null,"Equipment (Purchases & Lease)","…...........................",null,0,0]
[null,null,"Feed","…...........................",null,0,0]
[null,null,"Fertilizer (Nutrients)","…...........................",null,0,0]
[null,null,"Freight/Trucking","…...........................",null,0,0]
[null,null,"Fuel","…...........................",null,0,0]
[null,null,"Hired Labor","…...........................",null,0,0]
[null,null,"Insurance","…...........................",null,0,0]
[null,null,"Interest Paid","…...........................",null,0,0]
[null,null,"Livestock Purchase","…...........................",null,0,0]
[null,null,"Other Expenses","…...........................",null,0,0]
[null,null,"Rent or Lease Payments","…...........................",null,0,0]
[null,null,"Repairs/Maintenance","…...........................",null,0,0]
[null,null,"Seed","…...........................",null,0,0]
[null,null,"Storage","…...........................",null,0,0]
[null,null,"Supplies","…...........................",null,0,0]
[null,null,"Taxes (Farm)","…...........................",null,0,0]
[null,null,"Utilities","…...........................",null,0,0]
[null,null,"Vehicle(s)","…...........................",null,0,0]
[null,null,"Vet/Medical/AI","…...........................",null,0,0]
[]
[null,null,null,null,"Total Farm Expenses",{"$f":"SUM(G27:G48)","v":0}]
[]
[null,null,null,null,"Projected Net Income",null,{"$f":"SUM(G24-F50)","v":0}]

{"sheet":"UT Budgets","index":10,"n_rows":41,"n_cols":35,"rows_kept":41,"cut":false,"hidden":true,"merged":[[18,14,18,17],[28,28,28,30],[3,14,3,17],[14,28,14,30],[19,28,19,30],[20,28,20,30],[27,28,27,30],[14,23,14,25],[19,23,19,25],[20,23,20,25],[27,23,27,25],[28,23,28,25],[27,14,27,17],[28,14,28,17]]}
[]
["Chemical",{"$f":"VLOOKUP(A2,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(B2,0)","v":0},{"$f":"+C2","v":0},"Chemical",{"$f":"VLOOKUP(E2,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(F2,0)","v":0}]
["Custom Hire",{"$f":"VLOOKUP(A3,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(B3,0)","v":0},{"$f":"+C3+'UT Budgets'!C23","v":0},"Custom Hire",{"$f":"VLOOKUP(E3,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"+G3+'UT Budgets'!G23","v":0}]
["Employee Benefits",{"$f":"VLOOKUP(A4,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(B4,0)","v":0},{"$f":"+C4+'UT Budgets'!C24","v":0},"Employee Benefits",{"$f":"VLOOKUP(E4,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"+G4+'UT Budgets'!G24","v":0},null,null,null,null,null,null,"Crops",null,null,null,"Corn","Cotton","Soybeans ","Wheat",null,"Cattle","Unit","Quantity","$/Cow",null,"Goat / Sheep","Unit","Quantity","$/head"]
["Equipment (Purchases & Lease)",{"$f":"VLOOKUP(A5,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(B5,0)","v":0},{"$f":"+C5+'UT Budgets'!G25","v":0},"Equipment (Purchases & Lease)",{"$f":"VLOOKUP(E5,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"+G5+'UT Budgets'!G25","v":0},null,"Chemical",{"$f":"SUM('Next Year Projections'!$D$9*'UT Budgets'!S7+'Next Year Projections'!$D$10*'UT Budgets'!T7+'Next Year Projections'!$D$12*'UT Budgets'!U7+'Next Year Projections'!$D$13*'UT Budgets'!V7)","v":0},null,null,null,"Seed",null,"Thous.",32,115.2,132.5,63,45,null,"Pasture Production","acre",2,287.74,null,"Pasture Production","acre",0.5,16.98]
["Feed",{"$f":"VLOOKUP(A6,'Livestock Expenses'!$C$4:$E$34,3,)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(B6,0)","v":0},{"$f":"+C6","v":0},"Fertilizer (Nutrients)",{"$f":"VLOOKUP(E6,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,null,null,"Custom Hire",{"$f":"SUM('Next Year Projections'!$D$9*'UT Budgets'!S8+'Next Year Projections'!$D$10*'UT Budgets'!T8+'Next Year Projections'!$D$12*'UT Budgets'!U8+'Next Year Projections'!$D$13*'UT Budgets'!V8)+('Next Year Projections'!$D$9*'UT Budgets'!S14+'Next Year Projections'!$D$10*'UT Budgets'!T14+'Next Year Projections'!$D$12*'UT Budgets'!U14+'Next Year Projections'!$D$13*'UT Budgets'!V14)","v":0},null,null,null,"Fertilizer & Lime",null,"Acre",1,213.86,141.13,62.66,124.95,null,"Hay Production","acre",0.9,200.58,null,"Hay Production","ton",12.29,19.66]
["Fertilizer (Nutrients)",{"$f":"VLOOKUP(A7,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(B7,0)","v":0},{"$f":"+C7","v":0},"Freight / Trucking",{"$f":"VLOOKUP(E7,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"SUM($G$7+$G$27)","v":0},null,"Employee Benefits",0,null,null,null,"Chemical",null,"Acre",1,71.92,191.61,87.15,75.06,null,"Purchased Hay per Cow","ton",0,0,null,"Purchased Hay per head","ton",0," $               -  "]
["Freight / Trucking",{"$f":"VLOOKUP(A8,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"SUM($G$7+$G$27)","v":0},"Fuel",{"$f":"VLOOKUP(E8,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"SUM($G$8+$G$28)","v":0},null,"Equipment (Purchases & Lease)",{"$f":"SUM('Next Year Projections'!$D$9*'UT Budgets'!S13+'Next Year Projections'!$D$10*'UT Budgets'!T13+'Next Year Projections'!$D$12*'UT Budgets'!U13+'Next Year Projections'!$D$13*'UT Budgets'!V13)+AI24","v":0},null,null,null,"Crop Scout or Consultant",null,"Acre",1,10,12,10,10,null,"Bull (Pasture & Hay)","$",1.7,33.21]
["Fuel",{"$f":"VLOOKUP(A9,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"SUM($G$8+$G$28)","v":0},"Hired Labor",{"$f":"VLOOKUP(E9,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"SUM($G$9+$G$29)","v":0},null,"Feed",{"$f":"IF('Next Year Projections'!C17=\"Cattle\",'Next Year Projections'!D17*'UT Budgets'!AB11,'Next Year Projections'!D17*'UT Budgets'!AG10)+IF('Next Year Projections'!C18=\"Cattle\",'Next Year Projections'!D18*'UT Budgets'!AB11,'Next Year Projections'!D18*'UT Budgets'!AG10)+IF('Next Year Projections'!C19=\"Cattle\",'Next Year Projections'!D19*'UT Budgets'!AB11,'Next Year Projections'!D19*'UT Budgets'!AG10)+IF('Next Year Projections'!C21=\"Cattle\",'Next Year Projections'!D21*'UT Budgets'!AB11,'Next Year Projections'!D21*'UT Budgets'!AG10)","v":0},null,null,null,"Repair & Maintenance",null,"Acre",1,45.98,32.659999999999997,33.130000000000003,36.96,null,"Supplemental Feed ","head",1,26.78,null,"Supplemental Feed ","bushels",47.01,3.76]
["Hired Labor",{"$f":"VLOOKUP(A10,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"SUM($G$9+$G$29)","v":0},"Insurance",{"$f":"VLOOKUP(E10,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"SUM(G10+G30)","v":0},null,"Fertilizer (Nutrients)",{"$f":"SUM('Next Year Projections'!$D$9*'UT Budgets'!S6+'Next Year Projections'!$D$10*'UT Budgets'!T6+'Next Year Projections'!$D$12*'UT Budgets'!U6+'Next Year Projections'!$D$13*'UT Budgets'!V6)","v":0},null,null,null,"Fuel, Oil & Filter",null,"Acre",1,25.76,32.950000000000003,17.37,22.24,null,"Salt & Mineral","lb",91,41.98,null,"Salt & Mineral","lb",383.93,2.76,{"$f":"SUM(AF5:AF10)","v":43.16}]
["Insurance",{"$f":"VLOOKUP(A11,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"SUM(C11+C31)","v":0},"Interest Paid",{"$f":"VLOOKUP(E11,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"SUM($G$11+$G$31)","v":0},null,"Freight / Trucking",0,null,null,null,"Operator Labor ",null,"Acre",1,13.98,15.44,8.9,11.84,null,"Vet & Med","head",1,33.090000000000003,{"$f":"SUM(AA5:AA10)","v":590.29000000000008},"Vet & Med","head",1,6.47]
["Interest Paid",{"$f":"VLOOKUP(A12,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"SUM($G$11+$G$31)","v":0},"Rent or Lease Payments",{"$f":"VLOOKUP(E12,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"SUM($G$12+$G$33)","v":0},null,"Fuel",{"$f":"SUM('Next Year Projections'!$D$9*'UT Budgets'!S10+'Next Year Projections'!$D$10*'UT Budgets'!T10+'Next Year Projections'!$D$12*'UT Budgets'!U10+'Next Year Projections'!$D$13*'UT Budgets'!V10)+('Next Year Projections'!$D$9*'UT Budgets'!S15+'Next Year Projections'!$D$10*'UT Budgets'!T15+'Next Year Projections'!$D$12*'UT Budgets'!U15+'Next Year Projections'!$D$13*'UT Budgets'!V15)","v":0},null,null,null,"Crop Insurance",null,"Acre",1,20.399999999999999,12.5,11.22,14.6,null,"Reproduction (Artificial Insemination)","head",0," $               -  ",{"$f":"SUM(AA11:AA12)","v":33.090000000000003},"Reproduction (Artificial Insemination)","head",0," $               -  ",{"$f":"AF11:AF12","v":6.47}]
["Livestock Purchase",{"$f":"VLOOKUP(A13,'Livestock Expenses'!$C$4:$E$34,3,)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(B13,0)","v":0},{"$f":"+C13","v":0},"Repairs / Maintenance",{"$f":"VLOOKUP(E13,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"SUM($G$13+$G$34)","v":0},null,"Hired Labor",{"$f":"SUM('Next Year Projections'!$D$9*'UT Budgets'!S11+'Next Year Projections'!$D$10*'UT Budgets'!T11+'Next Year Projections'!$D$12*'UT Budgets'!U11+'Next Year Projections'!$D$13*'UT Budgets'!V11)+('Next Year Projections'!$D$9*'UT Budgets'!S26+'Next Year Projections'!$D$10*'UT Budgets'!T26+'Next Year Projections'!$D$12*'UT Budgets'!U26+'Next Year Projections'!$D$13*'UT Budgets'!V26)+AI14","v":0},null,null,null,"Machinery Rental ",null,"Acre",1,0,0,0,0,null,"Other Expenses","head",1,1.5,null,"Other Expenses","head",1,{"$f":"27.61-5.6","v":22.009999999999998}," $               -  ",null,{"$f":"IF('Next Year Projections'!C17=\"Cattle\",'Next Year Projections'!D17*'UT Budgets'!AA13,'Next Year Projections'!D17*'UT Budgets'!AF13)+IF('Next Year Projections'!C18=\"Cattle\",'Next Year Projections'!D18*'UT Budgets'!AA13,'Next Year Projections'!D18*'UT Budgets'!AF13)+IF('Next Year Projections'!C19=\"Cattle\",'Next Year Projections'!D19*'UT Budgets'!AA13,'Next Year Projections'!D19*'UT Budgets'!AF13)+IF('Next Year Projections'!C21=\"Cattle\",'Next Year Projections'!D21*'UT Budgets'!AA13,'Next Year Projections'!D21*'UT Budgets'!AF13)","v":0}]
["Other Expenses",{"$f":"VLOOKUP(A14,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(B14,0)","v":0},{"$f":"SUM($G$20+$G$41)","v":0},"Seed",{"$f":"VLOOKUP(E14,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"+G14","v":0},null,"Insurance",{"$f":"SUM('Next Year Projections'!$D$9*'UT Budgets'!S12+'Next Year Projections'!$D$10*'UT Budgets'!T12+'Next Year Projections'!$D$12*'UT Budgets'!U12+'Next Year Projections'!$D$13*'UT Budgets'!V12)+('Next Year Projections'!$D$9*'UT Budgets'!S25+'Next Year Projections'!$D$10*'UT Budgets'!T25+'Next Year Projections'!$D$12*'UT Budgets'!U25+'Next Year Projections'!$D$13*'UT Budgets'!V25)","v":0},null,null,null,"Custom Work",null,"Acre",1,0,0,0,0,null,"Labor","hours",8,120,null,"Labor","hours",8,30,null,null,{"$f":"IF('Next Year Projections'!C$17=\"Cattle\",'Next Year Projections'!D$17*'UT Budgets'!AA14,'Next Year Projections'!D$17*'UT Budgets'!AF14)+IF('Next Year Projections'!C$18=\"Cattle\",'Next Year Projections'!D$18*'UT Budgets'!AA14,'Next Year Projections'!D$18*'UT Budgets'!AF14)+IF('Next Year Projections'!C$19=\"Cattle\",'Next Year Projections'!D$19*'UT Budgets'!AA14,'Next Year Projections'!D$19*'UT Budgets'!AF14)+IF('Next Year Projections'!C$21=\"Cattle\",'Next Year Projections'!D$21*'UT Budgets'!AA14,'Next Year Projections'!D$21*'UT Budgets'!AF14)","v":0}]
["Rent or Lease Payments",{"$f":"VLOOKUP(A15,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"SUM($G$12+$G$33)","v":0},"Storage",{"$f":"VLOOKUP(E15,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"+$G$15+$G$35","v":0},null,"Interest Paid",{"$f":"SUM('Next Year Projections'!$D$9*'UT Budgets'!S18+'Next Year Projections'!$D$10*'UT Budgets'!T18+'Next Year Projections'!$D$12*'UT Budgets'!U18+'Next Year Projections'!$D$13*'UT Budgets'!V18)+AI17","v":0},null,null,null,"Drying (Fuel/Electric)",null,"Bu",175,0,0,0,0,null,"Production Expenses",null,null,744.88,null,"Production Expenses",null,null,101.64]
["Repairs / Maintenance",{"$f":"VLOOKUP(A16,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"SUM($G$13+$G$34)","v":0},"Supplies",{"$f":"VLOOKUP(E16,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"+$G$16+$G$36","v":0},null,"Livestock Purchase",{"$f":"IF('Next Year Projections'!C17=\"Cattle\",'Next Year Projections'!D17*'UT Budgets'!AA25,0)+IF('Next Year Projections'!C18=\"Cattle\",'Next Year Projections'!D18*'UT Budgets'!AA25,0)+IF('Next Year Projections'!C19=\"Cattle\",'Next Year Projections'!D19*'UT Budgets'!AA25,0)","v":0},null,null,null,"Other",null,"Acre",1,0,23,0,0]
["Seed",{"$f":"VLOOKUP(A17,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"+C17","v":0},"Taxes (Farm)",{"$f":"VLOOKUP(E17,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"+$G$17+$G$37","v":0},null,"Other Expenses",{"$f":"+AI13+AI18+AI27","v":0},null,null,null,"Other",null,"Acre",1,0,0,0,0,null,"Interest","$",797.42,26.07,null,"Interest","$",8.5000000000000006E-2,3.6707976047991067,null,null,{"$f":"IF('Next Year Projections'!C$17=\"Cattle\",'Next Year Projections'!D$17*'UT Budgets'!AA17,'Next Year Projections'!D$17*'UT Budgets'!AF17)+IF('Next Year Projections'!C$18=\"Cattle\",'Next Year Projections'!D$18*'UT Budgets'!AA17,'Next Year Projections'!D$18*'UT Budgets'!AF17)+IF('Next Year Projections'!C$19=\"Cattle\",'Next Year Projections'!D$19*'UT Budgets'!AA17,'Next Year Projections'!D$19*'UT Budgets'!AF17)+IF('Next Year Projections'!C$21=\"Cattle\",'Next Year Projections'!D$21*'UT Budgets'!AA17,'Next Year Projections'!D$21*'UT Budgets'!AF17)+IF('Next Year Projections'!C$17=\"Cattle\",0,'Next Year Projections'!D$17*'UT Budgets'!AF26)+IF('Next Year Projections'!C$18=\"Cattle\",0,'Next Year Projections'!D$18*'UT Budgets'!AF26)+IF('Next Year Projections'!C$19=\"Cattle\",0,'Next Year Projections'!D$19*'UT Budgets'!AF26)+IF('Next Year Projections'!C$21=\"Cattle\",0,'Next Year Projections'!D$21*'UT Budgets'!AF26)","v":0}]
["Storage",{"$f":"VLOOKUP(A18,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"+$G$15+$G$35","v":0},"Utilities",{"$f":"VLOOKUP(E18,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"+$G$18+$G$38","v":0},null,"Rent or Lease Payments",{"$f":"SUM(('Next Year Projections'!$D$9*'UT Budgets'!S24+'Next Year Projections'!$D$10*'UT Budgets'!T24+'Next Year Projections'!$D$12*'UT Budgets'!U24+'Next Year Projections'!$D$13*'UT Budgets'!V24))+AI19","v":0},null,null,null,"Operating Interest",null,"%",8.5000000000000006E-2,21.98,25.24,12.47,14.48,null,"Marketing","head",0.86,35.97,null,"Marketing","head",1,9.1300000000000008,null,null,{"$f":"IF('Next Year Projections'!C$17=\"Cattle\",'Next Year Projections'!D$17*'UT Budgets'!AA18,'Next Year Projections'!D$17*'UT Budgets'!AF18)+IF('Next Year Projections'!C$18=\"Cattle\",'Next Year Projections'!D$18*'UT Budgets'!AA18,'Next Year Projections'!D$18*'UT Budgets'!AF18)+IF('Next Year Projections'!C$19=\"Cattle\",'Next Year Projections'!D$19*'UT Budgets'!AA18,'Next Year Projections'!D$19*'UT Budgets'!AF18)","v":0}]
["Supplies",{"$f":"VLOOKUP(A19,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"+$G$16+$G$36","v":0},"Vehicle(s)",{"$f":"VLOOKUP(E19,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"SUM($G$19+$G$39)","v":0},null,"Repairs / Maintenance",{"$f":"SUM('Next Year Projections'!$D$9*'UT Budgets'!S9+'Next Year Projections'!$D$10*'UT Budgets'!T9+'Next Year Projections'!$D$12*'UT Budgets'!U9+'Next Year Projections'!$D$13*'UT Budgets'!V9)+AI23","v":0},null,null,null,"Total Variable Expenses",null,null,null,{"$f":"SUM(S5:S18)","v":539.08000000000004},{"$f":"SUM(T5:T18)","v":619.03000000000009},305.90000000000003,355.13,null,"Land Rent","acre",null,0,null,"Land Rent","acre",0,0,null,null,{"$f":"IF(AA19>0,(IF('Next Year Projections'!C$17=\"Cattle\",'Next Year Projections'!D$17*'UT Budgets'!AA19,'Next Year Projections'!D$17*'UT Budgets'!AF19)+IF('Next Year Projections'!C$18=\"Cattle\",'Next Year Projections'!D$18*'UT Budgets'!AA19,'Next Year Projections'!D$18*'UT Budgets'!AF19)+IF('Next Year Projections'!C$19=\"Cattle\",'Next Year Projections'!D$19*'UT Budgets'!AA19,'Next Year Projections'!D$19*'UT Budgets'!AF19)+IF('Next Year Projections'!C$21=\"Cattle\",'Next Year Projections'!D$21*'UT Budgets'!AA19,'Next Year Projections'!D$21*'UT Budgets'!AF19)),0)","v":0}]
["Taxes (Farm)",{"$f":"VLOOKUP(A20,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"+$G$17+$G$37","v":0},"Other Expenses",{"$f":"VLOOKUP(E20,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"SUM($G$20+$G$41)","v":0},null,"Seed",{"$f":"SUM('Next Year Projections'!$D$9*'UT Budgets'!S5+'Next Year Projections'!$D$10*'UT Budgets'!T5+'Next Year Projections'!$D$12*'UT Budgets'!U5+'Next Year Projections'!$D$13*'UT Budgets'!V5)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Total Variable Expenses",null,null,806.92,null,"Total Variable Expenses",null,null,114.44]
["Utilities",{"$f":"VLOOKUP(A21,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"+$G$18+$G$38","v":0},null,null,null,null,null,"Storage",0,null,null,null,"Capital Recovery",null,"Acre",1,127.89,181.02,115.28,107.1]
["Vehicle(s)",{"$f":"VLOOKUP(A22,'Crop Expenses'!$C$5:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"SUM($G$19+$G$39)","v":0},"Breeding Expenses (AI)",{"$f":"VLOOKUP(E22,'Livestock Expenses'!$C$4:$E$34,3,)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(F22,0)","v":0},null,null,"Supplies",0,null,null,null,"Other Fixed Machinery Costs",null,"Acre",1,0,0,0,0]
["Vet / Medical / AI",{"$f":"VLOOKUP(A23,'Livestock Expenses'!$C$4:$E$34,3,)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(B23,0)","v":0},{"$f":"SUM($G$40+$G$22)","v":0},"Custom Hire",{"$f":"VLOOKUP(E23,'Livestock Expenses'!$C$4:$E$34,3,)","v":{"$error":"#N/A"}},{"$f":"_xlfn.IFNA(F23,0)","v":0},null,null,"Taxes (Farm)",0,null,null,null,"General Overhead",null,"Acre",1,20,20,20,20,null,"Livestock Facilities & Equipment","head",1,71.09,null,"Livestock Facilities & Equipment","head",1,5.66,null,null,{"$f":"IF('Next Year Projections'!C$17=\"Cattle\",'Next Year Projections'!D$17*'UT Budgets'!AA23,'Next Year Projections'!D$17*'UT Budgets'!AF23)+IF('Next Year Projections'!C$18=\"Cattle\",'Next Year Projections'!D$18*'UT Budgets'!AA23,'Next Year Projections'!D$18*'UT Budgets'!AF23)+IF('Next Year Projections'!C$19=\"Cattle\",'Next Year Projections'!D$19*'UT Budgets'!AA23,'Next Year Projections'!D$19*'UT Budgets'!AF23)+IF('Next Year Projections'!C$21=\"Cattle\",'Next Year Projections'!D$21*'UT Budgets'!AA23,'Next Year Projections'!D$21*'UT Budgets'!AF23)+IF('Next Year Projections'!C$17=\"Cattle\",0,'Next Year Projections'!D$17*'UT Budgets'!AF25)+IF('Next Year Projections'!C$18=\"Cattle\",0,'Next Year Projections'!D$18*'UT Budgets'!AF25)+IF('Next Year Projections'!C$19=\"Cattle\",0,'Next Year Projections'!D$19*'UT Budgets'!AF25)+IF('Next Year Projections'!C$21=\"Cattle\",0,'Next Year Projections'!D$21*'UT Budgets'!AF25)","v":0}]
[null,null,null,null,"Employee Benefits",{"$f":"VLOOKUP(E24,'Livestock Expenses'!$C$4:$E$34,3,)","v":{"$error":"#N/A"}},0,null,null,"Utilities",0,null,null,null,"Cash Rent",null,"Acre",1,113,113,113,113,null,"Pasture & Hay Machinery/Equipment","head",1,223.16,null,"Pasture & Hay Machinery/Equipment","head",1,14.93,null,null,{"$f":"IF('Next Year Projections'!C$17=\"Cattle\",'Next Year Projections'!D$17*'UT Budgets'!AA24,'Next Year Projections'!D$17*'UT Budgets'!AF24)+IF('Next Year Projections'!C$18=\"Cattle\",'Next Year Projections'!D$18*'UT Budgets'!AA24,'Next Year Projections'!D$18*'UT Budgets'!AF24)+IF('Next Year Projections'!C$19=\"Cattle\",'Next Year Projections'!D$19*'UT Budgets'!AA24,'Next Year Projections'!D$19*'UT Budgets'!AF24)+IF('Next Year Projections'!C$21=\"Cattle\",'Next Year Projections'!D$21*'UT Budgets'!AA24,'Next Year Projections'!D$21*'UT Budgets'!AG25)","v":0}]
[null,null,null,null,"Equipment (Purchases & Lease)",{"$f":"VLOOKUP(E25,'Livestock Expenses'!$C$4:$E$34,3,)","v":{"$error":"#N/A"}},0,null,null,"Vehicle(s)",0,null,null,null,"Insurance (Non-Machinery)",null,"Acre",1,0,0,0,0,null,"Purchased Breeding Stock","head",1,29.91,null,"Fences","head",1,9.0399999999999991,{"$f":"SUM(AF24:AF25)","v":23.97}]
[null,null,null,null,"Feed",{"$f":"VLOOKUP(E26,'Livestock Expenses'!$C$4:$E$34,3,)","v":{"$error":"#N/A"}},0,null,null,"Vet / Medical / AI",{"$f":"IF('Next Year Projections'!C17=\"Cattle\",'Next Year Projections'!D17*'UT Budgets'!AB12,'Next Year Projections'!D17*'UT Budgets'!AG12)+IF('Next Year Projections'!C18=\"Cattle\",'Next Year Projections'!D18*'UT Budgets'!AB12,'Next Year Projections'!D18*'UT Budgets'!AG12)+IF('Next Year Projections'!C19=\"Cattle\",'Next Year Projections'!D19*'UT Budgets'!AB12,'Next Year Projections'!D19*'UT Budgets'!AG12)+IF('Next Year Projections'!C21=\"Cattle\",'Next Year Projections'!D21*'UT Budgets'!AB12,'Next Year Projections'!D21*'UT Budgets'!AG12)","v":0},null,null,null,"Management Labor",null,"Acre",1,25,25,25,25,null,"Purchased Heifers, (not bred)","head",0," $               -  ",null,"Fixed Interest","head",1,15.96]
[null,null,null,null,"Freight / Trucking",{"$f":"VLOOKUP(E27,'Livestock Expenses'!$C$4:$E$34,3,)","v":{"$error":"#N/A"}},0,null,null,null,null,null,null,null,"Other",null,"Acre",1,0,0,0,0,null,"Miscellaneous Overhead","head",1,23.53,null,"Miscellaneous Overhead","head",1,0,null,null,{"$f":"+IF('Next Year Projections'!C17=\"Cattle\",'Next Year Projections'!D17*'UT Budgets'!AA27,'Next Year Projections'!D17*'UT Budgets'!AF27)+IF('Next Year Projections'!C18=\"Cattle\",'Next Year Projections'!D18*'UT Budgets'!AA27,'Next Year Projections'!D18*'UT Budgets'!AF27)+IF('Next Year Projections'!C19=\"Cattle\",'Next Year Projections'!D19*'UT Budgets'!AA27,'Next Year Projections'!D19*'UT Budgets'!AF27)+IF('Next Year Projections'!C21=\"Cattle\",'Next Year Projections'!D21*'UT Budgets'!AA27,'Next Year Projections'!D21*'UT Budgets'!AF27)","v":0}]
[null,null,null,null,"Fuel",{"$f":"VLOOKUP(E28,'Livestock Expenses'!$C$4:$E$34,3,)","v":{"$error":"#N/A"}},0,null,null,null,null,null,null,null,"Total Fixed Expenses",null,null,null,{"$f":"SUM(S21:S27)","v":285.89},{"$f":"SUM(T21:T27)","v":339.02},273.27999999999997,265.10000000000002,null,"Total Fixed Expenses",null,null,347.69,null,"Total Fixed Expenses",null,null,45.59]
[null,null,null,null,"Hired Labor",{"$f":"VLOOKUP(E29,'Livestock Expenses'!$C$4:$E$34,3,)","v":{"$error":"#N/A"}},0,null,null,null,null,null,null,null,"Total Expenses",null,null,null,{"$f":"S19+S28","v":824.97},{"$f":"T19+T28","v":958.05000000000007},{"$f":"U19+U28","v":579.18000000000006},{"$f":"V19+V28","v":620.23},null,"Total Expenses",null,null,1154.6099999999999,null,"Total Expenses",null,null,160.03]
[null,null,null,null,"Insurance",{"$f":"VLOOKUP(E30,'Livestock Expenses'!$C$4:$E$34,3,)","v":{"$error":"#N/A"}},0]
[null,null,null,null,"Interest Paid",{"$f":"VLOOKUP(E31,'Livestock Expenses'!$C$4:$E$34,3,)","v":{"$error":"#N/A"}},0]
[null,null,null,null,"Livestock Purchase",{"$f":"VLOOKUP(E32,'Livestock Expenses'!$C$4:$E$34,3,)","v":{"$error":"#N/A"}},0]
[null,null,null,null,"Rent or Lease Payments",{"$f":"VLOOKUP(E33,'Livestock Expenses'!$C$4:$E$34,3,)","v":{"$error":"#N/A"}},0]
[null,null,null,null,"Repairs / Maintenance",{"$f":"VLOOKUP(E34,'Livestock Expenses'!$C$4:$E$34,3,)","v":{"$error":"#N/A"}},0]
[null,null,null,null,"Storage",{"$f":"VLOOKUP(E35,'Livestock Expenses'!$C$4:$E$34,3,)","v":{"$error":"#N/A"}},0]
[null,null,null,null,"Supplies",{"$f":"VLOOKUP(E36,'Livestock Expenses'!$C$4:$E$34,3,)","v":{"$error":"#N/A"}},0]
[null,null,null,null,"Taxes (Farm)",{"$f":"VLOOKUP(E37,'Livestock Expenses'!$C$4:$E$34,3,)","v":{"$error":"#N/A"}},0]
[null,null,null,null,"Utilities",{"$f":"VLOOKUP(E38,'Livestock Expenses'!$C$4:$E$34,3,)","v":{"$error":"#N/A"}},0]
[null,null,null,null,"Vehicle(s)",{"$f":"VLOOKUP(E39,'Livestock Expenses'!$C$4:$E$34,3,)","v":{"$error":"#N/A"}},0]
[null,null,null,null,"Vet / Medical",{"$f":"VLOOKUP(E40,'Livestock Expenses'!$C$4:$E$34,3,)","v":{"$error":"#N/A"}},0,{"$f":"SUM($G$40+$G$22)","v":0}]
[null,null,null,null,"Other Expenses",{"$f":"VLOOKUP(E41,'Livestock Expenses'!$C$4:$E$34,3,)","v":{"$error":"#N/A"}},0]