Assignment: Account and Finance Statement Model Valuation
Create a 5 year 3 statement model (Income statement, balance sheet, Cash Flow statement, DCF) for Walmart, using annual statement SEC filings by Walmart online. I will also need to forecast for the next 4 years using assumptions based on how Walmart will perform during and after the coronavirus pandemic. Things that I will be calculating are:
o Sales growth
o Profitability
o Efficiency
o Returns
o Liquidity
o Leverage
o WACC
Finally, based on all the information, I need to create a report suggesting whether someone should buy, hold, or sell the stock, carefully explaining the assumptions I made, and analyzing the calculations.
Format your assignment according to the give formatting requirements:
a. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
b. The response also includes a cover page containing the title of the assignment, the course title, the student's name, and the date. The cover page is not included in the required page length.
c. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.