In the ValuPlan module, the Financial Projections is designed to simplify and enhance your financial forecasting process.
Financial Projections
The historic and forecast financials are displayed in three sections:
Actuals
Phase 1+2 (Budget & Projections)
Terminal Year
Color Coding Methodology
Cell colours indicate how values are derived:
White – Calculated value (If enclosed in a box, it can still be updated manually.)
Green – Default value or sourced from Benchmarking data.
Blue – Manual input.
Red – Invalid entry (e.g., a negative number where a positive value is required).
Navigation & Formatting Options
Expanding or Collapsing Data
Use the +/- button (top left) to expand or collapse data by one level.
Selecting a Projection Case
Users can switch between different projection cases:
Lower Case – 25th percentile
Base Case – Median
Upper Case – 75th percentile
Formatting Styles
On the right side of the screen, users can toggle between:
Black fonts – Read-only mode.
• Coloured fonts & backgrounds – Highlights manual inputs, peer-based estimates,
and platform calculations.
Modifying Financial Projections
You can modify projections (actual values, growth percentages, margins, or ratios) by clicking on a cell and updating the value.
Additionally, you can choose how forecasts are calculated by selecting one of the following methods:
1. Benchmarking Data
The selected projection case (Lower Case, Base Case, or Upper Case) determines the applied growth %, margin, or ratio based on peer group data.
2. Keep % Constant
The growth %, margin, or ratio remains fixed into the future based on:
The first forecast year.
The last actual year.
3. Interpolate %
This method applies incremental interpolation, adjusting a known rate, margin, or ratio over time.
The base value is set at the beginning of the period, and a fixed increment is applied each period until the Terminal Year.
Interpolation is only applied to non-manual entry cells between two manual input
values.