Quantify the EBITDA range around the latest forecast, separate commercial slippage from cost exposure, and see how much of a current-period downside is recovered or persists into the next period.
About this interactive
The analysis starts with the entered current-period EBITDA forecast, isolates revenue still dependent on open assumptions, translates downside and upside realization through the entered contribution margin, and applies cost variance to the exposed cost base. The downside case then rolls into the next period using entered revenue-recovery and cost-persistence assumptions. A separate threshold solves for the current-period revenue realization required to protect the entered EBITDA decision floor. The range is a management scenario, not a statistical confidence interval. The view supports forecast review within our Private Equity FP&A practice.
Current-period decision range
The center point is the entered EBITDA forecast. Commercial realization and exposed-cost variance determine the downside and upside bounds. The decision floor remains independent of the range.
Downside economics
The current-period downside separates commercial slippage and cost pressure, then rolls both into the next period. Revenue can recover later; cost pressure can persist. Those two paths do not reverse symmetrically.
Decision threshold
The threshold holds the downside cost variance constant and solves for the realization of assumption-dependent revenue required to keep current-period EBITDA at the entered decision floor.
What the interactive shows
PRIVATE EQUITY FORECAST CONFIDENCE RANGE — ILLUSTRATIVE DEFAULT RECORD INPUTS Current-period EBITDA forecast: $4,500,000 Next-period EBITDA forecast: $5,000,000 Revenue embedded in current forecast: $30,000,000 Revenue still dependent on open assumptions: $7,000,000 Contribution margin on assumption-dependent revenue: 45% Downside current-period realization: 65% Upside current-period realization: 105% Share of downside revenue slippage recovered next period: 70% Cost base exposed to unresolved movement: $6,000,000 Downside cost variance: +7% Upside cost variance: -2% Share of downside cost pressure persisting next period: 50% Current-period EBITDA decision floor: $3,500,000 COMPUTED POSITION Revenue not dependent on open assumptions: 76.7% Downside revenue EBITDA impact: −$1,102,500 Downside cost EBITDA impact: −$420,000 Current-period downside EBITDA: $2,977,500 Current-period upside EBITDA: $4,777,500 Current-period forecast range width: $1,800,000 Downside position versus EBITDA floor: −$522,500 Revenue slipping from current period in downside case: $2,450,000 Revenue recovered next period: $1,715,000 Next-period EBITDA recovery from slipped revenue: $771,750 Next-period persistent cost impact: −$210,000 Permanent revenue loss after entered recovery: $735,000 Two-period downside versus the two forecast baselines: −$960,750 Current-period realization required to protect EBITDA floor under downside cost variance: 81.6% Gap from entered downside realization to required realization: 16.6 percentage points FINDING The latest $4,500,000 EBITDA forecast carries a current-period range from $2,977,500 to $4,777,500 under the entered commercial and cost conditions. The downside case falls $522,500 below the $3,500,000 decision floor. Protecting that floor under the entered downside cost variance requires 81.6% realization of assumption-dependent revenue, versus the entered 65% downside case. Of the current-period downside, $771,750 of EBITDA is recovered next period through delayed revenue, while persistent cost pressure leaves the two-period position $960,750 below the two forecast baselines. METHOD STATUS Management-entered assumptions. The current EBITDA forecast is the center point. Revenue realization affects EBITDA through the entered contribution margin. Cost variance is applied to the entered exposed cost base. Current-period downside and upside EBITDA equal the center forecast plus commercial and cost effects. Revenue not realized in the downside case can move into the next period at the entered recovery share, while downside cost pressure can persist at the entered persistence share. The two-period downside compares those timing and persistence effects with the two entered EBITDA forecast baselines. Required realization solves for the current-period realization rate needed to protect the entered EBITDA floor under the downside cost variance. No statistical confidence interval, probability model, external benchmark, or hidden score is used.
Continue your analyses, email calculation records, and return to your work from one account.
By creating an account, you agree to the Terms of Use and acknowledge the Privacy Policy.
Enter the 6-digit code sent to .
