Skip to content

sigit48/fp-a

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Enterprise Liquidity Stress-Test & Capital Governance Framework

Project Snapshot (TL;DR)

A CFO-grade FP&A framework that stress-tests enterprise liquidity and translates financial shock scenarios into objective capital allocation decisions at the business-unit level.

This project demonstrates how liquidity risk, not profitability, determines organizational survival — and how delayed capital decisions accelerate value destruction.


Executive Overview

This repository presents a CFO-grade Financial Planning & Analysis (FP&A) project focused on:

  • Enterprise liquidity resilience
  • Capital allocation discipline
  • Stress-tested decision governance

The framework simulates multi-scenario financial shocks and converts them into unit-level capital actions using objective, data-driven rules.

This is not academic financial modeling.
It reflects real-world capital governance logic applied under uncertainty and financial stress.


Strategic Problem Statement

Many organizations remain profitable on paper while silently drifting toward operational insolvency due to:

  • Rigid fixed-cost structures
  • Delayed liquidity visibility
  • Subjective management judgment during crises
  • Capital misallocation across business units

Core CFO Question

At what point does capital allocation stop creating value and begin destroying liquidity?


Objectives

  • Stress-test enterprise liquidity under adverse revenue scenarios
  • Detect early signals of operational insolvency
  • Prevent capital contagion across business units
  • Replace subjective judgment with objective capital governance triggers

Scope of Analysis

  • Multi-entity / multi–business unit portfolio
  • Unit-level liquidity and cash runway modeling
  • Scenario-based capital allocation outcomes
  • Strategic classification logic: FUND / FIX / KILL

Methodology

1. Data Preparation

  • Revenue and operating cost normalization
  • Removal of scale distortions (trillion / quadrillion artifacts)
  • No artificial smoothing or numerical manipulation

2. Stress-Test Scenarios

Scenario Revenue Impact Cost Impact
Base Normal Baseline
Downside −15% +2%
Severe −30% +5%

3. Liquidity Modeling

  • Net Cash Flow
  • Cash Buffer Ratio
  • Cash Runway (months)

4. Capital Decision Logic

Each business unit is classified based on liquidity sustainability:

  • FUND → Value creation and strategic expansion
  • FIX → Conditional survival with enforced cost discipline
  • KILL → Capital termination to prevent systemic risk

Key Findings

Structural Insight

  • A 30% revenue decline produces an 8× acceleration in cash burn
  • Fixed costs dominate the cost structure, amplifying downside exposure

Liquidity Reality

  • Cash runway dispersion ranges from 97 months to 0.2 months
  • Positive equity does not imply operational survivability

Capital Truth

  • ~79% of business units enter survival or termination mode under severe stress
  • The enterprise structurally shifts from a Growth Entity to a Survival Entity

Strategic Decision Matrix (Severe Scenario)

Category Units Strategic Action
🚀 FUND 2,544 Accelerate R&D, M&A, market dominance
⚠️ FIX 5,120 OpEx −20%, hiring freeze, debt restructuring
❌ KILL 4,336 Shutdown, divestment, asset liquidation

Executive Implications

  • Liquidity > Revenue
    Revenue is a vanity metric; liquidity is existential.

  • Delay is fatal
    Acting at sub–1 month runway eliminates strategic optionality.

  • Capital amputation is not failure
    It is a governance discipline.


Why This Project Matters

This project demonstrates the ability to:

  • Translate financial analytics into capital allocation strategy
  • Identify hidden structural risks beyond surface-level ratios
  • Communicate insights using board-level decision language
  • Design analytics that drive real investment and survival decisions

This is not a growth story.
This is a capital survival and governance story.


Disclaimer

All data used in this project is simulated and anonymized for analytical and portfolio demonstration purposes only.
No real company financials are disclosed.


Author

Sigit Dwiantoro
Financial & Risk Analytics | FP&A | Capital Strategy

Focused on:

  • Liquidity risk management
  • Capital allocation governance
  • Enterprise financial resilience

“A company does not die from lack of profit.
It dies from lack of cash — and delayed decisions.”

About

FP&A / Cashflow Scenario Analytics

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors