USE CASE/

COMPANY PERFORMANCE ANALYSIS

VISUALIZATION

Portfolio Burn Analysis Copy

Burn multiple alone is only half the picture. Plot it against growth rate and you can see in one chart which portfolio companies are growing efficiently and which are burning faster than they're growing.

  1. Prepare your Data

Prepare a single spreadsheet — one row per company per quarter. This is the input file the AI needs to run the analysis. Add the following metrics for each company:

ARR or Revenue
Ending value for each quarter

Total OpEx & Revenue
To derive net burn if no direct figure

Cash in Bank
End-of-quarter balance

Include columns for company name, quarter, FY convention, currency. Note any fundraise amounts. Cover 4 quarters for QoQ, or include prior-year quarters for YoY. If a quarter is missing, leave the row blank.

Download sample input file

  1. Run the Analysis

Once your data is set, run the prompt to generate your burn-vs-growth matrix and portfolio summary.

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.

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.

Copy prompt

Copied

  1. Go Deeper

Use these follow-ups to push the analysis further.

Stress-test runway
"Model runway at current burn and at burn +20%. Which companies cross the 12-month line?"

Try on PortfolioIQ

In most analyses like this, data prep is the hardest part. With PortfolioIQ, your portfolio data is always analysis-ready — no prep required.

Request a Demo

Create a 2x2 visual with burn multiple and growth for all my portfolio companies