Conduct a financial analysis on Walmart

Anonymous
timer Asked: Oct 21st, 2018
account_balance_wallet $55

Question Description

3. Section 3: Assets
a. Record the following weekly market activity for the company’s stock for the previous year (any day such as Friday, Monday etc.). Make sure to record:
i. Closing price
ii. One source: search online for yahoo finance, click on quotes & info, type in your company name – follow instructions on web page, click on search, click on historical data, click on daily – change to weekly, click on apply, get close price.
iii. Analyze, evaluate, and discuss the information
b. List the total of Property, Plant, and Equipment for the years covered in your annual report
i. List the total of Accumulated Depreciation associated with Property, Plant, and Equipment for 2 years listed in your annual report
ii. List the total of all assets for 2 years listed in the annual report
iii. List the total of the current assets for 2 years listed in the annual report
iv. As shown in the balance sheet, has your company had significant changes in asset structure, such as major purchases of other companies, investments, or discontinued operations?
v. Identify the method or methods used by your company to value the inventories.
1. List the total dollar value of the inventory for 2 years on balance sheet presented in the annual report.
2. Compute the percentage of inventories to total assets for 2 years of your annual report’s balance sheets and assess the results.
c. List the Cost of Goods Sold and the Gross Profit for your company for 2 years in income statement appearing in the annual report.
i. Calculate the percentage of Cost of Goods Sold to Net Sales and the percentage of Gross Profit to Net Sales for 2 periods and assess the results
d. Analyze/assess/discuss your findings

Unformatted Attachment Preview

Providing opportunity & serving our communities 2018 ANNUAL REPORT $250B 250,000+ U.S. associates graduated from Walmart Academy Commitment to purchase products that support American jobs 1 Gigaton $35M+ Commitment to work with suppliers to reduce emissions in the value chain Donated to 2017 hurricane relief Walmart Inc. (NYSE: WMT) 702 S.W. 8th Street Bentonville, Arkansas 72716 USA 479-273-4000 walmart.com The minimized environmental footprint of this report is the result of an extensive, collaborative effort of Walmart and our supply chain partners. The environmental and social impact continues to be an important consideration. It is printed on paper from well-managed forests containing recycled PCW fiber that is Elementally Chlorine Free (ECF). It is printed using environmental manufacturing principles that were utilized in the printing process. These practices include environmentally responsible procurement, lean manufacturing, green chemistry principles, the recycling of residual materials and reduced volatile organic compound inks and coatings. 2018 Annual Report For more information, please see our Global Responsibility Report at: corporate.walmart.com/global-responsibility ACCELERATING INNOVATION Corporate and Stock Information Listing New York Stock Exchange Stock Symbol: WMT Corporate Information Stock Registrar and Transfer Agent: Computershare Trust Company, N.A. P.O. Box 505000 Louisville, Kentucky 40233-5000 1-800-438-6278 TDD for hearing-impaired inside the U.S. 1-800-952-9245 Internet: http://www.computershare.com $500.3 billion Total Revenue Annual Meeting Our Annual Meeting of Shareholders will be held on Wednesday, May 30, 2018 at 10:00 a.m. (Central Time) in the John Q. Hammons Center, Rogers, Arkansas. Communication With Shareholders Walmart Inc. periodically communicates with its shareholders and other members of the investment community about our operations. For further information regarding our policy on shareholder and investor communications refer to our website: www.stock.walmart.com. $28.3 billion Operating Cash Flow The following reports are available without charge upon request by ­writing the Company c/o Investor Relations or by calling (479) 273-8446. These reports are also available via the corporate website. $14.4 billion cash returned to shareholders through dividends and share repurchases $11.5 billion Walmart U.S. eCommerce sales $10.1 billion Capital Expenditures • Annual Report on Form 10-K • Quarterly Reports on Form 10-Q • Earnings Releases • Current Reports on Form 8-K • Annual Shareholders’ Meeting Proxy Statement • Global Responsibility Report • Culture, Diversity & Inclusion Report Dividends Paid Per Share For fiscal 2018, dividends were paid based on the following schedule: April 3, 2017 $0.51 June 5, 2017 0.51 September 5, 2017 0.51 January 2, 2018 0.51 For fiscal 2017, dividends were paid based on the following schedule: April 4, 2016 $0.50 June 6, 2016 0.50 September 6, 2016 0.50 January 3, 2017 0.50 Stock Performance Chart This graph compares the cumulative total shareholder return on Walmart’s common stock during the five fiscal years ending in fiscal 2018 to the cumulative total returns on the S&P 500 Retailing Index and the S&P 500 Index. The comparison assumes $100 was invested on February 1, 2013, in shares of our common stock and in each of the indices shown and assumes that all of the dividends were reinvested. Comparison of 5-Year Cumulative Total Return* Among Walmart Inc., the S&P 500 Index and S&P 500 Retailing Index Walmart Inc. Independent Registered Public Accounting Firm Ernst & Young LLP 5417 Pinnacle Point Dr., Suite 501 Rogers, AR 72758 $300 Market Price of Common Stock The high market price and low market price per share for the Company’s common stock for each fiscal quarter in fiscal 2018 and 2017 were as follows: $100 $250 $200 $150 2018 270 million customers a week over 11,700 stores operating in 28 countries 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter High 2017 Low $ 75.77 $ 66.04 80.47 73.13 89.11 77.50 109.98 87.00 High Low $ 70.08 $ 62.35 74.35 62.72 75.19 67.07 72.48 65.28 The high market price and low market price per share for the Company’s common stock for the first fiscal quarter of fiscal 2019, were as follows: 2019 1st Quarter(1) (1) Through March 28, 2018. 2 | WALMART S&P 500 Retailing Index $350 $ 50 $ 0 2013 2014 2015 High $106.56 Low $85.28 2016 2017 2018 Fiscal Years Fiscal Years Ended January 31, Serve nearly S&P 500 Index *A ssumes $100 Invested on February 1, 2013 Assumes Dividends Reinvested Fiscal Year Ending January 31, 2018 Fiscal Years Ended January 31, 2013 2014 2015 2016 2017 2018 Walmart Inc. $100.00 $109.39 $127.58 $102.39 $105.97 $173.61 S&P 500 Index 100.00 121.52 138.80 137.88 165.51 209.22 S&P 500 Retailing Index 100.00 127.72 153.64 184.32 218.76 321.37 Holders of Record of Common Stock As of March 28, 2018, there were 229,858 holders of record of Walmart’s common stock. Designed and produced by Corporate Reports Inc./Atlanta   www.cricommunications.com Walmart by the numbers Dividends Payable Per Share For fiscal 2019, dividends will be paid based on the following schedule: April 2, 2018 $0.52 June 4, 2018 0.52 September 4, 2018 0.52 January 2, 2019 0.52 CEO LETTER Dear shareholders, associates and customers: Recently I was talking to Chad Daggett about his experience leading our Sam’s Club in Bangor, Maine (he was recently promoted to a new role). Chad’s club had a good year and we were recognizing him for his servant leadership in the club and the community. He was quick to give credit to his team and said, “If you treat people like they make a difference, they will.” In that moment, he captured what makes our company unique: it’s our people, our culture, our purpose and our values that make the difference for our business and have enabled our success since the start. And those are the things that will empower our success in the future. We’ve had an exciting year at Walmart. We have the right strategy and we’re making progress putting our unique assets to work to serve customers in all the ways they want to shop. We are confident in our strategy because customers are responding. We are confident in our ability to execute the strategy because we have the culture, the talent and the resources not only to deliver the current plan, but also to dream of new things and new ways to transform our business. We will delight customers in ways they might not have even thought of yet. We’re out to provide an easy, fast, friendly and fun shopping experience for them whether they shop with us in stores, online, via a mobile device, with their voice or with virtual reality, augmented reality or whatever comes next. This year we made great progress accelerating innovation to save customers both money and time. In our stores, we’re digitizing experiences to make it easier for customers to shop and more efficient for associates to manage inventory and perform routine tasks. Our eCommerce business continues to scale as we launch new ways to enhance the customer experience. We’re moving faster, getting stronger and we have good momentum throughout the business. Last fiscal year we reached more than $500 billion in revenue for the first time as a company. Walmart U.S. delivered the highest comp sales growth in nine years and U.S. eCommerce sales grew 44 percent. Walmart International had 10 of 11 markets post positive comp sales for the year and five of those markets grew comp sales by more than 5 percent. Sam’s Club comp sales continue to improve and the business is repositioned to capitalize on future growth. We have a strong foundation and great opportunities to better serve customers. I’m excited about what the future holds. HERE’S MORE ABOUT WHAT WE’VE BEEN UP TO: First, we know our customers’ lives are busier than ever before, so our first objective is to make every day easier for them. They rely on us for low prices and they want us to save them time. We’re leveraging our stores as a strategic advantage in new ways. This past year, we nearly doubled the number of stores offering online grocery pickup to more than 1,100 locations in the U.S. and we’ll add another 1,000 locations in fiscal 2019. We’re expanding online grocery in Canada, Mexico and China as well. We’re also broadening our delivery capabilities in the U.S., China and other international markets. For example, through our partnership with JD Daojia in China, we offer grocery delivery in less than one hour in over 160 stores in China. We launched an express checkout experience in pharmacy, money services, and returns at Walmart U.S. Sam’s Club Scan & Go has been well-received by members and we’ve introduced this capability in certain Walmart U.S. stores as well as in Canada. We launched free 2-day shipping and easy reorder on Walmart.com and the response has been strong. Sam’s Club also enhanced the value of the Plus membership with the offer of free shipping. Our eCommerce assortment has also improved. In the U.S., we’ve doubled the number of items on Walmart.com over the past year. Jet.com continues to complement Walmart.com nicely with its appeal to higher-income, urban, millennial customers. Acquisitions like Bonobos bring unique, private branded products to our shopping experience, and relationships with partners like Lord & Taylor enable us to offer brands and experiences that complement our own assortment. We’re also partnering with Google on personalized voice shopping. Outside the U.S., we launched eCommerce marketplaces in Canada and Mexico so that customers have access to more of the general merchandise assortments they desire. Overall, it’s a lot easier to shop with Walmart today than it used to be. And, we’re going to keep getting better as we focus on serving customers seamlessly across our apps, sites and stores. Nearly Stores 2X the spend eCommerce Customers who shop in store and become eCommerce customers spend nearly twice as much overall. Second, we’re changing how we work to become more efficient. We’re equipping and empowering our associates to be successful with better information, tools and training. In stores, this means our associates are spending more time driving sales and less time doing repetitive tasks. We’ve opened training academies to further develop the retail skills of our associates and we’ve deployed new technology and apps to help them improve in-stock levels and better manage price changes. We’re also testing shelf-scanning technology in stores and distribution centers to handle routine tasks. We will compete with technology, but we will win with our people. We’re creating a high-performance culture that rewards achievements and fosters accountability while remaining true to our core values. A YEAR OF ACCELERATED INNOVATION JANUARY Launched 2-day free shipping on Walmart.com for orders over $35 2 | WALMART FEBRUARY Walmart U.S. mobile express money and pharmacy services launched MARCH Acquired ModCloth APRIL Introduced pickup discount on Walmart.com MAY Launched Sam’s Club Global Flagship Store on JD.com in China JUNE Acquired Bonobos CEO LETTER The investments we’re making are critical to winning with customers as we’re focused on delivering results and operating with discipline. An everyday low cost mindset is core to who we are as a company and it helps fuel the productivity loop enabling lower prices for customers. We’re laser-focused on improving productivity throughout the organization and leveraging expenses as a company. We’re also being more strategic with capital allocation to deliver strong efficient growth. We’re prioritizing eCommerce, store remodels and customer initiatives like online grocery over new store openings. In addition, we’ve made strategic choices around our portfolio including closing certain stores and clubs and winding-down the first party eCommerce business in Brazil. These decisions are positioning the business for more efficient, sustainable growth in the future. Finally, we want to be the most trusted retailer. We believe in the concept of shared value where Walmart operates for the benefit of not just customers, associates and shareholders, but all stakeholders including suppliers, communities and society in general. It’s important for us to do things ethically and the right way. Customers trust us for low prices on quality merchandise. They also want the products they buy to be good for the planet and the people who made them so we’ve invested to promote the safety and dignity of the people who make the products we sell. We’ve also implemented leading technologies in our stores and supply chain to promote the highest freshness, quality and safety in the food we sell, while at the same time improving the safety of our operations worldwide. JULY Opened new eCommerce fulfillment center in Florida AUGUST Google partnership to deliver personalized voice shopping SEPTEMBER 1,000th Online Grocery location in Walmart U.S. Many of our customers also value the role we play in their communities. We provide good jobs for our associates with opportunity to build a career with Walmart. Earlier this year, we increased the starting wage for our U.S. associates to $11 per hour and expanded maternity and parental leave for salaried and hourly associates. Families are a priority to us and connecting with and caring for a new family member is obviously important. We’re working hard to provide opportunities for associates to be successful at Walmart or wherever their careers take them. We’re also ready to support the communities we serve during times of crisis. I could not be more proud of the resolve our associates displayed this past year in responding to the devastating damage caused by the hurricanes in Puerto Rico, Texas and Florida and the earthquake in Mexico. The character of our people was on full display. We believed they would make a difference and they did not disappoint. In addition, we’re enhancing the environmental sustainability of our operations and we’re investing to make our supply chain more transparent. It’s really all about being true to our purpose: we save people money so they can live better. Thanks for your continued interest in our company and for investing in our future. We’re well-positioned to win—we have the plan, we have the assets, and most importantly, we have the people who are hungry to make a difference and innovate for customers in new ways. This is a great time to be at Walmart. I am excited for the year and what we will accomplish. Sincerely, Doug McMillon President and Chief Executive Officer Walmart Inc. OCTOBER New membership sign-up process at Sam’s Club NOVEMBER Expanded one-hour grocery delivery to nearly 140 stores in China DECEMBER Announced our name change to Walmart Inc. 2018 ANNUAL REPORT | 3 CFO MESSAGE Winning with customers and shareholders It’s an exciting time at Walmart as we’re transforming the business to serve customers more effectively. Customers are busier than ever, so we’re innovating and leveraging technology to save them time as well as money. Our financial strength provides the flexibility to win with both customers and shareholders. For customers, we’ve invested in initiatives such as online grocery, mobile express checkout in our stores, and free 2-day shipping for orders over $35 from Walmart.com. We made acquisitions to improve our online assortment and we’re partnering with others, like Google and JD.com, in new ways. At the same time, we provided solid cash returns to shareholders through a meaningful and growing dividend and continued share repurchases. We’re incredibly well-positioned with unique assets to win in this new age of retail and the fiscal 2018 results reflect Walmart’s strong financial position: • Total revenue surpassed $500 billion for the first time; • Walmart U.S. comp sales were the highest since fiscal 2009; • Walmart U.S. eCommerce sales grew 44 percent; • Operating cash flow was $28.3 billion, and; • We returned $14.4 billion to shareholders through dividends and share repurchases. Our financial framework helps guide decisions as we grow the business. The three key elements are: strong, efficient growth; consistent operating discipline; and strategic capital allocation. STRONG, EFFICIENT GROWTH. We’re focused on our most productive and profitable growth opportunities by prioritizing growth from comp sales and eCommerce versus opening new stores. We’ve seen good momentum with each of our segments delivering strong comp sales growth this past year. The customer experience in our stores has improved as we’re making shopping easy, fast, friendly and fun. Walmart U.S. eCommerce sales growth was also strong and we’re focused on continuing to accelerate eCommerce innovation and omni-channel offerings to provide the convenience customers expect. 4 | WALMART CONSISTENT OPERATING DISCIPLINE. The everyday low prices we provide to customers are enabled when we operate at everyday low costs. We’ve made headway in cost of goods efficiencies and working capital productivity with strong inventory management. Expenses are not where we want them to be overall, but we started bending the cost curve last year, particularly in Walmart U.S. stores and in International. We’re changing how we work by improving processes and increasingly using technology and automation to be more productive, especially in support functions. We’ll continue to make smart investments that help us grow faster and compete more effectively to win long-term. STRATEGIC CAPITAL ALLOCATION. Walmart generates substantial cash and we’ve aligned our capital priorities with the long-term strategy. Our first priority is to invest in growing the business efficiently. We’re being more disciplined and thoughtful with every dollar of capital, which led to a decline in capital expenditures in fiscal 2018. We’ve shifted spend from opening new stores to remodels, eCommerce, supply chain and technology to set us up for the future. We’ll continue to invest in customer initiatives like online grocery, pickup towers, and an expansion of grocery delivery. We’ll also be opportunistic with M&A while being open to taking action on assets within our portfolio to simplify the business. Secondly, our dividend is important and we’ve increased it for 45 consecutive years. Finally, we’re committed to the share repurchase program we announced last October as we continue to believe in the long-term value of Walmart. We’re confident that over time, these financial priorities will help us drive sustainable top line and bottom line growth, and generate solid returns for shareholders. In closing, we’re executing our strategy, we’re delivering results and we’re doing this from a base of incredible financial strength. We’re committed to growing the value of the company for our shareholders while we win with customers. Thanks for your investment in Walmart. Sincerely, Brett Biggs Executive Vice President and Chief Financial Officer Walmart Inc. UNITED STATES SECURITIES AND EXCHANGE COMMISSION Washington, D.C. 20549 ___________________________________________ FORM 10-K ___________________________________________ ý Annual report pursuant to section 13 or 15(d) of the Securities Exchange Act of 1934 for the fiscal year ended January 31, 2018, or ¨ Transition report pursuant to section 13 or 15(d) of the Securities Exchange Act of 1934 Commission file number 001-6991. ___________________________________________ WALMART INC. (Exact name of registrant as specified in its charter) ___________________________________________ Delaware ...
Purchase answer to see full attachment

Tutor Answer

Tutor_Booth
School: UC Berkeley

Hey! Kindly find the attached answer and in case of any issue, let me know. Thank you

Average closing price
Standard deviation
Maximum
Minimum
Range
Mean weekly return
Standard deviation

WMT-Close prices
$ 92.31
$ 6.50
$ 108.39
$ 82.46
$ 25.93
0.23%
3.12%

Close prices
120
100

Stock prices

Date
Close pricesChange
10/23/2017
88.17
10/30/2017
89.68
1.71%
11/6/2017
90.92
1.38%
11/13/2017
97.47
7.20%
11/20/2017
96.62
-0.87%
11/27/2017
97.35
0.76%
12/4/2017
96.55
-0.82%
12/11/2017
97.11
0.58%
12/18/2017
98.21
1.13%
12/25/2017
98.75
0.55%
1/1/2018
100.13
1.40%
1/8/2018
100.87
0.74%
1/15/2018
104.59
3.69%
1/22/2018
108.39
3.63%
1/29/2018
104.48
-3.61%
2/5/2018
99.37
-4.89%
2/12/2018
104.78
5.44%
2/19/2018
92.89 -11.35%
2/26/2018
88.77
-4.44%
3/5/2018
88.72
-0.06%
3/12/2018
89.17
0.51%
3/19/2018
85.42
-4.21%
3/26/2018
88.97
4.16%
4/2/2018
86.69
-2.56%
4/9/2018
86.02
-0.77%
4/16/2018
86.98
1.12%
4/23/2018
87.29
0.36%
4/30/2018
87.53
0.27%
5/7/2018
83.38
-4.74%
5/14/2018
83.64
0.31%
5/21/2018
82.46
-1.41%
5/28/2018
82.99
0.64%
6/4/2018
84.36
1.65%
6/11/2018
83.7
-0.78%
6/18/2018
84.82
1.34%
6/25/2018
85.65
0.98%
7/2/2018
84.51
-1.33%
7/9/2018
87.7
3.77%
7/16/2018
88.06
0.41%
7/23/2018
88.13
0.0...

flag Report DMCA
Review

Anonymous
Top quality work from this guy! I'll be back!

Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors