Financial Modeling
Program Objective
Excel Modeling techniques are used in many different areas, such as credit analysis, investment appraisal, risk management, valuation, financial analysis and forecasting. This 10 days computer based practical training course intends to address the most pressing requirement of the industry: financial modeling through MS-Excel The programs shall aim to provide the participants with- Understanding the Financial Model
- Techniques and methods for conceptualizing and implementing models for
- Financial Analysis ( P&L, Balance Sheet, Cash flow)
- Portfolio Theory and Cost of Capital ( WACC)
- Business Valuation with focus on Discounted Cash Flow
- Merger and Acquisition
- Project Finance
- Option Valuation, Real Options
- Simulation
- Knowledge of advance excel tools for improved excel efficiency
Program Outcome
After completion of this program participants
- Understand advance excel tools to be used in finance
- Know different types of financial models and their application
- Be able to develop the integrated financial model incorporating forecasting, sensitivity, scenario etc.
Highlights
- 40 Hrs of comprehensive training
- Industry professional Faculty with combined experience of over 30 Years in Investment Banking, Private Equity and modeling
- Case Study based learning
- Hands on modeling sessions and problem solving
- 24X7 online access to industry models and support for revision in future
- Certification for attendance and excellence based on performance
- Placement Guidance
Teaching Methodology
- Highly interactive, use of extensive case studies and real life examples for demonstrating Modeling techniques.
- Emphasis on
- Participants gaining practical, hands-on experience of the design and construction of financial models in Excel.
- Importance of reality-checking and the dangers of spreadsheet blindness,
- Fundamental understanding of key issues.
Who should attend our training
- Investment Bankers
- Research Analyst
- M & A Specialists
- Strategists in Corporate Finance
- Credit analysts from banking industry
- Finance Controllers
- Financial analysts
- Managers from different industries
- Employees in charge of budgeting, operational and investment plans of company development and raising funds
Certification
- Certification for attendance and excellence, based on performance to Mumbai students and Participation Certificate to Online Students.
Day 1
- Introduction to Modeling
- Introduction to Excel as a tool
- Excel and Modeling
- Data Entry Excel Fundamental
- Introduction to Profit&Loss A/c
- Case Study :Creating a P&L A/c in excel
Day 2
- Pivot Tables to Summarize data
- Uses of Formulas like If, Or, And, Trim and formatting of cells
- Formatting the Excel Sheet
- Introduction to Balance Sheet(B/S) statement
- Case Study :Creating a P & L in excel II
Day 3
- Balance Sheet
- Linking B/S to P&L and introduction to cross linking in Excel
- Cash Flows(C/F)
- Introduction to case
- Case Study on financial statement of the company
Day 4
- Model Review and revision of financial statements Financial Ratios
- Financial Ratios
- Using Excel to calculate Ratios
- Introduction to valuation
- Peer review ratios
- Case Study on Financial Rations
Day 5
- Time value of money
- NPV, IRR and calculations in excel, Loan Scheduling
- Cost of Capital
- Calculating cost of equity, WACC
- Calculating Beta using the CAPM Model
- Understanding Goal Seek and Solver
- DCF Valuation using excel
Day 6
- Terminal Value
- Scenario Analysis using excel
- Projecting the financials over period
- Comparing the value derived through DCF and Peer Valutaion
- Discussion of Case on DCF valuation
- Case Illustrating linkages of financial statements
Day 7
- Portfolio Theory
- Plotting Graphs/charts using excel
- Mean, Variance, Explaining Beta
- Inserting Function and Formula
- Diversification and Its measurement
- Volatility Estimation
- Time series generation
- Normal Distribution, generation of Random Number and its usage in Modeling
Day 8
- Excel Tips
- Introduction to option
- Call Put, Paypoff Diagram
- Formatting of Charts, for options Payoff
- Call,PutPayoff Diagram
- Valuing Options on Excel
- Calculation of Implied Volatility using Goal Seek, Solver
- Comprehensive Modeling of Option Pricing using Binomial, Black Scholes
Day 9
- Monte Carlo Simulation
- Using Monte Carlo Sumilation for Option Pricing
- Introduction to Macros
- Recording Macros and Automating task you peform frequently
- Introduction to VBA Language
- Creating a user friendly front end
- Custom defined functions
- Array Functions
Day 10
- Practical Problem I
- Case I - FSA (Take Infy financial Statements)
- Case II - Advanced Concepts
- Closing and Summarization
Download Brouchre
