{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Home","Cash Flow"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Home","index":0,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,0,30,8],[7,0,7,8]]}
[]
[]
[]
[]
[]
[]
["Instructions"]
["Use the yellow shaded cells found on the Cash Flow tab to fill in values for each category. "]
[]
["Each section will be subtotaled and automatically calculated in the orange shaded cells on the Cash Flow tab."]
[]
["Enter data in the yellow shaded cells only. "]
["Orange shaded cells will be calculated automatically from numbers entered in yellow shaded cells. "]
["Only add lines within sections with yellow cells."]
[]
["Options"]
["Users may create either a Farm, personal, or consolidated cash flow plan. "]
["Users may create a cash flow plan using either projected values or actual values."]
[]
["OCES Fact Sheets"]
["AGEC-751, Developing a Cash Flow Plan"]
["AGEC-302, Information Systems for Oklahoma Farmers"]
["AGEC-208, Evaluating Options for Change"]
[]
["Additional Spreadsheet Tools"]
["OSU spreadsheet tools"]
["www.beefextension.com/"]
["KSU spreadsheet tools"]
["ISU spreadsheet tools"]
[]
["Disclaimer: This spreadsheet is provided by the Oklahoma Cooperative Extension Service for educational use and is provided solely on an “AS IS” basis. Oklahoma Cooperative Extension Service assumes no liability for the use of these programs. "]

{"sheet":"Cash Flow","index":1,"n_rows":101,"n_cols":15,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["Cash Flow ","*Please fill in the yellow shaded cells. Orange shaded cells will fill in automatically. "]
["Name: "]
["Covering the Period: "]
["Plan Type (farm, personal or consolidated) : "]
["Actual or Projected: "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line reference"]
["Cash Received From Operations ","Totals ","January ","February","March ","April ","May ","June ","July ","August","September","October","November","December "]
["    1) Sale of Livestock Bought for Resale",{"$f":"SUM(C8:N8)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,1]
["    2) Sale of Livestock Products",{"$f":"SUM(C9:N9)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,2]
["    3) Livestock Sales (raised) ",0,null,null,null,null,null,null,null,null,null,null,null,null,3]
["    4) Crop Sales",0,null,null,null,null,null,null,null,null,null,null,null,null,4]
["    5) Other Raised Sales",0,null,null,null,null,null,null,null,null,null,null,null,null,5]
["    6) Government Payments",0,null,null,null,null,null,null,null,null,null,null,null,null,6]
["    7) Other Farm Income ",0,null,null,null,null,null,null,null,null,null,null,null,null,7]
["    8) Patronage Dividends ",0,null,null,null,null,null,null,null,null,null,null,null,null,8]
["    9) TOTAL CASH RECEIVED FROM OPERATIONS  (Sum 1 thru 8) ",0,{"$f":"SUM(C8:C15)","v":0},0,0,0,0,{"$f":"SUM(H8:H15)","v":0},0,0,0,0,{"$f":"SUM(M8:M15)","v":0},{"$f":"SUM(N8:N15)","v":0},9]
[]
["Cash Received From Capital "]
["    10) Non-Real Property ",{"$f":"SUM(C19:N19)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,10]
["    11) Land, Buildings & Improvements ",0,null,null,null,null,null,null,null,null,null,null,null,null,11]
["    12) Non-Farm Property ",0,null,null,null,null,null,null,null,null,null,null,null,null,12]
[]
["Other Inflows "]
["    13) Wages and Salaries ",{"$f":"SUM(C24:N24)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,13]
["    14) Other Contributed Capital ",0,null,null,null,null,null,null,null,null,null,null,null,null,14]
["    15) Royalty Income  ",0,null,null,null,null,null,null,null,null,null,null,null,null,15]
["    16) TOTAL CASH INFLOWS   (Sum 9 thru 15) ",0,{"$f":"SUM( C16:C26)","v":0},0,0,0,0,{"$f":"SUM( H16:H26)","v":0},0,0,0,0,0,{"$f":"SUM( N16:N26)","v":0},16]
[]
["Operating Expenses"]
["    17) Car and Truck Expenses ",{"$f":"SUM(C30:N30)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,17]
["    18) Chemicals ",0,null,null,null,null,null,null,null,null,null,null,null,null,18]
["    19) Conservation Expenses ",0,null,null,null,null,null,null,null,null,null,null,null,null,19]
["    20) Custom Hire (machine work) ",0,null,null,null,null,null,null,null,null,null,null,null,null,20]
["    21) Employee Benefits ",0,null,null,null,null,null,null,null,null,null,null,null,null,21]
["    22) Feed",0,null,null,null,null,null,null,null,null,null,null,null,null,22]
["    23) Fertilizers and Lime ",0,null,null,null,null,null,null,null,null,null,null,null,null,23]
["    24) Freight and Trucking ",0,null,null,null,null,null,null,null,null,null,null,null,null,24]
["    25) Gasoline, Fuel, and Oil ",0,null,null,null,null,null,null,null,null,null,null,null,null,25]
["    26) Insurance ",0,null,null,null,null,null,null,null,null,null,null,null,null,26]
["    27) Labor Hired ",0,null,null,null,null,null,null,null,null,null,null,null,null,27]
["    28) Pension and Profit-Sharing ",0,null,null,null,null,null,null,null,null,null,null,null,null,28]
["    29) Rent or Lease ",0,null,null,null,null,null,null,null,null,null,null,null,null,29]
["    30) Repairs and Maintenance ",0,null,null,null,null,null,null,null,null,null,null,null,null,30]
["    31) Seeds and Plants ",0,null,null," ",null,null,null,null,null,null,null,null,null,31]
["    32) Storage and Warehousing ",0,null,null,null,null,null,null,null,null,null,null,null,null,32]
["    33) Supplies ",0,null,null,null,null,null,null,null,null,null,null,null,null,33]
["    34) Taxes",0,null,null,null,null,null,null,null,null,null,null,null,null,34]
["    35) Utilities ",0,null,null,null,null,null,null,null,null,null,null,null,null,35]
["    36) Veterinary, Breeding, and Medicine ",0,null,null,null,null,null,null,null,null,null,null,null,null,36]
["    37) Other Expenses ",0,null,null,null,null,null,null,null,null,null,null,null,null,37]
["    38) ",0,null,null,null,null,null,null,null,null,null,null,null,null,38]
["    39) ",0,null,null,null,null,null,null,null,null,null,null,null,null,39]
["    40) Cost of Livestock Purchased for Resale ",0,null,null,null,null,null,null,null,null,null,null,null,null,40]
["    41) TOTAL CASH EXPENSES   (Sum 17 thru 40)",0,{"$f":"SUM(C30:C53)","v":0},0,0,0,0,{"$f":"SUM(H30:H53)","v":0},0,0,0,{"$f":"SUM(L30:L53)","v":0},0,{"$f":"SUM(N30:N53)","v":0},41]
[]
["Capital Expenses "]
["    42) Non-Real Property ",{"$f":"SUM(C57:N57)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,42]
["    43) Land, Buildings, & Improvements ",0,null,null,null,null,null,null,null,null,null,null,null,null,43]
["    44) Non-Farm Property ",0,null,null,null,null,null,null,null,null,null,null,null,null,44]
[]
["Other Outflows "]
["    45) Family Living ",{"$f":"SUM(C62:N62)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,45]
["    46) Income & Social Security Taxes ",0,null,null,null,null,null,null,null,null,null,null,null,null,46]
["    47) ",0,null,null," ",null,null,null,null,null,null,null,null,null,47]
["    48)",0,null,null,null,null,null,null,null,null,null,null,null,null,48]
[]
["Scheduled Loan Payments "]
["    49) Current Short Term            - Interest ",{"$f":"SUM(C68:N68)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,49]
["    50)                                              - Principal  ",0,null,null,null,null,null,null,null,null,null,null,null,null,50]
["    51) Non-Real Estate                    - Interest ",0,null,null,null,null,null,null,null,null,null,null,null,null,51]
["    52)                                              - Principal ",0,null,null,null,null,null,null,null,null,null,null,null,null,52]
["    53) Real Estate                            - Interest ",0,null,null,null,null,null,null,null,null,null,null,null,null,53]
["    54)                                              - Principal ",0,null,null,null,null,null,null,null,null,null,null,null,null,54]
["    55) Non-Farm Loan                   - Interest",0,null,null,null,null,null,null,null,null,null,null,null,null,55]
["    56)                                             - Principal ",0,null,null,null,null,null,null,null,null,null,null,null,null,56]
["    57) TOTAL CASH OUTFLOWS   (Sum 41 thru 56)",{"$f":"SUM(C76:N76)","v":0},{"$f":"SUM(C54:C75)","v":0},0,0,0,0,{"$f":"SUM(H54:H75)","v":0},0,0,0,0,0,0,57]
[]
["New Borrowing "]
["    58) Short Term ",{"$f":"SUM(C79:N79)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,58]
["    59) Non-Real Estate ",0,null,null,null,null,null,null,null,null,null,null,null,null,59]
["    60) Real Estate ",0,null,null,null,null,null,null,null,null,null,null,null,null,60]
[]
["Cash Flow Summary ",null,"January ","February","March ","April ","May ","June ","July ","August","September","October","November","December "]
["        Interest Rate on Line of Credit (percent): "]
["        Minimum Cash Balance: "]
["    61) Beginning Cash Balance ",null,{"$f":"B86","v":0},{"$f":"C93","v":0},0,0,0,0,0,0,0,0,0,0,61]
["    62) Inflows-Outflows   (16-57)",null,{"$f":"C27-C76","v":0},0,0,0,0,0,0,0,0,0,0,0,62]
["    63) Cash Position   (Sum 58 thru 62) ",null,{"$f":"SUM(C79:C87)","v":0},0,{"$f":"SUM(E79:E87)","v":0},0,{"$f":"SUM(G79:G87)","v":0},{"$f":"SUM(H79:H87)","v":0},0,0,0,0,0,{"$f":"SUM(N79:N87)","v":0},63]
["    64) New Borrowing, Line of Credit ",null,{"$f":"IF((C88<$B85),($B85-C88),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,64]
["    65) Interest Accrued, Line of Credit       ",null,{"$f":"(B96*$B84/1200)+B90-B91","v":0},0,0,0,0,0,0,0,0,0,0,0,65]
["    66) Line of Credit                     - Interest Payments",null,{"$f":"MIN(C88+C89-$B85,C90)","v":0},0,0,0,0,0,0,0,0,0,0,0,66]
["    67) Line of Credit                     - Principal Payments",null,{"$f":"MIN(C88+C89-$B85-C91,B96)","v":0},0,0,0,0,0,0,0,0,0,0,0,67]
["    68) Ending Cash Balance ",null,{"$f":"C88+C89-C91-C92","v":0},{"$f":"D88+D89-D91-D92","v":0},{"$f":"E88+E89-E91-E92","v":0},0,0,0,0,0,0,0,0,0,68]
[]
["Outstanding Loan Balances"]
["    69) Outstanding Credit Line Loans",null,{"$f":"B96+C89-C92","v":0},{"$f":"C96+D89-D92","v":0},0,0,0,0,0,0,0,0,0,0,69]
["    70) Outstanding Short Term Loans ",null,{"$f":"B97+C79-C69","v":0},0,0,0,0,0,0,0,0,0,0,0,70]
["    71) Outstanding Non-R.E. Loans",null,{"$f":"B98+C80-C71","v":0},0,0,0,0,0,0,0,0,0,0,0,71]
["    72) Outstanding Real Estate Loans",null,{"$f":"B99+C81-C73","v":0},0,0,0,0,0,0,0,0,0,0,0,72]
["    73) Outstanding Non-Farm Loans",null,{"$f":"B100-C75","v":0},0,0,0,0,0,0,0,0,0,0,0,73]
["    74) TOTAL OUTSTANDING LOANS   (Sum 69 thru 73) ",{"$f":"SUM(B96:B100)","v":0},{"$f":"SUM(C96:C100)","v":0},0,0,0,0,{"$f":"SUM(H96:H100)","v":0},0,0,0,0,0,{"$f":"SUM(N96:N100)","v":0},74]