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 Microsoft Excel
  • Basic Microsoft Excel Manipulation
  • Excel Best PracticesExcel 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

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: 8th – 11th Jun | 4 Days | Mon – Thur || 9am – 5pm
Weekend: 7th – 28th Nov | 4 Days | Sat | 9am – 5pm

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

Financial modelling – Fundamentals

1
• Introduction
2
• Use of financial modelling
3
• Essential components of financial models
4
• Financial performance and interpretations
5
• Profitability ratios
6
• Liquidity ratios
7
• Building models
8
• Gathering data
9
• Making assumptions
10
• Deciding layouts
11
• Projecting the future

Introduction

1
• Financial statement- Explanation of basic components of the
2
• Financial statement:
3
• Statement of financial position
4
• Statement of profit or loss and other comprehensive
5
• Income
6
• Statement of cash flow
7
• Statement of changes in equities
8
• Understanding the story in a financial statement

Financial functions

Interest and time value of money concept

1
• Introduction
2
• Future value concept
3
• Present value concept
4
• Annuity and periodic payments
5
• Present value Vs. Net present value
6
• Compound interest, the time value of money and
7
• Discounted Cash Flow (DCF) Methodologies

Logical Functions

1
• Scenario Manager
2
• Index and Match Function
3
• Nesting Lookup
4
• Writing Functions

Income Statement

Statement of Financial Position and Cash flow modeling

1
• Modeling the cash flow statement
2
• Key linkage to other statements
3
• Presenting the cash flow statement
4
• Forecasting cash flow
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.
No announcements at this moment.

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: 34
Level: Intermediate

Archive

Working hours

Monday9:30 am - 6.00 pm
Tuesday9:30 am - 6.00 pm
Wednesday9:30 am - 6.00 pm
Thursday9:30 am - 6.00 pm
Friday9:30 am - 5.00 pm
SaturdayClosed
SundayClosed