FINANCIAL MODELLING(FM)

Financial modelling and valuation techniques are becoming increasingly important for finance professionals and entrepreneurs across sectors. Quantitative models are used by both large and small enterprises to:

COURSES OFFERED

  •   BASIC TO INTERMEDIATE EXCEL:
    •   Creating a Financial Model Template
    •   Cell Freeze, Row Freeze, Column Freeze and Cell Referencing
    •   Logical and Statistical Functions (String Function, Offset Function, Data table, Goal seek)
    •   Linkages used for Financial Modelling
    •   Algebraic operations using Formulas
    •   VLOOKUP / HLOOKUP
    •   Match Function
    •   IRR Calculation and CAGR Calculation
    •   Usage of IF function, Table functions, Transpose function
    •   Pivot Tables
    •   Interest functions as EMI calculator
  •   BASICS OF BUSINESS MODEL:
  •   FINANCIAL STATEMENT ANALYSIS:
    •   Introduction to Financial statements
    •   Balance Sheet, Profit and Loss and Cash Flow
    •   Revenue and Expenses
    •   Financial Statement Valuation – Applying DCF
    •   Cost of Equity – CAPM
    •   Net cost of Debt and WAC
  •   ADVANCED EXCEL:
    •   Macros and Excel Visualization
    •   Combination of multiple functions in a problem as VLOOKUP +Match, Index+ Match, VLOOKUP and If
    •   Using Excel for Statistical Analysis like Correlation, Regression, Variance
    •   Summarising data from different sheets and collating them into a single sheet using
    •   Charts – Waterfall Charts, Thermometer Charts
    •   Practical Application of Formulas and Charting through Creation of Dashboards
    •   Advanced excel formulas and Conditional formatting
    •   Using referencing framework (usage of $) to effectively use formulas Indirect function
    •   Charts – Waterfall Charts, Thermometer Charts
    •   Practical Application of Formulas and Charting through Creation of Dashboards
    •   Advanced excel formulas and Conditional formatting
    •   Using referencing framework (usage of $) to effectively use formulas
  •   CORPORATE ANALYSIS:
    •   Time Value of Money
    •   Interest Rates
    •   Discounted Cash Flow Analysis
    •   Return on Investment
    •   Treatment of leases (operating and capital), R&D expenses etc
    •   Role of multiples in IPO valuation
    •   Running regression analysis on multiple
  •   PROJECT VALUATION:
    •   Project finance introduction
    •   Circular Logic and looping
    •   Creating EPC Schedule and CAPEX Schedule
    •   GANTT Chart Logic and looping
    •   Building a Project Finance Model
  •   MERGER AND ACQUISITION (M&A):
    •   Introduction – Categories, Merger motivators, forms of payment
    •   Evaluation – Calculating FCFF, discount and terminal rate and NPV
    •   Valuation – usage of 10K and 10Q, Merger Analysis
  •   BUILDING FORECAST:
    •   Create a Basic IB Financial Model
    •   Growth Rates and Proportions
    •   Forecasting BS and CFS
    •   Forecasting costs and revenues
    •   Modelling Revenue and Expenses Drivers
    •   Modelling Income Statement and Implied EBITDA
    •   Visualization – Interactive excel dashboard
  •   VBA:
    •   Macro Recording Basics
    •   The VBA Editor
    •   VBA & The Object Library
    •   Objects, Properties and methods
    •   Referencing a Range
    •   Important Range Properties
    •   The Worksheets Collection
    •   ActiveX and Dashboard

Turbo course offers students the benefit of CORE+ ENHANCED+ ADVANCED

100 Hours in person Teaching / Online

WHY FINANCIAL MODELLING(FM) AT FINTRAINERS?

Live classroom sessions by charter holders at centre
These sessions offer chance to network, receive personalized coaching, and engage in interactive learning.
Mentoring sessions with experts
Overall, It can be a powerful tool for personal and professional growth, providing individuals with the knowledge, guidance, and support
Additional in person doubt clearing sessions
These sessions are typically held outside of regular class hours and are designed to give students an opportunity to ask questions.
Small batches of students promoting peer learning
When students work together in small groups, they can exchange ideas, ask questions, and challenge each other's assumptions.
Mock tests with review
Reviewing your test results can help you identify areas where you need to improve and areas where you are already strong.
Recap of old topics with specially curated cue cards before starting new topics
Do you struggle to recall key concepts when studying a new topic? Well, fear not!
Convenient India and Global timings
we understand that our students come from diverse backgrounds and have busy schedules. That's why we offer convenient India and Global timings
Optional internship experience
We also provide our students who have cleared CFA a practical internship, with regular check-ins and evaluations .

Immerse yourself in a world-class educational journey with FinTrainers

About our instructors

Our instructors are Chartered Financial Analysts who have not only passed all three levels of the CFA exam but also have practical experience in the finance industry. They bring their expertise and real-world experience into the classroom, providing our students with a comprehensive understanding of the concepts and skills needed to excel in their careers.

Our instructors are passionate about teaching and mentoring our students. They are dedicated to helping our students succeed in their CFA exams and achieve their career goals. They go the extra mile to ensure that our students receive the guidance and support they need to succeed.

Our instructors have excellent communication skills, making complex concepts easy to understand for our students. They are adept at breaking down complex topics into simple, digestible chunks, ensuring that our students grasp the fundamental concepts of the CFA exam.

Our instructors have extensive industry connections, which they leverage to provide our students with networking opportunities and career guidance. They keep abreast of the latest trends and developments in the finance industry, providing our students with practical insights into the industry.

Our instructors are dedicated to our students’ success. They take a personalized approach to teaching, working closely with our students to identify their strengths and weaknesses and tailoring their teaching to meet their unique needs.