MARTÍN GILSTRATEGY & INTELLIGENCE

MGS Executive Toolkit Collection · ET-008

Decision support tool

Liquidity and Treasury Diagnostic

Make cash pressure visible early enough to preserve room for action.

Identify cash pressure, critical payments and available actions before liquidity constraints reduce your options.

Download professional toolExplore the collection →

Editable XLSX file compatible with Excel, Numbers and Google Sheets.

When to use itBefore committing resources or closing a difficult-to-reverse decision.
What to prepareVerifiable evidence, owners, limits and alternatives.
What you will obtainSeparate immediate cash pressure from structural liquidity weakness.

What problem it helps solve

Identify cash pressure, critical payments and available actions before liquidity constraints reduce your options.

Questions to answer before deciding

  • Is the current cash balance reliable and reconciled?
  • Which collections are certain, probable or delayed?
  • Which payments cannot be postponed?
  • Are payroll, taxes and social contributions covered?
  • What cash is tied up in receivables and inventory?

How the result is interpreted

The 0–100 result is calculated only from confirmed rows. Document completeness is shown separately so that a completed worksheet is not confused with a favourable decision.

What it does not replace

The tool structures a decision. It does not replace financial, legal, tax, technical or human review when specialist verification is required.

User guide

How to use the tool

1

Define the scope

Specify the decision or situation being assessed.

2

Record evidence

Use verifiable data and documents.

3

Score from 1 to 5

Use one consistent and justified scale.

4

Close with accountability

Assign a condition and owner before confirming a row.

Within the framework

Diagnose

This tool forms part of the MGS Strategic Intelligence Framework™ and should be interpreted together with evidence, limits and the review mechanism.

Further reading

  1. Porter, M. E. (1980). Competitive Strategy. Free Press.
  2. Porter, M. E. (1985). Competitive Advantage. Free Press.
  3. Mintzberg, H. (1994). The Rise and Fall of Strategic Planning. Free Press.
  4. Kaplan, R. S. y Norton, D. P. (1996). The Balanced Scorecard. Harvard Business School Press.
  5. Christensen, C. M. (1997). The Innovator’s Dilemma. Harvard Business School Press.

Review methodology criteria, scoring and limitations.

Next step

When the tool identifies material exposure

Convert material gaps into a decision question, a verifiable scope and an expected outcome.

Discuss the situationKnowledge Centre