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
Incorporating
innovative social, financial, economic, local administrative and productive
structures, numerous renewable energy applications, with an important role for
women in poverty alleviation in rural and poor urban environments.
"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, London 1958, page 228
Edition 02: 31 October,
2007
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
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.
Excel
file for the activities sheet.
Forward: Short analysis of the budget.
Menu group 7 work files: Financial justification.
Main menu for project work file groups.
Complete index of the project work files.