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 Lar 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 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

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