MHP-Financial Feasibility Analysis Tool - Revision history

Ranisha at 15:49, 26 June 2018

2018-06-26T15:49:49Z

Lisafeldmann at 11:44, 11 June 2015

2015-06-11T11:44:53Z

Ranisha at 12:23, 18 May 2015

2015-05-18T12:23:06Z

Wiki Gardener at 20:48, 12 January 2015

2015-01-12T20:48:18Z

Wiki Gardener at 20:47, 12 January 2015

2015-01-12T20:47:35Z

Ranisha at 09:51, 14 August 2014

2014-08-14T09:51:19Z

Fungai Cecilia Sandamu at 11:23, 22 August 2013

2013-08-22T11:23:36Z

Fungai Cecilia Sandamu at 11:21, 12 July 2013

2013-07-12T11:21:55Z

Fungai Cecilia Sandamu at 19:37, 14 May 2013

2013-05-14T19:37:03Z

Fungai Cecilia Sandamu: Fungai Cecilia Sandamu moved page Tool for a fast but profound analysis on the financial feasibility of MHP projects to MHP-Financial Feasibility Analysis Tool

2013-05-14T19:32:41Z

Fungai Cecilia Sandamu moved page Tool for a fast but profound analysis on the financial feasibility of MHP projects to MHP-Financial Feasibility Analysis Tool

@@ Line 1: / Line 1: @@
 [[Portal:Hydro|►Back to Hydro Portal]]
@@ Line 43: / Line 42: @@
 <references /><br/>
 [[Category:Hydro]]

@@ Line 1: / Line 1: @@
 [[Portal:Hydro|►Back to Hydro Portal]]
 = Overview =
 Find here a description and download of the "MHP-Financial Feasibility Analysis Tool"
 = Structure and Content<br/> =
 The first part of the tool (first two spreadsheets) requires the manual input of key data in approximately 70 cells. This input includes basic data on costs (initial investment and maintenance / replacement costs), tariff structures, number of connections and key financial aspects. The second part (remaining 8 spreadsheets) of the tool uses automatic Excel processes to present the calculation of costs, revenues, cash flows and financing over the life-span of the project. Moreover, a general overview and a sensitivity analysis provide a variety of indicators on the project’s feasibility. The tool may easily be adapted to other forms of energy production as well as particular fiscal features of other jurisdictions.<br/>
 == Target Groups<br/> ==
-(a) compare several offers on one and the same project and
+The tool has been developed to accommodate the needs of three target groups: ADER (Rural Electrification Agency of Madagascar), operators of mostly insular rural electrification schemes and local banks. ADER has already implemented the tool to
-(b) compare offers on different projects.
+(a) compare several offers on one and the same project and
 The distinct sheet “financing” within the tool allows ADER to assess the impact of different amounts of subsidies and sources of financing for a given project so that the need for and efficiency of subsidies can be checked. Operators use the tool to assess the financial feasibility of their projects and to present their project proposals to ADER, other donors / investors and banks. The tool enables the operators to run different project scenarios, e.g. different cost estimates and financing conditions, and thereby to get a better understanding of the strengths and weaknesses of their projects. In addition, the proposals based on the tool incorporate financial indicators required by local banks to decide on credit approvals. Local banks benefit from more professional project proposals on the basis of the tool presented by the operators. They are willing to providing loans to the sector but due to the low quality of credit applications so far only a few applications have been approved.<br/>
 == Restrictions<br/> ==
 It is important to note that the challenge in assembling this tool has been to create a simple but yet profound analytical tool which at the same token allows knowledge transfer and sustainability. Thus, the tool is designed to analyze a project’s economic feasibility in a simplified and semi-automatic manner, yet it does not substitute a detailed feasibility study on the basis of in-depth demand studies and detailed engineering.<br/>
 = Download Tool =
@@ Line 26: / Line 36: @@
 *[[:file:Financial Analysis of Micro-hydropower Projects - Excel Tool.xls|Analysis tool - english]]
 *[[:file:Outil d 'analyse financière .xls|Analysis tool - french]]
 <br/>
 = References =
 <references /><br/>
 [[Category:Financing_and_Funding]]

@@ Line 24: / Line 24: @@
 = Download Tool =
-*[[:file:Gtz-perer madagascar - financial modelling tool 02-02-10.xls|Analysis tool - english]]
+*[[:file:Financial Analysis of Micro-hydropower Projects - Excel Tool.xls|Analysis tool - english]]
-*[[:file:GTZ-PERER Madagascar - Outil d'Analyse Financière.xlsx|Analysis tool - french]]
+*[[:file:Outil d 'analyse financière .xls|Analysis tool - french]]
 <br/>
 = References =
 <references /><br/>
 [[Category:Financing_and_Funding]]

@@ Line 2: / Line 2: @@
 = Overview =
 Find here a description and download of the "MHP-Financial Feasibility Analysis Tool"
 = Structure and Content<br/> =
-The first part of the tool (first two spreadsheets) requires the manual input of key data in approximately 70 cells. This input includes basic data on costs (initial investment and maintenance / replacement costs), tariff structures, number of connections and key financial aspects. The second part (remaining 8 spreadsheets) of the tool uses automatic Excel processes to present the calculation of costs, revenues, cash flows and financing over the life-span of the project. Moreover, a general overview and a sensitivity analysis provide a variety of indicators on the project’s feasibility.
+The first part of the tool (first two spreadsheets) requires the manual input of key data in approximately 70 cells. This input includes basic data on costs (initial investment and maintenance / replacement costs), tariff structures, number of connections and key financial aspects. The second part (remaining 8 spreadsheets) of the tool uses automatic Excel processes to present the calculation of costs, revenues, cash flows and financing over the life-span of the project. Moreover, a general overview and a sensitivity analysis provide a variety of indicators on the project’s feasibility. The tool may easily be adapted to other forms of energy production as well as particular fiscal features of other jurisdictions.<br/>
 The tool may easily be adapted to other forms of energy production as well as particular fiscal features of other jurisdictions.
 <br/>
 == Target Groups<br/> ==
 The tool has been developed to accommodate the needs of three target groups: ADER (Rural Electrification Agency of Madagascar), operators of mostly insular rural electrification schemes and local banks. ADER has already implemented the tool to
 (a) compare several offers on one and the same project and
 (b) compare offers on different projects.
 The distinct sheet “financing” within the tool allows ADER to assess the impact of different amounts of subsidies and sources of financing for a given project so that the need for and efficiency of subsidies can be checked.
-Operators use the tool to assess the financial feasibility of their projects and to present their project proposals to ADER, other donors / investors and banks. The tool enables the operators to run different project scenarios, e.g. different cost estimates and financing conditions, and thereby to get a better understanding of the strengths and weaknesses of their projects. In addition, the proposals based on the tool incorporate financial indicators required by local banks to decide on credit approvals.
+The distinct sheet “financing” within the tool allows ADER to assess the impact of different amounts of subsidies and sources of financing for a given project so that the need for and efficiency of subsidies can be checked. Operators use the tool to assess the financial feasibility of their projects and to present their project proposals to ADER, other donors / investors and banks. The tool enables the operators to run different project scenarios, e.g. different cost estimates and financing conditions, and thereby to get a better understanding of the strengths and weaknesses of their projects. In addition, the proposals based on the tool incorporate financial indicators required by local banks to decide on credit approvals. Local banks benefit from more professional project proposals on the basis of the tool presented by the operators. They are willing to providing loans to the sector but due to the low quality of credit applications so far only a few applications have been approved.<br/>
 Local banks benefit from more professional project proposals on the basis of the tool presented by the operators. They are willing to providing loans to the sector but due to the low quality of credit applications so far only a few applications have been approved.
 <br/>
 == Restrictions<br/> ==
-It is important to note that the challenge in assembling this tool has been to create a simple but yet profound analytical tool which at the same token allows knowledge transfer and sustainability. Thus, the tool is designed to analyze a project’s economic feasibility in a simplified and semi-automatic manner, yet it does not substitute a detailed feasibility study on the basis of in-depth demand studies and detailed engineering.
+It is important to note that the challenge in assembling this tool has been to create a simple but yet profound analytical tool which at the same token allows knowledge transfer and sustainability. Thus, the tool is designed to analyze a project’s economic feasibility in a simplified and semi-automatic manner, yet it does not substitute a detailed feasibility study on the basis of in-depth demand studies and detailed engineering.<br/>
 <br/>
 = Download Tool =
@@ Line 31: / Line 35: @@
 <references /><br/>
 [[Category:Financing_and_Funding]]

@@ Line 1: / Line 1: @@
 [[Portal:Hydro|►Back to Hydro Portal]]
-= Description of the Tool =
+= Structure and Content<br/> =
-−
-== Structure and Content<br/> ==
-−
 The first part of the tool (first two spreadsheets) requires the manual input of key data in approximately 70 cells. This input includes basic data on costs (initial investment and maintenance / replacement costs), tariff structures, number of connections and key financial aspects. The second part (remaining 8 spreadsheets) of the tool uses automatic Excel processes to present the calculation of costs, revenues, cash flows and financing over the life-span of the project. Moreover, a general overview and a sensitivity analysis provide a variety of indicators on the project’s feasibility.
 The tool may easily be adapted to other forms of energy production as well as particular fiscal features of other jurisdictions.
 <br/>
 == Target Groups<br/> ==
 The tool has been developed to accommodate the needs of three target groups: ADER (Rural Electrification Agency of Madagascar), operators of mostly insular rural electrification schemes and local banks. ADER has already implemented the tool to
-The tool has been developed to accommodate the needs of three target groups: ADER (Rural Electrification Agency of Madagascar), operators of mostly insular rural electrification schemes and local banks. ADER has already implemented the tool to (a) compare several offers on one and the same project and (b) compare offers on different projects. The distinct sheet “financing” within the tool allows ADER to assess the impact of different amounts of subsidies and sources of financing for a given project so that the need for and efficiency of subsidies can be checked.
+(a) compare several offers on one and the same project and
 (b) compare offers on different projects.
 Operators use the tool to assess the financial feasibility of their projects and to present their project proposals to ADER, other donors / investors and banks. The tool enables the operators to run different project scenarios, e.g. different cost estimates and financing conditions, and thereby to get a better understanding of the strengths and weaknesses of their projects. In addition, the proposals based on the tool incorporate financial indicators required by local banks to decide on credit approvals.
 Local banks benefit from more professional project proposals on the basis of the tool presented by the operators. They are willing to providing loans to the sector but due to the low quality of credit applications so far only a few applications have been approved.
 <br/>
 == Restrictions<br/> ==
 It is important to note that the challenge in assembling this tool has been to create a simple but yet profound analytical tool which at the same token allows knowledge transfer and sustainability. Thus, the tool is designed to analyze a project’s economic feasibility in a simplified and semi-automatic manner, yet it does not substitute a detailed feasibility study on the basis of in-depth demand studies and detailed engineering.
 <br/>
 = Download Tool =
 *[[:file:Gtz-perer madagascar - financial modelling tool 02-02-10.xls|Analysis tool - english]]
 *[[:file:GTZ-PERER Madagascar - Outil d'Analyse Financière.xlsx|Analysis tool - french]]
 <br/>
 = Further Information =
-*[[:file:Gtz-perer_madagascar_-_outil_d_'analyse_financière_andriba_02-02-10.xls|Example case - analysis tool - french]]
+*[[:file:Gtz-perer madagascar - outil d 'analyse financière andriba 02-02-10.xls|Example case - analysis tool - french]]
-*[[:File:Gtz-perer_madagascar_-_financial_modelling_tool_02-02-10.xls|Hydro power (GTZ - Madagascar)]]<br/>
+*[[:File:Gtz-perer madagascar - financial modelling tool 02-02-10.xls|Hydro power (GTZ - Madagascar)]]<br/>
-−
 <br/>
 = References =
 <references /><br/>
 [[Category:Hydro]]

@@ Line 38: / Line 38: @@
 [[:file:Gtz-perer madagascar - outil d 'analyse financière andriba 02-02-10.xls|Example case - analysis tool - french]]
-[[Hydro_power_(GTZ_-_Madagascar)|Madagascar]] <br/>
+[[Hydro power (GTZ - Madagascar)|Madagascar]]<br/>
-−
-[[Category:Financing,_promotion_schemes_and_subsidies|Financing, promotion schemes and subsidies]]
 <br/>
@@ Line 48: / Line 46: @@
 <references /><br/>
 [[Category:Financing_and_Funding]]

@@ Line 4: / Line 4: @@
 <br/>
-= Short description of the tool =
+= Description of the Tool =
-== I. Structure and content<br/> ==
+== Structure and Content<br/> ==
 The first part of the tool (first two spreadsheets) requires the manual input of key data in approximately 70 cells. This input includes basic data on costs (initial investment and maintenance / replacement costs), tariff structures, number of connections and key financial aspects. The second part (remaining 8 spreadsheets) of the tool uses automatic Excel processes to present the calculation of costs, revenues, cash flows and financing over the life-span of the project. Moreover, a general overview and a sensitivity analysis provide a variety of indicators on the project’s feasibility.
-== II. Target groups<br/> ==
+The tool may easily be adapted to other forms of energy production as well as particular fiscal features of other jurisdictions.
 The tool has been developed to accommodate the needs of three target groups: ADER (Rural Electrification Agency of Madagascar), operators of mostly insular rural electrification schemes and local banks. ADER has already implemented the tool to (a) compare several offers on one and the same project and (b) compare offers on different projects. The distinct sheet “financing” within the tool allows ADER to assess the impact of different amounts of subsidies and sources of financing for a given project so that the need for and efficiency of subsidies can be checked.
@@ Line 18: / Line 22: @@
 Local banks benefit from more professional project proposals on the basis of the tool presented by the operators. They are willing to providing loans to the sector but due to the low quality of credit applications so far only a few applications have been approved.
-== III. Restrictions<br/> ==
+<br/>
 It is important to note that the challenge in assembling this tool has been to create a simple but yet profound analytical tool which at the same token allows knowledge transfer and sustainability. Thus, the tool is designed to analyze a project’s economic feasibility in a simplified and semi-automatic manner, yet it does not substitute a detailed feasibility study on the basis of in-depth demand studies and detailed engineering.
@@ Line 24: / Line 30: @@
 <br/>
-= Info Email by Sören:<br/><br/> =
+= Download Tool =
-From: David Soeren GTZ MG Sent: Wednesday, February 03, 2010 2:48 PM
+[[:file:Gtz-perer madagascar - financial modelling tool 02-02-10.xls|Analysis tool - english]]
-Dear colleagues,
+[[:file:GTZ-PERER Madagascar - Outil d'Analyse Financière.xlsx|Analysis tool - french]]
-GTZ-PERER Madagascar is happy to share with you our Excel Tool for a fast but profound analysis on the financial feasibility of MHP projects.
+<br/>
-In Madagascar, we run the tool in French but for the sake of most of you, we have also translated it into English. Furthermore, we provide you with a version of a basic case which has not been optimized so far to illustrate from where projects typically start off. We attach all those 3 versions to this e-mail, sorry for the large size of it all.
+= Further Information =
-For a brief description of the structure and content of the tool, its target groups and restrictions, please have a look at the text below the footer of this e-mail.
+[[:file:Gtz-perer madagascar - outil d 'analyse financière andriba 02-02-10.xls|Example case - analysis tool - french]]
-The tool may easily be adapted to other forms of energy production as well as particular fiscal features of other jurisdictions. In Madagascar, our local partners such as the Rural Electrification Agency (ADER), operator of electrification schemes and banks assisted a lot to optimize the tool in order to reflect their practical needs.
+[[Hydro|Hydro]] [[Madagascar|Madagascar]] [[Financing, promotion schemes and subsidies|Financing, promotion schemes and subsidies]]
-−
-I am happy to answer any further questions you might have on the tool. Remarks to further improve it are equally welcome.
-−
-I would like to thank Julian Frede for his assistance. We have developed the model together on the basis of my banking background and his programming skills in MS Excel . He also headed a training course with our local partners to implement the tool in Madagascar. Finally, he instructed a colleague from ADER to run the administration of the tool so that any further changes can be implemented locally. Julian works as a free-lance consultant, is fluent in both English and French and currently available to adapt the tool to the needs of other GTZ projects. Count on few days of work and the tool should fit to your particular needs. The sound general structure is in place and only minor changes should be required. You may contact Julian directly if you wish, julian.frede@yahoo.de.
-−
-I am looking forward to meeting most of you soon again at our Sector Network working group meeting hosted by Zana in Mozambique!
-−
-All the best,
-−
-Sören
-−
-Dr. Sören DAVID Conseiller principal "Promotion de l'électrification rurale par les énergies renouvelables" / Auftragsverantwortlicher Förderung der ländlichen Elektrifizierung durch Erneuerbare Energien Agence de Développement de l'Electrification Rurale (ADER) LOT II I 164 Ter - Amboniloha Ivandry - Antananarivo M: +261 (0)32 054 25 35 T: +261 (0)20 24 245 81 F: +261 (0)20 22 426 05
 <br/>
-= Download the tool: =
+= References =
-[[:file:Gtz-perer madagascar - financial modelling tool 02-02-10.xls|Analysis tool - english]]
+<references /><br/>
-−
-[[:file:GTZ-PERER Madagascar - Outil d'Analyse Financière.xlsx|Analysis tool - french]]
-−
-[[:file:Gtz-perer madagascar - outil d 'analyse financière andriba 02-02-10.xls|Example case - analysis tool - french]]
-−
-[[Hydro|Hydro]] [[Madagascar|Madagascar]] [[Financing, promotion schemes and subsidies|Financing, promotion schemes and subsidies]]
 [[Category:Financing_and_Funding]]