본문으로 건너뛰기
cccskills
무료GitHub에 공개

returns-analysis

Estimate private equity deal returns across purchase prices, borrowing levels, growth assumptions, exit prices, and holding periods. Produce Excel sensitivity tables showing annualized returns and investment multiples, plus scenario comparisons and a one-page investment committee summary.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

원문원문 설명 보기

Build quick IRR/MOIC sensitivity tables for PE deal evaluation. Models returns across entry multiple, leverage, exit multiple, growth, and hold period scenarios. Use when sizing up a deal, stress-testing assumptions, or preparing IC returns exhibits. Triggers on "returns analysis", "IRR sensitivity", "MOIC table", "what's the return at", "model the returns", or "back of the envelope".

anthropics/financial-services
설치 방법 보기

이럴 때 유용합니다

  • Estimate returns for a potential acquisition
  • Compare purchase and exit valuation assumptions
  • Stress-test growth and borrowing assumptions
  • Prepare return exhibits for an investment committee

포함된 파일(1)

  • SKILL.md3.3 KB

SKILL.md(원문)

설치하기 전에 에이전트에게 전달되는 지시 내용을 확인할 수 있습니다.

Returns Analysis

Workflow

Step 1: Gather Deal Inputs

Ask for (or extract from prior analysis):

Entry:

  • Entry EBITDA (LTM or NTM)
  • Entry multiple (EV / EBITDA)
  • Enterprise value
  • Net debt at close
  • Equity check size
  • Transaction fees & expenses

Financing:

  • Senior debt (x EBITDA, rate, amortization)
  • Subordinated debt / mezzanine (if any)
  • Total leverage at entry (x EBITDA)
  • Equity contribution

Operating Assumptions:

  • Revenue growth rate (annual)
  • EBITDA margin trajectory
  • Capex as % of revenue
  • Working capital changes
  • Debt paydown schedule

Exit:

  • Hold period (years)
  • Exit multiple (EV / EBITDA)
  • Exit EBITDA (calculated from growth assumptions)

Step 2: Base Case Returns

Calculate:

MetricValue
Entry EV
Equity invested
Exit EBITDA
Exit EV
Net debt at exit
Exit equity value
MOIC
IRR
Cash-on-cash

Show the returns waterfall:

  • EBITDA growth contribution
  • Multiple expansion/contraction contribution
  • Debt paydown contribution
  • Fee/expense drag

Step 3: Sensitivity Tables

Build 2-way sensitivity matrices:

Entry Multiple vs. Exit Multiple

Exit 6xExit 7xExit 8xExit 9xExit 10x
Entry 7x
Entry 8x
Entry 9x
Entry 10x

EBITDA Growth vs. Exit Multiple (at fixed entry)

Leverage vs. Exit Multiple (at fixed entry and growth)

Hold Period vs. Exit Multiple

Show both IRR and MOIC in each cell (IRR / MOIC format).

Step 4: Scenario Analysis

Build 3 scenarios:

BullBaseBear
Revenue CAGR
Exit EBITDA margin
Exit multiple
Exit EBITDA
MOIC
IRR

Step 5: Output

  • Excel workbook with:
    • Assumptions tab
    • Returns calculation
    • Sensitivity tables (formatted with conditional coloring)
    • Scenario summary
  • One-page returns summary suitable for IC deck

Key Formulas

  • MOIC = Exit Equity Value / Equity Invested
  • IRR = solve for r: Equity Invested × (1 + r)^n = Exit Equity Value (adjust for interim cash flows)
  • Returns attribution:
    • Growth: (Exit EBITDA - Entry EBITDA) × Exit Multiple / Equity
    • Multiple: (Exit Multiple - Entry Multiple) × Entry EBITDA / Equity
    • Leverage: Debt paydown over hold period / Equity

Important Notes

  • Always show returns both gross and net of fees/carry where applicable
  • Management rollover and co-invest change the equity check — ask if relevant
  • Dividend recaps or interim distributions affect IRR significantly — include if planned
  • Don't forget transaction costs (typically 2-4% of EV) — they reduce Day 1 equity value
  • Tax considerations (asset vs. stock deal, 338(h)(10) election) can materially affect after-tax returns

리뷰

아직 리뷰가 없습니다. 사용해 본 소감을 남겨 주세요.

댓글

로그인 없이 쓸 수 있습니다. 사용 후기, 질문, 작동하지 않은 환경 등을 편하게 남겨 주세요.

아직 댓글이 없습니다. 첫 댓글을 남겨 보세요.

보내면 바로 공개됩니다. 이메일 주소나 전화번호 같은 개인 정보는 쓰지 마세요. URL은 2개까지입니다.

0 / 1,000자

이 양식은 reCAPTCHA로 보호되며 Google 개인정보처리방침 및 서비스 약관이 적용됩니다.

같은 저장소의 스킬

3-statement-model

무료

Complete an existing financial model template by entering historical data and forecast assumptions, then linking the income statement, balance sheet, and cash flow statement with formulas. Check statement balances, cash consistency, and scenario behavior as each section is completed.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

  • Complete a partially filled financial model
  • Link forecasts across three financial statements
  • Check balance sheet and cash flow consistency
anthropics/financial-services4만2026년 9월 22일 업데이트

accrual-schedule

무료

Prepare a period-end accrual schedule for expenses incurred but not yet fully recorded. Apply company policy, subtract amounts already booked, cite supporting records, and draft journal entries for controller approval, including reversal notes where required.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

  • Preparing an accrual schedule for month-end close
  • Calculating audit fee, bonus, or utilities accruals
  • Drafting journal entries with supporting references
anthropics/financial-services4만2026년 9월 22일 업데이트

ai-readiness

무료

Review quarterly updates and financials across portfolio companies to identify practical AI opportunities. Rank them by estimated profit impact, speed, and feasibility, then outline first steps and approaches that other companies can reuse.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

  • Quarterly reviews of AI opportunities across portfolio companies
  • Prioritizing companies for AI investment and operational support
  • Finding ways to reuse successful AI projects across companies
anthropics/financial-services4만2026년 9월 22일 업데이트

audit-xls

무료

Check spreadsheet formulas for errors, broken references, inconsistent calculations, and unit mismatches. Review a selected range, one sheet, or an entire financial model, then receive findings ranked by severity with suggested fixes.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

  • Checking formulas in a selected range
  • Investigating a balance sheet that does not balance
  • Reviewing a financial model before client delivery
anthropics/financial-services4만2026년 9월 22일 업데이트

bond-futures-basis

무료

Analyze price differences between bond futures and cash bonds, identify the cheapest bond to deliver, and compare implied financing rates with market rates. Present valuation tables and historical context to assess potential basis trades.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

  • Comparing bond futures with cash bond prices
  • Identifying the cheapest bond to deliver
  • Comparing implied financing rates with market rates
anthropics/financial-services4만2026년 9월 22일 업데이트

bond-relative-value

무료

Assess whether bonds are expensive, cheap, or fairly priced by comparing yields with government rates and credit risk benchmarks. Combine spread breakdowns, historical context, and interest rate scenarios into tables and a recommendation.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

  • Comparing the relative value of candidate bonds
  • Separating credit risk from other yield differences
  • Estimating gains and losses under interest rate shifts
anthropics/financial-services4만2026년 9월 22일 업데이트

anthropics의 스킬 모두 보기

이 스킬의 문제 신고