Personal Blog of Satrio

Menu
  • About Me
  • Portfolio
  • Privacy Policy
Menu

Walmart Discounted Cash Flow Valuation

Posted on February 6, 2021February 11, 2021 by Admin

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.

Please follow and like us:
error
fb-share-icon
Tweet

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • Walmart Discounted Cash Flow Valuation
  • Notes on Majesty of Calmness by William George Jordan
  • Jurnal Kerajinan Kulit
  • Meningkatkan Brand Awareness dan Value Bisnis dengan Email Profesional
  • Cost Benefit Analysis

Categories

  • Biography
  • Business
  • Economics
  • Fintech
  • Hobby
  • Portfolio
  • Review

Archives

  • February 2021
  • October 2020
  • May 2020
  • March 2020
  • November 2019
  • October 2019
  • September 2019
  • April 2018
  • March 2018
  • February 2018

Industrious

Art of Wasting No Time

Terima Kasih

 

 

Jika ada masukan atau informasi yang keliru pada artikel di web ini dan harus di perbaiki, maka kontak saya dapat di lihat di halaman “About Me”

 

Satrio Budi Wicaksono
© 2021 Personal Blog of Satrio | Powered by Superbs Personal Blog theme