Hailu Ginchi Farm
Hailu Ginchi Farm
Hailu Ginchi Farm
VEGETABLES PRODUCTION
Ilfata, Ethiopia
OCT, 2023
i|Page
ii | P a g e
Table of Contents
Executive Summary of the Project.....................................................................................iv
1. Introduction................................................................................................................1
2. Background.................................................................................................................1
2.1. Fruit and vegetable Production in Ethiopia.......................................................................2
2.2. Fruit and vegetable Production and Management practices in Ethiopia...........................3
2.3. Constraints of Fruit and vegetable Production in Ethiopia...............................................3
2.4. Fruit and vegetable Marketing in Ethiopia.......................................................................4
2.5. Spices Sector in Ethiopia..................................................................................................6
2.6. Development and socio-economic objectives...................................................................7
2.7. Income distribution and poverty.......................................................................................7
3. Project Goal, Objectives and Rationales..................................................................8
4. The project Area Description....................................................................................8
4.1. Physical Features...............................................................................................................8
4.2. Economic Base..................................................................................................................9
4.3. Population.......................................................................................................................10
4.4. Vegetation.......................................................................................................................10
4.5. Infrastructure and Institutions.........................................................................................10
5. The Project Out puts, Activities and Inputs..........................................................11
5.1. Project Description..........................................................................................................11
5.2. project objectives............................................................................................................11
5.3. Types of technology Use.................................................................................................11
5.4. Production Capacity........................................................................................................11
5.5. Land Use Plan and Action Plan......................................................................................12
6. Market Prospects......................................................................................................12
6.1. Demands and Main Customers.......................................................................................12
6.2. Competition analysis and Selling Prices.........................................................................12
6.3. Marketing Strategies.......................................................................................................13
7. Organizations and Administration of the project.................................................14
7.1. Business Form.................................................................................................................14
7.2. Organization Structure of the Project..............................................................................14
7.3. Manpower Requirement with Qualification...................................................................14
8. Stakeholders and partners.......................................................................................15
iii | P a g e
9. Financial Study.........................................................................................................16
8.1 Financial Requirements...................................................................................................16
8.2. Forecasted Production........................................................................................................20
83 Forecasted Sales Revenues...................................................................................................20
8.4. Depreciation calculations....................................................................................................20
8.5 Loan Repayment Schedule and Interest Expense................................................................20
8.6 Forecasted Income Statement..............................................................................................21
8.7 Forecasted Cash Flow Statement.........................................................................................21
8.8 Forecasted Balance Sheet....................................................................................................21
8.9 Overall Financial Assessment.............................................................................................21
10. Environmental Impact Analysis..............................................................................23
11. Conclusion and Recommendation..........................................................................24
Annex.................................................................................................................................25
iv | P a g e
Executive Summary of the Project
1. Project Name Fruits and vegetable Production
15. Recommendation The project is economically, financially and socially feasible. For
instance, financially, the project’s IRR is 56% which is greater
than discount rate (11.5%) and NPV is equal to Br.
73,862,678
v|Page
1. Introduction
Tropical and sub-tropical fruit can make a significant direct contribution to the subsistence of small-
scale farmers by providing locally generate nutritious food that is often available when other
agricultural crops have not yet been harvested. Fruit are a versatile product that, depending on
need, can be consumed within the household or sold. Marketing fresh and processed fruit products
generates income which can act as an economic buffer and seasonal safety net for poor farm
households. Diversification into fruit production can generate employment and enable small-scale
farmers to embark on a range of production, processing and marketing activities to
complement existing income-generating activities (Clarke, et.al, 2011). The fruit and vegetable
(Persea Americana) is a native of Central America and the West Indies.
The tree is evergreen, though heavy leaf fall may occur during profuse blossoming and when the
tree is affected by root rot. The growth habit varies from tall and upright to well-shaped and
spreading. Fruit of the cultivated species vary greatly in size, shape, color, texture and flavor. The
edible part of the fruit-the flesh between the seed and the skin varies in color from cream to
yellowish green. When ripe the flesh should have the consistency of soft butter. The fruit has one
seed. The fruit is unique in that it will not ripen until harvested and may be left on the tree for some
time (depending on variety) after reaching maturity. Fruit and vegetables contain from 5 to 40% oil,
the percentage varying with the variety, growing area and seasonal conditions. Only ripe olives
have higher oil content. The therapeutic value of fruit and vegetable oil is related to its fatty acid
composition. Fruit and vegetables contain many vitamins, particularly the B complex and vitamins
A and E, as well as folic acid and iron. They contain no cholesterol (Agfact H6.1.1 2003). Fruit and
vegetable’s global production has now reached more than 3.8 million metric tons (FAOSTAT,
2010).
2. Background
Ethiopia is agro-ecologically diverse and has a total area of 1.13 million km 2. Many parts of the
country are suitable for growing temperate, sub-tropical or tropical fruits. For instant, substantial
areas in the southern and south-western parts of the country receive sufficient rainfall to support
fruits adapted to the respective climatic conditions. In addition, there are also many rivers and
streams which could be used to grow various fruits. Ethiopia has a potential irrigable area of 3.5
1|Page
million ha with net irrigation area of about 1.61 million ha, of which currently only 4.6 % is utilized
(Amer, 2002). Fruits have significant importance with a potential for domestic and export markets
and industrial processing in Ethiopia. The main fruits produced and exported are banana, citrus
fruits, mango, fruit and vegetable, papaya and grape fruits (Zeberga, 2010). According to Mauro
(2006), Ethiopia’s international involvement in horticultural trade and production is growing at rate
of 7 percent per year by creating better opportunity to compete on lucrative export market.
Owing to these realities, with its shortest introduction to Ethiopia, these days the crop is produced
in several countries where Ethiopia stands the 10 th leading producer and 6th most important
consumer in the world (FAOSTAT, 2010). Fruit and vegetable was first introduced to Ethiopia in
1938 by private orchardists in Hirna and Wondo-genet and production gradually spread into the
countryside where the crop was adapted to different agro-ecologies (Edossa, 1997; Woyessa and
Berhanu, 2010; and Zekarias, 2010). Fruit and vegetables are second in total volume of production,
next to banana, in Ethiopia (Joosten, 2007). Annual fruit and vegetable production in Ethiopia is
25,633.16 tons. The crop is now produced by 1,149,074.00 farmers countrywide who collectively
farm more than 8938.24 ha of land (CSA, 2012/13). Absence of improved varieties, fruit and
vegetable and mango production is exclusively based on distribution of mixed materials;
consequently the local seed system has come out as best-bet arena and is now a common route for
seedling dissemination (Ayelech, 2011). According to Mulat (2000) the largest constraints in
Ethiopian agricultural markets are the limited number of traders that have a scarce amount of capital
together with a large number of farmers, which leaves the farmers with a weak bargaining power.
Furthermore, limited information systems, poor transportation, high handling costs and an
underdeveloped sector are other limitations on the market. According to W.Garedew (2010) even
though fruit and vegetable has economically and socially play a significant role its production is
confronted by a number of constraints; - this are Degeneration of fruits, Disease problem and
absence of agronomic practices. According to Susanna and Amanda, 2014 In Ethiopia No value
adding activities of fruit and vegetable take place at the farmer, broker or wholesaler level in the
supply chains and the products are sold unprocessed. The value of the fruits increases when the
products move closer to markets with high demand.
2|Page
BRIEF DESCRIPTION OF PROJECT
Nursery Business will be used to meet the growing need of best varieties of fruit,
Vegetable ornamental plants and vegetable seedlings. The nursery industry is a
very wonderful and exciting business. The production of plants for profit has the
potential of providing many personal and financial rewards. However, as with
many other farming enterprises that appear to be very simple on the surface, the
nursery business is very complex and requires a great deal of knowledge and skill
not only in production, but also in labor management and marketing.
The nursery industry is very diverse. It is a business, and like any other
business, the probability of success depends on imagination, determination,
planning, and good management of the five major resources.
Nursery producers utilize one or more of the following production systems: field,
container, and pot-in-pot.
There are three major areas in which nursery producers compete: price, quality
and service (delivery). It is very difficult to compete with larger nurseries on
production costs. Therefore, new competition must strive to produce higher
quality plants and provide better service.
Apart from carefully studying the whole document one must consider critical
aspects provided later on, which form basis of any Investment Decision.
Ethiopia has huge investment potentials for agricultural development. Currently, investment in the
agriculture sector is found to be more attractive and profitable in diverse sub-sectors ranging from
food products, industrial raw materials to bio-fuel. The agriculture sector accounts for 47% of the
Gross Domestic Products of the country, provides 85% of employment and 90% of foreign
currency earning.
Moreover, the country has a huge market potential for crop and livestock produced with
comparative advantage to the Middle East, Europe, and Asia. For the past five consecutive years,
the agriculture sector was growing faster with more than 11% average annual growth. In addition to
the contribution to the national growth, the growth has triggered the increase in the domestic market
has for both livestock and food crops.
Looking at the agro-climatic condition i.e. average temperature, rainfall, physic-chemical properties
of the soil and the distribution of the rainfall give an indication that the proposed land is suitable for
cultivation of various crops but especially fruit and vegetables. The physic-chemical properties of
the soil indicated in the information sheet provide further confidence for the success of the project.
Moreover, the planning on the financial part of the project i.e. investment, cash flow, return on
investment, profitability and the cost-benefit ratio will show a positive trend.
The expertise in the marketing of farm-produced in the international market will provide an
additional benefit to improve the financial health of the organization. The statistic indicated in the
financial report will provide us confidence in the project. It justifies the investment and returns on
the investment.
5|Page
Support for the project
The financial support i.e., the equity infusion in the form of cash and kind for this project on
investments shall be received from promoters. The company shall receive equity infusion in the
form of cash or kind from any of these mentioned companies hereby for its project. The company
shall take the financial support in the form of project loan from either development bank of Ethiopia
or commercial bank of Ethiopia. In addition to our in-house team, we are also interacting with the
Ethiopian Institute of Agriculture Research to get timely support and valuable advice in this project
based on their experiences.
We are also expecting support from Agricultural office and responsible government officials for
identification of suitable land and facilitation of the documentation and import of farm machinery
and equipment, farm inputs for the success of this project. It appears to be a joint project of Fruit
and vegetable production farm project and Ministry of Agriculture, Government of Ethiopia, as we
need lots of support from the Ministry of Agriculture at various level of implementation of
activities in this project. Without their help and support, it will not be possible to make this project
a success
6|Page
in diameter in trees that are 25 to 30 years old (raceme), that can be axillaries or terminal. Fruit and
vegetable trees can be seeded or grafted. The seeded trees produce fruit after approximately 8 years
and grafted trees, being the most common propagation method, produce fruit after only 2 years.
Besides the longer juvenile period the seeded trees also have a larger risk of losses in yield and
quality. The fruit and vegetable trees could need irrigation during dry periods but not during rain
seasons. Root rot is the most common failure in fruit and vegetable production and too much
irrigation is one of the causes of this. According to CSA (2012/2013) the total cultivated area for
Fruit and vegetable in Ethiopia is 8938.24 hectares and production 256331.64 quintals more area
coverage is expected in the south-western and other parts of the country due to more conducive
climatic and edaphic factors.
Table 1 Summary of major fruit crops produced in Ethiopia in 2014/2015 cropping season
7|Page
spacing associated with difference in size and expansion nature of varieties used. In relation to this
management practices starting from seed multiplication up to harvesting are done by farmer’s
indigenous practice. According to Orwa et al.(2009) planting distances depend on soil type and
fertility, current technology, and economic factors. In commercial groves, trees are planted from 5-7
m in rows and 7-9 m between rows. Pruning during the first 2 years encourages lateral growth and
multiple framework branching. Ayelech (2011) indicated that Farm Yard Manure principally
transported from homestead to the field mostly during the dry season and spread in the bottom of
each tree in circular form. The chemical inputs entirely evaded neither for fertilization nor for pest
treatment. Thus, its Farm Yard Manure rate of application is minimal to improve soil fertility but
with positive impact on environment, i.e., reduction of soil pollution and water pollution. The same
study indicated that smallholder farmers in the area intercrop Fruit and vegetable with maize, taro,
ginger, chat, cabbage and banana at early stage. Another study conducted by Gilliard and Godfroy
(1995) intercropping of fruit and vegetable with short cycled crops; which is very common in sub-
Saharan Africa and most utilizes the empty space during the first few years.
8|Page
promises high returns on relatively small investments (Timoteos and Tigist, 2012). According to
Bezabih and Hadera ,(2007) horticulture production is based on tradition, which is poorly supported
by scientific recommendations. Although one can associate this constraint to institutional factors, it
is apparent that inadequate farmer skills and knowledge of production and product management
affects the supply. Farmers attempt to select varieties and practice traditional crop management
Farmers’ know-how of product sorting, grading, packing and transporting is traditional, which
severely affects the quality of horticultural products supplied to the market.
According to Birhanu (2013) Constraints hindering the development of fruit and vegetables are
found in all stages of the production chain. At the farmlevel, lack of clean disease-free seedlings
and grafted seedlings has compelled farmers to use inferior and low yielding varieties. Storage
facilities are scarce all along the chain and absence of collective bargaining power has forced
individual farmers to accept unfavorable deals. According to Zekarias (2010) Major productions
constraints are:-Vegetative growth: Most of the farmers reported that their fruit and vegetable trees
show only vegetative growth rather than giving yield at their fruit bearing stage Falling down of
fruits before they are mature, Pest problem There are no improved agronomic practices Longetivity:
Farmers are very much disappointed by the longer time fruit and vegetable takes to bear fruit and
Inadequate extension activities undertaken on fruit and vegetable. W.Garedew,(2010) also indicated
that even though fruit and vegetable has economically and socially play a significant role its
production is confronted by a number of constraints ;- this are Degeneration of fruits ,Disease
problem and absence of good agronomic practices.
9|Page
(consumer). This knowledge is acquired by studying the participants in the process, i.e. those who
perform physical marketing functions in order to obtain economic benefits (Getachew, 2002). A
marketing chain is used to describe the numerous links that connect all actors and transactions
involved in the movement of agricultural products from the farm to the consumer (Lunndyet al.,
2004). It is the path one good follow from their source of original production to ultimate destination
for final use. Fruits for both fresh and processed have a huge domestic market in Ethiopia which is
by far significant than that of the export volume.
The major export markets for fruits for Ethiopia are the surrounding countries Djibouti, Sudan and
Somalia and the main products exported to these countries is non-graded fresh fruits Whereas,
higher valued fresh produce that includes graded and pre-packed are exported to the United Arab
Emirates, United Kingdom and the Netherlands. about 85% of the fruits are exported to Djibouti
and the second export market destination is the Emirates (EHDA, 2011). In general, the main
products for export were citrus, bananas and mangoes (EHDA, 2011). Fruit and vegetable is
channeled from producers to local collectors, Cafeteria and whole sellers and finally to Addis
Ababa market through these channel middle men buys all fruit and vegetable fruits from the farmers
at a lower price and sells them in the market at higher price (Zekarias, 2010). According to Birhanu
(2013) the fruit and vegetable industry operated under an unregulated environment. Prices were
exclusively determined by traders negotiating with farmers at time of procurement. Over supply of
fruit is the principal reason for price declines which affect farmers.
10 | P a g e
supply periods which is not based on the real demand and supply interaction .this implies, the
middlemen decide on the price of fruit products. Producers cannot negotiate since they may be
denied even a low price and their products could be liable to rotting, since it is perishable, and lack
of semi-processing industries (yimer, 2015). According to Ayelech, (2011) Absence of organized
institution and system group marketing has made traders in a better position to dominate the
pricing. Changing the attitudes of farmers is a crucial factor in improving the marketing
performance of households. According to Zekarias (2010) major constraints for Fruit and vegetable
marketing Low price for product, low bargaining power to influence their due to poor economy and
perish ability nature of the product.
11 | P a g e
2.5. Spices Sector in Ethiopia
The Ethiopian varied agro ecology supports growing of a wide variety of crops in general and spice
crops in particular. As a result the country hosts several indigenous common and exotic spice crops,
which are cultivated widely since the time immemorial. Spice crops are produced in various regions
of the country and predominantly by small farmers as a cash crop traded primarily in domestic
markets, but with increasing success also entering foreign markets. The spice sub-sector has an
immense potential for economic development and poverty reduction through creation and
expansion of employment opportunities and distribution of income and foreign exchange earnings.
However despite all the potentials and opportunities of having such a long history and variety of
them with a diversified conducive agro-ecology base, the spice sub-sector potential remained
unexploited. The subsector is still not organized, low in productivity and inefficient. The production
of all the different types of spices, especially the technique employed by smallholders is mainly
based on traditional ancient knowledge that has been inherited and transferred from generations to
generations. Producers seldom use modern technologies such as farming tools and new techniques
and inputs like pesticide, fertilizer and improved seeds. Moreover, the production system is based
on rain-fed agriculture; therefore the supply of spices is unsustainable because of the vulnerability
of the crops to possible droughts. In most cases mixed unplanned cropping is performed and
normally smallholder farmers do not allocate enough land for the production of spices.
Despite Ethiopia’s a long history in Spice trade and its conducive agro-ecology which supports the
production of variety of them, the contribution of spice trade remained minimal and low.
Ministry of Trade is charged with the responsibility of creating conducive and enabling policy,
legal and regulatory environment in support of trade particularly that of export trade with the view
to facilitate a more diversified export trade. Given the potential of spice crop for an expanded
export trade, it is definitely among the priority crops that the Ministry considers for the support.
Thus the Ministry of Trade was represented in the Coordinating Committee that coordinated the
Strategy development process and participated actively at different stages of the development
including the stakeholders workshop held mid July 2010
13 | P a g e
producing more, selling more, nurturing the environment, eliminating hunger and protecting the
vulnerable against shocks; all of which are embodied in various national policy instruments, and are
expressed in terms of four main themes, each with its own Strategic Objective summarized as
follows:
Table: Strategic Objective
Thematic Area Strategic Objectives (SOs)
Productivity and To achieve a sustainable increase in agricultural productivity and
Production production.
Rural Commercialization To accelerate agricultural commercialization and agro industrial
development.
Natural Resources To reduce degradation and improve productivity of natural
Management resources.
Disaster Risk Management To achieve universal food security and protect vulnerable
and Food Security households from natural disasters.
Thus, the objective of this investment project proposal is well anchored to, and aligned with the
national socioeconomic development of the country. The detail project rational and objectives are
explained under section three “rationale and Objectives of the project”.
14 | P a g e
Smallholder output is inadequate and most fruits consumption is met by importing;
There has been a call for our smallholder and investors to concentrate on increasing
production and productivity to meet the growing food and export demands;
Past production increases depended largely on an expansion of area planted rather than on
increasing average yields per hectare continued to be low by international standards whereas
this project aims at meeting such standards;
Such project with the aim of enhancing production and productivity of fruits (Fruit and
vegetable), and spices will minimize the current national budget deficit caused as a result of
importing food items on one hand and generate foreign currency by promoting exports of
Fruit and vegetable and spices on the other hands.
Implementation of this commercial Fruit and vegetable and spices production project is
expected to Mettu, so that the outputs of this project will become the inputs for the
processing factors.
As Mettu town is expected to be the commercial center of the south western Ethiopia, this
project will have access to lucrative international market. The railroad and airport which is
on the process of implementation will facilitate the transportation of the products safely and
swiftly.
The license area is located in Oromia Regional State, West shawa Zone, Ilfata Woreda. The total
area of the project is 2.5 ha
The study area, Ilfata Wareda is found in West shawa zone of Oromia regional state. The Woreda
is located in the South Eastern part of the zone (Figure 2). It is one of the administrative units
15 | P a g e
(among 18 Woredas ) of West shawa zone with an area of about 2,384 square kilometers (account
for 3.4% of the area of the zone), which ranked it as 8th largest Woreda in the zone.
Administratively the Woreda is sub divided into 29 rural and 2 urban administration Kebeles.
According to 2013 CSA’s population projection, total pupation of the woreda by year 2014 is
170,218 (83,500 female and 86,718 male). Among which 141,929(83%) are rural and 28,289(17%)
are urban dwellers.
The administrative center of the Woreda is Ilfata town, which is located at distance of 133 km from
zone capital Robe town and 563 km from country center, Addis Ababa. The Woreda is bordered by
Gololcha and Gasera Woredas in North, Rayitu and Sawena Woredas in East, Dawe Kachen in
South and Goro and Sinana Woredas in West.
16 | P a g e
Ilfata Woreda receives mean annual rainfall of about 918 mm. The Woreda receive rain in two
seasons such as Belg(Autumn) season (March to May) and Tsedey(spring) season (September
to November). Bega (winter) season (December- February) is the driest season in the area. Unlike
highland part of the country, Kremit (June to August) is dry season with only small rainfall (figure
3).
In the Woreda the highest rainfall amounts recorded in months of April, May and October and the
lowest amount recorded in months of January and February.
4.1.2. Livestock
Like in most peasant smallholder societies in the Oromia region, livestock play a key role in day-to-
day life of the Mettu woreda society. Livestock play a key role in day-to-day life of the society,
especially in the peasant sector. They provide meat & milk, transport, manure, skin & hide &
furnish regular & easily realizable cash income. But in contrast to the size of the livestock
population, physical & value productivity is low.
In this project area oxen are the main source of power for peasant farming and hence a farmer with
no farm oxen is considered as poor. A farmer having a pair of ox is expected to feed himself and his
families provided that he possesses enough farmland. Saving capacity of the society is again the
function of their production capacity, which in turn, is the functions of oxen and farm sizes, both of
which are declining from time to time in this area. Besides, the farm oxen need medical care and
treatment, the cost and availability of which is again the major challenges for the smallholder
farmers. As a result, the average number of farm oxen per household has been decreasing from time
to time thereby leaving the smallholder farmers at very precarious situation.
17 | P a g e
4.1.4. Industry
Industry is a group of productive enterprises or organizations that produce or supply goods,
services, or sources of income. There is no medium and large-scale industries found in the district
and there is a data problem on small scale manufacturing industries.
4.2. Population
Population size, compositions, its spatial distribution and some other demographic and socio-
economic data are very important for planning, monitoring and evaluation of various development
programs. The total population size of the district is estimated to be 91,039 out of these 50,849 are
males and 40,200 are females. However, as the number of oxen per household are gradually
decreasing owing to the animal diseases and farm sizes is getting smaller and smaller due to
increasing population, there has been a trend of increasing rural to urban migration in search for
alternative non-farm income employment opportunities. Hence, this project is expected to create job
opportunities for these potential migrants at their nearby village and hence alleviate the pushing
factor for migrations.
4.3. Vegetation
About 19.5 percent of Ilfata District and its surrounding areas have been covered with forests both
natural and manmade forests. The lower part of the District is covered with lowland woodlands,
bush and Acacia trees (Acacia abyssinica). The dominant land cover of the project area is bushes.
There are also significant acacia woodlands. The project area is partly flat area and some of its part
is sloppy ranging from 3-5% covered by bushes, scattered acacia species and grazing land.
18 | P a g e
5. The Project Out puts, Activities and Inputs
19 | P a g e
5.3. Types of technology Use
The project aims at employing technologies which are environmentally friendly and which can be
effectively utilized by locally existing know-how with the exceptions of some machineries and
equipment which should be imported if there is no domestic source of supply. The project aims at
utilizing locally available technologies so as to encourage the backward and forward linkage of the
project and hence contribute towards the realization of Agricultural Development Led
Industrialization (ADLI) strategy of the country.
Fruit and
Fruit 55%
vegetable
Grapes 25%
Apple 18%
As the above table shows, the total farm land is allocated to production of demanded Fruit and
vegetable and various high valued spices items such as: Fruit (60 percent of the land to be covered
by Fruit and vegetable); Spices (38 percent of the land to be covered by Pepper, Ginger and
Others). The construction plots are expected to cover only 1 hectare and the remaining land 2
20 | P a g e
percent is reserved for forest coverage (at least 2 percent of the allotted land for investment as per
the Oromia Rural Land use and Administration Proclamation No. 130/ 2007, which will be 9
hectares).
6. Market Prospects
21 | P a g e
1. For the Supply of project inputs:
Regional and zonal Agricultural Research Institutes;
Regional and zonal Seed Enterprises (RSEs),
Universities and Agricultural Colleges existing in the region, and
Private organizations.
2. For the distributions of the project outputs:
Seed supplying enterprises
Agricultural Colleges existing in the region,
Civil society organizations (CSOs), including cooperatives and farmer organizations,
Private organizations, and individuals
International importers,
Local Traders
22 | P a g e
7. Organizations and Administration of the project
Note that this organizational structure depicts the overall flows of accountability and reporting
structure of the project staffs.
23 | P a g e
Table 2. Manpower Requirement (with qualifications, number and estimated monthly salaries in
Birr)
Staffs with position No Profession/Qualification Monthly Annual Salary
Require Salary (Birr)
d (Birr)
General Manager 1 MSc Agronomy/Related 7,000 84,000
Farm Manager 1 Bsc in Plant science /Horticulturist 6,000 72,000
Marketing officer 1 BA in Marketing 5,500 66,000
Administration 1 BA in Management 6,000 72,000
Forman 3 Diploma in relevant field 5,000 180,000
Clerk/Accountant 1 Diploma &above in relevant field 4,500 54,000
Time Keeper 3 Diploma &above in relevant field 2,500 90,000
Tractor Operators 2 4th /5th grade license and 10th/12th 5,000 120,000
complete
Farm Guards 4 8th /10th complete 1500 72,000
Store keepers 2 Diploma in relevant field 3,000 72,000
Secretary 1 Diploma in relevant field 2,500 30,000
Cashier 1 Diploma in relevant field 3,500 42,000
Cooks 3 10th /12th complete 1,500 54,000
Cleaners/Janitors 3 10th complete 1,200 43,200
Driver 3 4th /5th grade license and 10th /12th 3,000 108,000
complete
Sub-Total 30 1,159,200.00
Note that the employees’ salary is expected to increase by a minimum of five per
cent each year.
24 | P a g e
9. Financial Study
In this section, both the cash outflow requirements and the projected inflows are projected and
analyzed.
8.1 Financial Requirements
The yearly financial requirements of the project are classified as capital costs, operating costs and
working capital requirements as follows.
8.2 Project Capital Costs
The project capital costs include such costs as construction costs, expenditures on office
equipments, investment in farm equipments, and other costs which are supposed to be capitalized as
cost of the project and are gradually depreciated over the life of the project. Accordingly, the
following are the projected capital costs of the project summarized under different sections.
Construction costs: - these include expenditures related with the constructions of Store, residential
houses with guard room, offices, toilet, and guardian houses, parking areas, cafeteria etc. The
following table shows just the summaries of the construction items and their respective costs.
25 | P a g e
Investment on farm machineries and equipments: - The following table shows the specifications of
the selected machineries from the proforma invoices attached to this report.
Farm tools: - in addition to the above-mentioned farm machineries, the following farm tools are
also identified with their respective current unit prices. However, as these items are diverse in kind
and in significant in terms of cost per unit, the costs are forested based on the current market price
without the need to collect proforma invoices.
Table 5. Farm tools with their respective per unit cost and quantities needed
S.N0 Items Quantity Units cost Total cost
1 Chemical Sprayer 2 1500 3,000
2 Sickles 100 250 25,000
3 Axes 60 100 6,000
4 Tape meter (100 m) 10 650 6,500
5 Wheel borrow 5 3,500 17,500
6 Shovel 10 180 1,800
7 Weighing scale 3 25,000 75,000
8 Washing Machine 2 250,000 500,000
9 Vacuum Pump 1 125,000 125,000
10 Saw 10 160 1,600
11 Cutlass or Machete 3 40,000 120,000
12 Spade hoe 10 900 9,000
13 Local hand hoe 20 70 1,400
14 Spade 30 98 2,940
15 Digging fork 50 400 20,000
16 Trovel 4 500 2,000
= Estimated cost of farm tools (in Birr) 916,740
Office Equipments: - the following table shows the prices of office equipments at the time of
preparing this project proposal.
26 | P a g e
Table and chair (Farm Manger) Set 5 9,500 47,500
Waiting /guest Chair Pcs 10 1,500 15,000
Camp bed and furniture’s Set 8 3,200 25,600
Shelf and Other Drawers Set 3 5,000 15,000
Weighing scale 3 25,000 75,000
Desk top computer with its Accessories 5 15,500 77,500
Fax Machine 1 9,600 9,600
Laptop computer 3 25,500 76,500
Computer tables 3 5,000 15,000
Printer 1 7,600 7,600
Safe box 1 18,000 18,000
Cash register machine 1 8,000 8,000
Calculator /adding machines 2 650 1,300
Sub total 391,600.00
27 | P a g e
5. Finally, the average wage per day of labor is multiplied by the total labor requirement of the
project for each year. We have taken Birr 81.00 as the average wage per day per worker
applicable to the project location. The average wage per work-day is projected to increase by
minimum of 5 percent each year. This is determined by considering the change in the labor
markete price over the past few years.
Supplies costs: - such costs include costs for technological inputs such as fuel cost for the tractors,
fertilizers, seeds, office supplies and other chemicals. Table 9 (annexed) shows the detailed
calculations of these cost items, the summary of which is Birr 1,396,875 annual supplies cost. As
usual, we expect these cost items to increase by a minimum of 5 per cent per year. This is presented
by table 12 (annexed).
Repair and maintenance costs: - Operating costs for operations and maintenance of machineries
and equipment is taken to be 2 percent of the initial investment costs starting from its second year
after acquisition until end of tenth year, after which the rate would be 10 percent. Accordingly, table
8 (annexed) shows the detailed calculation of this cost item which is summarized to be Birr
391,878 starting from the second year of the project operation to tenth year. This is presented by
table 13 (annexed).
Utilities expenses: - these include such periodical costs as incurrence of liabilities (payments of
cash) for water bills, electricity bills, fuel consumptions and telephone expanses. Although such
types of expenses are changing with the volumes of operations, it is forecasted that a minimum of
Birr 412,500 forecasted for the first year of project operation, which is expected to increase by a
minimum of 5 percent per year. This is presented by table 14 (annexed).
Miscellaneous Expense: - are other operating expense for which it is neither economical nor
convenient to give specific account code and hence should be merged together under
“miscellaneous expense” includes entertainment expense, employee benefits, litigation expense and
others. Similar to the utilities expense, such expenses are estimated to be Birr 1,199,153 for the first
year and expected to increase at least by 5 percent per year. This is presented by table 14 (annexed).
which is (Birr 364,168 *0.8=364,168). It is estimated that the remaining 20 Percent increase in each
year’s operating expense will be covered by the cash inflows of the preceding year. The same
approach is followed for the rest years. The non-cash expense is not included in the determinations
of the working capital requirements. This is because such expense has no effect on cash flow
streams for which we need to determine working capital requirement. However, periodical income
tax and interest liabilities need to be considered since such items affect cash flows of an entity.
Nonetheless, they are not reflected in this case since we have not yet estimated such costs by this
time.
29 | P a g e
8.2. Forecasted Production
In order to estimate the per hectare production of each crop, we have utilized opinions of experts in
the field of agronomists. Accordingly, table 17 (annexed) shows the projected output in quintal
from each crop proposed to be cultivated over the first ten years of the project life.
Note that the projections are based on the expert opinions in the field as well as per the
recommendations of east Wollega zone agriculture office, and experienced investors & seed
multipliers enterprises. In essence, if the project is to be implemented and run in accordance with
the recommendations of the experts, these projections are supposed to be achievable. Here, it is
expected that as the project operates for more number of years, there is advantage of getting lessons
from the past years and hence the latter years’ output per year is expected to increase accordingly.
The cash flow statement shows the sources and uses of money over a given period of time.
Accordingly, there are three sections of this report: (1) cash flows of operating activities (O); (2),
cash flows of investing activities (I), and (3) cash flows of financing activities (F). Net cash flow of
the project is the sum of net cash flows from these three sections. Table 23 (annexed) shows the
projected cash flow statement over the first ten years of the project. Note also that this cash flow
31 | P a g e
report shows that the firm’s cumulative cash inflows over the forecast period is very attractive and
deserves financing. This statement also proves that the project is finically viable.
Note that as the projected balance sheet shows that the financial position of the firm remarkably
improves over the period and will be able to full operate by own finance after ten years if the
project is successfully implemented. This also supports that the project has financial viability.
Furthermore, the project has the following financial performance measured in different investment
decision criteria. The following table shows the summarized project financial viability test just for
the first ten years of the life of the project. Note that these figures would have been much larger if
we consider the entire life of the project since most of the capital expenditures of the project are
supposed to be committed at the beginning of the years while most net cash inflows are expected
32 | P a g e
during the later life of the project. However, these figures are still indicators of financial
attractiveness of the project. Detail calculation is presented by table 25 (annexed).
Net Present Value (NPV): - is the sum of present values of all the cash flow both positive and
negative that are expected to occur over the life of the project. The formal selection criterion for the
NPV measure of project worth is to accept all independent projects with a positive NPV when
discounted at the opportunity cost of capital. In this project case, given the project has positive
value of Birr 73,862,678; it means that the project would contribute Birr 73,862,678 towards the
wealth maximization of the owner’s wealth and hence it is viable.
Benefit Cost Ratio (BCR): - The benefit-cost ratio is defined as the ratio of the discounted values of
benefits to the discounted value of costs. A ratio of at least one is required for acceptability and the
ratio of one indicates that the NPV of zero at a particular discount rate. In our case BCR of Birr
1.52 shows, for every one Birr invested in this project, the return would be 1.52 Birr, which is
highly remarkable figure.
Net Benefit Cost Ratio (NBCR): - this ratio is defined as the ratio of net present value to the
present value of cost. A ratio greater than zero (0) is needed for the project to be financially
acceptable; in our case the ratio of 0.52 is in excess of the hurdle rate required to make the project
financially viable (the project is magnificent in terms of this criteria also).
Internal Rate of Return (IRR): - is the maximum interest that a project could pay for the resources
used if the project is to recover its investment and operating costs and still break even. It measures
opportunity cost of capital tied up in the investment. In this project case, IRR is 56 percent which is
extraordinarily large compared with the minimum cost of capital of 11.5 per cent. Hence, we can
safely conclude that the IRR of the project is extraordinarily high and hence indicates project
viability.
33 | P a g e
It should be recalled that the various investment decision criterion we have considered above
involve predicting values for each of the various elements entering into the definition of volume of
output sold, selling price, required investment, labor costs per unit; maintenance costs of machines,
profit, and so forth. However, as these values are based on certain assumptions, they may change in
unfavorable direction thereby making projects less attractive than when it was planned. Thus,
switching value measures the value an element of a project would have to reach as a result of a
change in an unfavorable direction before that project no longer meets the minimum level of
acceptability as indicated by one of the measures of project worth. In this case we ask, by how
much an element would have to change in an unfavorable direction before the project would no
longer meet the minimum level of acceptability as indicated by one of the measures of project
worth. In other words, in sensitivity analysis, we ask how sensitive is the project’s estimated
financial and economic benefits to increase in costs, fall in price and extension of implementation
periods?
In our case, since BCR is 1.52, it means that cost can rise by 52 percent at which the BCR will
become exactly 1.0 and hence the decision will be indifference. However, any rise in cost beyond
52 percent keeping sales revenues constant will lead the BCR to be below 1.0 and hence the
decision will be to reject the project on this ground. But it is unlikely to expect such increase in
operating costs keeping selling prices of these products constant. Thus, the 52 percent margin of
safety is large enough to guarantee for the stability of the above decision criteria. Similarly,
equals to 34 percent, keeping the cost elements constant. Any drop in sales by more than 34 percent
may lead the project to rejection region. However, given the past few year trends, the price of these
items has been increasing at increasing rate and hence expected to increase over the next many
years partly due to increasing demand to these outputs and partly due to increasing general trend in
commodity prices. Overall, when evaluated both in terms of cost and revenue, the project has
sufficient margin of safety to guarantee the stability of the determined investment decision criteria
above. Thus, it is can be safely concluded that the project is financially viable.
34 | P a g e
10. Environmental Impact Analysis
Consistent with the government’s high priority of encouraging private investment in the agriculture
sector, these integrated projects aim at agricultural production with due care to reduce degradation
and improve productivity of natural resources. Given the fact that these projects intend to utilize
the rain fed cultivation, certainly these reliefs the existing degradation pressure on rural farm land
imposed by the traditional farming system.
More importantly, the projects aim at reversing the environmental degradation trends widely
observable in the area by breaking the nexus between poverty and degradations. In essence, the
projects aim at solving the key problem area by breaking the nexus between rural poverty, natural
resource management and climate change mainly by creating alternative and more lucrative income
source for the local resource poor smallholder farmers, who, otherwise should depend on the natural
resource bases and hence causes the degradations. The project promoters believe:
environment and natural resource degradation are often a direct cause of rural poverty;
rural poverty often exacerbates environment and natural resource degradation; and
Climate change increases the vulnerability of rural people and the ecosystems they depend
on for their livelihoods.
Thus, opening alternative source of income by creating job opportunities within the project can
relieve the current pressure on the rural land in the project area. Besides, the project promoters are
fully aware of the Oromia Rural Land use and Administration Proclamation No. 130/ 2007, which
force any investor to cover at least 2 percent of the allotted land area by indigenous trees.
The strategic objectives of the projects are highly consistent with the national development
objective which calls to “sustainably increase rural incomes and national food security,
which embodies the concepts of producing more, selling more, nurturing the environment,
eliminating hunger and protecting the vulnerable against shocks.
35 | P a g e
These projects are expected to create job opportunities for these potential migrants at their
nearby village and hence alleviate the pushing factor for migrations.
The projects aim at utilizing locally available technologies so as to encourage the backward
and forward linkage of the project and hence contribute towards the realization of
Agricultural Development Led Industrialization (ADLI) strategy of the country.
Finally, the projects will largely contribute towards the national economic development by
contributing to National GDP. GDP contribution originating from the agriculture sector has
more power of poverty reduction than other sectors (a one percent GDP growth rate
originating in agriculture sector has more potential for poverty reduction than two percent
GDP growth rate originating from the service sector).
Recommendation: - considering the viability of the project, as aforementioned, the project is
recommended for implementation.
36 | P a g e
Annex
Table. 7 Labor requirement per Hectares of each crop
Project life in years
Crop and Operation 1 2 3 4 5 6 7 8 9 10 to 25
Fruit Land preparation 20 15 15 15 15 15 15 15 15 15
and
vegetable
Planting 50 50 50 50 50 50 50 50 50 50
Weeding (2X) 40 40 40 40 40 40 40 40 40 40
Chemical application (2X) 15 15 15 15 15 15 15 15 15 15
Harvesting 40 40 40 40 40 40 40 40 40 40
Total 165 160 160 160 160 160 160 160 160 160
Grapes
Land preparation 20 15 15 15 15 15 15 15 15 15
Planting 12 12 12 12 12 12 12 12 12 12
Weeding (2X) 24 10 10 6 6 6 6 6 6 6
Chemical application (4X) 15 15 15 15 15 15 15 15 15 15
Harvesting (2X) 20 20 20 20 20 20 20 20 20 20
Total 91 72 72 68 68 68 68 68 68 68
Apple
Land preparation 20 15 15 15 15 15 15 15 15 15
Planting 15 15 15 15 15 15 15 15 15 15
Weeding (2X) 24 10 10 6 6 6 6 6 6 6
Chemical application (2X) 12 12 12 12 12 12 12 12 12 12
Harvesting 30 30 30 30 30 30 30 30 30 30
Labor per season 101 82 82 78 78 78 78 78 78 78
Labor requirement is expressed in terms of work-day, which is to mean the time devoted by one person during one day (usually eight hours).
37 | P a g e
Table 8. Estimated yearly repair and maintenance expenses Repair and maintenance
Items costs Rate
Store and bathing room 1,950,000.00 0.02 39,000.00
New John Deere 6100D Mfwd Tractor (Mexico Origin) 2,765,577 0.02 55,311.54
Brand New Toyota Hilux Double cab 2,300,000 0.02 46,000.00
Trailer 660,000 0.02 13,200.00
Truck 3,450,000 0.02 69,000.00
Seed Sorting, Packing & distributing 8,000,000 0.02 160,000.00
Chemical Sprayer 3,000.00 0.02 60.00
Sickles 25,000.00 0.02 500.00
Axes 6,000.00 0.02 120.00
Tape meter (100 m) 6,500.00 0.02 130.00
Wheel borrow 17,500.00 0.02 350.00
Shovel 1,800.00 0.02 36.00
Weighing scale 75,000.00 0.02 1,500.00
Saw 1,600.00 0.02 32.00
Cutlass or Machete 120,000.00 0.02 2,400.00
Spade hoe 9,000.00 0.02 180.00
Local hand hoe 1,400.00 0.02 28.00
Spade 2,940.00 0.02 58.80
Digging fork 20,000.00 0.02 400.00
Trovel 2,000.00 0.02 40.00
Laptop Computer 76,500.00 0.02 1,530.00
Printers 7,600.00 0.02 152.00
Shelf 15,000.00 0.02 300.00
Managerial Chairs 47,500.00 0.02 950.00
Guest Chairs 15,000.00 0.02 300.00
Computer tables 15,000.00 0.02 300.00
Total Repair and Maintenance costs 391,878.34
38 | P a g e
Table 9. Total Labor requirement and cost of the project
Years 1 2 3 4 5 6 7 8 9
Fruit and Labor per Ha (table 7) 165 160 160 160 160 160 160 160 160
vegetable
Land area (table 1) 110 110 110 110 110 110 110 110 110
Sub-total labor required 18150 17600 17600 17600 17600 17600 17600 17600 17600
Grape Labor per Ha (table 7) 91 72 72 68 68 68 68 68 68
Land area (table 1)* 50 50 50 50 50 50 50 50 50
Sub-total labor required 4550 3600 3600 3400 3400 3400 3400 3400 3400
Apple Labor per Ha (table 7) 101 82 82 78 78 78 78 78 78
Land area (table 1) 35 35 35 35 35 35 35 35 35
Sub-total labor required 3535 2870 2870 2730 2730 2730 2730 2730 2730
Total Labor required per ha 26235 24070 24070 23730 23730 23730 23730 23730 23730
39 | P a g e
Unit Amount needed Cost (Birr)
Fertilizers: per Ha Total per unit Total
1 DAP kg 100 11000 15 165,000.00
2 UREA kg 150 16500 11 181,500.00
3 Pesticides L 4 440 350 154,000.00
4 Seeds kg 25 2750 18 49,500.00
5 Input transportations kg 10 1100 0.5 550.00
6 Output transportations kg 600 66000 0.5 33,000.00
7 Packing materials Pcs 70 7700 10 77,000.00
Sub-total 660,550.00
2. Grapes & Apple (85 Ha)
Unit Amount needed Cost (Birr)
Fertilizers: Per Ha Total Per unit Total
1 DAP kg 100 8500 15 127,500.00
2 UREA kg 100 8500 12 102,000.00
3 Pesticides L 4 340 350 119,000.00
4 Seeds kg 100 8500 15 127,500.00
5 Input transportations kg 10 850 0.5 425.00
6 Output transportations kg 600 51000 0.5 25,500.00
7 Sacking materials Pcs 16 1360 10 13,600.00
8 Sub-total 515,525.00
Total operating input supplies costs (excluding tractor related costs) 1,176,075.00
Table 11. Tractor related annual operating costs per year
1. Fruit and vegetable (110 Ha)
Requirements Fuel consumption Fuel Price
Descriptions Unit Per Ha Total Per hour Total Per Litter Total
Tractor Operations T/H
1 Ploughing T/H 2 360 20L 2200 20.00 Birr 39600
2 Discing & harrowing T/H 2 360 20L 2200 20.00 Birr 39600
3 Ridging T/H 2 360 20L 2200 20.00 Birr 39600
Sub-total 118,800.00
2. Grapes and Apple (85 Ha)
40 | P a g e
Requirements Fuel consumption Fuel Price
Descriptions Table 14. Miscellaneous
Unit and utilities
Per Ha Total Per hourexpenseTotal
per year Per Litter Total
Years 1
Tractor Operations 2 T/H 3 4 5 6 7 8 9 10
412,500
Utilities Expense 1 Ploughing 433,125 454,781
T/H 477,520
2 226 501,396 20L 526,466 552,789
1700 20.00 Birr 580,42934000609,450 639,923
Other Operating expense 1,199,153
2 Discing 1,259,110 1,322,066
& harrowing T/H 1,388,169
2 226 1,457,577
20L 1,530,4561700 1,606,979
20.00 Birr 1,687,32834000
1,771,694 1,860,279
3 Ridging T/H 2 226 20L 1700 20.00 Birr 34000
Sub-total 102,000.00
Total tractor related supplies cost per year 220,800.00
Total supplies costs 1,396,875
T/H refers to time requirement for a tractor to accomplish each of the
specified activity
41 | P a g e
Repair& maint. (table 13) 0 391,878 411,472 432,046 453,648 476,331 500,147 525,154 551,412 578,983
Utilities costs (table 14) 412,500 433,125 454,781 477,520 501,396 526,466 552,789 580,429 609,450 639,923
Supplies cost (table 12) 1,396,875 1,466,719 1,540,055 1,617,057 1,697,910 1,782,806 1,871,946 1,965,543 2,063,821 2,167,012
Miscellaneous cost (table 14) 1,199,153 1,259,110 1,322,066 1,388,169 1,457,577 1,530,456 1,606,979 1,687,328 1,771,694 1,860,279
Total Operating 5,925,473 6,380,682 6,699,716 7,009,587 7,360,067 7,728,070 8,114,473 8,520,197 8,946,207 9,393,517
Increase in Operating costs 0 455,210 319,034 309,871 350,479 368,003 386,403 405,724 426,010 447,310
Working capital needed 364,168 255,227 247,897 280,383 294,403 309,123 324,579 340,808 357,848 0
Table 17. Forecasted production of each crop over the first 10 years
Crops 1 2 3 4 5 6 7 8 9 10
Fruit and vegetable Land area in Ha 110 110 110 110 110 110 110 110 110 110
Output per Ha (quint) 96 96 96 96 96 96 96 96 96 96
Total Output (quint) 10,560 10,560 10,560 10,560 10,560 10,560 10,560 10,560 10,560 10,560
Grapes Land area in Ha 50 50 50 50 50 50 50 50 50 50
Output per Ha (quint) 25 25 25 25 25 25 25 25 25 25
Total Output (quint) 1250 1250 1250 1250 1250 1250 1250 1250 1250 1250
Apple Land area in Ha 35 35 35 35 35 35 35 35 35 35
Output per Ha (quint) 30 30 30 30 30 30 30 30 30 30
Total Output (quint) 1,050 1,050 1,050 1,050 1,050 1,050 1,050 1,050 1,050 1,050
Table 18. Projected selling price of (at the farm gate price in Birr per quintal)
Crops 1 2 3 4 5 6 7 8 9 10
Fruit and
1200 1,260 1,323 1,389 1,459 1,532 1,608 1,689 1,773 1,862
vegetable
Grapes 4000 4,200 4,410 4,631 4,862 5,105 5,360 5,628 5,910 6,205
Apple 900 945 992 1,042 1,094 1,149 1,206 1,266 1,330 1,396
Table 19 Projected annual Sales revenues from each Crop (at the farm gate price in Birr)
Crops 1 2 3 4 5 6 7 8 9 10
Fruit and Price (Birr) 1200 1,260 1,323 1,389 1,459 1,532 1,608 1,689 1,773 1,862
42 | P a g e
vegetable
Production (quint) 10,560 10,560 10,560 10,560 10,560 10,560 10,560 10,560 10,560 10,560
Sales (Birr) 12,672,000 13,305,600 13,970,880 14,669,424 15,402,895 16,173,040 16,981,692 17,830,777 18,722,315 19,658,431
Grapes Price (Birr) 4,000 4,200 4,410 4,631 4,862 5,105 5,360 5,628 5,910 6,205
Production (quint) 1250 1250 1250 1250 1250 1250 1250 1250 1250 1250
Sales (Birr) 5,000,000 5,250,000 5,512,500 5,788,125 6,077,531 6,381,408 6,700,478 7,035,502 7,387,277 7,756,641
Apple Price (Birr) 900.0 945.0 992.3 1,041.9 1,094.0 1,148.7 1,206.1 1,266.4 1,329.7 1,396.2
Production (quint) 1,050 1,050 1,050 1,050 1,050 1,050 1,050 1,050 1,050 1,050
Sales (Birr) 945,000 992,250 1,041,863 1,093,956 1,148,653 1,206,086 1,266,390 1,329,710 1,396,195 1,466,005
Total Sales revenues 18,617,000 19,547,850 20,525,243 21,551,505 22,629,080 23,760,534 24,948,561 26,195,989 27,505,788 28,881,077
Table 20. Estimation of annual depreciation expenses Economic Depreciation Depreciation expenses
Life rate
Items costs
Store and bathing room 1,950,000.00 40 0.025 48,750.00
48,750
New John Deere 6100D Mfwd Tractor (Mexico Origin) 2,765,577 7 0.142857 395,082.04 1,611,688.76
Brand New Toyota Hilux Double cab 2,300,000 7 0.142857 328,571.10 1,562,938.76
Trailer 660,000 7 0.142857 94,285.62
Sino Truck model ZZ1257S4641W, 9720cc, HP 371 3,450,000 5 0.1 345,000.00
43 | P a g e
Sickles 25,000.00 5 0.2 5000
Axes 6,000.00 5 0.2 1200
Tape meter (100 m) 6,500.00 5 0.2 1300
Wheel borrow 17,500.00 5 0.2 3500
Shovel 1,800.00 5 0.2 360
Weighing scale 75,000.00 5 0.2 15000 58,348.00
Saw 1,600.00 5 0.2 320
Cutlass or Machete 120,000.00 5 0.2 24000
Spade hoe 9,000.00 5 0.2 1800
Local hand hoe 1,400.00 5 0.2 280 93,668
Spade 2,940.00 5 0.2 588
Digging fork 20,000.00 5 0.2 4000
Trovel 2,000.00 5 0.2 400
Laptop Computer 76,500.00 5 0.2 15300
Printers 7,600.00 5 0.2 1520
Shelf 15,000.00 5 0.2 3000 35,320.00
Managerial Chairs 47,500.00 5 0.2 9500
Guest Chairs 15,000.00 5 0.2 3000
Computer tables 15,000.00 5 0.2 3000
Total yearly depreciation 1,705,356.76
Years 1 2 3 4 5 6 7 8 9 10
Cash Inflows:
Collections from Sales 18,617,000 19,547,850 20,525,243 21,551,505 22,629,080 23,760,534 24,948,561 26,195,989 27,505,788 28,881,077
Cash Outflows:
Salaries payment 1,159,200 1,217,160 1,278,018 1,341,919 1,409,015 1,479,466 1,553,439 1,631,111 1,712,666 1,798,300
Wages payment 1,757,745 1,612,690 1,693,325 1,752,876 1,840,520 1,932,546 2,029,173 2,130,631 2,237,163 2,349,021
Repair & maintenance - 391,878.34 411,472.26 432,045.87 453,648.17 476,330.57 500,147.10 525,154.46 551,412.18 578,982.79
45 | P a g e
Utilities Expense 412,500 433,125 454,781 477,520 501,396 526,466 552,789 580,429 609,450 639,923
Supplies Expense 1,396,875 1,466,719 1,540,055 1,617,057 1,697,910 1,782,806 1,871,946 1,965,543 2,063,821 2,167,012
Miscellaneous Expense 1,199,153 1,259,110 1,322,066 1,388,169 1,457,577 1,530,456 1,606,979 1,687,328 1,771,694 1,860,279
Interest payment 1,966,974 1,770,277 1,573,579 1,376,882 1,180,184 983,487 786,790 590,092 393,395 196,697
Income Tax (30%) 3,156,719 2,907,460 3,163,977 3,437,904 3,715,042 4,031,186 4,330,683 5,111,085 5,435,231 5,772,634
Working capital 364,168 255,227 247,897 280,383 294,403 309,123 324,579 340,808 357,848 0
Total cash outflows 11,413,333 11,313,646 11,685,169 12,104,756 12,549,695 13,051,866 13,556,525 14,562,182 15,132,681 15,362,848
Net cash provided by operation 7,203,667 8,234,204 8,840,073 9,446,748 10,079,385 10,708,668 11,392,036 11,633,807 12,373,107 13,518,229
Cash inflows:
Cash Outflows:
cash inflows:
46 | P a g e
Cash outflows:
Repayments of loans 2,070,499 2,070,499 2,070,499 2,070,499 2,070,499 2,070,499 2,070,499 2,070,499 2,070,499 2,070,499
Net cash flows by financing 27,508,058 -2,070,499 -2,070,499 -2,070,499 -2,070,499 -2,070,499 -2,070,499 -2,070,499 -2,070,499 -2,070,499
Total N et cash flows 9,743,433 6,163,705 6,769,574 7,376,249 8,008,886 8,638,169 9,321,537 9,563,308 10,302,608 11,447,730
Cumulative cash flows 9,743,433 15,907,137 22,676,711 30,052,961 38,061,846 46,700,015 56,021,552 65,584,860 75,887,468 87,335,198
47 | P a g e
Total capital 14,736,045 21,520,119 28,902,732 36,924,507 45,592,938 54,999,040 65,103,966 77,029,830 89,712,036 103,181,515
Total Liability + Capital 33,370,536 38,084,111 43,396,225 49,347,501 55,945,433 63,281,036 71,315,463 81,170,828 91,782,535 103,181,515
Table 25. Projected Annual cash Flow Statement from Operations (all in Birr)
Years 1 2 3 4 5 6 7 8 9 10
Cash flows of Operating
activities:
Cash Inflows:
Cash collections from
18,617,000 19,547,850 20,525,243 21,551,505 22,629,080 23,760,534 24,948,561 26,195,989 27,505,788 28,881,077
revenues
Cash Outflows:
Salaries payment 1,159,200 1,217,160 1,278,018 1,341,919 1,409,015 1,479,466 1,553,439 1,631,111 1,712,666 1,798,300
Wages payment 1,757,745 1,612,690 1,693,325 1,752,876 1,840,520 1,932,546 2,029,173 2,130,631 2,237,163 2,349,021
Repair & maintenance - 391,878 411,472 432,046 453,648 476,331 500,147 525,154 551,412 578,983
Utilities Expense 412,500 433,125 454,781 477,520 501,396 526,466 552,789 580,429 609,450 639,923
Supplies Expense 1,396,875 1,466,719 1,540,055 1,617,057 1,697,910 1,782,806 1,871,946 1,965,543 2,063,821 2,167,012
Miscellaneous Expense 1,199,153 1,259,110 1,322,066 1,388,169 1,457,577 1,530,456 1,606,979 1,687,328 1,771,694 1,860,279
Interest payment 1,966,974 1,770,277 1,573,579 1,376,882 1,180,184 983,487 786,790 590,092 393,395 196,697
Income Tax (30%) 3,156,719 2,907,460 3,163,977 3,437,904 3,715,042 4,031,186 4,330,683 5,111,085 5,435,231 5,772,634
Working capital 364,168 255,227 247,897 280,383 294,403 309,123 324,579 340,808 357,848 -
Capital cost 23,288,917
Total cash outflows 34,702,250 11,313,646 11,685,169 12,104,756 12,549,695 13,051,866 13,556,525 14,562,182 15,132,681 15,362,848
Net cash provided by
(16,085,250) 8,234,204 8,840,073 9,446,748 10,079,385 10,708,668 11,392,036 11,633,807 12,373,107 13,518,229
operation
PVC 31,983,641 10,427,324 10,769,741 11,156,457 11,566,539 12,029,370 12,494,493 13,421,366 13,947,171 14,159,307
PVB 17,158,525 18,016,452 18,917,274 19,863,138 20,856,295 21,899,110 22,994,065 24,143,768 25,350,957 26,618,505
NPV (14,825,115) 7,589,128 8,147,533 8,706,681 9,289,755 9,869,740 10,499,572 10,722,402 11,403,785 12,459,197
PVC 141,955,409.68
PVB 215,818,087.87
NPV 73,862,678.18
48 | P a g e
BCR 1.52
NBCR 0.52
IRR 56%
49 | P a g e