Nigerian Seminars and Trainings

Search conferences, training, seminars, courses and workshops in Nigeria and around the world

business logo

Financial Modeling and Forecasting Techniques Using Advanced Excel Tools

By: Tom Associates Training  

Lagos State, Nigeria

19 - 22 Apr, 2016  4 days

Follow Event

  

NGN 136,500

Modeling techniques that this course teaches are used in investment appraisal, capital planning, budgeting, valuation, financial analysis, and forecasting to make accurate financial and business decisions at the right time. The training course will deliver competencies in the use of Financial Tools designed for Account/Finance, Risk Management and Financial Control.

It is for delegates who already can create moderately complex spreadsheets and want to build models. The course will examine very briefly some foundational and intermediate topics and then progress to advanced functionality such as: Pivot Tables, Vertical Lookup (Vlookup), Goal-seeking and Solver, Cost of Capital, Ratio Analysis, Financial Forecasting, Profit Volume and Break-even Analysis, “What if”, Investment Return Appraisal, Financial Model Design and Constructions,  Project Evaluation and Sensitivity Analysis.

Learning Objectives

After completing this course, participants should be able to perform the following using excel models:

  • Advanced financial performance presentation and analyses
  • Loan management and loans schedules determination
  • Product sales, marketers and distributors performance analyses
  • Profit maximization
  • Product costing and pricing decisions
  • Investment appraisals and capital rationing solutions
  • Cost of capital determination
  • Cash flow planning
  • Business forecasting

Pre-requisite

Participants should already be using Excel on a regular basis.

Course Contents

Day One

  • Data Modeling
  • Formula Auditing Tools
  • Conditional Functions and Data Calculation
  • Worksheet Management and Linking
  • Data Management List.

Day Two

  • Advanced Excel Charts/Graphs
  • Lookup Functions and Application
  • Pivot Table Creation and Manipulation
  • Articulating Profit Volume and Break-even Analysis
  • What If Analysis (Sensitivity Testing)

Day Three

  • Statement of Comprehensive Income (SCI)
  • Revenue Modeling
  • Building Statement of Financial position (SFP)
  • Cash flows modeling
  • Ratio Analysis and Ratio Interpretation from the Model

Day Four

  • Capital Budgeting Techniques (Linear Programming)
  • Cost of Capital
  • Project Evaluation Techniques
  • Business and Financial Forecasting Techniques
  • Introduction to Macro and VBscripting
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. Apr 19 - 22 Apr, 2016
NGN 136,500.00(VAT Inclusive)
(Convert Currency)

08033019120

Discount of 5% to 3-4 participants from same organization. Discount of 10% to 5 or more participants from same organization.
Related Courses
Management Development for Personal Assistants and Senior Secretaries Management Development for Personal Assistants and Senior Secretaries

5 days, 18 - 22 Sep, 2017 

2017-09-18 12:09: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 ...

Office Management Training for Officers and Managers Office Management Training for Officers and Managers

5 days, 25 - 29 Sep, 2017 

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

Tom Associates Training

By the time the training ends, Officers and Managers who participate in it will: Have learned how to work well in ways that maintain and improve efficiency and productivity Be able to successfully ...

How to Create Positive Customer Experience: Service as an Art and a Science How to Create Positive Customer Experience: Service as an Art and a Science

2 day, 21 - 22 Sep, 2017 

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

Tom Associates Training

This training is to make employees psychologically ready, supported with the skills-set to deliver impeccable customer service. After the programme, employees will be able to attend to more service ...

Smarter Presentation and Persuasive Public Speaking Skills Smarter Presentation and Persuasive Public Speaking Skills

3 days, 04 - 06 Oct, 2017 

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

Tom Associates Training

The Smarter Presentation and Persuasive Public Speaking Skills training addresses Sales presentation Proposals presentation Reports presentation. Participants also practice Technical lecture ...