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
Payroll Management, Compensation and Benefits Administration Payroll Management, Compensation and Benefits Administration

3 days, 20 - 22 Sep, 2017 

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

Tom Associates Training

This is a course suitable for individuals administering the payroll function 'In-house' or managing providers of payroll services when outsourced. It is significant that every organization, ...

Workforce Harmony and Excellent Collaboration Workforce Harmony and Excellent Collaboration

3 days, 27 - 29 Nov, 2017 

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

Tom Associates Training

This programme is developed around Seven Key Collaboration Lessons for a harmonious workplace, namely: Avoid unreasonable or arbitrary positions Avoid letting prejudices show through Avoid ...

Improved English Communications: Report and Proposal Writing and Excellent Communication Improved English Communications: Report and Proposal Writing and Excellent Communication

3 days, 26 - 28 Oct, 2017 

2017-10-26 12:10:00
Lagos State, Nigeria

Tom Associates Training

For effectiveness in business communications, this course focuses on making managers to: Become highly skilled in the use of English Language Write memos, letters, reports, proposals excellently by ...

Dynamics of Hospitality Management Dynamics of Hospitality Management

3 days, 11 - 13 Jul, 2017 

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

Tom Associates Training

The programme focuses on the organisation’s employees attaining: Excellent responsiveness in serving customers Good service ethics Creativity that can lead to new service advancements ...