Prompt Details
Model
(claude-4-6-sonnet)
Token size
4,086
Example input
[BUSINESS_NAME]: Rootline Nutrition
[OPENING_CASH_BALANCE]: $47,000
[MONTHLY_CASH_INFLOWS]: Subscription box revenue (1,400 active subscribers): $75,600 Single-unit Shopify store sales: $18,400 Wholesale orders (3 gym chain accounts): $9,200 Affiliate & influencer referral commissions received: $2,100 Total Monthly Inflows: $105,300
[MONTHLY_CASH_OUTFLOWS]: Product manufacturing & raw ingredients: $31,800 Fulfillment, packaging & shipping: $14,200 Staff salaries (4 FTE — operations, customer success, marketing): $22,500 Paid social advertising (Meta & Google): $8,400 Influencer partnership fees: $3,200 Shopify platform & app subscriptions: $680 3PL warehouse storage fees: $2,900 Insurance & business compliance: $520 Accounting & legal retainer: $1,200 Misc. operational expenses: $800 Total Monthly Outflows: $86,200
[MINIMUM_CASH_THRESHOLD]: $25,000
Example output
══════════════════════════════════════════════════════════
12-MONTH CASH FLOW FORECAST
══════════════════════════════════════════════════════════
Business ............ Rootline Nutrition
Opening Balance ..... $47,000
Minimum Threshold ... $25,000
Forecast Period ..... Month 1 through Month 12
══════════════════════════════════════════════════════════
CASH FLOW HEALTH SCORE: 87 / 100 — Good — healthy cash management, minor exposure
══════════════════════════════════════════════════════════
SURVIVAL RUNWAY: Indefinite — STRONG
══════════════════════════════════════════════════════════
Note on assumptions: Monthly inflows and outflows are provided as single recurring figures. All 12 months are forecast at the stated values of $105,300 inflows and $86,200 outflows per month. No seasonal adjustment has been applied as no monthly variation was provided. If actual performance varies by month, the forecast should be updated with period-specific figures.
EXECUTIVE SUMMARY
──────────────────────────────────────────────────────────
Rootline Nutrition enters the 12-month forecast period with an opening cash balance of $47,000 and is projected to close Month 12 with a balance of $278,200, representing a total net annual cash flow of $231,200 on total inflows of $1,263,600 and total outflows of $1,034,400, achieving a Cash Flow Health Score of 87 out of 100, reflecting good and resilient cash management with minor residual exposure. The single most positive element is the business's consistent monthly net cash flow of $19,100 driven by 1,400 active subscription box customers generating $75,600 of predictable recurring revenue each month, while the most significant risk is the relatively thin opening cash buffer of $47,000 — only $22,000 above the $25,000 minimum threshold — which leaves the business with limited reserves to absorb any unexpected inflow shortfall in the critical first month of the period. At the current average monthly net cash flow of $19,100, the business is cash flow positive on an indefinite basis and its opening balance of $47,000 provides a survival runway that is classified as STRONG, meaning it can sustain operations through any short-term revenue disruption without immediately entering a liquidity crisis. Management should prioritise building the cash buffer above the $25,000 minimum threshold to a target of $50,000 to $75,000 in minimum operating reserves within the first three months, and simultaneously protect the subscription revenue base as the foundation of all liquidity projections.
──────────────────────────────────────────────────────────
KEY STATISTICS
──────────────────────────────────────────────────────────
Total Annual Inflows ........ $1,263,600
Total Annual Outflows ....... $1,034,400
Total Net Cash Flow ......... +$231,200
Average Monthly Net Flow .... +$19,100
Cash Coverage Ratio ......... 1.22x
Lowest Balance .............. $66,100 — Month 1
Highest Balance ............. $278,200 — Month 12
Closing Balance Month 12 .... $278,200
Months Below Threshold ...... 0 out of 12 months
──────────────────────────────────────────────────────────
Note on lowest balance: The lowest closing balance occurs at the end of Month 1 when the opening $47,000 grows by the $19,100 net cash flow to $66,100. Every subsequent month adds a further $19,100, meaning no month in the 12-month period falls below the $25,000 minimum threshold under the base case.
12-MONTH FORECAST
──────────────────────────────────────────────────────────
Month 1 ... Inflows $105,300 | Outflows $86,200 | Net +$19,100 | Balance $66,100 | SURPLUS
Month 2 ... Inflows $105,300 | Outflows $86,200 | Net +$19,100 | Balance $85,200 | SURPLUS
Month 3 ... Inflows $105,300 | Outflows $86,200 | Net +$19,100 | Balance $104,300 | SURPLUS
Month 4 ... Inflows $105,300 | Outflows $86,200 | Net +$19,100 | Balance $123,400 | SURPLUS
Month 5 ... Inflows $105,300 | Outflows $86,200 | Net +$19,100 | Balance $142,500 | SURPLUS
Month 6 ... Inflows $105,300 | Outflows $86,200 | Net +$19,100 | Balance $161,600 | SURPLUS
Month 7 ... Inflows $105,300 | Outflows $86,200 | Net +$19,100 | Balance $180,700 | SURPLUS
Month 8 ... Inflows $105,300 | Outflows $86,200 | Net +$19,100 | Balance $199,800 | SURPLUS
Month 9 ... Inflows $105,300 | Outflows $86,200 | Net +$19,100 | Balance $218,900 | SURPLUS
Month 10 ... Inflows $105,300 | Outflows $86,200 | Net +$19,100 | Balance $238,000 | SURPLUS
Month 11 ... Inflows $105,300 | Outflows $86,200 | Net +$19,100 | Balance $257,100 | SURPLUS
Month 12 ... Inflows $105,300 | Outflows $86,200 | Net +$19,100 | Balance $278,200 | SURPLUS
──────────────────────────────────────────────────────────
Annual Total .. Inflows $1,263,600 | Outflows $1,034,400 | Net +$231,200
No DANGER or WARNING months detected in base case. All 12 months project a closing balance above the $25,000 minimum threshold from Month 1 onward.
──────────────────────────────────────────────────────────
IMMEDIATE PRIORITIES
──────────────────────────────────────────────────────────
No months fall below the $25,000 minimum cash threshold under the base case forecast. However, the opening buffer of only $22,000 above the minimum threshold in Month 0 represents a structural vulnerability that the stress test analysis below confirms could become a WARNING or DANGER situation under adverse conditions. See Action Plan for recommended preventive steps.
──────────────────────────────────────────────────────────
CASH FLOW HEALTH SCORE BREAKDOWN
──────────────────────────────────────────────────────────
Coverage ......... 14 / 25 | Ratio: 1.22x
Buffer ........... 25 / 25 | 12 safe months of 12 months above threshold
Stability ........ 25 / 25 | 12 positive / 0 negative months
Trend ............ 12 / 25 | STABLE — Q4 net flow equals Q1 net flow (0% variance, flat rate forecast)
Note on Coverage Score: The cash coverage ratio of 1.22x falls in the 1.1x to 1.3x band, earning 14 of a possible 25 points. This is the primary driver of the score not reaching Excellent and reflects that while the business generates a consistent surplus, the margin between inflows and outflows at 18.1% of inflows is not as wide as the top tier requires. Growing inflows or reducing outflows to push the ratio above 1.3x would improve the score meaningfully.
Note on Trend Score: Because a flat constant rate was applied to all 12 months, Q4 average net flow equals Q1 average net flow exactly, placing the business in the STABLE band and earning 12 points. If real seasonal growth materialises, the score may improve to the IMPROVING band.
──────────────────────────────────────────────────────────
TOTAL: 87 / 100 — Good — healthy cash management, minor exposure
──────────────────────────────────────────────────────────
SURVIVAL RUNWAY AND STRESS TESTS
──────────────────────────────────────────────────────────
Opening cash position ...... $47,000 (today)
Monthly burn rate .......... $86,200 per month
Survival runway ............ Indefinite — STRONG
Months until cash zero ..... Cash flow positive — business generates $19,100 net per month
──────────────────────────────────────────────────────────
Note: Survival runway is classified as Indefinite and STRONG because average monthly net cash flow is positive at $19,100 per month. The business is not burning cash under the base case. The burn rate of $86,200 is the total expense figure used to calculate how long cash lasts if revenue stops entirely. At $47,000 opening balance against $86,200 monthly spend, if all revenue stopped today the business would exhaust its opening cash in 0.5 months (approximately 16 days). This is noted not as the operating runway but as the zero-revenue emergency figure, which underscores the critical importance of protecting inflow continuity.
Stress Test A — Inflows drop 15% ($89,505 per month):
Adjusted net flow: +$3,305 per month
Runway impact: Business remains cash flow positive but net monthly surplus collapses from $19,100 to $3,305, reducing the annual cash accumulation from $231,200 to approximately $39,660 and making the business highly vulnerable to any secondary cost increase or inflow disruption. Month 12 closing balance would fall from $278,200 to approximately $86,660. The health score would deteriorate as the coverage ratio would drop to approximately 1.04x, just above the break-even threshold.
Stress Test B — Outflows increase 10% ($94,820 per month):
Adjusted net flow: +$10,480 per month
Runway impact: Business remains cash flow positive but net monthly surplus reduces from $19,100 to $10,480, and the annual cash accumulation falls from $231,200 to approximately $125,760. Month 12 closing balance would fall from $278,200 to approximately $172,760. The coverage ratio drops to approximately 1.11x, remaining in the 1.1x to 1.3x band but with substantially less financial resilience against further cost pressures.
Critical stress note: If both Stress Test A and Stress Test B conditions occur simultaneously, adjusted net flow would be approximately: $89,505 - $94,820 = -$5,315 per month. Under this combined scenario the business would be in net cash burn, and the opening $47,000 would be exhausted in approximately 8.8 months, at which point the business would enter a DANGER position without additional financing. This dual-scenario risk makes inflow protection the single most important financial management priority.
──────────────────────────────────────────────────────────
CASH FLOW PATTERN ANALYSIS
──────────────────────────────────────────────────────────
Strongest quarter ... Q1 (Months 1–3) | Avg net: +$19,100
Weakest quarter .... Q4 (Months 10–12) | Avg net: +$19,100
Seasonal note: All four quarters show identical net cash flow of $19,100 per month under the flat-rate forecast; real-world performance should be reviewed for seasonal subscription churn patterns, promotional spending periods, and wholesale order cycles that may cause material intra-year variation not captured in this constant-rate model.
Peak inflow month .. All months equal — $105,300 per month
Peak outflow month . All months equal — $86,200 per month
Best net month ..... All months equal — +$19,100 net flow
Worst net month .... All months equal — +$19,100 net flow
Trajectory ......... FLAT
A flat trajectory under the constant-rate assumption confirms the business is generating steady positive cash flow, but management should review whether this reflects genuine business stability or an absence of growth investment that could compress the trajectory once planned marketing or subscriber acquisition spend is increased.
Cash collection signal: No timing mismatch is detected under the constant monthly rate model, as inflows and outflows are modelled as occurring within the same period. However, management should note that subscription billing cycles, wholesale order payment terms (commonly 30 to 60 days for gym chain accounts), and affiliate commission payout lags may create intra-month timing gaps that are not visible in a monthly forecast. A weekly cash flow model is recommended for the subscription and wholesale channels to confirm that billing dates and payment receipt dates are aligned with outflow commitments. If wholesale payments from the 3 gym chain accounts (generating $9,200 per month) are received on 45-day terms, the effective timing gap could expose the business to a $9,200 intra-month shortfall each period that the monthly model does not surface.
──────────────────────────────────────────────────────────
ACTION PLAN
──────────────────────────────────────────────────────────
Immediately establish a minimum cash reserve of $50,000 by ring-fencing $3,000 from each of the next Month 1 through Month 2 net surpluses into a dedicated operating reserve account, bringing the effective floor above the current $25,000 threshold to a level that absorbs a one-month inflow disruption without triggering a WARNING status. This is the highest-priority action because the combined stress scenario analysis shows that simultaneous 15% inflow reduction and 10% outflow increase produces a negative net flow of approximately -$5,315 per month, and only a stronger opening buffer prevents this scenario from becoming a liquidity crisis within 8.8 months.
Protect and grow the 1,400 active subscription base as the primary cash flow defence mechanism, given that subscription box revenue at $75,600 per month represents 71.8% of total monthly inflows and is the single variable most capable of converting this forecast from SURPLUS to WARNING. Introduce a churn monitoring dashboard by Month 2 tracking monthly subscriber cancellation rates against a target of below 5% per month, and allocate a minimum of 15% of the $8,400 monthly paid social advertising budget specifically to subscriber retention campaigns rather than purely acquisition-focused spend.
Review wholesale payment terms with the 3 gym chain accounts (currently contributing $9,200 per month) and negotiate payment terms of 14 days or fewer, or implement a 2% early payment discount to incentivise faster collection. If current terms exceed 30 days, the effective intra-month cash position is lower than the monthly model shows, and tightening collection to net 14-day terms on the $9,200 wholesale line would eliminate a structural timing risk that is invisible in the monthly aggregated forecast but material relative to the $22,000 buffer above the minimum threshold.
Build a formal 13-week (weekly) cash flow model by Month 3 to replace or supplement this monthly forecast, specifically mapping subscription billing dates, Shopify settlement timing (typically T+2 business days), affiliate commission payment lags, and wholesale invoice due dates against payroll processing dates ($22,500 fortnightly or monthly), manufacturing payment terms ($31,800), and 3PL storage fees ($2,900), as the monthly model's FLAT trajectory and zero danger months may mask intra-month gaps that are only visible at weekly granularity. This enhanced model will provide the early warning system needed to act before any stress test scenario converts from a theoretical risk to an active cash shortfall.
══════════════════════════════════════════════════════════
Cash Flow Forecast | Health Score 0-100 | Danger Zones
Survival Runway | Stress Tests | 12-Month Projection
══════════════════════════════════════════════════════════
By purchasing this prompt, you agree to our terms of service
CLAUDE-4-6-SONNET
Cash flow kills more profitable businesses than bad
products ever will. Input your opening balance, monthly
inflows, outflows, and minimum threshold. Get a full
12-month forecast with a Cash Flow Health Score from
0 to 100, month-by-month danger zone alerts, exact
survival runway, months until cash zero, two stress
tests showing what happens if inflows drop 15% or
costs rise 10%, and a prioritized action plan.
...more
Updated 2 weeks ago
