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 Consultants

Kenya

04 - 15 Nov, 2019  12 days

Follow Event

  

USD 2,000

Venue: Data-Afrique Training Centre, Nairobi, Kenya.

Other Dates

Venue Date Fee  
Data-Afrique Training Centre, Nairobi, Kenya., Kenya 06 - 17 Apr, 2020 USD2000
Data-Afrique Training Centre, Nairobi, Kenya., Kenya 02 - 13 Mar, 2020 USD2000
Data-Afrique Training Centre, Nairobi, Kenya., Kenya 03 - 14 Feb, 2020 USD2000
Data-Afrique Training Centre, Nairobi, Kenya., Kenya 13 - 24 Jan, 2020 USD2000
Data-Afrique Training Centre, Nairobi, Kenya., Kenya 09 - 20 Dec, 2019 USD2000
Data-Afrique Training Centre, Nairobi, Kenya., Kenya 04 - 15 May, 2020 USD2000
Data-Afrique Training Centre, Nairobi, Kenya., Kenya 01 - 12 Jun, 2020 USD2000

This course is suitable for users of excel or another 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 multistage 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.

We can also do this as tailor-made course to meet organization-wide needs

Data-Afrique Training Centre, Nairobi, Kenya. Nov 04 - 15 Nov, 2019
Data-Afrique Training Centre, Nairobi, Kenya., Kenya 06 - 17 Apr, 2020
Data-Afrique Training Centre, Nairobi, Kenya., Kenya 02 - 13 Mar, 2020
Data-Afrique Training Centre, Nairobi, Kenya., Kenya 03 - 14 Feb, 2020
Data-Afrique Training Centre, Nairobi, Kenya., Kenya 13 - 24 Jan, 2020
Data-Afrique Training Centre, Nairobi, Kenya., Kenya 09 - 20 Dec, 2019
Data-Afrique Training Centre, Nairobi, Kenya., Kenya 04 - 15 May, 2020
Data-Afrique Training Centre, Nairobi, Kenya., Kenya 01 - 12 Jun, 2020
USD 2,000.00
(Convert Currency)

DUNCAN KARIUKI +254723360025

DATA-AFRIQUE TRAINING CENTRE, Nairobi Kenya.
NST PPC Advert
Related Courses
Value for Money Audit Training Value for Money Audit Training

5 days, 16 - 20 Dec, 2019 

2019-12-16 12:12:00
Kenya

Data-Afrique Consultants

This training course is designed to assist the auditor in assessing whether an organization operates in a cost conscious, efficient and effective manner, and it will improve the organization’s ...

Training on Iso 9001 Quality Management System (QMS) Training on Iso 9001 Quality Management System (QMS)

5 days, 04 - 08 Nov, 2019 

2019-11-04 12:11:00
Kenya

Data-Afrique Consultants

ISO 9001 is the international standard that specifies requirements for a quality management system (QMS). Organizations use the standard to demonstrate the ability to consistently provide products ...

Training on Payroll Preparation, Analysis and Management Training on Payroll Preparation, Analysis and Management

5 days, 04 - 08 Nov, 2019 

2019-11-04 12:11:00
Kenya

Data-Afrique Consultants

Most companies generally use the term Payroll to refer to the money that is paid to the employees or the records that detail how much each employee has made. Processing payroll is a very important ...

International Training on Monitoring and Evaluation for Development Results International Training on Monitoring and Evaluation for Development Results

12 days, 04 - 15 Nov, 2019 

2019-11-04 12:11:00
Kenya

Data-Afrique Consultants

This course focuses on equipping monitoring and evaluation skills to all who undertake it. Monitoring and evaluation skills are on demand in the current competitive business market. Thus, on ...