Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Business Data Analysis and Modeling with Excel Course

By: Tom Associates Training  

Lagos State, Nigeria

17 - 21 Feb, 2020  5 days

Follow Event

  

NGN 180,000

Venue: 5/7 Alade Lawal Street, Opposite Divisional Police Station, Off Ikorodu Road, Anthony, Lagos.

Other Dates

Venue Date Fee  
5/7 Alade Lawal Street, Opposite Divisional Police Station, Off Ikorodu Road, Anthony, Lagos, Lagos State, Nigeria 18 - 22 May, 2020 NGN180000
5/7 Alade Lawal Street, Opposite Divisional Police Station, Off Ikorodu Road, Anthony, Lago, Lagos State, Nigeria 21 - 25 Sep, 2020 NGN180000

This program will make participants with little or no knowledge in modeling understand how to build a working data analysis model in excel. They will be equipped with advanced excel functions vital in modeling financial and business data. The will also be equipped with Excel Macro in visual basic to handle repetitive tasks.

This programme will enable participants:

  • Be able to Model and Forecast Financial Reports
  • Be able to Reference and Linking Business data in models
  • Build cash   and flexible budget models
  • Able to use various breakeven techniques
  • Know how to value businesses
  • Make optimal decision regarding investment.

Course Contents

Day One

  • Business Performance Analysis
  • Cash flow Forecast Models
  • Excel Referencing and application
  • Linking and worksheet Consolidation
  • Forecasting Models
    • Historical Forecast (Point Forecast)
    • Trend Lines (Interval Forecast)
    • Cyclicality and Seasonality
  • Forecasting Financial Reports;
    • Key Drivers
    • Driving Financial Statements
    • Alternative Approaches
  • Variance Analysis
  • Breakeven Analysis
    • Breakeven
    • Operating Leverage
    • Financial Leverage

Day Two

  • Budget variance
  • Budgeting and Control
  • Example of Personal Budget
  • Example of Company Budget
  • Flexible budget model
  • Fixed budget model.

Day Three

  • Portfolio Analysis
  • Cost of Capital
    • Capital Asset Pricing Model
    • Dividend Growth Model
    • Cost of Preference Share
    • Cost of Debt
    • Weighted Average Cost of Capital (WACC)
    • Marginal WACC
  • Investment Analysis
    • Payback Period
    • Accounting Rate of Returns
    • Internal Rate of Return
    • Net Present Value
    • Loan Management and Loan Determination Schedule
    • Benefit/Cost Ratio
    • Capital Rationing
    • Scenarios and Sensitivity Analysis and Charts
  • Risk and Return Analysis

Day Four

  • Company Valuation
    • Adjusted Accounting Valuation
    • Dividends Valuation
    • Market Valuation
    • Free Cash flow Valuation
  • Portfolio Analysis
  • Optimization
    • Elements of Optimization Models
    • Linear Programming
    • Margin Maximization
    • Bayes’  Theorem
    • Decision Tree Model
    • Building Sensitivity analysis and Scenarios into Models
    • Introduction and Application of Macro to enhance your Model.
5/7 Alade Lawal Street, Opposite Divisional Police Station, Off Ikorodu Road, Anthony, Lagos. Feb 17 - 21 Feb, 2020
5/7 Alade Lawal Street, Opposite Divisional Police Station, Off Ikorodu Road, Anthony, Lagos, Lagos State, Nigeria 18 - 22 May, 2020
5/7 Alade Lawal Street, Opposite Divisional Police Station, Off Ikorodu Road, Anthony, Lago, Lagos State, Nigeria 21 - 25 Sep, 2020

Registration: 08:30:am - 09:00:am

Class Session: 09:00:am - 04:00:am

NGN 180,000.00(Vat Inclusive)
(Convert Currency)

Mr Abiodun Toki 08033019120

3 – 4 participants: 5% discount 5 or more participants: 10% discount
NST PPC Advert
Related Courses
Pre-Retirement Course: Preparing to Manage a New Beginning Pre-Retirement Course: Preparing to Manage a New Beginning

5 days, 09 - 13 Mar, 2020 

2020-03-09 12:03:00
Lagos State, Nigeria

Tom Associates Training

The pre-retirement course: managing a new beginning training is a programme on how all employees sure to approach retirement shortly or in a few years’ time must plan how they will ...

Customer Experience Management Course Customer Experience Management Course

3 days, 24 - 26 Feb, 2020 

2020-02-24 12:02:00
Lagos State, Nigeria

Tom Associates Training

Customers, truly, provide the sources of the lifeblood for any business. But truly also, not all customers of any business are created equal. Some require more attention than others. By gaining ...

Intermediate Excel for Financial and Business Analysis Course Intermediate Excel for Financial and Business Analysis Course

4 days, 17 - 20 Mar, 2020 

2020-03-17 12:03:00
Lagos State, Nigeria

Tom Associates Training

This intermediate course is to make participants understand some critical functions and their usages in MS Excel. It starts with Data Manipulations, and goes on to Formatting and Displaying ...

Mastering Digital and Social Media Marketing Course Mastering Digital and Social Media Marketing Course

5 days, 03 - 07 Feb, 2020 

2020-02-03 12:02:00
Lagos State, Nigeria

Tom Associates Training

The Mastering Digital and Social Media Marketing training courses will discuss the following: The Digital Marketing Platform What really is digital marketing? Digital marketing vs Traditional ...