Break-Even Analysis & Cash Runway Calculator

Build a break-even analysis and cash runway model for my startup. Use the following inputs: **Current Monthly Revenue:** {&{CURRENT_MRR}} **Monthly Revenue Growth Rate:** {&{MONTHLY_GROWTH_RATE}} **Current Cash in Bank:** {&{CASH_BALANCE}} **Monthly Headcount Cost (fully loaded):** {&{HEADCOUNT_COST}} **Other Monthly Operating Costs:** {&{OTHER_OPEX}} (infrastructure, tools, rent, marketing) **Planned New Hires in Next 6 Months:** {&{PLANNED_HIRES}} **COGS as % of Revenue:** {&{COGS_PERCENT}} --- Deliver the following: **1. Monthly Burn Breakdown** Break total monthly burn into categories. Show: Category | Monthly Cost | % of Total Burn **2. Revenue Trajectory** Project monthly revenue for months 1–18 using the growth rate. Show when monthly revenue crosses monthly operating costs (gross profit break-even month). **3. Cash Runway Calculation** At current burn rate (before new hires): runway in months. At projected burn rate (after planned hires): revised runway in months. Fundraising window: when must the next raise process begin to avoid a cash gap? **4. Scenario Analysis (3 Scenarios)** Show the impact on break-even month of: - Scenario A: Delay planned hires by 3 months - Scenario B: Revenue growth rate increases from current to +5 percentage points - Scenario C: Cut non-headcount costs by 20% Present as a table: Scenario | Break-Even Month Change | Cash at Month 18 **5. Top Lever Identification** Which single decision has the largest impact on runway extension? What is the specific action and what is the runway extension in weeks or months? **6. Financial Health Assessment** Rate the current financial position: Strong / Adequate / Tight / Critical. Explain in 2 sentences.