ClaudeChatGPTFinance & LegalIntermediate

12-Month Cash Flow Projection

Build a detailed 12-month cash flow projection with revenue scenarios, expense categories, and break-even timeline.

Updated June 2026

12-month-cash-flow-projection.txt
Copy & Download at the bottom ↓
You are a financial analyst who knows that most companies don't close due to lack of profit — they close due to lack of cash. A well-done projection shows months in advance if money will run out.

Create a cash flow projection for 12 months:

**Company:** [company name and sector]
**Revenue model:** [recurring, per project, one-time sales, mixed]
**Current average monthly revenue:** [amount]
**Growth expectation:** [% per month or stable]
**Seasonality:** [strong and weak months, if any]

**Revenue:** [sources and amounts]
**Monthly fixed costs:** [rent, salaries, tools, accountant]
**Variable costs:** [paid traffic, commissions, taxes]
**Planned investments:** [hires, equipment]
**Current cash balance:** [amount]

Deliver:
1. Monthly cash flow table (12 months)
2. Three scenarios (optimistic, realistic, pessimistic)
3. Alerts (months with negative cash risk)
4. Key indicators (margin, runway, break-even point)
5. Financial recommendations

When to Use

In the company's annual financial planning

When seeking investment or credit (banks require it)

To decide whether you can hire, invest, or expand

When the company has good months and bad months (seasonality)

How to Use This Prompt

1

Copy the prompt below into Claude or ChatGPT

2

Enter the company's financial data

3

Receive the complete projection with scenarios

4

Review monthly and adjust the assumptions

Example Input

Company: Digital marketing agency
Revenue: R$45K/month (3 contracts of R$15K)
Growth: 1 new client every 2 months
Fixed costs: R$22K
Current balance: R$30K
Planned investment: New designer in month 4 (R$5K/month)

Expected Output

Months 1-3: Comfortable. Net flow ~R$15K/month. Balance accumulates to R$75K.
Month 4: Designer joins (+R$5K fixed). Flow drops to R$10K/month.
Month 5: If new client comes in as expected, flow returns to R$17K.

Pessimistic scenario: If 1 client is lost in month 3, cash gets tight in month 6 (R$18K — only 1 month of reserve).

Recommendation: only hire designer after confirming the 4th client.
Current runway: 1.4 months. Minimum target: 3 months of fixed costs = R$66K.

Ready to use this prompt?