Accounting homework help

Accounting homework help.

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

  • attachment

    FinalExamSpring2020.pdf
  • attachment

    apple3statementmodel.xlsx
  • attachment

    Homework9withSolutionsandRubrics1.xlsx

Accounting homework help