Events
 
Student
Browse the Schedule:

Financial Modelling ProgrammeFinancial Modelling Programme

Event CategorySeminars
DateMonday, July 2, 2012
Time9.00 a.m. - 5.00 p.m.
Duration4 Days
VenueLBS Ajah, Lagos
CaptionFinancial Modelling Programme
DescriptionThis 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.

  What to Bring:
Laptop and calculator

Prerequisites:
Financial accounting and basic knowledge of MS Excel
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
Partcipants ProfileInvestment 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
Fee=N= 280,000.00

Action:

registerregister..

MBAMBA AlumniAlumni SeminarsSeminars Breakfast ClubBreakfast Club GeneralGeneral ConferencesConferences

The AMP opens an entirely new world to you....
Femi Adesina, Deputy MD, The Sun Publishing Ltd.

rssFEATURED LBS EVENTS

resourcesDOWNLOAD RESOURCES