Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Training on Financial Modeling using Excel

By: Devimpact Institute

Kenya

27 Mar - 04 Apr, 2023  9 days

Follow Event

  

USD 950

Venue: Online

Other Dates

Venue Date Fee  
Devimpact Institute Training Centre Nairobi , Kenya 03 - 07 Apr, 2023 USD950

This training program will enable participants to acquire the practical knowledge required to build reliable financial models that can be applied to corporate planning and evaluation. Participants will learn best practise design concepts for designing adaptable models using a variety of financial modelling in excel techniques and functions that are used when creating a complete financial model from scratch. 

Target Participants 

This course is aimed at corporate finance professionals, CFOs, financial controllers, finance managers, financial analysts and business development analysts. 

What You Will Learn 

By the end of this course the participants will be able to: 

  • Prepare effective financial models utilizing powerful Excel functions 
  • Use core financial modeling techniques 
  • Create Scenario Analysis and Dash Boards 
  • Understand and apply Forecasting concepts and be able to track forecasting errors 
  • Forecast investments, and calculate valuations of projects and companies in an effective manner 
  • Develop comprehensive financial models to support investments decision 

Course Outline  

Introduction to Financial Modeling 

  • Financial modeling fundamentals 
  • Steps in model building 
  • Key concepts of financial modelling 

Getting Acquainted with Excel  

  • Making Sense of the Different Versions of Excel 
  • Defining Modern Excel 
  • Recognizing the Dangers of Using Excel 
  • Looking at Alternatives and Supplements to Excel 

Planning and Designing a Financial Model 

  • Identifying the problem that your financial model needs to solve 
  • Designing how the problem’s answer will look 
  • Gathering data to put in your model 
  • Documenting the limitations of your model 
  • Structuring your model: What goes where 
  • Defining inputs, calculations, and output blocks 
  • Determining your audience 

Excel Tools and Techniques 

  • Cell referencing 
  • Naming ranges 
  • Linking in excel 
  • Using shortcuts 

Excel Functions and Formulas in Finance 

  • The difference between a formula and a function 
  • Understanding to most important functions and formulas 
  • Finding the function and you need 
  • Advanced functions and formulas 

Applying Scenarios to Financial Model 

  • The Differences between types of analysis 
  • Building Drop-Down scenarios 
  • Applying sensitivity analysis with data tables 
  • Using scenario manager to model loan calculations 

Charting and Presenting Model Output 

  • Deciding which data to display 
  • Conveying your message by charting scenarios 
  • Deciding which type of chart to use 

Building Financial Statements Model 

  • Entering assumptions 
  • Calculating revenue 
  • Calculating expenses 
  • Building the Income Statement 
  • Building the Cash Flow Statement 
  • Building the Balance Sheet 
  • Building scenarios 

Building a Discounted Cash Flow Valuation 

  • Understanding how the discounted cash flow valuation works 
  • Step 1: calculating Free Cash Flow to Firm 
  • Step 2: calculating Weighted Average Cost of Capital 
  • Step 3: finding the Terminal Value 
  • Discounting Cash Flows and Valuation 

Integrating Financial Statements Model 

  • Making a reusable budget model template 
  • Creating dynamic titles 
  • Calculating cash required for budgeted asset purchases 
  • Calculating budgeted depreciation 
  • Calculating the written-down value of assets for the balance sheet 

Training Approach 

This course is delivered by our seasoned trainers who have vast experience as expert professionals in their respective fields of practice. The course is taught through a mix of practical activities, presentations, group works and case studies. 

Training manuals and additional reference materials are provided to the participants. 

Certification 

Upon successful completion of this course, participants will be issued a certificate. 

Tailor-Made Course 

We can also do this as a tailor-made course to meet organization-wide training needs. A training needs assessment will be done on the training participants to collect data on the existing skills, knowledge gaps, training expectations and tailor-made needs.

Online Mar 27 - 04 Apr, 2023
Devimpact Institute Training Centre Nairobi , Kenya 03 - 07 Apr, 2023

Registration: 00:00:am - 11:55:am

Class Session: 08:30:am - 04:00:am

USD 950.00 + 47.50 (VAT)(Classroom-based)
USD 600.00 + 30.00 (VAT)(Online)
(Convert Currency)

Devimpact Institute +254 714349537

Related Courses

Training on Research Design, Data Management and Statistical Analysis using SPSS Training on Research Design, Data Management and Statistical Analysis using SPSS

12 days, 10 - 21 Apr, 2023 

2023-04-10 12:04:00 2023-04-10 12:04:00
Kenya

Devimpact Institute

In the socio-economic and business context, conducting research, data management and data analysis are imperative for informed decision making. The availability of several datasets and research ...

Training on Resource Mobilization and Proposal Writing Training on Resource Mobilization and Proposal Writing

5 days, 10 - 14 Apr, 2023 

2023-04-10 12:04:00 2023-04-10 12:04:00
Kenya

Devimpact Institute

The ability of development partners to implement their project interventions is dependent on their access to donor funding. Access to these funds requires submission of proposals for consideration by ...

Training on Electronics Document Management Training on Electronics Document Management

5 days, 27 - 31 Mar, 2023 

2023-03-27 12:03:00 2023-03-27 12:03:00
Kenya

Devimpact Institute

Electronic Document Management the process of creating, managing, tracking and storing electronic information and records within an organization's workflow. It involves the digitalization of ...

Training on Data Management and Statistical Analysis using Stata Training on Data Management and Statistical Analysis using Stata

9 days, 03 - 11 Apr, 2023 

2023-04-03 12:04:00 2023-04-03 12:04:00
Kenya

Devimpact Institute

Stata statistical data software is a complete, integrated statistical software package that provides for data analysis, data management, and graphics.  The course is aimed at researchers ...