23/03/2026
Financial Modeling Training in Abuja
This course provides participants with practical skills in building robust financial models and performing corporate valuations. It covers model design, financial statement forecasting, discounted cash flow (DCF) valuation, relative valuation, and scenario analysis.
Financial Modeling Training Outline
Module 1: Introduction to Financial Modeling and Valuation
Purpose and applications of financial models
Best practices in model design and structure
Overview of valuation methodologies
Module 2: Excel for Financial Modeling
Essential Excel functions for modeling (INDEX, MATCH, OFFSET, NPV, IRR, etc.)
Data validation, scenario tools, and error checks
Building dynamic and flexible spreadsheets
Module 3: Financial Statement Analysis
Linking the balance sheet, income statement, and cash flow statement
Key financial ratios and performance metrics
Adjusting historical data for analysis
Module 4: Forecasting Financial Statements
Revenue and expense drivers
Working capital and capital expenditure forecasting
Building pro forma financial statements
Module 5: Cost of Capital and Capital Structure
Calculating WACC (Weighted Average Cost of Capital)
Impact of leverage on value
Estimating cost of equity and cost of debt
Module 6: Discounted Cash Flow (DCF) Valuation
Free cash flow to firm vs free cash flow to equity
Terminal value estimation (Gordon growth and exit multiple methods)
Sensitivity analysis in DCF models
Module 7: Relative Valuation Techniques
Trading comparables (P/E, EV/EBITDA, P/B ratios)
Precedent transactions analysis
Adjusting for industry and market differences
Module 8: Valuation in Special Contexts
Valuing startups and high-growth companies
Distressed company valuation
Real options in valuation
Module 9: Scenario and Sensitivity Analysis
Building scenarios for different economic conditions
Sensitivity tables and tornado charts
Monte Carlo simulations for valuation uncertainty
Project: Building a financial model from scratch.
