Brief Introduction of Walmart Inc
Walmart Inc is a public multinational retail and wholesale business company that was founded in 1962 by Sam Walton. The headquarter’s office location is in Arkansas, United States, and has approximate 11.510 retail stores worldwide. For more information regarding Walmart’s company profile and info, visit Walmart Inc’s official website at Walmart.com.
Financial Model & Input Assumptions
Excel Financial Model used Corporate Finance Institute Blue and Orange Color Theme which is very well fit for every financial model in excel I made since I am also a Financial Modeling & Valuation Analyst Certification Holder, check out CorporateFinanceInstitute.com for more information about this certification program. Inputs are blue-colored coded and formulas are black-colored coded, helping us to differentiate between the two. The input assumptions used are on the basis of historical performance data, which is taken from 4 years company’s financial performance prior reporting date. Some complex inputs are held constant to keep the model simple and can be understood easily.
The Report, Dashboard, and Feedback
The reported date is 2/2/2021 with Walmart’s (WMT) closing price of $139.27. Analyst’s target price taken from tipranks.com (credited in the footer of the report), competitor summary information are taken from marketbeat.com (credited in the footer of the report), discount rate assumption taken from finbox.com (credited in the footer of the report), and historical price data taken from Yahoo Finance. Valuation and forecast summary stated in the “Key Financials” section of the report. Many thanks to some Stockbit members, especially Om Skydrugz27 who have reviewed this model and also suggested some feedback regarding features and reliability of the 3-statements model and input assumptions.
Finally, here are the works. Click the image to open it as full size in a new tab:
Summary Report
Input, Assumptions, and Balance Sheet Model
Valuation Model
There were some problems when I tried to insert the Income statement and cash flow statement. Check back later when I have found the solutions. Have some questions or feedback? interested in taking the FMVA certification program like I did but still unsure about it? Are you a student looking for a partner to collaborate together in building a financial model, especially for a Public Indonesian Company? Comment below or send me an email at mail@satrio.web.id and let’s discuss it together!
DISCLAIMER: Investing and or trading in Stock Market involves a certain degree of risk. This Report and Valuation are for educational and portfolio purposes only. I hereby disclaim that I won’t be held responsible for any future risk and inaccuracies that occurred regarding your investment decision-making involving this Report & Valuation.
