Corporate Financial Modeling using Excel

This program is meticulously designed for executives eager to delve into the world of financial modeling using Microsoft Excel. Our objective is to equip you with a robust understanding and practical skills in constructing and interpreting financial models, ranging from foundational project financial models to comprehensive financial statement analysis and advanced valuation techniques. Through a blend of theoretical insights and hands-on exercises, you will emerge with the proficiency to apply these models in real-world scenarios, enhancing your decision-making abilities and elevating your professional standing in the financial sector.

The program will be offered primarily through a mixture of lectures and practice sessions. Participants are required to bring their own laptops to the class. 

Over the course of four days, participants will immerse themselves in the diverse aspects of Excel and corporate finance modeling. The initial one-and-a-half days, comprising six sessions, are dedicated to hands-on experience in constructing a project finance model. During this phase, participants will learn the essential principles and practices of crafting professional financial models, gaining insights into what to do and what to avoid. The latter half of the program, also spanning six sessions, focuses on developing an advanced model. Here, participants will forecast a company’s financial statements and engage in its valuation. A key feature of our program is the emphasis on experiential learning; participants will not receive any pre-made templates. Instead, they will develop both models from the ground up, ensuring a deep, practical understanding of the modeling process.

Financial consultants, Security analysts, and Corporate finance managers in charge of valuation and project appraisal. 

• Building an introductory Project Financial Model

• Softer aspects of model building

• Managing dates

• Managing likely delays in the construction

• Determination of Project IRR and Equity IRR

• Managing mid-year and year-end discounting

• Preparing an Integrated Financial Statements Model

• Balancing the Model

• Modeling Circularity in the Model (with and without the use of macros)

• Determining the enterprise value

• Managing circularity between value and cost of capital

• Preparing an executive summary containing football field charts, dynamic charts and valuation summary

• Sensitivity Analysis

22-25 October 2024.  XLRI , Jamshedpur