Please enter your details.The download link would be sent to your email.
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.
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 exed@fsm.ac.in or call at 011-26856301/+ 91 9166085159/ +91 9810875278/ + 91 7976445970
Enquiry Form
Please enter your details to enquiry.
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.
