Financial Modelling
Live Course
Weekend Classes
Online Offline Both
3 Months course
100% Placement
Life time Access to 600 Videos Free
Request Call Back
12 + Projects
Practical Projects on Financial Models, Valuations, Merger, Industry Research, Project Finance
Study Material
Study Material for future reference in the form of PPT, PDFs, Videos, Question Banks, Resume Templates, Interview tips.
Mock Interview
Learn to plan your interview, Resume preparation, Introduction, Models Explanation, Interview Case Studies
Internships
Qualify for Internship opportunities in Investment Banking or other Core Finance profiles with paid stipend.
Hiring Partners
More then 300 hiring partners are looking for Financial Analysts and Investment Bankers after the Courses
12 + Projects
Practical Projects on Financial Models, Valuations, Merger, Industry Research, Project Finance
Study Materials
Study Material for future reference in the form of PPT, PDFs, Videos, Question Banks, Resume Templates, Interview tips.
Assignments
Learn to plan your interview, Resume preparation, Introduction, Models Explanation, Interview Case Studies
Internships
Qualify for Internship opportunities in Investment Banking or other Core Finance profiles with paid stipend.
Hiring Partners
More then 300 hiring partners are looking for Financial Analysts and Investment Bankers after the Courses
Financial Modelling & Valuation Course
Financial Modelling and Valuation Course by IB Institute, offering Live classroom course as well as Online Financial Modelling Training for students and working Professionals.
With the help of Financial Modelling and Valuation Course you will be able to make Financial Projection of the company on the basis of assumptions and schedules. Financial Model includes the Projection of Income Statement, Balance Sheet and Cash Flow Statement. Financial Modelling and Valuation is the most required skill in Equity Research, Investment Banking, Project Financing, Credit Research, Hedge funds or any other mainstream Finance profile.
Financial Modelling & Valuations skills are required in all kinds of Finance Profiles. These skills are applied in Investment Banking, Equity Research, Project Appraisal, KPO, and Credit Rating, Private Equity, Venture Capital, Hedge Fund etc.
Financial Modelling & Valuation Course Modules
- Basic & Advance Excel 2013/16
- Dashboards / Pivot Table
- Visual Basic Application (VBA Macro)
- Introduction to Financial Statements & Analysis
- Multi Tab Financial Modeling from Scratch (Oil & Gas Sector)
- Multi Tab Financial Modeling from Scratch (OTT Platform - Netflix)
- Multi Tab Financial Modeling from Scratch (FMCG - Kellogg's)
- Project Finance (Real Estate Model/ Solar Power Model)
- Discounted Cash Flow Valuation ( DCF ) Analysis
- Trading Combs Valuation Technique
- Transaction Valuation Technique
- Merger and Acquisition Analysis
- Pitchbook Benchmarking Price Rebasing Company Profiling.
- Placement and Interview Preparation for Core Finance Roles
- Business Valuation
- IPO Valuation
- Equity Research Model
- POWER BI
- Capstone Project & Assesment
- Interview Preparation/ Resume Preparation / Mock Interview
Placements
- We have 100% Placement Record for this program in last 14+ yrs Our students are placed on the roles of Financial Analyst, Research Analyst, Equity Research Analyst, Business Analyst, Credit analyst, Valuation Analyst, Venture
- Capital Analyst, Portfolio Analyst/ Manager, Fund Manager, Corporate Finance Analyst, etc based on previous profiles they are hired on different hierarchies for this designation.
- Interview preparation starts right from the first class post every class you will get an interview preparation question sets related to that topic and the question asked in Investment Banking, Equity Research, Private Equity industry
Basic and Adv Excel 2019/21 and MS Office 365
Financial Statements Introduction
Financial Statement Analysis
Financial Modelling
Project Finance
DCF: Discounted Cash Flow
Company Comparable Analysis
Comparable Transaction Analysis
Merger Model
LBO Model
Equity Research Report Writing
Company Profile and Pitchbook
Placement Support
Industry Research
Basic and Adv Excel 2019/21 and MS Office 365
100+ Functions and Tools
- Master the essential tools of Excel for financial analysis and reporting.
- Learn advanced Excel functions to streamline financial modeling tasks.
- Utilize MS Office 365 features for seamless collaboration and productivity.
- Pivot Tables and Charts
- VLOOKUP and HLOOKUP
- Conditional Formatting
- Data Analysis Tools
- Text Function
- Financial Functions
- Date and Time Functions
- Lookup and reference function
- Excel Short cuts
- Working with multiple sheets and workbooks
- 100+ Excel function and short cuts
Financial Statements Introduction
- Gain an understanding of the core components of financial statements.
- Interpret balance sheets, income statements, and cash flow statements.
- Learn each item of Financial Statement and Link between them.
- How any change in IS will affect Balance Sheet, Income Statement, SOCE
- Notes to Financial Statements, Financial Accounting vs Tax Accounting
- Def Tax, Minority Interest, APIC, SBC, Accrued Compensation etc
- Basic and Diluted EPS, Current Asset, LT Assets, Goodwill etc
- Analyze the difference in Financial Statement of many companies
- Cost Sheet for COGS calculations
- Numerical Example for Financial Statements
- Operating Lease Vs Finance Lease
- Financial Accounting Vs Income Tax Accounting
Financial Statement Analysis
- Learn to calculate and interpret 100+ key financial ratios.
- Assess liquidity, profitability, solvency, and efficiency of a company.
- Use ratios to benchmark against industry standards and peers.
- Liquidity Ratios (e.g., Current Ratio)
- Profitability Ratios (e.g., ROA, ROE)
- Solvency Ratios (e.g., Debt-to-Equity Ratio)
- Efficiency Ratios (e.g., Inventory Turnover)
- Valuation Ratios
- Du Pont analysis
- Vertical Analysis
- Horizontal Analysis
- Trend Analysis
- Website refences for ratio analysis
- Theory and Practical analysis
- Define, Calculate and Interpret ratios
Financial Modelling
APA Corp, McDonald’s, Apple, Tata Motors, Netflix, Kellanova
- Create the Financial Model for multiple companies from Blank Excel.
- Download latest financials of company annual reports and Qtr files
- Apply financial Modelling techniques to analyze companies across various sectors.
- Build dynamic models for companies like McDonald’s, Netflix, and more.
- Incorporate historical data and assumptions to forecast future performance.
- Revenue Build-up Models for multiple companies/industries
- Cost Build-up Models, Debt, Equity, WC, Dep schedules
- Sensitivity Analysis
- Scenario Analysis
- Build the Model from Blank Excel / scratch
Project Finance
Solar Power Plant / Hotel Construction/ Real Estate Commercial Project
- Learn to create difference type of Project Finance Models
- Construct financial models for real estate, hotel, and Solar renewable energy projects.
- Calculate cost of Projects and sources of funding
- Evaluate project feasibility and financial viability.
- Understand cash flow dynamics and project financing structures.
- Real Estate Construction Commercial Project Model
- Hotel Construction Project Model
- Solar Power Plant Model
- Build the Model from Blank Excel
- Capital Budgeting techniques like NPV and IRR to know profitability
- Build the model from blank excel file
DCF: Discounted Cash Flow
Build Model from Scratch
- Learn the theory and practical application DCF Valuation technique.
- Master the DCF valuation method to estimate the intrinsic value of a company.
- FCFF vs FCFE, WACC vs Ke, Levered Beta Vs UnLevered beta
- Learn to discount future cash flows to present value using appropriate discount rates.
- Understand the sensitivity of valuation to key assumptions.
- Forecasting Free Cash Flows | FCFF and FCFE
- Determining the Discount Rate | WACC and Ke
- Terminal Value Calculation using Multiple and perpetual method
- Enterprise Value and Equity Value Calculations
- Type and Use of Multiples in Valuation
- Sensitivity Analysis
- Analyze your DCF knowledge with 100+ Q&As sheet
Company Comparable Analysis
Build Model from Scratch
- Create Combs Model template from Blank Excel file
- Include Input sheets, Output sheet, Switches, Currency Converter
- Calandarization
- Learn the step by step process to find comparable companies
- How to Use Equity and Enterprise Value multiple for valuations
- Difference in LTM, NTM, Current multiples
- Historical Multiple and Forwards multiples
- Update 10+ companies financials in model for practice
- Learn how to do Benchmarking and use it in valuation
- Identify comparable companies based on size, growth, and financial metrics.
- Calculate valuation multiples such as P/E ratio, EV/EBITDA, and P/B ratio.
- Selection of Comparable Companies
- Financial Metrics and Ratios
- Valuation Multiples Calculation
- Interpretation and Analysis
Comparable Transaction Analysis
- How transaction combs is difference from Trading Combs
- Develop the knowledge of various multiples, their calculations and uses
- Create Transaction Combs template with Input and Output sheet
- Identifying the Comparable Transactions
- Gathering transaction Data | Historical Deals in same domain
- Analyse Transaction Multiples
- Offer Price, Premium Calculation, Enterprise value, Dilutions,
- Normalise metrics and remove onetime and non-recurring items
- Apply multiples to target company to find its value
- Interpret the results
- Learn terminologies related to Treasury stock method, If-Converted method, In the Money Options, Other Dilutive securities, Restricted stock units
Merger Model
- Create an Accretion and Dilution merger Model
- Theory and practical included
- Understand the financial implications of mergers and acquisitions.
- Build integrated financial models for combined entities.
- Analyze accretion/dilution, synergies, and pro forma financial statements.
- Combining IS and BS of Acquirer and Target
- Purchase Price Allocation, goodwill calculations, Deal Value, Enterprise Value
- Accretion/Dilution Analysis
- Pro Forma Financial Statements
LBO Model
- Master leveraged buyout Modelling techniques used in private equity transactions.
- Analyse potential returns for investors and debt repayment schedules.
- Understand key terms such as leverage, equity contributions, and exit strategies.
- Leveraged Buyout Structure
- Debt Schedule and Cash Flow Waterfall
- IRR and Equity Returns Calculation
- Exit Strategies Evaluation
Equity Research Report Writing
- Develop comprehensive equity research reports for investment analysis.
- Communicate investment recommendations supported by financial analysis.
- Understand industry trends, company performance, and valuation methodologies.
- Company Overview and Industry Analysis
- Financial Performance Evaluation
- Investment Thesis and Recommendation
- Risk Factors and Conclusion
Company Profile and Pitchbook
- Create professional company profiles and pitchbooks for presentations to investors.
- Highlight key financial and operational metrics to showcase company performance.
- Tailor presentations to specific target audiences and investment opportunities.
- Business Overview and History
- Financial Highlights and Performance
- Investment Proposition and Growth Potential
- Visual Presentation Design
Placement Support
- Receive personalized assistance in preparing resumes and interview strategies.
- Gain insights into handling interview questions and case study solutions.
- Benefit from mock interviews and feedback sessions for improved performance.
- Resume Writing and Formatting
- Interview Preparation Techniques
- Case Study Analysis and Solution Development
- Mock Interviews and Feedback
Industry Research
- Understand the purpose and importance of industry research in investment banking.
- Analyze market size, growth trends, and competitive landscape.
- Identify key industry drivers, challenges, and regulatory impacts.
- Differentiate between qualitative and quantitative research methods.
- Utilize tools like SWOT, PESTLE, and Porter’s Five Forces.
- Support M&A activities and investment decisions with thorough insights.
- Gather data from government publications, industry reports, and financial news.
- Develop critical thinking, analytical, and communication skills.
- Apply research in real-world investment banking scenarios.
- Stay updated with industry trends and technological advancements.
Key Highlights
- 3 Months weekend practical training program
- Adv Excel, Financial Models, Ratios , Valuation, Merger analysis, LBO, Industry Research
- Company Profile, Pitchbook, Project Finance
- Handhold Placement Support till final Placement
- Downloadable Video backup, Exercise, Assignments, Case Studies, PPT, and PDF
- Weekly live query session with faculty
- Interview preparation KIT for Investment Banking roles with sample cvs
- What and what do should not do as an Analyst in your professional career
- We have 100% Placement Record for this program in last 15+ years
- Our students are placed on the roles of Financial Analyst, Research Analyst, Equity Research Analyst, Business Analyst, Credit analyst, Valuation Analyst, Venture Capital
- Interview preparation starts right from the first class post every class you will get an interview preparation question sets related to that topic and the question asked in Investment Banking, Equity Research, Private Equity industry
Companies where Financial Modeling & Valuation is used
- Goldman Sachs
- Morgan Stanley
- Barclays
- JP Morgan Chase Bank
- Nomura
- The Bank of New York Mellon
- SBI Capital Markets
- Kotak Mandira Capital Company
- BNP Paribas Bank
- Citi Bank
- Deutsche Bank
- HSBC
- Bajaj Capital
- Avendus
- ICICI Securities ltd
Industries where Financial Modeling & Valuation Course is used
Investment Banking
Project Appraisal
Private Equity
Hedge Funds
Equity Research
Corporate Finance
Knowledge Process Outsourcing
Asset Management
Certifications
Certificate from NSE
Certificate from Microsoft USA International Certification
Certification Financial Modelling Expert using Excel & Macro from IB Institute
Hear From Our Happy Learners
Tushar Singhla
Nitin Bansal
Khushi Chauhan
Ishaan sharma
Bulbul Verma
Our Recent Placements
Shivam Sharma
M&A Consultant
Ankit Saini
Analyst
Mehul Jain
Analyst
Chandni Gambhir
Assistant Manager
Our Placement Partners
What Our Students
Have To Say
Very good Institute for Investment Banking. The faculty is very knowledgeable in both Academics and Corporate world. Ample placement opportunities are provided even before the completion of the course. I recommend the institute to all Finance enthusiasts
7 Days Ago
I have done financial modelling and valuation course from IB institute. I am thankful to all faculty of institute for helping me to get the important skillset. They help me in clearing my doubts and also they available the pre online recorded class. I am very grateful to faculty
7 Days Ago
Surely an acceleration to my carrier: Having completed my CA, I had not much experience in the Investment Banking field. IB institute offers a rigorous programme that teaches the finance basics and the right skills one needs to build a full fledged Business Financial Model.
7 Days Ago
