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 Training  

Lagos State, Nigeria

18 - 20 Feb, 2015  3 days

Follow Event

  

Participants will learn:

DAY ONE

  • Business Performance Analysis
  • Cash flow Forecast Models
  • Budgeting and Control
  • 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

  • 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 THREE

  • Company Valuation
  • Adjusted Accounting Valuation
  • Dividends Valuation
  • Market Valuation
  • Free Cash flow Valuation(FCFE, FCFF)
  • Portfolio Analysis
  • Optimization
  • Elements of Optimization Models
  • Linear Programming
  • Margin Maximization
  • Optimization
  • Element of Optimization Models
  • Linear Programming
  • Margin Maximization
  • Decision Tree
  • Bayes’ Theorem
  • Decision Tree Model
  • Building Sensitivity  analysis and Scenarios into Models
  • Introduction and Application of Macro to enhance your Model
  • Strategy Session: Application of Policy Analysis and Formulation
5/7 Alade Lawal Street, Opposite Divisional Police Station, Off Ikorodu Road, Anthony, Lagos. Registration: 8.30 - 9.00 a.m. Class Session: 9.00 - 4.00 p.m. Feb 18 - 20 Feb, 2015
NGN110,000.00
(Convert Currency)

08033019120

Related Courses
Mastering Competitive Positioning, Blue Ocean Strategy and Value Chain Management Mastering Competitive Positioning, Blue Ocean Strategy and Value Chain Management

3 days, 02 - 04 Aug, 2017 

2017-08-02 12:08:00
Lagos State, Nigeria

Tom Associates Training

How does the management find a unique positioning, the “place” the organization should be in the industry? That is discovering a good strategy. In your arena of tough business rivalry, ...

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

5 days, 11 - 15 Dec, 2017 

2017-12-11 12:12:00
Lagos State, Nigeria

Tom Associates Training

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 ...

How to Find and Win New Business:Opening Doors and Converting Opportunities How to Find and Win New Business:Opening Doors and Converting Opportunities

3 days, 03 - 05 May, 2017 

2017-05-03 12:05:00
Lagos State, Nigeria

Tom Associates Training

The Focus of the How to Find and Win New Business: Opening Doors and Converting Opportunities training course are: How to plan prospecting for new customers How to position the organization and ...

Facility Maintenance and Management Training Facility Maintenance and Management Training

3 days, 20 - 22 Sep, 2017 

2017-09-20 12:09:00
Lagos State, Nigeria

Tom Associates Training

This is a programme for Facility Managers and Office Managers who support the Facility Managers. It is to give them the know-how to effectively manage the physical assets. The programme will make all ...