Security Solutions

We offer security solutions that customers can use to protect their computers.

Software Solutions

We provide software solutions such as VistaPOS, SACCO Systems, School Systems, Payroll Systems, ATM (SACCO Link)Integrations

Hardware Solutions

We offer KRA approved fiscal printers to all VAT registered traders in the country



Network Solutions

We provide appropriate Network and Technical solutions to various business entities in the country



E-CLINIC SYSTEM

E–Clinic is specialized software designed to manage wellness centers.

EaseUS Data Recovery Software

Safe & Do-It-Yourself Data Recovery Solution to Solve Your Data Loss Problems

Financial Modeling Training

The Financial Modeling - Full Integrated Model course teaches you the art of constructing an integrated financial model – from scratch. You will soon be building models that are robust and provide you with flexible projections that can be used to thoroughly analyze a company from multiple standpoints: Planning, Investment, Financing and Valuation.

Benefits of attending:

  1. Design & Structure various financial problems and translate them to Excel
  2. Ability to create models quickly
    • Online: FMCG Case Study
    • Classroom: Accenture Inc. Case Study
  3. Understand valuation techniques through DCF
    • Cost of Capital (WACC)
    • Terminal Value
    • Free Cash Flow to the firm and Equity Holders
  4. Understanding techniques to quickly audit robust models

Who should attend?

  • Financial Research  Analysts
  • Project Finance  Analysts
  • Corporate Finance Managers
  • Business planning & strategy
  • Investment Banking Associates and Analysts
  • Credit Analysts
  • Entrepreneurs
Financial Modeling - Full Integrated Model 
Overview

Overview of Fully Integrated Model
Keyboard shortcuts for efficient model building
Formulas and cross referencing

Creating a financial model template

Formatting numbers in Excel
Conditional formatting
Creating a consistent template for modeling

Historical financial statement modeling (P&L and
B/S)

Data Gathering from Annual Reports (10K filing)
Creating the historical statements and linking derived numbers

Calculating growth drivers

Gathering Data for growth drivers from research reports and other sources
Calculating P&L growth numbers/ CAGR
Calculating P&L ratios
Calculating Balance Sheet ratios

Building assumptions and projections

Building assumptions for P&L and B/S
Linking assumptions for P&L (Except depreciation and Interest)
Linking assumptions for Balance Sheet (Except Fixed Assets and Debt)

Building the Asset and depreciation schedule  
Financial Modeling - Full Integrated Model
Building Debt & Interest schedule (Without circular referencing)  
Building Cash flow statement

Understanding cash from operations, investing and financing activities

Building interest on excess cash and cash revolver

Using Excel for Iteration - Goal Seek & circular referencing
Linking cash revolver and interest to Cash flow, B/S and P&L
Formula navigation and debugging errors in excel
Handling errors in Excel – Is error function

Building ratios for analysis

Understanding liquidity ratios
Understanding profitability ratios

Updating integrated model for valuation analysis

Understanding and building trading comps
Understanding and building transaction comps
Understanding and building DCF
Building free cash flow to firm & equity
Understanding and estimating levered & unlevered beta
Understanding & estimating WACC
Understanding terminal value
Using data-validation to improve sheet structure

Financial Modeling - Full Integrated Model
Introduction and context in Advanced functions for modeling

Named ranges as methodology for modeling
Case: Selecting the relevant revenue
Use Index to get the relevant value
Case: Portfolio analysis Case: Creating flexible models for scenarios.
Case: Flexible model generation. Deferred Tax and Loss carried forward.

Formula Auditing

Excel Audit shortcuts
Formula Auditing: Road Model
Evaluate Formula

Advanced Charting technique

Building Primary & Secondary Axis in a Chart
Tracking the progress of the construction of the commercial property: Radar Charts
Summary of Valuation: Creating Football
Charts Stacked bar charts

Financial Modeling - Full Integrated Model
Introduction to Macros & Advanced Application Building in Excel

Introduction and context
Key concepts in Macros
Macros as recorded Robots!

Designing application to gather user data

Implementing user forms in Excel Macros
Linking forms to excel cells
Building flexible charts in excel

Understanding VBA and debugging

Understanding the relevant language constructs
Example: Write your First Macro
Errors in VBA
Step into VBA
Writing VBA codes:
Random Number Generator: Use of loop, Excel functions
Message box, Input box

Advanced Financial Applications Breaking circular loops

Monte Carlo simulation

 

By attending our Financial Modeling Masterclass 2016 you get, Exposure to best-in-class modeling techniques, design ideas & practical tips

  • Tips & ideas on using Excel better for Financial
  • Modeling
  • Downloadable workbooks, PDF
  • Guides & videos
  • Unlimited download Access to all videos & material on financial modeling
  • Networking opportunities with fellow professionals
  • Email support for your Financial Modeling questions for 1 Year