Communitygithub.com

Mr-Nobody-Anonymous/All-skills

建立 PE 回報模型,包含進出場倍數、槓桿分析與價值創造歸因。適用於 PE 回報建模、計算 IRR/MOIC 或歸因價值創造驅動因素。

All-skills 是什麼?

此技能專門為私募股權 (PE) 或成長型股權投資組合公司的回報建模而設計,支援從交易輸入到回報計算的完整工作流程。使用者可以分析進場與出場的企業價值倍數、槓桿結構及營運預測,並計算 IRR、MOIC 和現金對現金回報等關鍵績效指標。技能亮點在於其價值創造橋樑功能,能將股權回報分解為營收/EBITDA 成長、利潤率擴張、倍數擴張和槓桿效應(自由現金流與債務償還)四大驅動因素,並以瀑布圖或橋樑表呈現。此外,技能還提供敏感性分析(如進場倍數 vs. 出場倍數表格)和情境分析(下行、基準、上行),協助使用者壓力測試假設條件。內建品質檢查機制,確保資金來源與用途平衡、IRR 計算基於實際現金流日期、槓桿比率符合契約限制,以及模型回報與行業基準交叉比對。此技能適用於多種平台(例如 Claude Code、Cursor、Codex 等),開發者可直接整合至其 AI 代理工作流程中,快速生成專業的 PE 回報分析模型。

相容平台✓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
      • 槓桿效應(自由現金流與債務償還):持有期間因債務減少帶來的權益增值
    • 以瀑布圖或橋樑表呈現,各項加總等於總權益收益
  7. 執行敏感性和情境分析

    • 進場倍數 vs. 出場倍數以及 EBITDA 成長 vs. 槓桿的雙變量敏感性表
    • 標示假設集的下行、基準和上行情境
    • 損益平衡分析:達到 1.0x MOIC 所需的最低出場倍數或 EBITDA 水準

輸出結果

  • 資金來源與用途表,清楚標示債務和權益組成
  • 年度營運預測,包含營收、EBITDA、自由現金流和債務餘額
  • 回報摘要表:每個出場年份(第 3 年至第 7 年)的 MOIC、總 IRR、淨 IRR
  • 價值創造橋樑:量化歸因於成長、利潤率、倍數和槓桿驅動因素
  • 敏感性表:至少包含進場/出場倍數網格和 EBITDA 成長/出場倍數網格
  • 關鍵假設登記簿:每項重大假設均標明來源或帶有 [確認] 標籤

品質檢查

  • 資金來源與用途必須精確平衡 — 標記任何四捨五入差異
  • IRR 計算必須使用實際現金流日期(或若指定,使用年中慣例);確認債務清償計算中無循環參照
  • 出場權益價值必須對帳:出場 EV 減去淨債務再減去費用等於贊助商權益
  • 價值創造橋樑各組成部分加總必須等於總權益收益,MOIC 四捨五入容差在 ±0.1x 內
  • 確認每個預測年份的槓桿比率(債務/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...

相關技能