Financial Modelling Program is getting widely popular among finance professionals. Like accounting is incomplete without Tally or Busy software, Financial analysis is difficult without MS Excel. After revolution in IT industry, India is about to experience revolution in Financial Research and related services. Financial Modeling course can give you such an opportunity with TOP MNCs.
- Financial Modeling is creating various financial models in MS Excel using your financial skills.
- You can do various kind of valuation, projections and simulations for business decision making using financial models.
- It can be used in corporate finance, management accounting, risk management, investment decisions, IPO valuation and even more.
How financial modeling can help you in career?
- Financial modeling can help you in testing various business models to analyze its potential.
- You learn methods for valuation, risk modeling, IPO, FPO modeling which are used by Investment banks and private equity companies.
- Commercial Banks use financial projections to evaluate loan requests.
- If you want to work with any Investment Bank, Private Equity, Hedge Fund, Rating Agency or even Corporate Finance, you need to have at least basic financial modeling skills.
Who should do Financial Modeling
- People working in equity research, investment banking, corporate finance, business planning or management accounting.
- CA, CFA, FRM, MBA
- B.Com, B.E. and B.tech having some base in finance.
Financial Modeling Course Content
AIM 1: Basic and Advance Excel
- Basic Of Excel
- Using Name Ranges
- Index Matches
- Formulas and functions
- Logical Functions
- Date Functions
- H Lookup, V-Lookups and Reference Functions
- Database Statistical Functions
- Conditional Formatting
Aim2: Advance Excel
- Camera tool
- Data Tables
- Circular References and breaking them
- Key Concepts in Macros
- Macros as recorded Robots
- Form Contrls and Active X controls
- Implementing user forms in Excel Macros
- Linking forms to excel cells
- Sensitivity tools & Scenario Analysis
Aim3: Financial Statement Modeling and Forecasting
- Data mining and structuring
- Data correcting and validations
- Understanding business models
- Taking Assumptions and integrating them into the model
- Modeling Historical statements
- Modeling Projected Income Statement
- Modeling Projected Balance Sheet
- Modeling The Cash Flow Statement (direct method & indirect method)
- Modeling Working Capital Schedule
- Fixed Assets Schedule (along with treatment of CWIP and Interest capitalization)
- Modeling Depreciation & Amortization Schedule (Straight line & Written down Value)
- Modeling Shareholders’ Equity Schedule with a share repurchase table
- Debt and Interest schedule with a “cash sweep and moratorium” (Classification of debt as Senior Debt, Mezzanine Debt, Sub Debt along with repayment waterfall)
- Modeling for Tax & Dividend
Aim 4: Valuation Methodologies
- Modeling Discount Rate, Cost of Equity, Debt and Total Capital (CAPM and WACC)
- Free Cash Flows to Firm (FCFF)
- Free Cash Flows to Equity (FCFE)
- The Discounted Cash Flow (DCF) valuation model for HCL Technologies
- Estimate Terminal Value using The Perpetuity Growth Model
- Modeling Estimate Enterprise Value
- Calculate Equity Value using the Market Value Balance Sheet (MVBS) technique
- Compute non diluted and diluted share value
- Sensitivity & Scenario Analysis
- Modeling EPS Forecasting
Aim 5: Merger Acquisition
- Building merger plan
- Hostile Vs friendly offer
- Evaluating a merger bid/offer
- Understand Accretion / Dilution Analysis
- Building a Merger consequences Model
- Estimating Synergies
- After-tax Adjustments from Write-ups
- Pro forma Earnings & Pro forma EPS
- Earnings impact
- Computation of Goodwill created with an Acquisition
- LBO Modeling
- Structure of a Leveraged Buyout
- Funding a LBO
- Understanding a LBO Model
Aim 6: Project Financing Models
- Understanding the Project Finance Model
- Risk and contractual arrangement to reduce Risk
- Understanding the Escrow Arrangement and fund arrangement
- Learn about how Project Financing is different from traditional loan/debt financing
- Various elements of a Project Financing Model for an infra project
- Understand about risk management in Project Financing under BOT model
Aim 7: Advance Charting
- Building Primary & Secondary Axis in a Chart
- Radar Charts
- Waterfall Charts
- Football Field
- Gantt Chart
- Storytelling with advanced Financial Graphs & Charts
*Additional Aim 8: Using VBA in Excel
- Using VBA in MS Excel
- Using VAB with Macros
- Debugging VBA Code
- Breaking Circular references
- Monte carlo method
- Study Material
- After training support
- Placement support
Fee: INR 24,000 / USD 400
FAQ: About Financial Modeling Course
- Who should do Financial Modeling Course?Any one working in investment and finance or willing to pursue his career should learn financial modeling. Normally, CA, MBA, CFA, FRM, B.tech, B.com are good candidates.Is their any prior skill required?We expect candidate should have basic knowledge of financial accounting and basic of ms excel.What are the career options available?It is required into various fields of investment and finance like equity research, banking, investment banking, portfolio management, hedge fund, private equity, risk management and other.How much salary I can get after doing this course?Normally, a fresher who is good in finance can get a salary between 3 lac to 6 lac.Do we provide placement assistance?Financial modeling is a valuation addition course. Like other valuation addition programs.
It’ll certainly add value to your profile and help in getting good placement.We also provide deserving candidates placement assistance. We have good placement records.Does your certification approved by AICTE or UGC?Financial Modeling is a value addition certification. AICTE or UGC does not authorizes such programs.
It’s the industry which requires these skills in various jobs.
Why us for Financial Modeling Course?
- We follow ISO quality standards.
- Six Sigma practice for error handling.
- Contents are developed by CFA, FRM, MBA, PHDs.
- Cross verified by working professionals and updated on students feedback.
- Old students are given updated material without any extra charge.
- Periodic Mock test and case studies.
- 20+ locations around the globe.
- 11+ Courses with international curriculum.
Award and Recognition:
- Awarded Best Training Institute in Financial Services.
- Rated 4.5 out of 5
- Follows ISO quality guidelines
- Over 7000 fans following
- 10000+ students trained
- Working professionals from 89 different MNC have already joined our programs.
- Blue Ocean, USA –CFA Live Projects
- Reliable Solutions, Mumbai – Knowledge Partner
- ShareKhan, Mumbai – Business Partner
- VerticalSlab, Delhi – Placement Partner
- GARP, USA – FRM Training
What is Financial Modeling?
Watch this video to know more about Financial Modeling. How it can help you in your career? How can you use it in various job profiles and what all you learn.