25th – 27th 2013 – Advanced Financial Analysis and Business Modeling Using Microsoft Excel
SIGNALHOUSE Consulting
DATE: November 25th – 27th , 2013
Advanced Financial Analysis and Business Modeling Using Microsoft Excel
Venue: SIGNALHOUSE Learning Center – 61 Kudirat Abiola Way Oregun, Ikeja Lagos. Near IRORUN Plaza.
Objectives
At the end of this course, Participants should be able to
■ Use various IT productivity tools for financial modeling
■ Effectively use MS Excel tools and utilities such as PivotTables, Goal-Seek, Scenario Manager, LookUps, etc in their daily financial and accounting functions
■ Apply Excel tools to build financial models
■ Develop skills in using Macros to record their work
Course Contents
Module 1
■ Fiancial Ananlysis in a Tool box
■ Application of computers in financial analysis functions
■ Basics of spreadsheet applications
Module 2 – 3
■ Overview of electronic spreadsheet
■ Excel workbook environment
■ Proficiency skills: Filling the knowledge GAP
■ Formula construction and multiple worksheets
■ Tables and graphs
■ Data referencing and Analysis – Sorting, Filtering, Advanced Filtering techniques, Creating input formats, etc
■ Pivot Tables and Goal-seek functions
■ Scenarios and What-IF analysis
■ Recording your work with excel MACRO recorder
Module 4
Hands-on Application In:
■ Cash flow statement models
■ Budget preparation and Analysis models
■ Monthly/Quarterly financial regulatory reporting models in financial institutions
■ Business forecasting models/ ratios models.
Audience
This course is designed for Accountants , controllers, finance personnel, admin officers, auditors, investment analysts, training officers etc
Registration/ Fees
The fee is N63,000 per participant. This fee covers tuition, course folios, materials, tea/coffee break, lunch and computer rentals. Participants may also come with their laptops. Please make all nominations in favour of SIGNALHOUSE Consulting Limited, intending participants may also register and pay at the venue.
To register Please call: SIGNALHOUSE Consulting Limited 61, kudirat Abiola Way Orgeun, Ikeja Lagos Tel: 0817-300-8104, 0803-300-8104, 0708-829-4312
Workshop Facilitators
Your course leaders comprises of experience Chartered Accountants and consultants. They include: Greg U. Ezeilo, FCA, CISA; Niyi Ogunkunle, B.Sc ACA; Tom Satimehin, ACA, CISA
November 27th – 29th 2013 – PROCUREMENT: Improving the Negotiation and Buying Skills of Procurement Officers
THE INSTITUTE OF CHARTERED ACCOUNTANTS OF NIGERIA
THE LAGOS MAINLAND DISTRICT SOCIETY
DATE: November 27th – 29th , 2013
PROCUREMENT:
Improving the Negotiation and Buying Skills of Procurement Officers
Venue: SIGNALHOUSE Learning Center – 61 Kudirat Abiola Way Oregun, Ikeja Lagos. Near IRORUN Plaza.
Objectives
At the end of this workshop, Participants should be able to
■ Understand today’s procurement strategies
■ Discover the criteria for successful supplier selection
■ Benefit from e-procurement strategies and other purchasing tools
■ Learn negotiation techniques for a global purchasing environment
■ Understand legal and ethical requirements and issues
■ Discover the potential of outsourcing
■ Manage your suppliers to reduce costs and improve quality
Course Highlights
Track – one: Bargaining Gambits: Making the deal
■ Elements of negotiation
■ Possible outcomes in negotiation
■ Negotiation attitudes: Planning for a successful negotiation
■ Factors impacting on negotiation
■ Bargaining techniques: 10 rules of thumb
■ Minimizing your procurement costs.
Track – Two: The Role and Value of Contracts
■ Business objectives/expectations of stakeholders in procurement and negotiation of contracts
■ Measuring the quality of contracts
■ Understanding the contract’s and Tendering process: Pre-bid activities
■ Soliciting and evaluating bids from suppliers
Track – Three: Performance Management & Legal Obligations
■ The buyer’s role in managing supply and core processes
■ The purchasing cycle and its relationship to the supply chain
■ Key criteria for measuring a buyer’s performance
■ Managing the supplier base and relationships
■ Making effective procurement decisions: applying price, cost and value
■ Tools for enhancing material and product flow
■ Specialized purchase instruments, contracting methods and electronic purchasing
■ Professional practices : ethics in purchasing … Contract law
Who should attend ?
This seminar has been specifically designed to address the needs of managers in all disciplines who are involved in negotiating or managing commercial contracts. This includes : Purchasing and Procurement Officers, Executives responsible for supplying goods and services , commercial Executives and Managers, Project and Contract Managers, Key Personnel involved in facilities Management, company secretaries and officers.
Registration/ Fees
The workshop fee is N60,000 per participant. This fee covers tuition, materials, tea/coffee/snacks, and lunch only. Please make all nominations in favour of ICAN Lagos Mainland District Society and send to any of the addresses indicated below. Intending participants may also register and pay at the venue.
All enquiries should be directed to the:
Course Director / Liaison Officer: ICAN, Lagos Mainland District Society, 259, Borno Way Yaba. Tel:0803-300-8104, 070-8829-4312, 01-850-9123
Course Leaders
Your course leaders include experienced legal experts and consultants. Messers. Luke Aniago B.Sc, LLB, BL and Greg U. Ezeilo, B.Sc, M.Sc, FCA, CISA will lead the faculty.
November 27th – 29th 2013 – ASSET MANAGEMENT & ACCOUNTING
THE INSTITUTE OF CHARTERED ACCOUNTANTS OF NIGERIA
THE LAGOS MAINLAND DISTRICT SOCIETY
DATE: November 27th – 29th , 2013
ASSET MANAGEMENT & ACCOUNTING
Venue: SIGNALHOUSE Learning Center – 61 Kudirat Abiola Way Oregun, Ikeja Lagos. Near IRORUN Plaza.
Objectives
At the end of this workshop, Participants should be able to
■ Identify various Fixed Asset items in their establishments documents and record their Fixed Asset items using accounting books
■ Use Microsoft Excel to model Fixed Asset Register
■ Acquire knowledge of related Asset Management Software such as Oracle, SAP, etc
■ Generate Fixed Asset Reports in the desired formats
Course Contents
Module 1
Overview of Asset Management and Accounting
■ Meaning and Nature of Fixed Asset
■ Asset Cost Accumulation in Manufacturing, Engineering and Contract Deliveries
■ Asset Value Appraisals
■ Asset Tracking and Recording
■ Asset Disposals and Inter-company items
■ Capital allowances and tax offsets
■ Internal controls over fixed assets
■ Audit of fixed assets: Verification and the challenge of establishing titles.
Module 2
Overview of Microsoft Excel Spreadsheet
■ Excel spreadsheet applications: An overview
■ Excel workbook environment
■ Working with ranges , functions and formatting
■ Formula construction and multiple worksheets
■ Data referencing and analysis – sorting, filtering and 3-D referencing
■ Scenarios and What-IF Analysis
Module 3
Hands-on Application In:
■ Modelling fixed asset register using excel
■ Overview of fixed asset software:Oracle/SAP
■ Construcuting fixed asset depreciation tables using excel
Audience
This course is designed for Accountants , controllers, amangers of fixed assets, divisional plant managers and all executives with two years or less of experience in fixed asset accounting etc
Registration/ Fees
The workshop fee is N60,000 per participant. This fee covers tuition, materials, tea/coffee/snacks, and lunch only. Please make all nominations in favour of ICAN Lagos Mainland District Society and send to any of the addresses indicated below. Intending participants may also register and pay at the venue.
All enquiries should be directed to the:
Course Director / Liaison Officer: ICAN, Lagos Mainland District Society, 259, Borno Way Yaba. Tel:0803-300-8104, 070-8829-4312, 01-850-9123
Workshop Facilitators
Your course leaders comprised of experience Chartered Accountants and consultants. They include: Greg U. Ezeilo, FCA; Babtunde Pearce, FCA; Donatus Ogbonnaya, MBA, ACA
December 3rd – 5th 2013 – PENSIONS: Administration, Accounting and Financial Reporting
THE INSTITUTE OF CHARTERED ACCOUNTANTS OF NIGERIA
THE LAGOS MAINLAND DISTRICT SOCIETY
DATE: December 3rd – 5th , 2013
PENSIONS:
Administration, Accounting and Financial Reporting
Venue: SIGNALHOUSE Learning Center – 61 Kudirat Abiola Way Oregun, Ikeja Lagos. Near IRORUN Plaza.
Objectives
At the end of this workshop, Participants should be able to
■ Appreciate the nature and purpose of retirement benefit plans
■ Develop pension schemes and operational guidelines as contained in the Pensions Act 2004
■ Appreciate the roles of Employers and Employee’s and other related stakeholders such as the Pensions Custodians, and the PENCOM entity under the new law
■ Appraise investment opportunities open to pension fund entities to maximize stakeholders interest
■ Develop skills in accounting and financial reporting of pension funds activities in line with the Nigerian Accounting Standards Provisions and disclosure requirements.
Course Highlights
■ Nature and Purpose of Retirement Benefit Plans
■ Legal and Regulatory Framework of Pension Schemes
■ Pension Schemes: Structural Framework and Guidelines
■ Effective Management of Public Sector Plans: Remittances and Disbursements Issues
■ Funding Considerations of Governments Schemes: Dealing with lapses in pensions fund remittance to funds managers and Transfers to Other Schemes
■ Developing and Implementing a Successful Pension Scheme: A Case Study
■ Employee Ownership Plans as a Tool for Business Growth
■ Employer’s and Employee’s Accounting for Pension
■ Reporting and notes Disclosures of Pension Activities. NASB’s Statement of Accounting Standards No 8 in perspective
■ Auditing and Financial
Audience
This course is designed for Pension Managers, Investment Managers, Accountants , Auditors etc
Registration/ Fees
The workshop fee is N60,000 per participant. This fee covers tuition, materials, tea/coffee/snacks, and lunch only. Please make all nominations in favour of ICAN Lagos Mainland District Society and send to any of the addresses indicated below. Intending participants may also register and pay at the venue.
All enquiries should be directed to the:
Course Director / Liaison Officer: ICAN, Lagos Mainland District Society, 259, Borno Way Yaba. Tel:0803-300-8104, 070-8829-4312, 01-850-9123
Workshop Facilitators
Your course leaders comprises of experience Chartered Accountants and consultants. They include: Greg U. Ezeilo, FCA; Babtunde Pearce, FCA
ICAN TCI
ICAN
ICAN TCI
ICAN Technology Competence Initiative (TCI) is a program of the Institute of Chartered Accountants of Nigeria aimed at making Chartered Accountants technologically compliant.
Its objective is to promote computer literacy consistent with Information and Communication adoptions in organization for Chartered Accountants.
TCI is a prerequisite for the induction of new members as stipulated by ICAN.
CRISC
CRISC
CRISC – Certified in Risk and Informations Control
Certified in Risk and Information Systems Control (CRISC) is a certification for information technology professionals with experience in managing IT risks, awarded by ISACA. To gain this certification, candidates must pass a written examination and have at least eight years of information technology or business experience, with a minimum of three years work experience in at least three CRISC domains.
The intent of the certification is to provide a common body of knowledge for information technology/systems risk management, and to recognize the knowledge of enterprise and IT risk that a wide range of IT and Business practitioners have acquired, as well as the capability to: design, implement and maintain information system (IS) controls, to mitigate IS/IT risks.
The CRISC requires demonstrated knowledge in five functional areas or ‘domains’ of IT risk management:
- Risk identification, assessment and evaluation
- Risk response
- Risk monitoring
- Information systems control, design and implementation
- IS control, monitoring and maintenance