MDP on financial modelling was organised by JIMS, Sector 5, Rohini on Saturday, 25th May, 2019 in college premises for the corporate executives and managers. Our resource persons for the day were Dr Parminder Kaur, Professor-Finance, JIMS and Mr N P Singh, Associate Professor-Finance, JIMS. The motive was to give the participants an understanding of financial modelling and its application in decision making. Financial Modelling uses historical information on companies to analyse the company performance on relevant financial parameters. This analysis is then used as an input to build financial models. These models project the future financial performance of the project/companies and help to make financial decisions like viability of projects, valuation of companies and price targets for stocks etc.
The program started with the introduction and welcome of the resource persons. Without any delay Dr Parminder Kaur started discussing advance excel tools like formatting of excel sheets data, filter and sort, vlookup, hlookup, index, pivot tables, nesting of function etc. After tea break, Dr Kaur covered basics of financial statement analysis- financial reporting mechanics, income statement, balance sheet, cash flow statement and financial analysis techniques. The post lunch session was taken up by Mr N P Singh wherein he discussed an exhaustive case study on valuation model using DCF approach. The participants had hands on experience during the entire program.
It was indeed a day long interactive programme which proved to be productive for the participants. The session ended with valedictory session. Dr Pooja Jain, Director JIMS gave away certificates to the resource persons as well as the participants. The event was concluded successful with the support of the Dr Sumesh Raizada, Professor JIMS and Mrs Vijeta in organising this event.