I'm running a quarterly portfolio burn analysis. I've uploaded a spreadsheet with quarterly ARR, operating expenses, revenue, and cash balance data for my portfolio companies. For each company: - Calculate net burn. Use a reported burn figure if present. Otherwise, calculate as Total OpEx minus Total Revenue and note that it's derived. - Calculate revenue growth rate. Use YoY if prior-year data exists, QoQ otherwise. Label which method. - Calculate burn multiple: net burn ÷ net new ARR for the most recent quarter. If net new ARR is zero or negative, mark as "Not Meaningful." - Calculate runway in months: ending cash balance ÷ average monthly burn over the last 2 quarters. If a fundraise amount is noted, exclude it from the burn calculation for that quarter. - Show the burn trend over the last 4 quarters: increasing, stable, or declining. Produce: - A summary table with: Company, Currency, ARR, Growth Rate, Net Burn, Burn Multiple, Burn Trend, Cash Balance, Runway, Flags. - A 2×2 scatter chart: X-axis = Growth Rate (%), Y-axis = Burn Multiple (inverted, 0x at top). Use portfolio median growth rate as the vertical reference line and 2.0x as the horizontal. Label quadrants: Stars, Efficient but Slow, Growth at a Cost, At Risk. Flag any company under 12 months of runway, burn multiple above 3x, or burn increasing for 2+ consecutive quarters. Include portfolio-level summary stats (median burn multiple, median runway) and highlight the top performer and any companies requiring immediate attention. Before calculating, confirm the fiscal year convention per company.