In Chapter 7, the cash forecast showed £480 left at the end of Month 2. Move one £600 customer payment to Month 3 and Month 2 ends £120 short of the money it needs. Month 3 still ends with £870. A plan can look fine again later while the business needs a decision much earlier.
To stress-test a plan is to change an assumption and see what happens when the business has less room to manoeuvre. Start with the forecasts you already have. You’ll test one change at a time, compare three versions of the plan, and write a decision trigger that says when to act, who will act and what they will do. The aim is to give yourself enough time to make the decision before a bill, a launch commitment or a milestone comes due.
Figure 1. Follow a change through the forecast and turn the result into a decision.
1. Save the plan you expect to use
The base case is the version of the forecast you currently use to plan. Its assumptions should reflect the best evidence you have at the time. That could include written supplier prices, recent customer receipts, planned sales volumes or a dated agreement about funding. Give the base case a date and keep a copy. When the evidence changes, you can compare the revised plan with the one you started from (British Business Bank, no date).
Bring two forecasts together. The profit and loss forecast, or P&L, estimates what the business will earn and the costs it will incur over the period. The cash flow forecast shows when money would actually be expected in and out. A delayed receipt can affect the cash plan while leaving the revenue already earned in the same P&L period. A change to price, sales volume or cost may affect both forecasts. Trace each effect to the period where it belongs.
In the Chapter 7 example, the business opens with £300 cash, delivers 20 units a month at £60 each, pays £18 per unit in direct operating costs and pays £450 a month in other operating expenses. In the base case it collects half of each month’s sales in that month and half in the next month. There are no earlier invoices to collect at the start of Month 1. For this calculation, all the direct and other operating costs are paid in the month they arise. The starting sales are £1,200 a month, cash payments are £810 a month and operating profit is £390 a month.
Write down exactly what you’re changing. Testing a late payment should start from the same opening cash, sales volumes and payment dates for the other items. Testing a lower price should start from a stated volume and cost. Test results are easier to trust when you can identify which assumptions produced them.
2. Choose a sensitivity test or a scenario
A sensitivity test changes one input at a time so you can see how strongly the result depends on it. Examples include one invoice clearing later, one supplier raising its unit price or one selling price changing while sales volume stays fixed. If several forecast lines depend on the input, recalculate those lines. Changing sales volume will often change total sales, direct costs and the related cash receipts even though only one input moved.
A scenario describes a possible situation in which several related assumptions can move together. For example, some customers order less in one month and a receipt you expected to cover its costs is late. Choose a set of changes that could reasonably occur together and explain what makes them plausible. Both techniques help you check where the plan is exposed and what would change your decision (HM Treasury, 2026).
Figure 2. Use a single change to isolate an effect and a scenario to explore how changes interact.
Start with assumptions that could alter an upcoming commitment. Pick the biggest uncertain receipt, a major cost that still needs a quote or the sales needed to cover a new expense. If you have recent evidence, use it to set a meaningful change. For customer payment timing, compare when invoices were due with when they cleared. For a supplier cost, use the range in recent quotes or likely order sizes. If all you have is an estimate, label it and make a note of what you can check.
Use the same output measures across tests. For early decisions, note the first date cash falls below your cash floor, the lowest balance, and the gap to the floor. The cash floor is the minimum balance you want to keep available. Where the test changes trading, record operating profit and whether the sales needed to cover costs have changed. Use the same dates and definitions so you can compare the results.
3. Test one late customer payment
The base case ends Months 1, 2 and 3 with £90, £480 and £870 respectively. Use the same £100 cash floor as Chapter 7. Month 1 is already £10 below that floor at month end. The weekly breakdown from Chapter 7 shows a deeper low of −£210 in Week 3. That early issue needs its own action and remains relevant when you test Month 2.
Figure 3. Keep the base case and carry forward the earlier cash problem you already found.
Change just one date. The £600 owed from Month 1 sales moves from Month 2 to Month 3. The other £600 expected in Month 2 still clears, and payments remain £810. Month 2 starts with £90, so £90 + £600 − £810 = −£120. The closing balance is £220 below the £100 floor. If the delayed receipt does clear during Month 3, that month’s closing balance returns to £870.
Figure 4. A late payment can create a cash gap in an earlier month, even if the plan recovers later.
The negative balance is the amount of cash that would be missing if all the payments went ahead on those dates without another change. The £120 shortfall to zero and £220 gap to your chosen reserve answer different questions. You can record both. When you look at Month 2 by week or by day, the figures can be larger, depending on which receipts and payments happen first.
For this test, delivery and the amount owed stay the same. The simplified P&L therefore still includes the revenue in the period in which the sale was made. If new evidence indicates some of the invoice may never be collected, that is a different issue. Review the amount you expect to recover and the related accounting treatment as well as the cash dates.
4. Test a change in selling price
Use a separate sensitivity test and return to the base assumptions. Suppose you try a lower price of £57 instead of £60 for one month. Use 20 units to isolate what the price alone does. Keep direct operating cost at £18 per unit and other operating expenses at £450 for the month. Revenue becomes £1,140, direct costs stay £360, and operating profit falls from £390 to £330. At the same volume, the £3 price cut across 20 sales reduces operating profit by £60.
Figure 5. A lower price changes the amount left from each sale to cover regular costs.
Contribution per unit is the selling price minus the variable cost of one unit. It falls from £42 to £39 in this calculation. Using the £450 of monthly fixed costs, you need 11 whole units to break even before the price cut and 12 whole units after it. Divide fixed costs by contribution per unit and round up, since the business must sell whole units here. Chapter 5 explains the break-even calculation in more detail.
Under the same half-now, half-next-month payment pattern, a £60 reduction in sales would reduce cash receipts by £30 this month and £30 the following month. This assumes the lower price applies only to this month’s sales. If you keep the price down for longer, carry the new price and payment pattern into each affected month.
Next, ask what you would need to learn before turning the change into a pricing decision. To match the original £390 monthly operating profit at £57, you need to generate £840 of contribution to cover £450 of fixed costs and earn £390. Divide £840 by £39 and round up. You need 22 units on those assumptions. Can you deliver them with the same costs? Have buyers responded to that offer? A second test can change the expected volume and add any cost of serving the extra customers. Keep a clear link between the reasons for the price change and what you assume will happen next.
5. Build a base, upside and downside case
A useful comparison has three versions. The base uses the assumptions you currently plan from. The upside explores a plausible improvement. The downside explores a plausible problem. Use the same Month 1 opening cash and track the same measures in each. Name each change, keep the opening balances consistent and record the evidence or event that would make that case more likely (HM Treasury, 2026).
For the upside, test what happens if all customers agree to pay in the month they receive the goods. Keep 20 units at £60 and £810 of payments each month. With receipts of £1,200 each month, closing cash becomes £690, £1,080 and £1,470 in Months 1, 2 and 3. Operating profit remains £390 per month. Forecast the receipt dates within each month before concluding that earlier bills can be covered. The higher month-end balance alone does not tell you which week the money clears.
For the downside, test two linked assumptions. A difficult Month 2 brings 16 deliveries instead of 20, and the £600 owed from Month 1 clears one month later than expected. Month 2’s sales are £960. Half, £480, clears in Month 2. Cash payments in Month 2 are £738 because direct costs fall to 16 × £18, while the £450 of other operating expenses stays the same. Closing cash is £90 + £480 − £738 = −£168.
Figure 6. Compare each case at the same points in time. Check cash within a period where a bill or receipt could change the decision.
Month 2’s operating profit falls to £222, calculated as £960 in sales minus £288 of direct costs and £450 of other operating expenses. The business might still record a profit while facing £168 of missing cash for all planned payments, or a £268 gap to the floor at month end. Cash and profit should each have their own row in your working file.
Figure 7. The downside changes both trading performance and cash timing.
In Month 3 of the downside, sales return to 20 units. Cash receipts are £1,680, made up of £600 from the late Month 1 receipt, £480 from Month 2 and £600 from Month 3. The business pays £810 as in the base case. Month 3 closes with £702. Timing explains the sharp dip in Month 2. The lower volume also reduces the profit earned and leaves the business with £168 less cash than the base case by the end of Month 3.
Keep the reasons behind changes visible. If the cause of the sales drop would also affect future orders, update the affected months. If some direct costs were already committed before the orders fell, reducing volume may save less cash than this arithmetic assumes. If the missing sales are rebooked later, forecast that change when you have evidence. The effects should follow the assumptions you have written.
Check which decision each case tests. In the upside, the same sales come in as cash sooner. If you want to use that balance to take on more work, first check whether the earlier payment terms are agreed and when the money will clear. In the downside, one response may protect immediate cash while another addresses fewer orders. Agreeing a part payment could help with this month’s bills, while understanding why four units were lost helps you revise later sales. Keep both reasons visible when you choose what to do.
An upside and a downside describe possibilities. They can be useful without assigning a probability to either. If you have little evidence about how often an event occurs, write what would make it plausible and what you would notice first. Update the plan when that evidence arrives. For this calculation, the three-month comparison stops at Month 3, so the £600 still owed from Month 3 under the base and downside cases belongs on the Month 4 cash calendar.
6. Find the threshold and set the decision trigger
A threshold is the point where the result reaches a limit you have chosen. In this example, the threshold is the £100 cash floor. You can also ask for the smallest change needed to stay at or above it. Return to the single late-receipt test where Month 2 still has 20 deliveries. Before collecting any of the £600 owed, Month 2 closes at −£120. To reach £100 at month end, collect at least £220 from that invoice inside Month 2, with the other cash movements as forecast.
Figure 8. Work backwards from the cash floor to find the amount you need.
A decision trigger says when a condition should change what you do. It can be based on a forecast result or on a piece of evidence. For the invoice here, a trigger could be “If the customer has not confirmed a payment of at least £220 by the review date, bring forward the cash review before committing to discretionary spending.” A discretionary payment is one you can choose whether or when to make. Set the review date from the bill calendar, check whether any week needs more than the month-end calculation, and name the person who will act (ICAEW, 2022).
Figure 9. Give the response enough lead time before the forecast shows a gap.
Set the trigger early enough to negotiate or make a different decision. If a large payment is due on Friday and you need three working days to agree a change, mark Tuesday as the latest day to begin the response, allowing for any settlement delay. The actual date depends on the contract terms, who must agree and how payments clear. Recheck the specific day and amount in your forecast. A £220 adjustment that arrives at the end of the month does not solve a gap earlier in that month.
Figure 10. Keep the evidence, decision and person responsible together.
For the late receipt, the owner could be the founder in charge of invoicing. The first action could be to confirm the invoice is approved and agree a date for a part payment. The fallback could be to pause a non-essential purchase before it is committed or seek agreed changes to eligible payment dates. Keep confirmed terms separate from possible responses. If you later agree a change, put the new amounts and dates into the forecast and check which gap it actually solves.
If your test concerns sales volume instead of a receipt, the owner and action can change. For example, the person responsible for sales can review whether a planned price cut is likely to bring enough extra orders. A decision deadline before the new price goes live gives you time to change the offer or the launch plan. Set a review date so you can see whether the action made the forecast more realistic.
7. Keep the scenarios aligned over three years
Build the base, upside and downside on the same rolling 36-month plan. Compare cash month by month in Year 1, with weekly or daily detail near significant bills, funding or a projected shortfall. In Years 2 and 3, use quarterly figures for sales, costs, cash movements and key milestones. Keep dates for major commitments that can create a gap within the quarter. Compare annual operating profit, the year-end cash balance and the lowest dated balance you can support with the forecast detail.
Figure 11. Apply the same date range to each case and add detail where timing matters.
Check the effect on the business plan. If the downside pushes a cash-funded equipment purchase beyond the earliest safe date, see whether the launch or delivery milestone also has to move. The updated milestone may then move receipts and expenses. Keep the link between the main risk, the financial assumption and the delivery decision. That way you can explain which part of the plan changed and why.
Review scenarios when you learn something that matters. The invoice clears, a supplier confirms a new quote, or the first months of trading provide better evidence about demand. Record the actual amount and date, revise the assumptions that depend on it, and update the scenarios that remain plausible. Save the earlier version if you need to compare what you expected with what happened (British Business Bank, no date).
Figure 12. Keep the forecasts and the planned response current as evidence arrives.
Use the same period-end dates in every case so you can compare them side by side. When you move the plan forward, anchor each case to the latest available cash at the start of the next period. A case with different future receipts can share that starting balance. Compare the dated gaps again. For example, if the delayed invoice clears sooner than expected, check which remaining commitments still require a decision and keep the risk to later sales visible if that concern remains.
8. Save the test and trigger in Startup Builder
Open Stage 7 · Financial Planning and use Revenue Forecasts, Cost Forecasts, Profit And Loss and Cash Flow Forecast to gather the base assumptions and results. Compare the cases in your working forecast using the same periods. If your workspace shows a shorter range, keep the full 36-month view with the assumptions and worksheet. Open Startup Builder
Save the condition and planned response under Risk Assessment. Include the date of the first gap, the response, the person responsible and the date when work on the response needs to begin. Put the effect on any major milestone in Stage 9 · Business Plan Finalization. If you don’t yet have the relevant evidence, record the next thing you’ll check and when.
Check your understanding
What changed in the one-receipt test? The date of the £600 receipt moved from Month 2 to Month 3. The test holds sales and other cash movements fixed.
Why is Month 2 operating profit £222 in the downside when closing cash is −£168? The P&L uses the £960 earned and the £738 in costs. Cash starts at £90 and collects only £480 that month while those costs are paid.
What is the late-receipt test’s month-end gap to the cash floor? The forecast ends at −£120 before any payment on the overdue invoice. It needs £220 to reach £100. Check earlier dates separately.
What makes a trigger useful? It names what to watch, when to act, who will act and what they will do in time to change the result.
Two videos to watch
Leila Gharani (2022) · Excel What-If Analysis Data Table. Watch 0:16–4:47 for a demonstration of testing one input. Use the technique to compare £60 and £57 while keeping the volume at 20. You can also do this by hand using Figure 5. Watch the segment on YouTube
Corporate Finance Institute (2026) · Scenario Planning and Sensitivity Analysis in Uncertain Markets. Watch 3:11–5:06 for examples of how a downside case can affect decisions about hiring, prices and stock. Pick one commitment in your plan and ask what would cause you to delay it. Watch the segment on YouTube
Continue learning
Next comes Chapter 9 · Choose a UK business structure. Bring the names of the people who expect to own and run the venture, the planned commitments and the types of finance you may want. Those details can affect which options make sense.
References
British Business Bank (no date) Reforecasting in uncertain times. Available at British Business Bank (Accessed 17 November 2026).
HM Treasury (2026) The Green Book (2026). Available at GOV.UK (Accessed 17 November 2026).
ICAEW (2022) Nine principles for finance professionals: adapting cash flow processes, analysis and forecasting. Available at ICAEW (Accessed 17 November 2026).
Check whether your startup idea can pay its bills, meet the requirements for trading and move forward. Build a one-page decision using a rolling three-year plan with a more detailed first year.
Build a rolling three-year cash flow forecast. Learn when money will arrive and leave, how much cash is tied up in stock and unpaid invoices, and when you may need to act.
Compare funding options using the amount you need, the date you need it and what you’ll owe or share afterward. Test your choice in a rolling three-year plan and decide what to do if the money arrives late.