An Intensive 10-day Training Course
Financial Analysis,Modellingand Budgeting Masterclass
Modules
This course is split in two modules:
Module 1: Corporate Financial Planning, Budgeting & Control
Module 2: 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 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 2: 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
- 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
Oxford Management Centre Certificate will be provided to delegates who successfully completed the training course.
In association with
Duration
10 Days
Format
Classroom
Language
English
