Nigerian Seminars and Trainings

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

business logo

Financial Modeling and Forecasting Techniques with Excel

By: Impact Training and Management Consulting Limited  

Lagos State, Nigeria

15 - 17 Jun, 2016  3 days

Follow Event

  

NGN 87,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 finance management. This course is for people who already can create moderately complex spreadsheets and want to add greater sophistication, automation and build models. 

Learning Objectives:

At the end of this training course, participants will be proficient in:

  • Advanced financial performance presentation and analysis
  • Loan management and loans schedules determination
  • Product sales, marketers and distributors performance analysis
  • 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.

Learning Contents:

  • Data Modeling
  • Formula Auditing Tools
  • Conditional Functions and Date Calculation
  • Business and Financial Forecasting Techniques
  • Building Financial Models
  • Ratio Analysis and Ratio Interpretation from the Model
  • What If Analysis (Sensitivity Testing)
  • Capital Budgeting Techniques (Linear Programming)
  • Cost of Capital
  • Project Evaluation Techniques
  • Present Value (PV)
  • Introduction to Macro and VB scripting

Who Should Attend

People in risk management, financial control, management accounts financial and investment analysis

10, Obokun Street, Off Coker Road, Ilupeju, Lagos, Nigeria Jun 15 - 17 Jun, 2016
NGN 87,500.00
(Convert Currency)

08023060462

Discount off regular fees for open Programme: 3-5 nomination 5% Programme also available as in-plant. Fee: Negotiable.
Related Courses
Basic Accounting Principles and Book Keeping Workshop Basic Accounting Principles and Book Keeping Workshop

3 days, 17 - 19 May, 2017 

2017-05-17 12:05:00
Lagos State, Nigeria

Impact Training and Management Consulting Limited

Every venture per forms accounting function no matter the size of the business. Accounting officers need to understand the basics of accounting and know why and how things are done in particular ...

Performance Management Workshop Performance Management Workshop

2 day, 15 - 16 Jun, 2017 

2017-06-15 12:06:00
Lagos State, Nigeria

Impact Training and Management Consulting Limited

This course covers the techniques and processes for managing employee and team performance. Setting targets and measuring achievement are key to the attainment of performance objectives. This course ...

Human Resources Performance Metrics Human Resources Performance Metrics

, 16 - 16 Jun, 2017 

2017-06-16 12:06:00
Lagos State, Nigeria

Impact Training and Management Consulting Limited

This course provides HR practitioners with the tools to enable them report in quantitative terms the cost effectiveness of HR activities such as recruitment, training and development, compensation. ...

Selling in Tough Times Selling in Tough Times

2 day, 22 - 23 Jun, 2017 

2017-06-22 12:06:00
Lagos State, Nigeria

Impact Training and Management Consulting Limited

This special two-day course is designed to introduce new skills and approaches to provide a stimulus for the more experienced team members, so that they can have something new to try out to improve ...