Practical Financial Modelling & Analysis with Exce

Practical Financial Modelling & Analysis with Excel and ChatGPT (Live Webinar)

This course is formally known as Practical Financial Modelling & Analysis with Excel (Live Webinar).

 Participants are required to have Excel installed on their laptop (preferably Office 365—app version, at least Excel 2013).

Programme Objective

In today’s rapidly changing financial environment, dynamic financial modeling plays a crucial role in achieving a firm’s optimal financial results. To move from a “scorekeeper” role to top management’s strategic partner, one must acquire successful, modern financial modeling techniques.

An intense, interactive one-day workshop illustrating the professional way to construct and use financial models on spreadsheets incorporating the use of AI technology.

This practical one-day hands-on seminar is designed to give you comprehensive on-the-job tools and techniques, which you will need to become an indispensable member of your firm’s strategic planning and top management team.

A combination of modeling methodology illustrated with Excel, R, and Python with advanced Excel financial functions and tools focusing on:

• Industry Practitioner Financial Model Construction Techniques

• Black-Scholes Option Pricing Model

• Present and Future-Value Modeling

• Capital Expenditure Modeling

• Advanced Excel Tips and Techniques for Instant Modelling incorporating ChatGPT

Programme Outline

• Understand professional modeling concepts and techniques using the latest Excel spreadsheet functions and tools to calculate financial forecasts and projections.
• Professional principles of financial model construction, including the design of spreadsheets using input cells, cell names, and financial functions.
• Using ChatGPT in building financial models for analysis and reporting.
• The following modeling tools of Excel will be examined, including:

• Financial Functions

• Scenario Analysis

• Sensitivity Analysis

• Optimization Analysis

• Macros (for repetitive tasks)

• Black-Scholes option pricing model
• Capital expenditure model

Prerequisites
This course is suitable for those who already have an intermediate-level knowledge of working with Excel and who want to become familiar with and master the Excel tools, formulas, and functions necessary for building effective financial models.

Training Methodology

Lecture style, with computer hands-on Exercises

Closing Date for Registration

1 week before the program or until full enrolment

Intended For

Professional Accountants and Finance Executives who need to expand their knowledge and their professional role to support effective financial decision-making in their jobs.