Corporate Financial Modeling using Excel

A uniquely designed residential programme offered to the working executives across India.

Session starts from 22 Oct. 2024

Session ends on 25 Oct. 2024


    Corporate Financial Modeling using Excel

    Conventional Strategy is mostly about outperforming competitors and capturing a greater share of the existing market. However, these strategies are becoming susceptible to increasing competition in a globalized world. The traditional approach fails to consider disruptive innovations because industry boundaries are becoming fragile. Consequently, many successful companies of yesteryears are struggling to maintain their dominance. Hence, in this complex business environment companies are required to create a new market – also known as Blue Oceans. Challenge for aspiring managers is to sense and seize new growth opportunities by looking beyond existing customers.


    Get to know what the programme is all about


    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


    Get your total course expenditure



    Before registering get to know a bit about your director


    Prof. Pitabas Mohanty

    MA (Economics), Grad CWA, Fellow (IIM B), Fulbright Scholar at NYU-Stern.

    With over 25 years of teaching expertise in investments and corporate finance, Professor Pitabas Mohanty brings rich academic and professional experiences. He served as a Visiting Scholar at New York University's Stern School of Business in 2009-2010. Prof. Mohanty is a fellow of the Indian Institute of Management, Bangalore, and a Cost Accountant. Instrumental in leading various training programs, his extensive teaching and training portfolio comprises companies in India and internationally, notably in Dubai, Qatar, and Kuwait, focusing on company valuation and financial modeling.


    For program related queries, contact

    Management Development Programme