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
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.
Trainer at Piston and Fusion Business Academy • Nigeria
B.Sc. in Microbiology; certifications in Data Analysis, Financial Analysis, and Financial Modelling (DAFM)
Olawande Akinmola is a Business Intelligence Analyst and facilitator skilled in transforming data into actionable insights. With a B.Sc. in Microbiology and certifications in Data and Financial Analysis, she specializes in SQL, Tableau, and Power BI. With three years of experience, she helps businesses make data-driven decisions through clear, strategic insights. As a facilitator at Piston and Fusion, she empowers professionals with data literacy, making complex information accessible and impactful.
Finance Consultant at Alphafortress LLC and Chief Accountant at Refitok Limited • Nigeria
M.Sc. in Accounting; B.Sc. in Accounting; HND in Estate Management; AATWA; ACA (ICAN); FCTI (CITN)
Azeez Owoeye is a highly skilled accounting and finance professional holding an M.Sc. in Accounting, along with AATWA, ACA (ICAN), and FCTI (CITN) certifications. His expertise encompasses a wide range of financial functions, from bookkeeping and financial reporting to tax planning, data analysis (Excel and Power BI), and consulting. Proficient in various accounting software like SAGE, Peachtree, and Tally, Azeez has a proven track record of successful projects, including accounting system conversions, tax filing for various entities, and consulting for the Lagos State Internal Revenue Service. Currently a Finance Consultant at Alphafortress LLC and Chief Accountant at Refitok Limited, Azeez brings a wealth of practical experience and technical expertise to his roles.
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
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.
Talk to the Career Advisor and join the next schedule.
Are you a corporate client looking to upskill your team?
To register multiple employees for our courses, please fill out this form to request a proposal.
We’ll provide you with a detailed quote, outlining the costs and benefits of your chosen courses. Once approved, we’ll generate an invoice for payment.
Let’s elevate your team's skills together!
https://www.pistonandfusion.org/enrol-now?type=corporate&course=financial-modeling-and-forecasting-senior-analystWe help you decide if this course is a good match for your career. We can also help you plan and develop a career path.
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.