Build a Detailed Financial Projection Model for Your Business

Generate a comprehensive multi-year financial projection with revenue models, cost analysis, unit economics, and sensitivity scenarios.

๐Ÿ“ The Prompt

Act as a seasoned financial analyst and CFO advisor. Create a detailed financial projection for [COMPANY NAME], a [BUSINESS TYPE: SaaS/e-commerce/service-based/manufacturing] business in the [INDUSTRY] sector. We are currently generating [CURRENT MONTHLY REVENUE] in monthly revenue with [NUMBER OF EMPLOYEES] employees and have been operating for [TIME IN BUSINESS]. Please build a comprehensive financial projection covering the next [3/5] years with the following structure: 1. **Revenue Projections**: - Break down revenue by stream: [REVENUE STREAM 1], [REVENUE STREAM 2], [REVENUE STREAM 3] - Model three scenarios: conservative (bottom 25%), base case (most likely), and optimistic (top 25%) - Include monthly projections for Year 1 and annual projections for Years 2-[3/5] - State all growth rate assumptions clearly and justify each one based on [INDUSTRY] benchmarks 2. **Cost Structure**: - Fixed costs: List and estimate all fixed monthly expenses (rent, salaries, software, insurance, etc.) - Variable costs: Calculate COGS and variable expenses as a percentage of revenue - Hiring plan: Project headcount growth aligned with revenue milestones, assuming average salary of [AVERAGE SALARY] in our market - One-time costs: Identify anticipated capital expenditures or setup costs 3. **Key Financial Statements**: - Projected Income Statement (P&L) with gross margin, operating margin, and net margin - Simplified Cash Flow Statement highlighting months where cash position is critical - Break-even analysis: Calculate the exact month/revenue point where we become profitable 4. **Unit Economics & KPIs**: - Calculate and project: CAC, LTV, LTV:CAC ratio, payback period, gross margin percentage, burn rate, and runway - Compare these metrics against [INDUSTRY] industry benchmarks 5. **Sensitivity Analysis**: - Identify the top 5 variables that most impact profitability - Show how a ยฑ20% change in each variable affects bottom-line results 6. **Assumptions Summary**: - Compile all assumptions into a clearly organized table - Flag which assumptions carry the highest risk Present all financial data in clearly formatted tables. Use realistic, defensible numbers and explain your reasoning for each major assumption.

๐Ÿ’ก Tips for Better Results

Provide your actual current financials (even rough estimates) in the placeholders so the AI can anchor projections to reality rather than generating purely hypothetical numbers. Ask the AI to format outputs as CSV-ready tables so you can easily paste them into Excel or Google Sheets for further modeling and adjustments. Run the prompt multiple times with different growth assumptions to stress-test your model and identify which scenarios require contingency planning.

๐ŸŽฏ Use Cases

Entrepreneurs, finance teams, and small business owners who need structured financial forecasts for investor presentations, loan applications, or internal strategic planning. Best used during fundraising preparation or annual budgeting cycles.

๐Ÿ”— Related Prompts

๐Ÿ’ผ Business advanced

Create a Compelling Investor Pitch Deck Outline

Generate a detailed investor pitch deck outline with slide-by-slide guidance, speaker notes, and visual suggestions for fundraising.

๐Ÿ’ผ Business intermediate

Design a Complete OKR Framework for Your Team or Organization

Build a complete OKR framework with company, team, and individual objectives, scoring systems, and a 90-day rollout plan.

๐Ÿ’ผ Business intermediate

Write a Business Plan Executive Summary

Create a compelling executive summary for investors with market analysis, financials, and positioning.

๐Ÿ’ผ Business beginner

SWOT Analysis Generator

Generate a detailed SWOT analysis with strategic recommendations and priority actions.

๐Ÿ’ผ Business intermediate

Create a Project Proposal

Generate a complete project proposal with timeline, budget, risk assessment, and success metrics.

๐Ÿ’ผ Business beginner

Create a Professional Meeting Agenda That Drives Results

Generate a structured, professional meeting agenda with timed items, objectives, action trackers, and follow-up plans.