Country dropdown

Financial Analysis using excel Course


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, Management & Procurement. It is designed to improve the Excel modelling & analytical skills of finance professionals for the forecast, analysis & presentation of business & financial information


10 Days


  • This certificate 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.


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

  • 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                  

  • Module 1: Financial Modeling

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

    Module 2: Financial modeling Functions

    • Different ways of summing and counting: SUM; SUMIF;
    • TRUNC; MOD
    • 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

    Module 3: Modeling for financial and operational planning

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

    Module 4: 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

    Module 5: Credit Perspective

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

    Module 6: Capital Structure Analysis

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

    Module 7: Cost of Capital Modelling

    Module 8: 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

    Module 9: Modeling for Corporate Finance Transaction

    Module 10: Evaluation of Newly built financial model

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




The instructor led trainings are delivered using a blended learning approach and comprises 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.


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


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 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


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 should be transferred to IRES account through bank on or before C.O.B 28th October 2019.

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


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 04-11-2019
Event End Date 15-11-2019
Cut off date 28-10-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: