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