support@essaywritingexpert.orgFirst Report- Capital Structure Analysis: • Analyse the firm’s capital structure, including debt-equity ratios, cost of debt, and overall leverage. • Discuss the firm’s recent capital-raising activities and relate them to theories like Pecking Order Theory. Risk Analysis should be done on excel: • Calculate the firm’s historical return using its stock price data. • Determine the firm’s systematic risk (beta) using CAPM and Fama-French 3-Factor Model and compare it to its industry peers (Choose any 5 competitors of the company as industry peers). • Provide an overview of how the firm manages financial risks (e.g., currency risk, interest rate risk). Report Requirements: • Length: 6-8 pages • Content: o Summary of the selected firm’s financial background. o Analysis of the firm’s capital structure and risk profile. o Relevant financial metrics, with tables/graphs supporting the analysis. o References for all data sources. Second Report should be done on excel- Valuation Analysis: • Perform a Discounted Cash Flow (DCF) valuation of the selected firm using publicly available data. • Compare the valuation with a Relative Valuation approach using price multiples like P/E, P/BV, or EV/EBITDA, and benchmark these metrics against competitors. • Justify key assumptions, such as growth rates, discount rates, and peer selection. Comprehensive Report Requirements (Length: 12-15 pages) Content: Executive Summary • Expanded analysis including firm valuation, assumptions, and sensitivity analysis. • Graphs, charts, and tables illustrating the findings. • Conclusion with insights on the firm’s financial health and growth potential. • References for all data sources. These are 2 parts of a report, need to be done separately. The firm is SBI and it’s 5 competitors are- ICICI, HDFC, KOTAK MAHINDRA, IDFC bank, AXIS Focus on a publicly traded firm. Please use standard templates for all financial models and analysis. Please ensure to use Microsoft Excel for all calculations and analysis. Provide a comprehensive sensitivity analysis covering a wide range of variables and scenarios. The final deliverable should be provided in a Word document format. Feel free to use your own standard templates and formats for the Word document deliverable. Include a detailed sensitivity analysis covering a wide range of variables and multiple scenarios. Ensure the sensitivity analysis includes a moderately detailed breakdown covering numerous variables and intricate scenarios. Conduct the historical return and risk analysis for the last 5 years. Please use standard templates for all financial models and analysis.