Financial Modelling

Overview:
This is a comprehensive financial modelling programme developed to equip participants with practical knowledge and skills in modelling financial statement, valuation and DCF using Excel, and M&A (Accretion/Dilution)

Using hand-holding approach, participants will develop a complete and comprehensive financial statements (three-statement) model from scratch using various supporting schedules.

Participants will learn the conceptual underpinnings of the valuation framework followed by step-by-step training for building a professional, robust discounted cash flow (DCF) model in Excel from scratch, using real case studies, industry best practices, and sensitivity analyses.

Participants will build a merger model in Excel to reflect the pro forma impact of various acquisition scenarios. A small class size is maintained to ensure close faculty attention and foster individual learning.

Programme:
•    Building financial models from scratch the way it is done at financial institutions
•    Excel and formatting best practices, efficient formula construction, and appropriate driver selections
•    Fixing circularity problems, iteration, and other common modelling troubleshooting
•    Advanced Excel functions to present various sensitivities to projected financial metrics
•    Create a performance analysis model; Income Statements, Balance Sheet, Cash Flow Statement and Ratio Analysis
•    Balancing the balance sheet accounts, including excess cash and revolver
•    Balance sheet / cash flow statement crosschecks
•    Treatment and adjustments for options, preferred stock, minority interests, debt, cash and marketable securities
•    Creating models to compute depreciation, leases, rentals and tax
•    Analysing risk with the use of standard deviation, coefficient of variation models
•    Investment analysis using Payback Period, Accounting Rate of Return, Net Present Value, Internal Rate of Return.
•    M&A modelling overview
•    Building  a professional, robust discounted cash flow (DCF) model in Excel
•    Valuation models; Differences between enterprise and equity valuation, unlevered and levered free cash flow estimation, and intrinsic vs. market-based valuation
•    Purchase accounting; accretion/dilution overview and exercise
•    Building the accretion/dilution model
•    Sensitivity analysis using data tables and breakeven & contribution analysis

For:
Investment bankers, equity research associates, business development analysts,  asset  and  hedge fund managers, MBAs, accounting/treasury/corporate finance professionals and anyone seeking to improve their financial and valuation modelling skill set

What to Bring:
Laptop and calculator

Prerequisites:
Financial accounting and basic knowledge of MS Excel

Date:  2 – 5 July, 2012
Fee:    N 280,000