Financial PlanningBusiness FinanceRevenue ForecastingStartup FinanceBusiness Plan
Create Financial Projections
T. Krause
Build investor-ready, assumption-backed financial projections for your business without a CFO. This prompt generates a structured 3-year financial model with revenue forecasts, cost breakdowns, and cash flow analysis tailored to your business model.
Whether you're pitching investors, planning for growth, or simply trying to understand whether your business model works at scale, financial projections are non-negotiable. Most business owners either skip them entirely or build them on wishful thinking. This prompt generates rigorous, assumption-driven projections that hold up under scrutiny — and teaches you the logic as it builds.
What It Does
- Produces a structured 3-year financial projection covering revenue, costs, gross margin, operating expenses, and net profitability based on your specific business model.
- Makes all assumptions explicit so you can stress-test the model and defend it to investors, lenders, or co-founders.
- Identifies key financial milestones, break-even point, and cash flow risk periods so you can plan hiring, funding, and growth decisions proactively.
The Prompt
#CONTEXT:
I need to create realistic, assumption-backed financial projections for my business. These projections will be used for [investor presentation / internal planning / loan application / business plan]. They need to reflect my actual business model, realistic growth assumptions, and clear cost structure. I want the projections presented in a way that I can explain and defend every number.
#ROLE:
You are a senior financial analyst with experience modeling early-stage and growth-stage businesses across multiple industries. You build financial models that are rigorous enough to satisfy investors but clear enough for non-finance founders to understand and use. You always make assumptions explicit and flag risks proactively.
#RESPONSE GUIDELINES:
1. Begin by restating my business model and revenue mechanics to confirm you've understood them correctly before building any numbers.
2. Structure projections across three scenarios: conservative (base −30%), base case, and optimistic (base +30%).
3. Build projections year by year for 3 years, with monthly detail for Year 1.
4. For each revenue stream, show unit economics: price per unit, volume, and total revenue — not just revenue totals.
5. Flag the three most critical assumptions that most affect the projections and explain what would change if those assumptions proved wrong.
6. Calculate and call out: gross margin, operating margin, monthly cash burn (Year 1), and break-even point.
#FINANCIAL PROJECTION CRITERIA:
1. All assumptions must be stated explicitly — growth rates, pricing, churn, margins — so the model can be challenged and updated.
2. Cost structure must distinguish between fixed costs (do not scale with revenue) and variable costs (scale with revenue or volume).
3. Include working capital considerations: accounts receivable lag, payment terms, and pre-revenue cash requirements.
4. Revenue projections must account for sales cycle length — do not project revenue in the same month as a sale is initiated if the cycle is longer than 30 days.
5. Apply conservative hiring assumptions: headcount should only be added when revenue justifies it, not in anticipation of revenue.
#INFORMATION ABOUT ME:
- My business type and revenue model: [BUSINESS TYPE AND REVENUE MODEL — e.g., SaaS subscription, service retainer, e-commerce, marketplace]
- My primary revenue streams: [REVENUE STREAMS — describe each with pricing and frequency]
- My current revenue (monthly or annual): [CURRENT REVENUE]
- My primary cost categories: [COSTS — e.g., payroll, COGS, marketing, software, office]
- Target market and customer acquisition approach: [GTM — e.g., inbound marketing, outbound sales, paid acquisition, partnerships]
- Planning horizon and purpose of projections: [PURPOSE AND HORIZON]
#RESPONSE FORMAT:
Business Model Confirmation:
[Restatement of revenue model and key mechanics for validation]
Key Assumptions:
- Growth rate: [assumption and basis]
- Pricing: [assumption and basis]
- Customer acquisition cost: [assumption and basis]
- Churn / retention: [assumption and basis]
- Gross margin: [assumption and basis]
Year 1 Monthly Projection (Base Case):
| Month | New Customers | MRR/Revenue | COGS | Gross Profit | OpEx | Net Income | Cumulative Cash |
|---|---|---|---|---|---|---|---|
Year 1–3 Annual Summary:
| Year | Revenue | Gross Profit | Gross Margin | OpEx | EBITDA | Headcount |
|---|---|---|---|---|---|---|
Break-Even Analysis:
- Monthly break-even revenue: [amount]
- Projected break-even month: [month/year]
- Cash required to reach break-even: [amount]
Critical Risk Assumptions:
1. [Assumption 1]: [What changes if this is wrong]
2. [Assumption 2]: [What changes if this is wrong]
3. [Assumption 3]: [What changes if this is wrong]
How to Use
- Describe your revenue model precisely — specify whether it's per-seat SaaS, transaction-based, retainer, project-based, or product-based, and include actual pricing figures rather than leaving them vague.
- Include your real current revenue or early traction data. Projections anchored to actual data are more credible and useful than those built from scratch.
- Copy the output into a spreadsheet (Google Sheets or Excel) and replace the static figures with formulas so the model can be updated as assumptions change.
- Use the "Critical Risk Assumptions" section as the agenda for your next planning or investor conversation.
Example Input
## Information about me
- My business type and revenue model: B2B SaaS — monthly subscription, per-seat pricing at $49/seat/month
- My primary revenue streams: Core platform subscriptions (95%), implementation services (5%)
- My current revenue: $8,500 MRR, 12 paying customers, avg 14 seats per customer
- My primary cost categories: 2 engineers ($160K combined), 1 salesperson ($80K + commission), SaaS tools ($2K/month), marketing ($3K/month)
- Target market and acquisition approach: Marketing agencies 10–50 employees; inbound content + founder LinkedIn + outbound SDR
- Planning horizon and purpose: 3-year projection for Series A fundraising conversation, monthly detail for Year 1
Tips
- Push back on the AI's assumptions. If a growth rate assumption looks too aggressive or conservative, challenge it directly. Ask "what growth rate would a comparable SaaS company at $8K MRR typically achieve with $50K/month in marketing spend?" to get benchmarked alternatives.
- Run the conservative scenario first. Build your plan around the conservative case and treat the base case as your target. If the conservative case doesn't work, the business model needs rethinking before the growth plan does.
- Separate one-time from recurring revenue. Services revenue, setup fees, and implementation revenue are often one-time; subscriptions are recurring. Mixing them inflates apparent growth and misleads planning.
- Ask for a funding bridge analysis. Follow up by asking the AI to calculate how much capital you'd need to reach profitability or a specific revenue milestone given your current burn rate.
- Update monthly. A projection that's never revised against actuals becomes irrelevant quickly. Use this prompt quarterly to regenerate projections incorporating real performance data.