BalanceCheat
ENDE

Handbook / Analyze

Reverse with multiple variables

Search combinations of supported changes and express relative preferences through weights.

Methods and settings

Method / inputBehavior
Up to twelve variablesEach variable needs valid bounds and a current eligible source.
WeightPositive relative change penalty, from 0.000001 to 1,000,000.

Several ways can reach the same target

A target may be achievable through different combinations of price, cost or other supported assumptions. Set plausible individual ranges before solving. A wide range allows the search more freedom and affects how normalized change is judged. Do not add variables solely because they are available; each additional degree of freedom can make the result harder to explain.

Weights are soft preferences

For explicit-goal problems, weighted normalized distance favors smaller changes from current assumptions. A larger weight discourages change in that variable relative to others. It is not a hard priority order and does not freeze the input. Use narrower bounds, a suitable allowed-value restriction or remove a variable when change is not permitted.

Review the combined economics

The candidate is recalculated as a combination, so its effect need not equal the sum of separate one-variable effects. Inspect every proposed change and its source. In Ownership, analytical transaction evaluation remains separate from applying a closing. In 13W, variables belong to the selected plan and supported source or operational override. Do not assume a cross-domain target changes every domain’s stored assumptions.

Open in the financial model ↗

Documents the current implemented behavior. Numerical examples are synthetic, not market assumptions.