Financial Modelling
Financial Modelling
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
Open Course: NGN 100,000/participant
Office implant: NGN 1.7m/class of 10
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
Open Course: NGN 100,000/participant
Office implant: NGN 1.7m/class of 10
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
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
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
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
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