{"text_format":"2","workbook":"xls","n_sheets":10,"sheets":["Enable Content","Enterprise Budgets","Income & capital items","Expense and summary","Crop Production Plan","Setup for monthly","Monthly Cashflow","Monitoring Worksheet","Accrual Adjustment","Trends"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":36,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Enable Content","index":0,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"First click \"Enable Content\" or \"Enable Macros\" above"]
[]
[null,"The buttons within the spreadsheets run macros which allow you to print pages. The yellow highlighted cells can be edited. The 'cut' and 'drag/drop' functions have been disabled to ensure that the formulas calculate correctly."]

{"sheet":"Enterprise Budgets","index":1,"n_rows":41,"n_cols":67,"rows_kept":41,"cut":false,"hidden":true,"merged":[[3,11,3,12],[3,13,3,14],[3,15,3,16],[3,17,3,18],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,19,3,20],[3,21,3,22],[3,23,3,24],[3,25,3,26],[4,19,4,20],[4,21,4,22],[4,23,4,24],[4,25,4,26],[13,43,13,45],[14,43,14,45],[15,43,15,45],[16,43,16,45],[6,43,6,45],[4,43,4,45],[5,43,5,45],[21,43,21,45],[22,43,22,45],[23,43,23,45],[24,43,24,45],[17,43,17,45],[18,43,18,45],[19,43,19,45],[20,43,20,45],[37,43,37,45],[38,43,38,45],[29,43,29,45],[30,43,30,45],[31,43,31,45],[32,43,32,45],[34,43,34,45],[35,43,35,45],[15,47,15,49],[16,47,16,49],[17,47,17,49],[18,47,18,49],[33,43,33,45],[36,43,36,45],[25,43,25,45],[26,43,26,45],[27,43,27,45],[28,43,28,45],[19,47,19,49],[20,47,20,49],[21,47,21,49],[22,47,22,49],[39,43,39,45],[4,47,4,49],[5,47,5,49],[6,47,6,49],[13,47,13,49],[14,47,14,49],[29,47,29,49],[30,47,30,49],[34,47,34,49],[35,47,35,49],[23,47,23,49],[24,47,24,49],[25,47,25,49],[26,47,26,49],[39,47,39,49],[4,51,4,53],[5,51,5,53],[6,51,6,53],[13,51,13,53],[14,51,14,53],[15,51,15,53],[16,51,16,53],[31,47,31,49],[32,47,32,49],[17,51,17,53],[18,51,18,53],[19,51,19,53],[20,51,20,53],[37,47,37,49],[38,47,38,49],[33,47,33,49],[36,47,36,49],[27,47,27,49],[28,47,28,49],[34,51,34,53],[35,51,35,53],[21,51,21,53],[22,51,22,53],[23,51,23,53],[24,51,24,53],[17,55,17,57],[18,55,18,57],[33,51,33,53],[36,51,36,53],[25,51,25,53],[26,51,26,53],[27,51,27,53],[28,51,28,53],[29,51,29,53],[30,51,30,53],[5,55,5,57],[6,55,6,57],[13,55,13,57],[14,55,14,57],[15,55,15,57],[16,55,16,57],[34,55,34,57],[19,55,19,57],[20,55,20,57],[21,55,21,57],[22,55,22,57],[39,51,39,53],[37,51,37,53],[38,51,38,53],[31,51,31,53],[32,51,32,53],[28,55,28,57],[29,55,29,57],[30,55,30,57],[23,55,23,57],[24,55,24,57],[25,55,25,57],[26,55,26,57],[39,55,39,57],[3,43,3,46],[3,47,3,50],[3,51,3,54],[3,55,3,58],[31,55,31,57],[32,55,32,57],[33,55,33,57],[36,55,36,57],[27,55,27,57],[4,11,4,12],[4,13,4,14],[4,15,4,16],[4,17,4,18],[4,3,4,4],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,27,4,28],[3,27,3,28],[3,29,3,30],[4,29,4,30],[3,31,3,32],[4,31,4,32],[3,33,3,34],[4,33,4,34],[3,35,3,36],[4,35,4,36],[3,37,3,38],[4,37,4,38],[3,59,3,62],[3,63,3,66],[4,59,4,61],[4,63,4,65],[3,39,3,40],[4,39,4,40],[3,41,3,42],[4,41,4,42],[4,55,4,57],[5,59,5,61],[5,63,5,65],[6,59,6,61],[6,63,6,65],[13,59,13,61],[13,63,13,65],[14,59,14,61],[14,63,14,65],[15,59,15,61],[15,63,15,65],[16,59,16,61],[16,63,16,65],[17,59,17,61],[17,63,17,65],[18,59,18,61],[18,63,18,65],[19,59,19,61],[19,63,19,65],[20,59,20,61],[20,63,20,65],[21,59,21,61],[21,63,21,65],[22,59,22,61],[22,63,22,65],[23,59,23,61],[23,63,23,65],[24,59,24,61],[24,63,24,65],[25,59,25,61],[25,63,25,65],[26,59,26,61],[26,63,26,65],[27,59,27,61],[27,63,27,65],[28,59,28,61],[28,63,28,65],[29,59,29,61],[29,63,29,65],[30,59,30,61],[30,63,30,65],[31,59,31,61],[31,63,31,65],[39,59,39,61],[39,63,39,65],[32,59,32,61],[32,63,32,65],[33,59,33,61],[33,63,33,65],[36,59,36,61],[36,63,36,65],[34,59,34,61],[34,63,34,65],[35,55,35,57],[35,59,35,61],[35,63,35,65],[37,59,37,61],[37,63,37,65],[38,59,38,61],[38,63,38,65],[37,55,37,57],[38,55,38,57]],"flags":["formulas_cached_only"]}
[]
["Name:"," "]
["For 12 months ending: "]
["Enterprise Budgets",null,null,"Crop #1",null,"Crop #2",null,"Crop #3",null,"Crop #4",null,"Crop #5",null,"Crop #6",null,"Crop #7",null,"Crop #8",null,"Crop #9",null,"Crop #10",null,"Crop #11",null,"Crop #12",null,"Crop #13",null,"Crop #14",null,"Crop #15",null,"Crop #16",null,"Crop #17",null,"Crop #18",null,"Crop #19",null,"Crop #20",null,"Livestock #1",null,null,null,"Livestock #2",null,null,null,"Livestock #3",null,null,null,"Livestock #4",null,null,null,"Livestock #5",null,null,null,"Livestock #6"]
["Enterprise",{"$nulls":18}," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",{"$nulls":4},"Prod/hd",null,null,null,"Prod/hd",null,null,null,"Prod/hd"," ",null,null,"Prod/hd"," ",null,null,"Prod/hd"," ",null,null,"Prod/hd"]
["Unit of production"]
["Revenue (check against sales)","Total Revenue","Additional Revenue","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Head",null,null,"No. of head","Per Head",null,null,"No. of head","Per Head",null,null,"No. of head","Per Head",null,null,"No. of head","Per Head",null,null,"No. of head","Per Head",null,null,"No. of head"]
["Acres/head",{"$nulls":42},"Out wt.","Sale price","Total",null,"Out wt.","Sale price","Total",null,"Out wt.","Sale price","Total",null,"Out wt.","Sale price","Total",null,"Out wt.","Sale price","Total",null,"Out wt.","Sale price","Total"]
["Yield/Production",null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["Share",null,null,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,null,1,"In wt.","In price",null,null,"In wt.","In price",null,null,"In wt.","In price",null,null,"In wt.","In price",null,null,"In wt.","In price",null,null,"In wt.","In price"]
["Price",{"$nulls":44},0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["Additional revenue (gov't payments, etc.)",null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Total revenue",0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Net revenue/hd",null,{"$error":"#DIV/0!"},0,"Net revenue/hd",null,{"$error":"#DIV/0!"},0,"Net revenue/hd",null,{"$error":"#DIV/0!"},0,"Net revenue/hd",null,{"$error":"#DIV/0!"},0,"Net revenue/hd",null,{"$error":"#DIV/0!"},0,"Net revenue/hd",null,{"$error":"#DIV/0!"},0]
["Cash operating expenses","Total Expenses","Additional Expense","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Acre","Total","Per Head",null,null,"Total","Per Head",null,null,"Total","Per Head",null,null,"Total","Per Head",null,null,"Total","Per Head",null,null,"Total","Per Head",null,null,"Total"]
["Car and truck expenses",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Chemicals and Spray",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Custom Machine Hire",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Feed, hay and grain purchased",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Fertilizer and Lime",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Freight and Trucking",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Gas, Oil, Fuel",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Irrigation fuel",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Insurance",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Labor hired, benefits, etc.",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Rent, land and other",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Rent, vehicles and equipment",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Repairs and maintenance",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Seed",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Storage and warehousing",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Supplies",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Taxes - Real Estate & Personal Property",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Utilities",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Veterinary",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Legal, Professional & Consulting",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Crop  consulting & Marketing",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Misc",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Interest (Operating Loan)",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
["Total cash operating expenses",0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0]
["Return over direct costs",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"},null,null,0,{"$error":"#DIV/0!"},null,null,0]
["Version 12.2020"]

{"sheet":"Income & capital items","index":2,"n_rows":56,"n_cols":34,"rows_kept":56,"cut":false,"hidden":true,"merged":[[1,9,1,12],[3,21,3,32],[4,21,4,32],[52,0,52,2],[53,0,53,2],[54,0,54,2],[14,0,14,2],[15,0,15,2],[16,0,16,2],[17,0,17,2],[35,0,35,2],[36,0,36,2],[37,0,37,2],[47,0,47,2],[48,0,48,2],[49,0,49,2],[27,0,27,2],[28,0,28,2],[29,0,29,2],[30,0,30,2],[33,0,33,2],[34,0,34,2],[25,0,25,2],[26,0,26,2],[4,9,4,16],[20,0,20,2],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,24,2]],"flags":["formulas_cached_only"]}
["Town & Country Bank"]
["Agricultural Income and Expense Statement",{"$nulls":8},"Name:   "]
["Name:   ",{"$nulls":8},"For 12 months ending: ",null,"00:00:00"]
["For 12 months ending:","00:00:00",{"$nulls":7},"Note:  Information shown below must be manually transferred to the sales and income schedules.",{"$nulls":11},"Allocate to monthly cashflow stream - no entry = monthly"]
["Income Information",{"$nulls":8},"Summary of Enterprise Production and Revenue",{"$nulls":8},"Optional allocation for monthly cashflow:",null,null,"Month"]
["Schedule A.  Market livestock sales",{"$nulls":8},"Crop Enterprise",null,"Acres","Production","Yield","Price","Add. Revenue","Revenue",null,null,null,"Total","Jan-2022","Feb-2022","Mar-2022","Apr-2022","May-2022","Jun-2022","Jul-2022","Aug-2022","Sep-2022","Oct-2022","Nov-2022","Dec-2022","Total"]
["Description","No. Head","Weight","Price/lb","Price/hd","Total Income","Month",null,null,1,0,0,0,0,0,0,0,null,"Market Livestock Sales",null,0,{"$nulls":12},0]
[{"$nulls":4},0,0,null,null,null,2,0,0,0,0,0,0,0,null,"Cull Breeding Livestock Sales",null,0,{"$nulls":12},0]
[{"$nulls":4},0,0,null,null,null,3,0,0,0,0,0,0,0,null,"Crop, Hay and Feed sales",null,0,{"$nulls":12},0]
[{"$nulls":4},0,0,null,null,null,4,0,0,0,0,0,0,0,null,"Other Income",null,0,{"$nulls":12},0]
[{"$nulls":4},0,0,null,null,null,5,0,0,0,0,0,0,0,null,"Livestock purchased for resale",null,0,{"$nulls":12},0]
[{"$nulls":4},0,0,null,null,null,6,0,0,0,0,0,0,0,null,"Breeding Livestock Purchases",null,0,{"$nulls":12},0]
[{"$nulls":4},"Total",0,null,null,null,7,0,0,0,0,0,0,0,null,"Capital Purchases",null,0,{"$nulls":12},0]
["Schedule B.  Cull breeding livestock sales",{"$nulls":8},8,0,0,0,0,0,0,0]
["Description",null,null,"No. Head","Price/hd","Total Income","Month",null,null,9," ",0,0,0,0,0,0]
[{"$nulls":5},0,null,null,null,10," ",0,0,0,0,0,0]
[{"$nulls":5},0,null,null,null,11," ",0,0,0,0,0,0]
[{"$nulls":5},0,null,null,null,12," ",0,0,0,0,0,0]
[{"$nulls":4},"Total",0,null,null,null,13," ",0,0,0,0,0,0]
["Schedule C.  Crop, hay and feed sales",{"$nulls":8},14," ",0,0,0,0,0,0]
["Description",null,null,"Tot. Quantity","Price/unit","Total Income","Month",null,null,15," ",0,0,0,0,0,0]
[{"$nulls":5},0,null,null,null,16," ",0,0,0,0,0,0]
[{"$nulls":5},0,null,null,null,17," ",0,0,0,0,0,0]
[{"$nulls":5},0,null,null,null,18," ",0,0,0,0,0,0]
[{"$nulls":5},0,null,null,null,19," ",0,0,0,0,0,0]
[{"$nulls":5},0,null,null,null,20," ",0,0,0,0,0,0]
[{"$nulls":5},0,{"$nulls":4},"Total",0,0,null,null,null,0]
[{"$nulls":5},0,null,null,null,"Livestock Enterprise",null,"No. of head","Head to sell","Units","Price","Add. Revenue","Net Revenue"]
[{"$nulls":5},0,null,null,null,1,0,0,0,0,0,0,0]
[{"$nulls":5},0,null,null,null,2,0,0,0,0,0,0,0]
[{"$nulls":5},0,null,null,null,3,0,0,0,0,0,0,0]
[{"$nulls":4},"Total",0,null,null,null,4," ",0,0,0,0,0,0]
["Schedule D.  Other income",{"$nulls":8},5," ",0,0,0,0,0,0]
["Description",null,null,"Quantity","Price/unit","Total Income","Month",null,null,6," ",0,0,0,0,0,0]
[{"$nulls":5},0,"00:00:00",null,null,null,"Total",null,0,null,null,null,0]
[{"$nulls":5},0,{"$nulls":4},"Crop production budgeted",0,null,"Livestock head budgeted",null,0]
[{"$nulls":5},0,{"$nulls":4},"Sch. C Crop quantity sold",0,null,"Sch. A Mkt Lvstk head sold",null,0]
[{"$nulls":5},0,{"$nulls":4},"Difference",0,null,"Difference",null,0]
[{"$nulls":4},"Total",0]
["Feeder livestock, breeding livestock and capital item purchases"]
["Schedule E.  Livestock purchases for resale"]
["Description","No. Head","Weight","Price/lb","Price/hd","Total cost","Month"]
[{"$nulls":4},0,0]
[{"$nulls":4},0,0]
[{"$nulls":4},0,0]
[{"$nulls":4},"Total",0]
["Schedule F.  Breeding livestock purchases"]
["Description of breeding livestock purchases",null,null,"Quantity","Cost/unit","Total cost","Month"]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":4},"Total",0]
["Schedule G.  Capital purchases"]
["Description of capital purchases",null,null,"Quantity","Cost/unit","Total cost","Month"]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":4},"Total",0]

{"sheet":"Expense and summary","index":3,"n_rows":56,"n_cols":31,"rows_kept":56,"cut":false,"hidden":true,"merged":[[2,18,2,29],[3,18,3,29],[25,0,25,5],[0,0,0,5],[1,0,1,5],[4,0,4,5]],"flags":["formulas_cached_only"]}
["Town & Country Bank"]
["Agricultural Income and Expense Statement"]
["Name:   ",{"$nulls":7},"Name:   ",{"$nulls":9},"Allocate to monthly cashflow stream - no entry = monthly"]
["For 12 months ending: ",null,"00:00:00",{"$nulls":5},"Fpr 12 months ending:","00:00:00",{"$nulls":6},"Optional allocation for monthly cashflow",null,"Month"]
["Cash Flow Summary",{"$nulls":7},"Term Loan Payments (optional schedule)",{"$nulls":8},"Total","Jan-2022","Feb-2022","Mar-2022","Apr-2022","May-2022","Jun-2022","Jul-2022","Aug-2022","Sep-2022","Oct-2022","Nov-2022","Dec-2022","total"]
["Cash operating income",{"$nulls":8},"Principal",null,"Annual","Interest","Principal",null,null,"Personal wage, interest & other income",0,{"$nulls":12},0]
["Market livestock sales (Schedule A)",{"$nulls":4},0,null,null,"Loan","Balance","Rate","payment","portion","portion","Month",null,"Car and truck expenses",0,{"$nulls":12},0]
["Cull breeding livestock sales (Schedule B)",{"$nulls":4},0,{"$nulls":6},0,0,null,null,"Chemicals and Spray",0,{"$nulls":12},0]
["Crop, hay and feed sales (Schedule C)",{"$nulls":4},0,{"$nulls":6},0,0,null,null,"Custom Machine Hire",0,{"$nulls":12},0]
["Other Income (Schedule D)",{"$nulls":4},0,{"$nulls":6},0,0,null,null,"Feed, hay and grain purchased",0,{"$nulls":12},0]
["Personal wage, interest, dividend and other personal income",{"$nulls":4},0,{"$nulls":6},0,0,null,null,"Fertilizer and Lime",0,{"$nulls":12},0]
["Total Cash Income",{"$nulls":4},0,{"$nulls":6},0,0,null,null,"Freight and Trucking",0,{"$nulls":12},0]
[{"$nulls":12},0,0,null,null,"Gas, Oil, Fuel",0,{"$nulls":12},0]
["Cash expenditures",{"$nulls":11},0,0,null,null,"Irrigation fuel",0,{"$nulls":12},0]
["Purchases of feeder livestock (Schedule E)",{"$nulls":4},0,{"$nulls":6},0,0,null,null,"Insurance",0,{"$nulls":12},0]
["Total cash operating expenses",{"$nulls":4},0,{"$nulls":6},0,0,null,null,"Labor hired, benefits, etc.",0,{"$nulls":12},0]
["Total interest expense",{"$nulls":4},0,{"$nulls":6},0,0,null,null,"Rent, land and other",0,{"$nulls":12},0]
["Principal payments on term loans",{"$nulls":4},0,{"$nulls":6},0,0,null,null,"Rent, vehicles and equipment",0,{"$nulls":12},0]
["Breeding livestock purchases (Schedule F)",{"$nulls":4},0,{"$nulls":6},0,0,null,null,"Repairs and maintenance",0,{"$nulls":12},0]
["Capital purchases (Schedule G)",{"$nulls":4},0,{"$nulls":6},0,0,null,null,"Seed",0,{"$nulls":12},0]
["Family living expenses and other withdrawals",{"$nulls":4},0,{"$nulls":6},0,0,null,null,"Storage and warehousing",0,{"$nulls":12},0]
["Income and self-employment taxes",{"$nulls":4},0,{"$nulls":6},0,0,null,null,"Supplies",0,{"$nulls":12},0]
["Total Cash Expenditures",{"$nulls":4},0,{"$nulls":6},0,0,null,null,"Taxes - Real Estate & Personal Property",0,{"$nulls":12},0]
[{"$nulls":12},0,0,null,null,"Utilities",0,{"$nulls":12},0]
["Net Cash Flow",{"$nulls":4},0,{"$nulls":6},0,0,null,null,"Veterinary",0,{"$nulls":12},0]
["Expenses and Other Information",{"$nulls":11},0,0,null,null,"Legal, Professional & Consulting",0,{"$nulls":12},0]
["Interest expense",null,null,"Cash operating expenses",{"$nulls":8},0,0,null,null,"Crop  consulting & Marketing",0,{"$nulls":12},0]
["Interest (Operating Loan)",null,0,"Car and truck expenses",null,0,{"$nulls":6},0,0,null,null,0,0,{"$nulls":12},0]
["Interest (Mortgage and Other)",null,0,"Chemicals and Spray",null,0,{"$nulls":6},0,0,null,null,"Misc",0,{"$nulls":12},0]
["Total interest expense",null,0,"Custom Machine Hire",null,0,{"$nulls":6},0,0,null,null,"Family living and other withdrawals",0,{"$nulls":12},0]
["Principal portion of term loan payments",null,null,"Feed, hay and grain purchased",null,0,{"$nulls":6},0,0,null,null,"Income and self-employment taxes",0,{"$nulls":12},0]
[null," ",0,"Fertilizer and Lime",null,0,{"$nulls":6},0,0,null,null,"Interest (Operating Loan)","to be calculated"]
[null,null,null,"Freight and Trucking",null,0,{"$nulls":6},0,0,null,null,"Interest (Mortgage and Other)",0,{"$nulls":12},0]
[null,null,null,"Gas, Oil, Fuel",null,0,{"$nulls":6},0,0,null,null,"Principal portion of term loan payments",0,{"$nulls":12},0]
[null,null,null,"Irrigation fuel",null,0,null,null,"Totals",null,null,0,0,0]
[null,null,null,"Insurance",null,0]
[null,null,null,"Labor hired, benefits, etc.",null,0]
["from optional schedule:",null,0,"Rent, land and other",null,0]
["Total principal payments on term loans",null,0,"Rent, vehicles and equipment",null,0]
["Other Information (enter here and below)",null,null,"Repairs and maintenance",null,0]
["Personal wage, interest & other income",null,null,"Seed",null,0]
["Depreciation",null,null,"Storage and warehousing",null,0]
["Family living and other withdrawals",null,null,"Supplies",null,0]
["Income and self-employment taxes",null,null,"Taxes - Real Estate & Personal Property",null,0]
[null,null,null,"Utilities",null,0]
[null,null,null,"Veterinary",null,0]
[null,null,null,"Legal, Professional & Consulting",null,0]
[null,null,null,"Crop  consulting & Marketing",null,0]
[null,null,null,0,null,0]
[null,null,null,"Misc",null,0]
[null,null,null,"Total cash operating expenses",null,0]
["     I/we certify this information and that on on all supporting documents provided to Town & Country Bank"]
["is true, correct and complete to the best of my/our knowledge and understand all lending decisions will be based"]
["on Town & Country Bank's independent analysis of the information.",{"$nulls":4},"V 2022.1"]
["__________________________________",null,"_____________",null,"_____________________________________","_____________"]
["Signature",null,"Date",null,"Signature","Date"]

{"sheet":"Crop Production Plan","index":4,"n_rows":41,"n_cols":18,"rows_kept":41,"cut":false,"hidden":true,"merged":[[40,2,40,3]],"flags":["formulas_cached_only"]}
["Crop plan by field - Option B for presenting production",{"$nulls":15},"Prices"]
[{"$nulls":16},"Corn",3.75]
["Name:   ",{"$nulls":15},"Soybeans",8.75]
[{"$nulls":16},"Other",80]
["For 12 months ending:","00:00:00"]
[null,null,"Acres","Acres","Yld corn","Yield beans","Acres","Yield","Bushels","Bushels ","Production",null,"bushels","bushels","Production","Corn","Soybean ","Other"]
["Field","Crop","Corn","Soybeans","(APH)","(APH)","Other","Other","corn","Beans","Other","Share","corn to sell","beans to sell","Other to sell","Income","Income","Income"]
[{"$nulls":8},0,0,0,0.3,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,0.5,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
[{"$nulls":8},0,0,0,1,0,0,0,0,0,0]
["Totals",null,0,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Total Acres",0,{"$nulls":8},"Borrower's overall share of total production",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Total crop income",0]

{"sheet":"Setup for monthly","index":5,"n_rows":42,"n_cols":12,"rows_kept":42,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
["Date completed:","2021-11-01"]
["Completed for:",{"$nulls":8},1,"Jan",0]
["Name:"," ",{"$nulls":7},2,"Feb",0]
[{"$nulls":9},3,"Mar",0]
["Plan description:",{"$nulls":8},4,"Apr",0]
["Prepared by:",{"$nulls":8},5,"May",0]
[{"$nulls":9},6,"Jun",1]
["Planning Period:",{"$nulls":8},7,"Jul",0]
["Starting month (1-12):",1,"from:","Jan-2022",{"$nulls":5},8,"Aug",0]
["Year of starting month:",2022,"to:","Dec-2022",{"$nulls":5},9,"Sep",0]
[{"$nulls":9},10,"Oct",0]
["Cash and asset information",{"$nulls":8},11,"Nov",0]
[{"$nulls":9},12,"Dec",1]
[]
["Beginning cash balance:",0]
["Minimum desired cash each month:",0]
[]
["Operating loan information:"]
["Annual interest rate",5.75,"percent"]
["Beginning principal balance",0]
["Beginning accrued interest balance",0]
["Interest payment frequency",6,"months"]
["Interest first paid in planning month #",6,"(Jun)"]
["Cash Flow Actuals through planning month #",1,"(Jan)"]
[]
["Itemization of beginning operating loan balance:"]
["Item","Amount"]
{"$rows_empty":12}
["Total",0]
[]
["V. Copyright 2018 Town & Country Bank / James Friesen"]

{"sheet":"Monthly Cashflow","index":6,"n_rows":64,"n_cols":16,"rows_kept":64,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
[]
["Name:   ",{"$nulls":6},"Town & Country Bank -- Monthly Cash Flow Plan"]
["Plan description:  __________________________________________________",null,null,null,"Date prepared: ","2021-11-01",{"$nulls":9},"File:  S:\\FINSTMT\\Blank forms\\Customer friendly forms\\[Blank annual cashflow with 26 enterprises monthly cashflow with trends.xls]Monthly Cashflow"]
[null,null,"Last Year","Jan-2022","Feb-2022","Mar-2022","Apr-2022","May-2022","Jun-2022","Jul-2022","Aug-2022","Sep-2022","Oct-2022","Nov-2022","Dec-2022","Totals"]
[null,"Beginning Cash",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Market Livestock Sales",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[2,"Crop, Hay and Feed sales",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[3,"Other Income",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[4,"Carryover Sales from prior year",{"$nulls":13},0]
[5,"Total Cash Farm Oper. Rev.",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6,"Breeding livestock sales",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[7,"Sale of Other Capital Items",{"$nulls":13},0]
[8,"Personal income",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[9,"Borrowed (Other than Optg. Loan)",{"$nulls":13},0]
[10,"Total Cash Available",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[11,"Car and truck expenses",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[12,"Chemicals and Spray",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[13,"Custom Machine Hire",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[14,"Feed, hay and grain purchased",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[15,"Fertilizer and Lime",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[16,"Freight and Trucking",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[17,"Gas, Oil, Fuel",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[18,"Irrigation fuel",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[19,"Insurance",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[20,"Labor hired, benefits, etc.",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[21,"Rent, land and other",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[22,"Rent, vehicles and equipment",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[23,"Repairs and maintenance",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[24,"Seed",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[25,"Storage and warehousing",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[26,"Supplies",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[27,"Taxes - Real Estate & Personal Property",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[28,"Utilities",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[29,"Veterinary",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[30,"Legal, Professional & Consulting",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[31,"Crop  consulting & Marketing",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[32,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[33,"Misc",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[34,"Beginning Accounts to be Paid",{"$nulls":13},0]
[35,"Total Cash Farm Oper. Exp.",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[36,"Livestock purchased for resale",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[37,"Family living and other withdrawals",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[38,"Income and self-employment taxes",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[39,"Breeding Livestock Purchases",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[40,"Capital Purchases",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[41,"Interest (Operating Loan)",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[42,"Interest (Mortgage and Other)",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[43,"Principal portion of term loan payments",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[44,"Total Expenditures",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[45,"Periodic Net Cash Flow",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[46,"Cumulative Net Cash Flow (Deficit)",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[47,"Payments - Operating Loan",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[48,"Advances - Operating Loan",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[49,"Operating Loan Balance",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[50,"Accrued Optg. Interest     Rate:  5.75%",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[51,"Ending Cash",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Alimony, child support or separate maintenance income need not be revealed if you do not wish to have it considered as a basis for repaying your obligation.  Approval of loans based on this information is not an authorization to sell or otherwise "]
["dispose of collateral.  Any and all collateral given as security secures all outstanding indebtedness, notwithstanding the information given herein, unless a specific agreement exists to the contrary."]
["Signatures ________________________________________",null,null,"Date ____________________",null,null,null,"Signatures ________________________________________",{"$nulls":5},"Date ____________________"]
[]
[]
[]
["Year to Date Flag fields:",null,null,1,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Monitoring Worksheet","index":7,"n_rows":61,"n_cols":30,"rows_kept":61,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
["Town & Country Bank",null,"Cashflow Monitoring Worksheet"]
["Name:   ",{"$nulls":26},"File:  S:\\FINSTMT\\Blank forms\\Customer friendly forms\\[Blank annual cashflow with 26 enterprises monthly cashflow with trends.xls]Monitoring Worksheet"]
["Plan description:  __________________________________________________",{"$nulls":15},"Page 1",{"$nulls":10},"page 2","YTD through ","Jan"]
[null,null,"Last Year","Jan-2022","Actual","Feb-2022","Actual","Mar-2022","Actual","Apr-2022","Actual","May-2022","Actual","Jun-2022","Actual","Jul-2022","Actual","Aug-2022","Actual","Sep-2022","Actual","Oct-2022","Actual","Nov-2022","Actual","Dec-2022","Actual","Totals","Projected YTD","Actual YTD"]
[null,"Beginning Cash",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Market Livestock Sales",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[2,"Crop, Hay and Feed sales",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[3,"Other Income",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[4,"Carryover Sales from prior year",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[5,"Total Cash Farm Oper. Rev.",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[6,"Breeding livestock sales",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[7,"Sale of Other Capital Items",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[8,"Personal income",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[9,"Borrowed (Other than Optg. Loan)",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[10,"Total Cash Available",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[11,"Car and truck expenses",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[12,"Chemicals and Spray",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[13,"Custom Machine Hire",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[14,"Feed, hay and grain purchased",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[15,"Fertilizer and Lime",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[16,"Freight and Trucking",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[17,"Gas, Oil, Fuel",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[18,"Irrigation fuel",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[19,"Insurance",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[20,"Labor hired, benefits, etc.",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[21,"Rent, land and other",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[22,"Rent, vehicles and equipment",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[23,"Repairs and maintenance",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[24,"Seed",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[25,"Storage and warehousing",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[26,"Supplies",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[27,"Taxes - Real Estate & Personal Property",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[28,"Utilities",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[29,"Veterinary",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[30,"Legal, Professional & Consulting",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[31,"Crop  consulting & Marketing",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[32,0,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[33,"Misc",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[34,"Beginning Accounts to be Paid",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[35,"Total Cash Farm Oper. Exp.",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[36,"Livestock purchased for resale",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[37,"Family living and other withdrawals",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[38,"Income and self-employment taxes",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[39,"Breeding Livestock Purchases",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[40,"Capital Purchases",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[41,"Interest (Operating Loan)",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[42,"Interest (Mortgage and Other)",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[43,"Principal portion of term loan payments",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[44,"Total Expenditures",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[45,"Periodic Net Cash Flow",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[46,"Cumulative Net Cash Flow (Deficit)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[47,"Payments - Operating Loan",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[48,"Advances - Operating Loan",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0]
[49,"Operating Loan Balance",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[50,"Accrued Optg. Interest     Rate:  5.75%",0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[51,"Ending Cash",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
["Year to Date Flag fields:",null,null,1,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]

{"sheet":"Accrual Adjustment","index":8,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":true,"merged":[[50,0,50,7]],"flags":["formulas_cached_only"]}
["Note:  This worksheet starts with annual income and expense totals - not the monthly cashflow totals."]
["Agricultural Income and Expense Statement"]
["Accrual Adjustment Worksheet"]
["Name:  "]
["For 12 months ending: ",{"$nulls":6},"00:00:00"]
["Business Income"]
[null,"Livestock sales (Schedule A)",{"$nulls":5},0]
[null,"Crop sales (Schedule C)",{"$nulls":5},0]
[null,"Other Income (Schedule D)",{"$nulls":5},0]
[null,"Breeding livestock sales (Schedule B)",null,null,null,0]
[null,null,"less cost basis of cull animals sold/died ",null,"-"]
[null,null,"plus base value of raised breeding animals retained ",null,"+",null,"=",0]
[null,"Cash income adjustments:",null,"Ending",null,"Less Beginning"]
[null,null,null,"Inventory",null,"Inventory"]
[null,null,"Receivables","$","-","$","=",0]
[null,null,"Grain, hay and feed inventory",{"$nulls":4},0]
[null,null,"Market livestock inventory",{"$nulls":4},0]
["1.","Gross Revenues",{"$nulls":5},0]
[null,null,"less feeder livestock purchases (Schedule E)",null,null,null,"-",0]
["2.","Value of Production",{"$nulls":5},0]
["Business Expenses (bold numbers represent percentage of value of production)"]
[null,"Cash operating expenses",{"$nulls":5},0]
[null,"Operating expense adjustments:",null,"Beginning",null,"Less Ending"]
[null,null,null,"Inventory",null,"Inventory"]
[null,null,"Prepaid expenses and supplies","$","-","$","=",0]
[null,null,"Cash investment in growing crops",{"$nulls":4},0]
[null,null,null,"Ending",null,"Less Beginning"]
[null,null,null,"Inventory",null,"Inventory"]
[null,null,"Accounts payable","$","-","$","=",0]
[null,null,"Accrued expenses (except interest)",{"$nulls":4},0]
["a.","Total operating expenses",null,"NA",null,null,null,0]
["b.","Depreciation",null,"NA",null,null,null,0]
[null,"Cash interest payments",null,null,null,0]
[null,null,"plus ending accrued interest",null,"+"]
["c.",null,"less beginning accrued interest","NA","-",null,"=",0]
["3.","Total Expenses",{"$nulls":5},0]
["Net Income and Net Worth Change Summary"]
["4.","Net Income from Operations",null,"NA",null,null,null,0]
[null,"Capital sales except breeding livestock",null,null,null,"$"]
[null,null,"less cost basis of items sold",null,"-",null,"=",0]
["5.","Net Business Income",{"$nulls":5},0]
[null,null,"Personal income ",null,null,null,"+",0]
[null,null,"Income and social security (self employment) taxes ",null,null,null,"-",0]
["6.","Net Income After Taxes",{"$nulls":5},0]
[null,null,"Less family living and other withdrawals ",null,null,null,"-",0]
["7.","Earned Net Worth Change",null,"NA",null,null,null,0]
["Accrual Financial Performance Ratios"]
["Total Assets",null,"$","Return on Assets",null,null,null,{"$error":"#VALUE!"}]
["Total Liabilities",null,null,"Return on Equity",null,null,null,"NA"]
["Net Worth",null,0,"Accrual term debt coverage ratio",null,null,null,"NA"]
["Sensitivity Analysis"]
[{"$nulls":7},"With rev. decrease"]
[null,null,"As","With rev.",null,"With exp.",null,0.05]
[null,null,"Completed","decrease",null,"increase",null,"and exp. Increase"]
[null,null,null,0.05,null,0.05,null,0.05]
[]
["Net Cash Flow",null,0,0,null,0,null,0]
["NW Change",null,0,0,null,0,null,0]

{"sheet":"Trends","index":9,"n_rows":112,"n_cols":7,"rows_kept":112,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
["Town & Country Bank"]
["Agricultural Income Trends Report"]
["Name:   "]
[null,"a","b","c","d","Average of"]
["Fiscal Year:",{"$nulls":4},"a-d","Projection"]
["Farm/Ranch Income",{"$nulls":4},0]
["   Sales of purchased production",{"$nulls":4},0]
["Market livestock sales (Schedule A)",{"$nulls":4},0,0]
["   Sales of raised livestock ",{"$nulls":4},0]
["   Sales of raised livestock ",{"$nulls":4},0]
["Crop, hay and feed sales (Schedule C)",{"$nulls":4},0,0]
["Other Income (Schedule D)",{"$nulls":4},0,0]
["Cull breeding livestock sales (Schedule B)",{"$nulls":4},0,0]
["      less adjusted basis",{"$nulls":4},0]
["   Other capital sales",{"$nulls":4},0]
["      less adjusted basis",{"$nulls":4},0]
["Personal wage, interest & other income",{"$nulls":4},0,0]
["Other taxable income",{"$nulls":4},0]
["Gain on Sale",{"$nulls":4},0]
["Farm program payments",{"$nulls":4},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
["Total Income",0,0,0,0,0,0]
[]
["Farm/Ranch Expenses",{"$nulls":4},0]
["Purchases of feeder livestock (Schedule E)",{"$nulls":4},0,0]
["Car and truck expenses",{"$nulls":4},0,0]
["Chemicals and Spray",{"$nulls":4},0,0]
["Custom Machine Hire",{"$nulls":4},0,0]
["Depreciation",{"$nulls":4},0,0]
["Feed, hay and grain purchased",{"$nulls":4},0,0]
["Fertilizer and Lime",{"$nulls":4},0,0]
["Freight and Trucking",{"$nulls":4},0,0]
["Gas, Oil, Fuel",{"$nulls":4},0,0]
["Irrigation fuel",{"$nulls":4},0,0]
["Insurance",{"$nulls":4},0,0]
["Interest (Operating Loan)",{"$nulls":4},0,0]
["Interest (Mortgage and Other)",{"$nulls":4},0,0]
["Labor hired, benefits, etc.",{"$nulls":4},0,0]
["Rent, land and other",{"$nulls":4},0,0]
["Rent, vehicles and equipment",{"$nulls":4},0,0]
["Repairs and maintenance",{"$nulls":4},0,0]
["Seed",{"$nulls":4},0,0]
["Storage and warehousing",{"$nulls":4},0,0]
["Supplies",{"$nulls":4},0,0]
["Taxes - Real Estate & Personal Property",{"$nulls":4},0,0]
["Utilities",{"$nulls":4},0,0]
["Veterinary",{"$nulls":4},0,0]
["Legal, Professional & Consulting",{"$nulls":4},0,0]
["Crop  consulting & Marketing",{"$nulls":4},0,0]
[0,{"$nulls":4},0,0]
["Misc",{"$nulls":4},0,0]
[{"$nulls":5},0]
[{"$nulls":5},0]
["Total expenses",0,0,0,0,0,0]
["Net cash income for the year",0,0,0,0,0,0]
["Adjustments to income (1/2 SE, IRA, etc)",{"$nulls":4},0]
["NOL Carryover",{"$nulls":4},0]
["Adjusted Gross Income",{"$nulls":4},0]
["   Check row - should match AGI off of tax return",0,0,0,0,0,0]
[]
[]
["Scheduled Tax Payments:"]
["Self Employment taxes",{"$nulls":4},0]
["Federal income taxes",{"$nulls":4},0]
["State income taxes",{"$nulls":4},0]
["Total income/self employment taxes",0,0,0,0,0,0]
[]
["Cash Flow Summary:"]
["Net Cash Income",0,0,0,0,0,0]
["Add back Depreciation",0,0,0,0,0,0]
["Add back Interest",0,0,0,0,0,0]
["Less Cash for Capital Purchases",{"$nulls":4},0,0]
["Less income and SE taxes",0,0,0,0,0,0]
["Less Family Living Withdrawals",{"$nulls":4},0,0]
["Net cash available for debt service",0,0,0,0,0,0]
[]
["Principal and interest payments:"]
["Operating loan interest",{"$nulls":4},0,0]
["Term P & I payments:",{"$nulls":4},0,0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
["Total debt payments",0,0,0,0,0,0]
["Net Cash Flow",0,0,0,0,0,0]
[]
["Debt coverage ratio (cash)",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Net Worth Change Summary:"]
["Net Cash Income",0,0,0,0,0,0]
["Plus positive income adjustments",{"$nulls":4},0]
["Less negative income adjustments",{"$nulls":4},0]
["Plus or minus other capital infusions/withdrawals",{"$nulls":4},0]
["Less income taxes paid",0,0,0,0,0,0]
["Less family living/other withdrawals",0,0,0,0,0,0]
["Net Worth Change",0,0,0,0,0,0]
["Net Worth Change + Depreciation + Interest",0,0,0,0,0,0]
[]
["Term Debt Coverage Ratio (accrual)",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Note:  Net Worth Change + Depreciation + Interest is available to pay term debt P&I payments, operating loan interest, "]
["    cash portion of capital purchases and breeding livestock herd expansion through retention."]
[]
[]
["     I/we certify this information and that on on all supporting documents provided to Town & Country Bank is true,"]
["correct and complete to the best of my/our knowledge and understand all lending decisions will be based on Town &"]
["Country Bank's independent analysis of the information."]
[]
[]
["______________________________________","___/___/___","___________________________________",null,null,"___/___/___"]
["Signature","Date","Signature",null,null,"Date"]