Nigerian Seminars and Trainings

Search conferences, training, seminars, courses and workshops in Nigeria and around the world

business logo

Business Data Analysis and Modeling with Excel

By: Tom Associates  

State, Nigeria

19 - 22 Sep, 2017  4 days

Follow Event


NGN 136,500

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. Sep 19 - 22 Sep, 2017

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

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

NGN 136,500.00(Including VAT)
(Convert Currency)


Discount of 5% to 3-4 participants from same organization. Discount of 10% to 5 or more participants from same organization.
Related Courses
Internet Security Awarenes Training Internet Security Awarenes Training

5 days, 26 - 30 Nov, 2018 

2018-11-26 12:11:00
Lagos State, Nigeria

Tom Associates

Course Contents DAY ONE Having a security mindset What is Internet Security? What is at risk? Identity theft - people impersonating you Data theft of valuable personal and official data Accounts ...

Management Development for Personal Assistants and Senior Secretaries Management Development for Personal Assistants and Senior Secretaries

5 days, 07 - 11 May, 2018 

2018-05-07 12:05:00
Lagos State, Nigeria

Tom Associates

This course will take the PAs and Senior Secretaries through some thought process that focuses on the style and work culture which characterizes the managers they work with. The jobs of Personal ...

The Five S System The Five S System

2 day, 07 - 08 Jun, 2018 

2018-06-07 12:06:00
Lagos State, Nigeria

Tom Associates

The "Five S" System is a set of universal principles and activities that help to sustain high performance on the production floor and the offices of any company. The gains include: ...

Strategic Managerial Accounting: Cost Behaviors, Systems and Analysis Strategic Managerial Accounting: Cost Behaviors, Systems and Analysis

3 days, 11 - 13 Jun, 2018 

2018-06-11 12:06:00
Lagos State, Nigeria

Tom Associates

This course presents how Strategic Managerial Accounting primarily links the goals of the organization with its analysis of cost accounting as well as its management information systems. But beyond ...