Wehrspohn Risk Management

Monte Carlo liquidity planning: is there enough cash?

October 27, 2026

“Is our liquidity sufficient?” The plan says yes, the simulation says: not in one case out of three. Questions every finance department knows: • “Will our liquidity last for the next three months, even if customers pay later?” • “How large does our credit line need to be, and with what level of certainty?” • “What happens if late payments never arrive at all?” • “How robust is our plan when we present it to the board or the bank?”

We calculated an example: a liquidity plan over three months with customer payments, ongoing outgoing payments and an investment. Some customer payments arrive a month late, and some of these late payments default entirely. Three views of the same plan: 1. Best case: all customers pay on time. The lowest liquidity is +€40k. That is an ideal case, but not a plan. Anyone who plans this way is wearing rose-tinted glasses. 2. Expectation-neutral plan. Delays and defaults are included at their expected level. The lowest liquidity drops to +€7k. That is realistic but tight, and it still requires no credit line. 3. Monte Carlo simulation with Risk Kit. Here, not only the expected value is calculated, but 100,000 possible paths. The result: In 32.6% of cases a credit line is needed, although the expectation-neutral plan does not provide for one. A €18k credit line covers 95% of cases. Anyone who wants to cover all simulated cases needs a liquidity buffer of around €42k. The key insight: a plan with customers who pay on time is systematically too optimistic. An expectation-neutral plan is more realistic, but does not show how strongly reality fluctuates around it. Only the simulation makes the uncertainty visible: how likely a shortfall is and how large it can become. This leads to concrete decisions about the size of the credit line, the dunning process or payment terms. Built in dialogue: we did not program the model, we built it in Excel in a conversation with an AI. We described the requirements, looked at the result and refined it (“Late payments should also be able to default”, “We plan expectation-neutral instead of with on-time payments”). Every number remains a traceable Excel formula, and all assumptions are separate and adjustable. The model is transparent, not a black box. The chart shows the result at a glance. Orange is the liquidity covered by the cash balance, blue is the part that has to be covered by the credit line. The expectation-neutral plan, the best case and the worst simulated case are also marked. Conclusion: with Risk Kit, the finance department answers the questions that the plan alone cannot answer. A plan becomes a decision that explicitly takes uncertainty into account. Would you like to try the model? Write to me and I will be happy to make it available to you.