f

Nigerian Seminars and Trainings

Search conferences, training, seminars, courses and workshops in Nigeria and around the world

business logo

Financial Modeling

By: Lagos Business School   

Lagos State, Nigeria

07 - 11 Jul, 2014  5 days

Follow Event

  

This is a comprehensive financial modeling programme developed to equip participants with practical knowledge and skills in modeling (Accretion/Dilution). Using hand-holding approach, participants will statements) 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 analysis.

Furthermore, participants will build a merger model in Excel to reflect the pro forma impact of various acquisition scenarios.

Programme

  • Building financial models from scratch the way it is done in financial institutions
  • Excel and formatting best practices, efficient formula construction, and appropriate driver selections. Fixing circularity problems, iteration, and other common modeling troubleshooting.
  • Advanced Excel functions to present various sensitivities that project financial metrics and showcase formatting best practice.
  • Creating 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 cross-checks
  • Analyzing 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 modeling overview
  • 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 and contribution

Targeted Audience

Investment bankers, equity research associates, business development analysts, asset and hedge fund managers, accounting/treasury/corporate finance professionals and anyone seeking to improve their financial and valuation modeling skills.

Lagos Business School, Pan-Atlantic University, Km 22, Lekki-Epe Expressway, Ajah, Lagos, Nigeria Jul 07 - 11 Jul, 2014
NGN350,000.00
(Convert Currency)

+234-8025014623; 08025014624; 08058097448