Financial Modelling & Forecasting Using Excel

Financial Modelling and Forecasting Using Excel Course Overview

The Financial Modeling and Forecasting course is suitable for individuals who aspire to develop their financial modeling and Excel skills. The excel course will cover beginners to advanced tools and functions. The financial modeling module will cover balance sheet, cash flow projections, investment appraisal, etc. 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 and Forecasting. Skilled financial modelers are in high demand, and are well paid as there is little to no competition in the industry. Hence, enrolling for this Financial Modeling and Forecasting course is an opportunity to increase your earning potential.

What is the Financial Modeling and Forecasting Course Outline?

The course will cover the following;

  • Introduction to Financial Modelling
  • Advanced Excel Functions for Building Flexible Financial Models
  • Modelling The Income Statement
  • Modelling The Statement of Financial Position
  • Developing The Forecast Layouts
  • Developing The Calculation Sheet
  • Building Forecasting Schedules
  • Modelling The Cash Flow Statements

Who Should Attend the Financial Modeling & Forecasting Course?

  • Working professionals seeking to become skilled in Excel & Financial Modelling
  • Finance officers & managers
  • Non-Finance managers that analyze and interpret finance documents
  • Fresh graduates with Business, Finance & Accounting backgrounds

Financial Modelling and Forecasting Location, Dates & Fees

Piston and Fusion offer the Financial Modelling and Forecasting Course in Lagos Nigeria. For information on dates and fees for each location click on the calendar/fee tab or chat with us.

LAGOS – FEE: ₦ 69,000
Weekday: N/A
Weekend: 10th Oct – 18th Oct 2020 | 4 Days | Sat & Sun | 10am – 4pm | 12pm – 4pm

Lagos Venue: 122a Obadina Street, Omole Phase 1 Ikeja Lagos

ABUJA – FEE: ₦ 69,000
Weekday: Contact Us
Weekend: Contact Us

Abuja Venue: 27B Limpopo Street, Maitama, Abuja.

Port Harcourt – FEE: ₦ 69,000
Contact Us
Contact Us

PH Venue: Oceanville Estate, 55 King Perekule Street GRA Phase II, PH

People who enrolled for this course, also enrolled for the following courses

Credit Risk Analysis Financial Audit Essentials
Treasury & Fund Management Cost Reduction, Control & Revenue Management

Introduction to Financial Modelling & Advanced Excel Functions

1
What are Financial Models
2
Types of Financial Models
3
What is a financial model used for?
4
Best & Bad Practices in Financial Modelling

Advanced Excel Functions for Building Flexible Financial Models

1
SUM, SUMIF, SUMIFS, VLOOKUP
2
INDEX & MATCH, PMT
3
IF Statement
4
Data Validation & Duplicates

Modelling The Income Statement & Statement of Financial Position

1
Review of Source Data
2
Introduction to Income Statement
3
Building the Income Statement output sheet
4
Populating the Income Statement
5
Introduction to Statement of Financial Position
6
Populating the Statement of Financial Position

Forecast Layouts & Calculations

1
Adding a Forecast Period to the Income Statement
2
Calculating Historical Percentage Ratios Income Statement
3
Building a flexible model with Scenario Manager (VLOOKUP) Income Statement
4
Adding a forecast period for the Statement of Financial Position
5
Forecasting DSO, DPO, DIO, Other Assets & Other Liabilities

Building Forecasting Schedules & Cash Flow Statements

1
Building a Fixed Asset Roll Forward
2
Building the Financial liabilities schedule Sheet
3
Building the equity schedule Sheet
4
Building the cash flow sheet
The weekend course is for 4 weekends; Saturday.
Our training venues are in Lagos, Port Harcourt and Abuja.
There is no prerequisite for taking this course.
What we have available is the classroom training.
The course will cover the following modules;  Introduction to Microsoft Excel  Basic Microsoft Excel Manipulation  Excel Best Practices  Excel Functions and Functionalities  Setting up your financial model template  Calculations Module 1 – Revenue, Expense, Debt schedule, Capital expenditure & Income statement  Calculations Module 2- Balance sheet, Cash flow, Investment appraisal, Ratio analysis & Sensitivities and Scenario testing
The training fee is N99,000.
Yes, you can pay the fees in two instalments.
Yes, you can get a discount, kindly speak with any of our client’s executives.
Some of the benefits of this course includes;  Finance modellers are highly paid professionals  More job opportunities because of less competition  Finance modellers are highly valued thereby creating job security
This course is suitable for;  Working professionals seeking to become skilled in Excel & Financial Modelling  Finance officers & managers  Non-Finance managers that analyse and interpret finance documents  Fresh graduates with Business, Finance & Accounting backgrounds
Professionals within this field can expect to enjoy a progressive and fulfilling career
No, but you will have an assessment after the training.
This course is a skill-based course.
You will be issued a certificate of completion after the training.

Be the first to add a review.

Please, login to leave a review

Partners

Companies we have trained

image

image

image

image

Add to Wishlist
Enrolled: 227 students
Duration: 4 days
Lectures: 23
Level: Intermediate

Archive

Working hours

Monday 9:30 am - 6.00 pm
Tuesday 9:30 am - 6.00 pm
Wednesday 9:30 am - 6.00 pm
Thursday 9:30 am - 6.00 pm
Friday 9:30 am - 5.00 pm
Saturday Closed
Sunday Closed