Financial Modeling Program
- Offered byIplane education
Financial Modeling Program at Iplane education Overview
Total fee | ₹24,000 |
Mode of learning | Online |
Official Website | Go to Website  |
Credential | Certificate |
Financial Modeling Program at Iplane education Highlights
- Earn a certificate from Iplane
- Get after training support and placement support after completion
- Get access to periodic mock test and case studies
- The program follows ISO quality standards
Financial Modeling Program at Iplane education Course details
- For People working in equity research, investment banking, corporate finance, business planning or management accounting.
- For CA, CFA, FRM, MBA
- For B.Com, B.E. and B.tech having some base in finance
- 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
- Financial Modeling is creating various financial models in MS Excel using your financial skills
- Students 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
- If student want to work with any Investment Bank, Private Equity, Hedge Fund, Rating Agency or even Corporate Finance, they need to have at least basic financial modeling skills
Financial Modeling Program at Iplane education Curriculum
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
Other courses offered by Iplane education
Student Forum
Anything you would want to ask experts?