unit-economics

Analyze CSV cohort data to compute LTV/CAC and net retention metrics.

Updated Apr 25, 2026
One-click install
npx skills add https://github.com/bolnet/private-equity --skill unit-economics-bolnet
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: unit-economics
Source: https://github.com/bolnet/private-equity/tree/main/finance-mcp-plugin/skills/private-equity/unit-economics
Command: npx skills add https://github.com/bolnet/private-equity --skill unit-economics-bolnet

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, numpy, matplotlib, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides PE professionals with the ability to analyze revenue quality, customer economics, and cohort data to make informed decisions about portfolio or target company health.

Core Features & Use Cases

  • Cohort Data Profiling: Profile and summarize cohort data before analysis.
  • ARR Cohort Waterfall Analysis: Visualize retention behavior by vintage.
  • LTV / CAC Analysis: Compute customer lifetime value and acquisition cost.
  • Net Revenue Retention Analysis: Decompose net dollar retention for the trailing 12-month period.
  • Revenue Quality Scorecard: Assess the overall quality of a company's revenue stream.
  • Use Case: A PE professional can use this Skill to analyze the revenue quality of a target company by building an ARR cohort waterfall, calculating LTV/CAC, and assessing net dollar retention.

Quick Start

Analyze the revenue quality of the attached CSV file 'customer_data.csv' using the unit-economics skill.

Frequently Asked Questions about unit-economics

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I analyze revenue quality and customer economics from a CSV file?

You can analyze revenue quality and customer economics by ingesting CSV data to compute LTV/CAC, net retention, and cohort metrics. This process generates cohort-based insights to help private equity professionals evaluate portfolio or target company health.

What is an ARR cohort waterfall and how does it show retention behavior?

An ARR cohort waterfall visualizes retention behavior by customer vintage. It decomposes recurring revenue movements across cohorts, allowing you to track expansion, contraction, and churn within specific customer acquisition timeframes to assess overall revenue stability.

Can I calculate LTV and CAC metrics using pandas and numpy for private equity analysis?

Yes, you can calculate LTV and CAC metrics using Python with pandas and numpy. The analysis processes raw customer data to compute lifetime value and acquisition costs, producing metrics tailored for private equity revenue quality assessments.

How do I decompose net revenue retention for a trailing 12-month period?

To decompose net revenue retention for a trailing 12-month period, you analyze cohort data to separate expansion, downgrade, and churn components. This breakdown reveals the underlying drivers of net dollar retention over the past year.

Does this cohort analysis approach work for assessing private equity target companies?

Yes, cohort analysis works for assessing private equity target companies by profiling cohort data and generating a revenue quality scorecard. It evaluates customer economics and net retention metrics to support informed investment decisions.

What is the best way to visualize customer retention metrics using matplotlib?

The best way to visualize customer retention metrics using matplotlib is by building an ARR cohort waterfall. This approach graphs retention behavior by vintage, allowing you to visually compare revenue quality across different customer groups.