Account and Finance 3 statement model valuation

profiledanishsiddiquie

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 

  • 4 years ago
  • 45
Answer(2)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    AnswerDocument.docx

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    WalmartFinancialPerformance1.docx
  • attachment
    WallmartFinancialModelling.xlsx
  • attachment
    WallmartFinancialModellingeditedcopy.1.xlsx