Financial Modelling

by Fintrainers Claim Listing

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 Forecast future business requirements and much more.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Fintrainers Logo

img Duration

Please Enquire

Course Details

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:

  • Forecast future business requirements
  • Required for debt or equity fund raise
  • Determine financial risks and/or opportunities for business expansion
  • Examine the earning and investment quality
  • Determine the worth of a company
 

Curriculum:

  • Financial Modelling Core
  • 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
  • Financial Modelling Enhanced
  • 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 Lar Logic and looping
    • Building a Project Finance Model.
  • Financial Modelling Advanced
  • Merger And Acquisition (M&A):
    • Introduction – Categories, Merger motivators, forms of payment
    • Evaluation – Calculating FCFF, discount and terminal rate and NPVValuation – 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 Dashboards
  • Financial Modelling Turbo
    • Turbo course offers students the benefit of CORE+ ENHANCED+ ADVANCED
  • Chennai Branch

    76, Nungambakkam High Rd, Chennai

Check out more Financial Modeling courses in India

FinXL Logo

Financial Modelling Equity Research

Our course is thoughfully designed in such a way that learner gets the Real Time Investment banking & Equity Research exposure. Learner is not necessarily be from finance background, as our course ensures that Basic finance & account concepts are covered in detail with real time examples.

by FinXL [Claim Listing ]
Digital Vidya Logo

Financial Modelling

Financial Modelling training is offered by Digital Vidya for all skill level. At Digital Vidya, we have a very focused approach to training corporations. Over the last 13 years, we have been continuously working on creating mechanisms that enhance retention of the subject matter post-training. 

by Digital Vidya [Claim Listing ]
Edu Pristine Logo

Financial Modeling Course (In collaboration with BSE Institute Ltd.)

The Financial Modeling course trains the candidate to create Financial Models that are used by the organization for various reasons like tracking the company’s performance, forecasting, and budgeting, risk analysis, and evaluation, etc.

by Edu Pristine [Claim Listing ]
Excel Next Logo

Financial Modeling Training

Financial modeling is a process of creating a financial representation of a business, project, or investment in order to understand its potential financial performance. Financial models are typically used to forecast and analyze the financial implications of different business decisions.

by Excel Next [Claim Listing ]
The XL Academy Logo

Financial Modeling Course

Financial Modeling course is offered by The XL Academy. The XL Academy is a capability-building and training solutions organization with deep industry experience and a flair for coaching.

by The XL Academy [Claim Listing ]
  • Price
  • Start Date
  • Duration

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy