Week 6 -Final Assignment - BUS625

.docx

School

University Of Arizona *

*We aren’t endorsed by this school

Course

625

Subject

Information Systems

Date

Oct 30, 2023

Type

docx

Pages

Uploaded by MasterArt8229

1 Walmart Expansion Analysis – Part 1 Swaminathan Subramanian The University of Arizona Global Campus BUS625: Data & Decision Analytics (FTB2211B) Prof. Kurt Diesch October 3 rd , 2022

2 Introduction Data Analytics plays a key role in making use of the data that is extracted in a large volume from various sources to make sense of that data with a graphical and pictorial representation using various tools and techniques to represent graphs and trends. This data is provided to the executives to make big decisions on the customers likes and dislikes of their products along with the expected profit/loss of their performance. Summarize the background of the country or region, including what makes unique and why it is a viable option for Walmart expansion. The country I chose for Walmart to globally expand is Philippines. The Republic of Philippines consists of 7,640 islands situated in Asia which is approx. 1200 sq miles. As of 2020 the population in 109 million and considered as the 12 th populous country in the world. The area occupied by Philippines is slightly largest than the state of Arizona. The major languages that are spoken Philippines is Filipino which is their native language and the second language that is widely spoken is English. The population growth is more than 2% compared to the most populated countries India & China

3 Wal-Mart moto is ‘Always low prices, always’ which helps it to sustain in any of the Asian country and Philippines will fall under the southern Asian cluster based on the Globe studies. One of the unique factors is some of the Information Technology companies have their Offshore business expanded to Philippines and Manila is their capital which is one of the largest islands of the Philippines. Since Philippine people are already familiar about US and its products because of them working for the US companies they are well aware of Wal-Mart and its products, and it is easy for Wal-Mart to expand their business in Philippines without many challenges on marketing and advertisement of their products and their services. Assesses the Data sets and includes any charts or graphs used in evaluation. Cashflow statement 2022 2021 2020 2019 2018 Net cashflow from operating activities 24,181,000 36,074,000 25,255,000 27,753,000 28,337,000 Net cash flow from investing activities -6,015,000 - 10,071,000 -9,128,000 - 24,036,000 -9,060,000 Net cash flow from financing activities - 22,828,000 - 16,117,000 - 14,299,000 -2,537,000 - 19,875,000 For any given organization the baseline requirement is to have transparency, accuracy of data is very important to show the financial health status of the company. One of the more important data to visualize is the cash flow of the company and below is the cash flow of operations, investment, and finance to showcase the outgoing expenditures and investments. Based on this we can make major decisions on how well the organization generate cash, how is the incoming cash flow compared to outgoing cash flow.

4 Net cashf ow fro m operatng actvites Net cash fow f rom investng actvites Net cash fow f rom fna ncing actvites -30,000,000 -20,000,000 -10,000,000 0 10,000,000 20,000,000 30,000,000 40,000,000 24,181,000 -6,015,000 -22,828,000 36,074,000 -10,071,000 -16,117,000 25,255,000 -9,128,000 -14,299,000 27,753,000 -24,036,000 -2,537,000 28,337,000 -9,060,000 -19,875,000 Cashflow Details in Thousands 2022 2021 2020 2019 2018 Measures Outlook Sales, Interest, and other trends to make a determination on the Regional Outlook Any business that has a positive working capital will be able to withstand financial challenges Based on the below data for working capital for the last 5 years of record we can see 50% of improvement compared to 2018 and 2019. This is a good sign that shows Wal-Mart can be ready for investment globally. Financial data 2022 2021 2020 2019 2018 Total current liability 87,379,000 92,645,000 77,790,000 77,477,000 78,521,000 Total current assets 81,070,000 90,067,000 61,806,000 61,897,000 59,664,000 Working capital -6,309,000 -2,578,000 -15,984,000 -15,580,000 -18,857,000

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version