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

By: Tom Associates  

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

Related Courses
Selling In a Difficult Environment Selling In a Difficult Environment

2 day, 09 - 10 Aug, 2018 

2018-08-09 12:08:00
Lagos State, Nigeria

Tom Associates

This Selling in a Difficult Environment course will discuss the following How the salespersons’ mental agility can increase so as to perform at the very best How to bring high energy to bear ...

Effective Management of Time, Priority and Work Pressure Course Effective Management of Time, Priority and Work Pressure Course

3 days, 20 - 22 Jun, 2018 

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

Tom Associates

Managers and executives must consistently add more value, in the limited time they have in hand, just to remain in contention today. To achieve more than the ordinary, managers must have the special ...

Excellent Operations Management: Value Improvement in Manufacturing and Service Operations Excellent Operations Management: Value Improvement in Manufacturing and Service Operations

4 days, 14 - 17 Aug, 2018 

2018-08-14 12:08:00
Lagos State, Nigeria

Tom Associates

Be it in manufacturing, services, social or non-government organization, operations management strategies are the bedrock for continuity and profitability. It deals with the management of the direct ...

Excellent English for Public Service Officers Excellent English for Public Service Officers

5 days, 25 - 29 Jun, 2018 

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

Tom Associates

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