Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Financial Modeling and Forecasting Techniques using Advanced Excel Tools

By: Tom Associates  

Lagos State, Nigeria

13 - 16 Oct, 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. Oct 13 - 16 Oct, 2015
NGN130,000.00
(Convert Currency)

08033019120

Related Courses
Preventive Maintenance Course Preventive Maintenance Course

3 days, 03 - 05 Dec, 2018 

2018-12-03 12:12:00
Lagos State, Nigeria

Tom Associates

Preventive maintenance takes proactive and organized actions to ensure that the plant will continue to function optimally to effect the achievement of planned results as per production schedule and ...

Excellent English for Public Service Officers Excellent English for Public Service Officers

5 days, 25 - 29 Jun, 2018 

2018-06-25 12:06:00
Lagos State, Nigeria

Tom Associates

Effective writing in English, the official language, is a powerful tool in the hands of public service officers. Brilliant officials articulate their thoughts in a clear and concise manner. They ...

Quality Proposal and Report Writing and Crucial Communications Course Quality Proposal and Report Writing and Crucial Communications Course

3 days, 04 - 06 Jul, 2018 

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

Tom Associates

For effectiveness in business communications, this course focuses on making managers to: Become highly skilled in the use of English Language Write memos, letters, reports, proposals excellently by ...

Business Acumen Master Class: Transformative Learning of How the Business Makes Money Business Acumen Master Class: Transformative Learning of How the Business Makes Money

3 days, 25 - 27 Jul, 2018 

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

Tom Associates

Business Acumen is all about seeing the big picture and recognizing that all decisions no matter how small can have an effect on the bottom line. Therefore the focus of this course is to prepare ...