Hi I need help with my Detailed Stock Valuation Project the stock I need to work on is Walmart normally there is a spreadsheet that I need to fill up but didn't know how to upload the spreadsheet here so I'm just putting the questions.

Detailed Stock Valuation Project

Profitability and Growth

Load your companys 10 years of historical data into spreadsheet.

Analyze the companys historical revenue growth and profit margin. Identify 3 main competitors and see they compare to your company in these two measures. Make a forecast for your companys revenue growth and profit margin out into the future.

Operating Capital

Analyze the components of your companys operating working capital and long term operating capital relative to revenues on a historic basis. Also look at the same measures for your 3 main competitors. Make a forecast for your companys operating and long term working capital.

Detail and support the calculation of your companys weighted average cost of capital.

Valuation

Calculate the companys historic return on invested capital and your forecast for it out into the future. Compare to the historic return on invested capital for your 3 main competitors.

Valuation Sensitivity

Show the sensitivity of your valuation to key assumptions:

1. Next few years and intermediate term revenue growth
2. Profit margins
3. Operating Capital as a percent of revenues
4. Weighted Average Cost of Capital
5. Long Term Return on Invested Capital
6. Growth Rate at Maturity