BAR SEENAA Mole Project Final
BAR SEENAA Mole Project Final
BAR SEENAA Mole Project Final
November, 2020
Addis Ababa
1
APPLICATION LETTER
TO WHOM IT MAY CONCERN
Dear Sir/Madam;
We are here to request Land for investment with its license by name of our private
trading which it named BARSENA GENERAL TRADING PLC. It is found in 2011.
Since the establishment of BARSENA GENERAL TRADING PLC, we are exercising
different business activities so as to crate job opportunity for our society as well as
developing our financial capacity and making benefit the government also.
Dear sir/madam we are here today as we begun before participating on our country’s
development, we are looking for an opportunity which enables as to take over the
developments of our country through investment. Which it is too vast and can give better
job opportunity than any other that can keep the truck our begun development.
Hence, if your organization accepting our application, give us an opportunity and signing
the project agreement with achieved anticipated results BARSENA GENERAL
TRADING PLC will have self-motivated, energetic and experiences in business duties
and committed to undertake the intention of this investment program from design,
planning, implementing, monitoring and evaluation of the activities with responsibilities
to deliver the desired result of the project with required quality for targeted groups.
We are looking forwards your positive response!!
Better Cooperation for better development!
AHMEDNAAJI MUKTAAR
C/C BAR SEENAA PLC
2
I. Executive Summary ---------------------------------------------------6
1. Introduction --------------------------------------------------------------------6
1.1. General Background-----------------------------------------------------7
1.2. Objective of the project--------------------------------------------------7
1.3. Project Description ------------------------------------------------------8
1.4. Project Rationale ---------------------------------------------------------8
1.5. The Significance of the project -----------------------------------------9
1.6. Project Location ---------------------------------------------------------10
2. The Market Study ------------------------------------------------------------10
2.1. Market Analysis ---------------------------------------------------------10
2.2. The Demand-Supply Gap ---------------------------------------------11
2.3. Current supply of Mixed Use Building ------------------------------12
2.4. Future market or Demand of commercial Building rental--------12
2.5. Target customers -------------------------------------------------------13
2.6. Marketing Promotion and Strategy-----------------------------------14
2.7. Competition -------------------------------------------------------------14
2.8. The project facilities and Services plan------------------------------15
3. Technical Study --------------------------------------------------------------16
3.1. Description of the project Service/ Product mix -------------------16
3.2. Land Use Plan -----------------------------------------------------------17
3.3. Construction work and Technology ---------------------------------18
3.3.1. Construction schedule ----------------------------------------------18
3.3.2. Architectural Design & Layout ------------------------------------18
3.3.3. Structural Design ---------------------------------------------------19
3.3.4. Reinforced Concrete -------------------------------------------------19
3.3.5. Foundation Design --------------------------------------------------20
3.3.6. Construction Plan and process ------------------------------------20
3.4. Utilities -------------------------------------------------------------------21
3.5. Project Implementation-------------------------------------------------22
4. Organizational Structure ---------------------------------------------------22
4.1. Organization and Management ---------------------------------------22
3
4.2. Man Power ---------------------------------------------------------------22
4.3. Organizational Structure ----------------------------------------------23
5. Financial Requirement and Analysis -------------------------------------25
5.1 Fixed Investment --------------------------------------------------------26
5.2 Working Capital---------------------------------------------------------28
5.2.1 Operating Expense at full Capacity -------------------------------28
5.2.2 Operating Expenses --------------------------------------------------29
5.2.3 Pre-service Expenses -------------------------------------------------29
5.3 Financial analysis and Statements ----------------------------------30
5.3.1 Underlying Assumption ----------------------------------------------
30
5.3.2 Sources of Fund ------------------------------------------------------31
5.3.3 Bank Loan Repayment Schedule ----------------------------------31
5.3.4 Depreciation Schedule ----------------------------------------------32
5.4 Financial Statement ---------------------------------------------------32
5.4.1 Income loss/statement ----------------------------------------------32
5.4.2 Cash flow Statement--------------------------------------------------34
5.5 Financial Analysis ------------------------------------------------------34
5.6. Environmental Impact of the Project --------------------------------35
6. Monitoring and Evaluation-------------------------------------------------36
4
I. Executive Summary
1. Project name: Mixed use Building [mole]
2. project Type: Multipurpose service Commercial building
3. Nationality: Ethiopian
4. Project Owner: BAR SEENAA PLC
5. Project location: Addis Ababa City
6. Project composition: multipurpose Building (G+10) used for diverse
business centers like banking & insurance, super market, shops,
restaurant, café, beauty salon, Pharmacy, bed rooms and offices.
7. Premises Required: 1500 m2
8. Total investment Cost: 80,000,000 ETB is required from this
amount 30% or 24,000,000 ETB from owner equity and the rest
70% 56,000,000from bank loans.
9. Employment opportunity: for 36 to56 individuals on permanent
130 on casual basis
10. Social and Economic Benefit: provide better Building service,
employment opportunities, generation of income and benefits for
the urban people.
5
1. Introduction
1.1. General Background
The current fast and dynamic economic growth of Ethiopia especially in
urban area necessitates equivalent growth of building and construction
sector. The sector should expand rapidly to support the overall economic
development sustainable.
In the building sector of the economy, the multi- purpose in the one
becoming rapidly expanding in urban areas of the country, since
dynamic economic development of urban economy requires the
construction of these buildings in towns to support the growing of
business service sectors like supermarkets, Beauty salon, shops, offices
cinemas, Computer Center, Cafeterias, restaurant, assembly hall, guest
house and other activities.
Investment and property development play an important role in any
emerging markets or economies. Property generally comprises reside vial
houses and commercial real estate property (mainly mixed us building)
developed for rental business and sale. The property investment market
in Ethiopia remained under developed for several years. As a
consequence, the supply of residential houses and non-residential real
estate that can be used for residence, office space, shopping malls and
catering services in the urban centers of the country is
disproportionately low to cope with the growing demand in the country
spinning from the average growth in GDP of 5.5 percent over the last ten
years and population increase. The relatively good performance of the
macro-economy (real growth in GDP, low inflation rate and growth in
investment and export sector) has stimulated unprecedented investment
growth in the property sector over the last five years. The growth of
investment in the property market over the last five years in consistent
with the global experience suggesting that investment in the residential
6
and commercial property (real estate) is greatly influenced by the
performance of the macroeconomic conditions.
In general, a stable macroeconomic condition leads to economic and
business growth and develops investors’ confidence. This certainly spurs
large demand in the property market for office space, shopping malls,
catering services, apartment and residential houses. Following growing
demand trends, and with the expectation of high return on their
investment capital, large number of land developers pooled their
financial resources and invested in the property market.
To this effect, the owner of the envisioned Mixed Use Building BAR
SEENAA PLC planned to construct in Addis Ababa city and undertaken
this project study to check the market, technical and financial feasibility
of this project. The promoter is very ambitious and committed to realize
the project. Hence, he expects to get the necessary support from the city
administration to make the project to be operational.
Looking at the past trends and permits issues by the Government to the
construction of real estate properties including the mixed use building in
the major urban areas of the country especially in Addis Ababa one can
easily conclude that the momentum is more likely to continue. Besides,
the government policies and incentives for the private sector investment
are very promising that motivates the promoter to engaged in mixed use
building business.
1.2. Objective of the Project
The major goal of this project is to contribute towards the growth of the
trade sector in the city. Its specific objectives include the following.
To construct and develop modern shops, offices, and restaurant,
bedroom & cafeteria facilities that enable to provide standard services
to visitors.
To undertake trading and other refuted business activities that enable
to generate a reasonable to the invested capital.
7
To develop modern business center that would provide services of
international standard in order to attract foreign visitors and thereby
contribute towards the generation of hard currency for the country.
To create employment opportunities for the population in the city and
Contribute towards the beautification of the town through the
construction of modern building infrastructure and facilities.
1.3. Project Description
The long-term goal of the project is become the best choice in area and
its surrounding areas by creating a differentiated experience capitalizing
on personal service. The proposed project will have a total area of
1500m2, designed to reader a multipurpose giving business, which will
in turn plays significant role towards solving shortage of business center
in the city.
The owner plans the project to render banking and insurance, shopping
facility, bank and cafeteria services to create high quality class to satisfy
the interest of customers in the city. Based on environmental and other
considerations, the entrepreneur has determined the type and size of the
building which is already determined by the site; conceptual planning
and preliminary analysis have been carried out by analysts. In order to
attract its clients to the service, the project will develop high standard
shop & banking rooms and office of best choices and will also save best
quality restaurant and café, national and international dish and various
types of soft drinks.
8
In order to respond to the created environment, the town is in need of
major, basic and feasible urban projects to be developed.
The existing promising investment opportunities, the demands of service
need along with relatively sound investment support made by the
government in such kinds of feasible projects, compelled the project
promoter to initiate the multipurpose oriented business project to be
established. Despite the promising business opportunities of the city, the
trend on such kinds of investment found to be not sufficient. The
mismatch between the demand for and supply of such kind of services in
easily observed in the city.
Therefore, the existing shortage or absence in the supply of these
services, along with its commercial and administrative access, better
location and infrastructure access, escalating trend of urbanization and
business activities, thus it is with such reason that this project is
identified and proposed and assumed to be more profitable.
In general, the country’s decentralized state based economy, privatized
and free market economy; good governance creates a favorable
environment for the development of investment for private investors.
9
B. Employment opportunity
One of the problems that our country faced is unemployment. Therefore,
the current objective of the government is working on tackling the
problem of unemployment and fostering the development process either
through creating self-employment or employment in other organization.
Hence, this project will hire 56 individuals and more than 130individuals
during construction.
C. Sources of Social service
In addition to serving as a source of employment and income for the city
Administration, the project renders social services for different group of
people. Hence, it also provides the following services;
Serve as a source of mental satisfaction for the different users,
Since, the center encompasses different recreational areas; it will
divert the attention of the users from different evil deeds.
It deemed to minimize the demand for shops and other bundles of
services in the area.
Furthermore, it serves as the pilot experience and ground for other
investor to enter in to such kinds of urban development. It also
contributes on the efforts made on as a character given building for
physical development pattern of the city scope.
1.6. Project Location
As aforementioned on the introductory part the envisioned project is
intended to be located in Addis Ababa city. Addis Ababa is located at an
elevation of 2,200 meters (7,200fit) and is a grassland biome, located at
901’48’’ N380 44’24’’ E/ 9.030000 N 38.740000E. The city lies at the foot
of mount Entoto and forms part of the water shed for the Awash River.
2. The market Study
2.1. Market Analysis
There are a number of factors which affects the demand of standardized
mixed use building. Of these factors, the most important to have
10
influence is population growth and the level of income. The currently
expanding industrial park around the city and the city has been inviting
skilled and unskilled labor forces to the town; in addition, the number of
both government and non-government offices has been increasing. Above
all the increase in the number of population of the city increases for the
provision of different services. Nowadays, most of the private business
organizations need their own small-medium offices in order to give their
services and provide their products, and they prefer the place that found
with suitable infrastructure and service.
As clearly indicated in the introductory part of this proposal, the market
demand gap for mixed use building in the city is not clearly understand
there is wider gap for such demand as many merchants, organizations
are flouring to the city every day. From prior business experiences, the
demand of mixed use building in Addis is very high and hence the
demand and the supply gap is very wide.
2.2. The Demand-Supply Gap
Addis Ababa is situated in very center of Ethiopian for the whole country
business, which is highly known for its surrounding industrial park and
also a major business center and commercial route that attracts
thousands of business travelers. These are also the most important
groups of potential customers that include both the local and foreign
tourists and the modern business community who choose services that
range from economic to high class standards. These groups would also
choose a healthy comfortable climate that combines a more traditional
type with that of modern shops, offices, bedrooms restaurants and
cafeterias.
Over the last decade, there has been a significant growth in the number
of local and international trades across the country. This increase is
mainly associated with the stimulation of economic activist and partly
due to an increase in the flow of international and local traders in to the
town. Since Addis Ababa is an important commercial center in addition
11
there is a significant increase in business activates and hence increasing
the number of traders to the town. Even though there is a lack of
quantitative estimates that depict the actual demand and also the
annual growth rate Hotel facilities and urban commercial facilities are
scarce in the city. They are mostly villa type premises modified as show
rooms and sailing posits. As a result, there is a large gap between the
developed and that of the supply for modern bed rooms; Bank and
cafeteria accommodation hence this project would not face any problem
of demand scarcity for it business Centre and it would provide good
service to customers.
2.3. Current Supply of Mixed Use Building
Commercial building/office sector has shown a dynamic change in the
past few years. The reason for this could be rapid economic growth and a
supporting public infrastructural development. Other factors relevant in
the specific case of commercial buildings are the large increases in
national and international businesses, particularly firms in the services
sector.
The business of multipurpose buildings in Addis is booming highly due
to the recent rapid growth experienced in Ethiopia. As a result, a good
number of local and international organizational are coming in place.
Government offices which used to operate in limited spaces all over the
city are also concentrating on leasing new and modern buildings.
Increasing numbers of international organization and NGOs which in the
past had typically converted residences into office space are now moving
towards renting whole floors or even multiple floors in modern city-center
commercial buildings.
2.4. Future Market or Demand of Commercial Building Rental
The demand for office space is a derived demand because firms rent
space as an input to the production of services or goods they provide to
businesses and households in the local regional or national economy.
12
Following our survey of office space users in the city are mainly firms
providing banking, cafeteria and restaurants, bed room, supermarkets
service, computer Center Crevice. The different customers for commercial
buildings also include shops and offices that are currently renting out to
provide their goods and services.
Future demand for office space is actually driven from growth in number
of offices in the city which in turn is influenced by the macro-economic
growth in the country. Following the government five-year growth and
transformation plan (GTP), the Ethiopian economy is expected to
increase by 11% for base case scenario and 14% under the optimistic
case scenario. Assuming that demand for office space is directly related
to the growth in the economy, the forecast for office space demand is
shown in the following table;
Table:1 Office Space Demand Forecast
Years Office space demand under base case Office space demand under high
economic case economic
Growth Growth
2010/2011 9,916,543 11,304,859
2011/2012 11,007,363 12,057,416
2012/2013 12,218,173 12,953,878
2013/2014 13,562,173 13,963,577
2014/2015 15,054,011 14,554,534
2015/2016 16,709,952 14,987,431
Source: Estimation based on GTP’s forecasted Ethiopian Economic
Growth.
2.5. Target customers
The target customers of this envisaged project include: -
1. Business Community
2. Nearby business organization
3. The government bureau
4. Small accounts(SOHO) SME
5. Nongovernmental organizations
13
2.6. Marketing Promotion and Strategy
In order to penetrate and gain considerable market share, one of the
major marketing strategies for the project is consistently rendering
quality service to its tenants. Due emphasis must be placed on improving
quality of service and facilities. The major marketing strategies to
promote the project and gain considerable market share include:
Advertising through different means focusing on the existing service
and facilities,
Promote in association to the key location and nearby business
Working on sustained promotional work,
Working on public relations to reach and influence key personas
and organization with a capacity of making decision,
Keeping the quality of its service/ facilities and consistently
improving with changing situations.
Seasonal discount pricing different others customer centric
marketing strategies will be used by the company.
2.7. Competition
There are different forms of competition that may face the envisaged
mixed use building. These are price and non-price based competition.
Moreover, there are different competitors that will compete with the
project either directly or indirectly. But the mixed use building under
discussion has diversified marketing strategies that could enable it come
up with the different competitors in the market. Moreover, it will
frequently conduct competitors research which focuses on, the strength
and the weaknesses, the different competitors’ strategies, the techniques
they use in rendering the service, their customer handling methods, and
others. Generally, the project has many other projects all over Ethiopia
which compete with it.
14
In order to provide mixed use business center building services of a high
standard, it has been planned to construct and develop the
infrastructure and facilities that would viable to meet the requirements of
an international standard business center. Accordingly, various
buildings and facilities will be constructed phase by phase starting with
the most needed ones that are essential to commence the operation of its
business activities. With the completion of construction, the building will
provide a combined service such as shops, bedroom, restaurant and café
service as well as modern business center that primarily serve its guests
and major clients.
Table:2 The plan is that the ground will be partitioned in to different
rooms:
Building Description UOM Unit price
in Birr
Basement Parking and warehouse car
Ground Supermarket, Pharmacy, Banking, Insurance Laundry M2
1st floor Shopping center, M2
2nd floor Shopping center, M2
3rd-floor Computer Center, Beauty salons(man and women), M2
4th floor Cafeteria & Restaurant(Modern M2
and traditional, Coffee Shop,
5th floor Different governmental, NGO & other private business M2
organization offices
6th floor Multipurpose Assembly hall, M2
7th8the& Bedrooms service or apartment and other M2
9thfloor
10th floor Office of the building administration M2
Total
Since the project will be engaged in mixed building the main sources of
its annual revenue would be from the rental of building spaces such as
shops, offices, and banking, café & restaurant bedrooms. Therefore, the
sources of revenue have been classified in to one category namely the
rental of banking & supermarket, offices, shops, bedrooms restaurant
and café based on these classifications. Based on the market price of
similar mixed use building in the area, the envisioned buildings set the
15
following fair price (Before VAT) for its service, hence when the building
construction fully get operational it is assumed to generate a yearly
income of ETB 44,865,000.00
3. Technical Study
3.1. Description of the project Service/ Product mix
The envisioned mixed purpose building will provide different rental
services to the different customer groups for different purpose. The
building will have basement, ground and eight floors. The purpose of the
building explained as follows;
The ground floor, first floor second floor and third floor designed
for different business centers like banks, supermarket, beauty
salon(man and women), Computer center, pharmacy, internet
café, boutiques, different shops and other business activities,
The fourth floors designed for Cafeteria & Restaurant(Modern and
traditional, Coffee Shop,
Fifth floor is designed for Different governmental, NGO & other
private business organization offices,
Sixth floor is designed for Multipurpose Assembly hall,
From 7th – 9th floors are designed for bed room or apartment or
for other services.
Tenth floor if designed for Office of the building administration,
Also Besides the buildings will have enough parking facility for its
customers and green area in its compound.
16
Table: 3 land utilization Plan
SN Description Land M2
Grou 1st 2nd 3rd 4th 5th 6th 7th 8th 9th 10th
nd
1 Building G+10
(G+10)
1.1 Basement 1320
1.2 Ground
1.3 First floor 1320
18
building adjustments were made to the bays if specific layouts are
necessary. The frame was made up of a grid with repeating standard
structural bays. Included in the structural system are bay sizes, shape
and size of structural members, floor compositions and curtain walls.
These elements were established to resist gravity ad lateral loads as
appropriate.
The gravity load design was completed for two frames; one of structural
steel and one of reinforced concrete. The structural steel frame was
chosen for further design based on cost per square foot, local availability
of material and constructability considerations, such as erection and
fabrication. The steel system was then designed for lateral loading with
necessary adjustment being made to framing.
19
superstructure through the columns. The foundation design conducted
by the project team consisted of the selection of foundation type,
determination of the bearing capacity and the design for typical interior
and exterior spread footings.
3.3.6. Construction Plan and process
The project team developed a coordinated project schedule and
construction plans that would reflect the expectations for an actual
construction project. The project schedule was developed using the
preliminary designs given to the project team.
Additionally, the group considered typical construction activities and
durations taken from similar construction projects as well as realistic
constraints on building development. For instance, it is necessary for the
structural frame to be completed before concrete can be placed for the
slab on deck. Hand drawn construction plans detailing site entrances
and storage areas were coordinated with the project schedule to give the
reader visualizations of the construction site set up through various
periods of the construction process.
The construction process for this project is normally a disjointed three
mages development by which the conceptualized need of the promoter of
this project is translated into a functional facility that will meet their
needs in terms of time, cost and quality.
Based on a general program of the project owners the consultant who is
going to be hired makes site studies, develops structural designs,
prepares drawings and specifications, determines quantities involved and
estimated the resultants costs. All these activities will be done in the first
phase of the project which is the design stage after the document are
produced by the designers have been received, and the works secured
the project is supposed to enter the tendering stage. At this stage
contractor study the project document analyze and subsequently
determine the construction methods, built up their unit rates and
submit their bids for the works. The promoter of this project intends to
20
compare the bids and award the contract for the lowest responsible
bidder. This, is of course, presupposes that the favorable proposal does
not exceed the allocated budget.
After the award is made and the contract signed between this project
owner and the contractor, the project constructor is expected to prepare
and submits a detailed construction program which includes material
schedule, manpower requirement and cash flow forecast.
After the award is made and the contract signed between this project
owner and the contractor, the project constructor is expected to prepare
and submits a detailed construction program which includes material
schedule, manpower requirement and cash flow forecast.
3.4. Utilities
A number of utilities world be put in place in order to ensure smooth
functioning of the project. These utilities include:
Water Supply,
Supplementary Electricity supply.
Telephone line Internet Broadband
Fuel, Oil and lubricant
Drainage Facility
3.5. Project Implementation
The project’s implementation is expected to take 24 months. The major
activities include Bank loan processing construction of the building,
cleaning the area around the building, Procurement of equipment’s and
start rendering services. The time schedule for the above matured major
activities is presented below:
Table:4 project Implementation schedule
SN Activities Date
1 Land request processing April-Jun, 2019
2 Land approval July, 2019
3 Bank loan processing June-July 2019
21
4 Site Development August 2020
5 Building and construction work August/2020-December 2021
6 Preparation for service January, 2022
7 Service execution February, 2022
4. Organizational Structure
4.1. Organization and Management
The organizational structure should be in a way that the company able to
achieve its objectives as well as the satisfaction of standard requirement.
In addition to this, the structure should fit the dynamics of all customers
in the building ranging from small business to large tenants.
Owner
22
General Manager
24
Works in collaboration with general service to make sure tenants
are well served.
5. Financial Requirement and Analysis
The financial resource is a prime resource for undertaking any activities.
Hence for implementing this mixed use building a total of 80,000,000
ETB is required. From this 30% or 24,000,000 birr will be covered by the
promoter of the project while the rest 70% will be covered through loan
from bank at the prevailing interest rate.
Therefore, the said amount of finance is needed for undertaking the
following.
25
SN Description Measurem Qty Unit cost in Birr Total cost in
ent Birr.
1 Generator Unit 1 200,000.00 200,000.00
2 Carpentry tool box Set 1 40,000.00 40,000.00
3 Electrician tools box Set 1 35,500.00 35,500.00
4 Plumber tools kit Set 1 12,300.00 12,300.00
5 Fire extinguisher Unit 15 6,000.00 90,000.00
(Security Equipment)
6 Total 377,800.00
C. Vehicle
Table:7
SN Description UOM Qty Unit Cost in Total cost in Remark
Fr. Birr
1 Mini-Bus Unit 2 600,000.00 1,200,000.00 Duty Free
Total 1,200,000.00
D. Office Equipment’s
Table: 8
SN Description Measurement Qty Unit cost in Total cost in
birr Birr
26
5.2. Working Capital
5.2.1. Operating Expense at full Capacity2
a. Salary Expense
Table:9
SN Position No Qualification Monthly Annual
salary in salary in
Birr Birr
1 General manager 1 BA in management 3000 36,000
2 Building Admin 1 BA in Acct/Mgt 2500 30,000
3 Secretary 2 10+2 in secretariat science 1000 24,800
4 HRM Officer 1 10+2 in HRM/Management 950 11,400
5 Technical and 1 Diploma in building maintenance 1500 18,000
maintenance manager
6 Finance head 1 BA in Accounting 2500 30,000
7 IT Technician 2 Diploma in computer science/IT 1150 27,600
8 Marketer 1 Diploma in marketing 1150 13,800
9 Accountant 1 Diploma in accounting 1150 13,800
10 Guards/Security 8 Basic 500 48,000
11 General Service head 1 Diploma in Management 1500 18,000
12 Purchaser 1 Diploma in purchasing &Sup Mgt 1150 13,800
27
13 Electrician 1 10+2 in general electricity 1000 12,000
14 Plumber 1 10+2 in general mechanic 1000 12,000
15 Casher 2 10+1 in bookkeeping 850 20,400
16 Cleaner 5 Unskilled 450 27,000
17 Maintenance officer 2 10+2 in General mechanic 1000 24,000
18 Driver 2 10 completed 850 20,400
Total 34 401,000
Benefit (20%) 80,200
Grand Total 481,200
28
2 Licensing fee and others
Total 50,000.00
30
8 6,776,927.90 3,241,177.73 10,018,105.63 13,553,855.83
9 6,776,927.90 2,917,059.96 9,693,987.86 6,776,927.93
10 6,776,927.90 2,625,353.97 9,402,281.87 0
31
Table: 16 Mixed use Building Profit/Loss Statement
Revenue Year 1 Year 2 Year 3
Rental Income 28,560,000.00 38,240,000.00 44,865,000.00
Expenses
Salary Expense 481,200.00 625,560.00 721,800.00
Operating Expenses 2,534,446.10 3,294,779.93 3,801,669.15
Deprecation Building 7,777,363.5 7,777,363.5 7,777,363.5
Deprecation Bld. Machineries 37,780.00 37,780.00 37,780.00
and Equip.
Deprecation of Vehicle 60,000.00 60,000.00 60,000.00
Deprecation office Equip 14,390.00 14,390.00 14,390.00
32
5.4.2. Cash flow Statement
Table: 16
Year Year 0 Year 1 Year 2 Year 3 andafter
Equity Capital 24,000,000.00
Loan principal 64,072,194.24
Net sale 28,560,000.00 38,240,000.00 44,865,000.00
Total Cash in flow 91,769,279.03 28,560,000.00 38,240,000.00 44,865,000.00
Cash payment
Salary Expense 0 481,200.00 625,560.00 721,800.00
Investment 67,769,279.03 0 0 0
Pre operating Expense 50,000.00 0 0 0
Operating Cost 0 2,534,446.10 3,294,779.93 3,801,669.15
Loan repayment 0 13,553,855.80 12,875,775.63 12,265,890.86
Lease payment 0 30,000.00 30,000.00 30,000.00
Tax payment 0 3,254,367.75 6,090,383.65 8,244,579.21
Total payment 67,819,276.03 19,853,869.65 22,916,499.21 25,063,939.22
B. Pay-Back Periods
33
The investment cost and income statement projection are used to project
the pay-back period. The building’s total investment will be fully
recovered at the 5.2 year of operation.
B. Evaluation
The project promoter evaluates the on-going process of the project at
each phase of implementation. Even if joint evaluation conducted at the
end of the project, the engineering estimation of bill of quantity is the
basic tool of project success evaluation. This evaluation will be based on
the agreed upon project document.
35