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
Learn from Financial Modeling Industry Experts and Prepare yourself for Google certification.
Study Material
Hard Copy of Study Notes
Online Materials
Topic Wise study material in the form of Presentation, Case Studies, Practical Exercises and Quiz or Assignments with detailed answers and explanation.
24×7 Forum
Doubt solving forum to interact with faculty & fellow students.
Assignments & Cases
Work on real time cases from different domains.
24×7 Online Access
24×7 Access to Course Material (Unlocked Excel Models, Presentations, etc)
Request Course Brochure & Schedule