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.
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
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:
Prospective applicants who do not meet the programme requirement but want to join the programme should talk to a Career Advisor.
The Financial Modeling & Forecasting Using Excel training approach employs hands-on learning, which imparts the skills required for specific job roles.
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.
The Financial Modeling & Forecasting Using Excel course assists participants in securing a job through the development of a professional profile and job prospecting.
Piston & Fusion Business Academy empowers individuals and businesses to achieve their professional goals through a variety of innovative courses, programs, and career services.
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.
17th Mar – 21st Mar, 2025
Mon – Fri
8:30am – 4pm
5 days
Contact Us
17th Mar – 21st Mar, 2025
Mon – Fri
8:30am – 4pm
5 days
Contact Us
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
Virtual Only
-
-
-
-
-
-
₦240,000
₦290,000
₦370,000
₦420,000
Virtual Only
3 Months
-
-
-
CV & LinkedIn Profile Development
Exam Application (Only for Certification courses)
₦240,000
₦290,000
₦370,000
₦420,000
Classroom & Virtual
Print & PDF
-
Teabreak & Lunch
Souvenir
Notepad & Pen
-
-
₦240,000
₦290,000
₦370,000
₦420,000
Classroom & Virtual
Print & PDF
Print & PDF
3 Months
Tea Break & Lunch
Souvenir
Notepad & Pen
CV & LinkedIn Profile Development
Exam Application (Only for Certification courses)
This programme is designed for executives tasked with igniting innovation within their organisations, or who seek to create innovative solutions to a major challenge.
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.
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.