An Intensive 10-day Training Course
Financial Analysis, Modelling,
Forecasting & Budgeting Planning

Modules
This training course is split into two modules:
MODULE I - Financial Analysis, Modelling & Forecasting
MODULE II - Budgeting, Forecasting and the Planning Process
Each module is structured and can be taken as a stand-alone training course; however, delegates will maximise their benefits by taking Module 1 and 2 back-to-back as a 2-week training course.
Course Outline
Module 1: Financial Analysis, Modelling & Forecasting
Day One
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 Two
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 Three
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 Four
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 Five
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
Module 2: Budgeting, Forecasting and the Planning Process
Day Six
Strategic Management and Financing
- Strategic Analysis, Strategic choices and evaluation, and Strategic implementation
- The Links between Strategy, Forecasting, Planning, Budgeting, Performance Measurement
- Strategic capability and avoiding the Spiral of Death
- Shareholder Wealth maximisation, Corporate and Shareholder value creation
- Financial Strategy, Dividend Policy, the Agency Problem and Corporate Governance
- Long-term Financing
- Debt and Equity; Cost of Equity using Dividend Growth and Capital Asset Pricing Model (CAPM); Cost of Debt; Weighted Average Cost of Capital (WACC)
- Capital Structure Optimisation Models to minimise WACC
- Using Strategy Maps to link strategies to Performance Measurement: The Balanced Scorecard
Day Seven
Financial Planning, Forecasting, and Risk Analysis
- The Financial Planning Process and Modelling using Excel
- Statistical Forecasting Tools and Techniques
- Time series; moving averages; exponential smoothing; Pareto Analysis; trend progression; linear regression; correlation
- Forecasting long- and short-term sales revenues, and sales pricing
- Porter’s generic strategy of cost leadership and differentiation; Bowman’s strategy clock; full cost pricing; marginal cost pricing; target cost pricing; life-cycle costing; kaizen costing; value-based pricing
- Using Excel for Optimum Product mix decisions
- Short-term Financing, Working Capital, and the Cash Operating Cycle
- Direct and Indirect Cash Flow Analysis and Cash Flow Forecasting using Excel
- Uncertainty and Risk
- Business Risk
- Financial Risk
- Systematic Risk
- Unsystematic Risk
- The Choices available to minimise and mitigate risk
Day Eight
Cost Analysis Techniques
- Cost Behaviour and Activities
- Fixed and Variable Costs, Direct and Indirect Costs
- Product Costs and Period Costs
- Cost Allocation and Absorption of Overheads
- Absorption or Full Costing
- Marginal Costing
- Cost-Volume-Profit (CVP) and ‘what-if’ analysis using Excel
- Activity Based Costing (ABC) and Activity Based Management (ABM)
Day Nine
Budgeting, Budgetary Control and Performance Improvement
- To Budget or Not – Purposes and Reasons for Budgets
- Stages in the Budget Preparation Process
- Preparation of the Master Budget
- Activity Based Budgeting (ABB)
- Responsibility Accounting and Variance Analysis
- Standard costing; flexed budgets; budgetary control to measure organisational and management performance
- Advantages, Disadvantages and Behavioural Aspects of Budgeting
- The Conflict between Performance Improvement and the Costing System
- Lean thinking and integrating continuous performance improvement into the Budget Process
Day Ten
Project Appraisal and Capital Budgeting
- The Time Value of Money
- Future Values
- Present Values
- Discounted Cash Flow (DCF)
- Capital investment Project Appraisal
- Accounting Rate of Return (ARR); payback; Net Present Value (NPV); Internal Rate of Return (IRR); Modified Internal Rate of Return (MIRR); Discounted Payback; Equivalent Annual Cost (EAC)
- Project Risk
- Sensitivity Analysis; simulation; scenario analysis; NPV break-even
- Capital Rationing
- Capital Budgeting and the Profitability Index (PI)
Certificate
On successful completion of this training course, Oxford Management Centre Certificate with eligible Continuing Professional Education credits (CPE) from National Registry of CPE Sponsor will be awarded to the delegates
Accreditation

In association with
FREQUENTLY ASKED QUESTIONS
Yes, we provide assistance in securing both hotel reservations & entry visa on all our international training venues, for delegates attending our training courses. For further information / assistance, please contact our Customer Service at:
- Telephone: +971 50 985 0174
- E-mail: info@oxford-management.com
Yes, Oxford Management Centre is accredited by the following professional bodies;
National Association of State Board of Accountancy (NASBA)
The Oxford Management Centre is registered with NASBA as a sponsor of Continuing Professional Education (CPE) on the National Registry of CPE Sponsors. NASBA have final authority on the acceptance of individual courses for CPE credit.
Yes, discounts are available. For further information please call +971 50 985 0174 or email, info@oxford-management.com
Note: Discounts are not applicable with any other special offer that may be available.
All course bookings made through Oxford Management Centre are non-refundable. By registering for a course, you acknowledge and accept that fees are payable in full and are not subject to refund under any circumstances, including but not limited to participant dissatisfaction, changes in personal or professional circumstances, or partial attendance.
Oxford Management Centre reserves the right to make reasonable adjustments to course content, trainers, or schedules where necessary, without entitling delegates to a refund. Full details of each course – including objectives, target audience, and content – are clearly outlined prior to enrolment, and it is the responsibility of the delegate to ensure suitability before booking.
There are 2 easy ways to register:
- Online: Select the training course you want to register for, Click the “Book Your Place” button on the course page, complete the form and click submit.
- E-mail: Send your details to info@oxford-management.com
We request that all cancellations be made at least one week before the class start date. You may reschedule this class without any penalty. If not, a $250 fee will be charged for cancellations received less than one week before a class begins and for no-shows. Cancellation penalties and any fees incurred by Oxford Management Centre will be deducted from refunds.
For more information request, email info@oxford-management.com or call +971 50 985 0174.
The classroom training fees include course presentation, relevant materials, physical & digital documentation, lunch and refreshments served during entire training. Accommodation and transportation are not included in the training course fees.
While, online training fees cover the course presentation and digital documentation and relevant materials.
The Oxford Management Centre Certificate of Completion with corresponding CPE credits shall be awarded to delegates who has successfully completed the training course.
Payment must be received before the training course commences. You can make payment by bank draft, cash, credit card or wire transfer.
Note: If the payment is not received, Oxford Management Centre has the right to refuse admission.
Upon receipt of your registration form, we will send you the following by e-mail:
- Registration Confirmation
- Invoice/Receipt (where appropriate)
If you register online you will receive an e-mail within 24 hours confirming your registration.