Applications are Invited for NRI/NRI Sponsored Seats. (Apply Online )   

Fore School of Management
  • Library
  • FORE in Media
  • Campus Tour
  • Alumni
  • Vacancy
  • Tenders
  • Blog
  • Login
Menu Icon


Download Brochure

Duration: 3 days
Timings: 1430hrs -1745hrs
Dates: June 29 – July 1 , 2022
Programme Director: Prof. Vandana Gupta , Prof. Himanshu Joshi
Mode: Online
Fees: Rs.5500 Plus GST @18%

Programme objectives:

  • Understanding the basics of Discounted Cash Flow Techniques using MS Excel
  • Revenue and Cost Projection for companies
  • Determination of projected cash flows
  • Building appropriate equity valuation model using MS Excel.
  • Building valuation model for M&A

Programme Contents:

  • Concept of Discounted Cash Flow Valuation and Market Comparable Valuation
  • Financial Statement Modelling –
    - Forecasting Income Statement and Balance Sheet
    - Concept of ‘plug’ – using Cash, Debt, and Target Capital Structure as plug
  • FCFF, FCFE, and EVA Valuation Model
  • Estimating the discount rate
    - Estimating equity premium
    - Estimating beta both when the stock trades and when it does not
  • Adjustment for Cash
  • Building a Spreadsheet Model for Valuation
  • Understanding the spreadsheet Logic
  • Closing the Valuation Model
  • Sensitivity Analysis
  • Regression Modelling for Market Comparable Valuation

Programme Methodology:

Interactive mode of teaching including case studies, and practical exercises and model building using MS Excel.

Target Organizations:

Medium and Large scale companies in private and public sectors, financial services firms, Banks and Non-Banking Finance Companies, Investment Banks.

Target Participants:

Professionals, bankers, instructors, institutions and executives engaged in public and private sector enterprises working in the fields of strategic planning, capital budgeting, finance, and valuation.

Programme Director

Prof Vandana Gupta (PGDM-IIM Ahmedabad, PhD Finance)

Prof.Vandana Gupta is a Professor of Finance at FORE School of Management, Delhi India. Her experience spans for 28 years which includes Academics and Industry. She has worked with some leading corporates as Bennett Coleman & Company, Infosys, ICRA (India’s leading Credit Rating Agency) and Religare Securities Limited (equity research). Her teaching areas are Financial Reporting and Analysis, Corporate Finance, Credit Risk, Project Appraisal and Financing and Business Valuations. Her PhD has been in credit risk and her research works are broadly focused on financial distress of Indian corporates, bankruptcy prediction. She has to her credit several research papers in national and international journals and has presented her research in national & international conferences.

Prof. Himanshu Joshi Professor – Finance & Accounting

Ph.D., M.B.A (Finance); FDP (IIM- Ahmedabad); Sp. Dip. in Credit Risk Management, NUS Singapore.

Brief description of Experience: With over two decades of experience in teaching, training, and research, Prof. Himanshu is currently working as Professor with FORE School of Management, New Delhi. He has also been associated with IIM Rohtak, IICA Manesar, and ONGC Academy, Dehradun as Visiting Faculty. He has developed and conducted various executive education programs for corporates and PSUs on Spreadsheet Modelling for Valuation, Enterprise Risk Management, Foreign Exchange Risk Management, and Financial Strategies for Value Creation. He frequently publishes research papers in peer reviewed journals indexed in Scopus, Web of Science, and listed in ABDC and ABS.

Corporate Group Discount:

One complimentary nomination for every group of three nominations from the same organization, i.e., 3+1 participants for the fee of 3 participants.

For registration/enquiries , please mail to or call at 011-26856301/+ 91 9166085159/ +91 9810875278/ + 91 7976445970

Executive Education/MDPs

FORE School of Management has been designing, developing and conducting innovative Executive Education (EE)/ Management Development Programmes (MDPs) for working executives in India for over three decades.