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 Training & Consultancy

Kenya

08 - 12 Jul, 2019  5 days

Follow Event

  

USD 1,000

Venue: Nairobi, Kenya

Other Dates

Venue Date Fee  
Nairobi, Kenya, Kenya 09 - 13 Dec, 2019
Nairobi, Kenya, Kenya 11 - 15 Nov, 2019
Nairobi, Kenya, Kenya 07 - 11 Oct, 2019
Nairobi, Kenya, Kenya 09 - 13 Sep, 2019
Nairobi, Kenya, Kenya 12 - 16 Aug, 2019

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 Jul 08 - 12 Jul, 2019
Nairobi, Kenya, Kenya 09 - 13 Dec, 2019
Nairobi, Kenya, Kenya 11 - 15 Nov, 2019
Nairobi, Kenya, Kenya 07 - 11 Oct, 2019
Nairobi, Kenya, Kenya 09 - 13 Sep, 2019
Nairobi, Kenya, Kenya 12 - 16 Aug, 2019
USD 1,000.00
(Convert Currency)

Jennifer +254706345988

NST PPC Advert
Related Courses
Training on Advanced Excel Formulas and Functions Training on Advanced Excel Formulas and Functions
On going

5 days, 22 - 26 Jul, 2019 

2019-07-22 12:07:00
Kenya

Uphilos Training & 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 ...

Food Security and Climate Resilience Food Security and Climate Resilience
On going

5 days, 22 - 26 Jul, 2019 

2019-07-22 12:07:00
Kenya

Uphilos Training & Consultancy

This course is an essential component for food as well as nutrition security. The course is also in line with the very first millennium objective on eradication of severe poverty and hunger. ...

Remote Sensing and GIS in Climate Change, Food Security and Agriculture Training Remote Sensing and GIS in Climate Change, Food Security and Agriculture Training
On going

5 days, 22 - 26 Jul, 2019 

2019-07-22 12:07:00
Kenya

Uphilos Training & Consultancy

The primary goal of the study course is enhancing the skills of technical team needed within Food Security Analysis, weather evaluation and also farming by giving them having a comprehension on the ...

Advanced Monitoring & Evaluation For Development Results Training Advanced Monitoring & Evaluation For Development Results Training
On going

12 days, 15 - 26 Jul, 2019 

2019-07-15 12:07:00
Kenya

Uphilos Training & Consultancy

This course takes two weeks, and it is designed to influence the line of business-oriented techniques for checking and analysis which are extremely required in the improvement industry. After using ...