Financial Planning & Analysis
Use AI for budgets, projections, and financial decision-making.
Financial Planning & Analysis
AI won't replace your accountant, but it will help you think through financial decisions faster and more thoroughly. The real power is not in the calculations -- a spreadsheet does math better. The power is in AI's ability to model scenarios, identify what you are not thinking about, and translate complex financial concepts into plain language.
Scenario planning is where AI truly excels in finance. Instead of building one forecast and hoping it is right, AI can model optimistic, realistic, and pessimistic futures in seconds. The pessimistic scenario is always the most valuable -- it reveals risks you have not prepared for.
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
"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"
When running the pessimistic scenario, always ask: "What if the pessimistic scenario is STILL too optimistic?" This forces you to think about truly bad outcomes -- and those are the ones you need contingency plans for. If your business survives the worst case, the realistic case will take care of itself.
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
AI projections are models, not predictions -- they are only as good as your assumptions. Always validate assumptions against real data and industry benchmarks. Use AI for exploration, not final numbers. Your accountant or CFO should review anything important. Garbage in, garbage out: wrong assumptions produce confidently wrong projections.
Exercises
0/4Run a 3-scenario analysis (optimistic, realistic, pessimistic) for your business or a business you know well. Does the pessimistic scenario reveal any risks you hadn't considered?
Hint: The pessimistic scenario is the most valuable. It forces you to think about: what if growth stalls? What if my biggest client leaves? What if costs increase 30%?
What is a healthy Customer Lifetime Value to Customer Acquisition Cost (CLV:CAC) ratio?
What financial question about your business have you been avoiding because the analysis feels overwhelming? Write it down as a specific prompt you could give to AI.
Hint: Common examples: "Can I afford to hire someone?", "Should I raise my prices?", "What's my break-even point?" Turn these into the structured prompts from this lesson.
AI projections are _______, not predictions -- they are only as good as your assumptions.