Business
Financial Projections AI Prompt Template
Create 3-year financial projections with this AI prompt: revenue model, costs, cash flow, and break-even analysis explained simply. Try it now.
The prompt
ROLE: You are a fractional CFO who builds financial models for early-stage companies. CONTEXT: Business: [COMPANY], a [BUSINESS_TYPE] selling [PRODUCT] at [PRICE_POINT]. Current monthly revenue: [CURRENT_REVENUE]. Monthly costs: [MONTHLY_COSTS]. Growth assumption: [GROWTH_ASSUMPTION]. Funding available: [FUNDING]. TASK: Build a 3-year financial projection narrative with supporting tables. FORMAT: 1. Revenue model explanation (how each dollar is earned, in plain English), 2. Year-by-year P&L table (revenue, COGS, gross margin, operating expenses, EBITDA), 3. Monthly cash flow summary for year 1 (opening cash, inflow, outflow, closing cash), 4. Break-even analysis (when and at what revenue level), 5. Key assumptions table (assumption, value, what happens if it is 30% worse). CONSTRAINTS: Show your math logic in words, not just numbers. Use conservative, base, and optimistic scenarios for revenue. Round all figures to thousands. Clearly mark every assumption. End with 3 questions I must answer before these projections can be trusted. If any variable is unclear or missing, ask up to 3 targeted clarifying questions before producing the output, and clearly mark every assumption you make with [ASSUMPTION].
Variables to fill in
Replace each [variable] in the prompt with your own details:
[COMPANY] [BUSINESS_TYPE] [PRODUCT] [PRICE_POINT] [CURRENT_REVENUE] [MONTHLY_COSTS] [GROWTH_ASSUMPTION] [FUNDING]
Example input
COMPANY=FitTrack, BUSINESS_TYPE=fitness app, PRODUCT=premium subscription at $12/month, PRICE_POINT=$12/mo, CURRENT_REVENUE=$8,000/mo, MONTHLY_COSTS=$25,000, GROWTH_ASSUMPTION=15% monthly user growth slowing to 5%, FUNDING=$500k seed
How to use this prompt
Enter your real current numbers, then sanity-check the AI's growth assumptions against your actual past growth before believing the projections.
Tips for the best results
- Always build the pessimistic scenario first; if the business survives that, the plan is robust.
- Cash flow matters more than profit for startups: watch the monthly closing cash line.
- Update projections monthly with actuals; a model you never revisit is decoration.
Frequently asked questions
How accurate are AI-generated projections?
They are only as good as your assumptions. The AI structures the logic correctly, but you must supply realistic inputs and stress-test them.
Do I need a spreadsheet too?
Yes for anything you share with investors. Use this prompt to get the structure and logic right, then transfer the numbers into a spreadsheet.