Courses

Courses

Financial Modelling

Day 1

Excel Tips

Edu Pristine
  • Understanding And Creating A Financial Model Template
  • Learning referencing (usage of $)Frame work in Excel
  • Learning Custom formatting in Excel
  • Excel Skills - Shortcuts, Formulas, Array Function and Pivot Tables
  • Implementing simple business modeling case in Excel
  • Simple exercise/models in excel
Day 2, 3, 4 & 5

Case Study FMCG

  • Case Study FMCG
  • Data Collection and Data Structuring
  • Preliminary Scrutiny of the Data and Information
  • Understand the Business Model and Operating Model
  • Modeling the Historical Statement
  • Business Drivers Identification and Modeling
  • Modeling Assumptions for Future Action
  • Modeling Revenue Build-up - projecting the future revenues
  • Modeling Cost Build-up - projecting the future cost
  • Modeling the Asset Schedule
  • Modeling the Depreciation Schedule - Book and Income Tax Depreciation
  • Working Capital & Term Loan Modeling - Debt Infusion Tax Modeling
  • Modeling MAT and MAT credit
  • Modeling Impact of Accumulated Losses, Current Tax and Deferred Tax on Tax Payble
  • Equity Modeling - Equity Infusion
  • Modeling Paid Up Capital and Share Premium Account
  • Modeling Retained Earning Schedule
  • Modeling the projected P/L and BS
  • Modeling the projected Cash Flow Statement
  • Conducting Covenant Testing
  • Performing Ratio Analysis
  • WACC and Cost of Equity Analysis
  • Performing Valuation using DCF (FCFF & Enterprise Value) and Comparable analysis (Relative Valuation)
  • Performing sensitivity/scenario analysis
Day 6

Project Finance

  • Introduction to Project Finance
  • Understanding the Project Finance Model
  • Characteristics of Project Finance
  • Risk and contractual arrangement to Mitigate Risk
  • Understanding the Escrow Arrangement
  • Incorporating Date, logical functions and flags to make the Model Flexible
    Incorporating Delays in the Model
  • Cash Flow Waterfall model - Modeling Payoffs to Investors using Goal Seek
  • Implementing Interest During Construction and Breaking Circular Loops
Day 7 & 8

M&A I & II

  • Meaning and categories of M&A
  • Merger motivations
  • Forms of payment in a Merger Deal
  • Hostile Vs Friendly offer
  • Evaluating a Merger Bid
  • Merger Analysis - Key Drivers and Inputs
  • Accretion/Dilution Analysis
  • Merger Plan - Ownership Vs Deal Price
  • Modeling a financing plan
  • Performing sensitivity analysis on Acquirer's EPS
  • Performing Contribution Analysis
  • Estimating value of a Merger Transaction
  • Discounted Cashflow Analysis
  • Comparable Company Analysis
  • Comparable Transaction Analysis
Day 9 & 10

Accenture Case Study

  • Accenture Case Study
  • Data Collection from Public Sources
  • Understanding the Business Profile of the Company
  • Modeling Revenue & Expenses Drivers
  • Modeling Income Statement
  • Modeling Implied EBITDA
  • Balance Sheet Projections
  • Cash Flow Statement Projection
  • Performing Valuation And Sensitivity Analysis
  • Calculating Enterprise value and Implied Market capitalization
Day 11 & 12

Macros

  • Macros I
  • Introduction to Macros & Advanced Application Building in Excel
  • Key Concepts in Macros
  • Macros as recorded Robots!
  • Form Controls and Active X controls
  • Implementing user forms in Excel Macros
  • Linking forms to excel cells
  • Building flexible Charts in Excel
  • Macros II
  • Understanding VBA - Sub & Functions
  • Understanding the Relevant Language Constructs
  • IDC Implementation using Macros
  • Breaking Circular Loops using Macro
  • Monte Carlo Simulation
  • Basics of Debugging VBA Code
Day 13

Charting

  • Charting
  • Building Primary & Secondary Axis in a Chart
  • Radar Charts - Showing the progress of Commercial Property Development
  • Waterfall Charts - Showing Funding Breakup for Renewable Energy project
  • Football Field - Showing Valuation Summary using Different Parameters
  • Gantt Chart - Tracking the status of an Ongoing Project
Day 14

Advance Function

  • Advance Function
  • Named Ranges
  • Index Match
  • Array Functions
  • Building Scenarios using Offset Functions
  • Creating growing models & Index functions
  • Usage of Indirect Functions
  • Usage of Goal Seek and Solver Functions

Creating Business Budgets

Creating Business Budgets

  • Tracking income and expenses by category and contract
  • Using balance sheets
  • Designing worksheets to assist decision making
  • Creating income statements
  • Calculating loans payments and interest
  • Creating cell references to other worksheets
  • Summarizing data in a chart
  • Building alternative budget scenarios

Efficient Email Management

Efficient Email Management

  • Viewing messages by conversation
  • Ignoring a conversation
  • Tagging messages with flags and categories
  • Arranging email by date or by sender
  • Creating inbox folders
  • Customizing and using categories
  • Creating a search folder
  • Creating Quick Steps and email rules

Setting Up a Database in Excel

Setting Up a Database in Excel

  • Understanding database-design concerns like large lists
  • Converting data into tables
  • Working with formulas
  • Using slicers to facilitate table filtering
  • Using the Form tool to build and view data
  • Using data validation to restrict data entries

Data Validation in Depth

Data Validation in Depth

  • Testing for whole numbers and decimals
  • Using the input message box
  • Sequencing and placing lists
  • Creating multitiered lists
  • Setting date and time limitations
  • Limiting text length
  • Locating data validation rules
  • Requiring entries to be unique

Dashboard Training Program

Dashboard Training Program

  • Formulas
  • Formatting
  • Conditional Formatting
  • Basic Charting
  • Advanced Charting
  • Excel Tables
  • Pivot Tables
  • Data Validation, Filters
  • Advanced. Formulas
  • Importing External Data
  • Shortcuts, Productivity
  • Basic Form Controls, Macros
  • Optional: Excel Dashboards

Project Management

Project Management

  • Defining project scope
  • Deciding how to list tasks
  • Estimating costs and time
  • Planning for risk
  • Staying on budget

Project Finance

Week-I

Basics of Financial Statements

Edu Pristine
Week-II

Getting acquainted with Excel

Week-III

Nuances of Project Finance Modeling

Week-IV

Project Cost Build-Up & IDC

Week-V

Capex & Financing Schedule

Week-VI

Modeling Delays & Consolidation

Week-VII

Debt and Revenue schedule, and Deferred Taxes

Week-VIII

Asset Schedule, Operation Cost, and P&L

Week-IX

Equity Schedule, Balance Sheet, Cash Flow Statement, and Basics of Corporate Finance

Week-X

Building Free Cash Flows, Net Operating Income, and Scenarios using Data Tables

Week-XI

Advanced Scenarios using Macros, Monte Carlo Simulations, and Dashboard

Data Visualization Fundamentals

Data Visualization Fundamentals

  • Channeling your audience
  • Understanding your data
  • Determining the information hierarchy
  • Sketching and wireframing your ideas
  • Defining your narrative
  • Using typography, color, contrast, and shape to convey meaning
  • Making your visualization interactive

Foundations of Programming

Databases

  • What is a database?
  • Why do you need a database?
  • Choosing primary keys
  • Identifying columns and selecting data types
  • Defining relationships: one-to-one, one-to-many, and many-to-many
  • Understanding normalization
  • Creating queries to create, insert, update, and delete data
  • Understanding indexing and stored procedures
  • Exploring your database options

Financial Literacy

Reading Financial Reports

  • What is a financial statement?
  • Reading the balance sheet
  • Understanding depreciation, liabilities, and equity
  • Reading the income statement
  • Understanding revenue, costs, profitability, and net income
  • How cash flow works
  • Analyzing financial documents with context

Excel Data-Mining Fundamentals

Excel Data-Mining Fundamentals

  • Solving business problems with data mining
  • Exploring Excel's data-mining algorithms
  • Data mining with Excel SQL Server Analysis Services
  • Using the Data Preparation tab
  • Detecting categories
  • Using the Prediction Calculator

Microsoft Business Intelligence Stack in Depth

Microsoft Business Intelligence Stack in Depth

  • Working with data sources and data views in SQL
  • Understanding the star and snowflake database schemas
  • Working with the SQL 2012 semantic model (aka tabular mode)
  • Using Data Analysis Expressions (DAX)
  • Using Excel Web Parts to connect to spreadsheets
  • Building dashboards with key performance indicators (KPIs) and reports
  • Understanding the Microsoft data-mining process

Power BI Features in Depth

Power BI Features in Depth

  • Understanding data analysis and business intelligence
  • Installing Office BI add-ins
  • Searching for online data with Power Query
  • Shaping data in the Query Editor
  • Connecting to data sources
  • Modeling data with Power Pivot
  • Enhancing PivotTables and PivotCharts with PowerPoint
  • Visualizing geospatial data with Power Map
  • Creating and formatting Power View reports
  • Sharing your data using Power BI for Office 365

SQL Essential Training

SQL Essential Training

  • Understanding SQL terminology and syntax
  • Creating new tables and records
  • Inserting and updating data
  • Writing basic SQL queries
  • Sorting and filtering
  • Accessing related tables with JOIN
  • Working with strings
  • Finding the numeric type of a value
  • Using aggregate functions and transactions
  • Updating a table with triggers
  • Creating views

Managing and Analyzing Data

Managing and Analyzing Data

  • Multiple key sorting
  • Single and multiple column numeric filters
  • Creating a top-ten list with values or percentages
  • Setting up subtotals
  • Creating multiple-field criteria filters
  • Creating unique lists from repeating field data
  • Using the Remove Duplicates command
  • Finding duplicate data with specialized arrays
  • Counting the number of unique items in a list
  • Using SUMIF and COUNTIF functions
  • Working with the database functions such as DSUM and DMAX

Up and Running with VBA

Up and Running with VBA

  • Working in the Visual Basic Editor
  • Adding code to a macro
  • Creating, exporting, and deleting code modules
  • Declaring and using variables
  • Managing variable scope
  • Defining arrays
  • Managing workbooks and worksheets with VBA
  • Repeating tasks with loops
  • Debugging VBA code
  • Cutting, copying, and pasting cell data
  • Running and triggering event procedures

Macros in Depth

  • Understanding what macros can do for you
  • Running macros
  • Creating a Personal Macro Workbook
  • Recording macros
  • Creating nonrecordable VBA code
  • Expanding a macro with statements
  • Using absolute and relative references
  • Testing a macro in Step mode
  • Joining two macros
  • Using loop structures
  • Streamlining macros

VBA & Macros Training Program

  • Introduction to VBA
  • Understanding Loops, Conditions & Writing VBA Code
  • Variables & Deep dive in to VBA
  • Working with Cells & Ranges
  • Worksheets, Workbooks & Databases
  • Working with Charts & Drawing Shapes
  • Dealing with Pivot Tables from VBA
  • User Forms & Databases – Basics
  • User Forms – Advanced
  • Integration with other Office Apps
  • Additional VBA Techniques – Arrays, Practical Examples
  • Class Project & More