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

14 - 16 Mar, 2016  3 days

Follow Event

  

NGN 98,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 Mar 14 - 16 Mar, 2016
NGN 98,500.00
(Convert Currency)

08023060462

Related Courses
Inventory Management and Stock Control Course Inventory Management and Stock Control Course

3 days, 19 - 21 Feb, 2018 

2018-02-19 12:02:00
Lagos State, Nigeria

Impact Training and Management Consulting Limited

The effective management of warehouse operations and inventory control are critical to the supply chain of organisations. The ability to maintain a smooth, constant and efficient flow of products and ...

 Effective Project Management Workshop Effective Project Management Workshop

3 days, 14 - 16 Feb, 2018 

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

Impact Training and Management Consulting Limited

The planning and co-ordination of a project, regardless of the size of the project or the organization requires a specific set of competencies in managing time, money, people, and materials. Project ...

Commercial Debt Recovery and Credit Control Commercial Debt Recovery and Credit Control

2 day, 22 - 23 Feb, 2018 

2018-02-22 12:02:00
State, Nigeria

Impact Training and Management Consulting Limited

This course is designed to help you understand the credit management methodology and tackle the issues related to late payment by laying out the options available to you. Through expert facilitation, ...

Business Writing and Communication Skills Business Writing and Communication Skills

3 days, 14 - 16 Feb, 2018 

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

Impact Training and Management Consulting Limited

Modern supervisors and managers write reports frequently. This training course will take participants through a step by step process of planning and writing a report to ensure easy understanding by ...