DBC Training Brochure

2014

Excel & Office Courses Financial Modelling & Valuation Business Intelligence Financial Analysis & Taxation Soft Skills Courses Master Class Series ICA International Qualifications in Anti Money Laundering and Compliance Corporate Finance & Capital Markets

contents

Introduction Course Summary Course Details, Fees & Dates Our Trainers Our Clients Our Training Methodology How We Train How to Register Contact Information

Introduction dbrownconsulting (DBC) is a financial training, financial consultancy and payroll outsourcing firm based in Lagos, Nigeria and London, UK. Our consultancy services cover financial model, dashboard and data model builds and fund-raising for major project finance transactions, while our payroll outsourcing services enable our clients to outsource their entire payroll functions to tax and payroll accounting specialists. DBC Training

has provided highly-rated financial training courses to more than 4,000 participants over the years. Our approach consistently delivers instant returns on our clients' training investment. We take our time to decipher the specific training needs of participants, which enables us to deliver bespoke packages that significantly boost job efficiency and effectiveness. Our courses are practical; in some cases we require participants to bring their actual work spreadsheets, based on which we impart new, time-saving techniques for producing reports. Using these techniques, participants find that the hours that they would typically spend on a report can be reduced to as little as ten minutes. We have working relationships with a range of world-class training providers and institutions.

We are the regional representative and approved training partner of the International Compliance Association (ICA) and International Compliance Training (ICT) in Nigeria. ICA is the leading global provider of professional certified qualifications and training in anti money laundering (AML), compliance and fraud/financial crime prevention. We are proud to introduce ICA's Diploma and Advanced Certificate in AML to Nigeria. With our dedicated and highly trained faculty, DBC training is excited to offer you over 70 courses from modelling, business intelligence (dashboards) and, soft skills to tax, financial analysis and Excel. We look forward to working with you again this year.

01

DBC Outsourcing Services

DBC Consulting Services

We offer the following core outsourcing services:

Our core consulting services are financial modelling and data (report) modelling/automation. Our bespoke models help our clients to visualise and understand the dimensions and impact of proposed business decisions. We also automate the considerable numbercrunching reporting requirements of large multinationals using costeffective business intelligent tools.

Ÿ Ÿ Ÿ Ÿ Ÿ Ÿ

Monthly payroll processing services Payroll compliance review Specialist loan staff support services Compensation structuring/restructuring Recruitment services Staff wide surveys/needs analysis

We provide efficient and cost-effective payroll outsourcing services that meet our clients’ unique requirements and budget considerations. Our deep knowledge of the Nigerian market, legal and tax system ensures that we deliver a world-class package with full regard to the unique characteristics of the local environment.

Financial Model Build We build the following types of models: l l l l l

Our personnel have proven track records, with experience garnered from leading consultancy and finance firms.

l

Project finance models Investment decision-making models Acquisition and other transaction support models Operational models Budgeting and forecasting models PPP/PFI models

Data Modelling and Report Automation Our Value Proposition: We wish to become your reliable payroll department thereby allowing you to concentrate on your core business. We will develop customised payroll software to meet your specific requirements.

We use Microsoft’s Business Intelligence tools including Power Pivot, Excel and Access to build and automate the following reports: l l

Our approach to providing outsourcing/payroll service is unique. A typical engagement includes planning and data gathering, template design and testing and monthly payroll processing and management. Our Recent Outsourcing Engagements include:

Ÿ Ÿ Ÿ Ÿ Ÿ

Full Payroll outsourcing services to top multinationals Payroll Ancillary Services to blue-chip multinationals Staff-wide training needs analysis for a host of clients Development of an online payslip management system for clients Design of bespoke, quarterly staff cost and contribution slips showing actual costs (salary and benefits) per employee Ÿ Monthly manpower reporting analysis for a top multinational

l l l

Past Consulting Engagements l

l

l

l

l l

l l

02

executive dashboards sales monitoring, forecasting and planning report engines vendor reward management systems financial forecasting, analysis and reporting systems other bespoke data models and solutions

Financial Model Build and Fund Raising Assistance for a commercial real estate development A bespoke sales and planning reporting engine for a multinational that completely automates monthly reporting on multiple products, channels and countries, with touch button analysis of such matrix as same period last year and year to date targets and variances Financial Model Build and Support for a healthcare services firm to secure finance from the International Finance Corporation Financial Model Build for an International Shipping and Marine Company Financial model build for a top pharmaceutical company in Nigeria A reporting engine to compute and analyse a complex vendor reward system for a highly rated multinational organisation Financial Model/Viability Analysis to support a Power Project Bid Build of a daily activity monitoring model for a top multinational that significantly reduces the time taken to generate monthly invoices

summary of courses Excel and Office Courses

Soft Skills Courses (Cont’d)

Power Excel 1 (The Essentials) (EO201) - 2 days Power Excel 2 (Real Case Studies) (EO202) - 3 days MS Power Point Essentials (EO205) - 1 day MS Word Essentials (EO204) - 1 day Advanced Power Point Skills (EO206) - 1 day Advanced Word Skills (EO207) - 1 day Excel 2010/2013 Refresher (EO203) - 1 day Basic Programming in Excel (Macros) (EO208) - 2 days Advanced Programming in Excel (VBA) (EO209) - 3 days

Effective Coaching and People Development (SS704) - 1 day Effective Communications (SS705) - 2 days Effective Meetings (SS706) - 2 days Effective Negotiations (SS707) - 1 day Effective Presentations (SS708) - 2 days In-Charge/Supervisor Skills (SS709) - 1 day Instructor Skills (SS710) - 3 days Interview Skills (SS711) - 1 day Team Development (SS712) - 1 day Telephone Etiquette (SS713) - 1 day Time Management and Personal Effectiveness (SS714) - 1 day Elocution and Public Speaking (SS715) - 1 day

Financial Modelling and Valuation Power Excel for Modellers (FM301) - 2 days Learn Model Building in a Day (FM302) - 1 day Model Auditing and Best Practice (FM303) - 2 days Project a Real Company's Forecast from Scratch (FM304) - 3 days Budgeting and Investment Appraisal (FM310) - 4 days Financial Modelling School (FM307) - 5 days Leveraged Buyout Modelling and Valuation (FM312) - 2 days Merger and Acquisition (M&A) Modelling and Valuation (FM313) - 2 days Advanced Modelling School (FM314) - 5 days Advanced Valuation Skills (FM309) - 3 days Risk Modelling and Analysis (FM311) - 3 days

Equity Analyst Master Class (MC801) - 10 days Report Writing and Data Presentation Master Class (MC802) - 4 days Finance and Accounting for Non-Finance Managers (MC803) - 5 days Charting and Presentation Master Class (MC804) - 5 days Business Intelligence Master Class (MC805) - 5 days Excel Programming (Macros and VBA) Master Class (MC806) - 5 days Financial Analysis and Modelling Master Class (MC807) - 5 days Power Excel Master Class (MC808) - 5 days

Business Intelligence

ICA International Qualifications in Anti-Money Laundering and Compliance

Effective Data Presentation (BI401) - 1 day Essential Charting Skills (BI402) - 1 day Advanced Charting for Presentations (BI403) - 2 days Advanced Data Analysis and Reconciliation (BI404) - 5 days Creating Executive Dashboards in Excel (BI405) - 5 days Essential Data Visualisation Techniques (BI406) - 1 day

ICA International Certificate in Anti Money Laundering for the Telecoms Sector ICA International Advanced Certificate in Anti Money Laundering for the Financial Services Sector ICA International Advanced Certificate in Anti Money Laundering, ABC & Fraud Prevention for the Oil & Gas Sector ICA International Diploma in Anti Money Laundering ICA International Advanced Certificate in Compliance ICA International Diploma in Compliance

Financial Analysis and Taxation Intro to Financial Analysis (FA101) - 2 days Accounting for Non Accountants (FA102) - 3 days Basic Mental Arithmetic for Professionals (FA103) - 1 day Taxation in Nigeria: Issues and Computations (FA104) - 2 days Investing your retirement funds (FA105) - 1 day Nigerian Pension and Retirement 101 (FA106) - 1 day IFRS Introductory Course (FA107) - 2 days Advanced Accounting for Modellers (FA108) - 1 day Soft Skills Courses Customer Service Excellence (SS701) - 2 days Effective Business Writing (SS702) - 2 days Proposal Writing Workshop (SS703) - 2 days

Master Class Series

Corporate Finance and Capital Markets Financial Markets 101 (CF510) - 2 days Portfolio Construction 101 (CF509) - 4 days Alternative Investing 101 (CF507) - 2 days Asset Allocation 101 (CF508) - 2 days Merger and Acquisition Deal Structuring (CF502) - 3 days Real Options Analysis (CF503) - 2 days Purchase Price Allocation, Valuing Intangibles and Impairment Testing (CF504) - 3 days Advanced Merger and Acquisition Negotiating Techniques (CF505) - 2 days Evaluating Corporate and Business Strategy (CF506) - 2 days Deal Strategy, Value, Structure and Negotiation (CF511) - 5 days Introduction to Debt and Securitisation (CF501) - 1 day

03

OVERVIEW OF COURSES

Excel and Office Courses We offer 10 courses in Excel, Word, Power Point and Visual Basic for Applications (VBA). Our flagship Excel course, Power Excel 1, gives participants all the essential skills they need to work efficiently. We also offer a unique consulting/training combo in Power Excel 2, in which we solve real life case problems brought in by participants using our 10-minute rule (that nothing should take you more than 10 minutes in Excel). In our other courses in this category, participants learn to master Power Point, Words and VBA or Macros, learn how to breathe life into their presentations with advanced Power Point skills, and how to automate key tasks in our advanced Word course. Financial Modelling and Valuation We use a unique combination of tools, experience and best practice to develop our financial modelling and valuation courses. In our financial modelling course, we start by teaching you all the Excel skills required to be an excellent modeller, then we use a real company's detailed financial statement to teach you how to build a financial model from scratch, carry out a valuation, and sensitise your results. You can also learn how top financial analysts model and value leverage buyout and merger and acquisition deals. Our financial modelling and valuation course category also includes more advanced modelling techniques under: risk modelling, bank modelling, budgeting and investment appraisal modelling and much more.

04

Business Intelligence Why waste time on analysis and number crunching if you can't extract real insights from your data? The key to effective business intelligence is effective data visualisation and presentation. We teach you the best practice rules for dashboard, chart and table design/build in our highly acclaimed five- day course, “Creating Executive Dashboards in Excel”. Learn how to build truly amazing charts in Excel and how to carry out complex data analysis and reconciliation tasks. Financial Analysis and Taxation Learn all the essential first steps to becoming an excellent business and financial analyst and modeller, from basic to advanced accounting concepts, essentials of Nigerian tax law to what you should know about international financial reporting standards. You will also learn the ins and outs of managing pension investments and developing a retirement plan, as well as a good working knowledge of key aspects of financial analysis. You also have the opportunity to give your brain a real tune up with our Basic Mental Arithmetic course, in which you will learn amazing tricks that will boost your confidence during presentations.

Soft Skills After spending most of your time bogged down in the numbers and details of your daily tasks, it is easy to forget the soft skills required to make you more efficient, alert and productive. Signing up for our 'effective' courses like effective meetings, negotiations, presentations and business writing will help boost your career. Alternatively, you may wish to take your deal pitches to the next level by attending our Elocution and Public Speaking course. Take some time to explore our 15+ soft skills courses that we offer; you may find just the course for your current requirements. Master Class Series Our master class series draws from the content of various individual courses to create a hybrid, multidisciplinary course that caters to a wide range of needs. Our report and presentation master class offers a powerful combination of our soft skills and business intelligence courses. Clients also have the option to combine modules from different courses to create their own master class experience.

ICA International Qualifications in Anti Money Laundering and Compliance Through our partnership with the International Compliance Association (ICA) and International Compliance Training (ICT), we provide professional certificated qualifications and skills in anti money laundering (AML), compliance and fraud/financial crime prevention. ICT is the largest and longest established of the training partners of the ICA. Established in 2001, ICT is passionate about learning and development and has helped thousands of individuals and firms all over the world realise their training ambitions. Designed for novice and experienced practitioners alike, the ICA certificate and diploma courses are a benchmark of excellence and are internationally recognised. They enhance the knowledge and skills of individuals, improve business practice and minimise risk.

Corporate Finance and Capital Markets As the world struggles with the worst financial crisis in decades, it is more important than ever for finance and market operators to get back to the fundamentals of finance and economics. Our corporate finance and capital market courses take you from fundamentals of asset allocation, alternative investments, portfolio construction and so on, to more advanced material like real option analysis, valuation of intangibles and advanced mergers and acquisitions negotiation techniques.

05

01 Excel and Office Courses

1.1.

Power Excel 1 (The Essentials) (EO201) 2 days ¦ US$800; NGN120,000 per participant Overview Learn the essential skills in Excel that will make you more efficient at work. This course will catapult your confidence when working with Excel and give you the required foundational knowledge for our more advanced courses. This flagship course has been delivered to more than 2,000 participants and is a must for anyone who uses Excel regularly.

“Open minded, able to simplify concepts and shortcuts in MS Excel” – C. Anekwe Addax

2014 Training Dates Mar. 10 and 11, May 5 and 6, Jul. 1 and 2, Aug. 18 and 19, Nov. 17 and 18

1.2.

Power Excel 2 (Real Case Studies) (EO202) 3 days ¦ US$1,200; NGN180,000 per participant Overview This is a highly-customised Excel course for experienced spreadsheet users. The course offers the precise spreadsheet skills required to solve real, job-related problems faced by participants. Participants are expected to communicate their specific needs in advance by email or bring their problem spreadsheets to the training, for full, on-the-spot Excel consultancy and solutions.

1.3.

MS Power Point Essentials (EO205) 1 day ¦ US$400; NGN60,000 per participant Overview Learn Microsoft Power Point from the ground up. This course will give you the necessary essentials of Power Point to enable you to build impressive presentations and take advantage of all the new features offered by Power Point 2010/2013. 2014 Training Dates Mar. 17, Jul. 17, Nov 6

2014 Training Dates Mar. 12 - 14, May 7 - 9, Jul. 7- 9, Aug. 20 - 22, Oct. 8 - 10, Nov. 19 - 21

07

1.4.

MS Word Essentials (EO204) 1 day ¦ US$400; NGN60,000 per participant

1.6.

Overview Learn Microsoft Word from the ground up. This course is offered to give you the essentials of Word to enable you to create and edit documents seamlessly, and learn all the new features offered by Word 2010/2013 to help you work more efficiently.

Advanced Word Skills (EO207) 1 day ¦ US$400; NGN60,000 per participant Overview Learn the advanced features of Microsoft Word 2010/2013 that will drastically improve your turnaround time in document creation and editing. Learn how to create auto-updating content and reference pages. Learn how to use and edit thousands of useful templates to save hours of editing time. Link all figures, charts and tables in your document to Excel to facilitate automatic updates and much more.

2014 Training Dates In-house or sponsored only (email your request today)

2014 Training Dates In-house or sponsored only (email your request today)

1.5.

Advanced Power Point Skills (EO206) 1 day ¦ US$400; NGN60,000 per participant Overview Learn the advanced features of Microsoft Power Point 2010/2013. Build presentations far more efficiently using the fantastic new features in Power Point. Learn how to convert boring text to engaging visuals. Incorporate videos, sounds, graphics and complex animations into your presentations. In this course you will also learn how to integrate Excel charts and objects that update automatically. 2014 Training Dates Mar. 18, Jul. 18, Nov. 7

08

1.7.

Excel 2010/2013 Refresher (EO203) 1 day ¦ US$400; NGN60,000 per participant Overview A must-have course before deciding to upgrade to Excel 2010 or Excel 2013. This course will show you how to harness all the major improvements in the new software, as well as highlight the few negatives. Learn the full potential of Excel software and see how you can do your job with greater efficiency and accuracy. 2014 Training Dates In-house or sponsored only (email your request today)

1.8. Basic Programming in Excel (Macros) (EO208) 2 days ¦ US$800; NGN120,000 per participant Overview Get a thorough introduction to basic programming in Microsoft Excel. Learn when best to use Excel's programming language, Visual Basic for Applications, to record repetitive tasks (Macros). Also learn how to edit your recorded Macros to improve their functionality. All cases use real-life examples, typical of most corporate jobs. . 2014 Training Dates In-house or sponsored only (email your request today)

1.9.

Advanced Programming in Excel (VBA) (EO209) 3 days ¦ US$1,200; NGN180,000 per participant Overview Unlock the power of Visual Basic for Applications (VBA), also known as macros. Every single action you do in Excel can be automated using VBA. In this course you will learn how to write VBA codes that will spare you the long hours you may typically spend creating monthly reports and performing other repetitive tasks in Excel. You will also learn how to create user-defined functions. 2014 Training Dates In-house or sponsored only (email your request today)

“Very engaging personality; always provides a suitable solution to all my Excel problems” - E. Abna Reckitts Benckiser

09

02 Financial Modelling and Valuation

2.1.

Power Excel for Modellers (FM301) 2 days ¦ US$800; NGN120,000 per participant

2.3.

Overview This course will teach modellers all the Excel tools they require to create effective models. A skilled modeller must know the key Excel functions (index, indirect, choose, vlookup, NPV ...), data entry tools and shortcuts (validations, goal seek, sensitivities, solver), template creation skills and much more to compete with the best in the world and build firstclass models with full confidence and minimal fuss.

Model Auditing and Best Practice (FM303) 2 days ¦ US$800; NGN120,000 per participant Overview Use auditing tools and techniques to identify all possible errors from a case study model, and learn how to document and correct these modelling errors. Understand and apply best practice techniques that minimise these errors in the first place. 2014 Training Dates In-house or Sponsored only (email your request today)

2014 Training Dates Apr. 7 and 8, Sept. 1 and 2

2.2.

Learn Model Building in a Day (FM302) 1 day ¦ US$400; NGN60,000 per participant Overview This course will teach you modelling best practice, efficient data entry techniques and the methodology required to create quick and efficient financial statement forecasts. It includes lessons on data integrity checks and simple auditing techniques involved in creating standard forecasting models. You will build various three-statement models ranging in complexity, culminating in a model with circularity and audit trail issues which need to be resolved.

2.4.

Project a Real Company's Forecast from Scratch (FM304) 3 days ¦ US$1,200; NGN180,000 per participant Overview Download a real company's financial report (maybe your company!) and learn how to analyse and build a fully integrated financial model forecast complete with sensitivity analysis, a valuation and a dynamic chart for reporting. 2014 Training Dates Apr. 9 - 11, Sept. 3 - 5

2014 Training Dates Apr. 9, Sept. 3

11

2.5.

Budgeting and Investment Appraisal (FM310) 4 days ¦ US$1,600; NGN240,000 per participant

2.7.

Overview Learn how to build versatile and scalable budgeting, and cash flow and investment appraisal models in Excel. Identify the key drivers in any investment appraisal and then learn how to use appraisal tools such as Excel's solver tool to accurately access the profitability of various investment options and optimal pricing policies. Finally, learn the best way of presenting your analysis with tables and charts that communicate effectively.

Leveraged Buyout Modelling and Valuation (FM312) 2 days ¦ US$800; NGN120,000 per participant Overview Learn the concept of a leveraged buyout (LBO), what goes into building an LBO model from scratch, the key participants and the economics of an LBO deal (detailed returns analysis) and exit strategies. Understand the technicalities involved and the different debt structures and cash flow consistencies that make or break LBO deals. Learn how to sensitise your model using key drivers. In the course you will build a fully-integrated model with an income statement, balance sheet and cash flow statement.

2014 Training Dates Apr. 1 - 4, Aug. 25 -28

2014 Training Dates May 20 and 21, Sept. 9 and 10

2.6.

Financial Modelling School (FM307) 5 days ¦ US$2,000; NGN300,000 per participant Overview This is a highly intensive five-day course for analysts, MBA graduates, accountants, bankers and finance managers. The course takes you through the whole process of modelling from modelling best practice methodologies, model auditing, pitfalls in model design, creating an integrated model, sensitising finished models and much more. The entire course uses a real company's recent financials as a case study, with key emphasis on quality control. 2014 Training Dates Apr. 7- 11, Sept. 1 - 5

2.8.

Merger and Acquisition (M&A) Modelling and Valuation (FM313) 2 days ¦ US$800; NGN120,000 per participant Overview Learn what goes into an M&A deal from both the target and acquirer perspective, and what goes into building an M&A model from scratch. Learn about the key participants and economics of an M&A deal (deal terms, deal analysis, synergies and premiums, complex accounting and analysis, etc). Also learn how to sensitise the model using key drivers. In the course you will build a fully-integrated M&A model with an income statement, balance sheet and cash flow statement. 2014 Training Dates May 22 and 23, Sept. 11 and 12

12

2.9.

Advanced Modelling School (FM314) 5 days ¦ US$2,000; NGN300,000 per participant Overview Learn how to build fully integrated leveraged buyout (LBO) and merger and acquisition (M&A) models from scratch. Also learn advanced accounting topics for modellers including treatment of payment-in-kind notes, goodwill, M&A accounting, deferred tax treatment, etc. Understand the technicalities involved in an M&A and LBO transaction, including deal terms, different debt structures, cash flows, deal analysis, synergies and premiums. During the course you will have access to complete LBO and M&A models. 2014 Training Dates May 19 - 23; Sept. 8 - 12

2.10.

2.11.

Risk Modelling and Analysis (FM311) 3 days ¦ US$1,200; NGN180,000 per participant Overview Gain an overview of the practice of risk management, and financial and non-financial risks. Understand how to measure risk through the use of well thought out models for value-at-risk calculations. Learn to build default probabilities based on bond ratings and other methods of measuring credit risk. Gain an appreciation for risk management applications of various derivative instruments and much more. 2014 Training Dates In-house or sponsored only (email your request today)

Advanced Valuation Skills (FM309) 3 days ¦ (special request only) Overview You will work with advanced risk and leverage issues, including worksheets where risk changes during the explicit forecast period, the extraction of betas, the sources of the market risk premium, country risk and small company alphas. You will also address more advanced valuation models such as the adjusted present value, residual income, dividend yield, private equity and free cash flow to equity (FCFE) models. In addition the course offers an introduction to Monte Carlo and real options analysis. The course contains numerous examples of valuation issues for group discussion. 2014 Training Dates In-house or sponsored only (email your request today)

“A concise step by step overview of the subject about to be discussed before practical” -G. Olulade Honeywell Group

13

03 Business Intelligence

3.1.

Advanced Data Analysis and Reconciliation (BI404) 5 days ¦ US$2,000; NGN300,000 per participant

3.3.

Advanced Charting for Presentations (BI403) 2 days ¦ US$800; NGN120,000 per participant Overview This course builds on participants' basic charting skills by teaching advanced techniques and methodologies which will save time and enhance reports and presentations. Learn to edit and interpret the chart series formula and to build custom charts including: Stephen Few's bullet graph, flying bricks (waterfall) charts, dynamic charts that automatically expand with your data and much more.

Overview This is an intensive three-day course in the business intelligence task of data analysis and reconciliation in Microsoft Excel 2010/2013. Learn powerful techniques used to analyse large, disjointed and incoherent data collected from actual scenarios faced by course participants. Also learn how to visualise your data with well-crafted charts and tables. The course additionally imparts unique, time-tested skills to quickly extract valuable information from data sets and harness the power of the pivot table and other special data extraction functions in Excel. It will also help you polish your reconciliation skills.

2014 Training Dates Jul. 15 and 16, Nov. 4 and 5

This course will change the way you work. 'Power users,' those who use more than half of Excel's capacity, will save 10-30 man-hours per week using the techniques the course offers. 2014 Training Dates Apr. 23 - 25/28 - 29 , Aug. 11 - 15

3.2.

3.4.

Essential Data Visualisation Techniques (BI406) 1 day ¦ US$400; NGN60,000 per participant

Essential Charting Skills (BI402) 1 day ¦ US$400; NGN60,000 per participant

Overview Data visualisation entails the effective communications of important business information through well-designed tables and graphs. These are usually depicted in information dashboards.

Overview Do you need to present company information in a succinct and attractive format? Learn the powerful secrets of Excel's chart engine and other hidden presentation tools to create attractive charts, interactive graphs, daily stock performance indicators, charts that embed pictures of your products and much more.

This course is targeted at participants who need to make sense of quantitative business data by discerning meaningful patterns, trends, relationships, and exceptions that reveal business performance, potential problems and opportunities, and hints about the future. It provides practical examples that are useful to managers at all levels and to those interested in keeping a keen eye on their business.

2014 Training Dates Jul. 14, Nov. 3

2014 Training Dates In-house or sponsored only (email your request today)

15

3.5.

Effective Data Presentation (BI401) 1 day ¦ US$400; NGN60,000 per participant Overview Business data is everywhere and we are constantly finding innovative ways to store it. However, we are often less skilled when it comes to effectively presenting this data to simplify business decisionmaking processes. This course will give you succinct rules and best practices in data presentation. You will learn to 'understand the message' required of you and then use the rules provided to determine which presentation technique is best to pass this message across to others.

“Educative and informative training, looking forward to attending another one” - A. Adamu AMCON

2014 Training Dates May 12, Jun. 4, Aug. 4, Oct. 15

3.6.

Creating Executive Dashboards in Excel (BI405) 5 days ¦ US$2,000; NGN300,000 per participant Overview Dashboards have become popular in recent years as uniquely powerful tools for communicating important information at a glance. A dashboard is a one-page summary of critical business information and indices to enable users to effectively monitor business activities. This course will teach you effective dashboard creation techniques in Excel, including for dashboards whose information source is easily updated, those that are created using an intuitive modular structure, those that summarise information using first class visualisation tools, bullet graphs, sparklines, comparative graphs, tables, etc. You will build a visual reporting template that tells you precisely what you need to know in an instant. 2014 Training Dates May 12 - 16, Aug. 4 - 8

16

“One of the best courses I have attended in 8 years, the instructors did well in all presentations” - S. A. Ahmed Central Bank of Nigeria

04 Financial Analysis and Taxation

4.1.

Intro to Financial Analysis (FA101) 2 days ¦ US$800; NGN120,000 per participant

4.3

Overview Learn the secrets behind seemingly difficult yet everyday calculations, and why your brain is more reliable than a calculator. Impress during critical sales pitches by easily calculating discounts and best deals on your feet for clients.

Overview Learn how to read, analyse and interpret financial statements. Build and interpret the core ratios (Du-Pont ratios), learn how to identify possible accounting dishonesty and adjust financial statements of companies before performing comparative analysis. 2014 Training Dates Jun. 19 and 20, Nov. 13 and 14

2014 Training Dates In-house or sponsored only (email your request today)

4.4. 4.2.

Accounting for Non Accountants (FA102) 3 days ¦ US$1,200; NGN180,000 per participant Overview Non-accountants may find themselves baffled when critical company issues are being discussed, simply because they can't speak even a little accounting! It is essential for non-accountants to understand the basics of accounting, for example to be able to understand why an increase in debtor days from 20 to 25 could spell working capital doom for a company. This course introduces basic but critical accounting concepts to help non-specialists improve their overall understanding of company matters. 2014 Training Dates Jun. 16 - 18, Nov. 10 - 12

18

Basic Mental Arithmetic for Professionals (FA103) 1 day ¦ US$400; NGN60,000 per participant

Taxation in Nigeria: Issues and Computations (FA104) 2 days ¦ US$800; NGN120,000 per participant Overview A fully practical course on tax administration in Nigeria (CIT, VAT, WHT, PIT, CGT, PPT, BIK, etc). What are the critical sections of the law that individuals and businesses must be aware of? And who do you talk to and where do you go – tax offices, agents and consultants – to ensure you are always on the right side of the law? In this course you will also get your hands on useful Excel templates and techniques to calculate taxes accurately, and more efficiently manage and analyse them. All participants are provided with soft copies of relevant laws, many useful templates, a compendium of critical tax offices and websites and a whole lot more. 2014 Training Dates Jul. 21 and 22, Oct. 20 and 21

4.5.

Investing Your Retirement Funds (FA105) 1 day ¦ US$400; NGN60,000 per participant

4.7.

Overview A financial specialist will provide answers to pressing questions and concerns that your retiring staff may have regarding the security of their pension savings, the annuity they can expect to buy, the investment vehicles available to them based on their unique circumstances and so on.

IFRS Introductory Course (FA107) 2 days ¦ US$800; NGN120,000 per participant Overview This course covers the key points of the international financial reporting standards (IFRS) and the key principles that make worldwide convergence to the standards inevitable. You will gain an understand of focus areas such as qualitative characteristics, elements of financial statements and their recognition, disclosure requirements, measurement and the concepts of capital and capital maintenance.

2014 Training Dates In-house or sponsored only (email your request today)

2014 Training Dates In-house or sponsored only (email your request today)

4.6.

Nigerian Pension and Retirement 101 (FA106) 1 day ¦ US$400; NGN60,000 per participant

4.8.

Advanced Accounting for Modellers (FA108) 1 day ¦ US$400; NGN60,000 per participant

Overview A financial specialist will provide answers to pressing questions and concerns regarding the security of your pension savings, the annuity required to afford retirement and your expected pension fund valuation at retirement. Also learn about your rights as stated in the Nigerian Pension Act.

Overview The course is designed to review complex accounting rules and techniques that affect the business modelling and forecasting process. It focuses on issues related to mergers and acquisitions, accounting such as fair value, available for sale, equity method, proportional consolidation and taxes. The focus is to understand how these accounting concepts affect financial deals.

2014 Training Dates In-house or sponsored only (email your request today)

2014 Training Dates May 19; Sept. 8

19

05 Soft Skills Courses

Our soft skills courses impart the critical skills participants require to be effective in carrying out most business daily activities. We have built on decades of experience and centuries of research to devise a bouquet of tailored courses to improve such critical skills as business writing, communication, negotiation, elocution and much more.

5.1.

Effective Business Writing (SS702) 2 days ¦ US$800; NGN120,000 per participant 2014 Training Dates Jun. 2 and 3, Oct. 13 and 14

5.2.

Elocution and Public Speaking (SS715) 1 day ¦ US$400; NGN60,000 per participant 2014 Training Dates Jun. 5, Oct. 16

5.3. 5.4. 5.5. 5.6. 5.7. 5.8. 5.9. 5.10. 5.11. 5.12. 5.13. 5.14. 5.15.

Customer Service Excellence (SS701) Proposal Writing Workshop (SS703) Effective Coaching and People Development (SS704) Effective Communications (SS705) Effective Meetings (SS706) Effective Negotiations (SS707) Effective Presentations (SS708) In - Charge/Supervisor Skills (SS709) Instructor Skills (SS710) Interview Skills (SS711) Team Development (SS712) Telephone Etiquette (SS713) Time Management and Personal Effectiveness (SS714) In-house or sponsored only (email your request today)

“An in-depth understanding of the materials, and an excellent ability to communicate with participants” - L. Lawani British American Tobacco

21

2014 Open Training Calendar Jan

Course

Feb

Excel & Office Courses Power Excel 1 (the essentials) Power Excel 2 (real case studies) MS Power Point Essentials Advanced Power Point Skills Financial Modelling & Valuation Power Excel for Modellers Learn Model Building in a Day Project a Real Company’s Forecast from Scratch Budgeting & Investment Appraisal Leveraged Buyout (LBO) Modelling & Valuation Merger & Acquisition (M&A) Modelling & Valuation Advanced Modelling School Financial Modelling School Business Intelligence Effective Data Presentation Essential Charting Skills Advanced Charting for Presentations Advanced Data Analysis & Reconciliation Creating Executive Dashboards Financial Analysis & Taxation Intro to Financial Analysis Accounting for Non Accountants Taxation in Nigeria: Issues & Computations Advanced Accounting for Modellers Soft Skills Courses Effective Business Writing Elocution & Public Speaking Master Class Series Equity Analyst Master Class Report Writing Master Class Finance & Accounting for Non Finance Managers Charting & Presentation Master Class Business Intelligence Master Class Power Excel Master Class ICA International Advanced Certification in Anti Money Laundering Workshop One Assignment One Due Date Workshop Two Examination

20

ICA International Diploma in Anti Money Laundering Workshop One Workshop Two Assignment One Due Date Workshop Three Assignment Two Due Date Workshop Four Examination

© 2013 dbrownconsulting

14

How to Register:

by web: www.dbrownconsulting.net

Mar

Apr

10 - 11 12 - 14 17 18

May

Jun

5-6 7-9

Jul

Aug

1-2 7-9 17 18

18 - 19 20 - 22

7-8 9 9 - 11 1-4

Sep

Oct

Nov

8 - 10

17 - 18 19 - 21 6 7

1-2 3 3-5 25 - 28 20 - 21 22 - 23 19 - 23

9 - 10 11 - 12 8 - 12 1-5

7 - 11

12

4

4

15

14 15 - 16 23 - 25, 28 - 29

3 4-5 11 - 15 4-8

12 - 16 19 - 20 16 - 18

13 - 14 10 - 12 20 - 21

21 -22 19

8 2-3 5

13 - 14 16

1 - 12 2-5 16 - 20

13 - 16 10 - 14 3-7

14 - 18 10 - 14

12 - 16 5-9

4-8 18 - 22

6 - 10

11 27

10 12

16 24 15

by email: [email protected] by phone: +234 701 357 0888 or 0700TRAINING (0700 872 46464)

17 - 21

06 Master Class Series

6.1

Equity Analyst Master Class (MC801) 10 days | $4,000 |NGN600,000 Overview This 10-day master class is a hybrid of our Financial Modelling and Advanced Modelling School. The class takes you through the whole process of modelling, from Excel skills to sensitising merger and acquisition (M&A) and leveraged buyouts (LBO) deals with models you build from scratch.

“A display of mastery and expertise, a brilliant instructor” - A. Kenneth ADDAX Petroleum

In week 1, you will build various financial forecast models and learn all modelling best practice methodologies and many Excel tips and tricks for modellers. In week 2 you will use your new modelling skills to build LBO and M&A models. You will also learn all major deal considerations for M&A and LBO transactions. 2014 Training Dates Sept. 1 - 12

6.2

Report Writing and Data Presentation Master Class (MC802) 4 days | $1,600 |NGN240,000 Overview Every business employee is at some point required to write a report of some sort, but we rarely take the initiative to improve our report writing skills. This master class will impart report writing skills and teach you how to determine which kinds of tables and charts are best for your reports. It will also help you improve your public speaking and elocution, to enable you to deliver engaging and succinct presentations. This master class draws from the content of three of our courses: Effective Business Writing, Elocution and Public Speaking and Effective Data Presentation. It will educate you on the best ways to use words and numbers to create effective and informative reports and presentations. 2014 Training Dates Jun. 2 - 5, Oct 13 - 16

6.3

Finance and Accounting for Non Finance Managers (MC803) 5 days | $2,000 |NGN300,000 Overview This master class is a combination of our Accounting for Non-Accountants and Intro to Financial Analysis courses. Non-accountants may find themselves baffled when critical company issues are being discussed, simply because they can't speak even a little accounting! It is essential for non-accountants to understand the basics of accounting, for example to be able to understand why an increase in debtor days from 20 to 25 could spell working capital doom for a company. This course introduces basic but critical accounting concepts to help non-specialists improve their overall understanding of company matters. 2014 Training Dates Jun. 16 - 20, Nov. 10 - 14

25

6.4

Charting and Presentation Master Class (MC804) 5 days | $2,000 |NGN300,000

6.5

Overview This course is a fusion of four of our standard courses: Essential/Advanced Charting and Presentation Skills and Essential/Advanced Power Point Skills.

Overview Business intelligence, as defined by Stephen Few, comprises technologies, practices and activities that enable businesses (and organisations of all types) to use information to achieve the necessary level of understanding and to make decisions to pursue their objectives.

Learn how to use the fantastic new features in Microsoft Power Point and Excel charts to create truly professional presentations that will keep your audience asking for more. In this master class, you will learn advanced chart making techniques which will save time and enhance your reports and presentations; learn how to build custom charts, including waterfall charts, bullet graphs, charts that show comparison and multivariate data (actual vs. target, variance analysis); and learn how to create charts that update automatically, how to use trend lines and much more.

This master class focuses on the most popular business intelligence tool: 'dashboards.' In this class you will learn what dashboards are and are not; how to design them; how to identify bad design and what to do about it; and how to build dynamic dashboard templates that update automatically in Excel. You will also be taught a detailed dashboard project implementation methodology and much more.

2014 Training Dates Jul. 14 - 18, Nov. 3 - 7

2014 Training Dates May 12 - 16, Aug. 4 - 8

6.6

“The facilitator has vast experience on charting and presentation with fine teaching technique” – A. Mohammed Etisalat

Business Intelligence Master Class (MC805) 5 days | $2,000 |NGN300,000

Excel Programming (Macros and VBA) Master Class (MC806) 5 days | $2,000 |NGN300,000 Overview Excel is infinitely powerful but most users only use about 10% of its capacity. This course is for the few 'power users' who use more than 50% of Excel's capacity and are aware of its complex formulas and functions such as INDIRECT, OFFSET and INDEX. Power users will learn to further wield the massive power of Excel's programming engine, Visual Basic for Applications, also known as macros. Every single action you do in Excel can be automated using VBA. You will learn how to: write VBA code that will in seconds save the hours you may typically spend creating monthly reports and other repetitive tasks in Excel. 2014 Training Dates In-house or sponsored only (email your request today)

26

6.7

Financial Analysis and Modelling Master Class (MC807) 5 days | $2,000 |NGN300,000 Overview This master class draws on the content and knowledge from eight of our standard courses: Excel for Modellers, Accounting for Non-Accountants, Intro to Financial Analysis, Modelling A Real Company from Scratch, M&A and LBO Modelling, and Valuation and Report Writing. This is a highly intensive five-day course for analysts, MBA graduates, accountants, bankers and finance managers. It takes you through the fundamentals of financial analysis, giving you a good understanding of critical accounting and financial concepts. You will learn how to build and interpret the core ratios used to analyse different industries and see what rating agencies look out for when doing credit analysis. Learn to also build and modify advanced financial and valuation models used to enhance the decision making process, such as deal value, financing decisions, asset allocation, optimal capital structure, credit appraisal methodology and more.

“The instructor worked at the pace of participants: flexible enough to accommodate all kinds of people. I will have him lecture me anyday!” – A. Sanni Honeywell Group

2014 Training Dates In-house or sponsored only (email your request today) 6.8.

Power Excel Master Class (MC808) 5 Days ¦ US$2,000; NGN300,000 per participant Overview This is an advanced Excel course that focuses on concepts for finance professionals. Understand how to harness advanced functions like INDEX, OFFSET, INDIRECT, how to build complex formulas, the power of array formulas, pivot tables and advanced charting techniques. The course will also offer an introduction to VBA/Macros, using real life examples.

“I love the energy level and the passion with which modules were delivered” – M. Ezenwegbu British American Tobacco

Participants are expected to communicate their specific needs in advance by email or bring their problem spreadsheets to the training, for full, on-the-spot Excel consultancy and solutions. 2014 Training Dates Mar. 10 - 14, May 5 - 9, Aug. 18 - 22, Oct. 6 - 10 Nov. 17 - 21

27

07 ICA International Qualifications in Anti Money Laundering and Compliance “The logos of ICA and ICT have been used with the kind permission of the respective organisations”

ICA International Diploma in Anti Money Laundering Overview Money laundering prevention remains high on the agenda for financial services professionals. An integrated approach to fighting the risk is needed and knowledgeable, fully trained staff are essential to that approach. The ICA Diploma in Anti Money Laundering (AML) helps individuals develop best practice initiatives and prepares them to face present and future challenges, reducing risk. The Diploma is awarded in association with Manchester Business School, University of Manchester. Who is the course suitable for? Money Laundering Reporting Officers (MLROs)/MLPOs and their deputies • Police and FIU/FCU staff • Managers with responsibilities for internal AML controls • Risk managers • Accountants, lawyers, company secretaries • Individuals who have completed the ICA Certificate in AML Awareness or ICA Advanced Certificate in AML • Accountants • Lawyers

•

What will you learn? Anti Money Laundering (AML) and Combating Terrorist Financing (CTF) in context • Customer identification, customer risk profiling and monitoring • Sanctions • Designing a comprehensive AML and CTF framework for a financial services business • Governance and leadership • Suspicious activity/suspicious transaction reporting and dealing with the authorities

workshops. Workshops are held in Lagos for the November intake, London for the September intake and other major cities in the UK. How will you be assessed? 2 x 3,000 word assignments 3 hour 15 minute open book examination Can this course be taught in-house? An in-house option is available for firms signing on a minimum of ten people for the course. Benefits include a reduction in price and the ability to include bespoke material in the course delivery. Contact ICT or dbrownconsulting for more information. What does it cost? Full Program: £3100 (+ VAT - this fee includes the ICA assessment fee) Examination Only: £2150 (+ VAT). The examination only route is available for very experienced practitioners only and is subject to approval by ICA. If approved, you will be exempted from attending workshops and submitting assignments and will be assessed purely on your exam performance.

•

Entry Requirements Sound educational background, e.g. degree or professional qualification in an appropriate discipline OR attainment of the ICA Advanced Certificate in Anti Money Laundering (International or UK) OR three years relevant work experience How and where can you study? This 9-month course is offered by International Compliance Training (ICT), ICA's approved training provider, and comprises self-study at home and attendance at four highly interactive

Key Course Dates Course Start Date Workshop One Workshop Two Assignment One Due Date Workshop Three Assignment Two Due Date Workshop Four Examination

Nov. 5, 2013 Nov. 27, 2013 Jan. 14, 2014 Mar. 10, 2014 Mar. 12, 2014 Jun. 16, 2014 Jun. 24, 2014 Sept. 15, 2014

“An excellent course covering all the relevant areas of AML. The tutors are experienced and informative and the interactive approach to learning definitely has more impact.” - Paul Simmons Head of FCPU, M+G Investments

29

ICA International Advanced Certificate in Anti Money Laundering Overview Qualified anti money laundering (AML) professionals are in demand as organisations increase their focus on risk prevention. The ICA International Advanced Certificate in AML provides all of the knowledge you will require to begin a career in this field. The Certificate is awarded in association with Manchester Business School, University of Manchester. Who is the course suitable for? • New/recently appointed MLROs and deputies • New/recently appointed financial crime and risk officers • Compliance officers • Internal auditors assuming responsibilities for money laundering/financial crime issues • All individuals engaged in financial services who aspire to a career in AML What will you learn? • The international context • Legal and regulatory framework • AML in practice • Sanctions • Customer due diligence (CDD) • Managing the risk of money laundering and terrorist financing • Transaction monitoring and filtering frameworks • Suspicious activity reporting • Emerging industry sectors • Escalations and exits Entry requirements The ICA Advanced Certificate in Anti Money Laundering is open to anyone who is interested in pursuing a career in anti money laundering. However, the content of the programme requires students to possess a sound educational background and good written English skills. How will you be assessed? One 1 hour and 45 minute open book examination One 2,000-2,500 word assignment

30

How and where can you study? This 6-month course is offered by International Compliance Training (ICT) ICA's approved training provider, and comprises self-study at home and attendance at two highly interactive workshops. Workshops are held in Lagos and London (subject to numbers enrolled). Can this course be taught in-house? An in-house option is available for firms signing on a minimum of seven people for the course. Benefits include a reduction in price and the ability to include bespoke material in the course delivery. Contact ICT or Contact dbrownconsulting for more information. What does it cost? £1,475 (+ VAT - this fee includes the ICA assessment fee) ICA International Advanced Certification in AML Training Dates Course Start Date Nov 5, 2013 Workshop One Nov 26, 2013 Assignment One Due Date Jan 20, 2014 Workshop Two Mar 11, 2014 Examination Mar 27, 2014

“Reach for the skies - you are never too old to learn! The tutors were amazing and always offered help outside of the classroom. The website is fantastic if you use it to its full potential.” - Kim Dickinson CDD Manager, Santander Private Banking

ICA Tailored Courses for Nigeria Open Courses • ICA International Advanced Certificate in Anti Money Laundering for the Financial Services Sector • ICA International Diploma in Anti Money Laundering In-house Courses • ICA International Certificate in Anti Money Laundering for the Telecoms Sector • ICA International Advanced Certificate in Anti Money Laundering, ABC & Fraud Prevention for the Oil & Gas Sector • ICA International Advanced Certificate in Compliance • ICA International Diploma in Compliance

ICA Qualification Framework

31

08 Corporate Finance and Capital Markets

8.1.

8.2.

Financial Markets 101 (CF510) 2 days ¦ (special request only)

8.3.

Alternative Investing 101 (CF507) 2 days ¦ (special request only)

Overview A two-day introductory course to financial markets and key asset classes.

Overview A two-day introductory course to Alternative Investing.

Learning Outcomes • Understand the origins of the financial markets, their structure and key players • Acquire a thorough introduction to the main asset classes including equities, bonds, currencies and commodities • Understand the key risk and return characteristics of the main asset classes • Understand how these asset classes operate within the Nigerian context • Obtain an understanding of how these different asset classes combine in a portfolio

Learning Outcomes • Acquire a thorough introduction to the fastest growing segments of alternative investment: hedge funds and private equity investing • Gain an insight to hedge fund strategies and associated risks • Gain an insight to private equity structuring; • Gain an insight to the pricing of private equity buyouts and how to achieve successful buyouts • Review the Nigerian hedge fund and private equity investing experience.

Portfolio Construction 101 (CF509) 4 days ¦ (special request only) Overview A four-day introductory course to portfolio construction. Learning Outcomes • Gain an understanding of the asset classes (risk, return, ease of access) and the importance of diversification; • Gain an insight to portfolio construction theory, stock selection philosophy; Gain an understanding of portfolio optimization • techniques; and • Understand how to construct optimal portfolios in global and local financial markets.

8.4.

Asset Allocation 101 (CF508) 2 days ¦ (special request only) Overview A two day introductory course to Asset Allocation. Learning Outcomes Acquire a thorough introduction of the different asset classes • Understand the role of asset allocation in a portfolio and the key issues involved • Gain an insight to strategic and tactical asset allocation • Understand tactical asset allocation methods • Acquire a thorough understanding of how to create an optimal long-term portfolio

•

33

8.5.

M&A Deal Structuring (CF502) 3 days ¦ (special request only) Overview In this course you will discover how to manage both disposal and acquisition assignments through strategy evaluation, deal mechanics, deal structuring, EPS management, bid management and negotiation. You will follow two case studies from the pitch stage through to the final deal negotiation. You will evaluate an acquisition using strategy evaluation and will assess the value of improvements and synergies. The course also contains an introduction to negotiating techniques and involves extended role plays in negotiating a deal.

8.6.

Real Option Analysis (CF503) 2 days ¦ (special request only) Overview Real options arise when there is an expectation of the resolution of relevant uncertainty, and management has the flexibility to take advantage of changes in the environment. You will discover how to identify archetypal embedded real options, to map them on to option valuation model inputs, to model the uncertainty, and to assess the value of the options. You will work with closed form and binomial models to put a value on the flexibility, and discover how to interpret and act on the output.

34

“Best local training attended in 5 years. Presentation and course were very apt” - U. Otoobong Total

8.7.

Purchase Price Allocation, Valuing Intangibles and Impairment Testing (CF504) 3 days ¦ (special request only) Overview In this course you will discover how to apply IFRS 3 and IAS 38 to allocate the acquisition price after a takeover, and to calculate goodwill. You will address the identification of intangibles, assessment of their remaining useful lives and their valuation using the cost, royalty relief and residual income models. You will use a typical allocation model to work through the intangibles valuations, and to ensure completeness. You will learn about the contributory asset charge, tax amortisation benefits and the weighted average return on assets. You will also be taught how to approach impairment testing under IAS 36, and to test goodwill within relevant cash generating units.

8.8.

Advanced M&A Negotiating Techniques (CF505) 2 days ¦ (special request only)

The trainer was articulate with a good grasp of the subject, highly effective teaching methods and very interactive – H. Abdoulrahmaan Etisalat

Overview In this hands-on course, you will learn how to plan effectively for negotiations, set your own negotiating outcomes and discover what lies behind other parties' negotiating positions. You will work with leverage and game theoretic issues, and learn how to craft effective negotiating arguments to deal with tough negotiators, and to use different negotiating styles. You will participate in a multi-party negotiation role plays and learn to use coalitions to achieve your outcomes.

35

8.9.

Evaluating Corporate and Business Strategy (CF506) 2 days ¦ (special request only) Overview In this course you will learn how evaluate corporate strategy through an analysis of intangible assets as a basis for acquisitions and subsequent merger integration. You will assess different firm and national cultures, and determine how these can be used to deploy a viable parenting strategy. You will also use multiple models to assess business strategy, and the embedded options inherent in many firms. The course will further teach you how to link strategy evaluation with its impact on cash flows, risk, value, and the acquisition proposition.

8.10.

Deal Strategy, Value, Structure and Negotiation (CF511) 5 days ¦ (special request only) Overview Armed with a full understanding of a business, you will learn the intricate mechanisms of deal strategy and how to calculate a fair value for transactions. You will cover the dynamics of valuation and the different types of value which can be derived. You will discover how to manage both disposal and acquisition assignments through strategy evaluation, deal mechanics, deal structuring, EPS management, bid management and negotiation. All topics in the course are structured around real world examples and international best practice.

36

8.11.

Introduction to Debt and Securitisation (CF501) 1 day ¦ (special request only) Overview This course is a quick overview of structured finance transactions including debt structures and analysis of their delinquencies. It also reviews the terms involved in mortgage securitisation and the cash flows of common structured finance transactions.

Complete, correct, comprehensive, consistent, comprehensible - O. Blessing MTN

Meet Our Trainers

CLARA OBAZELE

DAVID BROWN

JONATHAN BOWDLER

Elocution and Public Speaking Trainer Lecturer, Nigerian Institute of Journalism and LBS Lagos

Financial Modeller, Trainer and Consultant Principal, dbrownconsulting (DBC)

Global Head of Compliance, ICT

Clara Obazele is a seasoned broadcaster with years of experience, who has worked as a producer and presenter in the electronic media. For eight years, she was the principal lecturer in the National Training and Manpower Development Department of the Federal Radio Corporation of Nigeria ('Radio Nigeria'). She was the managing editor of an international magazine, Secretaries & Management, and she conceptualised and edited the Federal Ministry of Women Affairs' project, The Nigerian Women Magazine. She also presented Women, the Move and Family Q Time on NTA Abuja. Clara has a Bachelor of Arts in English Language and a Diploma in Mass Communication. She is a member of the Nigerian Institute of Public Relations (MNIPR) and Nigerian Institute of Management (MNIM). She has also attended numerous courses in Nigeria and abroad. Professionally, she works as a lecturer and facilitator of English Speech Sounds – Elocution and Public Speaking. She facilitates courses at the School of Media and Communications, Lagos Business School Pan-African University, and also lecturers on communication skills at the Nigerian Institute of Journalism in Lagos. Clara facilitates the Elocution and Public Speaking module of our Effective Business Writing and Data Presentation course.

38

AML & Compliance Trainer

David is the founder of dbrownconsulting (DBC). He has over 13 years of consulting and training experience, providing financial advisory, tax advisory, financial modelling, deal structuring and project finance services to teaming clients in his present capacity at dbrownconsulting and in his prior positions as a corporate finance and tax analyst in Andersen/KPMG. He has also previously worked at Savannah Bank.

Jonathan is the Global Head of Compliance at ICT, responsible for all of the ICA Compliance programmes, both in the UK and Internationally. Having nineteen years of financial services industry experience, holding senior Compliance roles (including Head of Compliance and Approved Person status) for the last ten of these, Jonathan has a wealth of practical compliance experience.

David is a chartered accountant and a member of other professional bodies in taxation and management. He is a regular facilitator for various ICAN training seminars. He is also a member of the CFA Institute, CFA UK and CFA Nigeria Societies. David is a SEC registered Investment Adviser.

With an MBA from Henley Business School and a Diploma in Management from Reading University Jonathan is also highly qualified in business management, and is therefore able to place compliance management within the context of wider corporate strategy, a must-have skill for the modern senior Compliance professional.

David has facilitated accounting, Excel and modelling-based training to over 3,000 participants, and is currently responsible for our financial modelling, business intelligence and Excel-based courses.

His role at ICT focuses upon ensuring that the training to obtain ICA qualifications meets the highest possible standards both in terms of content and delivery.

He heads our financial consultancy services and acts as the regional representative to the International Compliance Association and International Compliance Training.

Jonathan has developed and delivered compliance training, and spoken at a number of conferences, in numerous places across the globe, including; London, Singapore, Dubai ,Oman, Bahrain, Moscow, Almaty, Copenhagen, Bucharest, Jamaica, Jersey, Guernsey, Isle of Man Jonathan also writes on compliance topics for specialist industry publications whenever time allows. He is also a fully qualified investment and mortgage advisor and is a member of a number of industry forums.

LEE BYRNE

MARIAM ABDULAI

PEKKA DARE

AML and Compliance Trainer

Soft Skills Trainer Managing Associate, BRASS

AML & Compliance Trainer

AML Course Director, ICT

Lee has more than 27 years financial services experience in front office, quality assurance and management roles and covering a range of products and services provided in retail and commercial banking, credit cards, correspondent banking, private banking, on-line banking and trade finance. Most recently, Lee was the Head of Compliance and Financial Crime Management (MLRO) with a wholly owned subsidiary of an African bank. During his time there, Lee was responsible for the development and performance of a risk based compliance and financial crime monitoring plan across four strategic business units; Commercial Banking, Treasury, Private Bank and Trade Finance. Other roles have included being the Secretariat to the Board and the Board Risk and Audit Committee, as well as acting as the authorised Data Controller, Quality Assurance Training Manager, and the Compliance Monitoring Manager of a UK retail banking branch network responsible for the training of all levels of staff and management on a range of compliance and AML risks. Lee has had extensive experience in preparing and delivering AML, regulatory and crime awareness training workshops to foster improved compliance awareness and performance.

Mariam is the managing associate of BRASS, and has over 20 years of experience. Prior to setting up BRASS she gained extensive experience at KPMG Professional Services (formerly Andersen) where she was a manager in charge of the firm's executive selection and training functions. She also has extensive audit experience as a manager in KPMG's audit and business advisory division.

Director, ICT

Pekka is responsible for the development and delivery of ICA Financial Crime Prevention (FCP) and Anti Money Laundering (AML) programs worldwide. He has a wealth of experience in industry, including roles as a Money Laundering Reporting Officer for a multinational life & pensions firm and Head of Financial Crime of a division of a major UK retail bank. These roles involved managing external and internal fraud risks and AML systems and controls.

Mariam has actively led the identification and selection of ideal candidates for various levels in leading companies in industries such as oil and gas, banking and finance, manufacturing, and for international agencies. She has also been involved in the design and delivery of training programs to enhance the human capital of numerous organisations, from entry to senior management levels.

A qualified lawyer, Pekka has also conducted prosecutions for tax evasion and provided legal advice in respect of organised crime groups, complex frauds and corporate tax evasion. He has also worked for the UK Department of Trade and Industry (now BERR) in the investigation of corporate fraud and misfeasance.

Mariam holds a Bachelor's degree in Economics from the University of Ife. She is a fellow of the Institute of Chartered Accountants of Nigeria (FCA). She is also an associate of the Chartered Institute of Taxation (ACIT). She has attended courses and training in human capital consulting.

The range of practical skills Pekka brings to his role includes the management of regulatory and law enforcement relationships and complex fraud and money laundering cases. This experience enables him to bring an engaging mix of academic and practical insights into his role.

Mariam facilitates a growing list of soft skills courses for dbrown consulting.

Pekka has an extensive range of industry contacts and regularly teaches and speaks at AML and FCP events around the World. He is chairman of the Money Laundering Officer's Discussion Group (MLODG), a body which shares best practice amongst practitioners. He is passionate about promoting professionalism and best practice across all sectors engaged in AML & FCP.

39

RHODRI KETTLE

SEUN MINAKIRI

SIMIDELE DOSEKUN

AML and Compliance Trainer Course Writer and Tutor, ICT

Tax and Excel Trainer

Soft Skills Trainer Managing Editor, EditIQ

Rhodri is a course writer and tutor working directly for the Global Head of Compliance at ICT, and has responsibility for the development and delivery of ICA Compliance programmes, at Certificate, Advanced Certificate, and Diploma levels. This is supplemented by the preparation of briefing materials for Post Graduate and Masterclass courses and events.

Seun is currently a Tax Consultant and an Excel facilitator. She has over 8 years consulting experience in the Tax and Regulatory Services; most of which was gained working at KPMG Professional Services. Over the years she had varied experience working on clients' tax issues in Companies Income Tax), Value Added Tax, Withholding Tax and Personal Income Tax.

He has a background of over 25 years' experience in retail financial services, including roles as a Regulatory Compliance and Conduct Risk Manager for a 'Big Four' UK retail bank. This gives him a great deal of practical compliance application experience, interpreting regulation and challenging proposed implementation strategies through a customer and conduct lens.

She has used her technical competence in developing and modifying various spreadsheet programs especially those used in providing tailored payroll solutions to clients. She now dedicates her skills to assist clients in the development of robust and functional financial templates and models as well as in the creation of various training materials for DBC.

Rhodri also attends industry and trade body conferences and discussion groups whenever possible.

In addition to her consulting experience, she has facilitated training in the use of accounting software and the implementation of business processes.

Educated to Bachelors' Degree level, and holding the ICA qualifications, his role at ICT focuses upon ensuring that the course materials and training content required to obtain ICA qualifications meets the highest possible standards, and is continually revised to keep abreast of industry, regulatory and legislative developments.

40

Seun facilitates our Tax and Excel based courses.

Simidele Dosekun co-founded and manages EditIQ, which offers freelance editing and business writing training to diverse clients in Nigeria. She has over 10 years of editing experience, during which she has worked with individuals, publications, development and corporate organisations across Africa and the United States. She is the former managing editor of Kachifo Limited, publisher of Farafina Books. Simidele has a BA from Harvard University, an MA from the University of Cape Town and is currently pursuing a PhD at King's College London.

STEVE SHAW

Corporate Finance Trainer and Consultant Principal, Financial Seminars Ltd.

Steve Shaw has run his training and consulting firm for over 17 years. His career spans three decades working as assurance partner in continental Europe with Peat Marwick and subsequently KPMG during the 1980s and early 1990s. A master practitioner in Neuro-Linguistic Programming (NLP) and an accredited NLP trainer, Steve is licensed to use a variety of psychometric and organisational measurement instruments such as MBTI, FIRO, OTI and TMS. Steve has designed and delivered specialist corporate finance training, firm valuation and advanced mergers and acquisitions negotiating, real options analysis, scenario planning, Monte Carlo workshops, intangibles and impairment workshops, new managers' induction courses and influencing skills and business planning facilitation workshops for a number of world-class organisations. They include: KPMG, Oracle Corporation, Bull-Integris, Dendrite, Johnson & Johnson, Boston Scientific, Eli Lilly, Ernst & Young and United Technologies. Steve facilitates our corporate finance courses.

TOM BROWN

AML and Corporate Governance Trainer and Consultant

Tom is a qualified barrister and solicitor with the Supreme Court of Nigeria and a certified anti money laundering (AML) specialist. He has an LLB Joint Honours degree in English Laws and Sharia, and an LLM Master's degree in Commercial Law from the University of Wales. He has over 12 years' experience at the bar, with three degrees and eight professional qualifications in the fields of law, AML, risk, compliance and conveyancing. He also has over 15 years' experience in legal, AML, CDD, sanctions and compliance related fields, working for top-tier law firms, high street investment banks, and oil and gas companies in Europe. Tom currently acts as an AML and know your customer consultant, trainer and adviser to a top oil and gas company in the UK, and lectures on money laundering (master's level) at Cardiff Law School. He has also advised on Islamic banking and is a director of Vistalito Scotland Limited.

YEMI MUILI

Accounting and Excel Trainer

Yemi has worked with dbrownconsuting for 3 years and has acquired her skills from extensive trainings and work engagements, to become an Analyst and facilitator in the firm. She specialises in speadsheet consulting, Financial Model build and Data model build and Automation. She is adept at advanced data analysis reconciliation, performance reporting (using charts and dashboards).

YINKA IBUKUN Soft Skills Trainer

Yinka Ibukun is an editor and journalist, with experience in designing and facilitating writing workshops. She is the founding editor of Baobab Magazine in Montreal, Canada, and has previously worked for Farafina Magazine in Lagos. As a journalist, she has written for Bloomberg, Reuters, The Associated Press, The Guardian UK and The Christian Science Monitor, among many others. Yinka co-founded EditIQ and codeveloped its business writing workshops.

Yemi is also an affiliate member of the Association of Chartered Certified Accountants (ACCA) with a Professional level certificate in Accounting, and holds a distinction in Accounting from the Federal Polytechnic, Illaro, Ogun State.

He acts as a trainer and consultant for our anti money laundering and corporate governance courses.

41

Our Clients dbrownconsulting was formed to pioneer needs-based training in Nigeria. Our trainers have more than 150 years of training experience between them. Our trainees set the tone for our courses as they are taught through their actual work spreadsheets, case studies and experiences. This approach guarantees returns on our clients' training investment. We are not in a position to assess our ranking in the Nigerian market; however our reputation can be assessed by our extensive list of satisfied clients. Some of our clients include: Aviation, Marine & Engineering BGI Aviation & Technical Services Bristow Helicopters Nigeria Ltd Pan African Airlines Nigeria Ltd T1 Marine Services Limited Conglomerates Dangote Group Honeywell Group Financial Services Access Bank Alpine Invest ARM Investment Managers Central Bank of Nigeria Citibank FCMB Capital First Bank of Nigeria First City Monument Bank Key Stone Bank Lloyds TSB - UK Mansard Insurance Premium Pension Stanbic IBTC Asset Mgt Ltd Stanbic IBTC Bank Stanbic IBTC Pension Managers Ltd United Bank for Africa Vetiva Capital

42

Professional Services Accat Nigeria Ltd ACCL Honeywell ECC Institute of Chartered Accountants of Nigeria (ICAN) International Compliance Association UK (ICA) International Compliance Training UK (ICT) KPMG Egypt KPMG India KPMG Nigeria Landmark Offices OSMi Pavilion Technology Seindeo Limited Techquad Transcend Healthcare & Agriculture Hygeia HMO Limited Lagoon Hospitals Renal Dialysis Centre The Candel Company Manufacturing Benue Cement Company British American Tobacco Honeywell Flour mills Plc Honeywell Superfine Food Ltd Promasidor Nigeria Limited Tetra Pak West Africa Twinning Unilever Nigeria Plc

Energy, Oil & Gas Addax Petroleum BP Oil - UK Centrica Resources(Nig) ltd Honeywell Oil and Gas Midwestern Oil & Gas Oando PGS Exploration Sapetro Seplat Statoil Angola Statoil Nigeria Total - E&P Total Nigeria Wartsila Public Sector EFCC Federal Inland Revenue Service NFIU Real Estate Persianas Properties Limited URAGA Real Estate Telecoms Airtel Etisalat MTN Nigeria Starcomms Plc

Our training Methodology Project Planning and Online Testing (Needs Analysis) Feedback (to clients) and online post training Support

Deliver Training Design/customise Training Modules

Our approach to training is unique. A typical engagement will include:

Training Delivery Phase

Pre-Training Phase

•

•

• • •

We conduct an online proficiency test for all potential participants. These tests can be customised per organisation. We have separate tests for Excel and anti money laundering proficiencies We present clients with a needs analysis report detailing each potential participants' performance and training deficiencies Participants are allocated to training courses that match their proficiency levels For our bespoke courses, each approved participant sends us their unique training requests based on actual work experience, for incorporation into the course.

•

We use a heuristic approach to teaching; course content is structured in a way that encourages participants to build from their mistakes. We try as much as possible in our courses to simulate actual experiences in the work place. All exercises are based on case studies and each delegate gets a branded thumb drive containing manuals, exercises, solutions and support material.

Post Training Phase

• •

Participants complete an online post-training evaluation. We send their evaluations as a report to the client. We offer free online post-training support via our various online sites: Facebook page, newsletters, Twitter and YouTube training videos.

43

How We Train

Our Training Centre

Our courses are public (open), in-house or via a training academy.

Training Venue

1.

Public courses: Please review our 2014 open training calendar (available on our website and the center spread of this brochure) for all public course dates. We publish our annual calendar in November for the coming year Open courses are very convenient for clients that want the flexibility of sending small contingents of staff to a selection of our courses throughout the year. All courses hold at our training centre in Lagos or designated venues in other locations.

2.

In-house courses: These are tailored to clients' specific needs and mutually agreed fees, dates and venue. We recommend that a minimum of 10 participants and maximum of 20 participate in in-house courses. Clients can select from our different course offerings to create a unique course tailored to their specific needs. Inhouse courses can also be based upon real life examples from participants to afford a greater level of customisation and realism to the training, guaranteeing a higher return on investment for clients.

3.

Training Academy: Clients can completely outsource their new recruitment training programs to us, from conception to delivery. With our experience and highly competent faculty, we will deliver world-class training to expose your new recruits to the potential challenges that they will face in their new jobs. This will make them more efficient and help them to work smartly from day one, saving clients time and money.

70A Adeyemo Akapo Street Omole Phase 1, Agidingbi Lagos, Nigeria The Training Facilities We usually limit our class sizes to a maximum of 20 participants. Our Open Training Hall is spacious and comfortable; it is adequately airconditioned with 24 hours power supply. We use world class hotel conference centres for our offshore courses and regularly use our client’s training centres to facilitate in-house courses. Whatever your preference, we are sure we have a solution that meets your unique requirements, Equipment Training is delivered via a modern projector and a tablet PC and there are new Laptops for hire if required.

WAYS TO REGISTER 1.

On line: www.dbrownconsulting.net

2.

Email: [email protected]

3.

Phone: 0700TRAINING (0700 872 46464) (Nigeria) Princess: +234 (0) 701 375 0888 (Nigeria) Amy: +44 (0) 2075291496 (UK)

4.

Fax: +234 1 2626690 (Nigeria) +44 (0) 2075291402 (UK)

TRAINING REQUESTS Immediately after registration, you are expected to email all your training requests to [email protected] PAYMENT METHOD Cheque / Bank Draft made payable to dbrownconsulting. DISCLAIMER dbrownconsulting reserves the right to change or cancel any part of its published programme due to unforeseen circumstances.

44

contact information Training Centre 70A Adeyemo Akapo Street Omole Phase 1, Agidingbi Ikeja, Lagos, Nigeria. Nigeria Office: 3rd Floor Africa Re House Karimu Kotun Street Victoria Island, Lagos, Nigeria. Tel: +234 701 375 0888 +234 1 2705560 ext 637 Fax: +234 1 2626690 UK Office: Landmark House, 17 Hanover Square, Mayfair, London, UK W1S 1HU NG Contact: Training: Princess Odiakosa 0700TRAINING (070087246464) +234 805 777 0904 Payroll Outsourcing: Tosin Aromokun 0700PAYROLL (0700 729 7655) +234 802 296 6064 Financial Consulting: David Brown +234 701 375 0888 ICA Training enquiries: Seyi Agboola/Olumese Ogie +234 701 375 0888 Email:

[email protected]

UK Contact: Amy Hylton Tel: +44 (0) 2075291496 Fax No: +44 (0) 2075291402

Page layout and design: konsept kolture +234 803 520 4277

Email, Web and Collaboration Information Register Online: www.dbrownconsulting.net Email: [email protected] Free training videos: www.youtube.com/dbrownconsulting Facebook page: dbrownconsulting Follow us on Twitter: @dbctraining

www.dbrownconsulting.net