Financial Analysis, Modelling and Forecasting
- Next date
- 8–12 March 2027Online
- Fees from
- £2,950per delegate
- Formats
- Online · Classroom4 sessions
- Duration
- 5 daysCertificate
Overview
Financial analysis, modelling and forecasting are core skills for anyone who prepares budgets, evaluates investments or advises management on business performance. In the energy sector, where revenues depend on volatile prices and projects require large upfront investment, well-built financial models and reliable forecasts help organisations understand performance, plan cash needs and choose between competing opportunities. Yet many models are poorly structured, hard to audit and full of hidden errors, and forecasts are often prepared without a clear understanding of the drivers behind the numbers.
This course develops practical skills in financial analysis, spreadsheet modelling and forecasting. Participants learn how to analyse financial statements using ratios, trends and cash flow analysis, and how to assess profitability, liquidity, solvency and efficiency. The course covers good modelling practice, model structure and design, the linking of income statement, balance sheet and cash flow forecasts, and the use of assumptions and driver-based models. It also explains forecasting revenue, costs and capital expenditure, rolling forecasts, sensitivity and scenario analysis, discounted cash flow valuation, model review and error checking, and the clear presentation of financial results to decision makers.
Objectives
- Analyse financial statements using ratios, trends and cash flow analysis
- Apply good practice in financial model structure and design
- Build linked income statement, balance sheet and cash flow forecasts
- Develop driver-based forecasts for revenue, costs and capital expenditure
- Use sensitivity and scenario analysis to test forecasts
- Value projects and businesses using discounted cash flow methods
- Review models for errors and present financial results clearly
Who should attend
Financial analysts, accountants, planners, budget holders, business analysts and engineers involved in financial evaluation.
Training methodology
The course is highly practical and spreadsheet based. Participants work step by step through financial analysis exercises, build an integrated three-statement forecast model, develop driver-based revenue and cost forecasts, add sensitivity and scenario functionality and carry out a discounted cash flow valuation. Model review exercises train participants to find and correct common errors. Examples are drawn from energy and industrial companies. Participants should bring a laptop with spreadsheet software. Each day ends with a review of the model built and a short quiz.
Programme outline
Day1Financial Statement Analysis
- The purpose of financial analysis and the questions it helps managers answer
- Reviewing the income statement, balance sheet and cash flow statement together
- Profitability ratios including margins, return on capital and return on equity
- Liquidity, solvency and efficiency ratios and what they reveal about a business
- Cash flow analysis, cash conversion and the quality of reported earnings
- Trend analysis over several years and benchmarking against competitors and industry averages
- Practical exercise: analysing the financial performance of an energy company
Day2Financial Modelling Principles
- Uses of financial models in budgeting, investment appraisal and business planning
- Good modelling practice: clarity, consistency, flexibility and ease of review
- Model structure with clearly separated sections for inputs, calculations and outputs
- Timelines, flags and other techniques for handling periods and project phases
- Useful spreadsheet functions and features for building robust financial models
- Documentation, version control and protecting models from accidental or unauthorised changes
- Practical exercise: setting up the structure and inputs for a forecast model
Day3Building Integrated Forecasts
- Driver-based forecasting and identifying the key drivers of revenue and cost
- Forecasting revenue from volumes, prices and contract terms in energy businesses
- Forecasting operating costs, fixed and variable costs and inflation effects
- Capital expenditure, depreciation and working capital forecasts and how they affect cash
- Linking the income statement, balance sheet and cash flow statement correctly
- Financing, interest, tax and balancing the balance sheet without plugs
- Practical exercise: building an integrated three-statement forecast model from given assumptions
Day4Sensitivity, Scenarios and Valuation
- Sensitivity analysis using data tables and tornado charts to find key drivers
- Scenario analysis and the use of scenario switches within a model
- Introduction to probabilistic forecasting and Monte Carlo approaches for uncertain inputs
- Discounted cash flow valuation, free cash flow and terminal value
- Cost of capital, discount rates and their effect on valuation results
- Rolling forecasts and their practical advantages over traditional fixed annual budgets
- Practical exercise: adding scenarios and carrying out a discounted cash flow valuation
Day5Model Review and Presentation
- Common modelling errors and their potential impact on business and investment decisions
- Model review techniques, checks, audit tools and stress testing of outputs
- Reconciling forecasts with actual results and using the findings to improve forecast accuracy
- Presenting financial results with clear charts, simple dashboards and short written summaries
- Communicating key assumptions, risks and uncertainty clearly to managers and decision makers
- Group exercise: reviewing a colleague's model and presenting the forecast results
- Final assessment and discussion of modelling practices in participants' organisations
Dates and fees
Fees are in GBP. per delegate.
Certificate
Every delegate who attends the full programme receives a Harfard Technology certificate of completion stating the course title, duration, dates and venue.
Frequently asked questions
Will I receive a certificate?
What is the difference between classroom and online?
Can you run this course for our company?
How do I register?
Related courses
Energy Management, Economics & ContractsStrategic Leadership and Decision Making
8–12 March 2027 · London +2 dates
Energy Management, Economics & ContractsPetroleum Economics & Investment Decisions
30 November – 4 December 2026 · Berlin +4 dates
Energy Management, Economics & Contracts