I need to 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:
- Sales growth
- Profitability
- Efficiency
- Returns
- Liquidity
- Leverage
- 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.
I need this assignement by the 6th of May. Attached are the detailed requirements of the assignment (Please note I only have to do it for Walmart). Also attached are examples of vaguely how the 3 statement model should look like, and how the analysis should be
