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  

Lagos State, Nigeria

21 - 24 Apr, 2015  4 days

Follow Event

  

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 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 add greater sophistication, automation and 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 & 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 maximisation
  • 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.

 

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 21 - 24 Apr, 2015
NGN130,000.00
(Convert Currency)

08033019120

NST PPC Advert
Related Courses
Intenal Audit Course Intenal Audit Course

4 days, 08 - 11 May, 2018 

2018-05-08 12:05:00
Lagos State, Nigeria

Tom Associates

Course Contents DAY ONE Review and Appraisal of Operations  Compliance with policies, plans and procedures Safeguard of assets Detection and prevention of frauds Economical and efficient use of ...

Root Cause Analysis Training: Diagnosing Underlying Causes of Problems and Undesired Events Root Cause Analysis Training: Diagnosing Underlying Causes of Problems and Undesired Events

2 day, 24 - 25 May, 2018 

2018-05-24 12:05:00
Lagos State, Nigeria

Tom Associates

Delegates will become very competent in Seven major things: Understand and implement the “Root Cause Analysis methodology" Practically employ the basic techniques associated with Root ...

Debt Recovery and Credit Management Debt Recovery and Credit Management

3 days, 18 - 20 Jul, 2018 

2018-07-18 12:07:00
Lagos State, Nigeria

Tom Associates

For many businesses, particularly small and medium enterprises, credit sales can be inevitable first, for survival and second, for growth. Yet, they do experience difficulties in collecting debts ...

Powerful Leadership Communication and Influence Management Powerful Leadership Communication and Influence Management

5 days, 13 - 17 Aug, 2018 

2018-08-13 12:08:00
State, Nigeria

Tom Associates

Powerful communication is the key to effective leadership. This is a five-day practical ways for workplace communication in a variety of ways that senior officials should master if they plan to ...