Welcome to Investment Banking Institute

Become a professional in Investment Banking with our Live Investment Banking weekend course

Learn how to make Financial Models from scratch

Financial Modeling Valuations" skills are required in all kinds of Finance Profiles.

This course covers Advanced Excel Training

VBA (Macro), Basic Advanced Financial Modelling using Excel, Company Valuation and Merger Acquisition.

Become a professional in Financial Modelling with our Live Financial Modelling weekend course

Financial Modelling Company Valuation Training which you don’t learn in academics.

Advanced Digital Marketing Coaching Institute In Delhi

Our Digital Marketing TrainingCourse is designed for all to Entrepreneurs, Job Seekers and Professionals.

Investment Banking Courses

The IB Institute is recognized as the financial education and training leader, offering an accelerated career path for Finance professionals and all individuals specially those seeking to enter the finance industry and expecting an interview call from Equity Research or Investment Banking Firm.

Investment Banking Institute (IB Institute) is Microsoft’s "Authorized Testing Center" for all the applications of Microsoft.

IB Institute provides instructor-led (Live) training and e-learning (Online) courses on Excel 2010, Visual Basic of Application (VBA) , Charts, Dashboards, Financial Modeling, Company Valuation, Project appraisal, Merger and acquisition which develops the competitive profiles of the students for the interview and the working professionals on the job.

Investment Banking Courses in Delhi

Investment Banking Courses includes training on Financial Modelling & Valuation using Excel. Financial Modelling refers to the process of creating an excel based model which projects financial statements based on assumptions. All kinds of Finance Profiles like Investment Banking, Equity Research and Credit Research etc. requires practical knowledge of Financial Modeling & Valuations.

High quality trainers:

Highly qualified and experienced trainers help the participants to shape their career in the main stream Finance jobs. They have gone a milestone in the field of Corporate Finance, Equity Research and Investment banking which helps them to discuss the real world issues and provide real solutions.

Courses Highlights :

  • Certificate of Excel 2013 Expert from Microsoft
  • Complete Excel 2013, VBA Macro
  • Financial Statement Analysis
  • Financial modelling for Telecome and Oil & Ga Sectors
  • DCF, trading and transaction combs modelling and analysis
  • Merger & Acquisition accretion and Dilution analysis
  • Real Estate based Project Financing Modeling from scratch
  • Investment Banking Interview Kit with study material
  • 300 FAQs of Finance interviews with answers
  • 70 hours of videos free with Live Training
  • Mock interviews, resume preparation and placement assistance.

Friday 2 February 2018

What is Financial Modelling?

By  February 02, 2018  , , ,  No comments
Financial Modelling is an exercise wherein an analyst prepares a detailed company specific financial statement forecast for some decision making purposes like valuation, financial statement analysis, M&A and project financing.

In other words, Financial Modelling is the process to make Financial Statement projections with the help of assumptions. Any model which does not include the projections of Income statement, Balance sheet and cash flow statement is not a financial model. A financial model must include the projections of three financial statements.

A standard financial model will include Historical financial statements, Historical analysis, assumptions, working schedule for projection of Revenue, expense, basic & diluted EPS, working capital, capital expense, depreciation & amortization, shares & equity, debt & cash flow statement.

Steps in financial modelling:

  1. Understand the objective of Financial Model.
  2. Understand the business of company, revenue drives and projection parameters
  3. Collect 3 to 5 years historical financial statements from Annual report of company
  4. Clean the historical financial statements from non-recurring items and prepare a non-GAAP or pro forma financial statement before you do the historical analysis
  5. Based on company specific drivers and projection parameters, perform historical analysis for each item of Income statement, Balance sheet and cash flow statement.
  6. Based on management guidelines, historical analysis, research reports, market consensus and your objective and knowledge about the business take your assumptions for all items of IS, BS, CFS and SOCE.
  7. Based on assumptions & schedules, prepare a robust dynamic integrated Financial statement model of the company.
  8. Perform ratio analysis to test the strength and weakness of company health
  9. Financial model will take its final shape after scenario analysis. We have to test the changes in the results if our assumptions goes wrong.
The accuracy of Financial model will depend on the accuracy of assumptions. If assumptions are wrong then financial model will also give you incorrect cash flows, profits and asset & liabilities. So accuracy of assumptions will depend on your knowledge of Business and availability of information and source of those information like research reports and databases and software like Thomson research and Bloomberg.

Financial model can be prepared in just 2 hours or it can take several weeks. It will depend on the scale of business and availability of information about the company.
Read More