Query
|
Financial Modelling With Excel |
|
|
Name* |
|
|
Ph. No.* |
|
|
E-mail* |
|
|
Query* |
|
|
|
|
Topics
Program Objective:
Ms Excel ® is today unarguably the most commonly used spreadsheet utility globally to do finance. In spite of this, according to various surveys on Excel usage, rather miniscule percentage of Excel use it to its full potencial. The focus of the course is to help the participants learn the tools and capabiloities of this spreadsheet applicatio to perform from the simplest to the most complicated and elaborate fianacial analysis.
Modelling for Corporate Finance Transaction
Case Outline and the process participants will go through in solving the case and structuring an LBO/MBO transaction
The good thing about an over-engineered software like Excel is that it very well equiped to perform the most sophisticated and detailed financial analysis. The downside to this is that financial analysis workbooks are becoming increasingly bulky and unstructured. Many a times, they develop into unweildy, clumsy and difficult to manage models, with the user having no clue as to what’s going in the spreadsheet and if the results are accurate in the first place. Therefore, structuring good financial models is as much an art as a science.
The important aspects this workshop focuses on is to apply the tools effectively while constructing financial models, caring for scalability, making them flexibile, structuring in such a way that auditing the model results is not cumbersome. These essential attributes make financial models accurate, flexible and user-friendly. The workshop would use a ‘learning by doing’ approach, because that’s how the science and art of financial modeling is learnt.
Results:
We expect that the participants attending the course will be able to learn significant financial modeling capabilities using Excel that would be pertinent for corporate finance, financial analysis, risk management, transaction structuring like modeling for M&A, etc. The level of the course is Intermediate to advanced.
Key Benefits:
- Master the use of Excel’s financial modelling tools and capabilities
- How to design a model to suit your purpose
- Understand the different types of financial models and when each should be applied
- Construct financial models making use of a broad range of Excel methods and techniques
- Accurate forecasting corporate cash flows for project finance deals and structures
- Incorporate elements such as risk, sensitivity, optimisation and forecasting into financial models
- Produce meaningful management reports and charts for communication
- How to identify and control key sensitivities through advanced spreadsheet simulation
- How to design a model to maximise flexibility and reliability
- Practical tips for checking and debugging the mode
Program Faculty:
An Investment Banking professional with over 10 years of experience and a strong focus on medium sized organizations. He has hands on experience of setting up systems in start up and growth companies and is well networked in the investment banking and private equity space. He has strong sector exposure in Cement, Automobiles, Textiles and Infrastructure. With him, UNICOM has developed training modules to simplify financial modeling and investment analysis for corporate executives in order to cope with financial and strategic responsibilities.
Who Should Attend:
- Corporate Finance Professionals
- Quantitative analysts
- Investment Bankers
- Risk professionals
- Treasury managers
- Controllers
- Data analysts and economists
Dates & Venues:
| Date | City | Location |
| 13th - 14th April, 2012 | Mumbai | TBD |
| 20th - 21st April, 2012 | Delhi | TBD |
Session Details:
Day One:
Session One: Basics of Excel (9:30 am- 10:30 am)
- Financial functions
- Logical functions
- Statistical function
- Mathematical function
- Lookup and reference function
- Date and time function
Session 2: Business valuation – theory, practice and model development ( 10:45 am - 12:15 pm)
- Introduction to valuation
- Capital Market role
- Economy-industry-company role
- Interpreting Financial Statements
- Income Statements
- Cash Flow Statement
- Analysis of Financial Statements
- Ratio Analysis
- DuPont Analysis
Session 3: ( 1pm - 3:30 pm)
- Theories of Capital Market
- Efficient market hypothesis
- Understanding Return,
- Risk and Risk Premiums
- Analyzing corporate strength
- BCG, Porter’s model etc.
- Corporate Financial Planning
- Forecasting and growth rate assumption
- Cost of capital
Session 4: (3:45 pm - 5:30 pm)
- Valuation Approaches
- Dividend discount Model
- Free cash flow models
- Relative valuation model
- Sum of parts valuation
- Relative valuation model
- Sum of parts valuation
Day 2:
Session 5: Case Study (whole day exercise) (9:30 am- 5 pm)
- Selecting a company Sources of data assimilation
- Analyzing the strength of the company and it’s competitors
- Preparation of earning model linking Income Statement
- Balance Sheet and Cash Flow Statement
- Forecasting with assumptions
- Valuation of company
- Sensitivity analysis of the model
Workshop Fees:
| Amt in INR | |
| Course Fees | Rs 14,000 /- |
| Service Tax (12.36 %) | Rs 1,442 /- |
| Total | Rs 15,442 /- |
Total Fees: Rs. 15,442 /- (Including 12.36% service tax)
Early Bird Fee : Rs 13,000 + 12.36% ST (Register 7 days or more prior to the program date)
Payment Options:
1. Pay by Cheque/DD in favor of "OptiRisk Learning Systems (P) Ltd" payable at Chennai.
Send the cheque / DD to the following address along with the registration details.
OptiRisk Learning Systems (P) Ltd,
L-468, Ground Floor, 21st Cross Street ,
Thiruvalluvar Nagar, Thiruvanmiyur.
Chennai - 600041
Ph: 044 4501 8472 / Mob: +91 90945 32918
[ OR ]
2. Pay by bank transfer to the following bank account.
| Online Account Details : | |||
| Account Name: | OptiRisk Learning Systems (P) Ltd. | Account Number: | 30801187665 |
| Bank Name: | State Bank of India | IRTGS/NEFT/IFSC Code: | SBIN0011721 |
| Branch : | Valmiki Nagar Branch, Chennai | MICR Code: | 600002157 |
| Acount Type : | Current Account | ||
Upon successful transfer of the payment, please send the transfer confirmation details to contact@optiriskindia.com.
Registration:
Contact Us
For registration and more information on the workshop or to find out about exhibition, sponsoring the workshop, please contact training manager, at contact@optiriskindia.com.
Ph: +91 98406 18472 / +91 44 45018472.