Syntha Lab RU

Plan scenarios: base, optimistic, pessimistic

Compares the profit and cash of a plan in the base case and in two or three of your scenarios: price, volume, exchange rate, returns, discount depth, customers’ payment terms. You set the scenario shifts yourself in the table.

Scenarios and plan stress test For whom: Owners, finance directors and heads of a brand or chain when defending a plan and a budget.

Calculate on your data →

At a glance

What question does it answer?
What happens to profit and cash if the optimistic or the pessimistic scenario comes true.
What data is needed?
Plan sales, price, average discount, returns, cost and its rate-dependent share, variable and fixed costs.
How to read the result?
On the default data (50,000 pieces, price 3,000, discount 12%, returns 10%, cost 1,200, fixed costs 25 m) the base profit is 21,230,000 on revenue of 118,800,000 (17.9%). The optimistic scenario gives 35,356,010 and the pessimistic one (price −4%, volume −15%, rate +20%, returns +4 pp, discount +5 pp, payment 10 days longer) gives −1,629,148: 22,859,148 worse than the base and the cash is 23,530,583 worse because part of revenue is stuck in receivables. Example on the default values: Plan profit in the base case: RUB 21.2 million · 17.9%; Strongest scenario: profit: RUB 35.4 million · Optimistic; Weakest scenario: profit: −RUB 1.63 million · Pessimistic; Weakest scenario against the base: −RUB 22.9 million. The figures are illustrative: enter your own to see your result.

Why and how to reason

A plan with one number is a bet that everything goes as intended. Scenarios are needed to see how the plan reacts to shifts. Profit = revenue × (1 − variable) − sold × cost − returns × handling − fixed, where revenue = plan × (1 − returns) × price × (1 − discount). Base: 50,000 units × 90% × 3,000 × 88% = 118.8 million; after variable costs of 15%: 100.98 million; cost 45,000 × 1,200 = 54 million; return handling 0.75 million; fixed 25 million: profit 21.23 million. Scenario “Pessimistic”: price −4%, volume −15%, exchange rate +20% (70% of cost depends on the rate), returns +4 pp, discount +5 pp, payment 10 days longer. Profit −1.63 million: 22.9 million below base. Cash is even worse: −23.5 million because receivables grow. Scenarios are not probabilities but a strength test.

When to use it

It fits when drafting an annual budget, a seasonal plan and before talking to a bank or investor. It suits a brand and a retailer. It does not replace the “Plan sensitivity” calculation: scenarios change factors together, sensitivity one at a time. Assumptions: shifts are set by you in the table; the share of cost depending on the exchange rate is your estimate; the plan period is set in days; receivables are counted through the customers’ payment term.

How to read the result

First the weak scenario against base: profit and cash. If the weak scenario goes into loss decide in advance what you will do first: cut purchasing, shift fixed costs, agree a limit. Compare the profit gap and the cash gap: if cash is worse you have a cash-gap risk even with a small profit. The strong scenario shows how much extra capital is needed if growth occurs. Understand which factor contributes most: the “Plan sensitivity and breaking point” calculation answers. The decision: cash reserve, purchasing limits, action triggers. It is worth recording scenarios and triggers in the plan: at what value of a factor you launch which action.

Common mistakes

Setting shifts at random with no link to each other: a discount usually raises volume and a rising exchange rate pulls up price. Making the pessimistic scenario too soft so the plan “looks good”. Assuming a scenario predicts: it shows the plan’s reaction to shifts, not probability. Not accounting for how shifts change cash through receivables.

What data is needed?

  • Plan sales, price, average discount, returns, cost and its rate-dependent share, variable and fixed costs.
  • The customers’ payment term and the length of the period.
  • Your scenario shifts from the worst periods of past years.

Inputs

FieldUnitValue in the exampleMeaning
Planned sales before returnspcs50,000How many pieces go to customers in the plan period; returns are deducted below. The example value is illustrative.
Price excl. VAT before discounts₽3,000Amount excl. VAT: the general rate is 22% from 01.01.2026 (law of 28.11.2025 No. 425-FZ, a guide as of 13.11.2026, check against the act text). The rate follows the shipment date; confirm your regime and rate with an accountant.
Average discount depth from the price%12The average over the sales of the whole period: the share of the price lost to discounts across the stages BS, IS, AS and SO: before the sale, in the sale, after it and the final sell-out (your company may name them differently). Stage breakdown: the “Season results” calculation. An example, not a standard.
Returns in pieces%10The share of sold pieces that came back. Returned goods go back to stock at cost.
Unit cost at the warehouse₽1,200Full cost: fabric, sewing, delivery, duty.
Share of cost that depends on the exchange rate%70Purchases in foreign currency and duty on the foreign-currency value: count from your contracts. The rest (roubles) does not depend on the rate.
Variable costs in revenue%15Commissions, advertising, delivery to the customer, acquiring: a share of revenue.
Return handling, per piece₽150Receiving, checking, repacking, return delivery.
Fixed costs for the period₽25,000,000Rent, payroll, office, depreciation: what does not depend on sales.
Customer payment term in the base casedays20How many days on average money takes from shipment to the account. Used to show cash frozen in receivables.
Length of the plan perioddays365A year is 365 days, a season is usually 120–200. Used to turn the payment term into the receivables amount.

How it is calculated

StepFormula
Revenueplan × (1 − returns) × price × (1 − discount)
Cost in the scenariocost × (1 + rate-dependent share × rate rise)
Profitrevenue × (1 − variable) − sold × cost − returns × handling − fixed
Cash vs baseprofit difference − (scenario receivables − base receivables); receivables = revenue × payment term ÷ period

Worked numbers

Default values from the app; in the interactive version you enter your own.

Plan profit in the base case
21.2 m ₽ · 17.9 %
Strongest scenario: profit
35.4 m ₽ · Optimistic
Weakest scenario: profit
−1.63 m ₽ · Pessimistic
Weakest scenario against the base
−22.9 m ₽The profit difference: how much of the plan is lost if the worst of your scenarios comes true.
Cash of the weakest scenario against the base
−23.5 m ₽The profit difference plus the change of cash in receivables: the payment term grows and part of revenue arrives later.
Scenarios with a loss (with the base)
1
Plan profit by scenario
Bar chart: Base 21.2m, Optimistic 35.4m, Pessimistic −1.63m−10m010m20m30m40mBaseBaseProfit: 21.2m21.2mOptimisticOptimisticProfit: 35.4m35.4mPessimisticPessimisticProfit: −1.63m−1.63m₽
Data as a table
MeasureProfit
Base21.2m
Optimistic35.4m
Pessimistic−1.63m

Scenarios against the base

ScenarioRevenueContribution before fixed costsProfitProfit vs baseCash vs base
Base118.8 m ₽46.2 m ₽21.2 m ₽——
Optimistic140.7 m ₽60.4 m ₽35.4 m ₽14.1 m ₽14.9 m ₽
Pessimistic87.4 m ₽23.4 m ₽−1.63 m ₽−22.9 m ₽−23.5 m ₽

In the scenario “Pessimistic” the plan goes to a loss of −1.63 m ₽: decide beforehand what you will do first (cut the buy, defer fixed costs, agree a credit line) rather than after the scenario has come true.

Scenarios are not probabilities: three rows show how the plan reacts to shifts, not what will happen. Which factor is the most dangerous is shown by the “Plan sensitivity and breaking point” calculation.

Nuances and limits

  • Take scenarios from your own worst periods rather than inventing them: there is no single standard for shifts.
  • Three rows are not probabilities: they show the plan’s reaction, not a forecast.
  • Discount and volume are linked: set them together in one scenario.
  • Cash against the base takes only profit and receivables: stock and payments are in the cash plan.

Terms used

Calculate on your data →