Cal State Fullerton Walmart Expansion Analysis Final Project Part 1 Case Study

User Generated

FFEBFR08

Business Finance

Cal State Fullerton

Question Description

Help me study for my Management class. I’m stuck and don’t understand.


Imagine that you have been hired as a data analyst for Walmart. The Walmart executive team has asked you to gather data that will assist them in determining if this foreign market is a viable option for a Walmart expansion. You will continue to research the same region you have chosen to expand to in your previous MBA courses. Please refer to the Walmart Case StudyLinks to an external site. for the list of available regions. (CASE STUDY ATTACHED) 

Your Final Project will be comprised of two parts. In Part 1 you will be required to gather and analyze data for your case study paper. 

Walmart Expansion Analysis Final Project, Part 1: Walmart Case Study Paper 

You have been tasked with collecting and analyzing key data points that will assist Walmart in their decision to expand to your chosen region. In Part I, you will gather data from various sources, use the tools learned throughout this class to analyze data, and determine the best way to present this data to the Walmart executive team. Finally, you will make a recommendation on whether or not this foreign market is a viable option for a Walmart expansion.

Note: It is OK to not recommend an expansion to your chosen region. Just be sure to justify your recommendation.

Step 1: Data Collection
As a data analyst, you will be required to locate data from multiple sources. You are expected to identify additional data sources that will be useful in your analysis.

Accessing Walmart’s annual report:
You can find Walmart’s most recent annual report on their Financial Information (Links to an external site.) page (ANNUAL REPORT ATTACHED). You can use the annual report to gather additional international data.

Here are some examples of data that may be useful to an analyst:

  • Under “Item 1: Business,” in the “Walmart International      Segment,” you may wish to gather data for retail unit count and retail      square feet for all available fiscal years for the country or continent      closest to your region. For example, if you are looking to expand in      Egypt, you will use the data for Africa.
  • In the “Item 2: Properties” section of the report, you      may wish to gather data for the owned and leased properties for the      country or continent closest to your region.
  • In the “Results of Operations” section of the report,      look for “Walmart International Segment.” You may wish to gather data for      net sales, operating income, and unit counts at period end for all      available fiscal years.

You will likely need to gather more data to make your case. You are encouraged to seek out additional data points that will assist you in your analysis. Other data points you may want to consider include, but are not limited to

  • Gross national income
  • Population and demographic data
  • Key economic metrics, including current economic      status, inflation, etc.
  • Labor market data, including average wage, unemployment      rate, cost of living, etc.
  • Market environment
  • Foreign exchange
  • Credit environment outlook

Here are some suggested databases to get you started. These databases may not have all the information you need to make a full evaluation. You may need to conduct your own research to find useful databases that house the data you need to conduct your analysis.

Step 2: Analyzing the Data
Now that you have gathered your data, you will need to determine the best way to compile the data for analysis. Using the tools and skills you have learned in this course, create graphs and tables that will assist you in making sense of the data. You will use these tables to assess the data and support your analysis.

In your paper,

  • Summarize the background of the country or region,      including what makes it unique and why it is a viable option for Walmart      expansion.
  • Assess the data sets and include any charts or graphs      used in your evaluation. 
    • Measure outlook sales, interest, and other trends to       make a determination on the regional outlook. Is the outlook improving,       remaining stable, or deteriorating? For example, how will this expansion       affect sales trends, interest cost trends, etc.?
    • Calculate whether Walmart will have favorable or       unfavorable currency translation adjustments. For example, how strong is       the country’s currency against the U.S. dollar?
    • Create revenue projections and sales projections based       on the data. Consider the currently translation adjustments in your       projection.
    • Propose a recommended course of action based on your       interpretation of the data.

The Walmart Expansion Analysis Final Project, Part 1: Walmart Case Study Paper

  • Must be 8 to 10 double-spaced pages in length (not      including title page, reference pages, or tables and graphs) and formatted      according to APA      Style (Links      to an external site.) as outlined in the Writing      Center’s APA      Formatting for Microsoft Word (Links to an external site.) resource.
  • Must include a separate title page with the following: 
    • Title of paper in bold font 
      • Space should appear between the title and the rest of        the information on the title page.
    • Student’s name
    • Name of institution (University of Arizona Global       Campus)
    • Course name and number
    • Instructor’s name
    • Due date
  • Must use at least five applicable industry and company      sources in addition to the course text.

Unformatted Attachment Preview

Walmart Case Study Walmart today is a global retail giant. According to Carbonara (2018), Walmart is the world’s largest retail company with continued plans for global growth. There are many competitors, one of which is Amazon. How will Walmart continue to be a global giant in the years to come? In order to maintain the market leader position Walmart will be required to continually look for ways to out grow its’ global competitors (2018). In order to understand Walmart and where they are today and what tomorrow holds, it is important to understand their foundation. “Sam Walton opened his first five-and-dime in 1950. His vision was to keep prices as low as possible” (Wilbert, 2018, para1). Walton opened the first Walmart in early 1960’s in Roger, AK (2018). One thing that has and will always remain a key component for all Walmart stores is to keep expenses low. There has always been a mentality behind the vision of Walton to demand that employees always keep costs to a bare minimum (2018). On average, “Walmart saves a typical American family of four about $2500 a year. That’s about what a family of four gets from the government in food stamps. That makes Walmart a major antipoverty force in the United States” (Kestenbaum, 2017, para3). Another factor to consider when thinking about Walmart is that “since 1990, the global rate of poverty has been cut by two-thirds. That’s the sharpest decline in human poverty in all of history, more than one billion people have been lifted out of poverty during that period and Walmart is a major force in that effect” (2017, para 3). Today, Walmart has grown considerably and continues to expand. Just to get an idea of how large this retail giant is: • Walmart employs 1.6 million people. • Walmart has 6,200 retail outlets. In contrast, Home Depot has 2,040. (Wilbert, 2018, Para4) One might question, what does Walmart do to continue to be successful and keep costs to a minimum? There are several things that this retail giant has incorporated into the operations. First, “Walmart became the first major retailer to demand manufacturers use radio frequency identification technology (RFID). The technology uses radio frequencies to transmit data stored on small tags attached to pallets or individual products. RFID tags hold significantly more data than bar codes” (Wilbert, 2018, para6). Another interesting fact is that “Walmart is the single most important pipeline distributing wealth from rich countries to poor countries” (Kestenbaum, 2017, para3). One concern pertaining to Walmart is how the employees are treated. It is well known that Walmart not only pays low wages, but they also will cut corners (Kestenbaum, 2017). Walmart tends to hire mostly part-time workers (2017). Some may even say that Walmart “pay their workers poverty wages” (2017, para 4). There have long been ethical concerns in how Walmart operates and manages their employees. Case Study Assignment Throughout your MBA program you will be covering various subjects as they relate to business. You will initially have an opportunity in this class to create and build your own Walmart in a new global location. Your choices of location include: Czech Republic, Egypt, New Zealand, Peru, Philippines, and United Arab Emirates. As you progress through each course in the program you will build upon your case study for Walmart. The purpose of this Walmart Case Study is to give each student an opportunity to apply subject matter from each course in the MBA program to an ongoing strategic development. The knowledge gained on the case in each course will be cumulative. The knowledge will assist the student in demonstrating his or her ability to conduct critical analysis and decision making across a wide range of subject matter throughout the MBA program. Methodology The case is based upon past and current information about Walmart and the country of destination. 1. Each student will select a country to develop his or her case from. The student will use the same country in each course of the MBA program. 2. The student will be responsible for gathering as much information as needed that will help the student with determining the course of action that Walmart should pursue in the company’s quest to growth and meet the needs of international markets. References Carbonara, P. (2018, June 6). Walmart, Amazon top world’s largest retail companies. Forbes. Retrieved from https://www.forbes.com/sites/petercarbonara/2018/06/06/worlds-largest-retail-companies2018/#55ead67213e6 Kestenbaum, R. (2017, May 18). Is Walmart good or bad for America? The question may be outdated. Forbes. Retrieved from https://www.forbes.com/sites/richardkestenbaum/2017/05/18/is-walmartgood-or-bad-for-america/#2508388022ae Wilbert, C. (2018), How Wal-Mart works. Retrieved from https://money.howstuffworks.com/walmart.htm
Purchase answer to see full attachment
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

Explanation & Answer

View attached explanation and answer. Let me know if you have any questions.

RUNNING HEAD: WALMART CASE STUDY PAPER

Walmart Expansion Analysis Final Project, Part 1: Walmart Case Study Paper

Student’s name
University of Arizona Global Campus
Course name and number
Instructor’s name
Due date

1

WALMART CASE STUDY PAPER

2

Walmart Expansion into Egypt
U.S.-based multinational corporations struggle to penetrate some foreign markets, and
Walmart is no exception. Cultural differences, unique demographic characteristics, and legal
regimes contribute to their global expansion challenge—countries in the Middle East and
Northern Africa present strategic challenges amidst substantial growth opportunities. Walmart
has struggled to operate in India but can successfully enter the Egyptian market if it understands
it well. The Company should base its entry strategies on the country’s demographic, economic,
and socio-cultural factors affecting retail business. This paper summarizes Egypt’s background
detailing these factors and explaining why it is a viable option for Walmart.
The Country’s Background
Egypt is a country located in North-Eastern Africa. It is the Arab World’s most populated
country but second in Africa. A more significant proportion of the country’s population lives
along River Nile due to limited arable land in other areas. Egypt’s population proliferated at
2.1% from 1989 to 2018, but the growth rate now stands at 1.9%, indicating two million people
are added to the population each year (Assaad, 2020). The country’s population is about 104
million, projected to hit 160 million by 2050 and slightly over 200 million by 2080. One possible
explanation for this rapid growth is the high fertility rate (approximately 3.3 births per woman),
which exceeds the population replacement rate (about two births per woman). Another defining
characteristic of the Egyptian population is that majority are young people – approximately 62.4
million (60%) of Egyptians are younger than 30 years old (Krafft, 2020). Thus, the country’s
population is likely to grow over the next century.
Egypt is not immune to economic challenges associated with rapid population growth.
According to Ma et al. (2021), the growing population will pressure the country’s already

WALMART CASE STUDY PAPER

3

strained economic resources. Youth unemployment remains a significant challenge for the
economy, with 33% of Egyptians living below poverty. The country experienced a youth bulge
that overwhelmed the labor market, leaving 30% jobless young people (Assaad, 2020). The
burden on the labor market reduced over the past five years due to continued modest economic
growth. The COVID-19 pandemic slowed down economic growth from 5% before the pandemic
to 2% in 2020. The pandemic adversely affected the tourism sector, which employs 10% of
Egyptians and contributes 6% of the gross domestic product (GDP) (World Bank, 2020). Natural
gas prices have plummeted, decreasing government revenue and household income. Worse still,
the high fertility rate means a high dependency ratio, increasing health risks for women and
children, eroding life quality, and slowing economic recovery. The pandemic exacerbates
preexisting health risks for women and children, making employment terms more stringent. The
country’s youthful population implies that macroeconomic indicators are likely to change in the
coming years. COVId-19 has forced some businesses to close permanently, increasing the
percentage of unemployed youth in the population.
The country’s modest economic growth followed by the downturn occasioned by the
pandemic is suitable for foreign investment. President Abdel Fattah al Sisi’s regime embarked on
an economic development plan that yielded modest growth and propelled the economy forward.
One strategy the government has pursued is the private sector’s engagement in economic
development, opening a door for foreign investors. The government also encourages foreign
direct investment through partnerships with local firms, including local retailers.
However, one challenge that foreign investors must prepare for is cultural distance.
Egyptians primarily speak Arabic, but French and English languages are also used. It means that
foreign firms, especially from the U.S., may experience language barriers, requiring translation

WALMART CASE STUDY PAPER

4

services or learning Arabic. Egypt is a culturally distant nation, which has many implications for
Walmart. Egypt is a high-uncertainty avoidant nation; people are risk-averse, following
established codes of conduct, few accepted behaviors, no deviation from accepted norms, and
low tolerance to new ideas (El-Zayaty, 2018). Thus, foreign managers make business deals and
negotiate contracts through trust and relationship building.
Workplaces are also characterized by high-power distance as employees accept unequal
distribution of authority. Foreign managers should know their employees look up to them for
direction and guidance and cannot do something that deviates from established goals.
Institutional collectivism is highly embraced, with familial and religious ties determining loyalty.
Decisions are made mainly through consensus since they are binding to all employees. Work
relations entail encouraging employees to be timid, soft, and submissive to their managers,
embracing concession over confrontations (El-Zayaty, 2018). Lastly, Egyptians prefer preserving
the past and present to concentrating on the future. This low future orientation means that
employees enjoy routine work and would resist new ideas. Excellent performances are rewarded
collectively based on group achievement and not individual ranking. Therefore, a company that
wants to enter Egypt must make decisions informed by these demographic, political, economic,
and socio-cultural factors.
Why Egypt Is a Viable Option for Walmart Expansion
Egypt is the largest market in the Middle East and Northern Africa (MENA) region.
Based on the demographic characteristics, it could be argued that Egypt is the largest market in
the region and the fastest growing. A successful company that can enter Egypt can begin
expanding into other Arab nations, especially in the Middle East. It is the seaport to other
markets in the region, considering socio-cultural and political similarities. Cairo hosts the 22-

WALMART CASE STUDY PAPER

5

member Arab League, making it suitable for understanding the regional market. Besides that, the
country controls the Suez Canal, which is the world’s most celebrated maritime checkpoint
connecting the Red and Mediterranean Seas (World Bank, 2020). Walmart can also consider
establishing small stores to serve communities along River Nile.
Additionally, Egypt is a middle-income economy with a large population that grows,
making it a large market for Walmart’s supermarket goods. The country’s economy has been on
a stabilizing path following a period of political instability but slowed down again due to
COVID-19. The government’s commitment to engage the private sector in economic
development presents a huge opportunity for Walmart to invest in the retail sector. According to
World Bank (2020), the Egyptian retail sector has experienced dynamic growth over the past few
years, recording over $160 billion. Hence, some investors have pumped money into developing
shopping malls, including Cairo Festival City, Mall of Arabia, and the Mall of Egypt. That said,
a vast opportunity remains in the retails sector that is still in its early growth stages. The growing
population will increase demand for retail products since retail sales have also been rising. The
existing malls provide prime retail space to accommodate Walmart chain supermarkets in cities
like Cairo and Alexander. It is also projected that the Egyptian economy will grow at 17% in the
post-pandemic period, making the retail sector lucrative for Walmart.
Moreover, the country’s demographic characteristics make it a viable option for Walmart.
The demand for childcare and medical products will increase as more women and children face
health risks. Walmart could integrate the country’s pandemic recovery plan to provide health
care products and services to the growing population. An estimated 30% of the Egyptian
population are low-income earners, implying that Walmart can serve all population segments
(Assaad, 2020). Walmart’s low pricing strategy fits this population and would reduce barriers to

WALMART CASE STUDY PAPER

6

entry emanating from competitive pricing and price leadership. The youthful population creates
an opportunity for online retail due to the growing number of internet users who embrace online
shopping. The inflation rate declined with increased political stability, reducing the cost of doing
business in Egypt. More importantly, a large share of the retail market is controlled by smallscale retailers, implying that supermarkets serving low-income earners are still limited (Ma et al.,
2021). These retailers charge high prices, yet they lack the variety of goods and services that
Walmart provides.
Further, Egypt is a viable option because there are few global retailers in the local
market. Global retailers specializing in home appliances and furniture do not exist in Egypt,
reducing competition in these areas. The country also booms with new cities occupied by
wealthy people with high purchasing power. Walmart can enter the Egyptian market by setting
up stores in shopping malls located in major cities and towns.
Outlook sales, interest, and other trends
Foremost, between 2015 and 2020, Walmart increased the number of its retail units in
Africa year after year. In turn, the Company’s total size of its retail units increased as well.
However, the Company decreased the number of its retail units in the continent in the year 2021.
The decrease in the number of retail units can be attributed to the shift in focus towards the
eCommerce sector necessitated by the covid19 pandemic. As reported in the Company’s 2021
annual report, its eCommerce marketplace grew by triple digits in 2021 compared to 2020. The
upward trend in the Company’s eCommerce business is a clear indication that the downward
trend in the total number of its retail units in the region will continue as it seeks to appeal to the
growing number of customers who prefer its eCommerce platform.
Figure 1

WALMART CASE STUDY PAPER

7

Retail unit and retail square feet

retail unit and retail square feet
30000
25000
20000

15000
10000
5000
0
2021

2020

2019

2018

retail and wholesale unit count

2017

2016

2015

retail square feet

Note. The data is from Walmart annual report 2021. P. 27.
Secondly, between 2020 and 2021, the number of Walmart’s leased retail units
decreased. However, the number of fully-owned retail units remained relatively unchanged over
the same period. The decrease in the number of leased retail units resulted in the overall decrease
in Walmart’s total number of retail units in Africa.
The decrease in the number of leased retail units helped the Company save on costs due
to the decrease in the total annual rent. Additionally, the number of fully-owned Walmart’s retail
units remained unchanged because putting up new retail units or purchasing such units would
have been costly. Therefore, the expansion in the Egyptian market will have to be through the
Company’s eCommerce sector, which will help it to continue saving on costs.
Figure 2
Owned and leased units

WALMART CASE STUDY PAPER

8

owned and leased units
2018

2019

2020

2021
0

50

100

150

200
leased

250

300

350

400

450

Owned

Note. The data is from Walmart annual report 2021. P. 28.
Thirdly, between 2016 and 2021, Walmart’s net sales and operating income in Africa
varied year after year. However, between 2020 and 2021, the Company’s operating income and
net sales were on an upward trend. From figure 3, it is evident that there is a positive linear
relationship between year and Walmart’s net sales in African. The linear regression equation
shows that the Company’s net sales in the region will continue on an upward trend in the future.
Figure 3
Scatter plot of Walmart’s net sales in Africa

WALMART CASE STUDY PAPER

9

net sales
124,000
123,000
122,000
121,000

y = 129.97x - 142362
R² = 0.009

120,000
119,000
118,000
117,000
116,000
115,000
2015

2016

2017

2018

2019

2020

2021

2022

Note. The data is from Walmart annual report 2021. P. 40.
Fourthly, from table 1, it is evident that the Egyptian population has been rising year after
year since the year 2010. The increase in population has contributed to the overall increase in the
urban population. Therefore, considering that most of Walmart’s target customers are situated in
urban areas, it implies that Walmart will enjoy a ready market for its goods and services if it
expands into the Egyptian market. Additionally, the Company will experience an increase in the
demand for its products as the Egyptian population continues to increase year after year.
Table 1
Egyptian population
year

Urban Population

Rural Population

Total Population

2019

42895824

57492249

100388073

2018

42030812

56392783

98423595

2017

41185809

55256784

96442593

2016

40359123

54087949

94447072

WALMART CASE STUDY PAPER

10

2015

39551544

52891003

92442547

2014

38737018

51687636

90424654

2013

37919402

50485238

88404640

2012

37114895

49307345

86422240

2011

36347578

48181672

84529250

2010

35603056

47158179

82761235

Note. The data is from World Bank. (2021). Egypt, Arab Rep. | Data. Data.worldbank.org.
From table 2, Egypt’s GNI has been on an upward trend over the past ten years. The
trend shows that Egypt’s total wealth has increased year after year over the past ten years.
Therefore, Walmart will be able to appeal to the country’s rising middle-income population.
Table 2
Egypt’s gross national income
year

GNI (current U.S. dollars)

01/01/2010 2.14619E+11
01/01/2011 2.2994E+11
01/01/2012 2.72637E+11
01/01/2013 2.81028E+11
01/01/2014 2.98333E+11
01/01/2015 3.23666E+11
01/01/2016 3.2797E+11
01/01/2017 2.31165E+11

WALMART CASE STUDY PAPER

11

01/01/2018 2.43433E+11
01/01/2019 2.92071E+11
01/01/2020 3.51715E+11

Note. The data is from World Bank. (2021). Egypt, Arab Rep. | Data. Data.worldbank.org.
Also, between 2017 and 2021, Egypt’s annual inflation rate steadily decreased each year.
The decrease in the country’s inflation rate implies that Walmart will set affordable prices for its
goods and services. Theerefore, the Company will manage to attract and retain customers if it
enters the Egyptian market.
Table 3
Egypt’s inflation rates
Year

Inflation Rate (%)

2020

5.04%

2019

9.15%

2018

14.40%

2017

29.51%

Note. Macro trends. (2021). Egypt Inflation Rate 1960-2021. Macrotrends.net.
Lastly, between 2019 and 2020, Egypt’s minimum wage and unemployment rates
remained relatively unchanged at 2000 EGP or $129 per month, and 10% respectively. The
country’s unemployment rate clearly shows that there are no labor shortages in the country.
Therefore, the decision to expand into the Egyptian market will not result in Walmart incurring
high labor costs.

WALMART CASE STUDY PAPER

12

Currency translation adjustments
From figure 4, between 2010 and 2021, the overall trend of the value of the U.S. dollar in
Egyptian pounds has been an upward trend. In particular, the value rose from 5.5 EGP in January
of 2010 to 15.7 EGP in August 2021. The depreciation of the Egyptian pound relative to the U.S.
dollar can be attributed to the Arab spring. However, since December 2016, when the value of
the U.S. dollar in Egyptian pounds hit an all-time high of 19.64 EGP, the value of the Egyptian
pound relative to the U.S. dollar has remained stable, as indicated by the downward trend.
Specifically, the value of the U.S. dollar decreased from 19.64 EGP in December 2016 to 15.7
EGP in August 2021. If the trend continues, Walmart will end up with unfavorable currency
translations due to higher product costs. The anticipated losses resulting from the Egyptian
pound gaining value over the U.S. dollar can be avoided by Walmart by fixing the currency
exchange rates. In other words, Walmart can set the price that the U.S. dollar will convert into
the Egyptian pound in the future to avoid the impact of the unexpected increase or drop in the
value Egyptian pound.
Figure 4
The value of the U.S. dollar in the Egyptian pound

WALMART CASE STUDY PAPER

13

Note. From Trading economics. (2021). Egyptian Pound | 1992-2021 Data | 2022-2023 Forecast |
Quote | Chart | Historical. Tradingeconomics.com.
Sales projections
From figure 3, the linear regression equation is net sales =129.97(year) – 142362. Using
this linear regression equation, it is evident that Walmart’s net sales in Africa will increase in the
future even if the Company does expand into Egypt. However, if it expands into Egypt, it will
increase its market share, thus increasing the Company’s revenue and net sales. Also, since the
value of the Egyptian pound relative to the U.S. dollar has remained stable over the past 20
months by varying slightly between 1 U.S=16 EGP to 1 U.S=15.7 EGP, it implies that changes
in the foreign exchanges rates will not have a significant impact on Walmart’s sales in Egypt.
Considering that Walmart operations in 13 African countries resulted in the Company
generating $121360 million in net sales in 2021, it implies that on average, the Company
generated $9335.38 million from the country. Therefore, it is expected that Walmart will
generate $9335.38 million in net sales in its first year of operation in Egypt. Additionally, the
same margin of 1% with which the Company’s net sales in 2021 in the region increased by
compared to 2020 is expected to be the margin with which Walmart’s net sales in Egypt will
increase by each year. Therefore, Walmart’s net sales in Egypt over the next five years would be
as shown in table 2.
Table 2
Sales projections
sales projection in Egypt (millions of $)
2022

9335.38

2023

9428.74

WALMART CASE STUDY PAPER

14

2024

9523.03

2025

9618.26

2026

9714.44

2027

9811.58

Recommendation
In summary, Walmart should expand into the Egyptian market. The country’s status as
the largest market in the Middle East and Northern Africa (MENA) region gives Walmart an
opportunity to increase its revenue and net income. Additionally, as per the analysis above, it is
evident that Egypt’s rising urban population will offer Walmart a ready market for its products,
the decrease in the Company’s overall inflation rate will enable Walmart to set low prices for its
products, the country’s high unemployment rates and low minimum wage requirements will
result in Walmart incurring low labor costs, and the country’s relatively stable currency will
mitigate the risk of incurring losses because of fluctuations in the foreign exchange rates.

WALMART CASE STUDY PAPER

15
References

Assaad, R. (2020, August). Prospects for Egypt’s Population and Labor Force: 2000 to 2050.
In Economic Research Forum Working Papers (No. 1398).f
El-Zayaty, N. (2018). An exploration of leadership styles and motivation in Egyptian business
organizations. International Journal of Business and Applied Social Science
(IJBASS), 4(2).
Fred.stlouisfed.org. (2021). Gross National Income for Egypt. Fred.stlouisfed.org. Retrieved 13
August 2021, from https://fred.stlouisfed.org/series/MKTGNIEGA646NWDB.
Krafft, C. (2020). Why is fertility on the rise in Egypt? The role of women’s employment
opportunities. Journal of Population Economics, 33(4), 1173-1218.
Ma, Z., Zhang, S., & Zhao, S. (2021). Study on the Spatial Pattern of Migration Population in
Egypt and Its Flow Field Characteristics from the Perspective of “Source-Flow-Sink.”
Sustainability, 13(1), 350.
Macro trends. (2021). Egypt Inflation Rate 1960-2021. Macrotrends.net. Retrieved 13 August
2021, from https://www.macrotrends.net/countries/EGY/egypt/inflation-rate-cpi.
Trading economics. (2021). Egyptian Pound | 1992-2021 Data | 2022-2023 Forecast | Quote |
Chart | Historical. Tradingeconomics.com. Retrieved 13 August 2021, from
https://tradingeconomics.com/egypt/currency.
Walmart Inc. (2021). Walmart annual report 2021. S2.q4cdn.com. Retrieved 13 August 2021,
from
https://s2.q4cdn.com/056532643/files/doc_financials/2021/ar/WMT_2021_AnnualReport
.pdf.

WALMART CASE STUDY PAPER
World Bank. (2020). Egypt Economic Monitor, November 2020: From Crisis to Economic
Transformation-Unlocking Egypt’s Productivity and Job-Creation Potential. World
Bank.
world bank. (2021). Egypt, Arab Rep. | Data. Data.worldbank.org. Retrieved 13 August 2021,
from https://data.worldbank.org/country/egypt-arab-rep.

16


Outline
I.

Introduction
Thesis: The paper summarizes Egypt’s background detailing these factors and

explaining why it is a viable option for Walmart.
II.

The Country’s Background

III.

Why Egypt Is a Viable Option for Walmart Expansion

IV.

Outlook sales, interest, and other trends

V.

Currency translation adjustments

VI.

Sales projections

VII.

Recommendation

VIII.

Conclusion: Walmart should expand into the Egyptian market.


Year
2021
2020
2019
2018
2017
2016
2015
year

Africa
retail and wholesale unit count
retail square feet
423
442
436
424
412
408
396
Owned

2021
2020
2019
2018
2017
2016

24537
24754
24,317
23,134
22,542
21,869
21,223

leased

2021
2020
2019
2018
Year

year
1/1/2010
1/1/2011
1/1/2012
1/1/2013
1/1/2014
1/1/2015
1/1/2016
1/1/2017
1/1/2018
1/1/2019
1/1/2020

37
37
38
39

386
405
398
385

net sales (millions of $)
operating income (millions $)
unit counts
121360
3,660
6101
120,130
3,370
6246
120,824
4,883
5993
118,068
5,229
6360
116,119
5,758
6,363
123,408
5,346
6,299

year
2019
2018
2017
2016
2015
2014
2013
2012
2011
2010

net sales, operating income and units
count

Net sales, operating income and units count
30000

140000
120000
100000
80000
60000
40000
20000
0

25000

20000
15000
10000
2021

2020

2019

2018

2017

year
net sales (millions of $)

operating income (millions $)

unit counts

2016

GNI (current U.S. dollars)
2.14619E+11
2.2994E+11
2.72637E+11
2.81028E+11
2.98333E+11
3.23666E+11
3.2797E+11
2.31165E+11
2.43433E+11
2.92071E+11
3.51715E+11

Urban Population
42895824
42030812
41185809
40359123
39551544
38737018
37919402
37114895
36347578
35603056

year
2019
2018
2017
2016
2015
2014
2013
2012
2011
2010

Rural Population
57492249
56392783
55256784
54087949
52891003
51687636
50485238
49307345
48181672
47158179

Total Population
100388073
98423595
96442593
94447072
92442547
90424654
88404640
86422240
84529250
82761235

year
2020
2019
2018
2017
2016
2015
2014
2013
2012

retail unit and retail square feet
30000
25000

20000
15000
10000
5000
0
2021

2020

2019

2018

retail and wholesale unit count

2017
retail square feet

2016

2015

Year
2020
2019
2018
2017
2016
2015
2014
2013
2012
2011
2010

minimum wage(EGY/month)
2000
2000
1200
1200
1200
1200
1200
700
700

Inflation Rate (%) Annual Change
5.04%
9.15%
14.40%
29.51%
13.81%
10.37%
10.07%
9.47%
7.11%
10.06%
11.27%

Year
2020
2019
2018
2017
2016
2015
2014
2013
2012
2011
2010

-4.11%
-5.25%
-15.11%
15.69%
3.44%
0.30%
0.60%
2.36%
-2.95%
-1.20%
-0.50%

Unemployment Rate (%)
10.45%
9.73%
9.82%
11.74%
12.41%
13.05%
13.11%
13.15%
12.60%
11.85%
8.76%

owned and leased units
2018
2019
2020
2021
2015

0

50

100

150

200
leased

250
Owned

300

350

400

450

Year
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027

net sales (in millions of dollars)
123,408
116,119
118,068
120,824
120,130
121360
120437.34
120567.31
120697.28
120827.25
120957.22
121087.19

sales projection in Egypt (millions of $)
2022
9335.38
2023
9428.74
2024
9523.03
2025
9618.26
2026
9714.44
2027
9811.58

net sales (in millions of dollars)
124,000

123,000
122,000
121,000

y = 129.97x

120,000
119,000
118,000
117,000
116,000
115,000
2015

2016

2017

2018

2019

millions of dollars)

y = 129.97x - 142362
R² = 0.009

2019

2020

2021

2022

8/11/2021
8/10/2021
8/9/2021
8/8/2021
8/7/2021
8/6/2021
8/5/2021
8/4/2021
8/3/2021
8/2/2021
8/1/2021
7/31/2021
7/30/2021
7/29/2021
7/28/2021
7/27/2021
7/26/2021
7/25/2021
7/24/2021
7/23/2021
7/22/2021
7/21/2021
7/20/2021
7/19/2021
7/18/2021
7/17/2021
7/16/2021
7/15/2021
7/14/2021
7/13/2021
7/12/2021
7/11/2021
7/10/2021
7/9/2021
7/8/2021
7/7/2021
7/6/2021
7/5/2021
7/4/2021
7/3/2021
7/2/2021
7/1/2021
6/30/2021
6/29/2021
6/28/2021
6/27/2021

US Dollar
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =

Egyptian Pound
15.6971 EGP
15.6994 EGP
15.6982 EGP
15.7133 EGP
15.7056 EGP
15.7003 EGP
15.7064 EGP
15.7003 EGP
15.698 EGP
15.7082 EGP
15.7097 EGP
15.71 EGP
15.71 EGP
15.7038 EGP
15.6987 EGP
15.6887 EGP
15.6945 EGP
15.669 EGP
15.6715 EGP
15.672 EGP
15.6705 EGP
15.6734 EGP
15.671 EGP
15.6726 EGP
15.7035 EGP
15.7056 EGP
15.7056 EGP
15.7052 EGP
15.6959 EGP
15.6918 EGP
15.6777 EGP
15.6647 EGP
15.6894 EGP
15.6877 EGP
15.691 EGP
15.666 EGP
15.6896 EGP
15.6802 EGP
15.674 EGP
15.669 EGP
15.6697 EGP
15.6966 EGP
15.6955 EGP
15.6682 EGP
15.6699 EGP
15.6653 EGP

6/26/2021
6/25/2021
6/24/2021
6/23/2021
6/22/2021
6/21/2021
6/20/2021
6/19/2021
6/18/2021
6/17/2021
6/16/2021
6/15/2021
6/14/2021
6/13/2021
6/12/2021
6/11/2021
6/10/2021
6/9/2021
6/8/2021
6/7/2021
6/6/2021
6/5/2021
6/4/2021
6/3/2021
6/2/2021
6/1/2021
5/31/2021
5/30/2021
5/29/2021
5/28/2021
5/27/2021
5/26/2021
5/25/2021
5/24/2021
5/23/2021
5/22/2021
5/21/2021
5/20/2021
5/19/2021
5/18/2021
5/17/2021
5/16/2021
5/15/2021
5/14/2021
5/13/2021
5/12/2021
5/11/2021

1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =

15.6684 EGP
15.6684 EGP
15.671 EGP
15.6578 EGP
15.6793 EGP
15.6594 EGP
15.6362 EGP
15.6463 EGP
15.6474 EGP
15.6655 EGP
15.6513 EGP
15.6675 EGP
15.66 EGP
15.638 EGP
15.6394 EGP
15.6389 EGP
15.6697 EGP
15.6818 EGP
15.6495 EGP
15.6874 EGP
15.6942 EGP
15.6902 EGP
15.6902 EGP
15.6857 EGP
15.6902 EGP
15.6758 EGP
15.6933 EGP
15.6561 EGP
15.6585 EGP
15.6585 EGP
15.6831 EGP
15.6834 EGP
15.6676 EGP
15.6675 EGP
15.6619 EGP
15.6599 EGP
15.6599 EGP
15.6832 EGP
15.6819 EGP
15.6809 EGP
15.6893 EGP
15.6543 EGP
15.6548 EGP
15.6548 EGP
15.6637 EGP
15.6838 EGP
15.6838 EGP

5/10/2021
5/9/2021
5/8/2021
5/7/2021
5/6/2021
5/5/2021
5/4/2021
5/3/2021
5/2/2021
5/1/2021
4/30/2021
4/29/2021
4/28/2021
4/27/2021
4/26/2021
4/25/2021
4/24/2021
4/23/2021
4/22/2021
4/21/2021
4/20/2021
4/19/2021
4/18/2021
4/17/2021
4/16/2021
4/15/2021
4/14/2021
4/13/2021
4/12/2021
4/11/2021
4/10/2021
4/9/2021
4/8/2021
4/7/2021
4/6/2021
4/5/2021
4/4/2021
4/3/2021
4/2/2021
4/1/2021
3/31/2021
3/30/2021
3/29/2021
3/28/2021
3/27/2021
3/26/2021
3/25/2021

1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =

15.6682 EGP
15.6661 EGP
15.671 EGP
15.671 EGP
15.6687 EGP
15.6686 EGP
15.6657 EGP
15.6594 EGP
15.6497 EGP
15.6598 EGP
15.6593 EGP
15.6586 EGP
15.6604 EGP
15.6738 EGP
15.6937 EGP
15.7113 EGP
15.7032 EGP
15.7034 EGP
15.6948 EGP
15.6794 EGP
15.7056 EGP
15.6941 EGP
15.6955 EGP
15.6895 EGP
15.6838 EGP
15.681 EGP
15.6767 EGP
15.6861 EGP
15.6904 EGP
15.711 EGP
15.7071 EGP
15.706 EGP
15.705 EGP
15.7015 EGP
15.7085 EGP
15.6192 EGP
15.7287 EGP
15.7336 EGP
15.733 EGP
15.7024 EGP
15.715 EGP
15.7218 EGP
15.719 EGP
15.7158 EGP
15.67 EGP
15.6695 EGP
15.7014 EGP

3/24/2021
3/23/2021
3/22/2021
3/21/2021
3/20/2021
3/19/2021
3/18/2021
3/17/2021
3/16/2021
3/15/2021
3/14/2021
3/13/2021
3/12/2021
3/11/2021
3/10/2021
3/9/2021
3/8/2021
3/7/2021
3/6/2021
3/5/2021
3/4/2021
3/3/2021
3/2/2021
3/1/2021
2/28/2021
2/27/2021
2/26/2021
2/25/2021
2/24/2021
2/23/2021
2/22/2021
2/21/2021
2/20/2021
2/19/2021
2/18/2021
2/17/2021
2/16/2021
2/15/2021
2/14/2021
2/13/2021
2/12/2021
2/11/2021
2/10/2021
2/9/2021
2/8/2021
2/7/2021
2/6/2021

1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =
1 USD =

15.7543 EGP
15.7719 EGP
15.7335 EGP
15.7078 EGP
15.6435 EGP
15.6433 EGP
15.6794 EGP
15.7093 EGP
15.6892 EGP
15.7089 EGP
15.7062 EGP
15.701 EGP
15.7011 EGP
15.7032 EGP
15.7324 EGP
15.7289 EGP
15.7307 EGP
15.688 EGP
15.6976 EGP
15.6976 EGP
15.6909 EGP
15.6752 EGP
15.6772 EGP
15.7344 EGP
15.6868 EGP
15.7048 EGP
15.7046 EGP
15.707 EGP
15.6797 EGP
15.6783 EGP
15.6804 EGP
15.6268 EGP
15.6414 EGP
15.6414 EGP
15.6601 EGP
15.6255 EGP
15.6259 EGP
15.6199 EGP
15.5898 EGP
15.619 EGP
15.6191 EGP
15.6291 EGP
15.6625 EGP
15.6598 EGP
15.6569 EGP
15.6867 EGP
15.684 EGP

2/5/2021
2/4/2021
2/3/2021
2/2/2021
2/1/2021
1/31/2021
1/30/2021
1/29/2021
1/28/2021
1/27/2021
1/26/2021
1/25/2021
1/24/2021
1/23/2021
1/22/2021
1/21/2021
1/20/2021
1/19/2021
1/18/2021
1/17/2021
1/16/2021
1/15/2021
1/14/2021
1/13/2021
1/12/2021
1/11/2021
1/10/2021
1/9/2021
1/8/2021
1/7/2021
1/6/2...

Puhpxf574 (30982)
New York University

Similar Content

Related Tags