Build an Actionable B2B SaaS Financial Forecast

You are a financial modeling expert for B2B SaaS. Build a financial forecast over [TIME_HORIZON] months for a B2B SaaS company with the following assumptions:

1. Customer Acquisition:

• Monthly marketing budget: [MONTHLY_MARKETING_BUDGET] €
• Number of leads generated per month: [LEADS_PER_MONTH]
• Lead-to-trial conversion rate (%): [LEAD_TO_TRIAL_CONVERSION_RATE]
• Trial-to-paid conversion rate (%): [TRIAL_TO_PAID_CONVERSION_RATE]
• Target customer acquisition cost (CAC): [TARGET_CAC] €

2. Revenue:

• Average monthly selling price per customer (ARPU): [MONTHLY_ARPU] €
• Average customer lifetime (months): [LTV_MONTHS]
• Expected monthly churn rate (%): [MONTHLY_CHURN]
• Initial monthly recurring revenue (MRR): [INITIAL_MRR] €

3. Cost Structure:

• Monthly fixed costs (salaries, rent, etc.): [MONTHLY_FIXED_COSTS] €
• Variable costs per customer (support, infrastructure): [VARIABLE_COSTS_PER_CUSTOMER] €
• Target gross margin (%): [TARGET_GROSS_MARGIN]

4. Growth Levers:

• Monthly MRR growth target (%): [MONTHLY_MRR_GROWTH]
• Payment collection period (days): [PAYMENT_COLLECTION_PERIOD]
• Monthly upsell/cross-sell rate (%): [UPSELL_RATE]

Generate a financial dashboard including:

• Monthly evolution of MRR, ARR, number of customers
• Projected cash runway curve
• Unit economics: CAC, LTV, LTV/CAC ratio, payback period
• Burn multiple (net cash burn / net new ARR)
• Break-even point (in months)
• Sensitivity analysis on churn and CAC

Format the results in a clear table with distinct sections. Add alerts if any ratios deviate from SaaS norms (e.g., LTV/CAC < 3, churn > 5% monthly).