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 Course
On going

By: Tom Associates Training  

Lagos State, Nigeria

26 - 30 Jul, 2021  5 days

Follow Event

  

NGN 180,000

Venue: 5/7 Alade Lawal Street, Opposite Divisional Police Station, Off Ikorodu Road, Anthony, Lagos

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

  • Personal Budget
  • Company Budget
  • Flexible budget model
  • Fixed budget model
  • Budget variance
  • Budgeting and Control Models.

 

DAY THREE

  • Portfolio Analysis
  • Risk and Return Analysis
  • Cost of Capital:

- Capital Asset Pricing Model

- How to determine your company’s Beta.

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

 

DAY FOUR

  • Company Valuation:

- Adjusted Accounting Valuation

- Dividends Valuation

     - Market Valuation

- Free Cash flow Valuation

 

DAY FIVE

  • 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 Jul 26 - 30 Jul, 2021

Registration: 09:00:am - 04:00:am

NGN 180,000.00(Vat Inclusive)
(Convert Currency)

Mr Abiodun Toki 08033019120

3 – 4 participants: 5% discount 5 or more participants: 10% discount

Related Courses

Complete Salesperson Course: The Seven Traits Complete Salesperson Course: The Seven Traits

5 days, 08 - 12 Nov, 2021 

2021-11-08 12:11:00 2021-11-08 12:11:00
Lagos State, Nigeria

Tom Associates Training

The Traits Sales Competence Commercial Knowledge Business Development Capabilities Bidding and Tendering Application of Excel and PowerPoint in Sales Use of Digital Media Presentation Skills. ...

Experienced Auditors Refresher Programme Experienced Auditors Refresher Programme

5 days, 09 - 13 Aug, 2021 

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

Tom Associates Training

In any excellently managed business enterprise, the Board of Directors and Management look up increasingly to internal audit to help them better control the enterprise to keep the business on course ...

Tax Audit and Investigation Training Tax Audit and Investigation Training

3 days, 13 - 15 Oct, 2021 

2021-10-13 12:10:00 2021-10-13 12:10:00
Lagos State, Nigeria

Tom Associates Training

The Objective of Tax Audit and Investigation Training is as below: Course Contents Day One The Tax Authorities in Nigeria Federal State Local Joint Tax Board Differentiating Auditing from ...

Strategic Brand Management Course: Success with Product Management Strategic Brand Management Course: Success with Product Management

4 days, 14 - 17 Sep, 2021 

2021-09-14 12:09:00 2021-09-14 12:09:00
Lagos State, Nigeria

Tom Associates Training

This course Strategic Brand Management Course Success with Product Management delivers five broad competencies: This course delivers five broad competencies: Ability to develop marketing strategy to ...