Country dropdown
Don't have an account yet? Register Now!

Sign in to your account

Financial Analysis using 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, 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

5 Days

WHO SHOULD ATTEND?

This programme is aimed at training:

  • 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

REQUIREMENTS

Participants should be reasonably proficient in English. Applicants must live up to Indepth Research Services (IRES) admission criteria.

METHODOLOGY

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.

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:+250 789 621 067

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

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

Mob:+250 789 621 067

PAYMENT

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

Send proof of payment to

Email: 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 5 Days
Event Date 02-09-2019
Event End Date 06-09-2019
Cut off date 26-08-2019
Individual Price(rwanda franc) R₣ 552,000
Individual Price (International) EUR 883
Individual Price(International in Dollars) USD 999
Location Kigali,Rwanda

Group Tariffs

Group Size Rwandese Rate Per Day( R₣) International Rate Per Day(USD/EURO)
3-5 588,800.00 $ 1,118.00
€ 1,018.00
6-10 894,400.00 $ 1,721.00
€ 1,567.00
11-15 1,376,800.00 $ 2,250.00
€ 2,048.00
16-20 1,800,000.00 $ 2,706.00
€ 2,463.00
21-25 2,164,800.00 $ 3,089.00
€ 2,811.00
26-30 2,471,200.00 $ 4,556.00
€ 0.00
30-50 3,644,800.00 $ 736.00
€ 670.00
Share this event:
©2019 Indepth Research Services. All Rights Reserved.

Search

Don't have an account yet? Register Now!

Sign in to your account