f

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

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
New Approach to Documents Control and Records Management New Approach to Documents Control and Records Management

4 days, 26 - 29 Sep, 2017 

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

Tom Associates Training

Document Control and Records Management are a very important part of any management system. Records are needed for identification and evidence of transactions for government and private businesses. ...

Advanced Office Management and Administrative Skills Advanced Office Management and Administrative Skills

5 days, 04 - 08 Sep, 2017 

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

Tom Associates Training

To excel as a Senior Office Manager, Administrator or Secretary you need to perfect your interpersonal and behavioural skills, to ensure you stay in control and on top of every one of your ...

Mastering Competitive Positioning, Blue Ocean Strategy and Value Chain Management Mastering Competitive Positioning, Blue Ocean Strategy and Value Chain Management

3 days, 02 - 04 Aug, 2017 

2017-08-02 12:08:00
Lagos State, Nigeria

Tom Associates Training

How does the management find a unique positioning, the “place” the organization should be in the industry? That is discovering a good strategy. In your arena of tough business rivalry, ...

Anti-Money Laundering and Countering Terrorism Financing (AML/CTF) Anti-Money Laundering and Countering Terrorism Financing (AML/CTF)

2 day, 04 - 05 Dec, 2017 

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

Tom Associates Training

This Anti-Money Laundering and Countering Terrorism Financing (AML/CTF) training courses will treat the following: Day One Basic AML/ CFT Concept and Regulatory Responses Understanding Anti-Money ...