Walmart Financial Model

Description
Walmart, Inc. Save Money for better Life!



Walmart Inc. was founded in 1945 and is headquartered in Bentonville, Arkansas, USA.
It helps people around the world save money and live better – anytime and anywhere - by providing the opportunity to shop in both retail stores & through E-commerce.
It Serves approx 230 million in 24 countries.
Our operations comprise three - Walmart U.S., Walmart International, and Sam's Club.
1. Membership, advertising, Fulfillment, and Health & Wellness services enhance the omnichannel shopping experience.
2. These offerings are mutually reinforcing pieces of the flywheel. The growth of these pieces ultimately accelerates the flywheel - Creates Value for stakeholders.
3. Omni - Channel Shopping - Integration of Retail stores & E-commerce


I have considered 3 years of historical data for forecasting the next 5 years.

It is a Yearly Dynamic Financial Model prepared considering two scenarios: Revenue, Cost drivers


This Model consists of the following sections:
1. Cover Page
2. Dashboard
3. Assumptions & Inputs
4. Scenarios
5. Income Statement
7. Cash Flows Statement
8. Balance Sheet
9. Schedules
10. PP&E & Lease Schedule
11. DCF Valuation & WACC Calculation
12. Comp's Analysis.
13. Equity Research


Finally, I Bought all valuation methods in one place " Football Field Analysis"


If you have any queries or you want to contribute from your side that would make this model robust and that will be highly appreciated.



Note: All the information is taken from SEC Filing, Yahoo Finance, World Bank