Digital Finance Masterclass: Advancing with Financial Modelling IFRS Compliance & Power BI Integration

Overview

This course combines financial modeling, IFRS reporting, and practical case studies using real data. Participants will learn to use Microsoft Excel and Power BI to develop and review financial models across different scenarios. It integrates financial modeling techniques with IFRS standards, including IFRS 13 (Fair Value), IFRS 15 (Revenue from Contracts with Customers), and IFRS 16 (Leases).

The course offers hands-on experience through case studies and is suitable for both financial and non-financial managers.

Benefits of attending

By the end of the workshop, delegates will be able to:

ANALYSE financial statements using modelling
CREATE a Budget and to make changes to different scenarios
DEVELOP a model for investment decision
CREATE a sensitivity analysis model
MANAGE existing financial proposals to deliver the best returns
CREATE Business Intelligence reports and analysis
APPLY and EVALUATE aspects of IFRS techniques and methodologies
RECOGNISE the merits of using Excel and of using Power BI

Schedule

Day 1
Day 2
Day 3

Session 1: Working with Financial Statements: Income Statement, Balance Sheet and Statement of Cash Flow Financial Statement Analysis

Analysing
Profitability
Return
Liquidity
Asset Usage
Cash Flow
Investor
Growth ratios

Session 2: Statistical Analysis of Data

Golden Rules of Data Analysis
Ordinary Least Squares Regression Analysis
Multiple Regression Analysis
Apply the techniques to forecasting models and in setting standards and KPIs

Session 3: Functional Budgets

Preparation and presentation of functional budgets.
Sales
Production
Direct and Indirect Costs
Period Costs
Master Budgets

All of the above will be integrated with and enhanced by scenario analysis.

Session 4: Capital Budgeting, Risk Assessment and Simulations Calculating the Cost of Capital Investment Decisions

Calculating the NPV, XNPV, IRR, MIRR, XIRR, Profitability Indices and payback period
Sensitivity Analysis for a Business Case
Developing and Managing Scenarios

Session 5: IFRS 13 Fair Value Measurement

Highest and Best use and valuation premise
Multiple valuation techniques
Reconciliation of fair value measurements categorised within Level 3 of the fair value hierarchy

Session 6: A Brief Introduction to the main provisions of IFRS 15

Incremental costs of obtaining a contract
Disaggregation of revenue—quantitative

Session 7: IFRS 16 Leases

Modification that is a separate lease
Modification that increases the scope of the lease by extending the contractual lease term
Modification that decreases the scope of the lease

Section 8: IFRS 9 Financial Instruments

Significant changes to credit risk
Expected credit losses
Explicit probability approach
Loss rate approach
Provision matrix

Session 9: Business Intelligence Aspects of Financial and Data Modelling with Power BI

CSV/Text
XLSX
Access Database
Folders
Web
One off connection

Session 10: Data Preparation and Cleaning

Splitting columns
Merging columns
Adding columns
Duplicating columns
Filtering rows
Group By
Appending queries
Dealing with dates

Session 11: Visualisations

Column Chart
Line Chart
Area Chart
Scatter Chart
Waterfall Chart
Funnel Chart
Tables
Matrix
Maps
Filled Maps

Section 12: Measures and Detailed Analyses

Quick measures
Trendlines
Forecast
Key Influencers
Decomposition tree

Trainer's Profile

Your course leader, Mr. Duncan Williamson, international experience includes projects and consultancies carried out in the Middle East, Africa, Central Asia, South Asia, the Caucasus, the Balkans, Central Europe, and Denmark. He combines his extensive academic and training experience with significant manufacturing and commercial work.

He has published widely over the years and his publications listing includes an online series published by www.bookboon.com entitled Excel Solutions for Accountants (in preparation); a Self-Paced Study Text for non-accounting managers entitled The Bookkeeping and Accounting Coach, published by Hodder and Stoughton; a textbook on Cost and Management Accounting published by Prentice-Hall, eBooks on a variety of accounting topics, numerous.

At its core BIZREV is a global business to business event company that has embraced the digital age. We create a blend of live & digital events that drives corporate innovation.