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.