logo

Financial Modeling & Forecasting Using Excel

Unlock the power of Excel for financial planning!

Financial Modeling & Forecasting Using Excel

Apply Before

April 15, 2025

Next Start Date(s)

Fees

delivery

Classroom & Virtual

duration

5 days

enrolled students

9,999

Financial Modeling & Forecasting Using Excel

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.

The P&F Experience Video

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.

STD

₦240,000

STD +

₦290,000

PRO

₦370,000

PRO +

₦420,000

Standard

₦240,000

Virtual Only

Course Materials

PDF

Certificate

PDF

Manual, Cases & Templates

PDF

Mentorship

-

Refreshment

-

Perks

-

-

Additional Services

-

-

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
  • 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

Loading...

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.