delivery
Classroom & Virtual
duration
5 days
enrolled students
9,999
overview
Course Overview
The Financial Modeling & Forecasting course is suitable for individuals who aspire to develop their financial modelling and Excel skills. The excel course will cover beginners to advanced tools and functions. The financial modelling module will cover income statements, statements of financial position and cash flow projections. The course will adopt a hands-on approach, and real-life cases will be used to develop models and taught concepts. It is the perfect option for stepping up your career and overall efficiency in Financial Modeling & Forecasting. Skilled financial modellers are in high demand, and are well paid as there is little to no competition in the industry. Hence, enrolling for this Financial Modeling & Forecasting course is an opportunity to increase your earning potential.
Learning Outcomes
- Understand the difference between tax avoidance and tax evasion.
- Identify tax reliefs and incentives available to taxpayers.
- Develop tax planning strategies to reduce tax liabilities legally.
- Learn about the functions and powers of tax authorities in Nigeria.
- Understand the different taxes regulated by the federal, state, and local governments.
- Become familiar with the tax filing process and the implications of non-compliance.
Curriculum
Introduction to Financial Modeling & Advanced Excel Functions
Advanced Excel Functions for Building Flexible Financial Models
Income Statement & Statement of Financial Position
Forecast Layouts & Calculations
Building Forecasting Schedules & Cash Flow Statements
Introduction to Financial Modeling & Advanced Excel Functions
What are Financial Models
Types of Financial Models
What is a financial model used for?
Best & Bad Practices in Financial Modelling
Advanced Excel Functions for Building Flexible Financial Models
SUM, SUMIF, SUMIFS, VLOOKUP
INDEX & MATCH, PMT
IF Statement
Data Validation & Duplicates
Income Statement & Statement of Financial Position
Review of Source Data
Introduction to Income Statement
Building the Income Statement output sheet
Populating the Income Statement
Introduction to Statement of Financial Position
Populate the Statement of Financial Position
Forecast Layouts & Calculations
Adding a Forecast Period to the Income Statement
Calculating Historical Percentage Ratios Income Statement
Building a flexible model with Scenario Manager (VLOOKUP) Income Statement
Adding a forecast period for the Statement of Financial Position
Forecasting DSO, DPO, DIO, Other Assets & Other Liabilities
Building Forecasting Schedules & Cash Flow Statements
Building a Fixed Asset Roll Forward
Building the Financial liabilities schedule Sheet
Building the equity schedule Sheet
Building the cash flow sheet
who attends
Right For You
Participants enrolling for this programme will be required to have a minimum of 3 years’ professional experience. Participants who meet the programme requirement should pay the course fee and complete the enrollment form 2 weeks before the programme kick off date.
Requirements:
- Experienced individuals who manage financial activities in diverse fields
- Working professionals seeking to change career, job or industry to financial modelling related field
- Individuals who meets the requirements and intend on starting a career in financial modelling
- Mid to senior-level executives in any sector
Prospective applicants who do not meet the programme requirement but want to join the programme should talk to a Career Advisor.
Key Program Features
Training
The Financial Modeling & Forecasting Using Excel training approach employs hands-on learning, which imparts the skills required for specific job roles.
Internship & Projects
The Financial Modeling & Forecasting Using Excel course provides up to 4 months of internship while working on real work projects, which adds expertise and verifiable work references in the resident country.
Career Development
The Financial Modeling & Forecasting Using Excel course assists participants in securing a job through the development of a professional profile and job prospecting.
teaching team
Meet Your Facilitator(s)
testimonials
What Participants Said
The P&F Experience
Piston & Fusion Business Academy empowers individuals and businesses to achieve their professional goals through a variety of innovative courses, programs, and career services.

course schedule
The Schedule For This Course
Piston and Fusion offer the Course as Classroom in Lagos and Virtual Online Class in other states in Nigeria. See dates and fees for classroom and virtual online class.
Classroom
Weekdays
Dates:
22nd Apr – 26th Apr, 2025
Days:
Tue, Wed, Thu, Fri & Sat
Time:
8:30am – 4pm
Duration:
5 days
Weekends
Contact Us
Virtual
Weekdays
Dates:
22nd Apr – 26th Apr, 2025
Days:
Tue, Wed, Thu, Fri & Sat
Time:
8:30am – 4pm
Duration:
5 days
Weekends
Contact Us
fees
What It Will Cost
Piston and Fusion offer the Course as Classroom in Lagos and Virtual Online Class in other states in Nigeria. See dates and fees for classroom and virtual online class.
₦240,000
₦290,000
₦370,000
₦420,000
Standard
₦240,000
Virtual Only
Course Materials
Certificate
Manual, Cases & Templates
Mentorship
-
Refreshment
-
Perks
-
-
Additional Services
-
-
₦240,000
₦290,000
₦370,000
₦420,000
Standard Plus
₦290,000
Virtual Only
Course Materials
Certificate
Manual, Cases & Templates
Mentorship
3 Months
Refreshment
-
Perks
-
-
Additional Services
CV & LinkedIn Profile Development
Exam Application (Only for Certification courses)
₦240,000
₦290,000
₦370,000
₦420,000
Professional
₦370,000
Classroom & Virtual
Course Materials
Print & PDF
Certificate
Manual, Cases & Templates
Mentorship
-
Refreshment
Teabreak & Lunch
Perks
Souvenir
Notepad & Pen
Additional Services
-
-
₦240,000
₦290,000
₦370,000
₦420,000
Professional Plus
₦420,000
Classroom & Virtual
Course Materials
Print & PDF
Certificate
Manual, Cases & Templates
Print & PDF
Mentorship
3 Months
Refreshment
Tea Break & Lunch
Perks
Souvenir
Notepad & Pen
Additional Services
CV & LinkedIn Profile Development
Exam Application (Only for Certification courses)
apply now
Ready to Join the Course?
This programme is designed for executives tasked with igniting innovation within their organisations, or who seek to create innovative solutions to a major challenge.
How to Apply:
- Check the website to select a course of choice and fee.
- Pay the registration fee and tuition to P&F account domiciled at First Bank
- DETAILS Account Name: Piston & Fusion Ltd Account Number: 2015242578 Bank: First Bank of Nigeria
- Send your name, phone no, email, training location, amount paid & proof of payment to fees@pistonandfusion.org
- Complete the enrollment form ONLY AFTER PAYMENT
- CASH PAYMENTS ARE NOT ALLOWED, ALL PAYMENTS MUST BE MADE TO THE COMPANY’S ACCOUNT.
Reserve a slot
FAQs
Frequently Asked Questions
Yes, we may be able to reschedule your course. Please contact our customer support team for more information and to discuss your specific request.
Upon successful completion of the course, you will receive a certificate showing that you completed the course.