How do I use the "Build a Comprehensive Cash Flow Projection" prompt?

Copy the prompt template, fill in the variables (BUSINESS_TYPE, INDUSTRY, CURRENT_REVENUE, GROWTH_RATE, BUSINESS_STAGE, STARTING_CASH, MAJOR_EXPENSES, SEASONALITY, CAPEX_PLANS), and paste it into ChatGPT, Claude, or Gemini.

What AI tools work with this business prompt?

This prompt works with chatgpt, claude, gemini. Simply copy and paste the template into any of these AI assistants.

Tips for getting the best results?

Include multiple scenarios (best/base/worst case) to account for uncertainty and provide comprehensive planning Be specific about collection periods and payment timing - cash flow is about timing, not just amounts Factor in seasonal variations and industry-specific patterns that affect your business cycle Include one-time expenses like equipment purchases, tax payments, and loan repayments in the appropriate months Review and update assumptions monthly - cash flow projections are living documents that need regular refinement

business advanced

Build a Comprehensive Cash Flow Projection

Create detailed 12-month cash flow projections with AI. Get month-by-month breakdowns, scenario planning, and professional financial forecasts.

Works with: chatgptclaudegemini

Prompt Template

You are a senior financial analyst with expertise in cash flow modeling and business forecasting. Create a comprehensive 12-month cash flow projection for [BUSINESS_TYPE] with the following parameters: **Business Details:** - Industry: [INDUSTRY] - Current monthly revenue: [CURRENT_REVENUE] - Growth assumptions: [GROWTH_RATE] - Business stage: [BUSINESS_STAGE] **Financial Parameters:** - Starting cash balance: [STARTING_CASH] - Major expenses: [MAJOR_EXPENSES] - Seasonal factors: [SEASONALITY] - Capital expenditures planned: [CAPEX_PLANS] Create a detailed cash flow projection that includes: 1. **Monthly Revenue Projections:** Break down by revenue streams, incorporating growth rates and seasonal variations 2. **Operating Expenses:** Fixed costs (rent, salaries, insurance) and variable costs (materials, commissions, utilities) 3. **Cash Inflows:** Revenue collection timing, accounts receivable assumptions, other income sources 4. **Cash Outflows:** Operating expenses timing, loan payments, tax obligations, capital investments 5. **Net Cash Flow:** Monthly calculation showing cash generated or consumed 6. **Cumulative Cash Position:** Running balance to identify cash shortfalls or surpluses 7. **Key Assumptions:** Document all underlying assumptions for revenue growth, expense inflation, collection periods 8. **Scenario Analysis:** Provide best-case, base-case, and worst-case scenarios 9. **Critical Insights:** Identify months with potential cash shortfalls, recommend financing needs, highlight key cash flow drivers Format the output as a professional financial document with clear monthly breakdowns, summary tables, and actionable recommendations for cash management.

Variables to Customize

[BUSINESS_TYPE]

Type of business or company

Example: SaaS software company

[INDUSTRY]

Specific industry sector

Example: B2B marketing automation

[CURRENT_REVENUE]

Current monthly revenue amount

Example: $85,000

[GROWTH_RATE]

Expected growth rate assumptions

Example: 15% annual growth, 3% monthly churn

[BUSINESS_STAGE]

Current stage of business

Example: Series A startup, 2 years old

[STARTING_CASH]

Current cash balance

Example: $450,000

[MAJOR_EXPENSES]

Key expense categories and amounts

Example: Salaries $45k/month, AWS costs $12k/month, office rent $8k/month

[SEASONALITY]

Seasonal business factors

Example: Q4 typically 25% higher sales, summer months 10% slower

[CAPEX_PLANS]

Planned capital expenditures

Example: New server infrastructure $75k in Q2, office expansion $30k in Q3

Example Output

# 12-Month Cash Flow Projection - B2B SaaS Company ## Executive Summary Projected cash position ranges from $425k (Month 3) to $680k (Month 12). No additional financing required under base-case scenario. ## Monthly Revenue Projections - Month 1: $85,000 (base) - Month 2: $86,275 (1.5% growth) - Month 3: $87,571 (seasonal adjustment: -5%) - Q2 Average: $91,500 (includes new customer acquisition) - Q4 Peak: $105,000 (25% seasonal boost) ## Key Cash Flow Drivers **Inflows:** - Monthly recurring revenue: 85% of total - Annual contracts (paid quarterly): 15% - Collection period: 30 days average **Major Outflows:** - Payroll & benefits: $52,000/month - Cloud infrastructure: $12,000/month (scales with usage) - Marketing spend: $15,000/month - Q2 Infrastructure investment: $75,000 ## Critical Months - **Month 3**: Lowest cash position ($425k) due to Q1 tax payment - **Month 6**: Infrastructure investment creates temporary dip - **Month 9**: Strong recovery begins with Q4 seasonal uptick ## Scenarios - **Best case**: End at $750k (20% higher growth) - **Base case**: End at $680k - **Worst case**: End at $380k (requires $200k credit line) ## Recommendations 1. Establish $200k credit line by Month 2 2. Consider stretching infrastructure investment to Q3 3. Negotiate 45-day payment terms with major vendors

Pro Tips for Best Results

Include multiple scenarios (best/base/worst case) to account for uncertainty and provide comprehensive planning
Be specific about collection periods and payment timing - cash flow is about timing, not just amounts
Factor in seasonal variations and industry-specific patterns that affect your business cycle
Include one-time expenses like equipment purchases, tax payments, and loan repayments in the appropriate months
Review and update assumptions monthly - cash flow projections are living documents that need regular refinement