LOGIN
CONTACT US
TRAINING
REPORTS

Research Training Calendar 2020

Click on any course to get more details

Month	Course(a)	Course(b)	Date
January	Available for Implant Training	Financial Modelling	a) Open for Discussion b) Open for Discussion
February	Understanding Financial Markets	Power Point Essentials	a) 11th & 12th. b) 27th & 28th.
March	Company & Industry Analysis	Fixed Income Analysis	a) 12th & 13th b) 26th & 27th .
April	Available for Implant Training	Available for Implant Training	a) Open for Discussion b) Open for Discussion
May	Available for Implant Training	Business Valuation	a) Open for Discussion b) 21st & 22nd .
June	Power BI	Available for Implant Training	a) 17th & 18th b) Open for Discussion.
July	Available for Implant Training	Available for Implant Training	a) Open for Discussion b) Open for Discussion
August	Financial Modeling	Available for Implant Training	a) 11th & 12th. b) Open for Discussion.
September	Understanding Financial Markets	Power Point Essentials	a) 8th & 9th. b) 30th & 31st.
October	Company & Industry Analysis	Fixed Income Analysis	a) 7th & 8th b) 29th &30th
November	Business Valuation	Available for Implant Training	a) 11th & 12th. b) Open for Discussion.
December	Power BI	Available for Implant Training	a) 8th & 9th b) Open for Discussion.

Research | Powered by Meristem

Financial Modeling

Course Content

Excel Overview

Excel Shortcuts
Financial Modeling the aesthetics RIGHT
Understanding Arrays
Basic to Intermediate functions

Intermediate Function

Working with Date and Time
Text Manipulation
Working with databases
Naming Techniques
Conditional functions
Specialized look-up formula
Data Validation
Sensitivity Analysis
Scenario Analysis

Advanced Function

Using Interactive Controls
Using Developer Ribbon Controls
Form Controls and Active X Controls
Creating Charts and Graphics
Introducing Charts
Creating Charts
Customizing Charts
Working with Charts
Modifying Charts
Creating Chart templates
Conditional formatting in charts
Creating dynamic charts

Class Project

Creating dashboard for specific tasks

Investment/Project Analysis for decision making

Equity Model
Bond Model
T-Bills Model

Fees

Open Course: NGN 100,000/participant

Office implant: NGN 1.7m/class of 10

Pay Now
Register

Fixed Income Analysis

Course Content

Overview and types of fixed income securities

Risks associated with investing in fixed income securities

Market
Interest rate risk
Reinvestment risk
Call risk
Credit risk
Maturity risk

Legal, Regulatory and Tax Considerations
Bond Indenture
Legal and Regulatory Considerations
Tax Considerations

Bond Markets
Primary Market
Secondary Market
Treasury Bills Market
Primary Market
Secondary Market

Other Fixed Income Instruments
Basic Understanding of the Nigerian Treasury Bills Market
Players in the Treasury Bills Market
Trading in the Nigerian Market
Pricing

Basic understanding of the Nigerian bond market
Players in the Nigerian Bond Market
Trading in the Nigerian Market

Bond pricing, Yield Measures and Total return
Bond Pricing
Yield to Maturity
Coupon Payment Structures
Principal Repayment Structures
Structure of Interest rates

Valuation and Analysis
Determining Risk Free Rate
Determining Risk Premium

Fees

Open Course: NGN 100,000/participant

Office implant: NGN 1.7m/class of 10

Pay Now
Register

Understanding Financial Markets

Course Content

Financial Markets
• Primary and secondary markets.
• Money and capital markets
• Debt and equity markets
• Cash and derivative markets
Financial Intermediaries
• Commercial Banks and Investment banks
• Mortgage Banks
• Insurance Companies and Pension Fund Administrators
• Investment Firms
Financial Systems
• Market-based and Bank-based
Flow of Funds
• Households and Firms
• Government and Foreign sector
The Nigerian Equities market :The Primary Market
• Function of primary market
• Motivation for listing
• Regulatory bodies, Listing requirements and Methods of listing
Secondary Market
• Function and Structure of secondary market
• Participants and Trading Mechanisms
Money market
• Money Market Instruments
• Discussion on the global money market
Bond market
Types of bonds
Bond pricing
Future of the Financial Market :Financial innovation disruptions
• Artificial Intelligence
• Machine Learning
• Block-chain Technology
• Crowdfunding
• Initial Coin Offering…
Nigerian Financial Market Medium-Long term Outlook:
• Opportunities and Challenges

Fees

Open Course: NGN 100,000/participant
Office implant: NGN 1.7m/class of 10

Pay Now
Register

PowerPoint Essentials

Course Content

The PowerPoint Interface
• Getting Started
• Terminologies and Overview
• Principles of Slide Design
Slide Editing
• Working with Themes, Slide Masters and Templates
• Creating SmartArt
• Formatting shapes and images
• Using Textboxes and Placeholders
• Objects Alignment
• Grouping and Arranging Objects
• PowerPoint Shortcuts
Multimedia Automation
• Inserting and Formatting Images, Objects, Table, Charts and Graphs.
• Editing Images.
• Cropping, resizing and manipulation .
• Applying Artistic Effects.
• Adding Sounds.
• Adding videos and movies
Maintaining Presentation Flow
• Connecting the Slides
• Using the Separator Slides
• Inserting Hyperlinks
• Adding and controlling transition effects between slides
• Detailed animation and transition options.

Fees

Open Course: NGN 80,000/participant

Office implant: NGN 1.5m/class of 10

Pay Now
Register

Company & Industry Analysis

Course Content

Industry Analysis
• Analysis of Internal environment
• Porter’s Five forces
• Life-cycle Analysis
• Analysis of the external environment
• Macroeconomic factors
• Social factors
• Technological factors etc.

Company Analysis
• Analysis of various competitive Strategies
• What to consider in company analysis
• Corporate Profile
• Characteristics and position in the industry
• Demand and Supply analysis of Product
• Pricing environment etc.
• Framework for Company Analysis

Financial Statement Analysis
• Why Financial Statement Analysis
• Understanding the major financial and other non-financial elements
• Income Statement
• Analysis of each line item
• Forecasting
• Common size analysis
• Statement of Financial Position
• Analysis of each line item
• Forecasting
• Common size analysis
• Cashflow Statement

Financial Ratios
• Profitability ratios and their interpretations
• Liquidity ratios and their interpretations
• Solvency ratios and their interpretations
• Indicators of risks in a financial statement
• Compare historical performance and peer review
• Practical examples on some companies listed on the NSE

Case Study

Fees

Open Course: NGN 100,000/participant

Office implant: NGN 1.5m/class of 10

Pay Now
Register

Company & Industry Analysis

Course Content

Why Value?
• Implications for capital market integrity, buy-sell agreements, M&As…
• Understanding the craft of Valuation
• Dealing with Analysts’ Biases
• Valuation Framework
Linking valuation to corporate strategy
• Fundamental drivers of Value
• Interpreting company financials
• Calculating Cost of equity – Risk Free Rate, Beta, Equity Risk Premium,
leveraging/re-leveraging beta, adjusting beta, size risk premium, company
specific risk premium, …
• Cost of debt – Yield to Maturity, build-up, loan book…
• Weighted Average Cost of Capital

Forecasting
• Forecasting Income statements and Balance Sheet
• Forecasting the benefit streams for finite period and continuing period –
Dividends, Residual Income, Free Cash flow to Equity, Free Cash flow to the
Firm.
Other valuation assumptions – estimating reinvestment rate, continuing growth rate, and dealing with the inconsistencies
• Valuation Adjustments – control premium, marketability discount…
• Transaction multiple – MVIC and Equity Multiples, Market Price Multiples

Valuation of the selected company using Asset, Market and Income Approaches
Sensitivity Analysis
Alternating among the various levels of value
Peculiarities of private companies, both start-ups and mid-market companies.
Pricing and valuation – the nexus.

Fees

Open Course: NGN 150,000/participant

Office implant: NGN 2.2m/class of 10

Pay Now
Register

Power BI

Course Content

Overview
• Understanding the dashboard
• Interacting with the dashboard
• Getting Data: Excel vs Power BI Desktop & Service
• Naming for Q&A

Modeling Setup and Manage
• Setup and Mange Relationships
• Cardinality and Cross Filtering
• Default Summarization & Sort by

Power BI Desktop Visualizations
• Color & Conditional Formatting
• Setting Sort Order
• Slicers, Timeline Slicers & Sync Slicers
• Visual, Page and Report Level Filters
• Map Visualizations
• KPI’s, Cards & Gauges
• Bookmarks & Buttons.

Power BI Service Visualization Tools

• Introduction
• Standalone Tiles

Publishing & Sharing
• Overview of sharing options
• Publish from Power BI Desktop
• Publish Reports to Web
• Workspaces
• Apps
• Row Level Security

Refreshing Datasets
• Understanding Data Refresh
• Replacing a Dataset
• Troubleshooting Refreshing

Fees

Open Course: NGN 100,000/participant

Office implant: NGN 1.5m/class of 10

Pay Now
Register

Implant Training

Course Content

For every implant training:
• We tailor each module to the needs of the company and a pre-training assessment will be conducted to determine any special need and the curriculum enhanced to meet such objectives.
• We provide hands-on experience in which the participants will follow the skill demonstrations of the instructors on their laptops and build models of their own.
• We acknowledge that everyone is not on the same point on the learning curve and will therefore be willing to give special attention to participants needing such to bring everyone to speed on the training.
• Meristem is here to add value and will therefore provide a guaranteed follow-up service for thirty days (30) after the course. During this period, participants can email the instructors any question that pertains to the classes and they will be responded to within 1-2 business days.
Fees

Negotiable