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
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.