Portfolio company management review sheet
- Revenue growth year on year, percent
- 50
- Runway, months
- 12.5
- Headcount change, percent
- 12.5
- Position value at the fund's mark, dollars
- $7,200,000
Every figure on this page is computed from the inputs entered, by the method stated below it. LPreportly publishes no valuation, no benchmark multiple, no target growth rate and no loss ratio of its own: the marks, the KPIs and the ownership are your fund's own figures.
The figures above start from a worked example (50), a fund's own numbers rather than anybody's benchmark. Change any input and the answer updates as you type.
Download the Portfolio company management review sheet worked example (CSV)
This is a portfolio company management review sheet that builds one company's quarter from the KPIs it reported and the fund's own position in it. Revenue this quarter against the same quarter last year is the growth; cash over monthly burn is the runway in months; headcount against last quarter is the team's change; and the fund's ownership times the company's value at the fund's mark, against cost, is the position's value, gain and multiple. Every input is the company's own report and the fund's own mark; the sheet publishes no benchmark growth rate, no runway rule and no valuation. Free, on the page, no account; the paid plan builds the review document from the figures under your fund's name and keeps every quarter's sheet against the holding.
Growth and runway, the two sentences every review opens with
$3,000,000 this quarter against $2,000,000 a year ago is 50% growth; $5,000,000 of cash at $400,000 of monthly burn is 12.5 months of runway. Both are the company's own numbers worked into the form the partners read, and both are filed by quarter in the paid plan so the review can say whether they moved.
The team
45 people against 40 last quarter is 12.5% headcount growth. A small number that says a great deal beside the burn: a company growing headcount faster than revenue has a runway sentence coming, and the sheet puts the three figures on one line so the reviewer sees it.
The position, restated at the mark
12% of a $60,000,000 mark is a $7,200,000 position, $3,200,000 above its $4,000,000 cost, 1.8x. The review's last line, restated from the same mark the portfolio monitoring worksheet uses, so the company's quarter and the fund's position in it sit on one sheet.
Where the constants in this tool come from
ILPA Reporting Template definitions.
ILPA Reporting Template (v. 2.0), Institutional Limited Partners Association.
Portfolio company management review sheet: what portfolio teams ask
What should a portfolio company review contain?
The KPIs the company reported this quarter worked into growth, runway and headcount change, the fund's position in it at the fund's mark, and a line on what changed. The sheet builds the figures; the paid plan keeps every quarter's sheet against the holding.
Which KPIs does the sheet use?
Revenue this quarter and the same quarter last year, cash and monthly burn, headcount now and last quarter, plus the fund's ownership, the mark and the cost. Nine inputs, six worked figures, and no benchmark for any of them.
Does the review sheet tell me whether a company is doing well?
No. It works the company's own figures into the form the review reads and publishes no target growth rate, runway rule or benchmark. Whether 50% growth and 12.5 months are good for this company is the partners' judgement.