An Intensive 10-day Training Course
Financial Analysis,Modellingand Budgeting Masterclass
Modules
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 Module 1 and 2 back-to-back as a 2-week training course.
Course Outline
Module 1: Corporate Financial Planning, Budgeting & Control
Day One
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 Two
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 Three
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 Four
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 Five
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 2: Financial Analysis, Modelling & Forecasting
Day Six
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 Seven
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 Eight
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 Nine
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 Ten
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, Oxford Management Centre Certificate with eligible Continuing Professional Education credits (CPE) from National Registry of CPE Sponsor will be awarded to the delegates
In association with
Related Courses
Certificate in International Financial Reporting Standards (IFRS)
Date: 23-27 Jun 2025 Location: Dubai Fee: $5,950
Financial Accounting Certificate
Date: 11-15 Aug 2025 Location: London Fee: $5,950
Sustainability and Carbon Accounting Masterclass
Date: 16-20 Jun 2025 Location: London Fee: $5,950
Real Estate
Date: 29 Sep-10 Oct 2025 Location: London Fee: $11,900
Real Estate Economics and Valuations
Date: 08-12 Dec 2025 Location: Amsterdam Fee: $5,950
Real Estate Finance for Development and Investment
Date: 07-11 Jul 2025 Location: London Fee: $5,950
Real Estate Development Process
Date: 23-27 Jun 2025 Location: Dubai Fee: $5,950
Hotel Investments Analysis and Financing
Date: 14-18 Jul 2025 Location: London Fee: $5,950
Property Management
Date: 06-10 Oct 2025 Location: Dubai Fee: $5,950
Real Estate Market Analysis & Appraisal
Date: 30 Jun-04 Jul 2025 Location: Dubai Fee: $5,950
FREQUENTLY ASKED QUESTIONS
To check on availability please call Registrar’s Office at +971 50 985 0174. If you have any questions or enquiries please feel free to contact us
- Telephone: +971 50 985 0174
- E-mail: [email protected]
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: [email protected]
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, [email protected]
Note: Discounts are not applicable with any other special offer that may be available.
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 [email protected]
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 [email protected] 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.
