Course overview
A financial model is an argument expressed in arithmetic. It says: if these things are true, this is what happens to cash, profit and value. The arithmetic is usually the easy part. The argument is where models fail, because assumptions are buried inside formulas, drivers are invented to make the output land where someone wanted it, and terminal value quietly carries seventy percent of a valuation nobody has stress tested.
This course covers modeling and forecasting across twelve units: model construction, revenue and cost forecasting, cash flow, valuation, scenario and sensitivity analysis, advanced forecasting, risk integration, presentation, budgeting and long-term planning, governance, and a closing integrated case. It is educational and is not financial or investment advice.
What separates a good model from a dangerous one
Structure and transparency. In a good model, every assumption is visible in one place, every calculation flows in one direction, and any reviewer can trace an output back to the input that drove it. In a dangerous model, a hardcoded number sits inside a formula in a hidden column, and the person who built it left the company.
Forecasting has its own failure mode, and it is optimism. Forecasts made by people with an interest in the answer skew predictably: revenue ramps faster than any comparable, costs stay flat while volume triples, and the downside scenario is a slightly slower version of the base case. Tracking forecast error over time is the cheapest correction available and almost nobody does it.
Course objectives
By the end of the course, participants will be able to:
- Construct an integrated three-statement model that balances.
- Link every forecast line to a driver, not a hardcoded number.
- Forecast revenue, cost and the cash that growth consumes.
- Reconcile two valuation routes and explain the gap.
- Test which variables decide the answer, and by how much.
- Detect bias in a forecast and correct the next one.
- Simulate the range of outcomes from distributions chosen honestly.
- Chart the range and the drivers behind a single number.
- Roll the forecast forward without rebuilding the file.
- Version, document and review a model before it drives a decision.
Course outline
Unit 1: Introduction to financial modeling and forecasting
- Model purpose and the structure it dictates.
- Modeling conventions and the ban on hardcoded numbers.
- Common model failures and the cost of spreadsheet errors.
- Documentation that lets someone else use the file.
Unit 2: Building integrated financial models
- The three statements and how they lock together.
- Driver trees from volume, price and headcount to output.
- Balancing the model and the check that must equal zero.
- Circularity from interest on average debt.
Unit 3: Forecasting revenues and costs
- Revenue forecasting from pipeline, cohort or capacity.
- Step costs and the volume at which they appear.
- Checking the forecast against the growth the sector achieved.
- Documenting and challenging each assumption and its owner.
Unit 4: Cash flow forecasting and management
- Free cash flow as the cash to fund and to distribute.
- Working capital modeling with days sales outstanding.
- Thirteen-week cash forecasting when liquidity is tight.
- Funding requirement, facility headroom and covenant tests.
Unit 5: Valuation and discounted cash flow models
- Discounted cash flow structure over the forecast period.
- Terminal value and the share of the answer it carries.
- Discount rate choice and its effect on the answer.
- Cross-checking the answer against what the market pays.
Unit 6: Scenario and sensitivity analysis
- One-way and two-way sensitivity tables on key drivers.
- Scenario construction from combined moves, not one input.
- Breakeven and the threshold that changes the decision.
- Stress tests run backwards from an unacceptable outcome.
Unit 7: Advanced forecasting techniques
- Time series methods where history repeats predictably.
- Regression-based forecasting and correlation versus cause.
- Machine learning forecasts and the reasoning nobody sees.
- Forecast error measured on the same basis each cycle.
Unit 8: Risk integration in forecasting
- Monte Carlo runs that turn input ranges into an output range.
- Choosing distributions honestly to avoid false precision.
- Correlation between inputs wrongly modeled as independent.
- Presenting a probabilistic result where one number is wanted.
Unit 9: Data visualization and presentation of models
- Output design for the one page a decision-maker reads.
- Tornado charts and waterfall bridges for the range.
- Spotting truncated axes and disguised assumptions.
- Writing the model summary around the decision and drivers.
Unit 10: Budgeting and long-term planning
- Driver-based forecast turned into departmental budgets.
- Rolling forecasts and the maintenance they demand.
- Planning models that run past the budget year.
- Reconciling the model with the numbers the business sees.
Unit 11: Governance and best practices in modeling
- Model risk as the exposure carried by one file.
- Independent model review of formulas and assumptions.
- Version control and the record of who changed a live model.
- Ethics in a model built to inform rather than justify.
Unit 12: Capstone case study
- Building the driver structure from published company data.
- Valuing the company and challenging the discount rate.
- Pushing the assumptions until the decision flips.
- Presenting the output as a range with its risks named.
How the course is delivered
The course uses documented models, valuation extracts, published accounts and real board papers as material. Participants read and critique model structures, trace assumptions, and rework the weak parts in guided discussion; worked examples take valuation and sensitivity calculations through step by step. There is no software environment to build in, so the sessions concentrate on structure, assumptions and interpretation, which are the parts that go wrong. The course is educational and is not financial or investment advice. Participants applying this to project appraisal should look at Corporate Finance and Capital Budgeting.
Who should attend
- Financial analysts and finance managers who build or review models.
- Corporate development, treasury and planning professionals.
- Consultants and advisers who produce valuations and business cases.
- Executives who make decisions on the strength of models built by others.
About EuroQuest International Training
EuroQuest International Training was founded in 2015 by a team with more than 25 years of experience in professional development. We run over 1,000 courses and have trained more than 15,000 participants. Our head office is in Bratislava, Slovakia, with hubs in Dubai, London, Barcelona, Istanbul, Vienna, Paris and Geneva. Courses are developed and reviewed by practitioners from the fields they teach.
Frequently asked questions
Will I build a model during the course?
Not in a live software environment. The sessions examine model structures, assumptions and outputs through documented extracts and worked examples, which is where the errors and the judgment actually live.
How advanced is the mathematics?
Discounting, regression and probability distributions are used, explained from first principles. The course does not require statistical training, and it is explicit about where a technique adds insight and where it adds false confidence.
Does the course provide valuations or investment recommendations?
No. It is educational and is not financial or investment advice. Valuation techniques are taught as method; any valuation you produce remains your responsibility.
Related courses
- Budgeting and Financial Planning for Organizations
- Financial Statement Analysis for Decision Making
- Advanced Financial Management Strategies
- Financial Performance Measurement and Analysis
Register for this course
Choose a city and date from the schedule above to register, or contact EuroQuest about in-house delivery for a finance or corporate development team.
All Course Dates & Locations
19 dates · 15 cities · Oct 2026 – Jul 2027