returns-analysis
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".
What this skill does
# 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: | Metric | Value | |--------|-------| | 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 6x | Exit 7x | Exit 8x | Exit 9x | Exit 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: | | Bull | Base | Bear | |---|------|------|------| | 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
Related in Ads & Marketing
ads
IncludedMulti-platform paid advertising audit and optimization skill. Analyzes Google, Meta, YouTube, LinkedIn, TikTok, Microsoft, and Apple Ads. 250+ checks with scoring, parallel agents, industry templates, and AI creative generation.
banana
IncludedAI image generation Creative Director powered by Google Gemini Nano Banana models. Use this skill for ANY request involving image creation, editing, visual asset production, or creative direction. Triggers on: generate an image, create a photo, edit this picture, design a logo, make a banner, visual for my anything, and all /banana commands. Handles text-to-image, image editing, multi-turn creative sessions, batch workflows, and brand presets.
rpg-migration-analyzer
IncludedAnalyzes legacy RPG (Report Program Generator) programs from AS/400 and IBM i systems for migration to modern Java applications. Extracts business logic from RPG III/IV/ILE source code, identifies data structures (D-specs), file operations (F-specs), program dependencies (CALLB/CALLP), and converts RPG constructs to Java equivalents. Generates migration reports, complexity estimates, and Java implementation strategies with POJO classes, JPA entities, and service methods. Use when modernizing AS/400 or IBM i legacy systems, analyzing RPG source files (.rpg, .rpgle, .RPGLE), converting RPG to Java, mapping data specifications to Java classes, planning legacy system migration, or when user mentions RPG analysis, Report Program Generator, RPG III/IV/ILE, AS/400 modernization, IBM i migration, packed decimal conversion, or mainframe application rewrite.
brand-library-architect
IncludedBuild a complete brand library for a product — visual asset render pipeline, brand documentation set (BRAND, COPY, MANIFESTO, BIOS, FAQ, GLOSSARY, TONE, PRICING), open-source convention files (README, CONTRIBUTING, SECURITY, CODE_OF_CONDUCT), and a self-contained press kit. This skill should be used when the user asks to "build a brand library / brand kit / press kit / brand assets" for a product, "set up a brand library workflow," "create a positioning manifesto plus visual identity," or any combination of brand documentation + visual asset pipeline. Apply phase-by-phase or run end-to-end. Templates are product-agnostic and use {{TOKEN}} placeholders the skill prompts the user to fill.
writing-tech-post
IncludedAuthors engineering blog posts end-to-end: launch deep-dives, incident postmortems, architecture migrations, performance case studies, tutorials, AI/agent system writeups, security disclosures, and research-to-product translations. Picks the correct archetype, plans the abstraction ladder, enforces an evidence cadence (diagrams, benchmarks, profiles, traces, code, ablations), tunes voice against publisher house styles (Datadog, Vercel, GitHub, AWS, Meta, Cloudflare, Jane Street), and runs a pre-publish gate for narrative momentum and disclosure ethics. Use when drafting a new engineering post, restructuring a draft that feels flat, deciding which evidence form belongs where, validating that depth and product context are balanced, or preparing a postmortem, migration, or performance narrative for external publication. Do not use for API reference documentation, README authoring, marketing copy, release notes, generic SEO content, ghost-written executive thought leadership, or non-engineering long-form essays.
blog-google
IncludedGoogle API integration for blog performance: PageSpeed Insights, CrUX Core Web Vitals with 25-week history, Search Console performance, URL Inspection, Indexing API, GA4 organic traffic, NLP entity analysis for E-E-A-T, YouTube video search for embedding, and Google Ads Keyword Planner. Progressive feature availability based on credential tier (API key, OAuth/service account, GA4, Ads). Shares config with claude-seo at ~/.config/claude-seo/google-api.json. Use when user says "google data", "page speed", "core web vitals", "search console", "indexation", "GA4", "keyword research", "nlp entities", "blog performance", "youtube search", "google api setup".