Nigerian Seminars and Trainings

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

business logo

Financial Analysis Using Excel Course

By: Uphilos Consultancy

Kenya

11 - 15 Nov, 2019  5 days

Follow Event

  

USD 1,000

Venue: Nairobi, Kenya

Other Dates

Venue Date Fee  
Nairobi, Kenya, Kenya 09 - 13 Dec, 2019 USD1000

This training is best suited for existing owners of Excel or maybe similar spreadsheet programs needing to vastly improve their modeling and analytical skills particularly in the disciplinary aspects of Finance, Management, Accounting, Procurement, and Management. It's created for improving the Excel modeling and analytical abilities of financial experts because of the forecast, presentation, and analysis of business and economic info

Who Can Attend?

This certification system is perfect for portfolio managers, financial officers, and analysts looking for a much deeper understanding of Valuation, as well as the abilities and expertise to confidently make financial decisions.

Program Objective:

  • producing expert charts in Microsoft Excel
  • working with a lot of information
  • Understanding Accounting as well as Bookkeeping concepts
  • Building a business's financial statements
  • Performing Financial Statement Analysis
  • Understanding benefits of timing in terms of revenue and cost recognition
  • Calculating Liquidity, Profitability, Solvency, in addition to Growth ratios
  • assessing project feasibility
  • calculating a total loan schedule
  • Understanding the big difference between fixed and variable interest rates
  • Performing industry analysis
  • Understanding moves a company’s worth
  • analyzing a business

Program content

  • Financial Modeling
  • Accuracy, user friendliness, and flexibility​
  • Structural standards
  • Factual inspections, Rational inspections, Structural checks,
  • Model-Stress Testing, Proofreading

Financial modeling Functions

  • Different methods of summing and counting: SUM; SUM IF;
  • SUM PRODUCT; COUNT; COUNT; COUNT BLANK; COUNTIFY as well as If functions
  • ROUND; ROUNDUP; ROUND DOWN; CEILING; FLOOR; INT;
  • TRUNC; MOD
  • Discounting on irregular periods: NPV; XNPV; IRR; XIRR
  • Data validation; Text to column
  • HLOOKUP; VLOOKUP
  • Pivot tables, let's say evaluation as well as data tables
  • Sensitivity plus scenario analysis

Modeling for operational and financial planning

  • A functioning capital management model
  • A capital budgeting model
  • An accounting policy model

 

Additional Analysis to come down with Financial Modeling

  • Debt repayment
  • Modeling primarily based on seniority of debt obligations
  • Book Depreciation and Modeling, tax Depreciation deferred tax
  • asset/liability
  • Modeling Asset Sales

Credit Perspective

  • Capital Structure
  • Interest Coverage
  • Leverage Ratios
  • Liquidity Ratios
  • Operating Results
  • Working Capital

Capital Structure Analysis

  • Existing Debt
  • Bank Revolver
  • Book Capitalization
  • Book Equity
  • Long-Term Debt
  • Preferred Stock
  • Total Debt
  • Borrowing Base
  • Revolver Debt
  • Cost of Capital Modelling

Valuation models applying Discounted-Cash-flow Analysis

  • Free Cash Flow to Firm
  • Free CF to Equity
  • Principles of fiscal analysis using other, PBP, IRR, and NPV measures
  • Discounted Cash Flow Analysis
  • A mixture of relative valuation and DCF
  • Conducting correct check on the results
  • Single phase along with multi-stage models
  • Relative Valuation

Evaluation of Newly ​made financial model

  • Objectives
  • Assumptions
  • Key inputs
  • Interrelationships among inputs
  • Expected output
  • Logical flow
Nairobi, Kenya Nov 11 - 15 Nov, 2019
Nairobi, Kenya, Kenya 09 - 13 Dec, 2019
USD 1,000.00
(Convert Currency)

Jennifer +254706345988

NST PPC Advert
Related Courses
Training on Corporate Governance, Business Ethics and Corporate Social Responsibility Training on Corporate Governance, Business Ethics and Corporate Social Responsibility

5 days, 04 - 08 Nov, 2019 

2019-11-04 12:11:00
Kenya

Uphilos Consultancy

The program aims to create a comprehension of the underlying concepts of Corporate Governance, CSR and business ethics that apply to the contemporary business atmosphere. It's created to nurture ...

Food Security Policies Formulation and Implementation Course Food Security Policies Formulation and Implementation Course

5 days, 18 - 22 Nov, 2019 

2019-11-18 12:11:00
Kenya

Uphilos Consultancy

Food security regulations are created to ensure the enhancement of food availability where almost all the citizens have access to food, and the food systems have a positive impact on their lives. The ...

Training on Climate Change and Human Health Training on Climate Change and Human Health

5 days, 18 - 22 Nov, 2019 

2019-11-18 12:11:00
Kenya

Uphilos Consultancy

Climate modification is an emerging risk to global public health. The consequences of rising temperatures and much more extreme heat waves and floods are included by direct impacts resulting. Warmer ...

Training on Advanced Excel Formulas and Functions Training on Advanced Excel Formulas and Functions

, 04 - 04 Nov, 2019 

2019-11-04 12:11:00
Kenya

Uphilos Consultancy

The program focuses on those elements which are crucial in the daily operations of a business. Intermediate customers will also benefit from this program as it handles the in-depth subjects of ...