Integrated financial forecast model

Question description

I need to make the two companies on the same file together with 20 pages please .

Do the analysis of these firms and develop an equity research report for each firm that includes:

  • A competitive analysis of the industry and the firm’s competitive positioning
  • Financial analysis of both firms
  • Integrated financial forecast model developed in Excel
  • Determination of each firm’s weighted average cost of capital
  • A valuation of each firm utilizing both comparables and DCF approaches
  • One year target stock price with rationale
  • Investment thesis/recommendation
  • Scenario analysis ( you find the scenario list in the revenue build sheet ,1 to 3, change the scenario and analysis them, and how they affect the enter value (valuation )

I already did the Excel File, please Analyze the Excel file based on the outline.