Nigerian Seminars and Trainings

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

business logo

Training on Financial Analysis using Excel

By: Data-Afrique Consultancy

Kenya

13 - 24 May, 2019  12 days

Follow Event

  

USD 2,000

This course is suitable for users of excel or other spreadsheet software. The course aims at equipping participants with the analytical skills in the areas of finance, accounting, management, and procurement. The course is intended to enhance the Excel modeling and analytical skills of finance professionals for predicting, analysis, and presentation of business and financial data/information.

Course Objectives

  • Using Excel to create professional charts
  • Understand the principles of accounting and bookkeeping
  • Build the financial statements of an organization
  • Understand the importance of timing in relation to cost and revenue recognition
  • Analyze financial statements
  • Calculate liquidity, solvency, growth ratios, and profitability
  • Assess project feasibility
  • Calculate a loan schedule
  • Differentiate between variable and fixed interest rates
  • Carry out industry analysis
  • Understand company’s value drives
  • Business analysis

Who Should Attend

This course targets financial officers, analysts, and portfolio managers who want to learn about valuation and gain skills relevant in making financial decisions.

Course Outline

  • Financial Modeling
  • Flexibility, accuracy, and User-friendliness
  • Structural standards
  • Circular errors, the #REF! problem and Iteration
  • Factual, rational and Structural checks
  • Proofreading and Model Stress Testing
  • Functions of Financial Modeling
  • Counting and summing functions- SUM; SUMIF; SUMPRODUCT; COUNT; COUNTA; COUNTBLANK; COUNTIF and IF functions- ROUND; ROUNDUP; ROUNDDOWN; CEILING; FLOOR; INT; TRUNC; MOD
  • HLOOKUP; VLOOKUP
  • Discounting on uneven periods: NPV; XNPV; IRP; XIRP
  • Validation of data; Text to column
  • Pivot tables, what if analysis and data tables
  • Scenario and sensitivity analysis
  • Modeling for Financial and Operational Planning
  • Repayment of debt
  • Seniority of debt obligations modeling
  • Book and tax depreciation and modeling deferred tax
  • Liability/asset
  • Asset sales modeling
  • Credit Perspective
  • Capital structure
  • Leverage ratios
  • Interest coverage
  • Working capital
  • Operating results
  • Liquidity ratios
  • Capital Structures Analysis
  • Debt existing
  • Bank Revolver
  • Long-Term Debt
  • Preferred Stock
  • Book Capitalization
  • Total Debt
  • Book Equity
  • Base of Borrowing
  • Debt Revolver
  • Cost of Capital Modeling
  • Valuation Models using Discounted Cash Flow Analysis
  • Firms’ free cash flow
  • Free cash flow to equity
  • Single stage and multi stage models
  • Financial analysis principles using VPN, IRP, PBP and other measures
  • Analysis of discounted cash flow
  • Relative valuation
  • Hybrid of relative evaluation and DCF
  • Reality check on results
  • Modeling for Corporate Finance Transaction
  • Evaluation of Newly Built Financial Model
  • Objectives
  • Hypothesis
  • Logical flow
  • Key inputs
  • Inputs interrelationships
  • Outcome expected
  • Factual, rational, and structural checks

General Notes

  • This course is delivered by our seasoned trainers who have vast experience as expert professionals in the respective fields of practice. The course is taught through a mix of practical activities, theory, group works and case studies.
  • Training manuals and additional reference materials are provided to the participants.
  • Upon successful completion of this course, participants will be issued with a certificate.
DATA-AFRIQUE TRAINING CENTRE, NAIROBI KENYA. May 13 - 24 May, 2019

Registration: 08:30:am - 08:30:am

Class Session: 08:00:am - 04:00:am

USD 2,000.00
(Convert Currency)

DUNCAN KARIUKI +254723360025

DATA-AFRIQUE CONSULTANCY
Related Courses
Training on Monitoring and Evaluating for Human Rights Programmes Training on Monitoring and Evaluating for Human Rights Programmes

12 days, 13 - 24 May, 2019 

2019-05-13 12:05:00
Kenya

Data-Afrique Consultancy

Monitoring and evaluation (MandE) skills are fundamental to the process of designing and implementing programs that impact human beings positively, analyzing and using data, and conducting advocacy ...

Training on Managing Vendor Qualification, Performance, and Contract Compliance Training on Managing Vendor Qualification, Performance, and Contract Compliance

5 days, 20 - 24 May, 2019 

2019-05-20 12:05:00
Kenya

Data-Afrique Consultancy

The success of a company highly depends on its suppliers and vendors. Smooth operations are attributed to the implementation of a formalized system that tracks and evaluates performance of suppliers ...

Training on Senior Management Leadership Program Training on Senior Management Leadership Program

12 days, 18 - 29 Mar, 2019 

2019-03-18 12:03:00
Kenya

Data-Afrique Consultancy

This Training on Senior Management Leadership Program is a dynamic, high profile leadership and management program targeted at top level senior managers and executives of various organizations; ...

Mobile Data Collection for M and E using ODK and Kobo tool box Course   Mobile Data Collection for M and E using ODK and Kobo tool box Course

5 days, 03 - 07 Jun, 2019 

2019-06-03 12:06:00
Kenya

Data-Afrique Consultancy

Data collection and monitoring and evaluation (MandE) have always been an integral part of development work. In the past, these tasks were performed with paper and pen, which made them prone to ...