{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Farm Wizard","Title page","Lvstk & Crop Rpt.","Lvstk.Inv.","Land & Bldgs.","Crop Inv.","Leased prop.","Machinery","Barn Equipment","Credit Inf.","Off-farm Inc.","Balance Sheet","Income State.","Crop Prod.","Lvstk. Prod.","Proj.Inc.State.","Debt.Serv.Wkst.","Cashflow","Farm profile","Proj.Cap.Trans."],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":19,"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":"Farm Wizard","index":0,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["This is a farm business decision calculator that has 20 worksheets. There are fields that can be completed by the user. It is up to 18 columns wide and 54 rows."]
[null,null,null,null,null,null,"Publication 37"]
["Farm Financial Analysis and Planning Workbook "]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"For more information, contact:"]
[null,null,null,"Agricultural Information Contact Centre"]
[null,null,null,"ag.info.omafra@ontario.ca"]
[null,null,null,"1-877-424-1300"]

{"sheet":"Title page","index":1,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,"FARM FINANCIAL ANALYSIS"]
[null,"AND PLANNING WORKBOOK"]
[null,"Publication 37"]
[]
[]
[]
[]
[null,"Farm Information"]
[null,"Farmers Name:"]
[null,"Farm/Company Name:"]
[null,"Address"]
[null,"City/ Town"]
[]
[null,"Postal Code"]
[]
[null,"Telephone Number"]
[null,"Email Address:"]
[]
[null,"Farm Location"]
[null,"County"]
[null,"Lot:"]
[null,"Concess."]
[null,"Township:"]
[]
[null,"Last Edit:",{"$f":"NOW()","v":"2018-02-27T10:52:10.580"}]
[null,"Year Beginning ","2015-01-01"]
[null,"Year Ending","2015-12-31"]
[]
[null,"Contact Information"]
[null,"Contact Person:"]
[null,"Company/Agency:"]
[null,"Address:"]
[null,"City/Town:"]
[null,"Postal Code:"]
[null,"Telephone Number:"]
[null,"Email Address:"]

{"sheet":"Lvstk & Crop Rpt.","index":2,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"FARM LIVESTOCK AND CROP REPORT"]
[null,null,null,null,"FOR THE YEAR",{"$f":"'Title page'!C27","v":"2015-01-01"}]
[]
[null,"CROPS","Acres","Acres","Total","Yield","COMMENTS"]
[null,null,"Planted","Harvested","Yield","Per Acre"]
[null,null,null,null,null,{"$f":"IF(D6=0,\"-\",SUM(E6/D6))","v":"-"}]
[null,null,null,null,null,{"$f":"IF(D7=0,\"-\",SUM(E7/D7))","v":"-"}]
[null,null,null,null,null,"-"]
[null,null,null,null,null,"-"]
[null,null,null,null,null,"-"]
[null,null,null,null,null,"-"]
[null,null,null,null,null,"-"]
[null,null,null,null,null,{"$f":"IF(D13=0,\"-\",SUM(E13/D13))","v":"-"}]
[null,null,null,null,null,"-"]
[null,null,null,null,null,"-"]
[null,"Total",{"$f":"SUM(C6:C15)","v":0},{"$f":"SUM(D6:D15)","v":0}]
[]
[null,"LIVESTOCK"]
[]
[null,"Breeding",null,"# Animals","Total"]
[null,null,null,"Sold","Value"]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D22:D25)","v":0},{"$f":"SUM(E22:E25)","v":0}]
[]
[null,"Marketing",null,"# Animals","Total"]
[null,null,null,"Sold","Value"]
[]
[]
[]
[]
[null,"Total",null,{"$f":"SUM(D30:D33)","v":0},{"$f":"SUM(E30:E33)","v":0}]

{"sheet":"Lvstk.Inv.","index":3,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"         FARM INVENTORY"]
[null,null,null,null,"  LIVESTOCK AND POULTRY"]
[]
[null,null,null,"Beginning Inventory",null,{"$f":"'Title page'!C27","v":"2015-01-01"},null,"Ending Inventory",null,{"$f":"'Title page'!C28","v":"2015-12-31"}]
[null,"Type of Livestock",null,"#","Average","Total ",null,"#","Average","Total"]
[null," or Poultry",null,"Head","Value","Value",null,"Head","Value","Value"]
[]
[null,"BREEDING"]
[null,"Cows",null,null,null,{"$f":"D9*E9","v":0},null,null,null,{"$f":"H9*I9","v":0}]
[null,"Bred Heifers",null,null,null,0,null,null,null,0]
[null,"Open Heifers",null,null,null,0,null,null,null,0]
[null,"Calves",null,null,null,0,null,null,null,0]
[null,"Bull",null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,0,null,null,null,0]
[null,"TOTAL BREEDING",null,{"$f":"SUM(D9:D17)","v":0},null,{"$f":"SUM(F9:F17)","v":0},null,{"$f":"SUM(H9:H17)","v":0},null,{"$f":"SUM(J9:J17)","v":0}]
[]
[null,"MARKET"]
[null,"Calves",null,null,null,{"$f":"D21*E21","v":0},null,null,null,{"$f":"SUM(H21*I21)","v":0}]
[null,"Cull cows",null,null,null,{"$f":"D22*E22","v":0},null,null,null,{"$f":"SUM(H22*I22)","v":0}]
[null,null,null,null,null,{"$f":"D23*E23","v":0},null,null,null,{"$f":"SUM(H23*I23)","v":0}]
[null,null,null,null,null,{"$f":"D24*E24","v":0},null,null,null,{"$f":"SUM(H24*I24)","v":0}]
[null,null,null,null,null,{"$f":"D25*E25","v":0},null,null,null,{"$f":"SUM(H25*I25)","v":0}]
[null,"TOTAL MARKET",null,{"$f":"SUM(D21:D25)","v":0},null,{"$f":"SUM(F21:F25)","v":0},null,{"$f":"SUM(H21:H25)","v":0},null,{"$f":"SUM(J21:J25)","v":0}]
[]
[]
[null,"TOTAL LIVESTOCK",null,{"$f":"SUM(D26+D18)","v":0},null,{"$f":"SUM(F26+F18)","v":0},null,{"$f":"SUM(H26+H18)","v":0},null,{"$f":"SUM(J26+J18)","v":0}]
[]
[]
[null,"Record Dairy cows, heifers (bred, open) calves (under 6 mths. heifers, bulls)."]
[null,"Record Beef cows, heifers, bulls, feeder steers, feeder heifers."]
[null,"Hogs: sows, boars, breeding gilts, feeders, weaners, nursing."]
[null,"Sheep: goats, poultry, other livestock."]

{"sheet":"Land & Bldgs.","index":4,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"LAND AND BUILDINGS"]
[null,"FARMLAND OWNED",null,null,null,null,"Date:",{"$f":"'Title page'!C28","v":"2015-12-31"}]
[]
[null,"Parcel","Legal Description",null,null,"             Acquired",null,"                Acres",null,"Present"]
[null,"#",null,null,null,"Year","Cost","Total","Cultiv.","Mrkt.Value"]
[]
[]
[]
[]
[]
[]
[null,"Totals",null,null,null,null,null,{"$f":"SUM(H6:H11)","v":0},{"$f":"SUM(I6:I11)","v":0},{"$f":"SUM(J6:J11)","v":0}]
[]
[null,"DETAILS OF MAJOR BUILDINGS"]
[]
[null,"Parcel","Description",null,null,"              Acquired",null,"Value","Depreci-","Value"]
[null,"#",null,null,null,"Year","Cost",{"$f":"'Title page'!C27","v":"2015-01-01"},"ation",{"$f":"'Title page'!C28","v":"2015-12-31"}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(H18-I18)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(H19*5%)","v":0},0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,{"$f":"SUM(H21-I21)","v":0}]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,"Totals",null,null,null,null,{"$f":"+SUM(G19:G25)","v":0},{"$f":"+SUM(H19:H25)","v":0},{"$f":"+SUM(I19:I25)","v":0},{"$f":"+SUM(J19:J25)","v":0}]
[]
[null,"TILE DRAINAGE"]
[]
[null,"Description",null,null,null,"Date","Total",{"$f":"'Title page'!C28","v":"2015-12-31"},"Depreci-","Total"]
[null,null,null,null,null,null,"Cost","Value","ation","Pres.Value"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(H32*5%)","v":0},{"$f":"SUM(H32-I32)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(H33*5%)","v":0},{"$f":"SUM(H33-I33)","v":0}]
[null,"Totals",null,null,null,null,{"$f":"+G33+G32","v":0},{"$f":"SUM(H32:H33)","v":0},{"$f":"SUM(I32:I33)","v":0},{"$f":"SUM(J32:J33)","v":0}]
[]
[null,"QUOTA"]
[]
[null,"Description",null,null,null,"Date","Value"]
[]
[]
[]
[null,"Total",null,null,null,null,{"$f":"SUM(G39:G41)","v":0}]

{"sheet":"Crop Inv.","index":5,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"CROPS AND FARM SUPPLIES INVENTORY"]
[null,null,null,null,"Inventory of Home Grown Crops",null,null,null,"Date:",{"$f":"'Title page'!C28","v":"2015-12-31"}]
[]
[null,null,"    Beginning Inventory",null,null,{"$f":"'Title page'!C27","v":"2015-01-01"},null,"        Ending Inventory",null,null,{"$f":"'Title page'!C28","v":"2015-12-31"}]
[null,"DESCRIPTION","Quantity","Unit","Price/","Total",null,"Quantity","Unit","Price/","Total"]
[null,null,null,null,"Unit","Value",null,null,null,"Unit","Value"]
[null,null,null,null,null,{"$f":"SUM(C7*E7)","v":0},null,1,null,null,{"$f":"SUM(H7*J7)","v":0}]
[null,null,null,null,null,0,null,null,null,null,{"$f":"SUM(H8*J8)","v":0}]
[null,null,null,null,null,0,null,null,null,null,{"$f":"SUM(H9*J9)","v":0}]
[null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0]
[null,"TOTAL HOME GROWN CROPS",null,null,null,{"$f":"SUM(F7:F16)","v":0},null,null,null,null,{"$f":"SUM(K7:K16)","v":0}]
[]
[null,null,null,null,"Inventory of Purchased Feeds and Supplies"]
[]
[null,null,"       Beginning Inventory",null,null,{"$f":"'Title page'!C27","v":"2015-01-01"},null,"        Ending Inventory",null,null,{"$f":"'Title page'!C28","v":"2015-12-31"}]
[null,"DESCRIPTION","Quantity","Unit","Price/","Total",null,"Quantity","Unit","Price/","Total"]
[null,null,null,null,"Unit","Value",null,null,null,"Unit","Value"]
[null,"Complete Feed",null,null,null,{"$f":"SUM(C24*E24)","v":0},null,null,null,null,{"$f":"SUM(H24*J24)","v":0}]
[null,"Protein Supp.",null,null,null,{"$f":"SUM(C25*E25)","v":0},null,null,null,null,{"$f":"SUM(H25*J25)","v":0}]
[null,"Hay",null,null,null,0,null,null,null,null,0]
[null,"Grain",null,null,null,0,null,null,null,null,0]
[null,"Straw",null,null,null,0,null,null,null,null,0]
[null,"Seed",null,null,null,0,null,null,null,null,0]
[null,"Fertilizer",null,null,null,0,null,null,null,null,0]
[null,"Pesticides",null,null,null,0,null,null,null,null,0]
[null,"Containers & twine",null,null,null,0,null,null,null,null,0]
[null,"Fuel",null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,0]
[null,"TOTAL PURCHASED FEEDS AND SUPPLIES",null,null,null,{"$f":"SUM(F24:F37)","v":0},null,null,null,null,{"$f":"SUM(K24:K37)","v":0}]

{"sheet":"Leased prop.","index":6,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"LEASED PROPERTY"]
[]
[]
[null,"Landlord",null,"Type & Terms","Expiry","Acres","Acres","Annual"]
[null,null,null,"  of Lease","Date",null,null,"Payment"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TOTAL",{"$f":"SUM(F6:F35)","v":0},{"$f":"SUM(G6:G35)","v":0},{"$f":"SUM(H6:H35)","v":0}]

{"sheet":"Machinery","index":7,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"MACHINERY AND EQUIPMENT INVENTORY"]
[]
[null,"Description","Year of","Purchase","Deprec.","Deprec-","Present",null,"Description",null,"Year of","Purchase","Deprec.","Deprec-","Present"]
[null,null,"Purchase","Price","Value","iation","Value",null,null,null,"Purchase","Price","Value","iation","Value"]
[null,null,null,null,"Dec.31/99",null,{"$f":"'Title page'!C28","v":"2015-12-31"},null,null,null,null,null,"Dec.31/99",null,{"$f":"'Title page'!C28","v":"2015-12-31"}]
[null,null,null,null,null,{"$f":"SUM(E6*10%)","v":0},{"$f":"SUM(E6-F6)","v":0},null,null,null,null,null,null,{"$f":"SUM(M6*10%)","v":0},{"$f":"SUM(M6-N6)","v":0}]
[null,null,null,null,null,{"$f":"SUM(E7*10%)","v":0},{"$f":"SUM(E7-F7)","v":0},null,null,null,null,null,null,{"$f":"SUM(M7*10%)","v":0},{"$f":"SUM(M7-N7)","v":0}]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,null,null,null,null,null,0,0]
[null,null,null,null,null,{"$f":"SUM(E23*10%)","v":0},{"$f":"SUM(E23-F23)","v":0},null,null,null,null,null,null,0,{"$f":"SUM(M23-N23)","v":0}]
[null,null,null,null,null,0,0,null,null,null,null,null,null,{"$f":"SUM(M24*10%)","v":0},{"$f":"SUM(M24-N24)","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,"Total",null,null,{"$f":"SUM(L6:L25)","v":0},{"$f":"SUM(M6:M25)","v":0},{"$f":"SUM(N6:N25)","v":0},{"$f":"SUM(O6:O25)","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0,null,"Total Present Value",null,{"$f":"SUM(G36+O26)","v":0}]
[null,null,null,null,null,0,0,null,"This Year's Depreciation",null,{"$f":"SUM(F36+N26)","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[]
[null,"Total",null,{"$f":"SUM(D6:D34)","v":0},{"$f":"SUM(E6:E34)","v":0},{"$f":"SUM(F6:F34)","v":0},{"$f":"SUM(G6:G34)","v":0}]

{"sheet":"Barn Equipment","index":8,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"                          BARN EQUIPMENT INVENTORY"]
[]
[null,"Description",null,null,"Value","Appreciation","Depreciation","Present"]
[null,null,null,null,"Dec.31/99","$",null,"Value"]
[null,null,null,null,null,null,{"$f":"SUM(E5+F5)*10%","v":0},{"$f":"SUM(E5+F5-G5)","v":0}]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0]
[null,"Total",null,null,{"$f":"SUM(E5:E19)","v":0},{"$f":"SUM(F5:F19)","v":0},{"$f":"SUM(G5:G19)","v":0},{"$f":"SUM(H5:H19)","v":0}]

{"sheet":"Credit Inf.","index":9,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"CREDIT INFORMATION",null,null,null,"Date:",{"$f":"'Title page'!C28","v":"2015-12-31"}]
[]
[null,"ACCOUNTS RECEIVABLE"]
[null,"Owed by",null,null,null,"Year Beg.","Interest","Year End","Interest "]
[null,null,null,null,null,"Balance","Rate","Balance","Rate"]
[]
[]
[]
[]
[null,"Total Accounts Receivable",null,null,null,{"$f":"SUM(F6:F9)","v":0},null,{"$f":"SUM(H6:H9)","v":0}]
[]
[null,"ACCOUNTS PAYABLE"]
[null,"Owed to",null,null,null,"Year Beg.","Interest","Year End","Interest"]
[null,null,null,null,null,"Balance","Rate","Balance","Rate"]
[]
[]
[]
[]
[]
[null,"Total Accounts Payable",null,null,null,{"$f":"SUM(F15:F19)","v":0},null,{"$f":"SUM(H15:H19)","v":0}]
[]
[null,null,null,"LOANS, NOTES AND MORTGAGES"]
[]
[null,"OPERATING LOANS"]
[null,"Lender",null,null,null,"Purpose/Type",null,null,"Auth. Amt.","Int. Rate","Balance"]
[]
[]
[]
[null,"Total Operating Loans",null,null,null,null,null,null,{"$f":"SUM(I26:I28)","v":0},null,{"$f":"SUM(K26:K28)","v":0}]
[]
[null,"TERM LOANS"]
[null,"Lender",null,"Purpose",null,"       Original Loan",null,"Int.","Repayment","Present","   Pymt. due in 12 mths"]
[null,null,null,null,null,"Year","Amount","Rate","Period","Balance","Principal","Interest"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total Term Loans",null,null,null,null,{"$f":"SUM(G34:G42)","v":0},null,null,{"$f":"SUM(J34:J42)","v":0},{"$f":"SUM(K34:K42)","v":0},{"$f":"SUM(L34:L42)","v":0}]
[]
[null,"Loans in Arrears"]
[null,"Lender",null,"Purpose",null,null,"Time in ","Principal","Interest"]
[null,null,null,null,null,null,"Arrears","Overdue","Overdue"]
[]
[]
[]
[null,"Total Loan Arrears",null,null,null,null,null,{"$f":"SUM(K48:K52)","v":0},{"$f":"SUM(L48:L52)","v":0}]

{"sheet":"Off-farm Inc.","index":10,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"OFF FARM INCOME AND LOANS"]
[]
[null,"Off Farm Income"]
[]
[null,"APPLICANT"]
[]
[null,"Employer",null,"Type of Work",null,null,null,"Salary/Yr."]
[]
[]
[]
[]
[]
[null,"TOTAL",null,null,null,null,null,{"$f":"SUM(H8:H11)","v":0}]
[]
[]
[null,"SPOUSE"]
[]
[null,"Employer",null,"Type of Work",null,null,null,"Salary/Yr"]
[]
[]
[]
[]
[null,"TOTAL",null,null,null,null,null,{"$f":"SUM(H19:H21)","v":0}]
[]
[null,"NON-FARM LOANS"]
[]
[null,"Lender",null,"Purpose",null,null,"Present","Annual"]
[null,null,null,null,null,null,"Balance","Pymt. Due"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TOTAL",null,null,null,null,null,{"$f":"SUM(H29:H35)","v":0}]

{"sheet":"Balance Sheet","index":11,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"FARM BALANCE SHEET"]
[null,"Name:",{"$f":"'Title page'!C10","v":0},null,null,null,"As at:",null,{"$f":"'Title page'!D28","v":"00:00:00"}]
[]
[null,null,"ASSETS",null,null,null,"LIABILITIES & OWNER'S EQUITY"]
[null,null,null,"This","Previous",null,null,null,"This","Previous"]
[null,null,null,"Date","Statement",null,null,null,"Date","Statement"]
[null,"CURRENT ASSETS",null,{"$f":"'Title page'!C27","v":"2015-01-01"},"Dec.31/99",null,"CURRENT LIABILITIES",null,{"$f":"D7","v":"2015-01-01"},{"$f":"E7","v":"Dec.31/99"}]
[]
[null,"Cash on hand & in bank",null,"","",null,"Accounts Payable",null,null,{"$f":"'Credit Inf.'!F20","v":0}]
[null,"Short Term Investments",null,"","",null,"Bank Operating Loan"]
[null,"Accounts Receivable",null,{"$f":"'Credit Inf.'!H10","v":0},{"$f":"'Credit Inf.'!F10","v":0},null,"  (Incl. Bk. Overdraft)"]
[null,"Market Livestock",null,{"$f":"Lvstk.Inv.!J26","v":0},{"$f":"Lvstk.Inv.!F26","v":0},null,"Term Principal due"]
[null,"Home Grown Crops",null,{"$f":"'Crop Inv.'!K17","v":0},{"$f":"'Crop Inv.'!F17","v":0},null,"  within 12 months"]
[null,"Purchased Feed & Supplies",null,{"$f":"'Crop Inv.'!K38","v":0},{"$f":"'Crop Inv.'!F38","v":0},null,"Loan Arrears"]
[null,"Other",null,null,""]
[null,null,null,"",""]
[]
[null,"TOTAL CURRENT",null,{"$f":"SUM(D9:D17)","v":0},{"$f":"SUM(E9:E17)","v":0},null,"TOTAL CURRENT",null,{"$f":"SUM(I9:I17)","v":0},{"$f":"SUM(J9:J16)","v":0}]
[]
[null,"LONG TERM ASSETS",null,null,null,null,"TERM LIABILITIES (due over 1 year)"]
[null,"Market Quota",null,{"$f":"'Land & Bldgs.'!G42","v":0},null,null," - Term Notes, Loans, Morgages, etc."]
[null,"Breeding Livestock",null,{"$f":"Lvstk.Inv.!J18","v":0},null,null,{"$f":"'Credit Inf.'!B34","v":0},null,{"$f":"'Credit Inf.'!J34","v":0}]
[null,"Tile Drainage",null,{"$f":"'Land & Bldgs.'!J34","v":0},null,null,{"$f":"'Credit Inf.'!B35","v":0},null,{"$f":"'Credit Inf.'!J35","v":0}]
[null,"Field Machinery",null,{"$f":"Machinery!K28","v":0},null,null,{"$f":"'Credit Inf.'!B36","v":0},null,{"$f":"'Credit Inf.'!J36","v":0}]
[null,"Barn Equipment",null,{"$f":"'Barn Equipment'!H20","v":0},null,null,{"$f":"'Credit Inf.'!B37","v":0},null,{"$f":"'Credit Inf.'!J37","v":0}]
[null,"Buildings",null,{"$f":"'Land & Bldgs.'!J26","v":0},null,null,{"$f":"'Credit Inf.'!B38","v":0},null,{"$f":"'Credit Inf.'!J38","v":0}]
[null,"Land",null,{"$f":"'Land & Bldgs.'!J12","v":0},null,null,{"$f":"'Credit Inf.'!B39","v":0},null,{"$f":"'Credit Inf.'!J39","v":0}]
[null,"Other - House",null,{"$f":"'Land & Bldgs.'!J18","v":0},null,null,{"$f":"'Credit Inf.'!B40","v":0},null,{"$f":"'Credit Inf.'!J40","v":0}]
[null,null,null,null,null,null,{"$f":"'Credit Inf.'!B41","v":0},null,{"$f":"'Credit Inf.'!J41","v":0}]
[null,null,null,null,null,null,{"$f":"'Credit Inf.'!B42","v":0},null,{"$f":"'Credit Inf.'!J42","v":0}]
[]
[null,"TOTAL LONG TERM ASSETS",null,{"$f":"SUM(D21:D31)","v":0},{"$f":"SUM(E21:E31)","v":0},null,"LESS: Principal due",null,{"$f":"'Credit Inf.'!K43","v":0},{"$f":"+J13","v":0}]
[null,null,null,null,null,null,"  within 12 months"]
[null,"TOTAL ASSETS",null,{"$f":"SUM(D32+D18)","v":0},{"$f":"SUM(E32+E18)","v":0},null,"TOTAL TERM  LIABILITIES",null,{"$f":"SUM(I22:I30)-I32","v":0},{"$f":"SUM(J22:J30)-J32","v":0}]
[]
[null,"CHANGE IN EQUITY",null,null,null,null,"TOTAL LIABILITIES",null,{"$f":"SUM(I34+I18)","v":0},{"$f":"SUM(J34+J18)","v":0}]
[null,"Beginning Equity",null,{"$f":"J41","v":0}]
[null," + Net Farm Income",null,{"$f":"'Income State.'!H50","v":0}]
[null," + Owner's Contribution"]
[null," - Owner's Withdrawal"]
[null," = Ending Equity",null,{"$f":"SUM(D37+D38+D39-D40)","v":0},null,null,"OWNER'S EQUITY",null,{"$f":"SUM(D34-I36)","v":0},{"$f":"SUM(E34-J36)","v":0}]
[null,null,null,null,null,null,"TOTAL LIABILITIES"]
[null,"METHOD OF CALCULATION",null,null,null,null," & OWNER'S EQUITY",null,{"$f":"SUM(I41+I36)","v":0},{"$f":"SUM(J41+J36)","v":0}]
[null,"Crops and Livestock valued at market value."]
[null,"Buildings and Machinery at cost less depreciation."]
[null,"Land at Market Value."]

{"sheet":"Income State.","index":12,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"INCOME STATEMENT"]
[null,null,null,null,"(With Accrual Basis Adjustments)"]
[null,"Name:",{"$f":"'Title page'!C10","v":0},null,"Date:",{"$f":"'Title page'!C28","v":"2015-12-31"}]
[null,"REVENUE",null,null,null,"EXPENSES"]
[null,"Livestock","Breeding",{"$f":"'Lvstk & Crop Rpt.'!E26","v":0},null,"Livestock ","- purchases"]
[null,null,"Market",{"$f":"'Lvstk & Crop Rpt.'!E34","v":0},null,null,"- feed"]
[null,null,null,null,null,null,"- vet & med."]
[null,null,null,null,null,"Crops","- seed "]
[null,"Crops",{"$f":"'Crop Inv.'!B7","v":0},null,null,null,"- fertilizer"]
[null,null,{"$f":"'Crop Inv.'!B8","v":0},null,null,null,"- pest/herb."]
[null,null,{"$f":"'Crop Inv.'!B9","v":0},null,null,null,"- insurance"]
[null,null,{"$f":"'Crop Inv.'!B10","v":0},null,null,null," - other crop expenses"]
[null,null,{"$f":"'Crop Inv.'!B11","v":0},null,null,"Marketing/transportation"]
[null,null,{"$f":"'Crop Inv.'!B12","v":0},null,null,"Custom work, equip.rentals"]
[null,null,{"$f":"'Crop Inv.'!B13","v":0},null,null,"Hired labour"]
[null,null,{"$f":"'Crop Inv.'!B14","v":0},null,null,"Fuel, oil, (equipment)"]
[null,null,{"$f":"'Crop Inv.'!B15","v":0},null,null,"Equipment repairs"]
[null,null,{"$f":"'Crop Inv.'!B16","v":0},null,null,"Vehicle expenses"]
[null,"Custom Work",null,null,null,"Buildings, fence repairs"]
[null,"Rebates, Grants",null,null,null,"Equipment Lease"]
[null,null,null,null,null,"Electricity/telephone"]
[null,"CASH REVENUE",null,{"$f":"SUM(D5:D21)","v":0},null,"Account/office expense"]
[null,null,null,null,null,"Interest (operating)"]
[null,"ADJUSTMENTS",null,null,null,"Other variable cash costs"]
[null,"Change in Accounts Receivable"]
[null,"+ Ending Acc.Rec.",null,{"$f":"'Credit Inf.'!H10","v":0},null,"TOTAL VARIABLE CASH COSTS",null,{"$f":"SUM(H5:H25)","v":0},"B"]
[null,"- Beginning Acc. Rec.",null,{"$f":"'Credit Inf.'!F10","v":0}]
[null,"Inventory Change in Livestock",null,null,null,"ADJUSTMENTS"]
[null,"+ End. Market Lvstk.",null,{"$f":"Lvstk.Inv.!J26","v":0},null,"+ End. Accts. Payable",null,{"$f":"'Credit Inf.'!H20","v":0}]
[null,"- Begin. Market Lvstk.",null,{"$f":"Lvstk.Inv.!F26","v":0},null,"- Begin. Accts. payable",null,{"$f":"'Credit Inf.'!F20","v":0}]
[null,"+ End. Breed. Lvstk.",null,{"$f":"Lvstk.Inv.!J18","v":0},null,"TOTAL VARIABLE COSTS",null,{"$f":"SUM(H26+H29-H30)","v":0},"C"]
[null,"- Begin. Breed. Lvstk.",null,{"$f":"Lvstk.Inv.!F18","v":0},null,"Contribution Margin  (A-C)",null,{"$f":"SUM(D41-H31)","v":0}]
[null,"Inventory Change in Crops, Feeds, Supplies",null,null,null,"FIXED EXPENSES"]
[null,"+ End. Home Grown Crop",null,{"$f":"'Crop Inv.'!K17","v":0},null,"Property Taxes"]
[null,"- Begin. Home Grown Crop",null,{"$f":"'Crop Inv.'!F17","v":0},null,"Fire/Liability Ins."]
[null,"+ End. Purch. Feed & Suppl.",null,{"$f":"'Crop Inv.'!K38","v":0},null,"Lease/Rent payments"]
[null,"- Begin Purch. Feed & Suppl.",null,{"$f":"'Crop Inv.'!F38","v":0},null,"Interest (term)"]
[null,"+ Cost of Saleable ",null,null,null,"TOTAL FIXED CASH COSTS",null,{"$f":"SUM(H34:H37)","v":0},"D"]
[null,"       Products Consumed",null,null,null,"Total Overhead Expenses"]
[null,null,null,null,null,"Depreciation: Barn Equipment",null,{"$f":"'Barn Equipment'!G20","v":0}]
[null,"TOTAL  REVENUE",null,{"$f":"SUM(D22+D26-D27+D29-D30+D31-D32+D34-D35+D36-D37+D39)","v":0},"A","Depreciation: Mach/Equipment",null,{"$f":"Machinery!K29","v":0}]
[null,null,null,null,null,"Depreciation: Buildings",null,{"$f":"'Land & Bldgs.'!I26","v":0}]
[null,null,null,null,null,"Depreciation: Tile Drainage",null,{"$f":"'Land & Bldgs.'!I34","v":0}]
[null,"Total Cash Expenses",null,{"$f":"SUM(H38+H31)","v":0},null,"TOTAL FIXED NON-CASH COSTS",null,{"$f":"SUM(H40:H43)","v":0},"E"]
[]
[null,null,null,null,null,"TOTAL EXPENSES  (C+D+E)",null,{"$f":"SUM(H31+H38+H44)","v":0}]
[null,null,null,null,null,"- Personal Share of Expenses"]
[null,null,null,null,null,"TOTAL FARM EXPENSES",null,{"$f":"SUM(H46-H47)","v":0},"F"]
[]
[null,null,null,null,null,"NET FARM INCOME (A-F)",null,{"$f":"SUM(D41-H48)","v":0}]

{"sheet":"Crop Prod.","index":13,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"CROP PRODUCTION PLANS",null,null,null,"From:","Jan. 1, 2001",null,"To:","Dec. 31, 2001",null,null,"1999 Acres",{"$f":"'Land & Bldgs.'!I12+'Leased prop.'!F36","v":0}]
[]
[null,null,"            Opening Inventory",null,null,"       Projected Production",null,null,"          USES",null,null,"SALES",null,null,"Projected Ending Inventory"]
[null,"CROP",null,"Value/","TOTAL","#","Yield/","Total","Feed &","Land-","#","Value/","TOTAL","#","Value/","TOTAL"]
[null,null,"Units","Unit","VALUE","Acres","Acre","Units","Seed","Lord","Units","Unit",null,"Units","Unit"]
[null,{"$f":"'Income State.'!C9","v":0},{"$f":"'Crop Inv.'!H7","v":1},{"$f":"'Crop Inv.'!J7","v":0},{"$f":"SUM(C6*D6)","v":0},null,null,{"$f":"SUM(F6*G6)","v":0},null,null,null,null,{"$f":"SUM(K6*L6)","v":0},{"$f":"SUM(C6+H6-I6-J6-K6)","v":1},null,{"$f":"SUM(N6*O6)","v":0}]
[null,{"$f":"'Income State.'!C10","v":0},{"$f":"'Crop Inv.'!H8","v":0},{"$f":"'Crop Inv.'!J8","v":0},{"$f":"SUM(C7*D7)","v":0},null,null,{"$f":"SUM(F7*G7)","v":0},null,null,null,null,{"$f":"SUM(K7*L7)","v":0},{"$f":"SUM(C7+H7-I7-J7-K7)","v":0},null,{"$f":"SUM(N7*O7)","v":0}]
[null,{"$f":"'Income State.'!C11","v":0},{"$f":"'Crop Inv.'!H9","v":0},{"$f":"'Crop Inv.'!J9","v":0},0,null,null,0,null,null,null,null,0,{"$f":"SUM(C8+H8-I8-J8-K8)","v":0},null,{"$f":"SUM(N8*O8)","v":0}]
[null,{"$f":"'Income State.'!C12","v":0},{"$f":"'Crop Inv.'!H10","v":0},{"$f":"'Crop Inv.'!J10","v":0},0,null,null,0,null,null,null,null,0,0,null,0]
[null,{"$f":"'Income State.'!C13","v":0},{"$f":"'Crop Inv.'!H11","v":0},{"$f":"'Crop Inv.'!J11","v":0},0,null,null,0,null,null,null,null,0,0,null,0]
[null,{"$f":"'Income State.'!C14","v":0},{"$f":"'Crop Inv.'!H12","v":0},{"$f":"'Crop Inv.'!J12","v":0},0,null,null,0,null,null,null,null,0,0,null,0]
[null,{"$f":"'Income State.'!C15","v":0},{"$f":"'Crop Inv.'!H13","v":0},{"$f":"'Crop Inv.'!J13","v":0},0,null,null,0,null,null,null,null,0,0,null,0]
[null,{"$f":"'Income State.'!C16","v":0},{"$f":"'Crop Inv.'!H14","v":0},{"$f":"'Crop Inv.'!J14","v":0},0,null,null,0,null,null,null,null,0,0,null,0]
[null,{"$f":"'Income State.'!C17","v":0},{"$f":"'Crop Inv.'!H15","v":0},{"$f":"'Crop Inv.'!J15","v":0},0,null,null,0,null,null,null,null,0,0,null,0]
[null,{"$f":"'Income State.'!C18","v":0},{"$f":"'Crop Inv.'!H16","v":0},{"$f":"'Crop Inv.'!J16","v":0},0,null,null,0,null,null,null,null,0,0,null,0]
[]
[null,"TOTAL",null,null,{"$f":"SUM(E6:E15)","v":0},{"$f":"SUM(F6:F15)","v":0},null,null,null,null,null,null,{"$f":"SUM(M6:M15)","v":0},null,null,{"$f":"SUM(P6:P15)","v":0}]
[]
[null,"CROP INPUT COSTS",null,null,null,null,null,"From:",{"$f":"I1","v":"Jan. 1, 2001"},null,"To:",{"$f":"L1","v":"Dec. 31, 2001"}]
[]
[null,"CROP",null,"Acres","    Seed & Plants",null,"          Fertilizer",null,"    Pest/Herbicides",null," Other Crop Expenses",null,"             Crop Ins."]
[null,null,null,null,"$/Acre","Total","$/Acre","Total","$/Acre","Total","$/Acre","Total","$/Acre","Total"]
[null,{"$f":"B6","v":0},null,{"$f":"F6","v":0},null,{"$f":"E23*D23","v":0},null,{"$f":"G23*D23","v":0},null,{"$f":"I23*D23","v":0},null,{"$f":"D23*K23","v":0},null,{"$f":"D23*M23","v":0}]
[null,0,null,0,null,{"$f":"E24*D24","v":0},null,{"$f":"G24*D24","v":0},null,{"$f":"I24*D24","v":0},null,{"$f":"D24*K24","v":0},null,{"$f":"D24*M24","v":0}]
[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,0]
[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,0]
[null,0,null,0,null,0,null,0,null,0,null,0,null,0]
[]
[null,"TOTAL",null,{"$f":"SUM(D23:D31)","v":0},null,{"$f":"SUM(F23:F31)","v":0},null,{"$f":"SUM(H23:H31)","v":0},null,{"$f":"SUM(J23:J31)","v":0},null,{"$f":"SUM(L23:L31)","v":0},null,{"$f":"SUM(N23:N31)","v":0}]

{"sheet":"Lvstk. Prod.","index":14,"n_rows":26,"n_cols":16,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"LIVESTOCK PRODUCTION PLANS"]
[null,"Date:",null,{"$f":"'Title page'!D28","v":"00:00:00"}]
[]
[null,null," OPENING INVENTORY",null,null,null,null,null,null,null,null,null,null," PROJ. ENDING INVENTORY"]
[null,"Breeding","No.","Value/","Total","#","Transfer","      PURCHASES",null,"#","Transfer","        SALES",null,"#","Value/"]
[null,"Livestock",null,"Head",null,"Born","In","# Head","Cost","Deaths","Out","# Head","Income","Head","Head","Total"]
[null,{"$f":"Lvstk.Inv.!B9","v":"Cows"},{"$f":"Lvstk.Inv.!H9","v":0},{"$f":"Lvstk.Inv.!I9","v":0},{"$f":"C7*D7","v":0},null,null,null,null,null,null,null,null,{"$f":"C7+F7+G7+H7-J7-K7-L7","v":0},null,{"$f":"N7*O7","v":0}]
[null,{"$f":"Lvstk.Inv.!B10","v":"Bred Heifers"},{"$f":"Lvstk.Inv.!H10","v":0},{"$f":"Lvstk.Inv.!I10","v":0},{"$f":"C8*D8","v":0},null,null,null,null,null,null,null,null,{"$f":"C8+F8+G8+H8-J8-K8-L8","v":0},null,{"$f":"N8*O8","v":0}]
[null,{"$f":"Lvstk.Inv.!B11","v":"Open Heifers"},{"$f":"Lvstk.Inv.!H11","v":0},{"$f":"Lvstk.Inv.!I11","v":0},0,null,null,null,null,null,null,null,null,0,null,0]
[null,{"$f":"Lvstk.Inv.!B12","v":"Calves"},{"$f":"Lvstk.Inv.!H12","v":0},{"$f":"Lvstk.Inv.!I12","v":0},0,null,null,null,null,null,null,null,null,0,null,0]
[null,{"$f":"Lvstk.Inv.!B13","v":"Bull"},{"$f":"Lvstk.Inv.!H13","v":0},{"$f":"Lvstk.Inv.!I13","v":0},0,null,null,null,null,null,null,null,null,0,null,0]
[null,{"$f":"Lvstk.Inv.!B14","v":0},{"$f":"Lvstk.Inv.!H14","v":0},{"$f":"Lvstk.Inv.!I14","v":0},0,null,null,null,null,null,null,null,null,0,null,0]
[null,{"$f":"Lvstk.Inv.!B15","v":0},{"$f":"Lvstk.Inv.!H15","v":0},{"$f":"Lvstk.Inv.!I15","v":0},0,null,null,null,null,null,null,null,null,0,null,0]
[null,{"$f":"Lvstk.Inv.!B16","v":0},{"$f":"Lvstk.Inv.!H16","v":0},{"$f":"Lvstk.Inv.!I16","v":0},0,null,null,null,null,null,null,null,null,0,null,0]
[null,{"$f":"Lvstk.Inv.!B17","v":0},{"$f":"Lvstk.Inv.!H17","v":0},{"$f":"Lvstk.Inv.!I17","v":0},0,null,null,null,null,null,null,null,null,0,null,0]
[]
[null,"TOTAL",{"$f":"SUM(C7:C16)","v":0},null,{"$f":"SUM(E7:E16)","v":0},0,0,0,0,0,0,0,0,0,null,0]
[]
[null,"Market"]
[null,{"$f":"Lvstk.Inv.!B21","v":"Calves"},{"$f":"Lvstk.Inv.!H21","v":0},{"$f":"Lvstk.Inv.!I21","v":0},{"$f":"SUM(C20*D20)","v":0},null,null,null,null,null,null,null,null,{"$f":"C20+F20+G20+H20-J20-K20-L20","v":0},null,{"$f":"N20*O20","v":0}]
[null,{"$f":"Lvstk.Inv.!B22","v":"Cull cows"},{"$f":"Lvstk.Inv.!H22","v":0},{"$f":"Lvstk.Inv.!I22","v":0},{"$f":"SUM(C21*D21)","v":0},null,null,null,null,null,null,null,null,{"$f":"C21+F21+G21+H21-J21-K21-L21","v":0},null,{"$f":"N21*O21","v":0}]
[null,{"$f":"Lvstk.Inv.!B23","v":0},{"$f":"Lvstk.Inv.!H23","v":0},{"$f":"Lvstk.Inv.!I23","v":0},{"$f":"SUM(C22*D22)","v":0},null,null,null,null,null,null,null,null,{"$f":"C22+F22+G22+H22-J22-K22-L22","v":0},null,{"$f":"N22*O22","v":0}]
[null,{"$f":"Lvstk.Inv.!B24","v":0},{"$f":"Lvstk.Inv.!H24","v":0},{"$f":"Lvstk.Inv.!I24","v":0},{"$f":"SUM(C23*D23)","v":0},null,null,null,null,null,null,null,null,{"$f":"C23+F23+G23+H23-J23-K23-L23","v":0},null,{"$f":"N23*O23","v":0}]
[null,{"$f":"Lvstk.Inv.!B25","v":0},{"$f":"Lvstk.Inv.!H25","v":0},{"$f":"Lvstk.Inv.!I25","v":0},{"$f":"SUM(C24*D24)","v":0},null,null,null,null,null,null,null,null,{"$f":"C24+F24+G24+H24-J24-K24-L24","v":0},null,{"$f":"N24*O24","v":0}]
[]
[null,"TOTAL",{"$f":"SUM(C20:C25)","v":0},null,{"$f":"SUM(E20:E25)","v":0},0,0,0,{"$f":"SUM(I20:I25)","v":0},0,0,0,0,0,null,0]

{"sheet":"Proj.Inc.State.","index":15,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"        INCOME STATEMENT  "]
[null,null,null,"               PROJECTED"]
[null,"Year:",{"$f":"Cashflow!E3","v":"2001"},null,"Name:",null,{"$f":"'Title page'!C10","v":0}]
[null,"REVENUE",null,null,null,"EXPENSES"]
[null,"Livestock","Breeding",{"$f":"'Lvstk. Prod.'!M17","v":0},null,"Livestock ","- purchases",{"$f":"Cashflow!E23","v":0}]
[null,null,"Market",{"$f":"'Lvstk. Prod.'!M26","v":0},null,null,"- feed",{"$f":"Cashflow!E24","v":0}]
[null,null,null,null,null,null,"- vet & med.",{"$f":"Cashflow!E25","v":0}]
[null,null,null,null,null,"Crops","- seed & plants",{"$f":"Cashflow!E26","v":0}]
[null,"Crops",{"$f":"Cashflow!C6","v":0},{"$f":"Cashflow!E6","v":0},null,null,"- fertilizer",{"$f":"Cashflow!E27","v":0}]
[null,null,{"$f":"Cashflow!C7","v":0},{"$f":"Cashflow!E7","v":0},null,null,"- pest/herb.",{"$f":"Cashflow!E28","v":0}]
[null,null,{"$f":"Cashflow!C8","v":0},{"$f":"Cashflow!E8","v":0},null,null," - insurance",{"$f":"Cashflow!E29","v":0}]
[null,null,{"$f":"Cashflow!C9","v":0},{"$f":"Cashflow!E9","v":0},null,null," - other crop expenses",{"$f":"Cashflow!E30","v":0}]
[null,null,{"$f":"Cashflow!C10","v":0},{"$f":"Cashflow!E10","v":0},null,"Marketing/transportation",null,0]
[null,null,{"$f":"Cashflow!C11","v":0},{"$f":"Cashflow!E11","v":0},null,"Custom work, equip.rentals",null,{"$f":"Cashflow!E32","v":0}]
[null,null,{"$f":"Cashflow!C12","v":0},{"$f":"Cashflow!E12","v":0},null,"Hired labour",null,{"$f":"Cashflow!E33","v":0}]
[null,null,{"$f":"Cashflow!C13","v":0},{"$f":"Cashflow!E13","v":0},null,"Fuel, oil, (equipment)",null,{"$f":"Cashflow!E34","v":0}]
[null,null,{"$f":"Cashflow!C14","v":0},{"$f":"Cashflow!E14","v":0},null,"Equipment repairs",null,{"$f":"Cashflow!E35","v":0}]
[null,null,{"$f":"Cashflow!C15","v":0},{"$f":"Cashflow!E15","v":0},null,"Vehicle expenses",null,{"$f":"Cashflow!E36","v":0}]
[null,"Custom Work",null,{"$f":"Cashflow!E16","v":0},null,"Buildings, fence repairs",null,{"$f":"Cashflow!E37","v":0}]
[null,"Rebates, Grants",null,{"$f":"Cashflow!E17","v":0},null,"Equipment Lease",null,{"$f":"Cashflow!E38","v":0}]
[null,null,null,null,null,"Electricity/telephone",null,{"$f":"Cashflow!E39","v":0}]
[null,"CASH REVENUE",null,{"$f":"SUM(D5:D20)","v":0},null,"Account/office expense",null,{"$f":"Cashflow!E40","v":0}]
[null,null,null,null,null,"Interest (operating)",null,{"$f":"Cashflow!E45","v":0}]
[null,"ADJUSTMENTS",null,null,null,"Other variable cash costs",null,{"$f":"Cashflow!E44","v":0}]
[null,"Change in Accounts Receivable"]
[null,"+ Ending Acc.Rec.",null,null,null,"TOTAL VARIABLE CASH COSTS",null,{"$f":"SUM(H5:H24)","v":0},"B"]
[null,"- Beginning Acc. Rec.",null,{"$f":"'Credit Inf.'!H10","v":0}]
[null,"Inventory Change in Livestock",null,null,null,"ADJUSTMENTS"]
[null,"+ End. Market Lvstk.",null,{"$f":"SUM('Lvstk. Prod.'!P26)","v":0},null,"+ End. Accts. Payable"]
[null,"- Begin. Market Lvstk.",null,{"$f":"SUM('Lvstk. Prod.'!E26)","v":0},null,"- Begin. Accts. payable",null,{"$f":"'Credit Inf.'!H20","v":0}]
[null,"+ End. Breed. Lvstk.",null,{"$f":"SUM('Lvstk. Prod.'!P17)","v":0},null,"TOTAL VARIABLE COSTS",null,{"$f":"SUM(H26+H29-H30)","v":0},"C"]
[null,"- Begin. Breed. Lvstk.",null,{"$f":"SUM('Lvstk. Prod.'!E17)","v":0},null,"Contribution Margin  (A-C)",null,{"$f":"SUM(D41-H31)","v":0}]
[null,"Inventory Change in Crops, Feeds, Supplies",null,null,null,"FIXED EXPENSES"]
[null,"+ End. Home Grown Crop",null,{"$f":"'Crop Prod.'!P17","v":0},null,"Property Taxes",null,{"$f":"Cashflow!E42","v":0}]
[null,"- Begin. Home Grown Crop",null,{"$f":"'Crop Prod.'!E17","v":0},null,"Fire/Liability Ins.",null,{"$f":"Cashflow!E43","v":0}]
[null,"+ End. Purch. Feed & Suppl.",null,null,null,"Lease/Rent payments",null,{"$f":"Cashflow!E41","v":0}]
[null,"- Begin Purch. Feed & Suppl.",null,{"$f":"'Crop Inv.'!K38","v":0},null,"Interest (term)",null,{"$f":"Cashflow!E46","v":0}]
[null,"+ Cost of Saleable ",null,null,null,"TOTAL FIXED CASH COSTS",null,{"$f":"SUM(H34:H37)","v":0},"D"]
[null,"       Products consumed",null,null,null,"Total Overhead Expenses"]
[null,null,null,null,null,"Depreciation: Barn Equipment",null,{"$f":"'Barn Equipment'!H20*10%","v":0}]
[null,"TOTAL  REVENUE",null,{"$f":"SUM(D22+D26-D27+D29-D30+D31-D32+D34-D35+D36-D37+D39)","v":0},"A","Depreciation: Mach/Equipment",null,{"$f":"Machinery!K28*10%","v":0}]
[null,null,null,null,null,"Depreciation: Buildings",null,{"$f":"'Land & Bldgs.'!J26*5%","v":0}]
[null,null,null,null,null,"Depreciation: Tile Drainage",null,{"$f":"'Land & Bldgs.'!J34*5%","v":0},"E"]
[null,"Total Cash Expenses",null,{"$f":"H38+H26","v":0},null,"TOTAL FIXED NON-CASH COSTS",null,{"$f":"SUM(H40:H43)","v":0}]
[]
[null,null,null,null,null,"TOTAL EXPENSES  (C+D+E)",null,{"$f":"SUM(H31+H38+H44)","v":0},"F"]
[null,null,null,null,null,"- Personal Share of Expenses"]
[null,null,null,null,null,"TOTAL FARM EXPENSES",null,{"$f":"SUM(H46-H47)","v":0}]
[]
[null,null,null,null,null,"NET FARM INCOME (A-F)",null,{"$f":"SUM(D41-H48)","v":0}]

{"sheet":"Debt.Serv.Wkst.","index":16,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"DEBT SERVICING WORKSHEET"]
[null,"  ",null,null,"(When using as a projection, include new loans)"]
[]
[null,"DEBT SERVICING REQUIREMENTS",null,null,null,"Name:",{"$f":"'Title page'!C10","v":0}]
[null,"For the Period:"]
[]
[null,"CURRENT LIABILITIES",null,"Balance","Interest","        Annual Payment",null,"Balance"]
[null,null,null,"Start of Year","Rate","Interest","Principal","End of Year"]
[null,"Accounts Payable"]
[null,{"$f":"'Credit Inf.'!B15","v":0},null,{"$f":"'Credit Inf.'!H15","v":0}]
[null,{"$f":"'Credit Inf.'!B16","v":0},null,{"$f":"'Credit Inf.'!H16","v":0}]
[null,{"$f":"'Credit Inf.'!B17","v":0},null,{"$f":"'Credit Inf.'!H17","v":0}]
[null,{"$f":"'Credit Inf.'!B18","v":0},null,{"$f":"'Credit Inf.'!H18","v":0}]
[null,{"$f":"'Credit Inf.'!B19","v":0},null,{"$f":"'Credit Inf.'!H19","v":0}]
[null,"Total Accts. Payable",null,{"$f":"SUM(D10:D14)","v":0},null,{"$f":"SUM(F10:F14)","v":0},{"$f":"SUM(G10:G14)","v":0},{"$f":"SUM(H10:H14)","v":0}]
[]
[null,"Operating Loan"]
[null,{"$f":"'Credit Inf.'!B26","v":0},null,{"$f":"'Credit Inf.'!K26","v":0},{"$f":"Cashflow!C45","v":0},{"$f":"SUM(Cashflow!E45)","v":0},null,{"$f":"Cashflow!Q53","v":0}]
[null,{"$f":"'Credit Inf.'!B27","v":0},null,{"$f":"'Credit Inf.'!K27","v":0},{"$f":"'Credit Inf.'!J27","v":0}]
[]
[null,"Total Operating Loan",null,{"$f":"SUM(D18:D19)","v":0},null,{"$f":"SUM(F18:F19)","v":0},{"$f":"SUM(G18:G19)","v":0},{"$f":"SUM(H18:H19)","v":0}]
[]
[null,"TERM LIABILITIES"]
[null,{"$f":"'Credit Inf.'!B34","v":0},{"$f":"'Credit Inf.'!D34","v":0},{"$f":"'Credit Inf.'!J34","v":0},{"$f":"'Credit Inf.'!H34","v":0},{"$f":"'Credit Inf.'!L34","v":0},{"$f":"'Credit Inf.'!K34","v":0},{"$f":"SUM(D24-G24)","v":0}]
[null,{"$f":"'Credit Inf.'!B35","v":0},{"$f":"'Credit Inf.'!D35","v":0},{"$f":"'Credit Inf.'!J35","v":0},{"$f":"'Credit Inf.'!H35","v":0},{"$f":"'Credit Inf.'!L35","v":0},{"$f":"'Credit Inf.'!K35","v":0},{"$f":"SUM(D25-G25)","v":0}]
[null,{"$f":"'Credit Inf.'!B36","v":0},{"$f":"'Credit Inf.'!D36","v":0},{"$f":"'Credit Inf.'!J36","v":0},{"$f":"'Credit Inf.'!H36","v":0},{"$f":"'Credit Inf.'!L36","v":0},{"$f":"'Credit Inf.'!K36","v":0},0]
[null,{"$f":"'Credit Inf.'!B37","v":0},{"$f":"'Credit Inf.'!D37","v":0},{"$f":"'Credit Inf.'!J37","v":0},{"$f":"'Credit Inf.'!H37","v":0},{"$f":"'Credit Inf.'!L37","v":0},{"$f":"'Credit Inf.'!K37","v":0},0]
[null,{"$f":"'Credit Inf.'!B38","v":0},{"$f":"'Credit Inf.'!D38","v":0},{"$f":"'Credit Inf.'!J38","v":0},{"$f":"'Credit Inf.'!H38","v":0},{"$f":"'Credit Inf.'!L38","v":0},{"$f":"'Credit Inf.'!K38","v":0},0]
[null,{"$f":"'Credit Inf.'!B39","v":0},{"$f":"'Credit Inf.'!D39","v":0},{"$f":"'Credit Inf.'!J39","v":0},{"$f":"'Credit Inf.'!H39","v":0},{"$f":"'Credit Inf.'!L39","v":0},{"$f":"'Credit Inf.'!K39","v":0},0]
[null,{"$f":"'Credit Inf.'!B40","v":0},{"$f":"'Credit Inf.'!D40","v":0},{"$f":"'Credit Inf.'!J40","v":0},{"$f":"'Credit Inf.'!H40","v":0},{"$f":"'Credit Inf.'!L40","v":0},{"$f":"'Credit Inf.'!K40","v":0},0]
[null,{"$f":"'Credit Inf.'!B41","v":0},{"$f":"'Credit Inf.'!D41","v":0},{"$f":"'Credit Inf.'!J41","v":0},{"$f":"'Credit Inf.'!H41","v":0},{"$f":"'Credit Inf.'!L41","v":0},{"$f":"'Credit Inf.'!K41","v":0},0]
[null,{"$f":"'Credit Inf.'!B42","v":0},{"$f":"'Credit Inf.'!D42","v":0},{"$f":"'Credit Inf.'!J42","v":0},{"$f":"'Credit Inf.'!H42","v":0},{"$f":"'Credit Inf.'!L42","v":0},{"$f":"'Credit Inf.'!K42","v":0},{"$f":"SUM(D32-G32)","v":0}]
[null,{"$f":"Proj.Cap.Trans.!B34","v":0},{"$f":"Proj.Cap.Trans.!C34","v":0},{"$f":"Proj.Cap.Trans.!F13","v":0},{"$f":"Proj.Cap.Trans.!D34","v":0},{"$f":"Proj.Cap.Trans.!E34","v":0},{"$f":"Proj.Cap.Trans.!F34","v":0},{"$f":"SUM(D32-G32)","v":0}]
[]
[null,"Sub Total",null,{"$f":"SUM(D24:D33)","v":0},null,{"$f":"SUM(F24:F33)","v":0},{"$f":"SUM(G24:G33)","v":0},{"$f":"SUM(H24:H33)","v":0}]
[]
[null,"Grand Total",null,{"$f":"SUM(D35+D21)","v":0},null,{"$f":"SUM(F35+F21)","v":0},{"$f":"SUM(G35+G21)","v":0},{"$f":"SUM(H35+H21)","v":0}]
[]
[null,"Total Interest and Principal Payments",null,null,null,{"$f":"SUM(F37+G37)","v":0}]
[]
[null,"DEBT SERVICING CAPACITY"]
[]
[null,"PREVIOUS YEAR",null,null,null,"PROJECTED"]
[null," + Farm Cash Revenue",null,{"$f":"'Income State.'!D22","v":0},null," + Farm Cash Revenue",null,{"$f":"Proj.Inc.State.!D22","v":0}]
[null," - Farm Cash Expenses",null,{"$f":"'Income State.'!D44","v":0},null," - Farm Cash Expenses",null,{"$f":"Proj.Inc.State.!D44","v":0}]
[null," = Net Cash from Operation",null,{"$f":"SUM(D44-D45)","v":0},null," = Net Cash from Operation",null,{"$f":"SUM(H44-H45)","v":0}]
[null," + Interest Payments",null,{"$f":"'Income State.'!H23+H38","v":0},null," + Interest Payments",null,{"$f":"F37","v":0}]
[null," + Owner's Contributions",null,{"$f":"Cashflow!D20","v":0},null," + Owner's Contributions",null,{"$f":"Cashflow!E20","v":0}]
[null," - Owner's Withdrawals",null,{"$f":"Cashflow!D50","v":0},null," - Owner's Withdrawals",null,{"$f":"Cashflow!E50","v":0}]
[null," - Reserve for Asset",null,{"$f":"'Income State.'!H44","v":0},null," - Reserve for Asset",null,{"$f":"SUM(Proj.Inc.State.!H44)","v":0}]
[null,"     Acquisition",null,null,null,"    Acquisition"]
[]
[null," = Debt Servicing Capacity",null,{"$f":"SUM(D46+D47+D48-D49-D50)","v":0},null," = Debt Servicing Capacity",null,{"$f":"SUM(H46+H47+H48-H49-H50)","v":0}]

{"sheet":"Cashflow","index":17,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[null,"CASH FLOW STATEMENT & PROJECTION",null,null,{"$f":"'Farm profile'!D3","v":0}]
[null,null,null,"Last Year","Projected"]
[null,"CASH INFLOW","Work",{"$f":"'Title page'!C28","v":"2015-12-31"},"2001","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Total"]
[null,"Cash on Hand",null,{"$f":"'Balance Sheet'!E9","v":""},{"$f":"'Balance Sheet'!D9","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F4:Q4)","v":0}]
[null,"Livestock",null,{"$f":"SUM('Income State.'!D5+'Income State.'!D6)","v":0},{"$f":"SUM('Lvstk. Prod.'!M17+'Lvstk. Prod.'!M26)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Crop Sales",{"$f":"'Income State.'!C9","v":0},{"$f":"'Income State.'!D9","v":0},{"$f":"'Crop Prod.'!M6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"'Income State.'!C10","v":0},{"$f":"'Income State.'!D10","v":0},{"$f":"'Crop Prod.'!M7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"'Income State.'!C11","v":0},{"$f":"'Income State.'!D11","v":0},{"$f":"'Crop Prod.'!M8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"'Income State.'!C12","v":0},{"$f":"'Income State.'!D12","v":0},{"$f":"'Crop Prod.'!M9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"'Income State.'!C13","v":0},{"$f":"'Income State.'!D13","v":0},{"$f":"'Crop Prod.'!M10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F10:Q10)","v":0}]
[null,null,{"$f":"'Income State.'!C14","v":0},{"$f":"'Income State.'!D14","v":0},{"$f":"'Crop Prod.'!M11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"'Income State.'!C15","v":0},{"$f":"'Income State.'!D15","v":0},{"$f":"'Crop Prod.'!M12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"'Income State.'!C16","v":0},{"$f":"'Income State.'!D16","v":0},{"$f":"'Crop Prod.'!M13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"'Income State.'!C17","v":0},{"$f":"'Income State.'!D17","v":0},{"$f":"'Crop Prod.'!M14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"'Income State.'!C18","v":0},{"$f":"'Income State.'!D18","v":0},{"$f":"'Crop Prod.'!M15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Custom Work",null,{"$f":"'Income State.'!D19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Rebates and Grants",null,{"$f":"'Income State.'!D20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Term Borrowings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Capital Sales",null,null,{"$f":"Proj.Cap.Trans.!E13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Personal Contributions",null,{"$f":"'Balance Sheet'!D39","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL CASH INFLOW",null,{"$f":"SUM(D4:D20)","v":0},{"$f":"SUM(E4:E20)","v":0},{"$f":"SUM(F4:F20)","v":0},{"$f":"SUM(G4:G20)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"CASH OUTFLOW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Livestock - purchases",null,{"$f":"'Income State.'!H5","v":0},{"$f":"'Lvstk. Prod.'!I17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Livestock - feed",null,{"$f":"'Income State.'!H6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Vet & medicine",null,{"$f":"'Income State.'!H7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F25:Q25)","v":0}]
[null,"Seed",null,{"$f":"'Income State.'!H8","v":0},{"$f":"'Crop Prod.'!F33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Fertilizer & lime",null,{"$f":"'Income State.'!H9","v":0},{"$f":"'Crop Prod.'!H33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Herbicides/pesticides",null,{"$f":"'Income State.'!H10","v":0},{"$f":"'Crop Prod.'!J33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Crop insurance",null,{"$f":"'Income State.'!H11","v":0},{"$f":"'Crop Prod.'!N33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other Crop Expenses",null,{"$f":"'Income State.'!H12","v":0},{"$f":"'Crop Prod.'!L33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Marketing",null,{"$f":"'Income State.'!H13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Custom work",null,{"$f":"'Income State.'!H14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Hired labour",null,{"$f":"'Income State.'!H15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Fuel, oil (equipment)",null,{"$f":"'Income State.'!H16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Repairs (equipment)",null,{"$f":"'Income State.'!H17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Vehicle expenses",null,{"$f":"'Income State.'!H18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Buildings, fence repairs",null,{"$f":"'Income State.'!H19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Equipment Lease",null,{"$f":"'Income State.'!H20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Electricity/telephone",null,{"$f":"'Income State.'!H21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Acct./office expense",null,{"$f":"'Income State.'!H22","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Lease & rent",null,{"$f":"'Income State.'!H36","v":0},{"$f":"'Leased prop.'!H36","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F41:Q41)","v":0}]
[null,"Property tax",null,{"$f":"'Income State.'!H34","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Fire & liability insurance",null,{"$f":"'Income State.'!H35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Other operating exp.",null,{"$f":"'Income State.'!H24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Interest - operating",null,{"$f":"'Income State.'!H23","v":0},{"$f":"+R45","v":0},{"$f":"IF(C53<0,0,+$C$45*C53/12)","v":0},{"$f":"IF(F53<0,0,+$C$45*F53/12)","v":0},{"$f":"IF(G53<0,0,+$C$45*G53/12)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Interest - term",null,{"$f":"'Income State.'!H37","v":0},{"$f":"SUM(Debt.Serv.Wkst.!F35)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL CASH EXPENSES",null,{"$f":"SUM(D23:D46)","v":0},{"$f":"SUM(E23:E46)","v":0},{"$f":"SUM(F23:F46)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Principal Payments",null,null,{"$f":"SUM(Debt.Serv.Wkst.!G35)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Capital Purchases",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Personal Withdrawals",null,{"$f":"'Balance Sheet'!D40","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL CASH OUTFLOW",null,{"$f":"SUM(D47:D50)","v":0},{"$f":"SUM(E47:E50)","v":0},{"$f":"SUM(F47:F50)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"SURPLUS OR (DEFICIT)",null,{"$f":"SUM(D21-D51)","v":0},{"$f":"SUM(E21-E51)","v":0},{"$f":"SUM(F21-F51)","v":0},{"$f":"SUM(G21-G51)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R21-R51)","v":0}]
[null,"OPER. LOAN BALANCE",{"$f":"'Credit Inf.'!K29","v":0},null,null,{"$f":"IF(C53>0,((+C53*-1+F52)*-1),0)","v":0},{"$f":"IF(F53<0,((+F53*-1+G52)*-1),IF((F54+G52)*-1<0,0,(F54+G52)*-1))","v":0},{"$f":"IF(G53<0,((+G53*-1+H52)*-1),IF((G54+H52)*-1<0,0,(G54+H52)*-1))","v":0},{"$f":"IF(H53<0,((+H53*-1+I52)*-1),IF((H54+I52)*-1<0,0,(H54+I52)*-1))","v":0},0,0,0,0,0,0,0,0]
[null,"ENDING CASH",null,null,null,{"$f":"IF(C53>0,F52-C53,F52)","v":0},{"$f":"IF(F53>0,G52-F53,F54+G52)","v":0},{"$f":"IF(G53>0,H52-G53,G54+H52)","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"Farm profile","index":18,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"FARM PROFILE REPORT SYSTEM"]
[]
[null,"CLIENT NAME:",null,{"$f":"'Title page'!C10","v":0}]
[null,"FARM/COMPANY NAME:",null,{"$f":"'Title page'!C11","v":0},null,null,null,"COUNTY:",{"$f":"'Title page'!C21","v":0}]
[null,"TELEPHONE #:",null,{"$f":"'Title page'!C17","v":0}]
[null,"ADDRESS:",null,{"$f":"'Title page'!C12","v":0},null,null,null,"POSTAL CODE:",{"$f":"'Title page'!C15","v":0}]
[null,null,null,{"$f":"'Title page'!D14","v":0}]
[null,"HOME FARM LOCATION"]
[null,"Lot.",{"$f":"'Title page'!C22","v":0},"Conc.",{"$f":"'Title page'!C23","v":0},null,null,null,"TOWNSHIP",{"$f":"'Title page'!C24","v":0}]
[null,"Farm Type",null,null,null,1997,1998,1999,2000]
[]
[null,"Owned Acreages",null,"Total",null,null,null,null,{"$f":"'Land & Bldgs.'!H12","v":0}]
[null,null,null,"Cultivated",null,null,null,null,{"$f":"'Land & Bldgs.'!I12","v":0}]
[null,null,null,"Pasture"]
[null,null,null,"Other"]
[null,"Leased Acreages",null,"Cultivated",null,null,null,null,{"$f":"'Leased prop.'!F36","v":0}]
[null,null,null,"Other"]
[]
[null,"Farm Assets",null,"Current",null,null,null,{"$f":"'Balance Sheet'!E18","v":0},{"$f":"'Balance Sheet'!D18","v":0}]
[null,null,null,"Capital",null,null,null,{"$f":"'Balance Sheet'!E32","v":0},{"$f":"'Balance Sheet'!D32","v":0}]
[null,"Non Farm Assets"]
[]
[null,"Farm Liabilities",null,"Current",null,null,null,{"$f":"'Balance Sheet'!J18","v":0},{"$f":"'Balance Sheet'!I18","v":0}]
[null,null,null,"Term",null,null,null,{"$f":"'Balance Sheet'!J34","v":0},{"$f":"'Balance Sheet'!I34","v":0}]
[null,"Non Farm Liabilities"]
[]
[null,"Total Farm Revenue",null,null,null,null,null,null,{"$f":"'Income State.'!D41","v":0}]
[]
[null,"Total Farm Expenses",null,null,null,null,null,null,{"$f":"'Income State.'!H48","v":0}]
[]
[null,"Interest Paid (operating & term)",null,null,null,null,null,null,{"$f":"'Income State.'!H23+'Income State.'!H37","v":0}]
[]
[null,"Principal Paid",null,null,null,null,null,null,{"$f":"Cashflow!D48","v":0}]
[]
[null,"Non Farm Income (Net)",null,null,null,null,null,null,{"$f":"'Off-farm Inc.'!H13","v":0}]
[]
[null,"RESOURCE PERFORMANCE INDICATORS"]
[null," - Total Farm Assets",null,null,null,{"$f":"SUM(F19+F20)","v":0},{"$f":"SUM(G19+G20)","v":0},{"$f":"'Balance Sheet'!E34","v":0},{"$f":"'Balance Sheet'!D34","v":0}]
[null," - Total Farm Liabilities",null,null,null,{"$f":"SUM(F23+F24)","v":0},{"$f":"SUM(G23+G24)","v":0},{"$f":"'Balance Sheet'!J36","v":0},{"$f":"'Balance Sheet'!I36","v":0}]
[null," - Farm Equity",null,null,null,{"$f":"F38-F39","v":0},{"$f":"G38-G39","v":0},{"$f":"H38-H39","v":0},{"$f":"I38-I39","v":0}]
[null," - Percent Farm Equity",null,null,null,{"$f":"IF(F38=0, \"-\",F40/F38)","v":"-"},{"$f":"IF(G38=0, \"-\",G40/G38)","v":"-"},{"$f":"IF(H38=0, \"-\",H40/H38)","v":"-"},{"$f":"IF(I38=0, \"-\",I40/I38)","v":"-"}]
[]
[null,"PROFITABILITY"]
[null," - Net Farm Income",null,null,null,{"$f":"SUM(F27-F29)","v":0},{"$f":"SUM(G27-G29)","v":0},{"$f":"SUM(H27-H29)","v":0},{"$f":"SUM(I27-I29)","v":0}]
[null," - Return on Farm Equity",null,null,null,{"$f":"IF(F40=0, \"-\",F44*100/F40)","v":"-"},{"$f":"IF(G40=0, \"-\",G44*100/G40)","v":"-"},{"$f":"IF(H40=0, \"-\",H44*100/H40)","v":"-"},{"$f":"IF(I40=0, \"-\",I44*100/I40)","v":"-"}]
[]
[null,"PERFORMANCE EFFICIENCY"]
[null," - Value of Farm Production",null,null,null,{"$f":"F27","v":0},{"$f":"G27","v":0},{"$f":"H27","v":0},{"$f":"I27","v":0}]
[null," - Capital Turnover",null,null,null,{"$f":"IF(F48=0,\"-\",F38/F48)","v":"-"},{"$f":"IF(G48=0,\"-\",G38/G48)","v":"-"},{"$f":"IF(H48=0,\"-\",H38/H48)","v":"-"},{"$f":"IF(I48=0,\"-\",I38/I48)","v":"-"}]
[]
[null,"LIQUIDITY & SOLVENCY (year end)"]
[null," - Current Ratio ...:1",null,null,null,{"$f":"IF(F23=0,\"-\",F19/F23)","v":"-"},{"$f":"IF(G23=0,\"-\",G19/G23)","v":"-"},{"$f":"IF(H23=0,\"-\",H19/H23)","v":"-"},{"$f":"IF(I23=0,\"-\",I19/I23)","v":"-"}]

{"sheet":"Proj.Cap.Trans.","index":19,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,"PROJECTED CAPITAL TRANSACTIONS / MAJOR REPAIRS / TERM LOANS"]
[]
[null,"Plans for:",null,null,"to:"]
[]
[null,"Month","Item","Long Term","Long Term Asset","Net Cost"]
[null,null,null,"Asset Purchase","Sale (or Trade-in)"]
[null,null,null,null,null,{"$f":"D7-E7","v":0}]
[null,null,null,null,null,{"$f":"D8-E8","v":0}]
[null,null,null,null,null,{"$f":"D9-E9","v":0}]
[null,null,null,null,null,{"$f":"D10-E10","v":0}]
[null,null,null,null,null,{"$f":"D11-E11","v":0}]
[]
[null,"TOTAL",null,{"$f":"SUM(D7:D12)","v":0},{"$f":"SUM(E7:E12)","v":0},{"$f":"SUM(F7:F12)","v":0}]
[]
[null,"PARTIAL BUDGET"]
[]
[null,"Advantages",null,null,"Disadvantages"]
[]
[null,"Added Annual Income",null,"Added Annual Costs"]
[]
[]
[]
[]
[null,"Reduced Annual Costs",null,"Reduced Annual Income"]
[]
[]
[]
[null,"Total Advantages (A)",{"$f":"SUM(C18:C27)","v":0},"Total Disadvantages (B)",null,{"$f":"SUM(F18:F27)","v":0}]
[]
[null,"Estimated Change in Annual Farm Profits (A-B)",null,{"$f":"SUM(C28-F28)","v":0}]
[]
[]
[null,"Lender","Purpose","Interest Rate","Annual Interest","Annual Principal"]
[]
[]
[]
[null,"Explanatory Notes Concerning Farm Plan"]
[null,null,null,null,null,null,null," "]