{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Balance Sheet","Balance Sheet Schedules","ENW Change","Projected Cash Flow","Cash Flow Schedule"],"not_rendered":{"charts":0,"images":3,"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":"Balance Sheet","index":0,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,4],[4,6,4,7],[5,6,5,7],[8,0,8,2],[8,6,8,8],[8,3,8,4],[4,8,4,9],[5,8,5,9],[4,0,4,1],[5,0,5,1],[1,0,2,9],[3,4,3,7],[19,3,19,4],[20,3,20,4],[27,0,27,2],[28,0,28,2],[29,0,29,2],[30,0,30,2],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,24,2],[28,3,28,4],[29,3,29,4],[30,3,30,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[24,3,24,4],[17,3,17,4],[18,3,18,4],[9,0,9,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[14,0,14,2],[15,0,15,2],[16,0,16,2],[17,0,17,2],[15,3,15,4],[16,3,16,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],[16,6,16,8],[17,6,17,8],[18,6,18,8],[19,6,19,8],[20,6,20,8],[21,6,21,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[12,6,12,8],[13,6,13,8],[14,6,14,8],[15,6,15,8],[31,6,31,8],[32,6,32,8],[33,6,33,8],[34,6,34,8],[31,0,31,2],[32,0,32,2],[33,0,33,2],[34,3,34,4],[22,6,22,8],[23,6,23,8],[25,6,25,8],[26,6,26,8],[27,6,27,8],[28,6,28,8],[25,0,25,2],[26,0,26,2],[31,3,31,4],[32,3,32,4],[33,3,33,4],[51,6,51,7],[0,6,0,9],[40,0,46,9],[47,3,47,4],[47,0,47,2],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[47,6,47,8],[34,0,34,2],[35,0,35,2],[36,0,36,2],[37,0,37,2],[38,0,38,2],[39,0,39,2],[35,6,35,8],[36,6,36,8],[37,6,37,8],[38,6,38,8],[39,6,39,8],[29,6,29,8],[30,6,30,8]]}
[]
["Balance Sheet"]
[]
[null,null,null,null,"Date: "]
["Applicant:"]
["Spouse:"]
["This form will autofill when financial information is entered on Balance Sheet Schedules sheet."]
["Assets",null,null,null,null,null,"Liabilities"]
["Current Assets",null,null,null,null,null,"Current Liabilities"]
["Cash",null,null,{"$f":"'Balance Sheet Schedules'!G6","v":0},null,null,"Accounts Payable",null,null,{"$f":"'Balance Sheet Schedules'!H132","v":0}]
["Savings",null,null,{"$f":"'Balance Sheet Schedules'!G11","v":0},null,null,"Notes Payable",null,null,{"$f":"'Balance Sheet Schedules'!G138","v":0}]
["Hedging Equity",null,null,{"$f":"'Balance Sheet Schedules'!G16","v":0},null,null,"Current Portion LTD",null,null,{"$f":"'Balance Sheet Schedules'!H160+'Balance Sheet Schedules'!H166","v":0}]
["Marketable Securities",null,null,{"$f":"'Balance Sheet Schedules'!E22","v":0},null,null,"Accrued Interest",null,null,{"$f":"'Balance Sheet Schedules'!F166+'Balance Sheet Schedules'!F160+'Balance Sheet Schedules'!H138","v":0}]
["Accounts & Notes Receivable",null,null,{"$f":"'Balance Sheet Schedules'!C28","v":0},null,null,"Accrued Taxes",null,null,{"$f":"'Balance Sheet Schedules'!H143","v":0}]
["Livestock to be Sold",null,null,{"$f":"'Balance Sheet Schedules'!G41","v":0},null,null,"Accrued Rents & Leases",null,null,{"$f":"'Balance Sheet Schedules'!H148","v":0}]
["Crops & Feed",null,null,{"$f":"'Balance Sheet Schedules'!G47","v":0},null,null,"Other Current Liabilities",null,null,{"$f":"'Balance Sheet Schedules'!F154","v":0}]
["Investment in Growing Crops",null,null,{"$f":"'Balance Sheet Schedules'!G53","v":0}]
["Supplies",null,null,{"$f":"'Balance Sheet Schedules'!G59","v":0}]
["Prepaid Expenses",null,null,{"$f":"'Balance Sheet Schedules'!G64","v":0}]
["Other Current Assets",null,null,{"$f":"'Balance Sheet Schedules'!C34","v":0}]
["Total Current Assets",null,null,{"$f":"SUM(D9:E20)","v":0},null,null,"Total Current Liabilities",null,null,{"$f":"SUM(J9:J20)","v":0}]
["Intermediate Assets",null,null,null,null,null,"Intermediate Liabilities"]
["Accounts & Notes Receivable",null,null,{"$f":"'Balance Sheet Schedules'!E28","v":0},null,null,"Intermediate Notes Payable",null,null,{"$f":"'Balance Sheet Schedules'!E160-'Balance Sheet Schedules'!H160","v":0}]
["Machinery & Equipment",null,null,{"$f":"'Balance Sheet Schedules'!G80","v":0},null,null,"Other Intermediate Liabilities",null,null,{"$f":"'Balance Sheet Schedules'!G154","v":0}]
["Titled Farm Vehicles",null,null,{"$f":"'Balance Sheet Schedules'!G87","v":0}]
["Breeding Stock",null,null,{"$f":"'Balance Sheet Schedules'!G93","v":0}]
["Retirement Accounts",null,null,{"$f":"'Balance Sheet Schedules'!G99","v":0}]
["Life Insurance Cash Values",null,null,{"$f":"'Balance Sheet Schedules'!G105","v":0}]
["Securities Not Readily Marketable",null,null,{"$f":"'Balance Sheet Schedules'!G22","v":0}]
["Personal Items",null,null,{"$f":"'Balance Sheet Schedules'!G111","v":0}]
["Other Intermediate Assets",null,null,{"$f":"'Balance Sheet Schedules'!E34","v":0}]
["Total Intermediate Assets",null,null,{"$f":"SUM(D23:E31)","v":0},null,null,"Total Intermediate Liabilities",null,null,{"$f":"SUM(J23:J31)","v":0}]
["Long Term Assets",null,null,null,null,null,"Long Term Liabilities"]
["Accounts & Notes Receivable",null,null,{"$f":"'Balance Sheet Schedules'!G28","v":0},null,null,"Long Term Notes Payable",null,null,{"$f":"'Balance Sheet Schedules'!E166-'Balance Sheet Schedules'!H166","v":0}]
["Farm Real Estate",null,null,{"$f":"'Balance Sheet Schedules'!G120","v":0},null,null,"Other Long Term Liabilities",null,null,{"$f":"'Balance Sheet Schedules'!H154","v":0}]
["Non-Farm Real Estate",null,null,{"$f":"'Balance Sheet Schedules'!G126","v":0},null,null,"Total Long Term Liabilities",null,null,{"$f":"SUM(J34:J35)","v":0}]
["Other Long Term Assets",null,null,{"$f":"'Balance Sheet Schedules'!G34","v":0},null,null,"Total Liabilities",null,null,{"$f":"J21+J32+J36","v":0}]
["Total Long Term Assets",null,null,{"$f":"SUM(D34:E37)","v":0},null,null,"Total Net Worth",null,null,{"$f":"D39-J37","v":0}]
["Total Assets",null,null,{"$f":"D21+D32+D38","v":0},null,null,"Total Liabilities & Net Worth",null,null,{"$f":"SUM(J37:J38)","v":0}]
[]
["I certify that the information on the Balance Sheet is true and accurate to the best of my knowledge.\n\n                                                                             \n\nProfessional Signature                                                                        Title                                                                         Date"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Applicant Signature",null,null,null,"Date",null,"Spouse Signature",null,null,"                   Date"]

{"sheet":"Balance Sheet Schedules","index":1,"n_rows":171,"n_cols":8,"rows_kept":171,"cut":false,"hidden":false,"merged":[[18,4,18,5],[19,4,19,5],[49,0,49,2],[49,4,49,5],[20,4,20,5],[21,4,21,5],[33,2,33,3],[33,4,33,5],[24,2,24,3],[24,4,24,5],[30,2,30,3],[30,4,30,5],[35,4,35,5],[129,5,129,6],[130,5,130,6],[58,0,58,5],[52,4,52,5],[43,0,43,2],[46,0,46,2],[63,0,63,5],[50,4,50,5],[51,4,51,5],[52,0,52,2],[128,0,128,4],[107,0,107,4],[122,0,122,4],[128,5,128,6],[0,0,0,7],[153,0,153,2],[153,3,153,4],[137,0,137,2],[137,3,137,4],[139,0,139,6],[142,0,142,5],[144,0,144,6],[147,0,147,5],[150,0,150,4],[27,2,27,3],[27,4,27,5],[35,0,35,2],[37,0,37,1],[40,0,40,1],[131,0,131,5]]}
["Balance Sheet Schedules"]
["Additional lines can be added in each schedule while maintaining formulas, by highlighting a gray shaded row, and then right click and choose Insert."]
["Schedule A: Cash",null,null,null,null,null,"Amount","Collateral"]
[]
[]
["Total:",null,null,null,null,null,{"$f":"SUM(G4:G5)","v":0}]
[]
["Schedule B: Savings",null,null,null,null,null,"Amount","Collateral"]
[]
[]
["Total:",null,null,null,null,null,{"$f":"SUM(G9:G10)","v":0}]
[]
["Schedule C: Hedging Equity",null,null,null,null,null,"Amount","Collateral"]
[]
[]
["Total:",null,null,null,null,null,{"$f":"SUM(G14:G15)","v":0}]
[]
["Schedule D: Bonds & Securities"]
["Description",null,null,"% Owned","Marketable Securities",null,"Non-Readily Marketable Securities","Collateral"]
[]
[]
["Total:",null,null,null,{"$f":"SUM(E20:F21)","v":0},null,{"$f":"SUM(G20:G21)","v":0}]
[]
["Schedule E: Accounts & Notes Receivable"]
["Description",null,"Current Receivables",null,"Intermediate Receivables",null,"Long Term Receivables","Collateral"]
[]
[]
["Total:",null,{"$f":"SUM(C26:D27)","v":0},null,{"$f":"SUM(E26:F27)","v":0},null,{"$f":"SUM(G26:G27)","v":0}]
[]
["Schedule F: Other Assets (retirement, HSA, etc.)"]
["Description",null,"Other Current Assets",null,"Other Intermediate Assets",null,"Other Long Term Assets","Collateral"]
[]
[]
["Total:",null,{"$f":"SUM(C32:D33)","v":0},null,{"$f":"SUM(E32:F33)","v":0},null,{"$f":"SUM(G32:G33)","v":0}]
[]
[]
["Schedule G: Livestock to be Sold"]
["Description",null,"Number Head","% Owned","Avg Weight","Price per lb","Market Value","Collateral"]
[null,null,null,null,null,null,{"$f":"C39*D39*E39*F39","v":0}]
[null,null,null,null,null,null,{"$f":"C40*D40*E40*F40","v":0}]
["Total:",null,{"$f":"SUM(C39:C40)","v":0},null,null,null,{"$f":"SUM(G39:G40)","v":0}]
[]
["Schedule H: Crops & Feed"]
["Description",null,null,"Quantity","Unit","$/Unit","Market Value","Collateral"]
[null,null,null,null,null,null,{"$f":"D45*F45","v":0}]
[null,null,null,null,null,null,{"$f":"D46*F46","v":0}]
["Total:",null,null,null,null,null,{"$f":"SUM(G45:G46)","v":0}]
[]
["Schedule I: Investment in Growing Crops"]
["Description",null,null,"Acres","$/Acre",null,"Market Value","Collateral"]
[null,null,null,null,null,null,{"$f":"D51*E51","v":0}]
[null,null,null,null,null,null,{"$f":"D52*E52","v":0}]
["Total:",null,null,{"$f":"SUM(D51:D52)","v":0},null,null,{"$f":"SUM(G51:G52)","v":0}]
[]
[]
["Schedule J: Supplies",null,null,null,null,null,"Amount","Collateral"]
[]
[]
["Total:",null,null,null,null,null,{"$f":"SUM(G57:G58)","v":0}]
[]
["Schedule K: Prepaid Expenses",null,null,null,null,null,"Amount","Collateral"]
[]
[]
["Total:",null,null,null,null,null,{"$f":"SUM(G62:G63)","v":0}]
[]
["Schedule L: Machinery & Equipment"]
["Description",null,null,"% Owned","Serial #","Condition","Market Value","Collateral"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total:",null,null,null,null,null,{"$f":"SUM(G68:G79)","v":0}]
[]
["Schedule M: Titled Farm Vehicles"]
["Description",null,null,"% Owned","VIN #","Condition","Market Value","Collateral"]
[]
[]
[]
["Total:",null,null,null,null,null,{"$f":"SUM(G84:G86)","v":0}]
[]
["Schedule N: Breeding Livestock"]
["Description",null,null,"# Head","% Owned","$/Head","Market Value","Collateral"]
[null,null,null,null,null,null,{"$f":"D91*E91*F91","v":0}]
[null,null,null,null,null,null,{"$f":"D92*E92*F92","v":0}]
["Total:",null,null,null,null,null,{"$f":"SUM(G91:G92)","v":0}]
[]
["Schedule O: Retirement Accounts"]
["Company or Firm",null,null,null,null,null,"Market Value","Collateral"]
[]
[]
["Total:",null,null,null,null,null,{"$f":"SUM(G97:G98)","v":0}]
[]
["Schedule P: Life Insurance"]
["Insurance Company",null,null,"Beneficiary","Type of Policy","Face Value","Cash Value","Collateral"]
[]
[]
["Total:",null,null,null,null,{"$f":"SUM(F103:F104)","v":0},{"$f":"SUM(G103:G104)","v":0}]
[]
["Schedule Q: Personal Items"]
["Description",null,null,null,null,"Year","Market Value","Collateral"]
[]
[]
["Total:",null,null,null,null,null,{"$f":"SUM(G109:G110)","v":0}]
[]
[]
[]
[]
["Schedule R: Farm Real Estate"]
["Description",null,null,null,"Total Acres","$/Acre","Market Value","Collateral"]
[null,null,null,null,null,null,{"$f":"E118*F118","v":0}]
[null,null,null,null,null,null,{"$f":"E119*F119","v":0}]
["Total:",null,null,null,{"$f":"SUM(E118:E119)","v":0},null,{"$f":"SUM(G118:G119)","v":0}]
[]
["Schedule S: Non-Farm Real Estate"]
["Description",null,null,null,null,"Year Acquired","Market Value","Collateral"]
[]
[]
["Total:",null,null,null,null,null,{"$f":"SUM(G124:G125)","v":0}]
[]
["Schedule T: Accounts Payable"]
["Description",null,null,null,null,"Creditor",null,"Amount"]
[]
[]
["Total:",null,null,null,null,null,null,{"$f":"SUM(H130:H131)","v":0}]
[]
["Schedule U: Notes Payable"]
["Description",null,"Creditor/Note#",null,"Interest Rate","Maturity Date","Balance","Accrued Interest"]
[]
[]
["Total:",null,null,null,null,null,{"$f":"SUM(G136:G137)","v":0},{"$f":"SUM(H136:H137)","v":0}]
[]
["Schedule V: Accrued Taxes",null,null,null,null,null,null,"Amount"]
[]
[]
["Total:",null,null,null,null,null,null,{"$f":"SUM(H141:H142)","v":0}]
[]
["Schedule W: Accrued Rents & Leases",null,null,null,null,null,null,"Amount"]
[]
[]
["Total:",null,null,null,null,null,null,{"$f":"SUM(H146:H147)","v":0}]
[]
["Schedule X: Other Liabilities"]
["Description",null,null,null,null,"Other Current Liabilities","Other Intermediate Liabilities","Other Long Term Liabilities"]
[]
[]
["Total:",null,null,null,null,{"$f":"SUM(F152:F153)","v":0},{"$f":"SUM(G152:G153)","v":0},{"$f":"SUM(H152:I153)","v":0}]
[]
["Schedule Y: Intermediate Loans"]
["Description","Creditor/Note #","Interest Rate","Maturity Date","Balance","Accrued Interest","Annual Payment ","Current  Principal Due"]
[null,null,null,null,null,null,null,{"$f":"G158-(E158*C158)","v":0}]
[null,null,null,null,null,null,null,{"$f":"G159-(E159*C159)","v":0}]
["Total:",null,null,null,{"$f":"SUM(E158:E159)","v":0},{"$f":"SUM(F158:F159)","v":0},{"$f":"SUM(G158:G159)","v":0},{"$f":"SUM(H158:H159)","v":0}]
[]
["Schedule Z: Long Term Loans"]
["Description","Creditor/Note #","Interest Rate","Maturity Date","Balance","Accrued Interest","Annual Payment","Current Principal Due"]
[null,null,null,null,null,null,null,{"$f":"G164-(E164*C164)","v":0}]
[null,null,null,null,null,null,null,{"$f":"G165-(E165*C165)","v":0}]
["Total:",null,null,null,{"$f":"SUM(E164:E165)","v":0},{"$f":"SUM(F164:F165)","v":0},{"$f":"SUM(G164:G165)","v":0},{"$f":"SUM(H164:H165)","v":0}]
[]
[]
[]
[null,null,null,null,"Column1"]
[null,null,null,null,"Yes"]

{"sheet":"ENW Change","index":2,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":true,"merged":[[16,1,16,4],[7,1,7,4],[7,7,7,8],[0,1,0,9],[8,1,8,4],[9,1,9,4],[10,1,10,4],[2,8,2,9],[2,2,2,5],[3,2,3,5],[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[28,1,28,4],[17,1,17,4],[18,1,18,4],[19,1,19,4],[20,1,20,4],[21,1,21,4],[22,1,22,4],[23,1,23,4],[24,1,24,4],[25,1,25,4],[26,1,26,4],[27,1,27,4],[40,1,40,4],[29,1,29,4],[30,1,30,4],[31,1,31,4],[32,1,32,4],[33,1,33,4],[34,1,34,4],[22,7,22,8],[41,1,41,4],[8,7,8,8],[9,7,9,8],[10,7,10,8],[11,7,11,8],[12,7,12,8],[13,7,13,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[35,1,35,4],[36,1,36,4],[37,1,37,4],[38,1,38,4],[39,1,39,4],[17,7,17,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[34,7,34,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[26,7,26,8],[27,7,27,8],[28,7,28,8],[29,7,29,8],[30,7,30,8],[31,7,31,8],[32,7,32,8],[33,7,33,8],[41,7,41,8],[35,7,35,8],[36,7,36,8],[37,7,37,8],[38,7,38,8],[39,7,39,8],[40,7,40,8]]}
[null,"Earned Net Worth Change Calculation"]
[]
[null,"Borrower:",{"$f":"'Balance Sheet'!C5","v":0},null,null,null,null,"Date:",{"$f":"'Balance Sheet'!G3","v":"00:00:00"}]
[null,"Co-Borrower:",{"$f":"'Balance Sheet'!C6","v":0}]
[]
[]
[]
[null,"Current Year Net Worth",null,null,null,null,null,{"$f":"'Balance Sheet'!J38","v":0}]
[]
[null,"Previous Year Net Worth"]
[]
[null,"Net Worth Change",null,null,null,null,null,{"$f":"H8-H10","v":0}]
[]
[]
[null,"Earned Net Worth Adjustments:"]
[null,"Change in Equipment"]
[]
[null,"Change in Vehicles"]
[]
[null,"Change in Breeding Stock"]
[]
[null,"Change in Personal Items"]
[]
[null,"Change in Land"]
[]
[null,"Change in Buildings & Improvements"]
[]
[null,"Other Changes"]
[]
[null,"Total Earned Net Worth Adjustments",null,null,null,null,null,{"$f":"H16+H18+H20+H22+H24+H26+H28","v":0}]
[]
[]
[null,"Earned Net Worth Change",null,null,null,null,null,{"$f":"H12+H30","v":0}]

{"sheet":"Projected Cash Flow","index":3,"n_rows":73,"n_cols":2,"rows_kept":73,"cut":false,"hidden":false,"merged":[[72,0,72,5],[0,6,2,8],[0,0,2,0],[0,1,2,5],[63,0,67,8]]}
[null,"Projected Annual Cash Flow"]
[]
[]
["Applicant"]
["Source","Projection"]
["Year"]
["Cells containing $0 will autofill when financial information is entered on Cash Flow Schedule."]
["Cash Inflows"]
["Livestock Sales less Purchases.",{"$f":"'Cash Flow Schedule'!I19-'Cash Flow Schedule'!E19","v":0}]
["Crops & Feed",{"$f":"'Cash Flow Schedule'!I12","v":0}]
["Coop Dist"]
["Gov. Pmts"]
["Crop Insurance"]
["Custom Work"]
["Other Farm Income"]
["Total Farm Income",{"$f":"SUM(B9:B15)","v":0}]
[]
["Personal Income 1040"]
["Business Income Sch. C"]
["Rental Income Sch. E"]
["Other Income",{"$f":"'Cash Flow Schedule'!I33","v":0}]
["Total Other Income",{"$f":"SUM(B18:B21)","v":0}]
[]
["Gross Income",{"$f":"B16+B22","v":0}]
[]
["Expenses"]
["Auto "]
["Chemicals"]
["Conservation Exp."]
["Custom Hire"]
["Feed "]
["Fertilizer"]
["Freight & Trucking"]
["Gas, Fuel, Oil"]
["Insurance"]
["Labor"]
["Rents & Leases",{"$f":"'Cash Flow Schedule'!I27","v":0}]
["Repairs"]
["Seed"]
["Storage"]
["Supplies"]
["Farm Taxes"]
["Utilities"]
["Livestock Expense"]
["Legal & Prof"]
["Misc. "]
["Total Farm Expenses",{"$f":"SUM(B27:B46)","v":0}]
[]
["Fixed Interest",{"$f":"'Cash Flow Schedule'!H41","v":0}]
["Operating Interest"]
["Sch. C, E, & F Depreciation"]
["Family Living"]
["Income Taxes"]
[]
["Net Farm Inc from Operations",{"$f":"B16-B47-B50","v":0}]
["Total Net Income",{"$f":"B24-B47-B49-B50-B52-B53","v":0}]
[]
["Available for Debt Service",{"$f":"B24-B47-B50-B52-B53","v":0}]
["Annualized Debt Payments",{"$f":"'Cash Flow Schedule'!G41","v":0}]
[]
["Excess (Deficient) Cash Flow",{"$f":"IF(B58-B59=0,\"\",B58-B59)","v":""}]
["DSCR",{"$f":"IF(B59=0,\"\",B58/B59)","v":""}]
[]
["I certify that the information on the Cash Flow is true and accurate to the best of my knowledge.\n\n\n\nProfessional Signature                                                                                           Title                                                                       Date"]
[]
[]
[]
[]
[]
[]
[]
[]
["Applicant Signature                                                                                                                   Date               "]

{"sheet":"Cash Flow Schedule","index":4,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[47,0,47,8],[48,0,48,8],[0,0,0,8],[43,0,43,8],[44,0,44,8],[45,0,45,8],[46,0,46,8],[1,0,1,8]]}
["Projected Cash Flow Schedules"]
[{"$f":"'Balance Sheet'!$C$5","v":0}]
[null,null,null,"Year",{"$f":"'Projected Cash Flow'!B6","v":0}]
[]
["Crop Sales"]
["Field/Description","Acres","Yield","Total BU","Operator Share","Farm Use BU","Total BU for Sale","Price","Cash Income"]
[null,null,null,{"$f":"B7*C7","v":0},1,null,{"$f":"(D7*E7)-F7","v":0},null,{"$f":"G7*H7","v":0}]
[null,null,null,{"$f":"B8*C8","v":0},1,null,{"$f":"(D8*E8)-F8","v":0},null,{"$f":"G8*H8","v":0}]
[null,null,null,0,1,null,0,null,0]
[null,null,null,0,1,null,0,null,0]
[null,null,null,0,1,null,0,null,0]
["Total",{"$f":"SUM(B7:B11)","v":0},null,{"$f":"SUM(D7:D11)","v":0},null,null,{"$f":"SUM(G7:G11)","v":0},null,{"$f":"SUM(I7:I11)","v":0}]
[]
["Livestock Purchases/Sales"]
["Description","# Head Purchasing","Avg Weight","Purchase $/LB","Total Cost","Farm Use/Death Loss","Avg Weight","Sale $/LB","Income"]
[null,null,null,null,{"$f":"B16*C16*D16","v":0},null,null,null,{"$f":"(B16-F16)*G16*H16","v":0}]
[null,null,null,null,{"$f":"B17*C17*D17","v":0},null,null,null,{"$f":"(B17-F17)*G17*H17","v":0}]
[null,null,null,null,0,null,null,null,0]
["Total",{"$f":"SUM(B16:B18)","v":0},null,null,{"$f":"SUM(E16:E18)","v":0},{"$f":"SUM(F16:F18)","v":0},null,null,{"$f":"SUM(I16:I18)","v":0}]
[]
["Cash Rent"]
["Landlord/Description",null,null,null,null,null,"# Acres","Cash Rent Rate","Total Cash Rent (Calculated)"]
[null,null,null,null,null,null,null,null,{"$f":"G23*H23","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"G24*H24","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
["Total",null,null,null,null,null,{"$f":"SUM(G23:G26)","v":0},null,{"$f":"SUM(I23:I26)","v":0}]
[]
["Other Income"]
["Description",null,null,null,null,null,null,null,"Amount"]
[]
[]
["Total",null,null,null,null,null,null,null,{"$f":"SUM(I31:I32)","v":0}]
[]
["Proposed Debt Schedule"]
["Description",null,"Creditor/ Note #","Interest Rate","Maturity Date","Balance","Annual Payment","Interest Portion","Current Principal "]
[null,null,null,null,null,null,null,{"$f":"F37*D37","v":0},{"$f":"G37-(F37*D37)","v":0}]
[null,null,null,null,null,null,null,{"$f":"F38*D38","v":0},{"$f":"G38-(F38*D38)","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
["Total:",null,null,null,null,{"$f":"SUM(F37:F40)","v":0},{"$f":"SUM(G37:G40)","v":0},{"$f":"SUM(H37:H40)","v":0},{"$f":"SUM(I37:I40)","v":0}]
[]
["Notes"]