Nigerian Seminars and Trainings

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

business logo

Virtual Training on Business Data Analysis and Modelling with Excel

By: Tom Associates Training  

Lagos State, Nigeria

02 - 06 Nov, 2020  5 days

Follow Event

  

NGN 140,000

Venue: Online

Programme Description

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

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

Day Three

  • Portfolio Analysis
  • Risk and Return Analysis
  • Cost of Capital:
    • Capital Asset Pricing Model
    • How to determine your company’s Beta.
    • 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.

Day Four

  • Company Valuation:
  • Adjusted Accounting Valuation
  • Dividends Valuation
  • Market Valuation
  • Free Cash flow Valuation

Day Five

  • 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.
Online Nov 02 - 06 Nov, 2020

Registration: 09:00:am - 02:30:am

NGN 140,000.00(VAT Inclusive)
(Convert Currency)

Mr Abiodun Toki 08033019120

Related Courses
Building and Sustaining a Successful Enterprise Course Building and Sustaining a Successful Enterprise Course

4 days, 01 - 04 Dec, 2020 

2020-12-01 12:12:00
Lagos State, Nigeria

Tom Associates Training

This Building and Sustaining a Successful Enterprise training will discuss: Set right strategy Beat powerful competitors Get funding for new growth initiatives Be relentlessly innovative. ...

Crucial Written Communications for Public Service Officers Course Crucial Written Communications for Public Service Officers Course
On going

5 days, 23 - 27 Nov, 2020 

2020-11-23 12:11:00
State, Nigeria

Tom Associates Training

Effective writing in English, the official language, is a powerful tool in the hands of  public service officers. Brilliant officials articulate their thoughts in a clear and concise manner. ...

Advanced Office Management and Administrative Skills Course Advanced Office Management and Administrative Skills Course

5 days, 07 - 11 Dec, 2020 

2020-12-07 12:12:00
Lagos State, Nigeria

Tom Associates Training

To excel as a Senior Office Manager, Administrator or Secretary you need to perfect your interpersonal and behavioural skills, to ensure you stay in control and on top of every one of your ...

A Production Processes Management  Programme: Strategic Warehousing A Production Processes Management Programme: Strategic Warehousing
On going

4 days, 24 - 27 Nov, 2020 

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

Tom Associates Training

This production processes management programme strategic warehousing course will discuss the following: Efficient warehouse operations do the following: Provide timely customer service Keep track ...