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

16 - 18 Sep, 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. Sep 16 - 18 Sep, 2015
NGN110,000.00
(Convert Currency)

08033019120

NST PPC Advert
Related Courses
Advancing Performance through Targets Setting and Appraisal Processes: Employee Performance Assurance Training Advancing Performance through Targets Setting and Appraisal Processes: Employee Performance Assurance Training

4 days, 06 - 09 Feb, 2018 

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

Tom Associates Training

By the time the programme ends, participants would become conversant with the procedure of: Determining performance measures at the Corporate, Business Unit and Individual levels. Managing the ...

Building Trust and Inspiring Followers - Small Behaviours that Create Positive Change Building Trust and Inspiring Followers - Small Behaviours that Create Positive Change
On going

3 days, 17 - 19 Jan, 2018 

2018-01-17 12:01:00
Lagos State, Nigeria

Tom Associates Training

This course is relevant mostly when the leadership faces among the followers problems of: change resistance lower morale lack of real effort. Then it's the time the leader must tap into the ...

Stock Management and Control Training Stock Management and Control Training

3 days, 06 - 08 Jun, 2018 

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

Tom Associates Training

This Stock Management and Control Training delivers four broad competencies: Reasons for holding Stock Accurate Stock records Difference between Stock recording and Stock control Security of Stores. ...

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

5 days, 04 - 08 Jun, 2018 

2018-06-04 12:06: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 ...