Treasury Cash Liquidity Planner
Calculate the optimal cash buffer for your business. Determine minimum liquidity targets based on operating expenses, volatility, and risk tolerance.
Formula
Target Liquidity = Operational Buffer (2mo OpEx) + Volatility Buffer (% of WC) + Strategic Shock
The Minimum Liquidity Target is constructed from three layers: 1) Operational Buffer: Typically 2 months of operating expenses to cover routine outflows like payroll and rent. 2) Volatility Buffer: A percentage of working capital needs to cover revenue timing mismatches (e.g., late payments). 3) Strategic Buffer: A fixed amount set aside for specific risks or one-time shocks. Summing these provides a defensible, risk-adjusted cash target.
Worked Examples
Example 1: Small Agency Planning
Problem:$50k Monthly OpEx, 30-day cash cycle, wants 20% volatility buffer + $10k shock reserve.
Solution:Op Buffer: $100k. Volatility: ($50k/30 * 30 * 0.20) = $10k. Shock: $10k. Total: $120k.
Result:$120,000 Target (72 days cash on hand)
Frequently Asked Questions
What is a liquidity buffer?
A liquidity buffer is excess cash kept on hand to cover unexpected expenses, revenue shortfalls, or delays in receivables. It ensures the business can continue operations during financial stress without needing emergency borrowing.
How much cash should a small business keep?
A common rule of thumb is 3 to 6 months of operating expenses (OpEx). However, this varies by industry. Volatile industries (like tech startups) often need 12+ months (runway), while stable service businesses might manage with 2-3 months.
What is the Cash Conversion Cycle (CCC)?
CCC measures how long it takes to convert investments in inventory and resources into cash flows from sales. It calculates: Days Inventory Outstanding + Days Sales Outstanding - Days Payable Outstanding. A lower CCC means better liquidity.
Why separate buffers into Operational, Volatility, and Strategic?
Segmentation helps decision-making. Operational buffer covers payroll/rent. Volatility buffer handles market swings. Strategic buffer is for opportunities (M&A, new product). Don't spend the Operational buffer on Strategy.
How does high inflation affect liquidity planning?
Inflation increases OpEx over time, meaning your static cash buffer represents fewer days of runway. In high inflation, you must periodically increase your nominal cash buffer to maintain the same 'real' coverage.
Is too much cash bad?
Yes. Idle cash loses value to inflation. Excess cash beyond the target buffer should be deployed into working capital optimization, debt paydown, or short-term investments (like T-bills) to earn yield.
What is a 'Cash Drag'?
Cash drag refers to the performance lag caused by holding a portion of a portfolio in cash (which earns low returns) rather than invested assets. In corporate treasury, it's the opportunity cost of not investing surplus cash.
How often should I review liquidity targets?
Quarterly reviews are standard. However, during periods of rapid growth or economic instability, monthly reviews are recommended to adjust for changing burn rates and revenue reliability.
What counts as 'Liquid Assets'?
Cash in checking/savings accounts, money market funds, and short-term treasury bills. Accounts Receivable (AR) and Inventory are NOT considered fully liquid for emergency buffers as they take time to convert.
How do covenants impact liquidity?
Bank loans often have 'minimum cash balance' covenants. Your internal buffer must always be *higher* than the bank's requirement to avoid technical default.
Background & Theory
The Treasury Cash Balance & Minimum Liquidity Buffer Planner calculates the "safe" amount of cash a business needs to survive shocks without disrupting operations. It moves beyond "gut feel" to a component-based approach.
Concept Overview
Liquidity planning balances safety (having enough cash) with efficiency (not hoarding cash). The model stacks three buffers:
- Operational: Keep the lights on (Payroll, Rent).
- Volatility: Absorb AR delays or sales dips.
- Strategic: Capital for unexpected opportunities or shocks.
Key Variables & Intuition
- Burn Rate (OpEx): The base outflow. Higher burn = higher required buffer.
- Revenue Volatility: Stable subscription revenue requires a smaller buffer than lumpy project revenue.
- Cash Conversion Cycle: If it takes 90 days to get paid, you need 90 days of cash to bridge the gap.
- Access to Capital: If you can raise money easily, you might hold less cash. If credit is tight, hold more.
Assumptions
- OpEx is relatively constant.
- The "One Time Shock" captures the single largest risk event (e.g., server outage, lawsuit settlement).
- Liquid assets are truly liquid (T+0 or T+1 access).
Limitations & Edge Cases
- Black Swans: No buffer protects against total market collapse; that requires business pivots.
- Hypergrowth: Rapid hiring consumes cash faster than historical OpEx suggests.
- Seasonality: Averages mask seasonal cash crunches (e.g., retail before holidays).
Practical Tips
- Ladder your Cash: Keep 1 month in Checking, 2 months in High Yield Savings, 3+ months in T-Bills.
- Stress Test: Ask "What if our biggest client pays 30 days late?"
- Monitor Covenants: Know your bank loan requirements.
- Don't count uncollected AR: Revenue is vanity, cash is sanity.
Common Mistakes
- Using tax money (VAT/Sales Tax) as operating cash.
- Ignoring annual lump sums (insurance, software renewals).
- Confusing personal credit limits with business liquidity.
History
Treasury and liquidity management has evolved from simple checkbook balancing to complex, algorithmic risk management strategies used by businesses of all sizes.
Origins & Why It Emerged
In the pre-digital era, "cash management" meant literally managing physical cash and ensuring enough was in the bank for payroll checks to clear. The high interest rates of the 1980s made idle cash expensive (high opportunity cost), driving the development of "sweep accounts" and sophisticated treasury functions. The 2008 financial crisis highlighted that "profitable" companies could die overnight from liquidity freezes, cementing liquidity risk management as a board-level priority.
How It Evolved in Practice
Initially, only large corporations had "Treasury Departments." Mid-market firms relied on controllers. Excel was the primary tool. As supply chains globalized, cash cycles lengthened, increasing risk. The introduction of TMS (Treasury Management Systems) in the 2000s allowed real-time visibility into global cash positions.
Modern Usage Today
Today, even startups plan "runway" and "buffers" meticulously. The collapse of Silicon Valley Bank (2023) was a stark reminder of counterparty risk, leading modern treasury policies to diversify holdings across multiple banks and instruments (e.g., money market funds). API-driven banking now allows real-time liquidity forecasting.
Common Misconceptions
- Profit = Cash: A profitable company can go bankrupt if it runs out of cash (e.g., waiting for AR).
- Credit lines = Cash: Relying solely on lines of credit is risky; banks can cut them in a downturn.
- Cash is safe: Inflation erodes cash; bank failures threaten it. Cash needs active management.