Financial Modelling Course:

This program is a fit for the people in investment banking, project management, equity research, business planning, etc. Almost everyone uses MS Excel to create financial models to analyze/project financial statements. A mastery over financial modeling will give all the professionals an edge over others.

About Financial Modeling Course:

Number crunching is one the most important aspects of any job in the world of finance. Unlike other businesses, professionals in the finance industry haveto work with large amounts of numbers. There is thus a demand for finance professional who have an expertise in Microsoft Excel to create financial projections, analyze competition and markets and make financial models. A mastery over Microsoft Excel is actually a way to excel in the finance world, as it ensures accuracy, speed and can make you stand out in the crowd of Finance Professionals.

Our Financial Modeling course will teach you the basic of Microsoft Excel all the way to creating successful Financial Models. By the end of the course, you will be able to independently build models that are robust and provide dynamic projections that can be used to thoroughly analyze a company from multiple standpoints: operations, investment, financing and valuation.

Our four-day course with two modules is all you need to start building your own financial models. The first module is Equity Evaluations and the second module being advanced Excel. So you can make a model firstly, and then understand how to use that model for various purposes like projections, evaluations etc.

Excel in Financial World:

The Financial Modeling course will enable you to

  • Value and analyze Firms, IPOs and FPOs in Financial Modeling.
  • Investments in nascent stages can be valued with accuracy with hands on Financial Modeling for e.g. Private Equity or Venture Capital Investing.
  • Build your own financial models.

Career Benefits after learning Financial Modelling:

Commercial Banks are using Financial Modeling for disbursing loans for the projects; Project Managers are using it for performance tracking of on-going projects.
Financial Modeling concepts can be applied to any industry. Individuals who hold an MBA and possess knowledge of Financial Modeling have an advantageous edge over others.

Ideal Candidates for Financial Modeling:

This program is suitable for students and professionals related to Investment, Equity Research, Credit, Project, Mergers & Acquisition, Corporate Finance, Critical Thinking and analytical skills. It is also ideal for CA, CFA Program candidates, FRM, MBA Finance, B TECH and Commerce Graduates who want a career in any of the above profiles.
Financial Modeling is also a suitable choice for those in non-finance related careers such as in the preparation of Business Plan, working on Excel, decision making and mapping theory to practical.

Appearance Criteria:

Students should have hands-on experience with Microsoft Excel and a brief idea about Finance, Balance Sheets, and Cash Flow Models.

Course Details:

Module I

Exclusive 2 Days Masterclass:

Day-1: Financial Modelling Principles: Excel as a tool for financial modeling
Building financial models best practices
Modeling growth drivers, depreciation, cost drivers, asset & debt schedules

Day-2: Valuation Principles

Projecting cash flow statement
Circular references and handling them
Financial ratio analysis
Valuation using DCF & Comps
Scenario analysis and Building valuation dashboards
Q & A

Module II

Exclusive 4 Days Masterclass

Day-1: Financial Modelling Principles:

Excel as a tool for financial modeling
Building financial models best practices
Modeling growth drivers, depreciation, cost drivers, asset & debt schedules

Day-2: Valuation Principles Projecting cash flow statement
Circular references and handling them
Financial ratio analysis
Valuation using DCF & Comps
Scenario analysis and Building valuation dashboards
Q & A
Day 3: Advanced Functions, Tools & Charting Techniques 
Advanced Tools in Excel for Auditing Financial Models 
Mastering Financial Functions 
Advanced Charting Techniques in Excel 
Day 4: Using Macros & VBA for Financial Modeling Understanding Macros & VBA for Financial Modeling 
Implementing Monte Carlo Simulation
Advanced Charting Techniques in Excel
Q & A

Financial Modeling Course Highlights:

Classroom Training:
Get trained by topic experts with interactive learning in small batches.
Excel Workbooks:
Create models following a step-by-step approach devised by professionals. These workbooks have been specially designed to ensure you incorporate best industry practices of financial modeling.
Bonus Package:
Exclusive 1000+ minutes of video tutorials explaining the process of constructing a financial model for project finance.
Video Tutorials:
Easy to follow byte sized video tutorials of over 1200 minutes created by topic experts. Learn the concepts at your own pace.
Doubt Solving by Experts:
Write to us and get your doubts solved by our experts within 2 business days. You can also initiate a discussion by posting it on active forums.
Study Notes:
Download the study notes to supplement video tutorials.
Case Study Approach (Using models for analysis, including valuations):
Appreciate the concepts by working on case studies derived from real-life situations.
Request Course Brochure & Schedule