Financial Planning & Analysis

AI won't replace your accountant, but it will help you think through financial decisions faster and more thoroughly. Use it for modeling, scenario planning, and understanding your numbers.

Revenue Projection Framework

"Create a 12-month revenue projection for a [business type] with these assumptions:

- Starting monthly revenue: $[X]

- Pricing: $[X] per [unit/subscription/project]

- Current customers: [X]

- Monthly growth rate assumption: [X%]

- Churn rate: [X%]

- Key costs: [list fixed and variable costs]

Format as a monthly table with columns:

Month | New Customers | Lost Customers | Total Customers | Revenue | Fixed Costs | Variable Costs | Net Profit

Below the table, calculate:

- Break-even point (which month)

- Year-end annual revenue

- Average monthly profit margin

- Cash needed to reach profitability"

Scenario Planning

This is where AI truly excels — running multiple "what if" scenarios:

"Using the revenue model above, show me 3 scenarios:

Optimistic: Growth rate is [X%], churn drops to [X%], we add a new product line at $[X]

Realistic: Current assumptions hold steady

Pessimistic: Growth slows to [X%], churn increases to [X%], we lose our biggest client ($[X]/month)

For each scenario, show:

- 12-month revenue trajectory

- Cash position each month

- Break-even timeline

- One action we should take NOW to prepare"

Pricing Decision Analysis

"I'm considering changing my pricing from $[current] to $[new]. Help me think through this:

Current state:

- [X] customers at $[current] = $[revenue]/month

- Customer acquisition cost: $[X]

- Average customer lifetime: [X months]

Model the impact if:

- We lose 10% of customers due to the price increase

- We lose 20% of customers

- We lose 0% (best case)

For each scenario: what's the break-even point? How long until the new pricing generates more total revenue than the old?"

Expense Analysis

"Here are my business expenses for the last 3 months: [paste or list]

Analyze them and:

1. Categorize each expense (operations, marketing, payroll, software, etc.)

2. Calculate what percentage each category is of total spending

3. Identify any expenses that seem high relative to industry benchmarks

4. Flag any duplicate or redundant expenses (e.g., multiple software tools doing the same thing)

5. Suggest 3 areas where I could cut costs without impacting quality"

Investment/Purchase Decisions

"Help me evaluate whether to [buy/lease/hire/build]:

Option A: [description, costs, benefits]

Option B: [description, costs, benefits]

Option C: do nothing (status quo)

For each option, analyze:

- Total cost over [timeframe]

- ROI (return on investment) calculation

- Payback period

- Risk factors

- Hidden costs I might not be thinking of

Recommend the best option and explain why."

Unit Economics

"Calculate the unit economics for my [business type]:

- Average revenue per customer: $[X]

- Customer acquisition cost: $[X] (marketing spend / new customers)

- Average customer lifetime: [X months]

- Monthly cost to serve each customer: $[X]

Calculate:

- Customer Lifetime Value (CLV)

- CLV:CAC ratio (healthy is 3:1 or better)

- Monthly recurring revenue needed to cover fixed costs of $[X]

- Number of customers needed to break even"

Important Disclaimers

1. 1.AI projections are models, not predictions — they're only as good as your assumptions
2. 2.Always validate assumptions against real data and industry benchmarks
3. 3.Use AI for exploration, not final numbers — your accountant/CFO should review anything important
4. 4.AI doesn't know your specific tax situation — don't use it for tax planning
5. 5.Garbage in, garbage out — wrong assumptions produce confidently wrong projections