WORKSHOP ON EXCEL BASED FINANCIAL MODELING
AND ANALYSIS
VENUE:
DATE:
November 24 - 25, 2017
INTRODUCTION
PURPOSE
PEDAGOGY
The success of every business lies in effective financial decision making. Financial analysis as a tool for decision making has been used by industry practitioners across the world. The availability of large amount of data along with the changes in technology has necessitated Excel integration in to financial analysis. At present, most of the educational institutes in India teach financial analysis using traditional 'Pen & Paper' model while the industry practices the analysis using Excel. Thus there exists a gap between what is offered in educational institutes and what is practiced in the industry as Financial Analysis. With a view to bridge the gap, CIML organizes this workshop on Excel Based Financial Analysis.
The workshop aims to introduce excel integration in to the methods of financial analysis. The two day workshop will start with introducing to the participants with the basic excel requirements in order to do Financial Analysis. By the end of the workshop, the participants are expected to create their own financial model for Valuation of Companies using Discounted Cash Flow technique
Each session will be led by resource person(s) who will quickly review the theoretical concepts before proceeding with the excel applications for the same. The sessions will be completely Excel driven and will be practically rigorous. Participants are supposed to bring their laptops and are expected to complete the individual / group tasks assigned to them during the sessions.
WORKSHOP ON EXCEL BASED FINANCIAL MODELING AND ANALYSIS
TOPICS COVERED1. BASIC EXCEL REQUIREMENT FOR FINANCIAL ANALYSIS
2. EXCEL BASED FINANCIAL MATHEMATICS
3. EXCEL INTEGRATED INVESTMENT DECISIONS
4. EXTRACTION AND ANALYSIS OF DATA FROM FINANCIAL STATEMENTS.
5. VALUATION OF COMPANIES USING DISCOUNTED CASH FLOW TECHNIQUE
WORKSHOP ON EXCEL BASED FINANCIAL MODELING AND ANALYSIS
DETAILS OF THE WORKSHOP
Overnight Assignments to be worked out by participants outside the session before the next session begins
·
·
·
·
·
Understanding the framework of a financial Model
Good Financial Modeling Practices
Organizing the Historical – (Financial Statements)
Building Financial Ratios for trend analysis & Forecasting
Forecasting the P&L
Balance sheet forecasting and validating
Forecasting the Cash flow statement
Identifying the key drivers of the business using the Economic, Industry and other company data
Case Studies on selected Industries and sectors
(Cash Burn Analysis and What if Analysis)
Simple DCF valuations – (Single Stage and Multi stage)
Free cash flow approach – FCFF, FCFE and hence
Residual Value approach
Market Multiples (P/E,P/B, P/S)
Each group is given a stock of a particular sector. They would be building a financial model from scratch, forecast the models, do validations, identify the right valuation approach and arrive at the valuation of the stock.
Each group will present the models they constructed. They will justify their assumptions and approach to the entire class
Basic financial Modelling exercise
Forecasting using the Financial Model
Sector Based key drivers for the financial models
Finding the Valuation using the financial Model
Group Case study - Financial Modelling exercise
TARGET AUDIENCEThe participants are expected to be thorough with the basic concepts of Financial Management and Financial Statement Analysis. Familiarity with basic excel though expected is not mandatory. The participants can be academicians, research scholars, industry practitioners as well as students aspiring to have a career in finance.
MahidharaDavangere V.,
Soumya V ACSI.
MBA, MFC, MSc (Maths), Associate Actuary (UK)
Mahidhara is the Founder and Managing Director of Pramartha – an Actuarial Risk Management and Consulting firm. Pramartha, which started in 2010 today, has offices across6 countries - India, Australia, South Africa, Malaysia, UAE and United States. He has over 13 years of extensive experience in Research and financial valuation covering industries like Banking, Insurance and Financial sectors in India, South Africa and other emerging African markets. Prior to starting his own firm he worked in Citi Bank, Ocwen and Atom Funds Management (Australia).He is a Board member representing Asia for Finance and Investment Board of Institute and Faculty of Actuaries (IFoA), UK. He is involved with in various regulatory boards overlooking policies and frameworks. He was the Vice Chair for the recently conducted IFoA Asia Conference 2016 in Kuala Lumpur and Upcoming IFoA Asia conference 2017 in Hongkong. He is also the Mathematical Advisor in Scientific Review Committee, a National level Committee set up by Department of Science and Technology, Government of India and Intel to promote innovation in Basic Science and Maths. He was the Regional Co-ordinator for ASEAN Countries and Bangladesh during Indian Science Congress 2014. He is the President of Christ University Institute of Management Alumni Association, Board Member of Actuarial Consulting Congress of Asia and also is an Advisor for Karnataka RajyaVigyanParishad (KRVP)
Prof. Soumya is an Assistant Professor and Head of Finance Specialization in Christ Institute of Management, Lavasa. She is an associate member of Chartered Institute for Securities and Investments (UK) and has 17 years of teaching experience. She is a post graduate in Commerce as well as Management and has completed ICWAI (Inter). Her teaching and research interests include Financial and Management Accounting, Financial Management, Financial Analysis and Taxation.
WO
RK
SH
OP
ON
EX
CEL B
ASED
FIN
AN
CIA
L M
OD
ELIN
G
AN
D A
NA
LYSIS
WORKSHOP ON EXCEL BASED FINANCIAL MODELING AND ANALYSIS
Early Bird discounted
REGISTRATION FEES
fees (paid before
October 10, 2017
Actual fees (paid after October 10, 2017)
Corporates 10000 12000
Academicians 8000 10000
Research Scholars
and Students 6000
8000
VENUE:
DATE:
November 24 - 25, 2017
(The fee includes AC accommodation for one night and two days, workshop kit, certificates, breakfast and lunch for two days. Option for spouse accommodation is available for participants)
The participants will have an option for boating in the beautiful Lavasa Lake.Other attractions are Water Sports, Lavasa City Tour, Nature Trail, Cycling, Segway Ride
and Adventure Sports.
ATTRACTIONS
Pay TM
Bank Transfer
Demand Draft
7264851230
South Indian Bank, Lavasa Branch
A/C No. 0919053000000001
IFSC: SIBL0000919
State Bank of India, Lavasa Branch
A/C No. 033701600928
IFSC: SBIN0014242
DD drawn in favor of
Christ Institute of Management
payable at Lavasa.
ABOUT THE ORGANIZERSChrist Institute of Management Lavasa
Pramartha
Christ Institute of Management (CIM), Lavasa is the latest addition to the renowned Christ University Trust Institutions which promote Christ University Bengaluru, the best deemed University in India which was awarded an A grade by NAAC. Christ Institute of Management Lavasa offers two year full time Post Graduate programmes in Management. From its inception the institute has been able to consistently attract future corporate leaders from across the country. In addition to the regular specialised programmes in Marketing, Finance and Human Resources, CIM Lavasa also offers a cutting edge introduction to data based decision making through its latest specialisation on Business Analytics. Through its differentiated pedagogy, world class infrastructure and superior academic environment, situated in the serene hill station, Lavasa, CIM Lavasa is destination excellence for management education and research.
Pramartha is a risk consulting firm with expertise in actuarial, quantitative and analytics with its operations spread across more than seven countries .Pramartha is one of the few Indian firms working in the wider area of Actuarial Applications, Enterprise Risk Management, Quantitative Techniques and Analytics and has developed in house tools and techniques to access a company's risks across sectors and geographies. With in depth expertise in formulating cutting edge strategies Pramartha convert your business risk into opportunity.
Pramartha Centre for Education and Research (PCER)
Pramartha Centre for Education and Research is a division of Pramartha which focuses on Education and Research in the area of Mathematics, Data Science, Actuarial Science, Analytics etc. Pramartha provides Certifications, workshops, Diplomas, FDPs and MDPs on subjects like Advanced Excel, Big Data Analytics, Financial Modelling through its higher education wing PRAMLAB. The courses are offered both online and offline. PRAMLAB has delivered the courses in across the country to more than 25000 candidates.
Payment Mode:
Pick up and drop facility between Pune and Lavasa.· Pick Up from Pune – Previous evening of the workshop : 6.30 pm , Day 1: 7.00 am· Pick Up from Lavasa – Day 2: 4.30 pm
30 Valor Court, At Post: Dasve Lavasa,Taluka: MulshiPune 412112, Maharashtra.
Contact Us:
How to Apply:
Visit : cimlavasa.inPhone : 1800‐123‐2009 (Toll Free)
WORKSHOP ON EXCEL BASED FINANCIAL MODELING
AND ANALYSIS