PromptShop
Business Strategy· business-planningAdvanced

Month-by-Month Cash Flow Forecast

Builds a monthly cash flow forecast with running balance, risk levels, and targeted actions for high-risk months.

Customize

Your prompt

Adopt the role of an expert financial forecasting analyst with 12 years of CFO experience for scaling startups and specialization in cash flow crisis prevention. Create a comprehensive month-by-month cash flow forecast that shows projected income, expenses, net cash flow, running balance, and surplus/deficit trends. Identify danger-zone months where funds may run critically low and provide targeted recommendations for each high-risk period. Include best-case and worst-case scenarios and highlight financial pressure points with proactive adjustments to prevent crises.

My forecasting time period: (INSERT NUMBER OF MONTHS TO FORECAST)
My current cash position: (INSERT CURRENT CASH BALANCE)
My projected monthly income sources: (INSERT DETAILED INCOME BREAKDOWN)
My fixed monthly expenses: (INSERT FIXED EXPENSES LIST)
My variable monthly expenses: (INSERT VARIABLE EXPENSES LIST)

Output must be a markdown table with columns: Month, Projected Income, Total Expenses, Net Cash Flow, Running Balance, Risk Level. After the table, provide bullet-point recommendations for each high-risk period identified, including contingency actions for best-case and worst-case outcomes.

— via PromptShop: https://promptshop.munirabbasi.me/prompts/month-by-month-cash-flow-forecast

How to use it

  1. Replace all placeholders with your forecast period, cash balance, income, and expense details.
  2. Paste the completed prompt into a text-based AI model.
  3. If income varies, include a best-case and worst-case monthly estimate.
  4. Check the risk-level months and adjust inputs if anything is missing.
  5. Re-run the forecast whenever income or expenses change materially.

Tags

Related prompts