delivery
Classroom & Virtual
duration
5 days
enrolled students
9,999
Related Courses
Cost Reduction, Control and Revenue Management
Credit Risk Analysis
Finance for Senior Executives Program
Financial Audit Essentials
Financial Modeling, Forecasting & Valuation: Senior Analyst
Financial Risk Management
Financial Strategies for Value Creation
Tax Planning & Corporate Compliance
Treasury & Fund Management
overview
Course Overview
Why Should I Attend the Financial Modeling & Forecasting: Junior Analyst Training?
Start Your Career with a Foundational Course
This Junior Financial Analyst course provides participants with the foundational Excel skills and financial knowledge needed to understand financial statements, set up basic financial models, perform simple forecasting, and support financial analysis tasks. It is designed to equip individuals for entry-level analyst roles where understanding and building basic financial models in Excel is required.
Career Switch: Give yourself a new start with Financial Analysis. This course is your gateway to a high-demand, future-proof career across various industries including corporate finance, investment, and accounting.
Upgrade Your Skills: Enhance your professionalism with in-demand skills like Excel modeling, financial statement analysis, basic forecasting, and understanding key financial ratios.
Improved Earning Potential: Junior Financial Analysts in Nigeria earn competitive monthly salaries, depending on the industry, technical skills, and level of hands-on experience.
Learning Outcomes
What Will You Learn in Our Financial Modeling & Forecasting Junior Analyst Course?
By the end of the Junior Financial Analyst course, participants will be able to:
- Apply Excel best practices and essential functions for financial modeling.
- Understand and structure the three core financial statements (IS, BS, CF) in Excel using historical data.
- Build simple supporting schedules (Revenue, Assets, Debt) based on basic assumptions and drivers.
- Construct a basic forecasted Income Statement and Balance Sheet, ensuring key linkages and balancing.
- Set up a simple Cash Flow Statement using the indirect method, reconciling cash balances.
- Implement basic model formatting, error checks, and clearly document assumptions.
Curriculum
Module 1: Financial Modeling & Excel Fundamentals Setup
Module 2: Setting Up Historical Financial Statements in Excel
Module 3: Setting Up Basic Forecasting Schedules
Module 4: Building a Basic Forecasted Income Statement & Balance Sheet
Module 5: Setting Up a Basic Cash Flow Statement
Module 6: Introduction to Model Review & Formatting
Module 1: Financial Modeling & Excel Fundamentals Setup
Purpose and Types of Financial Models
Core Excel Best Practices for Modeling: Formatting, Structure, Clarity
Essential Excel Functions: SUM, AVERAGE, IF, SUMIF/SUMIFS, Basic Arithmetic
Key Data Tools: Sorting, Filtering, Basic Data Validation
Understanding the 3 Core Financial Statements: Income Statement (IS), Balance Sheet (BS), Cash Flow Statement (CF)
Basic Linkages Between Financial Statements
Module 2: Setting Up Historical Financial Statements in Excel
Inputting and Structuring Historical IS and BS Data
Calculating Key Historical Ratios: Growth Rates, Basic Margins (Gross, Operating)
Ensuring the Historical Balance Sheet Balances
Setting up Basic Error Checks (e.g., BS Check)
Module 3: Setting Up Basic Forecasting Schedules
Understanding Forecasting Drivers and Assumptions
Building Simple Supporting Schedules:
Basic Revenue Forecast (e.g., simple growth rate)
Basic Fixed Asset Schedule (Straight-line depreciation)
Simple Debt Schedule (Basic interest calculation)
Using Lookup Functions (VLOOKUP, INDEX/MATCH) to pull data
Module 4: Building a Basic Forecasted Income Statement & Balance Sheet
Projecting IS Line Items: Linking to Schedules, Historical Trends, Simple Drivers
Projecting BS Items: Linking to Schedules, IS (Net Income to Equity), Working Capital basics
Ensuring the Forecasted Balance Sheet Balances (The "Plug" - often Cash or Debt)
Module 5: Setting Up a Basic Cash Flow Statement
Structure of the Cash Flow Statement: Operating, Investing, Financing Activities
Building a Simple CF Statement (Indirect Method):
Starting with Net Income
Adjusting for Non-Cash Items (Depreciation)
Incorporating Changes in Working Capital (from BS changes)
Reflecting Investing & Financing Activities (from schedules/BS changes)
Reconciling Beginning and Ending Cash Balances
Module 6: Introduction to Model Review & Formatting
Applying Consistent Formatting: Number formats, Colors, Fonts
Importance of Clear Assumptions Sections
Implementing Basic Checks and Balances within the model
Basic Model Documentation Principles
who attends
Right For You
Is the Financial Modeling & Forecasting Junior Analyst Training Right for You?
Participants enrolling for this programme will be required to have no prior financial modeling experience, but a basic understanding of accounting principles (debits/credits, core financial statements) is highly recommended.
Proficiency in basic Excel operations (navigation, simple formulas) is essential, and access to a computer with Microsoft Excel installed.
Requirements:
- Individuals seeking entry-level positions in finance, accounting, or investment banking (e.g., Junior Analyst, Finance Assistant, Accounting Clerk).
- Business students or recent graduates looking to build practical financial modeling skills.
- Professionals in other fields needing a foundational understanding of financial statements and basic modeling in Excel.
- Entrepreneurs or small business owners wanting to perform basic financial forecasting.
- Career changers aiming to enter the finance or accounting fields.
Prospective applicants who do not meet the programme requirement but want to join the programme should talk to a Career Advisor.
Why is Piston & Fusion Ranked the Best Financial Modeling & Forecasting Training Institute in Nigeria?
Expert Instructors: Learn from experienced financial professionals who bring real-world industry expertise into every session.
Flexible Learning Options: Choose between Classroom training in Lagos/Abuja or Instructor-led Virtual Online classes to suit your schedule and location.
Hands-on Learning: Sessions are delivered with practical exercises and real datasets to simulate workplace financial challenges and build confidence.
Case Studies: Practical financial modeling projects are used to teach problem-solving, business insight generation, and data-driven decision-making within a financial context.
Tools and Templates: Gain proficiency using industry-standard tools like Excel, along with templates for financial models, reports, and basic analysis.
Certification
What Are the Benefits of the Financial Modeling & Forecasting Junior Analyst Certificate?
Acquire essential financial modeling skills, including building 3-statement models, basic forecasting, and financial statement analysis, through a hands-on learning approach using Excel.
Improve your job prospects for entry-level roles such as Junior Financial Analyst, Finance Assistant, or Reporting Analyst with targeted training and career development support.
Gain valuable real-world experience and verifiable references by participating in an internship of up to four months on actual financial analysis projects across various industries.
Establish a solid foundation for career progression and the pursuit of more advanced financial certifications like the CFA (Chartered Financial Analyst) or FMVA
teaching team
Meet Your Financial Modeling & Forecasting Trainers
testimonials
Hear From Our Successful Financial Modeling & Forecasting Alumni
The Financial Modeling & Forecasting Training 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
What Is The Financial Modeling & Forecasting Course Schedule for 2025?
Piston and Fusion offer the Financial Modeling & Forecasting Course as Classroom in Lagos and Virtual Online Class in other states in Nigeria. See dates for classroom and virtual online class.
Classroom & Virtual
Junior Financial Analyst Course Schedule for Lagos, Abuja, & Online
Weekdays
Dates:
18th Aug – 22nd Aug, 2025
Days:
Mon – Fri
Time:
8:30am – 4pm
Duration:
5 days
Weekends
Contact Us
fees
How Much is the Financial Modeling & Forecasting: Junior Analyst Training Fee in Nigeria?
Piston and Fusion offer the Junior Financial Analyst Course as Classroom in Lagos and Virtual Online Class in other states in Nigeria. See fees for classroom and virtual online class.
₦150,000
₦180,000
₦230,000
₦260,000
Standard
₦150,000
Virtual Only
Course Materials
Certificate
Manual, Cases & Templates
Mentorship
-
Refreshment
-
Perks
-
-
Additional Services
-
-
₦150,000
₦180,000
₦230,000
₦260,000
Standard Plus
₦180,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)
₦150,000
₦180,000
₦230,000
₦260,000
Professional
₦230,000
Classroom & Virtual
Course Materials
Print & PDF
Certificate
Manual, Cases & Templates
Mentorship
-
Refreshment
Teabreak & Lunch
Perks
Souvenir
Notepad & Pen
Additional Services
-
-
₦150,000
₦180,000
₦230,000
₦260,000
Professional Plus
₦260,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
How Do I Enrol for The Junior Financial Modeling & Forecasting Course?
Talk to the Career Advisor and join the next schedule.
Where Can I Take the Financial Modeling & Forecasting Junior Analyst Training in Nigeria?
Our Financial Modeling & Forecasting 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
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
contact us
Contact Us for Financial Modeling & Forecasting Training Enquiries
Get Free Career Counselling
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.
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.
Financial modeling is the process of creating a spreadsheet-based summary of a company's expenses and earnings to anticipate future financial performance. It involves forecasting a company's financial statements and performance based on historical data and assumptions about the future. This course covers the basics of building these models in Excel.
Not strictly required, but foundational knowledge in these areas is very helpful and often assumed in entry-level roles. The course focuses on the Excel modeling aspect.
No. Investment banking requires much more advanced modeling, valuation, and deal structuring knowledge, typically built upon these foundations.