Advanced Financial Modelling

  • Category
    Business/ Data Analysis

Course Content

Fee: N395,000 (Per Participant Ex VAT) Duration: 4 Days 

COURSE OVERVIEW
Financial modeling is an in-demand skill. Organizations now utilize financial models as a crucial tool to comprehend business risks and make crucial strategic decisions. An efficient model can be used to analyze operational parameters' effects on a firm's value and viability since it is reliable, adaptable, and user-friendly.

This course shows how financial modeling is performed and how financial models are used. It also shows the finance, accounting, spreadsheet, and design skills that underlay good modeling practice. This intermediate through to advanced course is aimed at those who wish to learn the principles and practice of financial modeling to design or maintain their own models. With a practical ‘hands-on’ approach, each participant will work with a computer for most of the course on practical financial modeling topics.

COURSE OBJECTIVES

The course is designed to cover the following key objectives:

  • Appreciate the difference between what makes a good model and a bad one
  • Follow a logical, structured and disciplined approach towards model building
  • Build a model (or significant parts of one) from start to finish
  • Learn how to translate key financial and commercial aspects into Excel
  • Understand better how to tailor the outputs of the model toward end users and interpret the results
  • Improve knowledge of Excel functionality
  • Learn ways to reduce the incidence of modeling errors

COURSE MODULES

  • Advanced concepts in Financial Modeling
  • Planning and Designing Your Financial Model
  • Excel Tools and Techniques for Financial Modeling
  • Using Financial Functions in Excel
  • Applying Scenario
  • Understanding the three major financial statement
  • Building an Integrated Financial Statement Model
  • Charting and Presentation of Model

Course Information

  • Next Start Date:
  • Duration: Days
  • Course Fee : 0
  • Seating Capacity:
  • Venue:
  • City:
  • Upcoming Dates: