How much family harmony can a spreadsheet buy?

None. But transparency can change the discussion.

Three family shareholders.

Three visions of the future.

One company.

And a shared capital.

The first wants to invest.

The second wants to secure liquidity.

The third wants higher dividends.

All three may have valid points.

And yet a discussion about capital can very quickly turn into something else.

A discussion about power. Trust. The past. Responsibility. Recognition. And about who ultimately makes the decision.

Then perhaps there’s an Excel file on the table.

But the real conflict isn’t contained in any cell.

How much family peace can a spreadsheet buy?

None.

No spreadsheet can build trust.

No business case can resolve a generational conflict.

No algorithm can repair family relationships.

And no mathematical optimisation can decide which personal expectations within an entrepreneurial family are right.

But transparency can change what people are arguing about.

Perhaps the family is arguing about two completely different things

Part of the conflict is personal.

Who bears responsibility?

Who wields what influence?

Who feels heard?

Which past decisions are still having an impact?

What role should the next generation take on?

These questions cannot be solved mathematically.

But there is often a second part to this.

What happens to cash flow when we invest?

How does liquidity change?

Which projects will then be unable to be financed?

How does debt develop?

What expected value contributions will arise?

How much capital is available for distributions?

What strategic options will remain in three or five years’ time?

This aspect is at least partly predictable.

And it is precisely these two levels that should not be confused

When a family is discussing an investment of EUR 50 million, a difference of opinion can feel very personal.

Shareholder A says:

“We need to grow now.”

Shareholder B says:

“We’re taking too much of a risk with this.”

Shareholder C says:

“The company must finally start paying out more again.”

At first glance, three people are at odds with one another.

But perhaps, initially, it is three different capital strategies that are at odds with one another.

Growth.

Security.

Distribution.

That is a crucial difference.

Don’t debate the people. Calculate the scenarios.

What happens if we don’t evaluate the three positions initially?

We calculate them.

SCENARIO 1: GROWTH

A larger proportion of the available capital is invested in growth, new capacity, technologies or markets.

Which projects would be financed?

What are the expected value contributions?

How will liquidity and debt levels develop?

What future capital requirements will arise?

SCENARIO 2: SECURITY

Liquidity, debt and financial resilience are given higher priority or subject to tighter limits.

How does this change the investment portfolio?

Which projects will be postponed?

What expected value contribution might be foregone?

What financial leeway remains?

SCENARIO 3: DISTRIBUTION

The owners define a higher distribution or a specific distributable financial leeway as an additional condition.

What capital will then still be available for investment?

Which projects remain financially viable?

Which growth options are changing?

And what economic consequences will this have?

Suddenly, the discussion changes

Previously, it might have been:

“You’re always just focused on growth.”

Now it is

:

“The growth scenario will tie up X more capital over the next three years.”

Previously:

“You’re far too cautious.”

Now:

“If we stick to this liquidity limit, Project B will be delayed by two years.”

Previously:

“All

you care about is dividends.”

Now:

“With this dividend policy

,

Y less will be available for the investment portfolio.”

The disagreement does not disappear.

But it takes on a different structure.

Mathematics separates the quantifiable part of the conflict from the personal part

This is perhaps one of the most interesting tasks of Decision Intelligence in a family business.

Not resolving conflicts.

Not eliminating emotions.

Do not determine which shareholder is right.

Instead,:

isolate

the part of the discussion that can actually be examined using data, assumptions, criteria and constraints.

What remains afterwards may well be the actual ownership conflict.

And that is precisely what can be valuable.

What is a figure – and what is an attitude?

The expected investment amount is a figure.

Available liquidity is a figure.

The maximum level of debt can be defined as a limit.

The expected cash flow can be modelled.

Project dependencies can be documented.

Resources can be limited.

But:

How much risk is the family willing to bear?

How important is independence?

How much of the family’s wealth should remain in the business?

To what extent should the next generation be allowed to invest?

What level of dividend does the family consider appropriate?

These are decisions for the owners.

Mathematics can calculate the consequences.

It cannot, however, replace the decision itself.

Transparency does not mean agreement

That is important.

A transparent calculation may even show that two positions are in fact far apart.

Perhaps there is no simple compromise.

Perhaps a higher dividend payout does indeed lead to significantly lower growth.

Perhaps the desired expansion cannot be reconciled with the defined debt limit.

Perhaps it is not possible to maximise investment, maximise distributions and maintain maximum liquidity all at the same time.

Transparency does not reduce trade-offs.

It makes them visible.

And sometimes that is precisely what governance is all about

Good governance does not mean that all shareholders always agree.

Nor does it mean that every decision is made on a purely mathematical basis.

Among other things, it means providing clarity on:

What are our objectives?

What criteria do we use?

What limits apply?

What assumptions underpin our decision?

What consequences are we prepared to accept?

And who, ultimately, has the authority to make decisions?

The quality of a decision does not stem from harmony alone.

It also stems from a transparent decision-making process.

The shared model changes the language

This can be particularly relevant for family businesses.

This

is

because different shareholders may have different levels of information.

The operational shareholder is familiar with the business on a day-to-day basis.

Another shareholder may not be involved in day-to-day operations.

The next generation is looking at new technologies.

The founder has decades of experience.

The CFO focuses on financing and liquidity.

Everyone brings a different perspective to the table.

A shared decision-making model does not force these perspectives to agree.

But it can bring them onto the same data foundation.

Same data. Different assumptions.

That is an important distinction.

The family doesn’t need to argue about which figures each person wants to use.

They can start by defining a common data set.

And then deliberately calculate based on different assumptions.

What happens with higher growth?

What happens with lower growth?

What happens with higher minimum liquidity?

What happens if the debt limit is lower?

What happens if the dividend payout is higher?

What happens if a strategic business unit must be retained at all costs?

Then it becomes clear which assumption leads to which consequence.

Perhaps the conflict does not lie where everyone assumes it does

Shareholders may disagree about Project A.

Once the figures have been crunched

,

it may turn out that:

Project A isn’t the real problem at all.

The real difference lies in the debt limit.

Or in the dividend policy.

Or in the balance between growth and liquidity.

Or in the question of how much financial leeway the family wishes to preserve for the next generation.

This shifts the discussion from the symptom to the underlying assumption.

Family peace is not an optimisation target

Family peace cannot be maximised in the same way as a financial contribution.

Trust has no clear unit of measurement.

Respect is not a KPI.

The past cannot be written into a constraint line.

And personal relationships do not belong in an optimisation algorithm.

That is how it should remain.

Decision Intelligence should not attempt to exclude people from an ownership decision.

It should provide precision where precision is possible.

Mathematics has its limits

It can calculate:

Which combination of projects emerges under defined conditions.

How different budgets impact outcomes.

Which constraints rule out which projects.

How different strategic priorities affect a portfolio.

What trade-offs arise between scenarios.

It cannot calculate:

Who should apologise.

Who feels overlooked.

Which generation deserves more recognition.

Or how a family wishes to interact with one another.

It is precisely this boundary that makes the application credible.

The Owner’s Decision

Perhaps, therefore, the next difficult discussion amongst shareholders should not begin with the question:

“Who is right?”

But

rather:

“Which part of our disagreement can actually be quantified?”

Then scenarios can emerge.

Growth.

Security.

Distribution.

Or a jointly defined fourth option.

The financial implications become clear.

The trade-offs become clear.

And ultimately, the decision remains where it belongs:

with the owners.

How much family peace can a spreadsheet buy?

None.
But transparency can change the conversation.

OWNER’S DECISIONS
The decisions you can’t delegate.

CALCULATE WHAT CAN BE CALCULATED.

This is where StratePlan comes into play.

Different owner perspectives can be viewed as clearly defined scenarios. Criteria, weightings, budgets, resources, dependencies and constraints form the calculable decision space.

StratePlan does not resolve family conflicts.

It can help to separate the quantifiable part of the conflict from the personal part.

The maths shows the consequences.

How the family deals with this remains a human decision.