Communitygithub.com

投资组合公司回报建模(PE建模)

构建PE回报模型,包含进入/退出倍数、杠杆分析以及价值创造归因。适用于建模PE回报、计算IRR/MOIC或归因价值创造驱动因素。

投资组合公司回报建模(PE建模) 是什么?

这是一个专为私募股权(PE)或成长型股权投资专业人士设计的AI技能,用于对投资组合公司的预期或已实现回报进行全面建模。该技能涵盖从构建资金来源与用途表、运营预测、债务时间表到计算关键回报指标(如MOIC、IRR、现金回报率)的完整工作流程。它能自动生成价值创造桥,将回报分解为收入增长、利润扩张、倍数扩张和杠杆效应。支持情景分析和敏感性分析,可测试购买价格、杠杆和退出假设对回报的影响。该技能广泛适用于投资委员会备忘录、LP报告、基金业绩追踪和投资决策支持,兼容Claude Code、Cursor、Codex等主流AI编码助手。

兼容平台✓Claude Code~Codex CLI~Cursor
npx skills add https://github.com/Mr-Nobody-Anonymous/All-skills/tree/HEAD/awesome_skills/finance/modeling-portfolio-company-returns

在你喜欢的 AI 中提问

打开一个已预加载此 Agent Skill 的新对话。

文档

建模投资组合公司回报

使用时机

  • 对PE/成长型股权投资组合公司的预期或已实现回报进行建模
  • 计算持有期内的IRR、MOIC和现金回报率
  • 将价值创造归因于收入增长、利润扩张、倍数扩张和杠杆偿还
  • 为投资委员会备忘录或LP报告比较进入与退出经济状况
  • 对购买价格、杠杆和退出假设下的回报进行压力测试

需收集的输入

  • 进入交易详情:购买价格(企业价值)、股权支票规模、进入EV/EBITDA倍数、交易费用、资金来源与用途
  • 进入时的资本结构:优先债、次级债、夹层债、卖方票据、转股权、管理层股权;利率及摊销安排
  • 运营预测:持有期(通常3-7年)的收入、EBITDA和自由现金流预测;资本支出、营运资本和税收假设
  • 退出假设:目标退出EV/EBITDA倍数、预期退出年份、退出交易成本
  • 额外现金流:附加收购、股息资本重组、管理费、监督费或其他中期分配
  • 基准背景:可比交易倍数、行业中位数回报或基金层面回报目标,用于合理性检查

工作流程

  1. 构建资金来源与用途表

    • 在用途方映射企业总价值、交易费用及融资费用
    • 在来源方列出债务分层、赞助商股权、转股权及任何共同投资
    • 确认总来源等于总用途
  2. 构建运营模型

    • 逐年预测持有期内的收入、EBITDA和无杠杆自由现金流
    • 应用营运资本变动、资本支出和税收假设得出可用于偿债的自由现金流
    • 若建模了附加收购,在相关年份叠加增量EBITDA和购买价格
  3. 建模债务时间表

    • 对每个分层:期初余额、强制摊销、现金扫除(如适用)、利息费用及期末余额
    • 计算每个预测退出年份的剩余总债务
    • 分别追踪累计现金利息与PIK利息
  4. 计算退出收益及股权瀑布分配

    • 对每个候选退出年份的预测EBITDA应用退出倍数
    • 扣除剩余净债务和交易成本得出退出时的股权价值
    • 将股权收益通过瀑布分配流程:优先回报基础、GP补足、附带权益分成及管理层期权池稀释(如适用)
  5. 计算回报指标

    • MOIC:总股权分配 ÷ 总投资股权
    • 毛IRR:股权现金流(进入、中期分配、退出)的内部收益率
    • 净IRR:扣除管理费和附带权益后 [确认基金层面费用结构]
    • 现金回报率:累计现金回报 ÷ 投资股权(对股息资本重组情景有用)
    • DPI / TVPI:用于基金层面汇总投资组合
  6. 执行价值创造桥

    • 将总股权回报分解为四个驱动因素:
      • 收入/EBITDA增长:在恒定进入倍数下EBITDA的增长
      • 利润扩张:在恒定收入下来自利润改善的增量EBITDA
      • 倍数扩张:进入和退出倍数之差应用于退出EBITDA
      • 杠杆效应(FCF和债务偿还):持有期内债务减少带来的股权增值
    • 以瀑布图或桥表呈现,合计为总股权收益
  7. 执行敏感性和情景分析

    • 对进入倍数 vs. 退出倍数以及EBITDA增长 vs. 杠杆进行双变量敏感性表
    • 下行、基准和上行情景,并明确标注假设集
    • 盈亏平衡分析:实现1.0倍MOIC所需的最小退出倍数或EBITDA水平

输出

  • 资金来源与用途表,清晰标注债务和股权组成部分
  • 年度运营预测,包含收入、EBITDA、FCF和债务余额
  • 回报汇总表:每个退出年份(第3年至第7年)的MOIC、毛IRR、净IRR
  • 价值创造桥:对增长、利润、倍数和杠杆驱动因素的量化归因
  • 敏感性表:至少包括进入/退出倍数网格和EBITDA增长/退出倍数网格
  • 关键假设登记表:列出每个重要假设及其来源或[确认]标签

质量检查

  • 资金来源与用途必须精确平衡——标出任何舍入差异
  • IRR计算必须使用实际现金流日期(或如指定使用年中惯例);确认债务扫除计算中无循环引用
  • 退出股权价值必须可核对:退出EV减去净债务减去费用等于赞助商股权
  • 价值创造桥各组成部分之和必须等于总股权收益,MOIC舍入容差在±0.1倍以内
  • 确认每个预测年份的杠杆比率(债务/EBITDA)保持在契约限制内 [确认信贷协议中的具体契约门槛]
  • 将建模回报与行业基准进行交叉核对——若毛IRR超过40%或低于10%,则标记为需要额外审阅假设
  • 确认附带权益和管理费抵消的税务处理与基金LPA条款一致 [确认司法管辖区特定税率和基金条款]

Individual skills in this repo

This repo contains 20 individual skills — each has its own dedicated page.

Mr-Nobody-Anonymous/All-skills

Build agency portfolios. TRIGGERS - Use when user needs help with agency-portfolio-builder related tasks.

Mr-Nobody-Anonymous/All-skills

Generate landing pages with AI. TRIGGERS - Use when user needs help with ai-landing-page-gen related tasks.

Mr-Nobody-Anonymous/All-skills

Skill for discovering and researching autonomous AI agents, tools, and ecosystems using the AgentFolio directory.

Mr-Nobody-Anonymous/All-skills

Review investment portfolios with rebalancing recommendations. TRIGGERS - Use when user needs help with investment-portfolio-review related tasks.

Mr-Nobody-Anonymous/All-skills

Create makeup artist portfolio guides. TRIGGERS - Use when user needs help with makeup-artist-portfolio related tasks.

Mr-Nobody-Anonymous/All-skills

Build freelance portfolios with case studies. TRIGGERS - Use when user needs help with freelance-portfolio-builder related tasks.

Mr-Nobody-Anonymous/All-skills

Structures secondary portfolio construction with vintage diversification, strategy mix, and geographic allocation optimization. Use when building secondary portfolios, managing allocation targets, or optimizing portfolio composition.

Mr-Nobody-Anonymous/All-skills

Optimize landing page copy for conversions. TRIGGERS - Use when user needs help with landing-page-optimizer related tasks.

Mr-Nobody-Anonymous/All-skills

Build copywriting portfolios. TRIGGERS - Use when user needs help with copywriting-portfolio related tasks.

Mr-Nobody-Anonymous/All-skills

Design cryptocurrency portfolio strategies. TRIGGERS - Use when user needs help with crypto-portfolio-strategy related tasks.

Mr-Nobody-Anonymous/All-skills

Build UX design portfolios. TRIGGERS - Use when user needs help with ux-portfolio-builder related tasks.

Mr-Nobody-Anonymous/All-skills

Design cloud landing zones. TRIGGERS - Use when user needs help with cloud-landing-zone related tasks.

Mr-Nobody-Anonymous/All-skills

Generate high-converting landing page copy with headlines, benefits, CTAs, and social proof. TRIGGERS - Use when user wants landing page copy, sales page content, or conversion-focused web copy.

Mr-Nobody-Anonymous/All-skills

Design portfolio assessment systems. TRIGGERS - Use when user needs help with portfolio-assessment related tasks.

Mr-Nobody-Anonymous/All-skills

Conducts portfolio performance measurement with benchmark comparison, attribution, and risk-adjusted metrics. Use when measuring portfolio performance, calculating Sharpe/Sortino ratios, or conducting performance attribution.

Mr-Nobody-Anonymous/All-skills

Builds strategic and tactical asset allocation models with risk-return optimization and constraint management. Use when constructing portfolios, optimizing asset allocation, or building model portfolios.

Mr-Nobody-Anonymous/All-skills

Creates client-facing portfolio reports with performance, allocation, commentary, and outlook. Use when producing client reports, preparing quarterly reviews, or creating portfolio summaries.

Mr-Nobody-Anonymous/All-skills

Design investment portfolios. TRIGGERS - Use when user needs help with investment-portfolio-design related tasks.

Mr-Nobody-Anonymous/All-skills

Plan investment portfolios. TRIGGERS - Use when user needs help with investment-portfolio-plan related tasks.

Mr-Nobody-Anonymous/All-skills

You are a Conversion Rate Optimization Strategist and Persuasive Content Specialist. Use this skill when the user wants to audit or improve a landing page, write conversion-focused copy, optimize CTAs, build an FAQ schema block, translate features into benefits, or maximize conversions on any specific page type. Activate when the user mentions "landing page," "sales page," "lead capture page," "squeeze page," "webinar sign-up page," "product launch page," "waitlist page," "early access page," "thank you page," "upsell page," "SaaS pricing page," "onboarding page," "ecommerce page," "audit this page," "improve conversions," "CTA optimization," "hero section," "headline rewrite," "subhead," "benefits section," "features to benefits," "FAQ schema," "schema FAQ," "trust elements," "page layout," "above the fold," "scroll order," "microcopy," "mobile-first copy," "landing page copy," "page flow," "drop-off," "weak CTA," "conversion copy," "page goal," "split test copy," "A/B test copy," or "wireframe suggestion...

相关技能