Director,
T.E.(Terry)
Manning,
Schoener 50,
1771 ED
Wieringerwerf,
The Netherlands.
Tel:
0031-227-604128
Homepage:
http://www.flowman.nl
E-mail:
(nameatendofline)@xs4all.nl : bakensverzet
and
"Money is not
the key that opens the gates of the market but the bolt that bars them"
Gesell, Silvio The
Natural Economic Order
Revised English edition,
Peter Owen,
“Poverty is created scarcity”
Wahu Kaara, point 8 of the Global Call to Action Against Poverty, 58th
annual NGO Conference, United Nations,
07.00 Financial justification.
The files
listed below are very simple technical files. They are designed to act as a
guide to help users who are not familiar with Excel spreadsheets prepare the
basic material for the various graphs included in the project documentation.
The
spread-sheet information to be filled in will vary with each project. These
variations will include budget item numbers, the amounts covered, and the
periods over which the money is spent.
The
graph type is usually “simple grouped columns” which are “organised in rows”.
The legend is usually placed under the graph. The “X” or horizontal line is
“Activity according to budget”. The “Y” or vertical line is the “Amount in
(Euro)”.
EXCEL
FILE FOR THE BUDGET
Excel file for the first year's
budget.
Excel file for the second year's
budget.
EXCEL
FILES COSTS EACH PHASE
The project phases do not follow quarterly or annual expenditure.
Figures given are approximate, as phases also overlap. In broad lines, the
second phase covers creation of project structures, the third phase the
creation of basic production and service facilities, and the fourth phase
completion of project activities. The
first phase is the preparation of the project documents and the formation of
the project partnership and the NGOs for project execution and on-going
management of the project structures. The first phase is not included in the
project budget.
Excel file for the second phase.
Excel file for the third phase.
Excel file for the fourth phase.
A single graph covering totals for each individual project item is not
readable.
Excel file showing total outgo first
year.
Excel file showing total outgo
second year.
A single graph covering totals for each individual project item is not
readable.
Excel file showing total outgo for
each quarter.
Excel file for activities first quarter.
Excel file for activities second quarter.
Excel file for activities third quarter.
Excel file for activities fourth quarter.
Excel file for activities fifth quarter.
Excel file for activities sixth quarter.
Excel file for activities seventh quarter.
Excel file for activities eighth quarter.
Excel file for personnel, items
1010101-20201.
Excel file for equipment, items
30101-3040104.
Excel file for vehicles, project offices,
items 40101-40404.
Excel file for formalities, items
5010-50901.
Excel file for hygiene education, items
60101-60203.
Excel file for financial structures, items
60301-60505.
Excel file for productive structures,
items 60601-60806.
Excel file for drinking water and
sanitation facilities, items 60901-61006.
Excel file for other activities, including
boreholes, items 61101-70101.
Excel file for supply contracts, items
70201-70221.
Excel file for consultants, items
70301-70306.
Budget items involving interest-free loans for productivity purposes are
paid back over a reasonable period of time, which is agreed between the project
management and the beneficiaries concerned. Which items are included and the
rate of repayment vary from case to case.
The average period for the repayment of loans under the interest-free
micro-credit system is shown in the graph as 24 months, or 8 quarters. This is
thought to be a very conservative estimate. Shorter average payback times will
lead to a larger total value of loan transactions.
Excel file for the micro-credits
graph.
FROM
07.00 FINANCIAL JUSTIFICATION
Forward
: 07.14 Built-in protection for funding parties.
Back: 07.12
Annual balance sheets and schedules.
Complete
index of the project.