Home Training Financial Modeling
Financial Modeling

financial-modeling

Financial Modelling With Excel

Program Objective:
Ms Excel ® is today unarguably the most commonly used spreadsheet utility globally to do finance. In spite of this, according to various surveys on Excel usage, rather miniscule percentage of Excel uses it to its full potential. The focus of the course is to help the participants learn the tools and capabilities of this spreadsheet application to perform from the simplest to the most complicated and elaborate financial analysis.

Modelling for Corporate Finance Transaction

Case Outline and the process participants will go through in solving the case and structuring an LBO/MBO transaction

financial modeling

The good thing about an over-engineered software like Excel is that it very well equipped to perform the most sophisticated and detailed financial analysis. The downside to this is that financial analysis workbooks are becoming increasingly bulky and unstructured. Many a times, they develop into unwieldy, clumsy and difficult to manage models, with the user having no clue as to what’s going in the spreadsheet and if the results are accurate in the first place. Therefore, structuring good financial models is as much an art as a science.

The important aspects this workshop focuses on is to apply the tools effectively while constructing financial models, caring for scalability, making them flexible, structuring in such a way that auditing the model results is not cumbersome. These essential attributes make financial models accurate, flexible and user-friendly. The workshop would use a ‘learning by doing’ approach, because that’s how the science and art of financial modeling is learnt.

Results:
We expect that the participants attending the course will be able to learn significant financial modeling capabilities using Excel that would be pertinent for corporate finance, financial analysis, risk management, transaction structuring like modeling for M&A, etc. The level of the course is Intermediate to advanced.

Key Benefits:

  • Master the use of Excel’s financial modelling tools and capabilities
  • How to design a model to suit your purpose
  • Understand the different types of financial models and when each should be applied
  • Construct financial models making use of a broad range of Excel methods and techniques
  • Accurate forecasting corporate cash flows for project finance deals and structures
  • Incorporate elements such as risk, sensitivity, optimisation and forecasting into financial models
  • Produce meaningful management reports and charts for communication
  • How to identify and control key sensitivities through advanced spreadsheet simulation
  • How to design a model to maximise flexibility and reliability
  • Practical tips for checking and debugging the mode

Program Faculty:
An Investment Banking professional, with over 10 years of experience and a strong focus on medium sized organizations. He has hands on experience of setting up systems in start up and growth companies and is well networked in the investment banking and private equity space. He has strong sector exposure in Cement, Automobiles, Textiles and Infrastructure. With him, UNICOM has developed training modules to simplify financial modelling and investment analysis for corporate executives in order to cope with financial and strategic responsibilities.

Who Should Attend?

  • Corporate Finance Professionals
  • Quantitative analysts
  • Investment Bankers
  • Risk professionals
  • Treasury managers
  • Controllers
  • Data analysts and economists

Session Details:

Day One:

Session One:
Creating the first financial statement model in Excel to begin with (with an exercise and hands on practical session; focus on how to build a model right from the scratch, linkages with excel spread sheets, assumptions, use of past financial statements for the projections and building forecasted financial statements)

Important issues for preparation and building of a financial model

Excel Functions and commands to supercharge worksheets (most of the participants may be aware about the functions, yet just a quick revision and how these functions are used in financial modelling)

  • Different ways of summing and counting: SUMIF;SUMIFS; SUMPRODUCT; DSUM; DCOUNT;DCOUNTA; COUNTBLANK; COUNTIF; DMAX;DAVERAGE
  • IF (This Is True, Do This, Else Do This)
  • Lookup & reference: CHOOSE; OFFSET; INDEX;MATCH; HLOOKUP; VLOOKUP
  • Data Analysis Toolpak
  • Important Excel Functions and commands for modeling
    • Conditional Formatting
    • Online collaboration
    • Auditing
    • Protecting the workbook
    • Sharing the workbook
    • Data Validation
    • Handling external data
    • Sorting
    • Filters
    • Subtotals
    • Pivot Tables

Session Two:

  • Statistical Data Analysis: trend analysis, regression, moving average
  • Optimisation using
    • Goal Seek
    • Scenario Manager
    • Data Table: Row and Column input cell
    • Solver
  • Scenario Building
    • Switches
    • Forms
    • Scenario building optimistic, base case and pessimistic assumptions

Day Two:
Session Three: Topics in Finance

  • Principles of financial modelling—Accuracy, Flexibility & User-friendliness
  • Defining Model objective
  • Outlining model plan
  • Spread sheet maps
  • Flowchart and information flow
  • Layout and architecture of financial model
  • Setting up modules
  • Identifying inputs and variables
  • Defining deliverables and functionality
  • Cataloguing outputs
  • Stress testing Models
  • Model Documentation
  • Financial Statement modelling
  • Projection of Revenues, COGS, SG&A and other Income Statement and Balance Sheet items
  • Select model drivers and assumptions
  • How to create an interlinked model for Income Statement and Balance Sheet
  • How circularity improves accuracy but also destabilizes the model
  • Building a fully integrated Cash Flow Statement
  • Modelling need for financing in future time
  • Analysing the output and cross-checking with surplus funds and necessary to finance
  • Models for Debt repayment with prepayment option
  • Modelling Amortizing & Accreting Loans
  • Modelling Pay In Kind (PIK) securities
  • Model for computing Beta
  • Modelling un-levering and re-levering of betas
  • Modelling term structure of Beta
  • Model for WaCC with various debt-equity choices
  • Modelling term structure of WaCC
  • DCF valuation
  • Relative valuation (PE, EBITDA multiple)
  • Combining DCF and relative valuation models
  • Modelling for Leveraged Buy Out & Management Buy Out
  • Sources of funds for acquisition
  • Modelling uses of funds
  • Modelling ESOPs and Earn-Outs
  • Partial and full dilution due to ESOPs
  • IRR calculation for financial sponsor on fully diluted basis
  • Purchase Accounting Model
  • Model for Stock-for-Stock Deal
  • Model for Cash-for-Stock Deal
  • Modelling when M&A financed by issue of debt
  • Model illustrating Accounting for a partial Acquisition
  • Accretion Dilution Model
  • Deal Structure: Cash, Fixed-Value Stock Offer, Fixed- Shares Stock Offer
 

Top Videos

TechFeat Clients

Watch Video

Ergonomics?

Watch Video

Data Center Tour

Watch Video

Go Green

Watch Video

Cloud Computing

Watch Video

Green World

Watch Video

Six Sigma Project

Watch Video

Green Building

Watch Video

Never Give Up

Watch Video

TechFeat Clients

Watch Video

Top 20 Best Android Apps 2014

Watch Video

Cloud Computing

Watch Video

Even More Green City

Watch Video

QuikSigma Complete Six Sigma Project Example

Watch Video

Green world animation

Watch Video

What is Cloud Computing?

Watch Video

Go Green Campaign

Watch Video

Data center tour: Equinix

Watch Video

Computer Ergonomics - What's That?

Watch Video

Chat With Us Now!

Technology Partners

  • Tech Feat Partners
  • Tech Feat Partners
  • Tech Feat Partners
  • Tech Feat Partners
  • Tech Feat Partners
  • Tech Feat Partners
  • Tech Feat Partners

Our Consulting Services

image The following are our Consulting Services list in addition to the other services we offerRead More

Our Development Services

imageThis is the array of Software Development Services we offer at TechFeat Read MoreConsulting

Talk Of The Town

ad

Quick Contact






TechFeat Consulting

TechFeat Consulting began IT consulting with the intention of creating a full-service operation that offered excellent service, creativity and production at an inexpensive rate. Read More

Infrastructure Management

Our offerings enable SME's to have a full-staffed and qualified Virtual IT Department, assisting them in deploying and managing desktops, servers, and networks.Read More

ITIL For ITSM

The IT Infrastructure Library (ITIL) is the most universally accepted approach to the management and delivery of IT Services. Your organization can benefit from this effectively. Read More