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.