Financial projections 3-year forecast

🎭 Role

Act as an expert Fractional CFO and Financial Strategist with extensive experience in venture capital fundraising and SaaS/startup financial modeling. You specialize in building robust, investor-ready financial models that prioritize clarity, conservative accuracy, and data-driven storytelling.

🌐 Context

I am preparing a 3-year financial forecast to support a [FUNDRAISING ROUND/STRATEGIC INITIATIVE] for [COMPANY NAME]. The goal is to demonstrate fiscal responsibility, scalability, and a clear path to profitability to sophisticated investors. The model must be grounded in conservative, defensible assumptions.

🛠️ Task Instruction

Construct a comprehensive 3-year financial projection model based on the following framework:

1. Revenue Modeling: Build a bottom-up forecast using the following drivers: [TOTAL ADDRESSABLE MARKET/LEADS] × [CONVERSION RATE] × [AVERAGE CONTRACT VALUE/PRICE]. Account for monthly recurring revenue (MRR) growth and churn.
2. COGS & OpEx: Define Cost of Goods Sold (COGS) and classify Operating Expenses into fixed costs (salaries, rent) and variable costs (marketing, customer acquisition).
3. Financial Statements: Generate pro-forma statements including an Income Statement (highlighting EBITDA and Net Income), a Cash Flow Statement, and a Balance Sheet.
4. Break-Even Analysis: Calculate the specific month and revenue threshold at which the business achieves self-sustainability.
5. Scenario Modeling: Create three distinct versions of the model:
   • Realistic: The base case.
   • Conservative (Worst Case): Assuming lower conversion and higher churn.
   • Aggressive (Best Case): Assuming market penetration and optimized pricing.

⚖️ Constraints & Tone

• Tone: Professional, analytical, objective, and transparent.
• Assumptions: Adopt a "conservative bias." If an assumption is uncertain, favor lower growth or higher costs.
• Clarity: Avoid jargon where possible; define any specific financial metrics used.
• Length: Provide the logical structure and mathematical formulas for each section, followed by a summary analysis.

📝 Output Format

Provide the response in the following structure:

• Executive Summary: A brief overview of the financial health and growth trajectory.
• Methodology & Assumptions: A bulleted list detailing the logic behind the inputs (e.g., CAC, LTV, Burn Rate).
• Projection Tables: Present the data in markdown tables formatted by year (Year 1, Year 2, Year 3) with monthly breakdowns for Year 1.
• KPI Dashboard: A summary table highlighting EBITDA, Net Income, and Cash Flow per scenario.
• Investor Takeaways: A section outlining the three most critical financial levers for our business.

🧩 Variables

• Company Name: [INSERT NAME]
• Industry/Sector: [INSERT INDUSTRY]
• Current Monthly Revenue: [INSERT REVENUE]
• Primary Revenue Driver: [INSERT DRIVER, e.g., Monthly Subscriptions]
• Key Growth Assumption: [INSERT ASSUMPTION, e.g., 5% MoM user growth]