Skip to main content
Financial Projections
Updated over 3 weeks ago

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:

  1. WhiteCalculated value (If enclosed in a box, it can still be updated manually.)

  2. GreenDefault value or sourced from Benchmarking data.

  3. BlueManual input.

  4. RedInvalid 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.

Did this answer your question?