Working Capital Scorecards: The Fastest Way to Prove Cash Runway Before Renewal
Turn messy bank data into a lender-ready scorecard that shows liquidity, variance, and contingency plans in under an hour per week.
1. Build a 13-Week Liquidity Spine
Export daily balances from every operating account and condense them into a 13-week view. Separate committed funding (credit lines, SBA draws) from discretionary cash so lenders can see true runway. Highlight:
- Opening cash: Prior day closing balance for each account.
- Expected inflows: Receivables, subscription renewals, card-clearing deposits.
- Fixed vs. variable outflows: Payroll, rent, cloud spend, campaign tests.
- Borrowing base availability: Headroom on ABL or inventory lines.
Lock the sheet every Friday, compare actuals versus forecast, and document any variance greater than 5% so the narrative is ready the next time underwriting calls.
2. Layer Stress Tests Right in the Scorecard
Credit teams care less about your base case and more about how quickly you react when receipts slip. Add a dedicated tab that applies two stress scenarios:
- Collections drag: Push 30% of receivables out by two weeks and show the new runway date.
- Expense surge: Add an unplanned 10% vendor hike to OpEx for one cycle.
Call out the mitigation plan (draw on LOC, pause discretionary spend, accelerate renewal discounts) so the lender sees discipline, not just numbers.
3. Assign a Health Score to Each Week
Create a simple 3-color scale that mirrors the lender’s covenant expectations:
| Score | Description | Action |
|---|---|---|
| Green | >45 days runway and covenant headroom above 10% | Share dashboard snapshot with lenders |
| Yellow | 30-45 days runway or variance exceeding ±5% | Trigger internal standup, prep mitigation memo |
| Red | <30 days runway or covenant breach risk | Deploy contingency plan, alert relationship manager |
Embedding the score inside the workbook saves lenders from scanning dozens of lines—they can see in one glance whether management is on top of liquidity.
4. Tie Scorecard Insights to Operating Levers
Link the scorecard to operational dials so leadership can take action the same day a metric drifts:
- Sales pipeline: Highlight enterprise deals set to fund within 45 days.
- Procurement: Flag PO deferments that free cash without breaking SLAs.
- Headcount: Connect hiring freeze decisions to the runway impact.
- Marketing CAC: Show what happens if acquisition spend pauses for one sprint.
Lenders love when borrowers connect liquidity to levers because it proves the team can self-correct without waiting for a board meeting.
5. Package the Scorecard for Underwriting
Before every renewal or new application, export the latest scorecard to PDF, attach the stress-test tab, and add a one-page management commentary:
- Summarize the last quarter’s runway trend.
- Note any covenant conversations already in flight.
- List contingency triggers and who owns each action.
This proactive bundle turns the typical tracking request into a value-add update and often trims a week off underwriting because all follow-up answers are already in the packet.
What to Do This Week
Schedule a 45-minute workshop with finance, sales, and operations to finalize the scorecard inputs. Assign one owner to publish the living version every Friday afternoon and share it with your banking partners on Monday morning. Consistency is the edge—good numbers are table stakes, but predictable reporting earns bigger credit limits.