Track a commercial price action through staged customer repricing, contribution, invoicing, collection, and supplier-payment timing to see when the planned economics actually reach revenue and cash.
About this interactive
The analysis converts a commercial price action into four repricing cohorts: immediate, Day 30, Day 60, and a residual Day 90 cohort. Net price realization determines the incremental revenue each cohort produces after it becomes effective. Delivery or input-cost pressure begins independently on Day 0, while invoice, collection, and supplier-payment terms determine when the incremental economics reach cash. The result separates fully effective price uplift, revenue actually recognized inside the horizon, contribution after cost pressure, and cash realized after timing. No external pricing benchmark is imposed. The view supports pricing and cash review within our Private Equity FP&A practice.
Realization over time
The curve keeps the fully effective price path, cohort-based revenue recognition, contribution after cost pressure, and incremental cash on the same time axis.
Customer repricing cohorts
Each cohort begins generating price uplift only after its effective day. Cash arrives later by the entered invoice and collection lag.
Decision thresholds
The realization threshold solves for the minimum net realization needed to offset entered cost pressure by the end of the horizon. The collection ceiling shows the longest customer term that still leaves incremental cash nonnegative by that date.
What the interactive shows
PRIVATE EQUITY PRICING REALIZATION CURVE: ILLUSTRATIVE DEFAULT RECORD INPUTS Baseline 30-day revenue: $4,000,000 Baseline delivery / input cost ratio: 65.0% Announced price movement: 6.0% Net price realization: 85.0% Revenue repriced immediately: 30.0% Revenue repriced on Day 30: 40.0% Revenue repriced on Day 60: 20.0% Revenue repriced on Day 90 from residual cohort: 10.0% Cost base affected by delivery / input inflation: 60.0% Delivery / input cost change: 4.0% Invoice lag: 5 days Customer collection terms: 30 days Supplier payment terms: 15 days Review horizon: 90 days COMPUTED POSITION Net realized price movement: 5.1% Fully effective price uplift across horizon: $612,000 Price uplift recognized inside horizon: $387,600 Share of fully effective uplift recognized: 63.3% Incremental delivery / input cost inside horizon: $187,200 Net contribution inside horizon: $200,400 Incremental price cash collected inside horizon: $180,200 Incremental cost cash paid inside horizon: $156,000 Net cash contribution inside horizon: $24,200 Recognized price uplift still uncollected at horizon end: $207,400 Incremental cost accrued but unpaid at horizon end: $31,200 Contribution break-even: Day 31 Cash break-even: Day 81 Minimum net price realization for nonnegative horizon contribution: 41.1% Maximum collection terms for nonnegative horizon cash contribution: 35 days FINDING The entered 6.0% commercial price movement produces a 5.1% net realized price movement. Within 90 days, $387,600 of the $612,000 fully effective uplift reaches revenue, and $200,400 reaches contribution after $187,200 of delivery / input cost pressure. Only $24,200 has reached incremental cash by Day 90 because cohort timing and collection lag leave $207,400 of recognized price uplift uncollected. Contribution turns positive on Day 31 and cash on Day 81. Holding the other assumptions constant, collection terms above 35 days leave the price action cash-negative at the end of the horizon. METHOD STATUS Management-entered assumptions. Baseline daily revenue equals the entered 30-day revenue divided by 30. Net realized price movement equals announced price movement multiplied by net realization. Each pricing cohort begins generating incremental price revenue on its effective day. The residual share not assigned to the immediate, Day 30, or Day 60 cohorts is assigned to Day 90. Incremental delivery / input cost begins on Day 0 and equals baseline revenue multiplied by the entered cost ratio, affected-cost share, and cost change. Contribution is recognized price uplift less incremental cost. Incremental price cash is delayed by invoice lag plus customer collection terms; incremental cost cash is delayed by supplier payment terms. The realization threshold solves for the minimum net realization required for nonnegative contribution by the horizon. The collection ceiling is the largest whole-number collection term that leaves incremental cash contribution nonnegative by the horizon. No external benchmark, categorical score, or hidden weighting 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 .
