12-Month Financial Projection with Scenario Analysis

Create a detailed 12-month financial projection for [COMPANY NAME], operating in the [INDUSTRY] sector, with current monthly revenue of R$ [AMOUNT].\\\\\\\\n\\\\\\\\n**Required Input Data:**\\\\\\\\n- Average revenue over the last 6 months: R$ [AMOUNT]\\\\\\\\n- Monthly fixed costs: R$ [AMOUNT]\\\\\\\\n- Average variable costs: [PERCENTAGE]% of revenue\\\\\\\\n- Planned investment: R$ [AMOUNT] in [MONTH]\\\\\\\\n- Seasonality: [STRONG MONTHS] and [WEAK MONTHS]\\\\\\\\n\\\\\\\\n**Build 3 Scenarios:**\\\\\\\\n\\\\\\\\n1) **Pessimistic** (revenue decline of [X]%):\\\\\\\\n- Month-by-month revenue\\\\\\\\n- Break-even point\\\\\\\\n- Months with negative cash flow\\\\\\\\n- Contingency actions\\\\\\\\n\\\\\\\\n2) **Base** (organic growth of [X]%/month):\\\\\\\\n- Month-by-month revenue and expenses\\\\\\\\n- Projected net margin\\\\\\\\n- Working capital requirements\\\\\\\\n\\\\\\\\n3) **Optimistic** (accelerated growth of [X]%/month):\\\\\\\\n- Projected revenue\\\\\\\\n- Additional viable investments\\\\\\\\n- Possible new hires\\\\\\\\n\\\\\\\\n**For each scenario, include:**\\\\\\\\n- Simplified monthly projected income statement (P&L)\\\\\\\\n- Projected cash flow statement\\\\\\\\n- Metrics: gross margin, net margin, EBITDA, burn rate\\\\\\\\n- Decision triggers (e.g., if revenue drops X%, activate Plan B)\\\\\\\\n\\\\\\\\nFormat as a monthly table ready for Excel/Google Sheets.