Financial Modelling
Online Course
600 Videos
Life Time Access
Future Updates
100% Practical
Request Call Back
Beginner to Pro Financial Modeling Online Course. Get Trained in Financial Modelling and Valuation using step-by-step video tutorials.
Learn comprehensive financial modeling, forecasting and business valuation techniques for Finance professionals with the help of Financial Modelling Online Self Paced Course.
Financial Modeling Online Self Paced Course Description
This step-by-step financial modeling course has been taught to several professionals as well as beginners. In this course, you will learn to make financial model by working in Excel and following along with the video.
Benefits:
- Lifetime Validity on Mobile App ( IB Institute)
- Lifetime Validity on LMS on Student login @ www.ibinstitute.in
- Immediate access
- lifetime Updation on Investment Banking Industry's latest demand & Trend
- Downloadable Videos can be played offline(without internet) on mobile app
- Downloadable Exercise Assignments Case Studies PPT and PDF
- Query session with faculty
- Ideal Resume Making session for Investment banking and other core Finance roles
- Interview preperation KIT for Investment Banking roles with sample cvs
- What and what you should not do as Analyst in your professional career
- know key elements to get faster in growth in Core Finance Industry by Investment bankers
What you’ll learn in this Online Self Paced Course
- Basic & Advance Excel 2013/16
- VBA Macro Programming
- Dashboards / Pivot Table
- Financial Statement Analysis
- Ratio Analysis
- Financial Modules (Case Study)
- Financial Model - Netflix OTT (Entertainment Sector)
- Financial Model - Tata Motors (Auto sector)
- Financial Model of Kellogg's Quarterly Model
- Financial Model on Telecom Sector (Uploading Soon)
- Financial Model - Colgate (FMCG Sector)
- IPO Valuation (Uploading Soon)
- Project Finance (Real Estate)
- ( DCF ) Analysis
- Trading Combs Valuation Technique
- Transaction Valuation Technique
- Merger and Acquisition Analysis
- Pitchbook Benchmarking
- Company Profiling
- Interview Preparation Kit
- Equity Research Model
- Financial Model - XTO Company (Oil & Gas Sector)
- Business Valuation
- CAPSTONE PROJECT
Financial Modelling & Company Valuation with M&A Course Includes
Basic & Adv Excel 2013/16
Basic Excel starts from very basic and goes to a very advanced level gradually.
VBA Macro Programming
(VBA Macro Programming is an advanced tool in MS Excel that makes you Super Here in Excel
Dashboards / Pivot Table
Create dynamic Excel dashboards to display large data sets that can be interpreted easily using Pivot Table
Financial Statements
(Understand Each item of Financial statements & perform impact analysis.
Ratio Analysis
Learn how to do Ratio Analysis of the company from scratch
Financial Model (Case Study)
Create Financial Model of Generic Company from Blank Excel Sheet
Financial Model - Netflix OTT
Create Financial Model of Netflix Company from Blank Excel Sheet
Financial Model - Tata Motors [Automobile]
Create Financial Model of Tata Motors from Blank Excel Sheet
Financial Model of Kellogg's
Create Financial Model of Kellogg’s (Quarterly Model) from Blank Excel Sheet
Financial Model of Telecom Sector
Create Financial Model of Telecom Sector (Uploading soon) from Blank Excel Sheet
Financial Model of Colgate
Create US based Company’s Financial Model from the FMCG sector
IPO Valuation
(Uploading Soon)
Project Finance (Real Estate)
(Analyze and Appraise Real Estate Commercial Project with NPV & IRR)
DCF Valuation
(DCF Valuation for a company Oil and Gas Sector from Scratch)
Trading Combs Valuation
(Relative Valuation for 10 listed Companies)
Transaction Valuation Technique
(Transaction Valuation based on 5 historical Deals)
M&A Analysis
(Analyze Company Post Merger for Accretion or Dilution Analysis)
Pitchbook Benchmarking
(Vital elements of a professional Pitchbook )
Equity Research Model
Financial Model Of XTO Company
Business Valuation
(Analyze Company Post Merger for Accretion or Dilution Analysis)
Company Profiling
(These are very crucial parts of an Investment Bankers’ profile. )
CAPSTONE PROJECT
you will be preparing a capstone project under the guidance of industry experts
Interview Preparation Kit
Learn how to prepare your resume from the Investment Banking industries’ point of view
Register in Financial
Modelling Online Course
By the completion of this Financial Modelling online self paced course you will
- You will become a Pro in Excel
- You will be able to create a financial statement from scratch
- You will be able to build a Cash Flow statement
- You will be able to create a model with multiple scenarios
- You will be able to forecast the revenue of the company
- You will be able to know how to perform valuation of a company
- You will be able to create project finance model from scratch
- You will be able to perform valuation of a STARTUP company from Venture Capital point of view
- You will be able to perform sensitivity analysis
- Create a professional and attractive advanced chart
- Create a professional and attractive Pitchbook and performing Benchmarking and Price Rebasing
- You will be able to understand Macro using VBA Coding
- Most Importantly you will be INTERVIEW READY!!
By the completion of this Financial Modelling online self paced course you will
- You will become a Pro in Excel
- You will be able to create a financial statement from scratch
- You will be able to build a Cash Flow statement
- You will be able to create a model with multiple scenarios
- You will be able to forecast the revenue of the company
- You will be able to know how to perform valuation of a company
- You will be able to create project finance model from scratch
- You will be able to perform valuation of a STARTUP company from Venture Capital point of view
- You will be able to perform sensitivity analysis
- Create a professional and attractive advanced chart
- Create a professional and attractive Pitchbook and performing Benchmarking and Price Rebasing
- You will be able to understand Macro using VBA Coding
- Most Importantly you will be INTERVIEW READY!!
Learn Financial Modelling &
Valuation from Scratch
Three Certifications
CERTIFICATION IN “Advance Financial Modelling using Excel & Macros from IBI”
Company Valuation for Merger & Acquisition with Pitchbook Preparation
Certification IN “IPO Valuation and Equity Research
Career Opportunities After
Completion of Course
- Group Manager
- Financial Manager
- Consultant
- Equity Research Analyst
- Investment Banker
- Research Analyst
- Wealth Manager
- Venture Capital Analyst
- Transaction Advisory
- Finance Analyst
- Portfolio Manager
- Business Valuation Analyst
- Quantitative Analyst
- Credit Analyst
- Project Finance
- Investment Partner
Our Placement Partners
