Financial Modelling using Excel

Start Date:2013-04-25
End Date:2013-04-27
Event Type:Management Development Programme
Location:IIM Raipur

The program is so designed to keep it jargon free and non-mathematical and useful for anyone using Excel for day to day financial applications.However the program is mainly targeted for:
• Corporate executives involved in financial decision making
• Professionals and research scholars who are actively engaged in analysis of Financial data
Participants are requested to bring their own laptop and charger.  

Event Details:

The important benefits that participants can expect from the program are:
• Understand the core concepts of Financial Management,
• Develop hands-on, spreadsheet modeling skills, and
• Build a number of finance applications, which are fully understandable.
Program Coverage:
The following broad topics will be covered during the program:
• Excel Basics and Data Analysis using Excel
• Forecasting of Financial Statements
o Profit & Loss Statements
o Balance Sheet
o Cash Flow Statements
• Valuation using
o Free Cash Flow Methods
o Investment Valuation
o Valuation of company, Stocks, etc.
• Risk Management
o Risk measures using standard deviation and beta
o Volatility measures using ARCH and GARCH models
• Capital Budgeting
o NPV, IRR and similar measures
• Special Topics
o Value at Risk
o Simulation for financial decision making
o Other relevant contemporary issues
Registration Fee: Rs. 25,000 per participant. This includes Single room accommodation at a Hotel in Raipur, academic fees, program kit for participants, breakfast, lunch, dinner and local transport from Hotel to Institute. Payment can be made either by NEFT or through a crossed demand draft in favour of “Indian Institute of Management, Raipur”.
The Bank Details are :
1. Bank Name     : Union Bank of India
2. Branch Name : Priyadarshini Nagar, Raipur
3. A/C No.             : 612702010001733
4. IFSC Code       : UBIN0561274
Please send the Registration form duly filled in along with NEFT or demand draft details to Ms. Ravishaw Bhatia (MDP-Cordinator) at IIM, Raipur by Post. Alternatively, soft copy of the Registration form (can be downloaded from the Institute Website ( can be mailed to
(Kindly note that 12.36% Service Tax is applicable in addition to the fee. Please note that the Programme Fee should be received at the MDP Office before the Programme Commencement Date).
Last Date: The last date of receipt of nominations for the programme is April 15, 2013 and the last date of withdrawal is April 20, 2013. Withdrawal received after this date will be subject to deduction as per the Institute’s rules. Participants are advised to await confirmation of acceptance before making their travel plan.
For any additional information, please write or e-mail to
Ms. Ravishaw Bhatia
Indian Institute of Management
GEC Campus, Sejbahar, Raipur-492015
Tel : 91-771-2772422/ 2772111
E-mail :