← Back to selected work

Forecasting & scenario analysis

Numtech Financial Forecast & Sensitivity Simulation

A finance-led forecast dashboard connecting historical performance, CAGR-based projections and upside/downside scenarios in one decision-ready view.

My roleFinancial analysis & dashboard design
ToolsPower BI · Forecasting · Scenario analysis
TypePortfolio demonstration
Numtech Financial Forecast & Sensitivity Simulation dashboard overview

The brief

From business question to decision-ready view.

01

Business question

Forecast discussions become difficult when the historical base, growth rate and scenario assumptions are spread across separate worksheets or presented without a clear visual relationship.

02

The approach

  • Established a historical reference period and extended it into a defined forecast horizon.
  • Used CAGR-based projections to create a consistent baseline for future performance.
  • Added visible upside and downside parameters so the impact of changing assumptions can be reviewed quickly.
03

What the sample data shows

Figures below describe the displayed portfolio dataset, not a client outcome.

  • The displayed overview uses 2020–2024 as the actual period and 2025–2035 as the forecast period.
  • The sample forecast shows an 8.77% CAGR across the selected view.
  • Upside and downside scenarios make the effect of alternative forecast assumptions visible alongside the baseline.
04

Decisions this supports

  • Actual-versus-forecast performance story
  • CAGR-based projection with scenario ranges
  • Transparent inputs for planning and sensitivity review

Interactive report

Explore the dashboard.

Use the report controls to navigate pages, filter the data and inspect individual views.

Numtech Financial Forecast & Sensitivity Simulation dashboard preview

The interactive report is best viewed in a larger window.

Open interactive report (opens in a new tab)

Public portfolio report. The demonstration data is intentionally non-confidential.

Open report in a new tab (opens in a new tab)

Simulation walkthrough

Make the forecast easy to pressure-test.

The Numtech view connects historical results to a forecast period, then makes the assumptions and scenario ranges visible enough to support a practical planning conversation.

Start a conversation

Have a similar reporting or modelling question?

Share the decision you need to support and the data or report you already have.

Work

Explore all
case studies.

Browse the complete portfolio of dashboards, models and reporting work. Choose another case study without leaving this page.

Use the arrows or swipe to browse the full case-study library.