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

{"sheet":"READ ME","index":0,"n_rows":106,"n_cols":7,"rows_kept":106,"cut":false,"hidden":false,"merged":[[69,3,80,9],[82,3,95,9],[97,3,103,9],[105,3,105,5],[18,3,23,9],[44,6,46,9],[44,3,46,5],[41,6,43,9],[63,3,63,4],[63,5,63,9],[64,3,66,4],[64,5,65,9],[66,5,66,7],[67,3,67,4],[67,5,67,7],[59,3,59,4],[59,5,59,6],[60,3,61,4],[60,5,61,9],[62,3,62,4],[62,5,62,7],[58,3,58,9],[41,3,43,5],[51,6,52,9],[51,3,52,5],[47,3,48,5],[47,6,48,9],[53,6,54,9],[53,3,54,5],[55,6,57,9],[55,3,57,5],[37,3,38,5],[37,6,38,9],[49,3,50,5],[49,6,50,9],[39,3,40,5],[39,6,40,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,"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. Income Crops & Livestock",null,null,"to add current or projected sales of seasonal crops (e.g. rice, maize), perennial crops (e.g. fruits) and livestock and respective by-products "]
[]
[]
[null,null,null,"4. 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,"5. Financing",null,null,"calculates annual loan repayment based on credit information"]
[]
[null,null,null,"6. Fixed and Variable Costs",null,null,"to add all fixed and variable costs/expenditures of the farm enterprise"]
[]
[null,null,null,"9. Farm Income Statement",null,null,"No Entry! Summary calculation on gross profitability of the farm enterprise"]
[]
[null,null,null,"Crop Price Calculation Sheet",null,null,"side sheet for calculating average annual crop and livestock prices"]
[]
[null,null,null,"Quick Check",null,null,"side sheet for a quick calculation of farm profitability useful before conducting full analysis"]
[]
[]
[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.5 (December 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'!D14,'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'!D15,'List of dropdown'!A14:B17,2,FALSE)","v":1}]

{"sheet":"1 General Information","index":2,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,9],[5,7,5,9],[10,2,10,7],[16,1,16,9],[17,1,17,9],[1,1,2,9],[7,2,7,4],[9,2,9,4],[8,2,8,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 or name","Mary Wanjiku's Farm",null,null,null,"Date","2018-08-07"]
[]
[null,"Village"]
[null,"Division"]
[null,"District"]
[null,"Assessor"]
[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$14","v":"acre"},"=",null,{"$f":"+E21/$J$14","v":1.0117156674288259},"ha"]
[null,"+ Additional land as part of co-operative land",null,null,null,{"$f":"+$D$14","v":"acre"},"=",null,{"$f":"+E22/$J$14","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(E21:E24)-E25+E26-E27","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$14","v":"acre"},"=",{"$f":"(+E32+F32)/$J$14","v":0.40468626697153032},"ha"]
[null,"Perennials (with & without option of intercropping)",{"$nulls":4},"acre","=",{"$f":"(+E33+F33)/$J$14","v":0},"ha"]
[null,"Greenhouses",{"$nulls":4},"acre","=",{"$f":"(+E34+F34)/$J$14","v":0},"ha"]
[null,"Pastures (grazing land)",{"$nulls":4},"acre","=",{"$f":"(+E35+F35)/$J$14","v":0},"ha"]
[null,"Fallow land",null,null,1.5,null,"acre","=",{"$f":"(+E36+F36)/$J$14","v":0.60702940045729548},"ha"]
[null,null,null,"Total agricultural / horticultural land",{"$f":"+SUM(E32:E36)","v":2.5},{"$f":"+SUM(F32:F36)","v":0},"acre","=",{"$f":"IF((+$I$32+$I$33+$I$34+$I$35+$I$36)=I28,+$I$32+$I$33+$I$34+$I$35+$I$36,\"CHECK Property rights\")","v":1.0117156674288257},"ha"]

{"sheet":"2 Equipment & Assets","index":3,"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":"Mary Wanjiku's Farm"}]
[]
[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'!D13","v":"KES"},{"$f":"'1 General Information'!D13","v":"KES"},"years","years",{"$f":"'1 General Information'!D13","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},"(highly quality dependent!)"]
[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 modules - 20 years","PV generator"]
[{"$nulls":6},"",null,"Well / borehole"]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[]
[null,null,"Total Annual Depreciation ",null,null,{"$f":"'1 General Information'!D13","v":"KES"},{"$f":"+SUM(G11:G36)","v":34649.122807017542}]

{"sheet":"3 Income Crops & Livestock","index":4,"n_rows":63,"n_cols":15,"rows_kept":63,"cut":false,"hidden":false,"merged":[[56,10,56,12],[54,10,54,14],[57,10,57,12],[58,10,58,12],[61,10,61,12],[59,10,60,14],[62,1,62,5],[0,0,0,6],[35,1,35,6],[40,1,40,2],[40,3,40,6],[38,3,38,4],[1,1,1,6],[3,5,3,6],[7,1,7,6],[19,1,19,6],[23,1,23,6],[18,1,18,5],[34,1,34,5],[30,10,30,14],[32,10,32,12],[33,10,33,12],[34,10,34,12],[35,10,35,12]]}
["INVEST – Farm Analysis Tool"]
[null,"INCOME: SEASONAL CROP"]
[]
[{"$nulls":4},"Farm code",{"$f":"'1 General Information'!C6","v":"Mary Wanjiku's Farm"}]
[]
[null,"Agricultural land used:",{"$f":"SUM(C10:C14)","v":1},{"$f":"'1 General Information'!D14","v":"acre"}]
[null,null,null,"Unit",{"$f":"\"Yield per \"& '1 General Information'!D14 &\" 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 INCOME",{"$nulls":4},{"$f":"SUM(G10:G18)","v":500000}]
[null,"INCOME: PERENNIAL CROP"]
[]
[null,"Agricultural land used:",{"$f":"SUM(C26:C30)","v":0},{"$f":"'1 General Information'!D14","v":"acre"}]
[null,null,null,"Unit",{"$f":"\"Yield per \"& '1 General Information'!D14 &\" or Quantity\"","v":"Yield per acre or Quantity"},"Unit Price","Value"]
[null,"Sales"]
[null,"Crop types:","Area:"]
[{"$nulls":6},{"$f":"+F26*E26*C26","v":0}]
[{"$nulls":6},{"$f":"+F27*E27*C27","v":0}]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[null,"By-products:"]
[{"$nulls":6},{"$f":"+F32*E32","v":0}]
[{"$nulls":6},{"$f":"+F33*E33","v":0}]
[{"$nulls":6},0]
[null,"GROSS INCOME",{"$nulls":4},{"$f":"SUM(G26:G34)","v":0}]
[null,"INCOME: LIVESTOCK"]
[]
[]
[null,"Livestock for production:",{"$f":"SUM(C43:C56)","v":3},"Livestock sold:",null,{"$f":"SUM(E43:E56)","v":0},"head"]
[null,null,null,"Unit","Quantity","Unit Price","Value"]
[null,"For Production",null,"For Sale"]
[null,"Livestock type","Quantity"]
[null,"Dairy cows",3,"head",null,null,{"$f":"+F43*E43","v":0}]
[null,"Heifers",null,"head",null,null,{"$f":"+F44*E44","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,null,null,null,"By-product calculator"]
[{"$nulls":6},0]
[null,"By-products:",{"$nulls":8},"Daily milk yield:",null,null,10,{"$f":"IF(K57=\"Daily milk yield:\",\"litres/day\",\"eggs/day\")","v":"litres/day"}]
[null,"Milk",null,"litres",9000,50,{"$f":"+F58*E58","v":450000},null,null,null,"Number of dairy livestock:",null,null,3,"head"]
[null,"Eggs",{"$nulls":4},{"$f":"+F59*E59","v":0},null,null,null,"Days of milking per year:",null,null,300,"days/year"]
[null,"Skins",{"$nulls":4},{"$f":"+F60*E60","v":0},null,null,null,"Note: milking (lactation) periods typically range between 209 and 305 days per year for dairy livestock"]
[null,"Manure",{"$nulls":4},{"$f":"+F61*E61","v":0}]
[{"$nulls":6},0,null,null,null,"Total",null,null,{"$f":"N57*N58*N59","v":9000},{"$f":"IF(K57=\"Daily milk yield:\",\"litres/year\",\"eggs/year\")","v":"litres/year"}]
[null,"GROSS INCOME",{"$nulls":4},{"$f":"SUM(G43:G62)","v":450000}]

{"sheet":"4 Other Income","index":5,"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],[3,10,3,11]]}
["INVEST – Farm Analysis Tool"]
[null,"4 OTHER INCOME"]
[]
[{"$nulls":10},"Farm code",null,{"$f":"'1 General Information'!C6","v":"Mary Wanjiku's Farm"}]
[]
[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},{"$f":"+SUM(C10:N10)","v":0}]
[null,"Lease out land",{"$nulls":12},0]
[null,"Lease out labour",{"$nulls":12},{"$f":"+SUM(C12:N12)","v":0}]
[{"$nulls":14},{"$f":"+SUM(C13:N13)","v":0}]
[{"$nulls":14},{"$f":"+SUM(C14:N14)","v":0}]
[null,"TOTAL OTHER INCOME per month",{"$f":"+SUM(C8:C14)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(O8:O14)","v":0}]

{"sheet":"5 Financing","index":6,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,13],[1,0,1,13],[4,8,7,8],[5,0,7,0],[5,1,7,1],[5,2,7,2],[5,3,7,3],[5,4,7,4],[5,5,7,5],[5,6,7,6],[5,9,15,13],[3,10,3,12],[4,0,4,6]]}
["INVEST – Farm Analysis Tool"]
["CREDIT AND FINANCING (simplified calculator, to be confirmed with loan provider)"]
[]
[{"$nulls":9},"Farm code",{"$f":"'1 General Information'!C6","v":"Mary Wanjiku's Farm"}]
["Calculator",{"$nulls":7},"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(D9,-PMT(F9/12,C9*12,B9),\"0\")","v":21094.219821810057}]
[{"$nulls":6},{"$f":"IF(D10,-PMT(F10/12,C10*12,B10),\"0\")","v":"0"}]
[{"$nulls":6},{"$f":"IF(D11,-PMT(F11/12,C11*12,B11),\"0\")","v":"0"}]
[{"$nulls":6},"0"]
[{"$nulls":6},"0"]
[{"$nulls":6},"0"]
[{"$nulls":6},"0"]
["TOTAL CREDIT",{"$f":"SUM(B9:B15)","v":600000},{"$nulls":4},{"$f":"SUM(G9:G15)","v":21094.219821810057},null,{"$f":"SUM(I9:I14)","v":0}]
[null,null,null,"Total Annual Loan Repayments",null,null,{"$f":"G16*12","v":253130.63786172069},null,{"$f":"I16*12","v":0}]

{"sheet":"6 Fixed and Variable Costs","index":7,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[5,1,6,1],[20,1,20,14],[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)"]
[]
[{"$nulls":11},"Farm code",{"$f":"'1 General Information'!C6","v":"Mary Wanjiku's Farm"}]
[]
[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,"Financing fees",{"$f":"'5 Financing'!$G$16","v":21094.219821810057},{"$f":"'5 Financing'!$G$16","v":21094.219821810057},{"$f":"'5 Financing'!$G$16","v":21094.219821810057},{"$f":"'5 Financing'!$G$16","v":21094.219821810057},{"$f":"'5 Financing'!$G$16","v":21094.219821810057},{"$f":"'5 Financing'!$G$16","v":21094.219821810057},{"$f":"'5 Financing'!$G$16","v":21094.219821810057},{"$f":"'5 Financing'!$G$16","v":21094.219821810057},{"$f":"'5 Financing'!$G$16","v":21094.219821810057},{"$f":"'5 Financing'!$G$16","v":21094.219821810057},{"$f":"'5 Financing'!$G$16","v":21094.219821810057},{"$f":"'5 Financing'!$G$16","v":21094.219821810057},{"$f":"+SUM(C9:N9)","v":253130.63786172066}]
[null,"Depreciation costs",{"$f":"'2 Equipment & Assets'!$G$38/12","v":2887.426900584795},{"$f":"'2 Equipment & Assets'!$G$38/12","v":2887.426900584795},{"$f":"'2 Equipment & Assets'!$G$38/12","v":2887.426900584795},{"$f":"'2 Equipment & Assets'!$G$38/12","v":2887.426900584795},{"$f":"'2 Equipment & Assets'!$G$38/12","v":2887.426900584795},{"$f":"'2 Equipment & Assets'!$G$38/12","v":2887.426900584795},{"$f":"'2 Equipment & Assets'!$G$38/12","v":2887.426900584795},{"$f":"'2 Equipment & Assets'!$G$38/12","v":2887.426900584795},{"$f":"'2 Equipment & Assets'!$G$38/12","v":2887.426900584795},{"$f":"'2 Equipment & Assets'!$G$38/12","v":2887.426900584795},{"$f":"'2 Equipment & Assets'!$G$38/12","v":2887.426900584795},{"$f":"'2 Equipment & Assets'!$G$38/12","v":2887.426900584795},{"$f":"+SUM(C10:N10)","v":34649.122807017549}]
[null,"Membership fees ",{"$nulls":12},{"$f":"+SUM(C11:N11)","v":0}]
[null,"Insurance costs",{"$nulls":12},{"$f":"+SUM(C12:N12)","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,{"$f":"+SUM(C14:N14)","v":12000}]
[null,"Leasing fees for equipment",{"$nulls":12},0]
[null,"Rental costs for land",{"$nulls":12},{"$f":"+SUM(C16:N16)","v":0}]
[null,"-",{"$nulls":12},{"$f":"+SUM(C17:N17)","v":0}]
[null,"-",{"$nulls":12},0]
[null,"TOTAL FIXED COSTS per month",{"$f":"+SUM(C9:C18)","v":28981.646722394853},{"$f":"+SUM(D9:D18)","v":28981.646722394853},28981.646722394853,28981.646722394853,28981.646722394853,28981.646722394853,28981.646722394853,28981.646722394853,28981.646722394853,28981.646722394853,28981.646722394853,28981.646722394853,{"$f":"+SUM(O9:O18)","v":347779.76066873822}]
[]
[null,"VARIABLE COSTS"]
[null,"Fuel and gas costs",329.16660000000002,329.16660000000002,329.16660000000002,329.16660000000002,329.16660000000002,329.16660000000002,329.16660000000002,329.16660000000002,329.16660000000002,329.16660000000002,329.16660000000002,329.16660000000002,{"$f":"+SUM(C22:N22)","v":3949.9992000000002}]
[null,"Water fees",{"$nulls":12},{"$f":"+SUM(C23:N23)","v":0}]
[null,"Electricity fees",{"$nulls":12},0]
[null,"Transport fees ",{"$nulls":12},0]
[null,"Salary costs (permanent staff)",{"$nulls":12},0]
[null,"Salary costs (temporary staff)",18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,18000,216000]
[null,"Seeds",500,500,500,500,500,500,500,500,500,500,500,500,6000]
[null,"Manure and fertilizer",291.66665999999998,291.66665999999998,291.66665999999998,291.66665999999998,291.66665999999998,291.66665999999998,291.66665999999998,291.66665999999998,291.66665999999998,291.66665999999998,291.66665999999998,291.66665999999998,3499.9999199999988]
[null,"Plant protection",2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,30000]
[null,"Fodder",{"$nulls":12},0]
[null,"Veterinary Services",{"$nulls":12},0]
[null,"Traction and mechanisation hire",{"$nulls":12},0]
[null,"Machinery repairs and maintenance",2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,2500,30000]
[null,"Infrastructure repairs and maintenance",{"$nulls":12},0]
[null,"Irrigation repair and maintenance",{"$nulls":12},{"$f":"+SUM(C36:N36)","v":0}]
[null,"-",{"$nulls":12},0]
[null,"-",{"$nulls":12},0]
[null,"VARIABLE COSTS per month",{"$f":"+SUM(C22:C38)","v":24120.833259999999},24120.833259999999,24120.833259999999,24120.833259999999,24120.833259999999,24120.833259999999,24120.833259999999,24120.833259999999,24120.833259999999,24120.833259999999,24120.833259999999,24120.833259999999,289449.99911999999]

{"sheet":"Graph table","index":8,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
["FIXED COSTS",{"$f":"'6 Fixed and Variable Costs'!B9","v":"Financing fees"},{"$f":"'6 Fixed and Variable Costs'!O9","v":253130.63786172066}]
[null,{"$f":"'6 Fixed and Variable Costs'!B10","v":"Depreciation costs"},{"$f":"'6 Fixed and Variable Costs'!O10","v":34649.122807017549}]
[null,{"$f":"'6 Fixed and Variable Costs'!B11","v":"Membership fees "},{"$f":"'6 Fixed and Variable Costs'!O11","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B12","v":"Insurance costs"},{"$f":"'6 Fixed and Variable Costs'!O12","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B13","v":"Land tax"},{"$f":"'6 Fixed and Variable Costs'!O13","v":48000}]
[null,{"$f":"'6 Fixed and Variable Costs'!B14","v":"Social fund contribution"},{"$f":"'6 Fixed and Variable Costs'!O14","v":12000}]
[null,{"$f":"'6 Fixed and Variable Costs'!B15","v":"Leasing fees for equipment"},{"$f":"'6 Fixed and Variable Costs'!O15","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B16","v":"Rental costs for land"},{"$f":"'6 Fixed and Variable Costs'!O16","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B17","v":"-"},{"$f":"'6 Fixed and Variable Costs'!O17","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B18","v":"-"},{"$f":"'6 Fixed and Variable Costs'!O18","v":0}]
[{"$f":"'6 Fixed and Variable Costs'!B21","v":"VARIABLE COSTS"},{"$f":"'6 Fixed and Variable Costs'!B22","v":"Fuel and gas costs"},{"$f":"'6 Fixed and Variable Costs'!O22","v":3949.9992000000002}]
[null,{"$f":"'6 Fixed and Variable Costs'!B23","v":"Water fees"},{"$f":"'6 Fixed and Variable Costs'!O23","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B24","v":"Electricity fees"},{"$f":"'6 Fixed and Variable Costs'!O24","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B25","v":"Transport fees "},{"$f":"'6 Fixed and Variable Costs'!O25","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B26","v":"Salary costs (permanent staff)"},{"$f":"'6 Fixed and Variable Costs'!O26","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B27","v":"Salary costs (temporary staff)"},{"$f":"'6 Fixed and Variable Costs'!O27","v":216000}]
[null,{"$f":"'6 Fixed and Variable Costs'!B28","v":"Seeds"},{"$f":"'6 Fixed and Variable Costs'!O28","v":6000}]
[null,{"$f":"'6 Fixed and Variable Costs'!B29","v":"Manure and fertilizer"},{"$f":"'6 Fixed and Variable Costs'!O29","v":3499.9999199999988}]
[null,{"$f":"'6 Fixed and Variable Costs'!B30","v":"Plant protection"},{"$f":"'6 Fixed and Variable Costs'!O30","v":30000}]
[null,{"$f":"'6 Fixed and Variable Costs'!B31","v":"Fodder"},{"$f":"'6 Fixed and Variable Costs'!O31","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B32","v":"Veterinary Services"},{"$f":"'6 Fixed and Variable Costs'!O32","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B33","v":"Traction and mechanisation hire"},{"$f":"'6 Fixed and Variable Costs'!O33","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B34","v":"Machinery repairs and maintenance"},{"$f":"'6 Fixed and Variable Costs'!O34","v":30000}]
[null,{"$f":"'6 Fixed and Variable Costs'!B35","v":"Infrastructure repairs and maintenance"},{"$f":"'6 Fixed and Variable Costs'!O35","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B36","v":"Irrigation repair and maintenance"},{"$f":"'6 Fixed and Variable Costs'!O36","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B37","v":"-"},{"$f":"'6 Fixed and Variable Costs'!O37","v":0}]
[null,{"$f":"'6 Fixed and Variable Costs'!B38","v":"-"},{"$f":"'6 Fixed and Variable Costs'!O38","v":0}]

{"sheet":"7 Farm Income Statement","index":9,"n_rows":64,"n_cols":10,"rows_kept":64,"cut":false,"hidden":false,"merged":[[63,3,63,7],[1,1,1,8],[3,6,3,7],[0,0,0,8],[57,3,57,5],[59,3,59,4],[60,3,60,4],[61,3,61,4],[62,3,62,4],[59,5,59,6],[60,5,60,6],[61,5,61,6],[62,5,62,6]]}
["INVEST – Farm Analysis Tool"]
[null,"8 FARM INCOME STATEMENT"]
[]
[{"$nulls":5},"Farm code",{"$f":"'1 General Information'!C6","v":"Mary Wanjiku's Farm"}]
[]
[null,null,"+","Gross value of seasonal crop production",{"$f":"SUM('3 Income Crops & Livestock'!G10:G14)","v":500000},{"$f":"'1 General Information'!$D$13","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":"SUM('3 Income Crops & Livestock'!G16:G18)","v":0},{"$f":"'1 General Information'!$D$13","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":"SUM('3 Income Crops & Livestock'!G26:G30)","v":0},{"$f":"'1 General Information'!$D$13","v":"KES"},"+",0]
[null,null,"+","Gross value of perennial crop by-product production",{"$f":"SUM('3 Income Crops & Livestock'!G32:G34)","v":0},{"$f":"'1 General Information'!$D$13","v":"KES"},"+",0]
[null,null,"+","Gross value of livestock production: ",{"$f":"SUM('3 Income Crops & Livestock'!G43:G56)","v":0},{"$f":"'1 General Information'!$D$13","v":"KES"},"+",0]
[null,null,"+","Gross value of livestock by-product production: ",{"$f":"SUM('3 Income Crops & Livestock'!G58:G62)","v":450000},{"$f":"'1 General Information'!$D$13","v":"KES"},"+",0.47368421052631576]
[null,null,"+","Gross value of other income: ",{"$f":"'4 Other Income'!O15","v":0},{"$f":"'1 General Information'!$D$13","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$13","v":"KES"},"=",{"$f":"SUM(H6:H12)","v":1}]
[]
[]
[null,null,"-","Total fixed costs",{"$f":"'6 Fixed and Variable Costs'!O19","v":347779.76066873822},{"$f":"'1 General Information'!$D$13","v":"KES"},"+",{"$f":"IF($E$21=0,0,+E19/$E$21)","v":0.54576823402604135}]
[null,null,"-","Total variable costs",{"$f":"'6 Fixed and Variable Costs'!O39","v":289449.99911999999},{"$f":"'1 General Information'!$D$13","v":"KES"},"+",{"$f":"IF($E$21=0,0,+E20/$E$21)","v":0.45423176597395859}]
[null,null,"=","TOTAL COST",{"$f":"SUM(E19:E20)","v":637229.75978873821},{"$f":"'1 General Information'!$D$13","v":"KES"},"=",{"$f":"SUM(H19:H20)","v":1}]
{"$rows_empty":35}
[null,null,"=",{"$f":"\"GROSS FARM PROFIT for period \"  &   '1 General Information'!D12","v":"GROSS FARM PROFIT for period 2018"},{"$f":"\"to \" & '1 General Information'!E12","v":"to 2019"},null,{"$f":"E16-E21","v":217770.24021126179},{"$f":"'1 General Information'!$D$13","v":"KES"}]
[null,null,null,"Farm Profit Margin ",null,null,{"$f":"(E16-E21)/E16","v":0.25470203533480912}]
[]
[null,null,null,{"$f":"\"average profit per \"&'1 General Information'!$D$14&\" of seasonal crops:\"","v":"average profit per acre of seasonal crops:"},null,{"$f":"IFERROR('3 Income Crops & Livestock'!G19/'3 Income Crops & Livestock'!C6,\"no crops\")","v":500000},null,{"$f":"'1 General Information'!$D$13&\" per\"&\" \"&'1 General Information'!$D$14","v":"KES per acre"}]
[null,null,null,{"$f":"\"average profit per \"&'1 General Information'!D14&\" of perennial crops:\"","v":"average profit per acre of perennial crops:"},null,{"$f":"IFERROR('3 Income Crops & Livestock'!G35/'3 Income Crops & Livestock'!C22,\"no crops\")","v":"no crops"},null,{"$f":"'1 General Information'!$D$13&\" per\"&\" \"&'1 General Information'!$D$14","v":"KES per acre"}]
[null,null,null,"average profit per head of livestock:",null,{"$f":"IFERROR(('3 Income Crops & Livestock'!G63+'3 Income Crops & Livestock'!F39)/'3 Income Crops & Livestock'!C39,\"no livestock\")","v":150000},null,{"$f":"'1 General Information'!$D$13&\" per head\"","v":"KES per head"}]
[null,null,null,"total crop area under cultivation:",null,{"$f":"'3 Income Crops & Livestock'!C6+'3 Income Crops & Livestock'!C22","v":1},null,{"$f":"'1 General Information'!D14","v":"acre"},null,{"$f":"SUM('1 General Information'!I32:I36)-F63","v":1.1715667428825682E-2}]
[null,null,null,{"$f":"IF(J63<0,\"Cultivated area does not match available crop area (1. General Information)\",\"\")","v":""}]

{"sheet":"Crop Price Calculation Sheet","index":10,"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 Income Crops & Livestock'!B10","v":"Tomatoes"},{"$nulls":12},{"$f":"AVERAGE(B6:M6)","v":{"$error":"#DIV/0!"}}]
[{"$f":"'3 Income Crops & Livestock'!B11","v":0},{"$nulls":12},{"$f":"AVERAGE(B7:M7)","v":{"$error":"#DIV/0!"}}]
[{"$f":"'3 Income Crops & Livestock'!B12","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B13","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B14","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B15","v":"By-products:"}]
[{"$f":"'3 Income Crops & Livestock'!B16","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B17","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B18","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
["Perennial crops"]
[{"$f":"'3 Income Crops & Livestock'!B26","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B27","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B28","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B29","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B30","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B31","v":"By-products:"}]
[{"$f":"'3 Income Crops & Livestock'!B32","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B33","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B34","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
["Livestock"]
[{"$f":"'3 Income Crops & Livestock'!B43","v":"Dairy cows"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B44","v":"Heifers"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B45","v":"Adult steers"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B46","v":"Juvenile steers"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B47","v":"Calfs"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B48","v":"Sheep does"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B49","v":"Sheep bucks"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B50","v":"Sheep kids"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B51","v":"Goat does"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B52","v":"Goat bucks"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B53","v":"Goat kids"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B54","v":"Chickens"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B55","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B56","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B57","v":"By-products:"}]
[{"$f":"'3 Income Crops & Livestock'!B58","v":"Milk"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B59","v":"Eggs"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B60","v":"Skins"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B61","v":"Manure"},{"$nulls":12},{"$error":"#DIV/0!"}]
[{"$f":"'3 Income Crops & Livestock'!B62","v":0},{"$nulls":12},{"$error":"#DIV/0!"}]

{"sheet":"Quick Check","index":11,"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,"QUICK CHECK"]
[]
[]
[null,"Annual Expenditure"]
[null,"Expenditure Type","Examples","Annual Amount"]
[null,"Seasonal crop expenses","Seedlings, pesticides, fertilisers, protection, etc",null,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",null,null,"d."]
[null,"Labour","Salaries, benefits, own salary (?) etc",null,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"]
[]
[null,null,null,{"$f":"SUM(D7:D16)","v":0}]
[]
[null,"Annual Income"]
[null,"Income Type","Examples","Annual Amount"]
[null,"Seasonal crop sales","Tomatos, grain, rice, value added product, etc"]
[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"]
[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":0}]
[]
[null,null,"Profit or loss",{"$f":"D30-D17","v":0}]
[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 or means to reduce expenses.\",\"\")))","v":""}]