{"text_format":"2","workbook":"xls","n_sheets":5,"sheets":["Setup","crop plan","Cashflow","Income Statement","Monitoring Worksheet"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":28,"comments":1,"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":"Setup","index":0,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Date completed:","2021-11-01"]
["Completed for:",{"$nulls":8},1,"Jan",0]
["Name:",{"$nulls":8},2,"Feb",0]
["Address:",{"$nulls":8},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]
["Total Assets",{"$nulls":8},12,"Dec",1]
["Total Liabilities"]
["Beginning cash balance:",1000]
["Minimum desired cash each month:"]
[]
["Operating loan information:"]
["Annual interest rate",5.75,"percent"]
["Beginning principal balance"]
["Beginning accrued interest balance"]
["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]

{"sheet":"crop plan","index":1,"n_rows":61,"n_cols":18,"rows_kept":61,"cut":false,"hidden":false,"merged":[[51,6,51,7],[52,6,52,7],[53,6,53,7],[54,6,54,7],[55,6,55,7],[56,6,56,7],[57,6,57,7],[58,6,58,7],[59,6,59,7],[60,6,60,7],[40,2,40,3],[46,6,46,7],[47,6,47,7],[48,6,48,7],[49,6,49,7],[50,6,50,7]],"flags":["formulas_cached_only"]}
["Crop plan by field",{"$nulls":15},"Prices"]
[{"$nulls":16},"Corn",10]
[{"$nulls":16},"Soybeans",9]
["Name:  ______________________________________",{"$nulls":15},"Other",75]
["Plan description:  __________________________________________________"]
[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,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]
[{"$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]
[]
[]
[]
["Livestock production plan:"]
[]
["Description","# of head","weight","price","Share","Revenue/hd","Total Income"]
[{"$nulls":4},1,0,0]
[{"$nulls":5},0,0]
[{"$nulls":5},0,0]
[{"$nulls":5},0,0]
[{"$nulls":5},0,0]
[{"$nulls":5},0,0]
[{"$nulls":5},0,0]
[{"$nulls":5},0,0]
[{"$nulls":5},0,0]
[{"$nulls":5},0,0]
[{"$nulls":5},0,0]
[{"$nulls":5},0,0]
[{"$nulls":5},0,0]
["Totals",0,{"$nulls":4},0]

{"sheet":"Cashflow","index":2,"n_rows":230,"n_cols":16,"rows_kept":230,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Name:  ______________________________________",{"$nulls":6},"Town & Country Bank -- Monthly Cash Flow Plan",{"$nulls":7},"page 1"]
["Plan description:  __________________________________________________",null,null,null,"Date prepared: ","2021-11-01",{"$nulls":9},"File:  S:\\FINSTMT\\Blank forms\\Customer friendly forms\\[Blank Cashflow with monitoring worksheet.xls]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,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]
[1,"Farm Income:",{"$nulls":13},0]
[2,"Crop Income",{"$nulls":13},0]
[3,{"$nulls":14},0]
[4,{"$nulls":14},0]
[5,"Carryover sales from prior year",{"$nulls":13},0]
[6,{"$nulls":14},0]
[7,"Livestock Income",{"$nulls":13},0]
[8,{"$nulls":14},0]
[9,"Custom Hire Income",{"$nulls":13},0]
[10,"Government payments, other farm income",{"$nulls":13},0]
[11,{"$nulls":14},0]
[12,"Total Cash Farm Oper. Rev.",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[13,"Breeding livestock sales",{"$nulls":13},0]
[14,{"$nulls":14},0]
[15,"Sale of Other Capital Items",{"$nulls":13},0]
[16,"Personal income",{"$nulls":13},0]
[17,"Paid-In Capital",{"$nulls":13},0]
[18,"Borrowed (Other than Optg. Loan)",{"$nulls":13},0]
[19,"Total Cash Available",0,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]
[20,"Auto and Truck",{"$nulls":13},0]
[21,"Chemicals and Spray",{"$nulls":13},0]
[22,"Custom machine hire",{"$nulls":13},0]
[23,"Hay, Grain, Mineral and other Feed",{"$nulls":13},0]
[24,"Fertilizer",{"$nulls":13},0]
[25,"Gas, Oil, Fuel",{"$nulls":13},0]
[26,"Irrigation fuel",{"$nulls":13},0]
[27,"Insurance",{"$nulls":13},0]
[28,"Labor",{"$nulls":13},0]
[29,"Rent",{"$nulls":13},0]
[30,"Repairs",{"$nulls":13},0]
[31,"Seed",{"$nulls":13},0]
[32,"Supplies",{"$nulls":13},0]
[33,"Real Estate, Personal Property and other Taxes",{"$nulls":13},0]
[34,"Utilities",{"$nulls":13},0]
[35,"Veterinary",{"$nulls":13},0]
[36,"Legal, Professional & Consulting",{"$nulls":13},0]
[37,"Trucking",{"$nulls":13},0]
[38,"Miscellaneous",{"$nulls":13},0]
[39,{"$nulls":14},0]
[40,{"$nulls":14},0]
[41,{"$nulls":14},0]
[42,{"$nulls":14},0]
[43,"Beginning Accounts to be Paid",{"$nulls":13},0]
[44,"Total Cash Farm Oper. Exp.",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[45,"Purchases of Feeder Livestock",{"$nulls":13},0]
[46,"Other Purchases for Resale",{"$nulls":13},0]
[47,"Family Living",{"$nulls":13},0]
[48,"Income/SE Taxes",{"$nulls":13},0]
[49,"Capital Purchases",{"$nulls":13},0]
[50,"Breeding Livestock Purchases",{"$nulls":13},0]
[51,"Other Breeding Livestock/Capital Purchases",{"$nulls":13},0]
[52,"Interest (Operating Loan)",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[53,"Interest (Mortgage and Other Term)",{"$nulls":13},0]
[54,"Principal payments, term loans:",{"$nulls":13},0]
[55,{"$nulls":14},0]
[56,{"$nulls":14},0]
[57,{"$nulls":14},0]
[58,"Total Expenditures",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[59,"Periodic Net Cash Flow",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[60,"Cumulative Net Cash Flow (Deficit)",0,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]
[61,"Payments - Operating Loan",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[62,"Advances - Operating Loan",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[63,"Operating Loan Balance",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[64,"Accrued Optg. Interest     Rate:  5.75%",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[65,"Ending Cash",0,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]
[{"$nulls":15},"page 2"]
[66,"Growing Crops"]
[67,"Harvested Grain and Feed",null," "]
[68,"Market Livestock"]
[69,"Other Liquid Collateral"]
[70,"Liquid Margin",0,0,0,0,0,0,0,0,0,0,0,0,0]
[71,"Liquid Margin Percentage"]
[72,"Breeding & Dairy Livestock",null," "]
[73,"Machinery & Equipment",null," "]
[74,"Vehicles"]
[75,"Term Loans"]
[76,"Net Margin - Chattel Assets",0,0,0,0,0,0,0,0,0,0,0,0,0]
[77,"Net Margin Percentage"]
[78,"Net Realizable Value of Real Estate"]
[79,"Net Margin - All Collateral",0,0,0,0,0,0,0,0,0,0,0,0,0]
[80,"Net Margin Percentage"]
["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 ____________________"]
[]
["Signatures ________________________________________",null,null,"Date ____________________",null,null,null,"Signatures ________________________________________",{"$nulls":5},"Date ____________________"]
[]
[]
[{"$nulls":6},"Sensitivity Analysis"]
[{"$nulls":14},"With rev.","With rev."]
[{"$nulls":14},"decrease","decrease"]
[{"$nulls":14},0.05,0.1]
[{"$nulls":9},"As","With rev.","With rev.","With exp.","With exp.","and exp.","and exp."]
[{"$nulls":9},"Completed","decrease","decrease","increase","increase","increase","increase"]
[{"$nulls":10},0.05,0.1,0.05,0.1,0.05,0.1]
[]
[{"$nulls":6},"Projected Net Cash Flow",null,null,0,0,0,0,0,0,0]
[{"$nulls":6},"Projected Net Worth Change",null,null,0,0,0,0,0,0,0]
[]
[]
[]
[]
[null,"Summary and Ratio Analysis",{"$nulls":4},"Farmer Programs Information"]
[null,"Total Assets",0,null,null,null,"A)  Typical year gross farm operating income",{"$nulls":4},0,"Interest assistance would save how much:"]
[null,"Total Liabilities",0,null,null,null,"     Typical year cash flow operating expenses & interest",null,null,null,0,null,"Operating loan interest saved",null,null,0]
[null,"Net Worth",0,null,null,null,"     + depreciation",null,null,null,0,null,"Term debt interest saved (itemize):",null,null,0]
[{"$nulls":6},"= B)  Typical year total operating expenses",{"$nulls":4},0,null,null,null,0]
[null,"High Operating Credit:",0,null,null,null,"C)  Net operating income",{"$nulls":4},0,null,null,null,0]
[null,"Balance Available",1000,null,null,null,"D)  Nonfarm income",{"$nulls":4},0,"Total term debt interest saved",null,null,0]
[null,"Total Loan Payments and income/SE taxes",0,null,null,null,"E)  Depreciation",{"$nulls":4},0,"Term debt principal saved (itemize):",null,null,0]
[null,"Debt Repayment Margin",{"$error":"#DIV/0!"},null,null,null,"F)  Annual term debt interest",{"$nulls":4},0,null,null,null,0]
[null,"Interest as a % of gross cash sales",0,null,null,null,"G)  Annual capital lease interest",{"$nulls":4},0,null,null,null,0]
[{"$nulls":6},"H)  Income and Soc. Sec. taxes",{"$nulls":4},0,"Total term debt interest saved",null,null,0]
[null,"Note:  The following ratios are only valid with a",{"$nulls":4},"I)  Living expenses",{"$nulls":4},0,"L)  FSA Term debt coverage ratio",null,null,{"$error":"#DIV/0!"}]
[null,"       completed projected accrual income statement.",{"$nulls":4},"     Other living expenses and withdrawal adjustments",{"$nulls":4},0,"L2)  FSA Term debt coverage ratio with "]
[null,"Projected return on assets",{"$error":"#DIV/0!"},null,null,null,"J)  Balance available for term debt repayment",{"$nulls":4},0,"         interest assistance",null,null,{"$error":"#DIV/0!"}]
[null,"Projected return on equity",{"$error":"#DIV/0!"},null,null,null,"K)  Total interest and term principal payments",{"$nulls":4},0,"FNB Net Cash Flow w/ assistance",null,null,1000]
[null,"Projected asset turnover ratio",{"$error":"#DIV/0!"},{"$nulls":9},"FNB Net Worth Change w/ assistance",null,null,0]
[null,"Breakdown of gross revenues:",{"$nulls":4},"Table C - Capital Replacement and Term Debt Repayment Margin"]
[null,"   % Interest",{"$error":"#DIV/0!"},null,null,null,"M)  Cash carryover from previous year",{"$nulls":4},0]
[null,"   % Operating expenses",{"$error":"#DIV/0!"},null,null,null,"N)  Carryover debt from previous year",{"$nulls":4},0]
[null,"     % Feed",{"$error":"#DIV/0!"},null,null,null,"O)  Capital replacement and term debt repayment margin",{"$nulls":4},0]
[null,"     % Feeder livestock purchases",{"$error":"#DIV/0!"},null,null,null,"P)  Portion of capital assets not financed",{"$nulls":4},0]
[null,"   % Depreciation",{"$error":"#DIV/0!"},null,null,null,"Net (must be negative for interest rate assistance)",{"$nulls":4},0]
[null,"   % Net (before taxes & withdrawals)",{"$error":"#DIV/0!"}]
[null,"   Total",{"$error":"#DIV/0!"}]
[null,"Net Worth change as % of Gross",{"$error":"#DIV/0!"}]
[null,"Term Debt Coverage Ratio",{"$error":"#DIV/0!"}]
[]
["Year to Date Flag fields:",null,null,1,0,0,0,0,0,0,0,0,0,0,0]
{"$rows_empty":25}
["Inventory Flows"]
["Physical Inventory Flows:"]
[null,"(optional)",null,"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"]
["Crop enterprise:"]
[null,"Beginning Inventory",null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"+ Production",{"$nulls":13},0]
[null,"+ Purchases",{"$nulls":13},0]
[null,"- Sales",{"$nulls":13},0]
[null,"Sales price per unit"]
[null,"- Fed",{"$nulls":13},0]
[null,"= Ending Inventory",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Crop enterprise:"]
[null,"Beginning Inventory",null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"+ Production",{"$nulls":13},0]
[null,"+ Purchases",{"$nulls":13},0]
[null,"- Sales",{"$nulls":13},0]
[null,"Sales price per unit"]
[null,"- Fed",{"$nulls":13},0]
[null,"= Ending Inventory",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Crop enterprise:"]
[null,"Beginning Inventory",null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"+ Production",{"$nulls":13},0]
[null,"+ Purchases",{"$nulls":13},0]
[null,"- Sales",{"$nulls":13},0]
[null,"Sales price per unit"]
[null,"- Fed",{"$nulls":13},0]
[null,"= Ending Inventory",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Crop enterprise:"]
[null,"Beginning Inventory",null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"+ Production",{"$nulls":13},0]
[null,"+ Purchases",{"$nulls":13},0]
[null,"- Sales",{"$nulls":13},0]
[null,"Sales price per unit"]
[null,"- Fed",{"$nulls":13},0]
[null,"= Ending Inventory",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Livestock enterprise:"]
[null,"Beginning Inventory",null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"+ Production & Transfers",{"$nulls":13},0]
[null,"+ Purchases",{"$nulls":13},0]
[null,"- Death loss & transfers",{"$nulls":13},0]
[null,"- Sales",{"$nulls":13},0]
[null,"Sales Price"]
[null,"Sales weight"]
[null,"= Ending Inventory",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Livestock enterprise:"]
[null,"Beginning Inventory",null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"+ Production & Transfers",{"$nulls":13},0]
[null,"+ Purchases",{"$nulls":13},0]
[null,"- Death loss & transfers",{"$nulls":13},0]
[null,"- Sales",{"$nulls":13},0]
[null,"Sales Price"]
[null,"Sales weight"]
[null,"= Ending Inventory",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Livestock enterprise:"]
[null,"Beginning Inventory",null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"+ Production & Transfers",{"$nulls":13},0]
[null,"+ Purchases",{"$nulls":13},0]
[null,"- Death loss & transfers",{"$nulls":13},0]
[null,"- Sales",{"$nulls":13},0]
[null,"Sales Price"]
[null,"Sales weight"]
[null,"= Ending Inventory",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Livestock enterprise:"]
[null,"Beginning Inventory",null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"+ Production & Transfers",{"$nulls":13},0]
[null,"+ Purchases",{"$nulls":13},0]
[null,"- Death loss & transfers",{"$nulls":13},0]
[null,"- Sales",{"$nulls":13},0]
[null,"Sales Price"]
[null,"Sales weight"]
[null,"= Ending Inventory",null,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Income Statement","index":3,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,0,0,7]],"flags":["formulas_cached_only"]}
["Projected Income Statement Based on Cash Flow Projections"]
[]
["Name:  ______________________________________",null,null,"For 12 months ending:  _________________"]
["Plan description:  __________________________________________________",null,null,"Based on Cash Flow Plan dated: November 1,2021"]
["Projected Business Income"]
[null,"Operating sales (total of lines 1 through 11)",{"$nulls":5},0]
[null,"Breeding livestock sales (lines 13 & 14)",null,null,null,0]
[null,null,"less estimated cost basis of cull animals sold/died",null,"-"]
[null,null,"plus base value of raised breeding animals retained",null,"+",null,"=",0]
[null,"Estimated cash income adjustments:",null,"Estimated Ending",null,"Less Beginning"]
[null,null,null,"Inventory",null,"Inventory"]
[null,null,"Receivables",0,"-",0,"=",0]
[null,null,"Grain, hay and feed inventory",{"$nulls":4},0]
[null,null,"Market livestock inventory",{"$nulls":4},0]
["1.","Estimated Gross Revenues",{"$nulls":5},0]
[null,null,"less feeder livestock purchases (lines 41 & 42)",null,null,null,"-",0]
[null,null,"less feed purchases (line 23)",null,null,null,"-",0]
["2.","Estimated Value of Production",{"$nulls":5},0]
["Projected Business Expenses"]
[null,"Cash operating expenses (line 40 minus line 23)",{"$nulls":5},0]
[null,"Estimated operating expense adjustments:",null,"Beginning",null,"Less Estimated"]
[null,null,null,"Inventory",null,"Ending Inventory"]
[null,null,"Prepaid expenses and supplies",null,"-",null,"=",0]
[null,null,"Cash investment in growing crops",{"$nulls":4},0]
[null,null,null,"Estimated Ending",null,"Less Beginning"]
[null,null,null,"Inventory",null,"Inventory"]
[null,null,"Accounts payable",null,"-",null,"=",0]
[null,null,"Accrued expenses (except interest)",{"$nulls":4},0]
["a.","Total estimated operating expenses",{"$nulls":5},0]
["b.","Estimated depreciation",{"$nulls":5},0]
[null,"Cash interest payments (lines 48 & 49)",null,null,null,0]
[null,null,"plus estimated ending accrued interest",null,"+"]
["c.",null,"less beginning accrued interest",null,"-",null,"=",0]
["3.","Estimated Total Expenses",{"$nulls":5},0]
["Projected Net Income Summary"]
["4.","Estimated Net Income from Operations (2 - 3)",{"$nulls":5},0]
[null,"Estimated capital sales except breeding livestock (line 15)",null,null,null,0]
[null,null,"less cost basis of items sold",null,"-",null,"=",0]
["5.","Estimated Net Business Income",{"$nulls":5},0]
[null,null,"Estimated personal income (line 16)",null,null,null,"+",0]
[null,null,"Income and social security (self employment) taxes (line 44)",null,null,null,"-",0]
["6.","Estimated Net Income After Taxes",{"$nulls":5},0]
[null,null,"Less estimated family living and other withdrawals (line 43)",null,null,null,"-",0]
["7.","Estimated Net Worth Change (other than asset valuation changes)",{"$nulls":5},0]
["Comparison Information from Cash Flow Plan"]
[null,"Projected Paid-in Capital ",{"$nulls":5},0]
[null,"Projected Borrowed non-operating loan principal",{"$nulls":5},0]
[null,"Projected Capital Purchases",{"$nulls":5},0]
[null,"Projected Breeding Livestock Purchases",{"$nulls":5},0]
[null,"Projected Principal Payments",{"$nulls":5},0]
[null,"Net non-income/expense transactions",{"$nulls":5},0]

{"sheet":"Monitoring Worksheet","index":4,"n_rows":76,"n_cols":30,"rows_kept":76,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Town & Country Bank"]
["Cashflow Monitoring Worksheet"]
["Name:  ______________________________________",{"$nulls":4},"Prepared by: ",0,{"$nulls":20},"File:  S:\\FINSTMT\\Blank forms\\Customer friendly forms\\[Blank Cashflow with monitoring worksheet.xls]Monitoring Worksheet"]
["Plan description:  __________________________________________________",{"$nulls":4},"Date prepared: ","2021-11-01",{"$nulls":9},"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,1000,1000,1000,0,1000,0,1000,0,1000,0,1000,0,1000,0,1000,0,1000,0,1000,0,1000,0,1000,0,1000,1000,1000]
[1,"Farm 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]
[2,"Crop 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]
[3,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]
[4,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]
[5,"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]
[6,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]
[7,"Livestock 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]
[8,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]
[9,"Custom Hire 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]
[10,"Government payments, other farm 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]
[11,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]
[12,"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]
[13,"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]
[14,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]
[15,"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]
[16,"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]
[17,"Paid-In Capital",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,"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]
[19,"Total Cash Available",0,1000,1000,1000,0,1000,0,1000,0,1000,0,1000,0,1000,0,1000,0,1000,0,1000,0,1000,0,1000,0,1000,1000,1000]
[20,"Auto and Truck",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,"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]
[22,"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]
[23,"Hay, Grain, Mineral and other Feed",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,"Fertilizer",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,"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]
[26,"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]
[27,"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]
[28,"Labor",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,"Rent",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,"Repairs",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,"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]
[32,"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]
[33,"Real Estate, Personal Property and other 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]
[34,"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]
[35,"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]
[36,"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]
[37,"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]
[38,"Miscellaneous",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,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]
[40,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]
[41,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]
[42,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]
[43,"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]
[44,"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]
[45,"Purchases of Feeder Livestock",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]
[46,"Other Purchases 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]
[47,"Family Living",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]
[48,"Income/SE 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]
[49,"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]
[50,"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]
[51,"Other Breeding Livestock/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]
[52,"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]
[53,"Interest (Mortgage and Other Term)",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]
[54,"Principal payments, term loans:",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]
[55,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]
[56,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]
[57,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]
[58,"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]
[59,"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]
[60,"Cumulative Net Cash Flow (Deficit)",0,1000,1000,1000,0,1000,0,1000,0,1000,0,1000,0,1000,0,1000,0,1000,0,1000,0,1000,0,1000,0,1000,1000,1000]
[61,"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]
[62,"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]
[63,"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]
[64,"Accrued Optg. Interest     Rate:  5.8%",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]
[65,"Ending Cash",0,1000,null,1000,null,1000,null,1000,null,1000,null,1000,null,1000,null,1000,null,1000,null,1000,null,1000,null,1000,null,1000,1000,1000]
[]
[]
[]
[]
["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]