Name: Financial Analysis,Modelling and Budgeting Masterclass Training Course
Rating: 4.7 (1076 reviews)

Scheduled Dates

Classroom

10 - 21 Aug 2026

London - UK

$11,900

07 - 18 Dec 2026

London - UK

$11,900

09 - 20 Aug 2027

London - UK

$11,900

06 - 17 Dec 2027

London - UK

$11,900

This training course is split into two modules:

Module I - Corporate Financial Planning, Budgeting & Control
Module II - Financial Analysis, Modelling & Forecasting

Each module is structured and can be taken as a stand-alone training course; however, delegates will maximise their benefits by taking Modules I, and II back-to-back as a 2-week training course.

Daily Agenda

Module I: Corporate Financial Planning, Budgeting & Control

Day 1: Corporate Financial Planning

Strategic Planning
The Objective of the Firm – Meeting Shareholder & Stakeholder Objectives
Agency Theory – The Relationship between Shareholders & Management
Creative Accounting and the Case of Enron
Financial Management & Financial Planning – The Scope, Role & Responsibilities of Financial Management
Preparing a Financial Plan – The Master Budget
Forecasting Future Cash-flows and Financial Modelling
Time Series Analysis, Correlation & Regression

Day 2: Financing the Plan

Sources of Finance – Long Term & Short Term
Evaluation of the Types of Finance - Equity vs. Debt Finance
Hybrid Finance & Financial Engineering
The Dividend Decision
The Cost of Capital and Weighted Average Cost of Capital (WACC)
Capital Asset Pricing Model (CAPM)
Accounting Rate of Return (ARR)
Net Present Value (NPV), Internal Rate of Return (IRR) Capital Rationing & Payback

Day 3: Preparing & Managing Budgets to Support the Financial Plans

Definition of Budgets, the Budgetary Process and Budgetary Control
Types of Budgets-Fixed, Flexible, Incremental and Zero Based
The Purpose / Benefits & Problems / Limitations of Budgets
Setting / Implementing Effective Budgets - Eliminating the Problems
Responsibility Accounting and Absorption Costing
Activity-Based Budgeting / Costing (ABB, ABC)
Variance Analysis, Cost Behaviour, Break Even Analysis & Sensitivity / What If Analysis
What-If Analysis combined with Du-Pont Analysis

Day 4: Managing and Controlling Cash Flow to Support the Financial Plan

Cash vs. Profit & The Cash Conversion Cycle
Calculating and Managing the Cash flow Cycle
Cash Flow Ratios
Working Capital
The Cost of Maintaining Working Capital
Maintaining the Optimum Level of Working Capital
Working Investment Ratios
Preparing a Monthly Cash Flow Forecast

Day 5: Managing Financial Risk

Risk Management & Types of Risk
Identifying Risk – SWOT Analysis
The Major Quantitative & Qualitative Risks Facing Companies
Establishing a Risk Management Strategy
Financial Risk Management & Hedging Techniques
Managing Exchange Rate & Interest Rate Risk
Derivatives-Forwards, Futures, Options & Swaps
Risk Management Glossary of Terms

Module II: Financial Analysis, Modelling & Forecasting

Day 6: The Competitive Challenge in the 21st Century

Identifying and Managing Stakeholder Needs
Business Models and How They are Disrupted
An Integrated Approach to Risk Management
The Essentials of Business Performance Management

Fundamentals of Financial Modelling

Financial Statements Basics
Fundamentals of Financial Modelling

Day 7: Mastering Financial Analysis

Building a Financial Ratio Database in Excel
Practical Modelling: The Cost-Volume-Profit Relationship
Measuring and Improving Return On Investment
Measuring and Improving Asset Management Efficiency
Measuring and Managing Capital Structure and Risk
Practical Modelling: The Effect of Gearing on Shareholders’ Earnings

Day 8: Improving Financial Forecasting

Practical Modelling: Using Excel Statistical Analysis Tools
Avoiding Common Forecasting Problems
Using Moving Averages to Analyse Time Series Data
Using Linear Regression for Sales Trend Analysis
Using Excel Solver to Minimise Forecasting Error
Using Regression and Correlation to Forecast Costs
Practical Modelling: Cash Flow Forecasting

Day 9: Financial Models to Improve Investment Decision-making

Principles of Capital Investment Decision-making
Sources and Cost of Business Finance
Practical Modelling: Using Excel Discounted Cash Flow Tools
Practical Modelling: Capital Investment Analysis
Essentials of Business Valuation
Practical Modelling: Business Valuation Based on Shareholder Value Added

Day 10: Managing Risk and Uncertainty

Identifying and Analysing Business Risk
Probability Based Approach to Decision-making
Monte Carlo Simulation
Sensitivity Analysis and “what-if” Forecasting
Identifying the Key Drivers of Financial Performance
Practical Modelling: Key Driver “what-if” Forecast

Certificate

On successful completion of this Training Course / Online Training Course, a PetroKnowledge Certificate / E-Certificate will be awarded to the delegates.

Would an alternative date be more suitable?

We offer a variety of tailored training options, customized to meet your organisation's needs. Delivered anytime, anywhere, we make it easy to bring expert training directly to your team.

Related Categories

Finance & Accounting

Subscribe To Our Newsletter

CERTIFICATES

An Interactive 10-Day Training Course

Financial Analysis,Modellingand Budgeting Masterclass