Country dropdown

Basics of financial modelling using Ms Excel Course

INTRODUCTION

This course is designed for existing users of Excel or similar spreadsheet programs needing to vastly increase their modelling & analytical skills especially in the disciplinary areas of Finance, Accounting, and Management & Procurement. It is designed to improve the Excel modelling & analytical skills of finance professionals for the forecast, analysis & presentation of business & financial information.

DURATION

10 Days

WHO SHOULD ATTEND?

This course is for analysts, financial officers, and portfolio managers seeking a deeper understanding of Valuation, and the skills and knowledge to confidently make financial decisions.

COURSE OBJECTIVES

At the end of this IRES training seminar, you will learn to:

  • creating professional charts in Microsoft Excel
  • working with large amounts of data
  • Understanding Accounting and Bookkeeping principles
  • Building a company’s financial statements
  • Performing Financial Statement Analysis
  • Understanding importance of timing in terms of revenue and cost recognition
  • Calculating Liquidity, Solvency, Profitability, and Growth ratios
  • assessing project feasibility
  • calculating a complete loan schedule
  • Understanding the difference between variable and fixed interest rates
  • Performing industry analysis
  • Understanding drives a company’s value
  • analyzing a business

TOPICS TO BE COVERED

Financial Modeling

    • Accuracy, flexibility, User-friendliness
    • Structural standards
    • Iteration, Circular Errors, the #REF! problem
    • Factual checks, Rational checks, Structural checks,
    • Model Stress Testing, Proofreading

Financial modeling Functions

    • Different ways of summing and counting: SUM; SUMIF;
    • SUMPRODUCT; COUNT; COUNTA; COUNTBLANK; COUNTIF and IF fuctions
    • ROUND; ROUNDUP; ROUNDDOWN; CEILING; FLOOR; INT;
    • TRUNC; MOD
    • HLOOKUP; VLOOKUP
    • Discounting on uneven periods: NPV; XNPV; IRR; XIRR
    • Data validation; Text to column
    • Pivot tables, what if analysis and data tables
    • Sensitivity and scenario analysis

Modeling for financial and operational planning

    • A working capital management model
    • A capital budgeting model
    • An inventory policy model
    • A plant opening/closing model

 Additional Analysis in Financial Modeling

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

Credit Perspective

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

Capital Structure Analysis

    • Existing Debt
    • Bank Revolver
    • Other Long-Term Debt
    • Preferred Stock
    • Book Capitalization
    • Total Debt
    • Book Equity
    • Borrowing Base
    • Revolver Debt

Cost of Capital Modelling

Valuation models using Discounted Cash Flow Analysis

    • Free Cash Flow to Firm
    • Free Cash Flow to Equity
    • Single stage and multi stage models
    • Principles of financial analysis using NPV, IRR, PBP and other measures
    • Discounted Cash Flow Analysis
    • Relative Valuation
    • Hybrid of DCF and relative valuation
    • Conducting reality check on results

Modeling for Corporate Finance Transaction

Evaluation of Newly built financial model

    • Objectives
    • Assumptions
    • Logical flow
    • Key inputs
    • Interrelationships among inputs
    • Expected output
    • Factual checks, Rational checks, Structural check
  • METHODOLOGY

The instructor led trainings are delivered using a blended learning approach and comprise of presentations, guided sessions of practical exercise, web-based tutorials and group work. Our facilitators are seasoned industry experts with years of experience, working as professional and trainers in these fields.

All facilitation and course materials will be offered in English. The participants should be reasonably proficient in English.

ACCREDITATION

Upon successful completion of this training, participants will be issued with an Indepth Research Services (IRES) certificate.

TRAINING VENUE

The training is residential and will be held at IRES training Centre. The course fee covers the course tuition, training materials, two break refreshments, lunch, and study visits.

All participants will additionally cater for their, travel expenses, visa application, insurance, and other personal expenses.

ACCOMMODATION

Accommodation is arranged upon request. For reservations contact the Training Officer.

Email:  This email address is being protected from spambots. You need JavaScript enabled to view it.   

Mob: +254 715 077 817

Tel: 020 211 3814

TAILOR- MADE

This training can also be customized for your institution upon request to a minimum of 4 participants. You can have it delivered in our training centre or at a convenient location.

For further inquiries, please contact us on Tel: +254715077817, +254(020) 211 3814 or mail This email address is being protected from spambots. You need JavaScript enabled to view it.

PAYMENT

Payment should be transferred to IRES account through bank on or before C.O.B. 30th September 2019.

Send proof of payment to This email address is being protected from spambots. You need JavaScript enabled to view it.

CANCELLATION POLICY

Payment for all courses includes a registration fee, which is non-refundable and equals 15% of the total sum of the course fee.

1.    Participants may cancel attendance 14 days or more prior to the training commencement date.

2.    No refunds will be made 14 days or less to the training commencement date. However, participants who are unable to attend may opt to attend a similar training at a later date, or send a substitute participant provided the participation criteria have been met.

Please Note: The program content shown here is for guidance purposes only. Our continuous course improvement process may lead to changes in topics and course structure.

Event Properties

Event Duration 10 Days
Event Date 07-10-2019
Event End Date 18-10-2019
Cut off date 30-09-2019
Individual Price(Kenyan) KES 139,000
Individual Price (International) EUR 1,592
Individual Price(International in Dollars) USD 1,853
Location Nairobi, Kenya
Share this event:

Search