{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["READ ME","1. Financing models","How does it work "],"not_rendered":{"charts":0,"images":5,"macros":0,"external_links":0,"defined_names":33,"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":86,"n_cols":7,"rows_kept":86,"cut":false,"hidden":false,"merged":[[40,3,42,4],[34,3,35,9],[37,3,37,9],[36,3,36,9],[40,5,41,9],[43,5,43,7],[43,3,43,4],[85,3,85,5],[38,3,38,9],[77,3,83,9],[50,3,61,9],[63,3,75,9],[47,5,47,7],[45,3,47,4],[39,3,39,4],[39,5,39,6],[48,3,48,4],[44,3,44,4],[44,5,44,9],[48,5,48,7],[45,5,46,9],[10,3,10,9],[15,3,15,9],[17,3,17,9],[30,6,31,9],[27,3,27,9],[18,3,20,9],[22,3,22,9],[30,3,31,5]]}
{"$rows_empty":10}
[null,null,null,"Read Me Sheet"]
[]
[]
[]
[]
[null,null,null,"FINANCE – Finance Deployment Tools"]
[]
[null,null,null,"Introduction"]
[null,null,null,"This tool serves to identify the most suitable financial products available on the market for the use of a SPIS."]
[]
[]
[]
[null,null,null,"Tips & Tricks"]
[]
[]
[]
[]
[null,null,null,"Overview"]
[null,null,null,"This tool comprises the following sheet:"]
[]
[null,null,null,"1. Financing models",null,null,"identify a suitable financing option as per your prevailing circumstances"]
[]
[]
[]
[null,null,null,"This tool is based on the FAO Training Manual no. 3: Irrigation Water Management: Irrigation Water Needs, available at: "]
[]
[null,null,null,"http://www.fao.org/docrep/s2022e/s2022e07.htm"]
[]
[null,null,null,"About"]
[null,null,null,"Published by: ",null,"GIZ & FAO"]
[null,null,null,"Resposible:",null,"GIZ project Sustainable Energy for Food - Powering Agriculture"]
[]
[{"$nulls":5},"Francesca Dobrigna"]
[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.0 (April 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":13}
[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, 2017"]

{"sheet":"1. Financing models","index":1,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[11,8,13,10],[11,11,13,13],[7,8,9,10],[7,11,9,13],[21,1,21,5],[20,1,20,5],[2,1,2,5],[4,1,4,5],[11,1,11,5],[12,1,12,5],[15,1,15,5],[6,1,6,5],[14,1,14,5],[13,1,13,5],[8,1,8,5],[0,0,0,13],[9,1,9,5],[10,1,10,5],[19,1,19,5],[18,1,18,5],[17,1,17,5],[3,1,3,5],[5,1,5,5],[7,1,7,5],[16,1,16,5],[15,8,16,10],[15,11,16,13],[2,8,2,13],[3,8,5,10],[3,11,5,13],[1,1,1,7]]}
["FINANCE-Finance Deployment Tool"]
[null,"Answer the following questions (1-19) choosing among YES or NO on the drop down menu. On the right side of the excel sheet the financial products most suitable for your needs will compare."]
["1)","Do you possess any collateral?",{"$nulls":4},"Yes",null,"Possible financing options:"]
["2)","Do you possess any soft collateral?",{"$nulls":4},"Yes",null," COMMERCIAL BANK LOAN                                                     is a loan from a financial institution whose main occupations consist in giving loans and taking deposits ",null,null," DEVELOPMENT BANK LOAN                             is a loan froma financial institutions which provides financial services  to actors involved in the food value chain"]
["3)","Do you have access to alternative sources of income?",{"$nulls":4},"Yes"]
["4)","Can other people/companies guarantee for you?",{"$nulls":4},"Yes"]
["5)","Do you possess a bank account?",{"$nulls":4},"Yes"]
["6)","Do you possess a mobile device with access to the internet?",{"$nulls":4},"Yes",null,"MFIs                                                                            are organizations, which provide financial inclusion to the poor strata of the population",null,null,"VALUE-CHAIN LOAN                                           is a loan in-between the value chain actors. "]
["7)","Are you able to pay a commercial interest rate?",{"$nulls":4},"Yes"]
["8)","Do you possess starting capital?",{"$nulls":4},"Yes"]
["9)","Does your government subsidize your farm activity?",{"$nulls":4},"Yes"]
["10)","Do you work in an established value chain with downstream and upstream players?",{"$nulls":4},"Yes",null,"LEASING                                                                    is a financial instrument which allows the use of an equipment without the need to purchase it",null,null,"COOPERATIVES                                                                                                                                         are institutions which bring farmers together enabling them financial and economic advantages"]
["11)","Is the private sector interested in your products (i.e. for export reasons)?",{"$nulls":4},"Yes"]
["12)","Are there international cooperation programs investing in your farm activities? ",{"$nulls":4},"Yes"]
["13)","Can you imagine to use a SPIS without buying it?",{"$nulls":4},"Yes"]
["14)","Do you live in a community of people with a common bond? ",{"$nulls":4},"Yes",null,"INFORMAL SAVING GROUPS  are groups of people who save money in a common fund and borrow directly from their savings ",null,null,"PAY-PER-USE                                                 is a business model offered by equipment manufacturers and dealers"]
["15)","Can you imagine becoming a member of an organization: Deposit monthly payments, attend meetings and participate in group activities?",{"$nulls":4},"Yes"]
["16)","Is there a reciprocal trust between you and people of your community?",{"$nulls":4},"Yes"]
["17)","Can you imagine to deposit your saving in local saving groups?",{"$nulls":4},"Yes"]
["18)","Do you only have a limited and sporadic need of irrigation?",{"$nulls":4},"Yes"]
["19)","Are you able to depend on other people and on a predetermined schedule for the irrigation of your fields?",{"$nulls":4},"Yes"]

{"sheet":"How does it work ","index":2,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":true,"merged":[[7,4,7,6],[8,4,8,6],[9,4,9,6],[10,4,10,6],[1,1,1,2],[3,4,3,6],[4,4,4,6],[5,4,5,6],[6,4,6,6]]}
[]
[null,"Drop Down Menu",null,null,"Formula for Conditional Formatting"]
[]
[null,"Column1",null,null,"Commercial Bank Loan",null,null,{"$f":"AND(AND(OR('1. Financing models'!G3=\"yes\",'1. Financing models'!G5=\"yes\")),'1. Financing models'!G10=\"yes\",'1. Financing models'!G7=\"yes\",'1. Financing models'!G8=\"yes\",'1. Financing models'!G9=\"yes\")","v":true}]
[null,"Yes",null,null,"Development Bank Loan",null,null,{"$f":"AND(AND(OR('1. Financing models'!G11=\"yes\",'1. Financing models'!G13=\"yes\",'1. Financing models'!G14=\"yes\"),'1. Financing models'!G10=\"yes\",'1. Financing models'!G7=\"yes\",'1. Financing models'!G8=\"yes\",'1. Financing models'!G10=\"yes\"))","v":true}]
[null,"No",null,null,"MFIs ",null,null,{"$f":"AND(AND(OR('1. Financing models'!G3=\"yes\",'1. Financing models'!G4=\"yes\",'1. Financing models'!G6=\"yes\"),'1. Financing models'!G9=\"yes\",'1. Financing models'!G7=\"yes\",'1. Financing models'!G8=\"yes\"))","v":true}]
[{"$nulls":4},"Value Chain Loan",null,null,{"$f":"AND(AND(OR('1. Financing models'!G6=\"yes\",'1. Financing models'!G10=\"yes\"),'1. Financing models'!G7=\"yes\",'1. Financing models'!G9=\"yes\",'1. Financing models'!G8=\"yes\",'1. Financing models'!G12=\"yes\"))","v":true}]
[{"$nulls":4},"Leasing",null,null,{"$f":"AND('1. Financing models'!G7=\"yes\",'1. Financing models'!G8=\"yes\",'1. Financing models'!G15=\"yes\")","v":true}]
[{"$nulls":4},"Cooperatives",null,null,{"$f":"AND('1. Financing models'!G7=\"yes\",'1. Financing models'!G16=\"yes\",'1. Financing models'!G17=\"yes\",'1. Financing models'!G18=\"yes\",'1. Financing models'!G19=\"yes\")","v":true}]
[{"$nulls":4},"Informal Saving Group",null,null,{"$f":"AND('1. Financing models'!G18=\"yes\",'1. Financing models'!G19=\"yes\",'1. Financing models'!G16=\"yes\",'1. Financing models'!G17=\"yes\")","v":true}]
[{"$nulls":4},"Pay-per-Use ",null,null,{"$f":"AND(AND(OR('1. Financing models'!G20=\"yes\",'1. Financing models'!G21=\"yes\"),'1. Financing models'!G8=\"yes\",'1. Financing models'!G15=\"yes\"))","v":true}]