RESEARCH · Deep Research
Build a 12-Month Small Business Cashflow Runway & Revenue Stress-Test Model
Profitable on paper but anxious about cashflow? Build a 12-month Runway & Burn Rate stress test across Base, -30% Revenue, and Zero-Inflow scenarios with clear survival triggers.
CORE TOOLS
DeepSeek / Claude, Excel
BEST FOR
Small business owners, agency founders, shop owners, freelancers
REQUIREMENTS
Current cash balance, monthly fixed costs, and average revenue
✦ WHY THIS WORKFLOW
Small businesses rarely die from lack of ideas—they die from timing mismatches between delayed client payments and fixed payroll/rent. Stress-testing prevents surprise crunches.
✦
Interactive Workflow Animation Preview
Step-by-Step Action Checklist
0 / 4 Completed
READY-TO-USE PROMPT TEMPLATE
I run a small business ([Business Type]) and need a **12-Month Cashflow Runway & Stress-Test Model**: - Current liquid cash on hand: [$ / ¥ X] - Fixed monthly burn (rent, base payroll, tools): [$ / ¥ X/mo] - Variable costs (% of revenue): [X%] - Average monthly collected revenue & seasonal/AR delay notes: [Input] Please generate: 1) [3-Scenario Runway Table]: Months of survival under Base Case, -50% Revenue Shock, and Zero-Inflow Lockdown, flagging lumpy cash-out months (quarterly rent, bonuses, taxes); 2) [AR Delay Impact]: What happens if our largest client pays 60 days late; 3) [Yellow & Red Circuit Breakers]: Concrete cost-cutting triggers when runway drops below 6 months and 3 months.