Hootel SHAMSUDIN-1
Hootel SHAMSUDIN-1
Business Plan
For
Establishment of a Four-Star Hotel
At
Bole Michael Area
Addis Ababa City Administration
Project Investor:
Ato Shamsudin Abdullahi
January, 2025
Addis Ababa.
1
TABLE OF CONTENTS
Project Summary
CHAPTER ONE
INTRODUCTION
1.1 Executive Summary
1.2 Project Description
1.3 Project Objectives
1.4 Project Rationales
1.5 Project Investor
1.7 Government Policy
CHAPTER TWO
MARKET ANALYSIS
2.1 An Overview
2.2 Demand Analysis
2.3 Tourism Sector
2.3.1 Global Scene
2.3.2 African Scene
2.3.3 National Scene
2.4 Supply Analysis
2.41. Nationwide Hotels
2.4.2 Addis Ababa Hotels
2.4.3 Bole Michael Area Hotels
2.5 Target Markets
2.6 Market Prospect
2.7 Completion
2.8 Market Strategies
2.9 Price Structure
CHAPTER THREE
TECHNICAL ANLAYSIS
2
3.1 Location and Site
3.2 Physical Layout
3.3 Furniture and Furnishings
3.4 Office Equipment
3.5 Machinery and Equipment
3.6 Motor Vehicles
3.7 Raw Materials and Inputs
3.8 Manufacturing Process
3.9 Utilities
3.10 Service Process
3.11 Project Capacity
3.12 Project Implementation Schedule
3.13 Environmental Impacts
CHAPTER FOUR
ORGANIZATION AND MANAGEMENT
4.1 Organization
4.2 Human Resource
4.2.1 Shareholders
4.2.2 Management Staff
4.2.3 Operative Employee
CHAPTER FIVE
INVESTMENT ANALAYSIS
5. 1 Investment Capital
5.2 Sources of Finance
5.3 Financial Results
5.3.1 Profitability
5.3.2 Liquidity
5.3.3 Net Worth
5.3.4 Net Present Value
5.3.5 Payback Period
3
5.3.5 Financial Internal Rate of Return
Schedules
1. Basic Financial Assumptions
2. Working Capital Determination
3. Loan Repayment Schedule
Annexes
I Projected Balance Sheet
II Projected Profit and Loss Statement
III Projected Cash Flow Statement
IV Computation of Present Value
V Present Value Determination
VI Computation of Financial Rate of Return
Tables
1.Shamsudin Hotel Building Facilities
2.World Tourism Rankings by Country in Fifteen
3. Star Rated Hotels in Different Regional States
4.List of Star Rated Hotels in Addis Ababa
5. Existing Decent Hotels at Bole Michael Area
6. Proposed Rental Charges
7. List and Cost of Office Furniture
8. List and Cost of Office Equipment
9. List and Cost of Machinery and Equipment
10. List and Cost of Motor Vehicles
11. Project Implementation Schedule
12. Human Resource Requirement
13. Investment Capital
14. Sources and Pattern of Finance
4
Project Summary
Nationality: American
Address: Addis Ababa, Bole Sub-city, Wereda 01, House No. New,
Service ranges: 24 spacious rooms and restaurant for servicing foods and beverages,
License No.:
Project Location: Bole Micheal Area, Bole Sub-City, A.A. City Administration
5
Land Use Program and Facilities:
No. Facility
54 Standard Bedrooms
9 Premium Suites
Raw Materials and Inputs: Foodstuffs, beverages, cleaning stuffs, fuel and
6
Manpower: 46 persons with the following qualifications
7
Market Plan:
Total 38647
Sources of Finance:
Equity Capital - Birr 136.00 million (40%)
Bank Loan - Birr 204.00 million (60%)
8
CHAPTER ONE
INTRODUCTION
Addis Ababa. The hotel will be owned and managed by Ato Shamsudin
Birr 136.00 million and local bank loan of Birr 204.00 million.
The hotel building will have a total built-up area of 5,950m2 covering 2
the Oromos, Yemenis and other tourists are more attracted to this
market for hotel services. The existing hotels, pensions and apartment
houses are enjoying over 80% of their capacities as per market survey
Ethiopian Somalis both of whom noted for their mobility and high
The basic raw materials and inputs required in the course of hotel
operation are foodstuffs (meats and flour, short and long pasta,
vegetables and fruits, edible oils, sugar and salt, spices, coffee and
10
The hotel servicing processes entail, reservation, client reception,
business is profitable and liquid with after tax financial internal rate of
potentials,
11
This report is, therefore, the result of extensive research carried out to
very far from Rwanda Embassy in Addis Ababa and owned by Ato
and furnished, luxury, clean decode standard single and executive and
The facilities that the hotel building contain are shown in the following
table.
12
Table 1
Shamsudin Hotel Building Facilities
No. Available Facilities
1 2 Basements for parking
2 Ground Floor for shops
3 First Floor for reception, restaurant and kitchen
4 Second to Ten Floors for 90 Bedrooms with spacious areas
-
54 Standard Bedrooms @ 20 m2
27 Executive Suites @ 28m2
Premium Suites @ 43 m
5 Terrace for water tanks, laundry and store
Total
The hotel building will have its own standby generator, communication
and security facilities. All bedrooms will be spacious and furnished and
meet four - star class standards and withstand the existing and
13
To provide gainful employment opportunities for about 54
persons,
To ensure that the hotel visitors are given maximum due care and
and
14
There are all age groups of Somalis and Oromos that live, work
and temporarily visit Bole Michael and all these require catering
area. This segment forms a large and growing market for decent
places to feed, drink and spare their leisure time and thus the
Despite the fact that there are many hot hotels, pensions,
visitors who are faced with shortages luxury villa and hotel rooms,
15
The tourism sub-sector is a blood vine of development of all
female. Having stayed and worked for about 25 years in the United
running real estate development business. The high rising and star
rated i.e. 2 basements, ground plus ten floors and terrace hotel
owned by Ato Shamsudin. The hotel that has a total plot of land of
16
Valuing the importance of tourism as the sources of foreign currency
making the country among the top ten tourist destinations in Africa by
In order to achieve the aims, the Government has taken the following
positive steps:
industry,
parks,
17
Privatizing of the public hotels and tourism facilities including
310,
publications, and
18
CHAPTER TWO
MARKET ANALYSIS
2.1 An Overview
have triggered demand for travel and tour from those searching for
Spain (82.8 million), United States (79.6 million), China (62.9 million),
19
Germany (37.9 million), Thailand (38.3 million) and United Kingdom
As regard to Africa, there were over 62.7 million tourist arrivals in 2017
and this was an increase of 8.5% from 2016. The top 10 African tourist
Egypt (11.3 million), South Africa (10.5 million), Tunisia (8.3 million),
Algeria (2.8 million), Zimbabwe (2.6 million), Ivory Coast (2.0 million),
million).
Ethiopia has variegated and rich natural, cultural, historical and man-
20
systems, hotel and restaurant industry, tour and travel enterprises,
power and parks by the government and hotels, restaurants, clubs and
sustainable market for the existing and planned hotels and conference
tourist sites for seeing and enjoying wildlife, birds, mountains, water
falls, hot springs, Dallol life volcano, Simien Mountains Parks, Rock-
21
Hewn Church of Lalibela, the Holy City of Harar, Gondar palace, Blue
Nile Falls, Addis Ababa Museums, Axum obliques, and Arba Minch,
National Parks with rare animals in wild and 850 bird species would
peace and security are not threats and aggressive promotion are
than 81 countries worldwide and covering Asian (Middle East and Far
travel and tour operations and promising market for hotels and
many reasons.
The demand for hotel accommodations and services are always there
22
Presence of natural, cultural archeological,
23
Active operation of the Ethiopian Airlines with its increasing
supports.
and
poverty,
American countries.
24
international overnight visitors. This was an increase of 34% over
The same source also reported that the total revenues from tourism
major political changes in the Middle East and North Africa and natural
disaster in Japan. The table below shows the top fifteen world tourist
destinations.
Table 2
World Tourism Rankings by Country in Fifteen
Total Tourist Arrivals in 2023
Regions Arrivals Receipts Receipt/
25
13 Saudi Arabia Middle East 27.42 36.0 1,312
14 Japan Asia Pacific 25.07 20.2 993
15 Netherlands Europe 20.30 14.8 735
Source: World Tourism Organization
Africa namely Morocco, Egypt, Tunisia and South Africa with 14.52,
11.66, 9.37 and 8.48 million tourist arrivals, respectively; strong in East
Africa; and weak in Sudan, Cape Verde, Mali, Niger, Chad, Congo, Sao
reported by WTO.
23.37 billion from 160 million tourists by 2024 with continued annual
2029. The largest market and beneficiary in the travel and tourism
industry are the hotels, whose market volume projected at USD 10.60
26
The Growth and Transformation Plan (GTP) of the Democratic Republic
and evaluated star rated hotels in the country. Of these, 9 are five
star, 37 are four star, 70 are three star, 73 are two star and 139 are
one star hotels. The numbers and classifications of these hotels are
Table 3
Star Rated Hotels in Different Regional States
Hotel Ranks
Region 9 4 3 2 1 Tota
Oromia 1 4 16 22 22 65
Amhara 0 5 14 8 23 50
Dire Dawa 0 1 0 1 7 9
Afar 0 0 1 0 2 3
27
Bemi-Shangul Gumuz 0 0 0 1 2 3
Harar 0 0 0 0 3 3
Gambella 0 0 0 0 1 1
Tigray 0 1 2 4 11 18
SNNPR 0 5 3 4 15 27
evaluated star rated hotels in the country. Of these, 9 are five star
with total of 1,044 bedrooms and 1,701 beds , 21 are four star with
total of 1,774 bedrooms and 2,063 beds, 34 are three star with total of
1,914 bedrooms and 1,701 beds, 33 are two star with total of 1,405
bedrooms and 1,836 beds and 53 are one star with 1614 bedrooms
and 2,178 hotels. The numbers and classifications of these hotels are
Table 4
1 5 9 1,044 1,701
2 4 21 1,774 2,063
3 3 34 1,914 2,519
28
4 2 33 1,405 1,836
5 1 53 1,614 2,178
apartment houses. Currently, there are ten decent hotels with no lifts
operating at well over 80% occupancy rate and they are hardly
area, the following are relatively good and preferred for the Somali
local and foreign tourists. Of these, almost all are Somali Diasporas and
Table 5
Existing Decent Hotels at Bole Michael Area of Addis Ababa
Rent/Bed Night
(Birr) Telephone
No. Name of Hotel Single Double No.
room Room
1 Ye Afoli International Hotel 011-6
610203
29
5 Mubarak Hotel 011 6-
392727
932600
5 Golis Hotel
7 TZ Hotel 0924-005477
9 Nati Hotel
According to survey, there are three planned hotels including the hotel
The major market targets for Shamsudin hotel are domestic and
mobility and numbers have been increasing from year to year as well
30
serve as a terminal for private big buses that go to and coming from
the Somali Regional State cities, towns and villages for trade and
for chance to travel overseas, chewing chat and taking traditional and
2.7 Competition
The hotel is will face a fair competition with two new hotels under
completion with a leverage of having latest lift. All the exist are old
31
2.8 Market Strategies
hotel customers,
complaints.
competition.
Table 6
Proposed Rental Charges
(Birr)
Price/Bed/night Rate/Bed/ night
No. Bedroom Types (In USD) (In Birr)
1 Standard 30 3,600
2 Executive Suites 40 4,800
3 Premium Suites 55 6,600
32
Considering the newness of the hotel, having parking space and lift,
and good location and service components, the proposed hotel room
33
CHAPTER THREE
from Rwanda Embassy and put under its custody a total plot area of
515 square meters sharing a built-up area of 425 square meters for the
The site has not only easy access to basic utilities such as water,
the .
most ideal and strategic location for running hotel, pensions and
The area noted for its being a high concentration site of Somali
coming all over the European, American, African, Asian, and Middle
tea rooms and restaurants that all attract and suit Somalis, Muslem
Oromos and Yemen tourists with high mobility, trade and expending
34
cultures. The area ss also possesses a well-developed infrastructure
floors and terrace. The basements will provide adequate space for
will used for placing laundry, water tanks and keeping important stuffs.
The hotel building was beautifully designed involving and will be built
light required for the building. The construction cost of the building is
The building will be furnished with high quality local and imported
35
the list and cost of furniture and furnishing materials required for the
hotel.
Table 7
List and Cost of Furniture and Furnishings
(Birr)
No. Description Quantity Unit cost Total cost
I Office Furniture
Sub-total 81 470000
II Reception
36
Stools 4 2,000 8,000
Sub-total 10 443000
III Kitchen
Sub-total 16 470000
IV Restaurant
V Café
Sub-total 51 19000019
0000
37
VI Bedrooms
Sub-total 720000
Total 1440000
9,197,000.00.
Table 8
List and Cost of Machinery and Equipment
(Birr)
No. Description Quantity Unit cost Total cost
I Office Equipment
38
UPS 15 10,000 150,000
II Reception
Sub-total 8 400000
39
Kitchen wares 20 3,000 60,000
IV Café
0000
V Bedrooms
Sub-total 3 1500000
40
VII Miscellaneous 700,000
Total 17,086,00
41
3.5 Motor Vehicles
The hotel will require the following motor vehicles to execute its day-
to-day routines.
Table 9
Required Motor Vehicles
(Birr)
No. Description Quantity Unit cost Total cost
Total 5 182000001
8200000
The raw materials and inputs required in the course of running the
consumables.
3.7 Utilities
The required utilities for smooth operation of the project are electricity,
water, accessible road and telephone. The site selected has easy
access to all these utilities. The total power required is about 80 kW. In
42
43
3.8 Service Processes
The annual servicing capacity of the project is 27,000 bed nights at full
and this increases at 10% every year until 90% capacity is attained.
The project implementation would take six months for completing the
Table 10
Project Implementation Schedule
F M A 2 3 A
2 Trade registration
2 Loan Processing
44
5 Employee recruitment (one
month)
month)
being, animal lives and vegetation existing in the project area. Rather,
the country.
45
CHAPTER FOUR
4.1. Organization
Executive Management
Administration and Finance
Marketing and Sales
Front Office Operations
House Keeping
Food and Beverage
Engineering and maintenance
The main organs of the organization would be general manager, three
The section heads will be placed as per their qualification and interests
4.2 Management
46
experience and business insight to smoothly run the planned hotel
business.
for 54 citizens. The employees will be picked in the area based on their
Table 11
Human Resource Required
No. Positions No. of Monthly Annual Salary
Persons Salary/person
1 General manager 1 80,000 960,000
2 Administrator 1 60,000 720,000
3 Business developer 1 50,000 600,000
4 Electro mechanic 1 25,000 300,000
5 Office clerks 4 20,000 960,000
6 Accountant 1 30,000 360,000
7 Purchasers 2 20,000 480,000
8 Store keeper 1 10,000 120,000
9 Cashiers 2 15,000 360,000
10 Receptionists 2 15,000 360,000
11 Head waiters 2 10,000 240,000
12 Food and beverage officer 1 25,000 300,000
13 Head cooks 1 20,000 240,000
14 Assistant cooks 2 10,000 480,000
15 Coffee machine operators 2 6,000 144,000
16 Waitresses 10 5,000 600,000
17 Supervisor - housekeeping 2 6,000 144,000
18 Café workers 2 5,000 120,000
19 Cleaners 8 3,000 288,000
20 Drivers 3 5,000 180,000
20 Security head 1 5,000 60,000
47
21 Guards 4 5,000 240,000
Total 54 8256000
CHAPTER FIVE
FINANCIAL ANALYSIS
Table 12
Investment Capital
(Birr 000)
No. Asset Amount
Total 38647
The main investment components are building and civil work, land
48
together amounts Birr 314.756 million or about 92 percent of total
49
5.2 Sources of Finance
The total amount of Birr 340.00 million will be generated from equity
capital of Birr 136.00 million and local bank loan of Birr 204.00 million.
below.
Table 13
Sources and Pattern of Finance
(Birr 000)
No. Asset Equity Loan Amount
50
51
5.3.1 Net Worth
The initial equity capital of Ato Shamsuddin Birr 136.00 million will
increase to Birr 333.885 million in the fifth year and Birr 604.616
5.3.2 Profitability
expected to register a net profit of Birr 25.927 million rights from the
increase to Birr 55.374 million in the fifth year and Birr 62.468 million
by end of the tenth year. The average annual profit during the project
5.3.3 Liquidity
The project cash flow statement indicates that the project will not face
Birr 58.349 million in the beginning year. This amount will steadily
grow to Birr 214.395 million by the end of the fifth year and Birr
fund.
52
The computation of Net Present Value (NPV) of the hotel project is Birr
434.435 million.
recoup its total investment capital of Birr 340.00 million in about 6.2
years’ time.
53
Schedule 1
Shamsudin Hotel Project
Financial Assumptions
Sub-total 90 146853000
income)
income)
Sub-Total 314697150
Total 167,844,15
54
2027 70 117,490,905
2028 80 134,275,320
2029 90 151,059,735
2030-2034 100 167,844,150
Total 23639
2027 70 16,547
2028 80 18,911
2029 90 21,275
55
13. Supplies -Birr 150,000/year
56
25. Value Added Tax is beard by Customers -15%
57