Account And Finance 3 Statement Model Valuation

Question # 00791178 Posted By: Ainsley Updated on: 01/25/2021 09:54 AM Due on: 02/25/2021
Subject General Questions Topic General Academic Questions Tutorials:
Dot Image

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:

  1. Sales growth
  2. Profitability
  3. Efficiency
  4. Returns
  5. Liquidity
  6. Leverage
  7. 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 

Dot Image

Click chat on right side to get answer. Click on Chat
Whatsapp Lisa