Become a proficient Financial Analyst. Master integrated 3-statement modeling, advanced forecasting, sensitivity analysis, and basic valuation techniques using Excel. Training in Lagos, Abuja, and online.
Apply Before
Contact Us
Next Start Date(s)
Fees
Cost Reduction, Control and Revenue Management
Credit Risk Analysis
Finance for Senior Executives Program
Financial Audit Essentials
Financial Modeling & Forecasting: Junior Analyst
Financial Risk Management
Financial Strategies for Value Creation
Tax Planning & Corporate Compliance
Treasury & Fund Management
Elevate Your Expertise for Strategic Financial Impact
Building upon foundational modeling skills, the Financial Analyst course focuses on constructing robust, integrated 3-statement financial models in Excel. Participants will learn advanced forecasting and analysis techniques, how to optimize model structure for flexibility and auditing, perform sensitivity and scenario analysis, understand core valuation principles, and interpret results for effective decision-making. This course prepares individuals for demanding Financial Analyst roles.
Career Growth: Advance into senior finance roles with strong modeling and forecasting capabilities that support strategic business decisions.
Skill Enhancement: Gain expertise in financial statement modeling, valuation, scenario planning, and predictive forecasting.
Professional Recognition: Prepare for globally respected certifications like CFA, FMVA, or CFM to boost your credibility and global employability.
Increased Earning Power: Senior Financial Analysts in Nigeria can earn ₦700,000 to ₦1,500,000 monthly, with higher potential in investment banking, consulting, and multinational firms.
By the end of the Financial Analyst course, participants will be able to:
Module 1: Advanced Excel & Modeling Best Practices Optimization
Module 2: Building Optimized & Integrated 3-Statement Models
Module 3: Advanced Forecasting Techniques & Optimization
Module 4: Performing Sensitivity & Scenario Analysis
Module 5: Introduction to Valuation & Advanced Analysis
Module 6: Model Presentation & Optimization
Module 1: Advanced Excel & Modeling Best Practices Optimization
Advanced Excel Functions: INDEX/MATCH, OFFSET, CHOOSE, IFERROR, Advanced Logical (AND/OR), Financial (NPV, IRR, PMT, FV, PV)
Advanced Data Tools: Data Tables (1-way, 2-way), Scenario Manager, Goal Seek, Solver Introduction
Robust Error Checking: Implementing Checks & Balances, Model Auditing Techniques
Optimizing Model Structure: Separation of Inputs/Calculations/Outputs, Dynamic Headers, Version Control Basics
Module 2: Building Optimized & Integrated 3-Statement Models
Constructing Fully Integrated Models: Ensuring dynamic links between IS, BS, CF
Handling Circular References: Iterative Calculations, Copy-Paste Macros (Concept), Toggle Switches
Building Detailed Supporting Schedules:
Complex Depreciation (Multiple asset classes, methods)
Detailed Debt Tranches (Revolvers, Term Loans, Repayment Schedules)
Working Capital Schedules (DSO, DPO, DIO forecasting)
Equity Schedule (Share issuances, dividends, buybacks)
Module 3: Advanced Forecasting Techniques & Optimization
Various Forecasting Methods: % of Revenue, Regression Analysis Basics, Detailed Driver-Based Forecasting
Building Flexibility: Scenario Toggles (CHOOSE, INDEX, Data Validation Lists)
Forecasting Working Capital Items in Detail
Projecting Complex Debt & Equity Structures (Refinancing, new issuances)
Module 4: Performing Sensitivity & Scenario Analysis
Sensitivity Analysis: Using Data Tables for 1-way and 2-way analysis on key outputs (e.g., EPS, Valuation)
Scenario Analysis: Using Scenario Manager to compare base, upside, and downside cases
Interpreting Results: Identifying key drivers, understanding model risk, break-even analysis concepts
Module 5: Introduction to Valuation & Advanced Analysis
Core Valuation Concepts: Time Value of Money, WACC (Weighted Average Cost of Capital) - Basic Calculation & Concept
Calculating Free Cash Flow: FCFF (Free Cash Flow to Firm) & FCFE (Free Cash Flow to Equity) from the model
Basic Discounted Cash Flow (DCF) Analysis: Projecting FCF, Calculating Terminal Value (Gordon Growth/Exit Multiple), Discounting to Present Value
Calculating & Interpreting Key Financial Ratios: Liquidity (Current/Quick), Solvency (Debt/Equity, Interest Coverage), Profitability (ROE, ROA, Margins), Activity (Turnover Ratios)
Introduction to M&A / LBO Modeling Concepts (Optional, time permitting)
Module 6: Model Presentation & Optimization
Creating Summary Output Sheets & Dashboards: Using Charts, Tables, Conditional Formatting
Effectively Presenting Model Assumptions: Clarity and justification
Presenting Key Outputs & Conclusions: Summarizing findings, key takeaways
Optimizing Model Presentation for Stakeholder Communication (Clarity, conciseness)
Participants enrolling for this programme will be required to have intermediate to advanced Excel skills, basic accounting knowledge, and familiarity with financial statements. Participants who meet the programme requirements should pay the course fee and complete the enrollment form 2 weeks before the programme kick-off date.
Requirements:
Prospective applicants who do not meet the programme requirement but want to join the programme should talk to a Career Advisor.
Piston and Fusion offer the Financial Modeling, Forecasting & Valuation Course as Classroom in Lagos and Virtual Online Class in other states in Nigeria. See dates for classroom and virtual online class.
Senior Financial Analyst Course Schedule for Lagos, Abuja, & Online
Contact Us
Contact Us
A strong, comfortable understanding of how the three financial statements articulate is crucial before starting this course.
Yes, significantly. It assumes mastery of foundational concepts and dives deep into complex Excel functions, modeling logic, and analytical techniques.
This course introduces the concepts and builds the core 3-statement model needed for them. Dedicated LBO/M&A modeling courses would delve deeper into deal-specific mechanics.
Proficient financial analysts capable of building robust models and performing valuation are highly valued in investment banking, private equity, corporate development, equity research, and senior finance roles within corporations in Nigeria. This course provides the technical modeling skills critical for these demanding positions.
Piston and Fusion offer the Financial Modeling, Forecasting & Valuation Course as Classroom in Lagos and Virtual Online Class in other states in Nigeria. See fees for classroom and virtual online class.
Piston & Fusion Business Academy empowers individuals and businesses to achieve their professional goals through a variety of innovative courses, programs, and career services.
Talk to the Career Advisor and join the next schedule.
Our Financial Modeling, Forecasting & Valuation Training Location in Lagos, Abuja, PH & Online
Piston & Fusion Business Academy Lagos Training Centre is located at 122a Obadina Street, Omole Phase 1, Ikeja | Abuja Office is located at 22 Kumasi Cres, Wuse 2, Abuja 904101, Federal Capital Territory
You can join our classes from anywhere in Nigeria, Canada, the UK and the US via our Virtual Online Programs
We help you decide if this course is a good match for your career. We can also help you plan and develop a career path.