{"text_format":"2","workbook":"xlsx","n_sheets":14,"sheets":["READ ME","List of dropdown","0 Quick Check","1 General Information","2 Equipment & Assets","3 Seasonal Crops","4 Perennial Crops","5 Livestock","6 Other Income","7 Financing","8 Fixed and Variable Costs","9 Farm Income Statement","Calculation","Crop Price Calculation Sheet"],"not_rendered":{"charts":2,"images":8,"macros":0,"external_links":0,"defined_names":164,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"READ ME","index":0,"n_rows":115,"n_cols":7,"rows_kept":115,"cut":false,"hidden":false,"merged":[[78,3,89,9],[91,3,104,9],[106,3,112,9],[114,3,114,5],[18,3,23,9],[53,6,55,9],[53,3,55,5],[44,6,46,9],[72,3,72,4],[72,5,72,9],[73,3,75,4],[73,5,74,9],[75,5,75,7],[76,3,76,4],[76,5,76,7],[68,3,68,4],[68,5,68,6],[69,3,70,4],[69,5,70,9],[71,3,71,4],[71,5,71,7],[67,3,67,9],[44,3,46,5],[47,6,49,9],[47,3,49,5],[50,6,52,9],[50,3,52,5],[60,6,61,9],[60,3,61,5],[56,3,57,5],[56,6,57,9],[40,3,41,5],[40,6,41,9],[58,3,59,5],[58,6,59,9],[42,3,43,5],[42,6,43,9],[38,3,39,5],[38,6,39,9],[10,3,10,9],[15,3,15,9],[17,3,17,9],[25,3,25,9],[35,3,35,9]]}
{"$rows_empty":10}
[null,null,null,"Read Me Sheet"]
[]
[]
[]
[]
[null,null,null,"INVEST – Farm Analysis Tool"]
[]
[null,null,null,"Introduction"]
[null,null,null,"This tool allows for assessment on farm productivity and profitability through its average annual agricultural production. The tool is useful for establishing a baseline or to assess the impact of planned investments. This tool allows a SPIS advisor (supplier, development practitioner, extension officer) to support a farm enterprise towards identify unnecessary costs, determine best value agricultural activities and correctly monetize different farm inputs. "]
[]
[]
[]
[]
[]
[]
[null,null,null,"Tips & Tricks"]
{"$rows_empty":9}
[null,null,null,"Overview"]
[null,null,null,"This tool comprises the following sheets:"]
[]
[null,null,null,"0. Quick Check",null,null,"Initial basic assessment to obtain profit/loss indication"]
[]
[null,null,null,"1. General Information",null,null,"on the farm identity, location and area"]
[]
[null,null,null,"2. Equipment & Assets",null,null,"currently available on the farm or considered for future purchase"]
[]
[null,null,null,"3. Seasonal Crops",null,null,"to add current or projected sales of seasonal crops (e.g. rice, vegetables, fodder) and by-products and the related variable expenditures"]
[]
[]
[null,null,null,"4. Perennial Crops",null,null,"to add current or projected sales of perennial crops (e.g. fruit trees) and by-products and the related variable expenditures"]
[]
[]
[null,null,null,"5. Livestock",null,null,"to add current or projected sales of livestock, poultry and by-products and the related variable expenditures"]
[]
[]
[null,null,null,"6. Other Income",null,null,"additional income not directly related to crop or livestock production such as sale of water or rental out of equipment"]
[]
[]
[null,null,null,"7. Financing",null,null,"calculates annual loan repayment based on credit information"]
[]
[null,null,null,"8. Fixed and Variable Costs",null,null,"overall regular expenditures and costs for loans"]
[]
[null,null,null,"9. Farm Income Statement",null,null,"No Entry! Summary calculation on gross profitability of the farm enterprise"]
[]
[]
[]
[]
[]
[]
[null,null,null,"About"]
[null,null,null,"Published by: ",null,"GIZ & FAO"]
[null,null,null,"Responsible:",null,"GIZ project Sustainable Energy for Food - Powering Agriculture"]
[]
[null,null,null,"Contact: ",null,"Powering.Agriculture@giz.de"]
[null,null,null,"Download link: ",null,"https://energypedia.info/wiki/Toolbox_on_SPIS"]
[null,null,null,"About: ",null,"Powering Agriculture: An Energy Grand Challenge for Development. Available at:  "]
[]
[{"$nulls":5},"https://poweringag.org"]
[null,null,null,"Version:",null,"1.2 (October 2018)"]
[]
[null,null,null,"The Toolbox on Solar Powered Irrigation Systems is made possible through the global initiative Powering Agriculture: An Energy Grand Challenge for Development (PAEGC). In 2012, the United States Agency for International Development (USAID), the Swedish International Development Cooperation Agency (Sida), the German Federal Ministry for Economic Cooperation and Development (BMZ), Duke Energy, and the Overseas Private Investment Cooperation (OPIC) combined resources to create the PAEGC initiative. The objective of PAEGC is to support new and sustainable approaches to accelerate the development and deployment of clean energy solutions for increasing agriculture productivity and/or value for farmers and agribusinesses in developing countries and emerging regions that lack access to reliable, affordable clean energy."]
{"$rows_empty":12}
[null,null,null,"The designations employed and the presentation of material in this information product do not imply the expression of any opinion whatsoever on the part of Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH, Food and Agriculture Organization of the United Nations (FAO) or any of the PAEGC Founding Partners concerning the legal or development status of any country, territory, city or area or of its authorities, or concerning the delimitation of its frontiers or boundaries. The mention of specific companies or products of manufacturers, whether or not these have been patented, does not imply that these have been endorsed or recommended by GIZ, FAO, or any of the PAEGC Founding Partners in preference to others of a similar nature that are not mentioned. The views expressed in this information product are those of the author and do not necessarily reflect the views or policies of GIZ, FAO, or any of the PAEGC Founding Partners."]
{"$rows_empty":14}
[null,null,null,"GIZ, FAO and the PAEGC Founding Partners encourage the use, reproduction and dissemination of material in this information product. Except where otherwise indicated, material may be copied, downloaded and printed for private study, research and teaching purposes, or for use in non-commercial products or services, provided that appropriate acknowledgement of GIZ and FAO as the source and copyright holder is given."]
{"$rows_empty":7}
[null,null,null,"© GIZ and FAO, 2018"]

{"sheet":"List of dropdown","index":1,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[]
["Area","CF to ha"]
["ha",1]
["Acre",2.47105]
["Sq. km",0.01]
["Sq. m",10000]
["Sq. yard",11959.9]
["Sq. ft",107639]
[]
["Conversion Factor",{"$f":"VLOOKUP('1 General Information'!D15,'List of dropdown'!A3:B8,2,FALSE)","v":2.47105}]
[]
[]
["Weight","CF to kg"]
["kg",1]
["metric ton",1000]
["quintal",100]
["pound (lb)",0.4536]
[]
["Conversion Factor",{"$f":"VLOOKUP('1 General Information'!D16,'List of dropdown'!A14:B17,2,FALSE)","v":1}]

{"sheet":"0 Quick Check","index":2,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,1,1,3],[32,1,32,3],[6,5,6,8],[33,2,33,3],[4,1,4,3],[18,1,18,3]]}
["INVEST – Farm Analysis Tool"]
[null,"0 QUICK CHECK"]
[]
[]
[null,"Annual Expenditure"]
[null,"Expenditure Type","Examples","Annual Amount"]
[null,"Seasonal crop expenses","Seedlings, pesticides, fertilisers, protection, etc",20000,null,"Calculator"]
[null,"Perennial crop expenses","Seedlings, pesticides, fertilisers, protection, etc",null,null,null,"add up:","multiply:","divide:"]
[null,"Livestock expenses","New livestock, fodder, slaughtering, veterinary services, etc",null,null,"a."]
[null,"Operation and maintenance \n- Infrastructure","Building renovations, painting, plastering, fencing, electricity, water, etc ",null,null,"b."]
[null,"Operation and maintenance\n- Fixed equipment","Water pumps, irrigation equipment, packaging equipment, milling, fuel, spare parts, repairs, etc",null,null,"c."]
[null,"Operation and maintenance \n- Movable equipment","Tractor, trucks, plough, trailer, fuel, spare parts, repairs, etc",50000,null,"d."]
[null,"Labour","Salaries, benefits, own salary (?) etc",200000,null,"e."]
[null,"Sales and distribution","Packaging, fees, advertising, etc",null,null,"Total",{"$f":"SUM(G9:G13)","v":0},{"$f":"H9*H10","v":0},{"$f":"I9/I10","v":{"$error":"#DIV/0!"}}]
[null,"Management and administration","Rent, office consumables, insurance, memberships, loan repayments, etc",300000]
[]
[null,null,null,{"$f":"SUM(D7:D16)","v":570000}]
[]
[null,"Annual Income"]
[null,"Income Type","Examples","Annual Amount"]
[null,"Seasonal crop sales","Tomatos, grain, rice, value added product, etc",500000]
[null,"By-products from seasonal crops","Compost, fodder, value added product, etc"]
[null,"Perennial crop sales","Citrus, apples, dates, berries, value added product, etc"]
[null,"By-products from perennial crops","Wood fuel, mulch, value added product, etc"]
[null,"Livestock sales","Cattle, sheep, chickens, etc"]
[null,"By-products from livestock","Manure, eggs, milk, wool, value added product, etc",500000]
[null,"Lease income","Labour, vehicles, land, etc"]
[null,"Services income","Subcontract work, maintenance service, packaging service, transport, etc"]
[]
[null,null,null,{"$f":"SUM(D21:D29)","v":1000000}]
[]
[null,null,"Profit or loss",{"$f":"D30-D17","v":430000}]
[null,{"$f":"IF(D32>0,\"You are profitable! Proceed with detailed analysis to be sure.\",(IF(D32<0,\"You are making a loss. Review your values or consider additional income opportunities business or means to reduce expenses.\",\"\")))","v":"You are profitable! Proceed with detailed analysis to be sure."}]

{"sheet":"1 General Information","index":3,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,9],[5,7,5,9],[11,2,11,7],[17,1,17,9],[18,1,18,9],[1,1,2,9],[7,2,7,9],[8,2,8,4],[10,2,10,4],[9,2,9,4],[4,2,4,4],[5,2,5,4],[4,7,4,9]]}
["INVEST – Farm Analysis Tool"]
[null,"1 GENERAL FARM INFORMATION"]
[]
[]
[null,"Country","Kenya",null,null,null,"Region","Taita "]
[null,"Farm code",1,null,null,null,"Date","2018-08-07"]
[]
[null,"Name of the farm","Mary Wanjiku's Farm"]
[null,"Village"]
[null,"Division"]
[null,"District"]
[null,"Interviewer"]
[null,"Agricultural planning period (years)",null,2018,2019,"(year in  four digits each ! )"]
[null,"Currency used for calculation",null,"KES"]
[null,"Area measurement unit",null,"acre",{"$nulls":4},"Conversion factor to 1 ha :",{"$f":"'List of dropdown'!B10","v":2.47105}]
[null,"Weight measurement unit",null,"kg",{"$nulls":4},"Conversion factor to 1 kg :",{"$f":"'List of dropdown'!B19","v":1}]
[]
[]
[null,"LAND RESOURCES"]
[]
[null,"Property rights",null,"Area"]
[null,"+ Land owned",null,null,2.5,{"$f":"+$D$15","v":"acre"},"=",null,{"$f":"+E22/$J$15","v":1.0117156674288259},"ha"]
[null,"+ Additional land as part of co-operative land",null,null,null,{"$f":"+$D$15","v":"acre"},"=",null,{"$f":"+E23/$J$15","v":0},"ha"]
[null,"+ Additional land exploited as sharegrower",null,null,null,"acre","=",null,0,"ha"]
[null,"+ Additional land leased in",null,null,null,"acre","=",null,0,"ha"]
[null," - Own land leased out",null,null,null,"acre","=",null,0,"ha"]
[null,"+ Additional land in possession of other sources",null,null,null,"acre","=",null,0,"ha"]
[null,"-  Own land unused or unusable",null,null,null,"acre","=",null,0]
[null,null,null,"Total",{"$f":"+SUM(E22:E25)-E26+E27-E28","v":2.5},"acre","=",null,1.0117156674288259,"ha"]
[]
[]
[null,"Land classification",null,"Area","rain fed","irrigated",null,null,"Total area"]
[null,"Seasonal crop land",null,null,1,null,{"$f":"+$D$15","v":"acre"},"=",{"$f":"(+E33+F33)/$J$15","v":0.40468626697153032},"ha"]
[null,"Perennials (with & without option of intercropping)",{"$nulls":4},"acre","=",{"$f":"(+E34+F34)/$J$15","v":0},"ha"]
[null,"Greenhouses",{"$nulls":4},"acre","=",{"$f":"(+E35+F35)/$J$15","v":0},"ha"]
[null,"Pastures (grazing land)",{"$nulls":4},"acre","=",{"$f":"(+E36+F36)/$J$15","v":0},"ha"]
[null,"Fallow land",null,null,1.5,null,"acre","=",{"$f":"(+E37+F37)/$J$15","v":0.60702940045729548},"ha"]
[null,null,null,"Total agricultural / horticultural land",{"$f":"+SUM(E33:E37)","v":2.5},{"$f":"+SUM(F33:F37)","v":0},"acre","=",{"$f":"IF((+$I$33+$I$34+$I$35+$I$36+$I$37)=I29,+$I$33+$I$34+$I$35+$I$36+$I$37,\"CHECK Property rights\")","v":1.0117156674288257},"ha"]

{"sheet":"2 Equipment & Assets","index":4,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,2,37,4],[5,6,8,6],[5,3,8,3],[5,2,8,2],[0,0,0,7],[1,1,1,6],[3,5,3,6],[5,1,9,1],[5,4,8,4],[5,5,8,5]]}
["INVEST – Farm Analysis Tool"]
[null,"2 EQUIPMENT & ASSETS"]
[]
[{"$nulls":4},"Farm code",{"$f":"'1 General Information'!C6","v":1}]
[]
[null,"Type\n\n","Cost of existing equipment (when originally purchased)","Salvage value (when selling existing equipment)","Age","Normal life span","Annual depreciation for replacement"]
[]
[]
[]
[null,null,{"$f":"'1 General Information'!D14","v":"KES"},{"$f":"'1 General Information'!D14","v":"KES"},"years","years",{"$f":"'1 General Information'!D14","v":"KES"}]
[null,"Storage / warehouse",250000,0,1,20,{"$f":"IFERROR(SLN(C11,D11,(F11-E11)),\"\")","v":13157.894736842105},"Indicative normal life span:","Please select"]
[null,"Cultivator / tiller",50000,0,1,7,{"$f":"IFERROR(SLN(C12,D12,(F12-E12)),\"\")","v":8333.3333333333339}]
[null,"Livestock shed",250000,0,1,20,13157.894736842105,"Livestock shed - 20 years","Livestock shed"]
[null,"Please select",{"$nulls":4},"","Garage / workshop - 20 year","Garage / workshop"]
[null,"Please select",{"$nulls":4},"","Storage / warehouse - 20 years","Storage / warehouse"]
[null,"Please select",{"$nulls":4},"","Greenhouse - 10 years","Greenhouse"]
[null,"Please select",{"$nulls":4},{"$f":"IFERROR(SLN(C17,D17,(F17-E17)),\"\")","v":""},"Other building - 20 years","Other building"]
[null,"Please select",{"$nulls":4},"","Ox cart - 7 years","Ox cart"]
[null,"Please select",{"$nulls":4},"","Truck / car - 10 years","Truck / car"]
[null,"Please select",{"$nulls":4},"","Tractor - 10 years","Tractor"]
[null,"Please select",{"$nulls":4},"","Plough - 7 years","Plough"]
[null,"Please select",{"$nulls":4},"","Cultivator / tiller - 7 years","Cultivator / tiller"]
[null,"Please select",{"$nulls":4},"","Sowing machine - 7 years","Sowing machine"]
[null,"Please select",{"$nulls":4},"","Fertilizer distributor - 7 years","Fertilizer distributor"]
[null,"Please select",{"$nulls":4},"","Sprayer - 7 years ","Sprayer"]
[null,"Please select",{"$nulls":4},"","Grass cutter  -  7 years","Grass cutter"]
[null,"Please select",{"$nulls":4},"","Baler - 7 years","Baler"]
[null,"Please select",{"$nulls":4},"","Cereal harvester - 10 years","Cereal harvester"]
[{"$nulls":6},"","Irrigation material - 5 years","Irrigation material"]
[{"$nulls":6},"","Water pump - 7 years","Water pump"]
[{"$nulls":6},"","PV generator - 20 years","PV generator"]
[{"$nulls":6},"","Well / borehole - 20 years","Well / borehole"]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[]
[null,null,"Total Annual Depreciation ",null,null,{"$f":"'1 General Information'!D14","v":"KES"},{"$f":"+SUM(G11:G36)","v":34649.122807017542}]

{"sheet":"3 Seasonal Crops","index":5,"n_rows":73,"n_cols":10,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,1,1,6],[7,1,7,6],[20,1,20,6],[62,1,62,6],[51,1,51,6],[24,1,24,6],[30,1,30,6],[36,1,36,6],[44,1,44,6],[58,1,58,6],[19,1,19,6],[3,5,3,6]]}
["INVEST – Farm Analysis Tool"]
[null,"4 SEASONAL CROP GROSS PROFIT CALCULATION"]
[]
[{"$nulls":4},"Farm code",{"$f":"'1 General Information'!C6","v":1}]
[]
[null,"Agricultural land used:",{"$f":"SUM(C10:C14)","v":1},{"$f":"'1 General Information'!D15","v":"acre"}]
[null,null,null,"Unit",{"$f":"\"Yield per \"& '1 General Information'!D15 &\" or Quantity\"","v":"Yield per acre or Quantity"},"Unit Price","Value"]
[null,"Sales"]
[null,"Crop types:","Area:"]
[null,"Tomatoes",1,"kg",20000,25,{"$f":"+F10*E10*C10","v":500000}]
[{"$nulls":6},{"$f":"+F11*E11*C11","v":0}]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[null,"By-products:"]
[{"$nulls":6},{"$f":"+F16*E16","v":0}]
[{"$nulls":6},0]
[{"$nulls":6},0]
[null,"GROSS PRODUCT",{"$nulls":4},{"$f":"SUM(G10:G18)","v":500000}]
[null,"Variable Costs"]
[null,"Seeds"]
[null,"Local seeds",null,"kg",60,100,{"$f":"+F22*E22","v":6000}]
[null,"Certified seeds",{"$nulls":4},{"$f":"+F23*E23","v":0}]
[null,null,"Sub-Total",null,null,null,{"$f":"+G23+G22","v":6000}]
[null,"Manure & Fertiliser"]
[null,"Manure",{"$nulls":4},{"$f":"+F26*E26","v":0}]
[null,"Compound fertiliser (NPK)",null,"kg",70,50,{"$f":"+F27*E27","v":3500}]
[null,"Organic fertiliser",{"$nulls":4},{"$f":"+F28*E28","v":0}]
[null,"Other",{"$nulls":4},{"$f":"+F29*E29","v":0}]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G26:G29)","v":3500}]
[null,"Plant Protection"]
[null,"Herbicides",null,"liter",150,200,{"$f":"+F32*E32","v":30000}]
[null,"Insecticides",{"$nulls":4},{"$f":"+F33*E33","v":0}]
[null,"Fungicides",{"$nulls":4},{"$f":"+F34*E34","v":0}]
[null,"Others",{"$nulls":4},{"$f":"+F35*E35","v":0}]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G32:G35)","v":30000}]
[null,"Labour (family, permanent staff and temporary staff)"]
[null,"Labour type","Number of labour type:"]
[null,"Temporary staff",2,"months",6,18000,{"$f":"+F39*E39*C39","v":216000},null,"Family member","days"]
[null,"Family member",{"$nulls":4},{"$f":"+F40*E40*C40","v":0},null,"Permanent staff","months"]
[null,"Family member",{"$nulls":4},{"$f":"+F41*E41*C41","v":0},null,"Temporary staff","years"]
[null,"Family member",{"$nulls":4},{"$f":"+F42*E42*C42","v":0}]
[null,"Family member",{"$nulls":4},0]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G39:G43)","v":216000}]
[null,"Traction and Mechanisation (own equipment and hired services)"]
[null,"Fuel Costs Machinery",null,"liter",50,79,{"$f":"+F46*E46","v":3950}]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G46:G50)","v":3950}]
[null,"Infrastructure (maintenance and expansion)"]
[null,"Maintenance and repair of machinery",null,"seasons",1,30000,{"$f":"+F53*E53","v":30000}]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G53:G57)","v":30000}]
[null,"Irrigation"]
[null,"Water fees",{"$nulls":4},{"$f":"+F60*E60","v":0}]
[null,"Fuel / energy",{"$nulls":4},{"$f":"+F61*E61","v":0}]
[null,null,"Sub-Total",null,null,null,{"$f":"+G61+G60","v":0}]
[null,"Other costs"]
[null,"Post-harvest operations",{"$nulls":4},{"$f":"E64*F64","v":0}]
[null,"Packaging materials",{"$nulls":4},{"$f":"E65*F65","v":0}]
[null,"Processing",{"$nulls":4},0]
[null,"Processing",{"$nulls":4},0]
[null,"Marketing",{"$nulls":4},0]
[null,null,"Sub-Total",null,null,null,{"$f":"SUM(G64:G68)","v":0}]
[]
[null,"TOTAL VARIABLE COSTS",{"$nulls":4},{"$f":"+G69+G62+G58+G44+G36+G30+G24+G51","v":289450}]
[]
[null,"GROSS PROFIT",{"$nulls":4},{"$f":"+G19-G71","v":210550}]

{"sheet":"4 Perennial Crops","index":6,"n_rows":75,"n_cols":10,"rows_kept":75,"cut":false,"hidden":false,"merged":[[46,1,46,6],[60,1,60,6],[64,1,64,6],[53,1,53,6],[38,1,38,6],[32,1,32,6],[0,0,0,6],[1,1,1,6],[7,1,7,6],[20,1,20,6],[26,1,26,6],[19,1,19,6],[3,5,3,6]]}
["INVEST – Farm Analysis Tool"]
[null,"5 PERENNIAL CROP GROSS PROFIT CALCULATION"]
[]
[{"$nulls":4},"Farm code",{"$f":"'1 General Information'!C6","v":1}]
[]
[null,"Agricultural land used:",{"$f":"SUM(C10:C14)","v":0},{"$f":"'1 General Information'!D15","v":"acre"}]
[null,null,null,"Unit",{"$f":"\"Yield per \"& '1 General Information'!D15 &\" or Quantity\"","v":"Yield per acre or Quantity"},"Unit Price","Value"]
[null,"Sales"]
[null,"Crop types:","Area:"]
[{"$nulls":6},{"$f":"+F10*E10*C10","v":0}]
[{"$nulls":6},{"$f":"+F11*E11*C11","v":0}]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[null,"By-products:"]
[{"$nulls":6},{"$f":"+F16*E16","v":0}]
[{"$nulls":6},{"$f":"+F17*E17","v":0}]
[{"$nulls":6},0]
[null,"GROSS PRODUCT",{"$nulls":4},{"$f":"SUM(G10:G18)","v":0}]
[null,"Variable Costs"]
[null,"Seedlings"]
[null,"Local Seedlings",{"$nulls":4},{"$f":"+F22*E22","v":0}]
[null,"Nursery Seedlings",{"$nulls":4},{"$f":"+F23*E23","v":0}]
[null,"Other establishment cost (juvenile phase)",{"$nulls":4},{"$f":"F24","v":0}]
[{"$nulls":6},{"$f":"F25","v":0}]
[null,null,"Sub-Total",null,null,null,{"$f":"SUM(G22:G25)","v":0}]
[null,"Manure & Fertiliser"]
[null,"Manure",{"$nulls":4},{"$f":"+F28*E28","v":0}]
[null,"Compound fertiliser (NPK)",{"$nulls":4},{"$f":"+F29*E29","v":0}]
[null,"Organic fertiliser",{"$nulls":4},{"$f":"+F30*E30","v":0}]
[null,"Other",{"$nulls":4},{"$f":"+F31*E31","v":0}]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G28:G31)","v":0}]
[null,"Plant Protection"]
[null,"Herbicides",null,"kg or litres",null,null,{"$f":"+F34*E34","v":0}]
[null,"Insecticides",null,"kg or litres",null,null,{"$f":"+F35*E35","v":0}]
[null,"Fungicides",null,"kg or litres",null,null,{"$f":"+F36*E36","v":0}]
[null,"Others",null,"kg or litres",null,null,{"$f":"+F37*E37","v":0}]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G34:G37)","v":0}]
[null,"Labour (family, permanent staff and temporary staff)"]
[null,"Labour type","Number of labour type:"]
[null,"Family member",0,"months",0,0,{"$f":"+F41*E41*C41","v":0},null,"Family member","days"]
[null,"Family member",0,"months",0,null,{"$f":"+F42*E42*C42","v":0},null,"Permanent staff","months"]
[null,"Family member",null,"months",null,null,{"$f":"+F43*E43*C43","v":0},null,"Temporary staff","years"]
[null,"Family member",null,"months",null,null,{"$f":"+F44*E44*C44","v":0}]
[null,"Family member",null,"months",null,null,{"$f":"+F45*E45*C45","v":0}]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G41:G45)","v":0}]
[null,"Traction and Mechanisation (own equipment and hired services)"]
[{"$nulls":6},{"$f":"+F48*E48","v":0}]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G48:G52)","v":0}]
[null,"Infrastructure (maintenance and expansion)"]
[null,"Fence repairs",{"$nulls":4},{"$f":"+F55*E55","v":0}]
[null,"Irrigation system repair",{"$nulls":4},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G55:G59)","v":0}]
[null,"Irrigation"]
[null,"Water fees",{"$nulls":4},{"$f":"+F62*E62","v":0}]
[null,"Fuel / energy",{"$nulls":4},{"$f":"+F63*E63","v":0}]
[null,null,"Sub-Total",null,null,null,{"$f":"+G63+G62","v":0}]
[null,"Other costs"]
[null,"Post-harvest operations",{"$nulls":4},{"$f":"E66*F66","v":0}]
[null,"Packaging materials",{"$nulls":4},{"$f":"E67*F67","v":0}]
[null,"Processing",{"$nulls":4},0]
[null,"Marketing",{"$nulls":4},0]
[{"$nulls":6},0]
[null,null,"Sub-Total",null,null,null,{"$f":"SUM(G66:G70)","v":0}]
[]
[null,"TOTAL VARIABLE COSTS",{"$nulls":4},{"$f":"+G71+G64+G60+G46+G38+G32+G26+G53","v":0}]
[]
[null,"GROSS PROFIT",{"$nulls":4},{"$f":"+G19-G73","v":0}]

{"sheet":"5 Livestock","index":7,"n_rows":84,"n_cols":15,"rows_kept":84,"cut":false,"hidden":false,"merged":[[24,10,24,14],[26,10,26,12],[27,10,27,12],[28,10,28,12],[29,10,30,14],[53,1,53,6],[67,1,67,6],[71,1,71,6],[60,1,60,6],[45,1,45,6],[0,0,0,6],[1,1,1,6],[30,1,30,6],[39,1,39,6],[3,5,3,6],[7,1,7,2],[7,3,7,6],[5,3,5,4]]}
["INVEST – Farm Analysis Tool"]
[null,"6 LIVESTOCK GROSS PROFIT CALCULATION"]
[]
[{"$nulls":4},"Farm code",{"$f":"'1 General Information'!C6","v":1}]
[]
[null,"Livestock for production:",{"$f":"SUM(C10:C23)","v":3},"Livestock sold:",null,{"$f":"SUM(E10:E23)","v":0},"head"]
[null,null,"Quantity","Unit","Quantity","Unit Price","Value"]
[null,"For Production",null,"For Sale"]
[null,"Livestock type"]
[null,"Dairy cows",3,"head",null,null,{"$f":"+F10*E10","v":0}]
[null,"Heifers",null,"head",null,null,{"$f":"+F11*E11","v":0}]
[null,"Adult steers",null,"head",null,null,0]
[null,"Juvenile steers",null,"head",null,null,0]
[null,"Calfs",null,"head",null,null,0]
[null,"Sheep does",null,"head",null,null,0]
[null,"Sheep bucks",null,"head",null,null,0]
[null,"Sheep kids",null,"head",null,null,0]
[null,"Goat does",null,"head",null,null,0]
[null,"Goat bucks",null,"head",null,null,0]
[null,"Goat kids",null,"head",null,null,0]
[null,"Chickens",null,"head",null,null,0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[null,"By-products:"]
[null,"Milk",null,"litres",9000,50,{"$f":"+F25*E25","v":450000},null,null,null,"By-product calculator"]
[null,"Eggs",{"$nulls":4},{"$f":"+F26*E26","v":0}]
[null,"Skins",{"$nulls":4},{"$f":"+F27*E27","v":0},null,null,null,"Daily milk yield:",null,null,10,{"$f":"IF(K27=\"Daily milk yield:\",\"litres/day\",\"eggs/day\")","v":"litres/day"}]
[null,"Manure",{"$nulls":4},{"$f":"+F28*E28","v":0},null,null,null,"Number of dairy livestock:",null,null,3,"head"]
[{"$nulls":6},0,null,null,null,"Days of milking per year:",null,null,300,"days/year"]
[null,"GROSS PRODUCT",{"$nulls":4},{"$f":"SUM(G10:G29)","v":450000},null,null,null,"Note: milking (lactation) periods typically range between 209 and 305 days per year for dairy livestock"]
[null,"Fodder & Fodder Concentrates"]
[null,"Regular base fodder",{"$nulls":4},{"$f":"+F32*E32","v":0},null,null,null,"Total",null,null,{"$f":"N27*N28*N29","v":9000},{"$f":"IF(K27=\"Daily milk yield:\",\"litres/year\",\"eggs/year\")","v":"litres/year"}]
[null,"Special fodder",{"$nulls":4},{"$f":"+F33*E33","v":0}]
[null,"Composed concentrates",{"$nulls":4},0]
[null,"Husks",{"$nulls":4},0]
[null,"Sunflower oil cakes",{"$nulls":4},0]
[null,"Grains",{"$nulls":4},0]
[null,"Milk powder",{"$nulls":4},0]
[null,null,"Sub-Total",null,null,null,{"$f":"SUM(G32:G38)","v":0}]
[null,"Veterinary Services"]
[null,"Vaccination",null,{"$f":"'1 General Information'!$D$14","v":"KES"},null,null,{"$f":"+F41*E41","v":0}]
[null,"Inspections",null,{"$f":"'1 General Information'!$D$14","v":"KES"},null,null,{"$f":"+F42*E42","v":0}]
[null,null,null,{"$f":"'1 General Information'!$D$14","v":"KES"},null,null,{"$f":"+F43*E43","v":0}]
[null,null,null,{"$f":"'1 General Information'!$D$14","v":"KES"},null,null,{"$f":"+F44*E44","v":0}]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G41:G44)","v":0}]
[null,"Labour (family, permanent staff and temporary staff)"]
[null,"Labour type","Number of labour type:"]
[null,"Family member",null,"months",null,null,{"$f":"+F48*E48*C48","v":0},null,"Family member","days"]
[null,"Family member",null,"months",null,null,{"$f":"+F49*E49*C49","v":0},null,"Permanent staff","months"]
[null,"Family member",null,"months",null,null,{"$f":"+F50*E50*C50","v":0},null,"Temporary staff","years"]
[null,"Family member",null,"months",null,null,{"$f":"+F51*E51*C51","v":0}]
[null,"Family member",null,"months",null,null,{"$f":"+F52*E52*C52","v":0}]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G48:G52)","v":0}]
[null,"Traction and Mechanisation (own equipment and hired services)"]
[null,"Ploughing / tillage",{"$nulls":4},{"$f":"+F55*E55","v":0}]
[null,"Transport",{"$nulls":4},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G55:G59)","v":0}]
[null,"Infrastructure (maintenance and expansion)"]
[null,"Fence repair",null,{"$f":"'1 General Information'!$D$14","v":"KES"},null,null,{"$f":"+F62*E62","v":0}]
[null,"New shed",null,{"$f":"'1 General Information'!$D$14","v":"KES"},null,null,0]
[null,null,null,{"$f":"'1 General Information'!$D$14","v":"KES"},null,null,0]
[null,null,null,{"$f":"'1 General Information'!$D$14","v":"KES"},null,null,0]
[null,null,null,{"$f":"'1 General Information'!$D$14","v":"KES"},null,null,0]
[null,null,"Sub-Total",null,null,null,{"$f":"+SUM(G62:G66)","v":0}]
[null,"Water supply"]
[null,"Water fees",{"$nulls":4},{"$f":"+F69*E69","v":0}]
[null,"Fuel / energie",{"$nulls":4},{"$f":"+F70*E70","v":0}]
[null,null,"Sub-Total",null,null,null,{"$f":"+G70+G69","v":0}]
[null,"Other costs"]
[null,"Cooling services",null,{"$f":"'1 General Information'!$D$14","v":"KES"},null,null,{"$f":"E73*F73","v":0}]
[null,"Abattoir services",null,{"$f":"'1 General Information'!$D$14","v":"KES"},null,null,{"$f":"E74*F74","v":0}]
[null,"Packaging materials",null,{"$f":"'1 General Information'!$D$14","v":"KES"},null,null,0]
[null,"Pasture leasing",null,{"$f":"'1 General Information'!$D$14","v":"KES"},null,null,0]
[null,"Processing",null,{"$f":"'1 General Information'!$D$14","v":"KES"},null,null,0]
[null,"Marketing",null,{"$f":"'1 General Information'!$D$14","v":"KES"},null,null,0]
[null,null,null,{"$f":"'1 General Information'!$D$14","v":"KES"},null,null,{"$f":"E79*F79","v":0}]
[null,null,"Sub-Total",null,null,null,{"$f":"SUM(G73:G79)","v":0}]
[]
[null,"TOTAL VARIABLE COSTS",{"$nulls":4},{"$f":"+G80+G71+G67+G53+G60+G45+G39","v":0}]
[]
[null,"GROSS PROFIT",{"$nulls":4},{"$f":"+G30-G82","v":450000}]

{"sheet":"6 Other Income","index":8,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,1,1,14],[3,12,3,13]]}
["INVEST – Farm Analysis Tool"]
[null,"4 OTHER INCOME"]
[]
[{"$nulls":11},"Farm code",{"$f":"'1 General Information'!C6","v":1}]
[]
[null,"Month","January","February","March","April","May","June","July","August","September","October","November","December","Total"]
[null,"Type of OTHER INCOME",1,2,3,4,5,6,7,8,9,10,11,12]
[null,"Sale of water",{"$nulls":12},{"$f":"+SUM(C8:N8)","v":0}]
[null,"Hire out of equipment",{"$nulls":12},{"$f":"+SUM(C9:N9)","v":0}]
[null,"Lease out storage space",{"$nulls":12},0]
[null,"Lease out land",{"$nulls":12},0]
[null,"Lease out labour",{"$nulls":12},0]
[{"$nulls":14},{"$f":"+SUM(C13:N13)","v":0}]
[{"$nulls":14},0]
[null,"TOTAL OTHER INCOME per month",{"$f":"+SUM(C8:C14)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"7 Financing","index":9,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,13],[1,0,1,13],[2,8,5,8],[3,0,5,0],[3,1,5,1],[3,2,5,2],[3,3,5,3],[3,4,5,4],[3,5,5,5],[3,6,5,6],[3,9,4,13]]}
["INVEST – Farm Analysis Tool"]
["CREDIT AND FINANCING (simplified calculator, to be confirmed with loan provider)"]
[{"$nulls":8},"Enter manually:"]
["Bank name","Loan amount","Credit period (years)","Month of taking credit","Year of taking credit","Annual interest rate","Monthly loan repayment",null,null,"Note: the calculator value will take precedence to the manual value. Ensure calculator value is 0 in order to use manual value."]
[{"$nulls":7},"OR"]
[]
["Alpha Bank",600000,3,1,2018,0.16,{"$f":"IF(D7,-PMT(F7/12,C7*12,B7),\"0\")","v":21094.219821810057}]
[{"$nulls":6},{"$f":"IF(D8,-PMT(F8/12,C8*12,B8),\"0\")","v":"0"}]
[{"$nulls":6},{"$f":"IF(D9,-PMT(F9/12,C9*12,B9),\"0\")","v":"0"}]
[{"$nulls":6},"0"]
[{"$nulls":6},"0"]
[{"$nulls":6},"0"]
[{"$nulls":6},"0"]
["TOTAL CREDIT",{"$f":"SUM(B7:B13)","v":600000},{"$nulls":4},{"$f":"SUM(G7:G13)","v":21094.219821810057},null,{"$f":"SUM(I7:I13)","v":0}]
[null,null,null,"Total Annual Loan Repayments",null,null,{"$f":"G14*12","v":253130.63786172069},null,{"$f":"I14*12","v":0}]

{"sheet":"8 Fixed and Variable Costs","index":10,"n_rows":54,"n_cols":15,"rows_kept":54,"cut":false,"hidden":false,"merged":[[53,1,53,13],[48,1,48,13],[49,1,49,13],[50,1,50,13],[51,1,51,13],[52,1,52,13],[44,1,44,13],[36,1,36,13],[45,1,45,13],[46,1,46,13],[47,1,47,13],[39,1,39,13],[40,1,40,13],[41,1,41,13],[42,1,42,13],[43,1,43,13],[33,1,33,13],[34,1,34,13],[35,1,35,13],[37,1,37,13],[38,1,38,13],[28,1,28,13],[29,1,29,13],[30,1,30,13],[31,1,31,13],[32,1,32,13],[5,1,6,1],[26,1,26,14],[17,1,17,14],[27,1,27,13],[0,0,0,14],[3,12,3,13],[1,1,1,14],[2,1,4,3]]}
["INVEST – Farm Analysis Tool"]
[null,"4 COSTS (FIXED and VARIABLE)"]
[null,"Note:  Please add all general costs. Specific costs for seasonal crops, perennial crops and livestock were already calculated from the previous input sheets and listed below."]
[{"$nulls":11},"Farm code",{"$f":"'1 General Information'!C6","v":1}]
[]
[null,"Month","January","February","March","April","May","June","July","August","September","October","November","December","Total"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,"FIXED COSTS"]
[null,"Membership fees ",{"$nulls":12},{"$f":"+SUM(D9:N9)","v":0}]
[null,"Insurance costs",{"$nulls":12},{"$f":"+SUM(C10:N10)","v":0}]
[null,"Land tax",4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,48000]
[null,"Social fund contribution",1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,12000]
[null,"Leasing fees for equipment",{"$nulls":12},0]
[null,"Rental costs for land",{"$nulls":12},{"$f":"+SUM(C14:N14)","v":0}]
[null,"Other fixed costs",{"$nulls":12},0]
[null,"TOTAL FIXED COSTS per month",{"$f":"+SUM(C9:C15)","v":5000},{"$f":"+SUM(D9:D15)","v":5000},5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,60000]
[]
[null,"GENERAL VARIABLE COSTS"]
[null,"Maintenance & repair",{"$nulls":12},0]
[null,"General fuel & lubricants ",{"$nulls":12},0]
[null,"Water, electricity, gas supply",{"$nulls":12},0]
[null,"Regular transport fees ",{"$nulls":12},0]
[null,"Regular staff salary costs",{"$nulls":12},0]
[null,"Other variable costs",{"$nulls":12},{"$f":"+SUM(C24:N24)","v":0}]
[null,"GENERAL VARIABLE COSTS per month",{"$f":"+SUM(C19:C24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"SPECIFIC VARIABLE COSTS (as per Seasonal Crops, Perennial Crops and Livestock Sheets)"]
[null,"Seasonal Crops",{"$nulls":12},{"$f":"+SUM(O29:O36)","v":289450}]
[null,"Seeds",{"$nulls":12},{"$f":"'3 Seasonal Crops'!G24","v":6000}]
[null,"Manure and Fertilizer",{"$nulls":12},{"$f":"'3 Seasonal Crops'!G30","v":3500}]
[null,"Plant Protection",{"$nulls":12},{"$f":"'3 Seasonal Crops'!G36","v":30000}]
[null,"Labour",{"$nulls":12},{"$f":"'3 Seasonal Crops'!G44","v":216000}]
[null,"Traction & Mechanisation",{"$nulls":12},{"$f":"'3 Seasonal Crops'!G51","v":3950}]
[null,"Infrastructure",{"$nulls":12},{"$f":"'3 Seasonal Crops'!G58","v":30000}]
[null,"Irrigation",{"$nulls":12},{"$f":"'3 Seasonal Crops'!G62","v":0}]
[null,"Other costs",{"$nulls":12},{"$f":"'3 Seasonal Crops'!G69","v":0}]
[null,"Perennial Crops",{"$nulls":12},{"$f":"+SUM(O38:O45)","v":0}]
[null,"Seedlings",{"$nulls":12},{"$f":"'4 Perennial Crops'!G26","v":0}]
[null,"Manure and Fertilizer",{"$nulls":12},{"$f":"'4 Perennial Crops'!G32","v":0}]
[null,"Plant Protection",{"$nulls":12},{"$f":"'4 Perennial Crops'!G38","v":0}]
[null,"Labour",{"$nulls":12},{"$f":"'4 Perennial Crops'!G46","v":0}]
[null,"Traction & Mechanisation",{"$nulls":12},{"$f":"'4 Perennial Crops'!G53","v":0}]
[null,"Infrastructure",{"$nulls":12},{"$f":"'4 Perennial Crops'!G60","v":0}]
[null,"Irrigation",{"$nulls":12},{"$f":"'4 Perennial Crops'!G64","v":0}]
[null,"Other costs",{"$nulls":12},{"$f":"'4 Perennial Crops'!G71","v":0}]
[null,"Livestock",{"$nulls":12},{"$f":"+SUM(O47:O53)","v":0}]
[null,"Fodder",{"$nulls":12},{"$f":"'5 Livestock'!G39","v":0}]
[null,"Veterinary Services",{"$nulls":12},{"$f":"'5 Livestock'!G45","v":0}]
[null,"Labour",{"$nulls":12},{"$f":"'5 Livestock'!G53","v":0}]
[null,"Traction & Mechanisation",{"$nulls":12},{"$f":"'5 Livestock'!G60","v":0}]
[null,"Infrastructure",{"$nulls":12},{"$f":"'5 Livestock'!G67","v":0}]
[null,"Water supply",{"$nulls":12},{"$f":"'5 Livestock'!G71","v":0}]
[null,"Other Costs",{"$nulls":12},{"$f":"'5 Livestock'!G80","v":0}]
[null,"SPECIFIC VARIABLE COSTS per month",{"$nulls":12},{"$f":"+SUM(O28,O46,O37)","v":289450}]

{"sheet":"9 Farm Income Statement","index":11,"n_rows":65,"n_cols":10,"rows_kept":65,"cut":false,"hidden":false,"merged":[[64,3,64,7],[1,1,1,8],[3,6,3,7],[0,0,0,8],[58,3,58,5],[60,3,60,4],[61,3,61,4],[62,3,62,4],[63,3,63,4],[60,5,60,6],[61,5,61,6],[62,5,62,6],[63,5,63,6]]}
["INVEST – Farm Analysis Tool"]
[null,"8 FARM INCOME STATEMENT"]
[]
[{"$nulls":5},"Farm code",{"$f":"'1 General Information'!C6","v":1}]
[]
[null,null,"+","Gross value of seasonal crop production",{"$f":"Calculation!D9","v":500000},{"$f":"'1 General Information'!$D$14","v":"KES"},"+",{"$f":"IF($E$16=0,0,(+E6/$E$16)*(1-$E$14))","v":0.52631578947368418}]
[null,null,"+","Gross value of seasonal crop by-product production",{"$f":"Calculation!E9","v":0},{"$f":"'1 General Information'!$D$14","v":"KES"},"+",{"$f":"IF($E$16=0,0,(+E7/$E$16)*(1-$E$14))","v":0}]
[null,null,"+","Gross value of perennial crop production",{"$f":"Calculation!D10","v":0},{"$f":"'1 General Information'!$D$14","v":"KES"},"+",0]
[null,null,"+","Gross value of perennial crop by-product production",{"$f":"Calculation!E10","v":0},{"$f":"'1 General Information'!$D$14","v":"KES"},"+",0]
[null,null,"+","Gross value of livestock production: ",{"$f":"Calculation!D11","v":0},{"$f":"'1 General Information'!$D$14","v":"KES"},"+",0]
[null,null,"+","Gross value of livestock by-product production: ",{"$f":"Calculation!E11","v":450000},{"$f":"'1 General Information'!$D$14","v":"KES"},"+",0.47368421052631576]
[null,null,"+","Gross value of other income: ",{"$f":"'6 Other Income'!O15","v":0},{"$f":"'1 General Information'!$D$14","v":"KES"},"+",0]
[]
[null,null,"-","Anticipated losses of total sales (reduction factor)",0.1,"%"]
[]
[null,null,"=","GROSS FARM INCOME",{"$f":"SUM(E6:E12)-(SUM(E6:E12)*E14)","v":855000},{"$f":"'1 General Information'!$D$14","v":"KES"},"=",{"$f":"SUM(H6:H12)","v":1}]
[]
[]
[null,null,"-","Total fixed costs",{"$f":"'8 Fixed and Variable Costs'!O16+'7 Financing'!G14*12","v":313130.63786172069},{"$f":"'1 General Information'!$D$14","v":"KES"},"+",{"$f":"IF($E$22=0,0,+E19/$E$22)","v":0.49139361842282281}]
[null,null,"-","Total general variable costs (for regular expenses)",{"$f":"'8 Fixed and Variable Costs'!O25+'2 Equipment & Assets'!G38","v":34649.122807017542},{"$f":"'1 General Information'!$D$14","v":"KES"},"+",{"$f":"IF($E$22=0,0,+E20/$E$22)","v":5.4374614849524848E-2}]
[null,null,"-","Total specific variable costs for crop and livestock ",{"$f":"'8 Fixed and Variable Costs'!O54","v":289450},{"$f":"'1 General Information'!$D$14","v":"KES"},"+",{"$f":"IF($E$22=0,0,+E21/$E$22)","v":0.45423176672765225}]
[null,null,"=","TOTAL COST",{"$f":"SUM(E19:E21)","v":637229.76066873828},{"$f":"'1 General Information'!$D$14","v":"KES"},"=",{"$f":"SUM(H19:H21)","v":1}]
{"$rows_empty":35}
[null,null,"=","GROSS FARM PROFIT",{"$f":"\"For period \"  &   '1 General Information'!D13","v":"For period 2018"},{"$f":"\"to \" & '1 General Information'!E13","v":"to 2019"},{"$f":"E16-E22","v":217770.23933126172},{"$f":"'1 General Information'!$D$14","v":"KES"}]
[null,null,null,"Farm Profit Margin ",null,null,{"$f":"(E16-E22)/E16","v":0.25470203430556926}]
[]
[null,null,null,{"$f":"\"average profit per \"&'1 General Information'!$D$15&\" of seasonal crops:\"","v":"average profit per acre of seasonal crops:"},null,{"$f":"IFERROR(Calculation!R9/Calculation!C9,\"no crops\")","v":210550},null,{"$f":"'1 General Information'!$D$14&\" per\"&\" \"&'1 General Information'!$D$15","v":"KES per acre"}]
[null,null,null,{"$f":"\"average profit per \"&'1 General Information'!D15&\" of perennial crops:\"","v":"average profit per acre of perennial crops:"},null,{"$f":"IFERROR(Calculation!R10/Calculation!C10,\"no crops\")","v":"no crops"},null,{"$f":"'1 General Information'!$D$14&\" per\"&\" \"&'1 General Information'!$D$15","v":"KES per acre"}]
[null,null,null,"average profit per head of livestock:",null,{"$f":"IFERROR((Calculation!R11/'5 Livestock'!C6+'5 Livestock'!F6),\"no livestock\")","v":150000},null,{"$f":"'1 General Information'!$D$14&\" per head\"","v":"KES per head"}]
[null,null,null,"total crop area under cultivation:",null,{"$f":"Calculation!C9+Calculation!C10","v":1},null,{"$f":"'1 General Information'!D15","v":"acre"},null,{"$f":"(SUM('1 General Information'!I33:I37))-F64","v":1.1715667428825682E-2}]
[null,null,null,{"$f":" IF(J64<0,\"Cultivated area does not match available crop area (1. General Information)\",\"\")","v":""}]

{"sheet":"Calculation","index":12,"n_rows":17,"n_cols":19,"rows_kept":17,"cut":false,"hidden":true,"merged":[[1,1,1,18],[0,1,0,18],[3,2,3,5],[5,1,7,1],[6,2,7,2],[6,18,7,18]]}
[null,"DESIGN – Farm Analysis Tool"]
[null,"7 SUMMARY OF GROSS MARGINS"]
[]
[null,"Farm code",{"$f":"'1 General Information'!C6","v":1}]
[]
[null,"Farm Enterprise","Area cultivated / Livestock for production","Gross Main Product from sale","Gross \nBy-product","Gross Product","Seeds / Seedlings / Establishment","Fodder / Fodder Concentrates","Manure / Fertiliser","Veterinary Services","Plant Protection","Labour","Traction / Mechanisation","Infrastructure","Irrigation / Water supply","Other Costs","Total Costs","Revenue","Share of enterprise at total GM"]
[null,null,{"$f":"'1 General Information'!D15&\" / head\"","v":"acre / head"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"M7","v":"KES"},{"$f":"Q7","v":"KES"},"%"]
[null,null,null,"total","total","total","total","total","total","total","total","total","total","total","total","total","total","per farm enterprise"]
[null,"Seasonal crops",{"$f":"'3 Seasonal Crops'!C6","v":1},{"$f":"SUM('3 Seasonal Crops'!G10:G14)","v":500000},{"$f":"SUM('3 Seasonal Crops'!G16:G18)","v":0},{"$f":"'3 Seasonal Crops'!G19","v":500000},{"$f":"'3 Seasonal Crops'!G24","v":6000},null,{"$f":"'3 Seasonal Crops'!G30","v":3500},null,{"$f":"'3 Seasonal Crops'!G36","v":30000},{"$f":"'3 Seasonal Crops'!G44","v":216000},{"$f":"'3 Seasonal Crops'!G51","v":3950},{"$f":"'3 Seasonal Crops'!G58","v":30000},{"$f":"'3 Seasonal Crops'!G62","v":0},{"$f":"'3 Seasonal Crops'!G69","v":0},{"$f":"'3 Seasonal Crops'!G71","v":289450},{"$f":"'3 Seasonal Crops'!G73","v":210550},{"$f":"IF($R$12=0,0,+R9/$R$12)","v":0.31874952690939368}]
[null,"Perennial crops",{"$f":"'4 Perennial Crops'!C6","v":0},{"$f":"SUM('4 Perennial Crops'!G10:G14)","v":0},{"$f":"SUM('4 Perennial Crops'!G16:G18)","v":0},{"$f":"'4 Perennial Crops'!G19","v":0},{"$f":"'4 Perennial Crops'!G26","v":0},null,{"$f":"'4 Perennial Crops'!G32","v":0},null,{"$f":"'4 Perennial Crops'!G38","v":0},{"$f":"'4 Perennial Crops'!G46","v":0},{"$f":"'4 Perennial Crops'!G53","v":0},{"$f":"'4 Perennial Crops'!G60","v":0},{"$f":"'4 Perennial Crops'!G64","v":0},{"$f":"'4 Perennial Crops'!G71","v":0},{"$f":"'4 Perennial Crops'!G73","v":0},{"$f":"'4 Perennial Crops'!G75","v":0},{"$f":"IF($R$12=0,0,+R10/$R$12)","v":0}]
[null,"Livestock",{"$f":"'5 Livestock'!C6","v":3},{"$f":"SUM('5 Livestock'!G10:G23)","v":0},{"$f":"SUM('5 Livestock'!G25:G29)","v":450000},{"$f":"'5 Livestock'!G30","v":450000},null,{"$f":"'5 Livestock'!G39","v":0},null,{"$f":"'5 Livestock'!G45","v":0},null,{"$f":"'5 Livestock'!G53","v":0},null,{"$f":"'5 Livestock'!G67","v":0},{"$f":"'5 Livestock'!G71","v":0},{"$f":"'5 Livestock'!G80","v":0},{"$f":"'5 Livestock'!G82","v":0},{"$f":"'5 Livestock'!G84","v":450000},{"$f":"IF($R$12=0,0,+R11/$R$12)","v":0.68125047309060627}]
[null,"Sub-Total (for entire farm)",null,{"$f":"SUM(D9:D11)","v":500000},{"$f":"SUM(E9:E11)","v":450000},950000,6000,0,3500,0,30000,216000,3950,30000,0,0,{"$f":"SUM(Q9:Q11)","v":289450},{"$f":"SUM(R9:R11)","v":660550},{"$f":"SUM(S9:S11)","v":1}]
[]
[]
[null,"Fixed and Variable Costs",{"$f":"'8 Fixed and Variable Costs'!B9","v":"Membership fees "},{"$f":"'8 Fixed and Variable Costs'!B10","v":"Insurance costs"},{"$f":"'8 Fixed and Variable Costs'!B11","v":"Land tax"},{"$f":"'8 Fixed and Variable Costs'!B12","v":"Social fund contribution"},{"$f":"'8 Fixed and Variable Costs'!B13","v":"Leasing fees for equipment"},{"$f":"'8 Fixed and Variable Costs'!B14","v":"Rental costs for land"},{"$f":"'7 Financing'!D15","v":"Total Annual Loan Repayments"},{"$f":"'2 Equipment & Assets'!C38","v":"Total Annual Depreciation "},{"$f":"'8 Fixed and Variable Costs'!B15","v":"Other fixed costs"},{"$f":"'8 Fixed and Variable Costs'!B19","v":"Maintenance & repair"},{"$f":"'8 Fixed and Variable Costs'!B20","v":"General fuel & lubricants "},{"$f":"'8 Fixed and Variable Costs'!B21","v":"Water, electricity, gas supply"},{"$f":"'8 Fixed and Variable Costs'!B22","v":"Regular transport fees "},{"$f":"'8 Fixed and Variable Costs'!B23","v":"Regular staff salary costs"},{"$f":"'8 Fixed and Variable Costs'!B24","v":"Other variable costs"}]
[null,null,{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"},{"$f":"'1 General Information'!$D$14","v":"KES"}]
[null,null,{"$f":"'8 Fixed and Variable Costs'!O9","v":0},{"$f":"'8 Fixed and Variable Costs'!O10","v":0},{"$f":"'8 Fixed and Variable Costs'!O11","v":48000},{"$f":"'8 Fixed and Variable Costs'!O12","v":12000},{"$f":"'8 Fixed and Variable Costs'!O13","v":0},{"$f":"'8 Fixed and Variable Costs'!O14","v":0},{"$f":"IF('7 Financing'!G14=0,('7 Financing'!I14*12),('7 Financing'!G14*12))","v":253130.63786172069},{"$f":"'2 Equipment & Assets'!G38","v":34649.122807017542},{"$f":"'8 Fixed and Variable Costs'!O15","v":0},{"$f":"'8 Fixed and Variable Costs'!O19","v":0},{"$f":"'8 Fixed and Variable Costs'!O20","v":0},{"$f":"'8 Fixed and Variable Costs'!O21","v":0},{"$f":"'8 Fixed and Variable Costs'!O22","v":0},{"$f":"'8 Fixed and Variable Costs'!O23","v":0},{"$f":"'8 Fixed and Variable Costs'!O24","v":0}]

{"sheet":"Crop Price Calculation Sheet","index":13,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,0,1,13],[4,0,4,13],[14,0,14,13],[24,0,24,13],[0,0,0,13]]}
["INVEST – Farm Analysis Tool"]
["Supplementary sheet for calculating average annual costs for selected crops and livestock based on seasonal monthly variations"]
[null,"January","February","March","April","May","June","July","August","September","October","November","December","AVERAGE"]
[null,"Unit price","Unit price","Unit price","Unit price","Unit price","Unit price","Unit price","Unit price","Unit price","Unit price","Unit price","Unit price","Unit price"]
["Seasonal Crops"]
[{"$f":"'3 Seasonal Crops'!B10","v":"Tomatoes"},{"$nulls":12},{"$f":"AVERAGE(B6:M6)","v":{"$error":"#DIV/0!"}}]
[{"$f":"'3 Seasonal Crops'!B11","v":0},{"$nulls":12},{"$f":"AVERAGE(B7:M7)","v":{"$error":"#DIV/0!"}}]
[{"$f":"'3 Seasonal Crops'!B12","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Seasonal Crops'!B13","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Seasonal Crops'!B14","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Seasonal Crops'!B15","v":"By-products:"}]
[{"$f":"'3 Seasonal Crops'!B16","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Seasonal Crops'!B17","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Seasonal Crops'!B18","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
["Perennial crops"]
[{"$f":"'4 Perennial Crops'!B10","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'4 Perennial Crops'!B11","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'4 Perennial Crops'!B12","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'4 Perennial Crops'!B13","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'4 Perennial Crops'!B14","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'4 Perennial Crops'!B15","v":"By-products:"}]
[{"$f":"'4 Perennial Crops'!B16","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'4 Perennial Crops'!B17","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'4 Perennial Crops'!B18","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
["Livestock"]
[{"$f":"'5 Livestock'!B10","v":"Dairy cows"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'5 Livestock'!B11","v":"Heifers"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'5 Livestock'!B12","v":"Adult steers"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'5 Livestock'!B13","v":"Juvenile steers"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'5 Livestock'!B14","v":"Calfs"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'5 Livestock'!B15","v":"Sheep does"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'5 Livestock'!B16","v":"Sheep bucks"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'5 Livestock'!B17","v":"Sheep kids"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'5 Livestock'!B18","v":"Goat does"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'5 Livestock'!B19","v":"Goat bucks"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'5 Livestock'!B20","v":"Goat kids"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'5 Livestock'!B21","v":"Chickens"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'5 Livestock'!B22","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'5 Livestock'!B23","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'5 Livestock'!B24","v":"By-products:"}]
[{"$f":"'5 Livestock'!B25","v":"Milk"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'5 Livestock'!B26","v":"Eggs"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'5 Livestock'!B27","v":"Skins"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'5 Livestock'!B28","v":"Manure"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'5 Livestock'!B29","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]