{"id":"4d1becb1-5414-4f31-b563-fb553c338ac8","entityType":"agent","slug":"clawhub-fenccerece-financial-services","name":"claude financial-services for openclaw","canonicalUrl":"https://www.xpersona.co/agent/clawhub-fenccerece-financial-services","canonicalPath":"/agent/clawhub-fenccerece-financial-services","generatedAt":"2026-10-12T13:56:14.097Z","source":"CLAWHUB","claimStatus":"UNCLAIMED","verificationTier":"NONE","summary":{"evidence":{"source":"editorial-content","verified":true,"confidence":"high","updatedAt":"2026-10-12T01:05:49.584Z","emptyReason":null},"description":"Complete financial analysis methodology for OpenClaw. A 6-skill collection covering investment banking, commercial banking, asset management, insurance, sour... Skill: claude financial-services for openclaw Owner: fenccerece Summary: Complete financial analysis methodology for OpenClaw. A 6-skill collection covering investment banking, commercial banking, asset management, insurance, sour... Tags: latest:1.0.0 Version history: v1.0.0 | 2026-05-09T06:51:34.979Z | user Initial release of the financial-services skill collection for OpenClaw: - Introduces a comprehensive methodo","descriptionLabel":"Technical summary","evidenceSummary":"Capability contract not published. No trust telemetry is available yet. 963 downloads reported by the source. Last updated 10/12/2026.","installCommand":"clawhub skill install s17fmkyfk8381hxzq5rtdj0jj184f9bj:financial-services","sourceUrl":"https://clawhub.ai/fenccerece/financial-services","homepage":"https://clawhub.ai/fenccerece/skills/financial-services","primaryLinks":[{"label":"View on ClawHub","url":"https://clawhub.ai/fenccerece/financial-services","kind":"source"},{"label":"Homepage","url":"https://clawhub.ai/fenccerece/skills/financial-services","kind":"homepage"}],"safetyScore":84,"overallRank":62,"popularityScore":60,"trustScore":null,"claimedByName":null,"isOwner":false,"seoDescription":"Complete financial analysis methodology for OpenClaw. A 6-skill collection covering investment banking, commercial banking, asset management, insurance, sour..."},"coverage":{"evidence":{"source":"public-profile","verified":false,"confidence":"medium","updatedAt":"2026-10-12T01:05:49.584Z","emptyReason":null},"protocols":[{"protocol":"OPENCLEW","label":"OpenClaw","status":"self-declared","notes":"Declared in the public agent profile."}],"capabilities":[],"verifiedCount":0,"selfDeclaredCount":1,"capabilityMatrix":{"rows":[{"key":"OPENCLEW","type":"protocol","support":"unknown","confidenceSource":"profile","notes":"Listed on profile"}],"flattenedTokens":"protocol:OPENCLEW|unknown|profile"}},"adoption":{"evidence":{"source":"CLAWHUB","verified":false,"confidence":"medium","updatedAt":"2026-10-12T01:05:49.584Z","emptyReason":null},"stars":null,"forks":null,"downloads":963,"likes":null,"task":null,"library":null,"packageName":null,"latestVersion":"1.0.0","tractionLabel":"963 downloads"},"release":{"evidence":{"source":"CLAWHUB","verified":false,"confidence":"medium","updatedAt":"2026-10-12T01:05:49.461Z","emptyReason":null},"lastUpdatedAt":"2026-10-12T01:05:49.584Z","lastCrawledAt":"2026-10-12T01:05:49.461Z","lastIndexedAt":null,"nextCrawlAt":"2026-10-13T01:05:49.461Z","lastVerifiedAt":null,"highlights":[{"version":"1.0.0","createdAt":"2026-05-09T06:51:34.979Z","changelog":"Initial release of the financial-services skill collection for OpenClaw: - Introduces a comprehensive methodology for financial analysis, modeling, due diligence, and report generation. - Includes 6 integrated skills covering investment banking, commercial banking, asset management, insurance, source attribution, and standardized output. - Each skill supports core workflows such as pitch books, underwriting, portfolio reporting, actuarial analysis, and verification. - Designed for seamless installation and auto-discovery within the OpenClaw platform. - Requires no additional dependencies; optional data provider integration available. - Licensed under MIT-0.","fileCount":10,"zipByteSize":26350}]},"execution":{"evidence":{"source":"CLAWHUB","verified":false,"confidence":"low","updatedAt":null,"emptyReason":"No published capability contract is available yet."},"installCommand":"clawhub skill install s17fmkyfk8381hxzq5rtdj0jj184f9bj:financial-services","setupComplexity":"low","setupSteps":["Setup complexity is LOW. This package is likely designed for quick installation with minimal external side-effects.","Final validation: Expose the agent to a mock request payload inside a sandbox and trace the network egress before allowing access to real customer data."],"contract":{"contractStatus":"missing","authModes":[],"requires":[],"forbidden":[],"supportsMcp":false,"supportsA2a":false,"supportsStreaming":false,"inputSchemaRef":null,"outputSchemaRef":null,"dataRegion":null,"contractUpdatedAt":null,"sourceUpdatedAt":null,"freshnessSeconds":null},"invocationGuide":{"preferredApi":{"snapshotUrl":"https://www.xpersona.co/api/v1/agents/clawhub-fenccerece-financial-services/snapshot","contractUrl":"https://www.xpersona.co/api/v1/agents/clawhub-fenccerece-financial-services/contract","trustUrl":"https://www.xpersona.co/api/v1/agents/clawhub-fenccerece-financial-services/trust"},"curlExamples":["curl -s \"https://www.xpersona.co/api/v1/agents/clawhub-fenccerece-financial-services/snapshot\"","curl -s \"https://www.xpersona.co/api/v1/agents/clawhub-fenccerece-financial-services/contract\"","curl -s \"https://www.xpersona.co/api/v1/agents/clawhub-fenccerece-financial-services/trust\""],"jsonRequestTemplate":{"query":"summarize this repo","constraints":{"maxLatencyMs":2000,"protocolPreference":["OPENCLEW"]}},"jsonResponseTemplate":{"ok":true,"result":{"summary":"...","confidence":0.9},"meta":{"source":"CLAWHUB","generatedAt":"2026-10-12T13:56:14.096Z"}},"retryPolicy":{"maxAttempts":3,"backoffMs":[500,1500,3500],"retryableConditions":["HTTP_429","HTTP_503","NETWORK_TIMEOUT"]}},"endpoints":{"dossierUrl":"https://www.xpersona.co/api/v1/agents/clawhub-fenccerece-financial-services/dossier","snapshotUrl":"https://www.xpersona.co/api/v1/agents/clawhub-fenccerece-financial-services/snapshot","contractUrl":"https://www.xpersona.co/api/v1/agents/clawhub-fenccerece-financial-services/contract","trustUrl":"https://www.xpersona.co/api/v1/agents/clawhub-fenccerece-financial-services/trust"}},"reliability":{"evidence":{"source":"runtime-metrics","verified":false,"confidence":"low","updatedAt":null,"emptyReason":"No trust, reliability, or runtime telemetry is available."},"trust":{"status":"unavailable","handshakeStatus":"UNKNOWN","verificationFreshnessHours":null,"reputationScore":null,"p95LatencyMs":null,"successRate30d":null,"fallbackRate":null,"attempts30d":null,"trustUpdatedAt":null,"trustConfidence":"unknown","sourceUpdatedAt":null,"freshnessSeconds":null},"decisionGuardrails":{"doNotUseIf":["Contract metadata is missing or unavailable for deterministic execution."],"safeUseWhen":[],"riskFlags":["missing_or_unavailable_contract","trust_data_unavailable","schema_references_missing"],"operationalConfidence":"low"},"executionMetrics":{"observedLatencyMsP50":null,"observedLatencyMsP95":null,"estimatedCostUsd":null,"uptime30d":null,"rateLimitRpm":null,"rateLimitBurst":null,"lastVerifiedAt":null,"verificationSource":null},"runtimeMetrics":{"successRate":null,"avgLatencyMs":null,"avgCostUsd":null,"hallucinationRate":null,"retryRate":null,"disputeRate":null,"p50Latency":null,"p95Latency":null,"lastUpdated":null}},"benchmarks":{"evidence":{"source":"no-benchmark-data","verified":false,"confidence":"low","updatedAt":null,"emptyReason":"No benchmark suites or observed failure patterns are available."},"suites":[],"failurePatterns":[]},"artifacts":{"evidence":{"source":"CLAWHUB","verified":false,"confidence":"high","updatedAt":"2026-10-12T01:05:49.584Z","emptyReason":null},"readme":"Skill: claude financial-services for openclaw\n\nOwner: fenccerece\n\nSummary: Complete financial analysis methodology for OpenClaw. A 6-skill collection covering investment banking, commercial banking, asset management, insurance, sour...\n\nTags: latest:1.0.0\n\nVersion history:\n\nv1.0.0 | 2026-05-09T06:51:34.979Z | user\n\nInitial release of the financial-services skill collection for OpenClaw:\n\n- Introduces a comprehensive methodology for financial analysis, modeling, due diligence, and report generation.\n- Includes 6 integrated skills covering investment banking, commercial banking, asset management, insurance, source attribution, and standardized output.\n- Each skill supports core workflows such as pitch books, underwriting, portfolio reporting, actuarial analysis, and verification.\n- Designed for seamless installation and auto-discovery within the OpenClaw platform.\n- Requires no additional dependencies; optional data provider integration available.\n- Licensed under MIT-0.\n\nArchive index:\n\nArchive v1.0.0: 10 files, 26350 bytes\n\nFiles: asset-management/SKILL.md (8786b), commercial-banking/SKILL.md (9549b), excel-powerpoint-output/SKILL.md (7679b), insurance/SKILL.md (9723b), investment-banking/SKILL.md (6952b), README.md (3709b), skill-card.md (2463b), SKILL.md (2048b), source-attribution/SKILL.md (5157b), _meta.json (137b)\n\nFile v1.0.0:asset-management/SKILL.md\n\n---\nname: financial-services-asset-management\ndescription: >\n  Use when building portfolio reports, performance attribution analyses, IC memos, fund performance decks, or any asset management deliverable. Covers Brinson attribution, risk metrics, and institutional investor reporting.\nmetadata:\n  openclaw:\n    emoji: \"📈\"\n---\n\n# Asset Management\n\n构建资管级别的分析材料：组合报告、Brinson 归因分析、IC memo、业绩 Deck、风险指标。\n\n**Announce at start:** \"I'm using the asset-management skill to structure this portfolio analysis.\"\n\n## Core Principle\n\n资管报告的核心是回答：业绩从哪来（归因）、风险在哪（风控）、下一步怎么做（展望）。每个绩效数字必须与基准和持仓数据交叉验证。\n\n**REQUIRED:** Use financial-services:source-attribution before finalizing any deliverable.\n**REQUIRED:** Use financial-services:excel-powerpoint-output for all output formatting.\n\n## Checklist\n\nYou MUST create a task for each applicable item and complete them in order:\n\n1. **Parse the request** — Identify deliverable type (attribution / IC memo / performance deck / risk report)\n2. **Gather source materials** — Holdings data, benchmark returns, market data\n3. **Calculate returns** — Time-weighted and money-weighted returns\n4. **Run attribution** — Brinson-Fachler or other attribution method\n5. **Calculate risk metrics** — Sharpe, beta, max drawdown, tracking error, active share\n6. **Source attribution** — Verify every number traces to source\n7. **Format output** — Apply standardized Excel/PowerPoint formatting\n\n## Workflow: Portfolio Performance Attribution\n\n**Brinson-Fachler Attribution Model:**\n\nThe Brinson-Fachler model decomposes active return into allocation and selection effects:\n\n```\nTotal Active Return = Allocation Effect + Selection Effect + Interaction Effect\n\nWhere:\n- Allocation Effect = (wp - wb) × (Rb - Rb_total)\n  (overweight sector × sector benchmark return vs total benchmark)\n\n- Selection Effect = wb × (Rp - Rb)\n  (sector benchmark weight × portfolio vs benchmark return within sector)\n\n- Interaction Effect = (wp - wb) × (Rp - Rb)\n  (combined effect of both weight and return differences)\n```\n\n**Standard Attribution Table:**\n```\nSector       | Port Wt | Bmk Wt | Active | Port Ret | Bmk Ret | Alloc  | Select | Interact | Total\n-------------|---------|--------|--------|----------|---------|--------|--------|----------|------\nTechnology   | 32.5%   | 28.0%  | +4.5%  | 12.3%    | 10.1%   | +0.45% | +0.70% | +0.10%   | +1.25%\nHealthcare   | 18.2%   | 20.0%  | -1.8%  | 8.5%     | 9.2%    | -0.17% | -0.13% | +0.01%   | -0.29%\nFinancials   | 15.0%   | 16.0%  | -1.0%  | 6.8%     | 7.5%    | -0.08% | -0.11% | +0.01%   | -0.18%\n...          | ...     | ...    | ...    | ...      | ...     | ...    | ...    | ...      | ...\nTOTAL        | 100.0%  | 100.0% | 0.0%   | X.X%     | X.X%    | +X.X%  | +X.X%  | +X.X%    | +X.X%\n```\n\n**Interpretation Guide:**\n- Positive allocation: overweight in outperforming sectors (or underweight in underperforming)\n- Positive selection: picked better securities within sector\n- Interaction: combined effect (usually small, but can be meaningful in concentrated portfolios)\n\n## Workflow: Risk Metrics Calculation\n\n**Core Risk Metrics:**\n\n```\nSharpe Ratio = (Rp - Rf) / σp\n  - Rp = portfolio return, Rf = risk-free rate, σp = portfolio standard deviation\n  - Interpretation: > 1.0 good, > 2.0 excellent\n\nSortino Ratio = (Rp - Rf) / σd\n  - σd = downside deviation only\n  - Better for asymmetric return distributions\n\nInformation Ratio = (Rp - Rb) / TE\n  - TE = tracking error = σ(Rp - Rb)\n  - Interpretation: > 0.5 good, > 1.0 excellent\n\nBeta = Cov(Rp, Rb) / Var(Rb)\n  - Sensitivity to benchmark movements\n  - β > 1 = more volatile than benchmark\n\nMax Drawdown = max(Peak - Trough) / Peak\n  - Worst peak-to-trough decline\n  - Report: date of peak, date of trough, recovery time\n\nActive Share = (1/2) × Σ|wp_i - wb_i|\n  - Percentage of portfolio that differs from benchmark\n  - < 60% = closet indexer, > 80% = truly active\n\nTracking Error = σ(Rp - Rb) × √12 (if monthly data)\n  - Annualized standard deviation of active returns\n\nVaR (95%) = μ - 1.645 × σ\n  - Maximum expected loss at 95% confidence over 1 day\n  - Report: parametric, historical, and Monte Carlo if available\n```\n\n**Standard Risk Summary Table:**\n```\nMetric              | Portfolio | Benchmark | Peer Median\n--------------------|-----------|-----------|------------\nReturn (1Y)         |   X.X%   |   X.X%    |   X.X%\nVolatility (1Y)     |   X.X%   |   X.X%    |   X.X%\nSharpe Ratio        |   X.XX   |   X.XX    |   X.XX\nSortino Ratio       |   X.XX   |   —       |   X.XX\nInformation Ratio   |   X.XX   |   —       |   X.XX\nMax Drawdown        |  (X.X%)  |  (X.X%)   |  (X.X%)\nBeta                |   X.XX   |   1.00    |   X.XX\nActive Share        |   X.X%   |   —       |   X.X%\nTracking Error      |   X.X%   |   —       |   X.X%\nVaR (95%, 1-day)    |  (X.X%)  |  (X.X%)   |  (X.X%)\n```\n\n## Workflow: IC Memo (Investment Committee Memo)\n\n**Standard IC Memo Structure:**\n\n1. **Executive Summary**\n   - Fund/portfolio name, period, AUM\n   - Key performance highlights (1-3 bullet points)\n   - Top contributors and detractors\n\n2. **Performance Overview**\n   - Period return vs benchmark vs peers\n   - Cumulative return chart (trailing 1M, 3M, 6M, 1Y, 3Y, 5Y, ITD)\n   - Attribution summary (allocation + selection effect)\n\n3. **Sector Attribution**\n   - Brinson-Fachler attribution table (per above)\n   - Commentary on top 3 attribution drivers\n\n4. **Position-Level Highlights**\n   - Top 5 contributors (name, weight, return, contribution)\n   - Top 5 detractors (name, weight, return, contribution)\n   - Notable new positions and exits\n\n5. **Risk Analysis**\n   - Risk metrics table (per above)\n   - Factor exposure decomposition (if available)\n   - Concentration analysis (top 10 holdings % of portfolio)\n\n6. **Outlook & Positioning**\n   - Current positioning vs benchmark\n   - Key tilts and rationale\n   - Upcoming catalysts or events\n   - Proposed changes (if any)\n\n## Workflow: Performance Deck (PowerPoint)\n\n**Slide Structure:**\n\n1. **Title Slide** — Fund name, period, \"Confidential\"\n2. **Performance Snapshot** — Single slide with headline return, attribution pie, risk metrics\n3. **Return Attribution** — Brinson table + commentary\n4. **Sector Positioning** — Bar chart: portfolio vs benchmark weights\n5. **Top Holdings** — Table with top 10 positions\n6. **Contributors & Detractors** — Two-column layout\n7. **Risk Dashboard** — Metrics table + drawdown chart\n8. **Outlook** — Current positioning rationale\n\n**Formatting Rules:**\n- One key message per slide\n- Charts preferred over tables where possible\n- Consistent color coding: green = positive, red = negative, gray = benchmark\n- All data labeled with source and date\n- Footnotes for any methodology assumptions\n\n## Attribution Edge Cases\n\n**Multi-Period Attribution:**\n- Linking single-period attribution effects across multiple periods requires geometric linking\n- Arithmetic attribution does not sum to total active return over multiple periods\n- Always state whether attribution is arithmetic or geometric\n\n**Cash Drag:**\n- If portfolio holds cash, include cash as a \"sector\" in attribution\n- Cash drag in rising markets = negative allocation effect\n- Document cash policy (tactical vs. liquidity requirement)\n\n**Currency Effects:**\n- For global portfolios, decompose return into: local return + currency effect\n- Use Brinson with currency overlay or separate currency attribution\n\n**Derivatives and Leverage:**\n- Options/futures: use delta-adjusted notional for weight calculations\n- Leveraged positions: weights can exceed 100%\n- Document derivative usage in risk section\n\n## Common Mistakes to Avoid\n\n| Mistake | Correct Approach |\n|---------|------------------|\n| Arithmetic attribution over multiple periods | Use geometric linking for multi-period |\n| Ignoring cash in attribution | Include cash as explicit sector |\n| Not benchmarking risk metrics | Always show portfolio vs benchmark vs peers |\n| Single-period attribution only | Show trailing 1Y, 3Y, 5Y where available |\n| Not disclosing benchmark methodology | State benchmark rebalancing frequency and rules |\n| Confusing time-weighted and money-weighted | TWR for manager skill, MWR for investor experience |\n\n## Self-Review Checklist\n\nBefore delivery:\n\n- [ ] Returns calculated correctly (TWR vs MWR stated)\n- [ ] Attribution sums to total active return\n- [ ] Risk metrics include benchmark comparison\n- [ ] Top contributors and detractors identified\n- [ ] Every number has a source citation\n- [ ] Source attribution skill applied\n- [ ] Output formatted per excel-powerpoint-output standard\n\nFile v1.0.0:commercial-banking/SKILL.md\n\n---\nname: financial-services-commercial-banking\ndescription: >\n  Use when building credit memos, loan underwriting analyses, covenant compliance tests, spread sheets, or cash flow analyses for lending decisions. Covers the full commercial banking credit analysis workflow.\nmetadata:\n  openclaw:\n    emoji: \"🏦\"\n---\n\n# Commercial Banking\n\n构建商业银行级别的信用分析材料：credit memo、贷款承销、合约合规测试、财务展期、现金流分析。\n\n**Announce at start:** \"I'm using the commercial-banking skill to structure this credit analysis.\"\n\n## Core Principle\n\n信用分析的核心是还款能力评估。每一项财务数据必须映射到合约条款，每一个风险判断必须有数据支撑。\n\n**REQUIRED:** Use financial-services:source-attribution before finalizing any deliverable.\n**REQUIRED:** Use financial-services:excel-powerpoint-output for all output formatting.\n\n## Checklist\n\nYou MUST create a task for each applicable item and complete them in order:\n\n1. **Parse the request** — Identify deliverable type (credit memo / covenant test / spread sheet / cash flow)\n2. **Gather source materials** — Borrower package, financial statements, covenant terms, industry data\n3. **Spread financials** — Map historical financials to standardized format\n4. **Run credit ratios** — Calculate key credit metrics\n5. **Covenant compliance test** — Test against covenant terms\n6. **Risk assessment** — Identify and quantify risks\n7. **Source attribution** — Verify every number traces to source\n8. **Format output** — Apply standardized Excel formatting\n\n## Workflow: Financial Spreading\n\nWhen spreading financials from a borrower package:\n\n**Standard Layout (Excel):**\n```\nRow | Category           | FY2023 | FY2024 | FY2025 | FY2026E | YoY Chg\n----|--------------------|--------|--------|--------|---------|--------\n    | INCOME STATEMENT   |        |        |        |         |\n    | Revenue            |        |        |        |         |  X%\n    | COGS               |        |        |        |         |  X%\n    | Gross Profit       |        |        |        |         |  X%\n    | Gross Margin       |        |        |        |         |  X bps\n    | SG&A               |        |        |        |         |  X%\n    | EBITDA             |        |        |        |         |  X%\n    | EBITDA Margin      |        |        |        |         |  X bps\n    | D&A                |        |        |        |         |  X%\n    | EBIT               |        |        |        |         |  X%\n    | Interest Expense   |        |        |        |         |  X%\n    | Pre-tax Income     |        |        |        |         |  X%\n    | Taxes              |        |        |        |         |  X%\n    | Net Income         |        |        |        |         |  X%\n    |                    |        |        |        |         |\n    | BALANCE SHEET      |        |        |        |         |\n    | Cash               |        |        |        |         |  X%\n    | Accounts Receivable|        |        |        |         |  X%\n    | Inventory          |        |        |        |         |  X%\n    | Total Current Assets|       |        |        |         |  X%\n    | PP&E (net)         |        |        |        |         |  X%\n    | Total Assets       |        |        |        |         |  X%\n    |                    |        |        |        |         |\n    | Current Liabilities|        |        |        |         |  X%\n    | Long-term Debt     |        |        |        |         |  X%\n    | Total Liabilities  |        |        |        |         |  X%\n    | Shareholders' Equity|       |        |        |         |  X%\n    | Total L&E          |        |        |        |         |  X%\n    |                    |        |        |        |         |\n    | CASH FLOW          |        |        |        |         |\n    | Operating CF       |        |        |        |         |  X%\n    | Capex              |        |        |        |         |  X%\n    | Free Cash Flow     |        |        |        |         |  X%\n    | Debt Repayment     |        |        |        |         |  X%\n    | Dividends          |        |        |        |         |  X%\n    | Net Change in Cash |        |        |        |         |  X%\n```\n\n**Rules:**\n- Use consistent units (millions with 1 decimal, or thousands)\n- All percentages calculated YoY\n- Margin changes in basis points (bps)\n- Negative values in parentheses: (123)\n- Highlight any covenant breach or near-miss in red/yellow\n\n## Workflow: Credit Ratio Analysis\n\n**Leverage Ratios:**\n```\nTotal Debt / EBITDA        → Target: < 3.0x (investment grade: < 2.0x)\nNet Debt / EBITDA          → Target: < 2.5x\nDebt / Total Capital       → Target: < 50%\nDebt / Equity              → Target: < 1.0x\n```\n\n**Coverage Ratios:**\n```\nInterest Coverage (EBIT / Interest)     → Target: > 3.0x\nFixed Charge Coverage                    → Target: > 1.5x\nDebt Service Coverage (EBITDA / Debt Service) → Target: > 1.25x\n```\n\n**Liquidity Ratios:**\n```\nCurrent Ratio    → Target: > 1.5x\nQuick Ratio      → Target: > 1.0x\nCash / Current Liabilities → Target: > 0.2x\n```\n\n**Profitability Ratios:**\n```\nGross Margin     → Track trend, compare to industry\nEBITDA Margin    → Track trend, compare to industry\nROA              → Target: > 5%\nROE              → Target: > 10%\n```\n\n**Efficiency Ratios:**\n```\nDays Sales Outstanding (DSO)  → Track trend\nDays Inventory Outstanding    → Track trend\nDays Payable Outstanding      → Track trend\nCash Conversion Cycle         → Track trend\n```\n\n## Workflow: Covenant Compliance Testing\n\n**Standard Covenant Test Layout:**\n```\nCovenant Type          | Covenant Term    | Actual  | Cushion  | Status\n-----------------------|------------------|---------|----------|--------\nMax Debt / EBITDA      | ≤ 3.50x         | 2.80x   | 0.70x    | PASS\nMin Interest Coverage   | ≥ 3.00x         | 4.20x   | 1.20x    | PASS\nMax Capex               | ≤ $50M          | $42M    | $8M      | PASS\nMin Tangible Net Worth  | ≥ $200M         | $185M   | ($15M)   | BREACH\nMax Debt / Total Capital| ≤ 55%           | 58%     | (3%)     | BREACH\n```\n\n**Status Definitions:**\n- **PASS**: Actual meets or exceeds covenant with positive cushion\n- **NEAR-MISS**: Cushion < 10% of covenant value (yellow highlight)\n- **BREACH**: Actual violates covenant term (red highlight)\n- **WAIVED**: Covenant waived by lender (note waiver date and terms)\n\n**When a breach is found:**\n1. Identify the specific covenant and the breach amount\n2. Assess if it's a technical breach (calculation timing) or fundamental (deteriorating performance)\n3. Check for any cure provisions or grace periods\n4. Flag cross-default implications\n5. Recommend action: waiver request, amendment, or remediation plan\n\n## Workflow: Credit Memo Structure\n\n**Standard Credit Memo Sections:**\n\n1. **Executive Summary**\n   - Borrower name, facility type, amount requested\n   - Purpose of credit\n   - Recommendation (approve / approve with conditions / decline)\n   - Key risk factors and mitigants\n\n2. **Borrower Overview**\n   - Business description, history, ownership\n   - Management quality assessment\n   - Industry position and competitive landscape\n\n3. **Financial Analysis**\n   - Historical financial spread (3-5 years)\n   - Key ratio trends with commentary\n   - Quality of earnings assessment\n   - Working capital analysis\n\n4. **Cash Flow Analysis**\n   - Sources and uses of cash\n   - Debt service capacity\n   - Free cash flow after debt service\n   - Stress scenarios (base / downside / severe)\n\n5. **Covenant Compliance**\n   - Current compliance status\n   - Projected compliance (12-24 months)\n   - Recommended covenant set for new facility\n\n6. **Risk Assessment**\n   - Credit risks (quantified where possible)\n   - Mitigants for each risk\n   - Industry/macro risks\n   - Concentration risks\n\n7. **Recommendation**\n   - Approval amount and terms\n   - Covenants and conditions\n   - Monitoring requirements\n   - Early warning indicators\n\n## Stress Testing\n\nAlways include at least two stress scenarios:\n\n**Base Case:**\n- Management projections or consensus\n- No material changes to business model\n\n**Downside Case:**\n- Revenue decline 10-15%\n- Margin compression 100-200 bps\n- Working capital deterioration\n- Test: Can borrower still service debt?\n\n**Severe Case:**\n- Revenue decline 20-30%\n- Margin compression 300-500 bps\n- Credit facility draw-up\n- Test: What is the loss given default?\n\n## Common Mistakes to Avoid\n\n| Mistake | Correct Approach |\n|---------|------------------|\n| Using GAAP EBITDA without adjustments | Normalize for non-recurring items, stock comp, operating leases |\n| Ignoring off-balance sheet liabilities | Include operating leases, guarantees, pension obligations |\n| Not testing projected covenants | Always project 12-24 months forward |\n| Single scenario analysis | Minimum: base + downside. Better: + severe |\n| Ignoring industry cyclicality | Compare to industry-adjusted norms |\n| Mixing fiscal and calendar year | Normalize to same period for comparisons |\n\n## Self-Review Checklist\n\nBefore delivery:\n\n- [ ] All financials spread with consistent format\n- [ ] Key credit ratios calculated and trended\n- [ ] Every covenant tested with status and cushion\n- [ ] Near-misses and breaches highlighted\n- [ ] Stress scenarios included (base + downside minimum)\n- [ ] Every number has a source citation\n- [ ] Source attribution skill applied\n- [ ] Output formatted per excel-powerpoint-output standard\n\nFile v1.0.0:excel-powerpoint-output/SKILL.md\n\n---\nname: financial-services-excel-powerpoint-output\ndescription: >\n  Use when generating Excel workbooks or PowerPoint decks for financial deliverables. Enforces consistent professional formatting for financial models, comps tables, pitch decks, and analytical reports. Applied after analysis is complete.\nmetadata:\n  openclaw:\n    emoji: \"📐\"\n---\n\n# Excel & PowerPoint Output\n\n金融 Excel 工作簿和 PowerPoint Deck 的标准化格式规范。\n\n**Announce at start:** \"I'm using the excel-powerpoint-output skill to format the deliverable.\"\n\n## Core Principle\n\n格式一致性和专业性是金融交付物的基本要求。好的格式让审阅者快速找到关键信息，差的格式掩盖好的分析。\n\n## Excel Formatting Standards\n\n### Number Format\n\n```\nType                | Format              | Example\n--------------------|---------------------|----------\nRevenue, large      | $#,##0.0\"M\"        | $4,218.5M\nRevenue, small      | $#,##0.0\"K\"        | $421.8K\nPercentages         | 0.00%              | 24.35%\nPercentages (bps)   | 0 bps              | 235 bps\nMultiples           | 0.00x              | 12.55x\nRatios              | 0.00               | 1.15\nShare price         | $#,##0.00          | $142.55\nShares              | #,##0.0\"M\"         | 1,245.3M\nNegative values     | (#,##0) or (0.0%)  | (125.5) or (2.3%)\nN/A or N/M          | \"N/A\" or \"N/M\"     | text\n```\n\n### Color Coding\n\n```\nElement                  | Color (Light Mode) | Color (Dark Mode)\n-------------------------|-------------------|------------------\nHeader row background    | #1F2937 (gray-800)| #F9FAFB (gray-50)\nHeader row text          | #FFFFFF (white)    | #111827 (gray-900)\nSubheader background     | #E5E7EB (gray-200)| #374151 (gray-700)\nPositive values          | #059669 (green-600)| #34D399 (green-400)\nNegative values          | #DC2626 (red-600)  | #F87171 (red-400)\nCovenant breach          | #FEE2E2 bg + red text|#7F1D1D bg + #FCA5A5\nCovenant near-miss       | #FEF3C7 bg + amber  |#78350F bg + #FCD34D\nInput cells              | #DBEAFE bg (blue)  | #1E3A5F bg\nCalculated cells         | No background       | No background\nBorders                  | #D1D5DB (gray-300) | #4B5563 (gray-600)\n```\n\n### Layout Rules\n\n**General:**\n- Freeze panes: freeze header row AND first column (company names)\n- Column widths: auto-fit, minimum 10 characters\n- Row heights: 15pt standard, 20pt for header rows\n- Font: Calibri 10pt body, 11pt headers, 9pt footnotes\n- Alignment: numbers right-aligned, text left-aligned, headers center-aligned\n\n**Financial Model Tab:**\n```\nColumn A: Row labels (left-aligned, bold for section headers)\nColumn B+: Periods (FY2023, FY2024, etc.)\nLast column: CAGR or YoY change\n\nSection headers: bold, light gray background\nSubtotals: top border (thin line)\nGrand totals: top and bottom border (double line)\nInput assumptions: blue font or blue background\nCalculated values: black font, no special background\n```\n\n**Comps Table Tab:**\n```\nColumn A: Company name\nColumn B: Ticker\nColumn C+: Financial metrics and multiples\nLast rows: Median, Mean, Min, Max, Target position\n\nSort order: by EV/EBITDA descending (or as specified)\nHighlight: Target company row in light blue background\nOutliers: gray italic with footnote explaining exclusion\n```\n\n**Sources Tab:**\n```\nColumn A: Source abbreviation\nColumn B: Full source name\nColumn C: Data type\nColumn D: Retrieval date\nColumn E: Access method (API, manual, file)\nColumn F: Notes\n```\n\n### Tab Naming Convention\n\n```\nTab Name            | Content\n--------------------|----------------------------------------\nSummary             | Key metrics overview\nIncome Statement    | P&L historical + projected\nBalance Sheet       | BS historical + projected\nCash Flow           | CF historical + projected\nComps               | Comparable company analysis\nDCF                 | Discounted cash flow model\nPrecedent Txns      | Precedent transactions\nWACC                | WACC calculation details\nSensitivity         | Sensitivity tables\nSources             | Data sources and retrieval dates\n```\n\n## PowerPoint Formatting Standards\n\n### Slide Layout\n\n**Title Slide:**\n```\n[Company Logo if applicable]\n\n[Title: Deliverable Name]\n[Subtitle: Target Company / Fund / Line of Business]\n\n[Date]\n[Confidential / Internal Use Only]\n```\n\n**Standard Content Slide:**\n```\n[Slide Title — one clear message]\n\n[Content area: chart, table, or text]\n\nSource: [Provider], [Date]\n```\n\n**Section Divider:**\n```\n[Section Number]\n[Section Title]\n[Brief description of what's in this section]\n```\n\n### Chart Standards\n\n**Colors:**\n```\nSeries 1 (Primary):   #2563EB (blue-600)\nSeries 2 (Secondary): #059669 (green-600)\nSeries 3 (Tertiary):  #D97706 (amber-600)\nSeries 4 (Quaternary):#7C3AED (violet-600)\nNegative/Benchmark:   #6B7280 (gray-500)\nTarget/Highlight:     #DC2626 (red-600)\n```\n\n**Chart Types:**\n```\nData Type              | Chart Type           | When to Use\n-----------------------|----------------------|---------------------------—\nComposition            | Pie chart or stacked bar | Sector allocation, revenue breakdown\nTime series            | Line chart           | Return trends, financial metrics over time\nComparison             | Grouped bar chart    | Peer comparison, before/after\nDistribution           | Histogram or box plot| Return distribution, valuation range\nRelationship           | Scatter plot         | Risk vs return, correlation\nFlow                   | Waterfall chart      | EBITDA bridge, attribution breakdown\nHeat map               | Conditional format   | Link ratio triangle, correlation matrix\n```\n\n**Chart Rules:**\n- Title: describe the insight, not the data (\"Tech outperformed by 250bps\" not \"Sector Returns\")\n- Axis labels: include units (%, $, x)\n- Legend: only if 2+ series, position at bottom\n- Data labels: only on key points (min, max, target)\n- Gridlines: light gray, horizontal only (for bar/line charts)\n\n### Text Standards\n\n**Font:**\n- Title: 24pt, bold\n- Section header: 18pt, bold\n- Body: 14pt, regular\n- Footnote: 10pt, regular, gray\n- Font family: Calibri or Arial (consistent throughout)\n\n**Bullet Points:**\n- Maximum 6 bullets per slide\n- Maximum 2 lines per bullet\n- Use parallel structure (all start with verb, or all noun phrases)\n- Indent sub-bullets one level, smaller font (12pt)\n\n**Tables in PowerPoint:**\n- Header row: dark background, white text\n- Alternating row colors: white and light gray\n- Right-align numbers, left-align text\n- Minimum font size: 10pt\n- Maximum rows: 15 (split to next slide if more)\n\n### Source Attribution in Decks\n\n**Every data slide must have:**\n```\nSource: [Provider], [Date]\n```\n\n**Format:**\n- Bottom-left or bottom-right of slide\n- 10pt, gray text\n- Include date of data retrieval\n\n**If multiple sources:**\n```\nSources: FactSet (prices), S&P Capital IQ (fundamentals), Author calculations\n```\n\n**For calculated values:**\n```\nSource: Author calculations based on [inputs]. See Appendix for details.\n```\n\n## Delivery Checklist\n\nBefore delivering any financial output:\n\n**Excel:**\n- [ ] All number formats consistent\n- [ ] Color coding applied per standard\n- [ ] Freeze panes set on all tabs\n- [ ] Tab names follow convention\n- [ ] Sources tab included\n- [ ] Input cells distinguished from calculations\n- [ ] Negative values in parentheses\n- [ ] No #REF!, #VALUE!, #N/A errors (unless intentionally handled)\n\n**PowerPoint:**\n- [ ] Title slide with date and confidentiality notice\n- [ ] One message per slide\n- [ ] Source attribution on every data slide\n- [ ] Consistent fonts and colors\n- [ ] Charts follow type and color standards\n- [ ] No orphan slides (every slide has context)\n- [ ] Appendix for detailed supporting data\n\nFile v1.0.0:insurance/SKILL.md\n\n---\nname: financial-services-insurance\ndescription: >\n  Use when reviewing reserve adequacy, building actuarial analyses, analyzing underwriting results, or preparing insurance regulatory filings. Covers reserve analysis, link ratio triangles, actuarial review, and insurance-specific financial reporting.\nmetadata:\n  openclaw:\n    emoji: \"🛡️\"\n---\n\n# Insurance\n\n构建保险级别的分析材料：准备金充足性审查、精算分析、承保结果分析、监管报告。\n\n**Announce at start:** \"I'm using the insurance skill to structure this actuarial analysis.\"\n\n## Core Principle\n\n保险分析的核心是不确定性量化。精算数据必须展示置信区间和敏感性，不能只给点估计。每个假设必须明确标注来源和合理性。\n\n**REQUIRED:** Use financial-services:source-attribution before finalizing any deliverable.\n**REQUIRED:** Use financial-services:excel-powerpoint-output for all output formatting.\n\n## Checklist\n\nYou MUST create a task for each applicable item and complete them in order:\n\n1. **Parse the request** — Identify deliverable type (reserve review / actuarial analysis / underwriting / regulatory)\n2. **Gather source materials** — Actuarial workbook, regulatory filings, loss triangles\n3. **Analyze reserve adequacy** — Compare carried vs indicated reserves\n4. **Build link ratios** — Development triangles and heatmaps\n5. **Flag anomalies** — Accelerated development, tail divergence, elevated initial reporting\n6. **Source attribution** — Verify every number traces to source\n7. **Format output** — Apply standardized Excel/PowerPoint formatting\n\n## Workflow: Reserve Adequacy Review\n\n**Step 1: Reserve Summary**\n```\nLine of Business    | Carried Reserves | Indicated Reserves | Redundancy/(Deficiency) | %\n--------------------|------------------|--------------------|-----------------------|-----\nWorkers' Comp       |    $XXX M        |    $XXX M          |    $XX M               | X.X%\nGeneral Liability   |    $XXX M        |    $XXX M          |    ($XX M)             | X.X%\nAuto Liability      |    $XXX M        |    $XXX M          |    $XX M               | X.X%\nProfessional Liab   |    $XXX M        |    $XXX M          |    ($XX M)             | X.X%\nProperty            |    $XX M         |    $XX M           |    $X M                | X.X%\nTOTAL               |    $X,XXX M      |    $X,XXX M        |    $XX M               | X.X%\n```\n\n**Step 2: Ultimate Loss Analysis**\n```\nAccident Year | Paid Losses | Case Reserves | IBNR  | Total Incurred | Selected Ultimate | % Developed\n--------------|-------------|---------------|-------|----------------|-------------------|-------------\n2019          | $XXX M      | $XX M         | $X M  | $XXX M         | $XXX M            | 98%\n2020          | $XXX M      | $XX M         | $XX M | $XXX M         | $XXX M            | 95%\n2021          | $XXX M      | $XX M         | $XX M | $XXX M         | $XXX M            | 88%\n2022          | $XXX M      | $XX M         | $XX M | $XXX M         | $XXX M            | 75%\n2023          | $XX M       | $XX M         | $XX M | $XXX M         | $XXX M            | 55%\n2024          | $XX M       | $XX M         | $XX M | $XX M          | $XXX M            | 30%\n2025          | $X M        | $XX M         | $XX M | $XX M          | $XXX M            | 10%\n```\n\n**Key Metrics:**\n- Average ultimate trend for accident years 2019-2025\n- Year-over-year development patterns\n- Paid-to-incurred ratio trends\n- Case reserve adequacy (case incurred vs. paid development)\n\n## Workflow: Link Ratio Triangles\n\n**Standard Development Triangle:**\n```\n              | Development Period\nAccident Year |  1    |  2    |  3    |  4    |  5    |  6    |  7    |  Ultimate\n--------------|-------|-------|-------|-------|-------|-------|-------|----------\n2019          | 1.45  | 1.22  | 1.10  | 1.05  | 1.02  | 1.01  | 1.00  |  $XXX M\n2020          | 1.42  | 1.20  | 1.08  | 1.04  | 1.02  | 1.01  |       |  $XXX M\n2021          | 1.48  | 1.25  | 1.12  | 1.06  | 1.03  |       |       |  $XXX M\n2022          | 1.50  | 1.28  | 1.15  | 1.08  |       |       |       |  $XXX M\n2023          | 1.55  | 1.30  | 1.18  |       |       |       |       |  $XXX M\n2024          | 1.52  | 1.26  |       |       |       |       |       |  $XXX M\n2025          | 1.48  |       |       |       |       |       |       |  $XXX M\n```\n\n**Link Ratio Heatmap Rules:**\n- Green: Within ±5% of 5-year weighted average for that development period\n- Yellow: 5-15% deviation from weighted average\n- Red: >15% deviation from weighted average\n- Always show the 5-year weighted average row for reference\n\n**Building the Heatmap:**\n```\nFor each cell (accident_year, dev_period):\n  deviation = (actual_ratio - weighted_avg_ratio) / weighted_avg_ratio × 100\n  color = green if |deviation| ≤ 5%, yellow if ≤ 15%, red otherwise\n```\n\n## Workflow: Anomaly Detection\n\n**Flag these patterns when reviewing actuarial data:**\n\n**Accelerated Development:**\n- Link ratios significantly above historical pattern\n- Potential causes: litigation surge, regulatory change, large claim emergence\n- Impact: may indicate reserve deficiency\n\n**Tail Development:**\n- Development continuing beyond expected closure period\n- Check: is this line developing faster or slower than historical?\n- Impact: IBNR may be inadequate if tail is lengthening\n\n**Elevated Initial Reporting:**\n- First development period ratio above historical average\n- Potential causes: claims frequency increase, underwriting change, reporting lag change\n- Impact: may signal adverse development in recent accident years\n\n**Calendar Year Effects:**\n- Consistent acceleration or deceleration across accident years in same calendar period\n- Potential causes: economic conditions, legal environment, claims handling changes\n- Impact: may need calendar year adjustment to development factors\n\n## Workflow: Underwriting Analysis\n\n**Combined Ratio Decomposition:**\n```\nCombined Ratio = Loss Ratio + Expense Ratio + Dividend Ratio\n\nWhere:\n- Loss Ratio = Incurred Losses / Earned Premium\n- Expense Ratio = Underwriting Expenses / Written Premium\n  - Commissions ratio\n  - General expenses ratio\n- Dividend Ratio = Policyholder Dividends / Earned Premium\n```\n\n**Standard Underwriting Summary:**\n```\nMetric                | Current Year | Prior Year | 3-Yr Avg | Industry\n----------------------|--------------|------------|----------|----------\nEarned Premium        | $XXX M       | $XXX M     | $XXX M   | —\nIncurred Losses       | $XXX M       | $XXX M     | $XXX M   | —\nLoss Ratio            | X.X%         | X.X%       | X.X%     | X.X%\nExpense Ratio         | X.X%         | X.X%       | X.X%     | X.X%\nCombined Ratio        | X.X%         | X.X%       | X.X%     | X.X%\nUnderwriting Income   | $XX M        | $XX M      | $XX M    | —\nInvestment Income     | $XX M        | $XX M      | $XX M    | —\nNet Income            | $XX M        | $XX M      | $XX M    | —\n```\n\n**Key Ratios to Track:**\n- Loss development (prior year reserve releases/ strengthening)\n- Current accident year loss ratio (excluding development)\n- Frequency (claims per exposure unit)\n- Severity (average claim size)\n- Expense ratio trend\n- Reinsurance impact\n\n## Workflow: Regulatory Filing Analysis\n\n**Common Filing Types:**\n- Annual Statement (NAIC)\n- Risk-Based Capital (RBC)\n- ORSA (Own Risk and Solvency Assessment)\n- Statutory Financial Statements\n\n**Key Regulatory Metrics:**\n```\nRBC Ratio = Total Adjusted Capital / Company Action Level RBC\n  - > 200% = Well capitalized\n  - 150-200% = Adequately capitalized\n  - 100-150% = Company action level (triggers filing)\n  - < 100% = Regulatory action required\n\nPremium-to-Surplus Ratio = Net Written Premium / Policyholder Surplus\n  - Target: < 3.0x\n\nReserve-to-Surplus Ratio = Total Reserves / Policyholder Surplus\n  - Varies by line; monitor trend\n```\n\n## Actuarial Assumptions Documentation\n\nEvery actuarial analysis must document:\n\n```\nAssumption Category     | Assumption Made           | Source/Basis          | Sensitivity\n------------------------|---------------------------|-----------------------|------------\nLoss Development Factors| 5-year weighted average   | Company experience    | ±5% = ±$XX M\nTail Factor             | 1.05 for long-tail lines  | Industry benchmark    | ±2% = ±$XX M\nClaim Inflation         | 3.5% annual               | CPI + litigation trend| ±1% = ±$XX M\nExpense Trend           | 2.5% annual               | Company budget        | ±0.5% = ±$X M\nInvestment Return       | 4.0% on reserves          | Current portfolio yield| ±1% = ±$XX M\n```\n\n## Common Mistakes to Avoid\n\n| Mistake | Correct Approach |\n|---------|------------------|\n| Point estimates without ranges | Always show sensitivity to key assumptions |\n| Ignoring calendar year effects | Check for consistent patterns across accident years |\n| Not disclosing development method | State: Bornhuetter-Ferguson, chain ladder, or frequency-severity |\n| Using industry benchmarks without adjustment | Calibrate to company-specific experience where data permits |\n| Not linking reserves to pricing | Reserve adequacy impacts future pricing adequacy |\n| Ignoring reinsurance effects | Show gross and net of reinsurance separately |\n\n## Self-Review Checklist\n\nBefore delivery:\n\n- [ ] Carried vs indicated reserves compared with redundancy/deficiency\n- [ ] Link ratio heatmap shows deviation from 5-year weighted average\n- [ ] Anomalies flagged with explanation and impact quantification\n- [ ] Actuarial assumptions documented with source and sensitivity\n- [ ] Every number has a source citation\n- [ ] Source attribution skill applied\n- [ ] Output formatted per excel-powerpoint-output standard\n\nFile v1.0.0:investment-banking/SKILL.md\n\n---\nname: financial-services-investment-banking\ndescription: >\n  Use when building pitch books, CIMs, comps tables, DCF models, precedent transaction analyses, or any M&A valuation work. Covers the full investment banking analysis workflow from data gathering to formatted deliverables.\nmetadata:\n  openclaw:\n    emoji: \"📊\"\n---\n\n# Investment Banking\n\n构建投行级别的分析材料：pitch book、CIM、可比公司分析、DCF 估值、先例交易。\n\n**Announce at start:** \"I'm using the investment-banking skill to structure this analysis.\"\n\n## Core Principle\n\n每个数字必须可追溯到源文档。估值结论必须交叉验证（可比公司、DCF、先例交易三角验证）。\n\n**REQUIRED:** Use financial-services:source-attribution before finalizing any deliverable.\n**REQUIRED:** Use financial-services:excel-powerpoint-output for all output formatting.\n\n## Checklist\n\nYou MUST create a task for each applicable item and complete them in order:\n\n1. **Parse the request** — Identify deliverable type (pitch book / CIM / comps / DCF / precedent transactions)\n2. **Gather source materials** — Collect CIM, financial statements, peer data, market data\n3. **Build the analysis** — Follow the applicable workflow below\n4. **Cross-validate** — Triangulate valuation across methods\n5. **Source attribution** — Verify every number traces to source\n6. **Format output** — Apply standardized Excel/PowerPoint formatting\n7. **Self-review** — Run the review checklist before delivery\n\n## Workflow: Pitch Book / Valuation Summary\n\nWhen building a pitch book or valuation summary slide:\n\n**Step 1: Peer Selection**\n- Select 5-10 comparable companies based on: sector, size (revenue/EBITDA range), geography, business model\n- Justify each inclusion/exclusion in a brief note\n\n**Step 2: Comps Table**\nBuild a comps table with these columns:\n```\nCompany | EV | Revenue | EBITDA | EV/Revenue | EV/EBITDA | P/E | EV/EBITDA Growth\n```\n- Include: median, mean, min, max, target company position\n- Source each multiple to the specific filing or data provider\n\n**Step 3: DCF Model**\nBuild a DCF with:\n- Free Cash Flow projections (5-10 year explicit period)\n- Terminal value (exit multiple or perpetuity growth method)\n- WACC calculation (show components: risk-free rate, equity risk premium, beta, cost of debt, capital structure)\n- Sensitivity table: WACC vs terminal growth/exit multiple\n- Clearly label: enterprise value, equity value, per-share value\n\n**Step 4: Precedent Transactions**\n- Collect 5-10 relevant M&A transactions in the same sector\n- Include: date, acquirer, target, deal value, EV/Revenue, EV/EBITDA\n- Adjust for market conditions if transactions are from different periods\n\n**Step 5: Valuation Triangle**\nPresent implied valuation range from all three methods:\n```\nMethod          | Low    | Midpoint | High\n----------------|--------|----------|-------\nComps           | $X.Xb  | $X.Xb    | $X.Xb\nDCF             | $X.Xb  | $X.Xb    | $X.Xb\nPrecedent Txns  | $X.Xb  | $X.Xb    | $X.Xb\nImplied Range   | $X.Xb  | $X.Xb    | $X.Xb\n```\n\n**Step 6: Position in Range**\n- Where does the target sit in its 52-week trading range?\n- Flag any outlier explanations (one-time events, market dislocations)\n\n## Workflow: CIM (Confidential Information Memorandum)\n\nWhen building or analyzing a CIM:\n\n**Structure:**\n1. Executive Summary\n2. Company Overview (history, products, market position)\n3. Industry Overview (market size, growth, dynamics, competitive landscape)\n4. Financial Analysis (3-5 year historical, projections, key metrics)\n5. Investment Thesis (growth drivers, competitive advantages, opportunities)\n6. Risk Factors\n7. Appendments (detailed financials, organizational chart, material contracts)\n\n**Financial Analysis Section Must Include:**\n- Revenue bridge (organic vs. inorganic growth)\n- EBITDA bridge (revenue growth, margin expansion/contraction, one-time items)\n- Cash flow analysis (FCF conversion, capex trends)\n- Key metrics by segment (if applicable)\n- Quality of earnings adjustments\n\n## Workflow: Comparable Company Analysis\n\n**Selection Criteria:**\n- Same GICS sub-industry (preferred) or adjacent industry\n- Revenue within 0.5x-2.0x of target\n- Similar geographic exposure\n- Similar growth profile\n\n**Standard Multiples:**\n- Enterprise Value: EV/Revenue, EV/EBITDA, EV/EBIT\n- Equity Value: P/E, P/B, P/FCF\n- Growth-adjusted: EV/EBITDA/Growth (PEG equivalent)\n\n**Statistical Treatment:**\n- Report median AND mean (outlier-sensitive)\n- Exclude outliers with clear justification\n- Show where target ranks within the distribution\n\n## Workflow: DCF Model\n\n**WACC Components:**\n```\nWACC = (E/(D+E)) × Ke + (D/(D+E)) × Kd × (1-T)\n\nWhere:\n- Ke = Rf + β × ERP + Size premium (if applicable)\n- Rf = 10-year government bond yield\n- β = Raw beta adjusted for leverage (Hamada formula)\n- ERP = Equity risk premium (Damodaran or consensus)\n- Kd = Risk-free rate + credit spread\n- T = Marginal tax rate\n```\n\n**Terminal Value:**\n- Exit Multiple Method: Apply peer median EV/EBITDA to terminal year EBITDA\n- Perpetuity Growth Method: g = long-term GDP growth + inflation (typically 2-3%)\n- Present both; reconcile if materially different\n\n**Sensitivity Table:**\n```\n              | Terminal Growth / Exit Multiple\nWACC          |  Low  | Base |  High\n----------------------------------\nLow (-1%)     |       |      |\nBase          |       |      |\nHigh (+1%)    |       |      |\n```\n\n## Workflow: Precedent Transactions\n\n**Data Points to Collect:**\n- Announcement date, completion date\n- Acquirer, target, deal structure (cash/stock/mixed)\n- Enterprise value, equity value\n- Multiples: EV/Revenue, EV/EBITDA, P/E\n- Premium to unaffected price\n- Strategic vs. financial buyer\n\n**Adjustments:**\n- Control premium (typically 20-40%)\n- Market condition adjustment if comparing across time periods\n- Synergy expectations (strategic buyers often pay more)\n\n## Common Mistakes to Avoid\n\n| Mistake | Correct Approach |\n|---------|------------------|\n| Using trailing multiples without noting period | Specify LTM, NTM, or calendar year |\n| Mixing equity and enterprise value | Be explicit: EV for operating metrics, equity for per-share |\n| Ignoring non-recurring items | Normalize EBITDA: add back restructuring, impairments, one-time gains/losses |\n| DCF with inconsistent FCF definition | FCF = EBITDA - Capex - Change in NWC - Cash Taxes |\n| Circular reference in WACC/valuation | Use goal-seek or iterate: lever beta → unlever → relever → WACC |\n| Presenting single point estimate | Always show range with sensitivity |\n\n## Self-Review Checklist\n\nBefore delivery:\n\n- [ ] Every number has a source citation\n- [ ] Valuation triangulated across 2+ methods\n- [ ] Comps median and mean both reported\n- [ ] DCF sensitivity table included\n- [ ] Key assumptions explicitly stated\n- [ ] Non-recurring items normalized\n- [ ] Source attribution skill applied\n- [ ] Output formatted per excel-powerpoint-output standard\n\nFile v1.0.0:SKILL.md\n\n---\nname: financial-services\ndescription: >\n  Complete financial analysis methodology for OpenClaw. A 6-skill collection covering investment banking, commercial banking, asset management, insurance, source attribution, and standardized output. Use when performing any financial analysis, modeling, due diligence, or report generation.\nmetadata:\n  openclaw:\n    emoji: \"💰\"\n    homepage: https://github.com/openclaw/financial-services\n---\n\n# Financial Services\n\n金融分析方法论在 OpenClaw 平台上的完整技能集合。6 个技能协同工作，覆盖投行、商业银行、资管、保险四大金融场景。\n\n## How This Collection Works\n\nThis is a **skill collection**. The root SKILL.md acts as the manifest. Individual skills live in subdirectories and are auto-discovered by OpenClaw via their `description` fields.\n\n## Skills\n\n### Core Analysis Skills\n- **investment-banking** — Pitch books, CIMs, comps tables, DCF models, precedent transactions\n- **commercial-banking** — Credit memos, loan underwriting, covenant analysis, spread sheets\n- **asset-management** — Portfolio reporting, Brinson attribution, IC memos, performance decks\n- **insurance** — Reserve review, actuarial analysis, underwriting, regulatory filings\n\n### Foundation Skills\n- **source-attribution** — Every number traces to its source. Verification checklist for financial claims.\n- **excel-powerpoint-output** — Standardized formatting for financial Excel workbooks and PowerPoint decks\n\n## Installation\n\n```bash\nclawhub install financial-services\n```\n\nOr manually:\n\n```bash\ncp -r financial-services ~/.openclaw/skills/\n```\n\nRestart OpenClaw Gateway. All 6 skills are auto-discovered.\n\n## Requirements\n\n- OpenClaw (any version supporting SKILL.md format)\n- No additional dependencies\n- For data-intensive workflows: configure MCP connectors to your data providers (FactSet, S&P Global, Morningstar, etc.)\n\n## License\n\nMIT-0\n\n## Credits\n\nInspired by [Claude for Financial Services](https://claude.com/solutions/financial-services) by Anthropic.\n\nFile v1.0.0:source-attribution/SKILL.md\n\n---\nname: financial-services-source-attribution\ndescription: >\n  Use when finalizing any financial deliverable, before claiming analysis is complete. Requires every number, ratio, and claim to trace back to a specific source document or data provider. The verification gate for financial accuracy.\nmetadata:\n  openclaw:\n    emoji: \"🔗\"\n---\n\n# Source Attribution\n\n每个数字必须追溯到源文档。这是金融分析的信任基础。\n\n**Announce at start:** \"I'm using the source-attribution skill to verify all data sources.\"\n\n## The Iron Law\n\n```\nNO FINANCIAL CLAIM WITHOUT SOURCE CITATION\n```\n\nIf you cannot point to the specific document, page, cell, or data provider where a number came from, do not include it.\n\n## Core Principle\n\n金融决策基于数据。不可追溯的数据是不可信的。源归因不是\"加分项\"，而是交付的前提条件。\n\n**This skill is RIGID. Do not adapt away the discipline.**\n\n## The Verification Gate\n\nBefore any financial deliverable leaves your hands:\n\n```\n1. SCAN: Review every number in the deliverable\n2. TRACE: Each number → source document + location\n3. CITE: Add citation in standard format\n4. VERIFY: Cross-check critical numbers against 2nd source if available\n5. FLAG: Mark any unverifiable numbers as [UNVERIFIED] or remove them\n```\n\n## Citation Format\n\n**Standard format:**\n```\n[Number] — [Source], [Date], [Location/Reference]\n```\n\n**Examples:**\n```\nRevenue: $4.2B — 10-K Filing, FY2025, p.38\nEBITDA Margin: 24.3% — FactSet, as of 2026-03-31\nBeta: 1.15 — Bloomberg, 2-year weekly, as of 2026-05-01\nWACC: 9.2% — Author calculation, components: [see WACC tab]\nComparable EV/EBITDA: 12.5x median — S&P Capital IQ, peer set [see Comps tab]\n```\n\n**In Excel workbooks:**\n- Add a \"Sources\" tab listing all data sources with retrieval dates\n- Use cell comments on key cells to note source\n- Use consistent source abbreviations (define in Sources tab)\n\n**In PowerPoint decks:**\n- Source footnote on every data slide: \"Source: [provider], [date]\"\n- Detailed sources in appendix if space is limited\n\n## Source Categories\n\n| Category | Acceptable Sources | Unacceptable |\n|----------|-------------------|--------------|\n| Financial statements | 10-K, 10-Q, annual report, audited financials | Press releases alone, unaudited management estimates |\n| Market data | Bloomberg, Refinitiv, FactSet, S&P Capital IQ | Unattributed web searches, Wikipedia |\n| Valuation multiples | Capital IQ, FactSet consensus, PitchBook | Single analyst estimate, blog posts |\n| Industry data | IBISWorld, Gartner, company filings, government stats | Marketing materials, unverified reports |\n| Macro data | Federal Reserve, BLS, IMF, World Bank | News articles, social media |\n| Calculations | Your own model (cite inputs and methodology) | Unverified calculations from third parties |\n\n## Cross-Verification Rules\n\n**Critical numbers (must cross-verify):**\n- Revenue, EBITDA, Net Income from financial statements\n- Share price and market cap (check date alignment)\n- WACC components (risk-free rate, beta, ERP)\n- Valuation multiples from comps or precedent transactions\n- Covenant ratios (verify against both financial data AND covenant terms)\n\n**Cross-verification method:**\n```\nPrimary source: 10-K filing, FY2025, Revenue = $4.2B\nSecondary source: FactSet, FY2025 Revenue = $4.2B ✓\nIf mismatch: investigate, document discrepancy, use audited source\n```\n\n## Handling Missing Sources\n\nWhen you cannot find a source for a number:\n\n1. **Search harder** — check alternative data providers, filings, presentations\n2. **Estimate explicitly** — if you must estimate, mark clearly:\n   ```\n   Estimated: [Number] — Author estimate based on [methodology]\n   Confidence: [High/Medium/Low]\n   ```\n3. **Remove** — if neither source nor reliable estimate available, do not include\n\n**Never:**\n- Present an estimate as a sourced fact\n- Use a number without noting if it's estimated\n- Cite a source you haven't actually checked\n\n## Common Violations\n\n| Violation | Fix |\n|-----------|-----|\n| \"Revenue grew 15%\" without source | \"Revenue grew 15% — 10-K, FY2025 vs FY2024, p.38\" |\n| Using \"approximately\" without basis | State exact number + source, or mark as estimated |\n| Copying numbers from chat/summary without verification | Verify against primary source before using |\n| Mixing fiscal year and calendar year without noting | Explicitly state: \"FY2025 (ended Jan 2026)\" |\n| Stale data without date | Always include \"as of [date]\" |\n| Calculation without showing inputs | Show formula and input sources |\n\n## The Bottom Line\n\nFinancial analysis without source attribution is opinion, not analysis.\n\nEvery number. Every time. No exceptions.\n\n## Verification Checklist\n\nBefore marking any financial deliverable complete:\n\n- [ ] Every financial metric has a source citation\n- [ ] Critical numbers cross-verified against 2nd source\n- [ ] Sources tab/footnote included in deliverable\n- [ ] All data dates specified (no stale data without noting)\n- [ ] Estimates clearly marked as estimates with methodology\n- [ ] No unverifiable numbers remain in deliverable\n- [ ] Citation format is consistent throughout\n\nFile v1.0.0:README.md\n\n# Financial Services for OpenClaw\n\n面向金融专业人士的 AI 分析技能集合。覆盖投行、商业银行、资管、保险四大场景，内置源归因机制和标准化输出格式。\n\n## 安装\n\n### 方式一：ClawHub 安装\n```bash\nclawhub install financial-services\n```\n\n### 方式二：手动安装\n将整个 `financial-services/` 目录复制到 `~/.openclaw/skills/`：\n\n```bash\ncp -r financial-services ~/.openclaw/skills/\n```\n\n重启 OpenClaw Gateway 后生效。\n\n## 技能列表\n\n### 核心分析技能\n| 技能 | 说明 | 典型场景 |\n|------|------|----------|\n| `investment-banking` | 投行分析方法论 | Pitch book, CIM, Comps, DCF, 并购估值 |\n| `commercial-banking` | 商业银行分析方法论 | Credit memo, 贷款承销, 合约测试, 现金流分析 |\n| `asset-management` | 资管分析方法论 | 组合报告, Brinson归因, IC memo, 业绩Deck |\n| `insurance` | 保险分析方法论 | 准备金审查, 精算分析, 承保, 监管报告 |\n\n### 基础技能\n| 技能 | 说明 |\n|------|------|\n| `source-attribution` | 每个数字必须追溯到源文档。金融声明验证清单。 |\n| `excel-powerpoint-output` | Excel 工作簿和 PowerPoint Deck 的标准化格式规范 |\n\n## 工作流\n\n```\n用户请求（如\"帮我做pitch book\"）\n         ↓\ninvestment-banking（投行分析流程）\n         ↓\nsource-attribution（源归因验证）\n         ↓\nexcel-powerpoint-output（标准化输出）\n         ↓\n交付：Excel 模型 + PowerPoint Deck\n```\n\n## 四大场景示例\n\n### 投行：构建估值摘要 Slide\n```\n用附件CIM和可比公司财务数据，构建Meridian收购的估值摘要。\n包含：EV/Revenue和EV/EBITDA中位数和Meridian倍数、\n可比公司隐含估值范围、10-12% WACC的DCF、先例交易。\n格式化为标准pitch book模板的PowerPoint。\n```\n\n### 商业银行：贷款承销分析\n```\n从借款人资料包中提取Atlas Manufacturing近四年财务数据，\n映射到合约条款。包含利润表、资产负债表、关键信用比率、\n现金流及同比变化。高亮FY2026E中任何合约违约或接近违约项。\n输出为内部信用委员会审查格式的Excel工作簿。\n```\n\n### 资管：组合业绩报告\n```\n用持仓数据和基准收益率生成Pinnacle Growth Equity Fund\nQ1 2026业绩摘要。使用Brinson-Fachler行业归因。\n包含：主动收益和信息比率、行业贡献（bps）、\n风险指标：Sharpe、Beta、最大回撤、主动份额。\n格式化为面向机构投资者的PowerPoint slide。\n```\n\n### 保险：准备金充足性审查\n```\n用附件精算工作簿和监管报告审查Sentinel Casualty\n一般责任险准备金充足性。显示：总选择终极赔付、\n已提准备金vs指示准备金及冗余、2019-2025事故年\n平均终极趋势。构建链比率热力图。\n格式化为董事会精算委员会的PowerPoint slide。\n```\n\n## 数据源集成\n\n本技能集合定义分析方法论。数据接入通过 MCP connectors 配置：\n\n| 数据源 | 用途 |\n|--------|------|\n| FactSet | 股票价格、财务数据、一致预期 |\n| S&P Global / Capital IQ | 财务数据、财报电话会纪要 |\n| Morningstar | 估值数据、研究分析 |\n| PitchBook | 私募市场数据 |\n| Databricks / Snowflake | 企业内部数据平台 |\n| Box | 安全文档管理和数据室分析 |\n| Daloopa | 公开披露的基础数据和KPI |\n\n配置 MCP server 后，技能会自动利用可用数据源。\n\n## 兼容性\n\n- 平台：OpenClaw\n- 格式：SKILL.md（YAML frontmatter + Markdown）\n- 无需额外依赖\n\n## 许可\n\nMIT-0\n\n## 致谢\n\n灵感来自 Anthropic 的 [Claude for Financial Services](https://claude.com/solutions/financial-services)。\n\nFile v1.0.0:_meta.json\n\n{\n  \"ownerId\": \"kn73dzb00yb0z6x3a38w5k7gtx84exb7\",\n  \"slug\": \"financial-services\",\n  \"version\": \"1.0.0\",\n  \"publishedAt\": 1778309494979\n}\n\nFile v1.0.0:skill-card.md\n\n## Description:\n\nComplete financial analysis methodology for OpenClaw: a 6-skill collection covering investment banking, commercial banking, asset management, insurance, source attribution, and standardized output for financial analysis, modeling, due diligence, and report generation.\n\nThis skill is ready for commercial/non-commercial use.\n\n## Publisher:\n\n[fenccerece](https://clawhub.ai/user/fenccerece)\n\n### License/Terms of Use:\n\nMIT-0\n\n## Use Case:\n\nFinancial professionals and OpenClaw users use this skill collection to structure investment banking, commercial banking, asset management, insurance, source attribution, and formatted Excel or PowerPoint financial deliverables.\n\n### Deployment Geography for Use:\n\nGlobal\n\n## Known Risks and Mitigations:\n\nRisk: Financial analysis outputs could be mistaken for final lending, investment, insurance, or regulatory decisions.\n\nMitigation: Require qualified human review before relying on any output for financial or regulatory decisions.\n\nRisk: Configured data connectors could expose more financial documents or provider data than intended.\n\nMitigation: Scope MCP data connectors to the specific document repositories and financial data providers needed for the task.\n\nRisk: Unverified figures or stale data could make generated financial deliverables misleading.\n\nMitigation: Apply the source-attribution workflow so every material number has a source, date, and cross-check where available.\n\n## Reference(s):\n\n- [ClawHub Skill Page](https://clawhub.ai/fenccerece/skills/financial-services)\n- [Project Homepage](https://github.com/openclaw/financial-services)\n- [Claude for Financial Services](https://claude.com/solutions/financial-services)\n\n## Skill Output:\n\n**Output Type(s):** [Guidance, Markdown, Code, Shell commands, Configuration]\n\n**Output Format:** [Markdown guidance with financial tables, formulas, checklists, and optional Excel or PowerPoint deliverable specifications]\n\n**Output Parameters:** [1D]\n\n**Other Properties Related to Output:** [Requires source attribution for financial numbers and review before lending, investment, insurance, or regulatory use.]\n\n## Skill Version(s):\n\n1.0.0 (source: ClawHub release metadata)\n\n## Ethical Considerations:\n\nUsers should evaluate whether this skill is appropriate for their environment, review any generated or modified files before relying on them, and apply their organization's safety, security, and compliance requirements before deployment.","readmeExcerpt":"Skill: claude financial-services for openclaw Owner: fenccerece Summary: Complete financial analysis methodology for OpenClaw. A 6-skill collection covering investment banking, commercial banking, asset management, insurance, sour... Tags: latest:1.0.0 Version history: v1.0.0 | 2026-05-09T06:51:34.979Z | user Initial release of the financial-services skill collection for OpenClaw: - Introduces a comprehensive methodo","codeSnippets":[],"executableExamples":[{"language":"text","snippet":"Total Active Return = Allocation Effect + Selection Effect + Interaction Effect\n\nWhere:\n- Allocation Effect = (wp - wb) × (Rb - Rb_total)\n  (overweight sector × sector benchmark return vs total benchmark)\n\n- Selection Effect = wb × (Rp - Rb)\n  (sector benchmark weight × portfolio vs benchmark return within sector)\n\n- Interaction Effect = (wp - wb) × (Rp - Rb)\n  (combined effect of both weight and return differences)"},{"language":"text","snippet":"Sector       | Port Wt | Bmk Wt | Active | Port Ret | Bmk Ret | Alloc  | Select | Interact | Total\n-------------|---------|--------|--------|----------|---------|--------|--------|----------|------\nTechnology   | 32.5%   | 28.0%  | +4.5%  | 12.3%    | 10.1%   | +0.45% | +0.70% | +0.10%   | +1.25%\nHealthcare   | 18.2%   | 20.0%  | -1.8%  | 8.5%     | 9.2%    | -0.17% | -0.13% | +0.01%   | -0.29%\nFinancials   | 15.0%   | 16.0%  | -1.0%  | 6.8%     | 7.5%    | -0.08% | -0.11% | +0.01%   | -0.18%\n...          | ...     | ...    | ...    | ...      | ...     | ...    | ...    | ...      | ...\nTOTAL        | 100.0%  | 100.0% | 0.0%   | X.X%     | X.X%    | +X.X%  | +X.X%  | +X.X%    | +X.X%"},{"language":"text","snippet":"Sharpe Ratio = (Rp - Rf) / σp\n  - Rp = portfolio return, Rf = risk-free rate, σp = portfolio standard deviation\n  - Interpretation: > 1.0 good, > 2.0 excellent\n\nSortino Ratio = (Rp - Rf) / σd\n  - σd = downside deviation only\n  - Better for asymmetric return distributions\n\nInformation Ratio = (Rp - Rb) / TE\n  - TE = tracking error = σ(Rp - Rb)\n  - Interpretation: > 0.5 good, > 1.0 excellent\n\nBeta = Cov(Rp, Rb) / Var(Rb)\n  - Sensitivity to benchmark movements\n  - β > 1 = more volatile than benchmark\n\nMax Drawdown = max(Peak - Trough) / Peak\n  - Worst peak-to-trough decline\n  - Report: date of peak, date of trough, recovery time\n\nActive Share = (1/2) × Σ|wp_i - wb_i|\n  - Percentage of portfolio that differs from benchmark\n  - < 60% = closet indexer, > 80% = truly active\n\nTracking Error = σ(Rp - Rb) × √12 (if monthly data)\n  - Annualized standard deviation of active returns\n\nVaR (95%) = μ - 1.645 × σ\n  - Maximum expected loss at 95% confidence over 1 day\n  - Report: parametric, historical, and Monte Carlo if available"},{"language":"text","snippet":"Metric              | Portfolio | Benchmark | Peer Median\n--------------------|-----------|-----------|------------\nReturn (1Y)         |   X.X%   |   X.X%    |   X.X%\nVolatility (1Y)     |   X.X%   |   X.X%    |   X.X%\nSharpe Ratio        |   X.XX   |   X.XX    |   X.XX\nSortino Ratio       |   X.XX   |   —       |   X.XX\nInformation Ratio   |   X.XX   |   —       |   X.XX\nMax Drawdown        |  (X.X%)  |  (X.X%)   |  (X.X%)\nBeta                |   X.XX   |   1.00    |   X.XX\nActive Share        |   X.X%   |   —       |   X.X%\nTracking Error      |   X.X%   |   —       |   X.X%\nVaR (95%, 1-day)    |  (X.X%)  |  (X.X%)   |  (X.X%)"},{"language":"text","snippet":"Row | Category           | FY2023 | FY2024 | FY2025 | FY2026E | YoY Chg\n----|--------------------|--------|--------|--------|---------|--------\n    | INCOME STATEMENT   |        |        |        |         |\n    | Revenue            |        |        |        |         |  X%\n    | COGS               |        |        |        |         |  X%\n    | Gross Profit       |        |        |        |         |  X%\n    | Gross Margin       |        |        |        |         |  X bps\n    | SG&A               |        |        |        |         |  X%\n    | EBITDA             |        |        |        |         |  X%\n    | EBITDA Margin      |        |        |        |         |  X bps\n    | D&A                |        |        |        |         |  X%\n    | EBIT               |        |        |        |         |  X%\n    | Interest Expense   |        |        |        |         |  X%\n    | Pre-tax Income     |        |        |        |         |  X%\n    | Taxes              |        |        |        |         |  X%\n    | Net Income         |        |        |        |         |  X%\n    |                    |        |        |        |         |\n    | BALANCE SHEET      |        |        |        |         |\n    | Cash               |        |        |        |         |  X%\n    | Accounts Receivable|        |        |        |         |  X%\n    | Inventory          |        |        |        |         |  X%\n    | Total Current Assets|       |        |        |         |  X%\n    | PP&E (net)         |        |        |        |         |  X%\n    | Total Assets       |        |        |        |         |  X%\n    |                    |        |        |        |         |\n    | Current Liabilities|        |        |        |         |  X%\n    | Long-term Debt     |        |        |        |         |  X%\n    | Total Liabilities  |        |        |        |         |  X%\n    | Shareholders' Equity|       |        |        |         |  X%\n    | Total L&E          |    "},{"language":"text","snippet":"Total Debt / EBITDA        → Target: < 3.0x (investment grade: < 2.0x)\nNet Debt / EBITDA          → Target: < 2.5x\nDebt / Total Capital       → Target: < 50%\nDebt / Equity              → Target: < 1.0x"}],"parameters":null,"dependencies":[],"permissions":[],"extractedFiles":[{"path":"asset-management/SKILL.md","content":"---\nname: financial-services-asset-management\ndescription: >\n  Use when building portfolio reports, performance attribution analyses, IC memos, fund performance decks, or any asset management deliverable. Covers Brinson attribution, risk metrics, and institutional investor reporting.\nmetadata:\n  openclaw:\n    emoji: \"📈\"\n---\n\n# Asset Management\n\n构建资管级别的分析材料：组合报告、Brinson 归因分析、IC memo、业绩 Deck、风险指标。\n\n**Announce at start:** \"I'm using the asset-management skill to structure this portfolio analysis.\"\n\n## Core Principle\n\n资管报告的核心是回答：业绩从哪来（归因）、风险在哪（风控）、下一步怎么做（展望）。每个绩效数字必须与基准和持仓数据交叉验证。\n\n**REQUIRED:** Use financial-services:source-attribution before finalizing any deliverable.\n**REQUIRED:** Use financial-services:excel-powerpoint-output for all output formatting.\n\n## Checklist\n\nYou MUST create a task for each applicable item and complete them in order:\n\n1. **Parse the request** — Identify deliverable type (attribution / IC memo / performance deck / risk report)\n2. **Gather source materials** — Holdings data, benchmark returns, market data\n3. **Calculate returns** — Time-weighted and money-weighted returns\n4. **Run attribution** — Brinson-Fachler or other attribution method\n5. **Calculate risk metrics** — Sharpe, beta, max drawdown, tracking error, active share\n6. **Source attribution** — Verify every number traces to source\n7. **Format output** — Apply standardized Excel/PowerPoint formatting\n\n## Workflow: Portfolio Performance Attribution\n\n**Brinson-Fachler Attribution Model:**\n\nThe Brinson-Fachler model decomposes active return into allocation and selection effects:\n\n```\nTotal Active Return = Allocation Effect + Selection Effect + Interaction Effect\n\nWhere:\n- Allocation Effect = (wp - wb) × (Rb - Rb_total)\n  (overweight sector × sector benchmark return vs total benchmark)\n\n- Selection Effect = wb × (Rp - Rb)\n  (sector benchmark weight × portfolio vs benchmark return within sector)\n\n- Interaction Effect = (wp - wb) × (Rp - Rb)\n  (combined effect of both weight and return differences)\n```\n\n**Standard Attribution Table:**\n```\nSector       | Port Wt | Bmk Wt | Active | Port Ret | Bmk Ret | Alloc  | Select | Interact | Total\n-------------|---------|--------|--------|----------|---------|--------|--------|----------|------\nTechnology   | 32.5%   | 28.0%  | +4.5%  | 12.3%    | 10.1%   | +0.45% | +0.70% | +0.10%   | +1.25%\nHealthcare   | 18.2%   | 20.0%  | -1.8%  | 8.5%     | 9.2%    | -0.17% | -0.13% | +0.01%   | -0.29%\nFinancials   | 15.0%   | 16.0%  | -1.0%  | 6.8%     | 7.5%    | -0.08% | -0.11% | +0.01%   | -0.18%\n...          | ...     | ...    | ...    | ...      | ...     | ...    | ...    | ...      | ...\nTOTAL        | 100.0%  | 100.0% | 0.0%   | X.X%     | X.X%    | +X.X%  | +X.X%  | +X.X%    | +X.X%\n```\n\n**Interpretation Guide:**\n- Positive allocation: overweight in outperforming sectors (or underweight in underperforming)\n- Positive selection: picked better securities within sector\n- Interaction: combined effect (usually small, but can be meaningful"},{"path":"commercial-banking/SKILL.md","content":"---\nname: financial-services-commercial-banking\ndescription: >\n  Use when building credit memos, loan underwriting analyses, covenant compliance tests, spread sheets, or cash flow analyses for lending decisions. Covers the full commercial banking credit analysis workflow.\nmetadata:\n  openclaw:\n    emoji: \"🏦\"\n---\n\n# Commercial Banking\n\n构建商业银行级别的信用分析材料：credit memo、贷款承销、合约合规测试、财务展期、现金流分析。\n\n**Announce at start:** \"I'm using the commercial-banking skill to structure this credit analysis.\"\n\n## Core Principle\n\n信用分析的核心是还款能力评估。每一项财务数据必须映射到合约条款，每一个风险判断必须有数据支撑。\n\n**REQUIRED:** Use financial-services:source-attribution before finalizing any deliverable.\n**REQUIRED:** Use financial-services:excel-powerpoint-output for all output formatting.\n\n## Checklist\n\nYou MUST create a task for each applicable item and complete them in order:\n\n1. **Parse the request** — Identify deliverable type (credit memo / covenant test / spread sheet / cash flow)\n2. **Gather source materials** — Borrower package, financial statements, covenant terms, industry data\n3. **Spread financials** — Map historical financials to standardized format\n4. **Run credit ratios** — Calculate key credit metrics\n5. **Covenant compliance test** — Test against covenant terms\n6. **Risk assessment** — Identify and quantify risks\n7. **Source attribution** — Verify every number traces to source\n8. **Format output** — Apply standardized Excel formatting\n\n## Workflow: Financial Spreading\n\nWhen spreading financials from a borrower package:\n\n**Standard Layout (Excel):**\n```\nRow | Category           | FY2023 | FY2024 | FY2025 | FY2026E | YoY Chg\n----|--------------------|--------|--------|--------|---------|--------\n    | INCOME STATEMENT   |        |        |        |         |\n    | Revenue            |        |        |        |         |  X%\n    | COGS               |        |        |        |         |  X%\n    | Gross Profit       |        |        |        |         |  X%\n    | Gross Margin       |        |        |        |         |  X bps\n    | SG&A               |        |        |        |         |  X%\n    | EBITDA             |        |        |        |         |  X%\n    | EBITDA Margin      |        |        |        |         |  X bps\n    | D&A                |        |        |        |         |  X%\n    | EBIT               |        |        |        |         |  X%\n    | Interest Expense   |        |        |        |         |  X%\n    | Pre-tax Income     |        |        |        |         |  X%\n    | Taxes              |        |        |        |         |  X%\n    | Net Income         |        |        |        |         |  X%\n    |                    |        |        |        |         |\n    | BALANCE SHEET      |        |        |        |         |\n    | Cash               |        |        |        |         |  X%\n    | Accounts Receivable|        |        |        |         |  X%\n    | Inventory          |        |        |        |         |  X%\n    | Total Current Assets|       | "},{"path":"excel-powerpoint-output/SKILL.md","content":"---\nname: financial-services-excel-powerpoint-output\ndescription: >\n  Use when generating Excel workbooks or PowerPoint decks for financial deliverables. Enforces consistent professional formatting for financial models, comps tables, pitch decks, and analytical reports. Applied after analysis is complete.\nmetadata:\n  openclaw:\n    emoji: \"📐\"\n---\n\n# Excel & PowerPoint Output\n\n金融 Excel 工作簿和 PowerPoint Deck 的标准化格式规范。\n\n**Announce at start:** \"I'm using the excel-powerpoint-output skill to format the deliverable.\"\n\n## Core Principle\n\n格式一致性和专业性是金融交付物的基本要求。好的格式让审阅者快速找到关键信息，差的格式掩盖好的分析。\n\n## Excel Formatting Standards\n\n### Number Format\n\n```\nType                | Format              | Example\n--------------------|---------------------|----------\nRevenue, large      | $#,##0.0\"M\"        | $4,218.5M\nRevenue, small      | $#,##0.0\"K\"        | $421.8K\nPercentages         | 0.00%              | 24.35%\nPercentages (bps)   | 0 bps              | 235 bps\nMultiples           | 0.00x              | 12.55x\nRatios              | 0.00               | 1.15\nShare price         | $#,##0.00          | $142.55\nShares              | #,##0.0\"M\"         | 1,245.3M\nNegative values     | (#,##0) or (0.0%)  | (125.5) or (2.3%)\nN/A or N/M          | \"N/A\" or \"N/M\"     | text\n```\n\n### Color Coding\n\n```\nElement                  | Color (Light Mode) | Color (Dark Mode)\n-------------------------|-------------------|------------------\nHeader row background    | #1F2937 (gray-800)| #F9FAFB (gray-50)\nHeader row text          | #FFFFFF (white)    | #111827 (gray-900)\nSubheader background     | #E5E7EB (gray-200)| #374151 (gray-700)\nPositive values          | #059669 (green-600)| #34D399 (green-400)\nNegative values          | #DC2626 (red-600)  | #F87171 (red-400)\nCovenant breach          | #FEE2E2 bg + red text|#7F1D1D bg + #FCA5A5\nCovenant near-miss       | #FEF3C7 bg + amber  |#78350F bg + #FCD34D\nInput cells              | #DBEAFE bg (blue)  | #1E3A5F bg\nCalculated cells         | No background       | No background\nBorders                  | #D1D5DB (gray-300) | #4B5563 (gray-600)\n```\n\n### Layout Rules\n\n**General:**\n- Freeze panes: freeze header row AND first column (company names)\n- Column widths: auto-fit, minimum 10 characters\n- Row heights: 15pt standard, 20pt for header rows\n- Font: Calibri 10pt body, 11pt headers, 9pt footnotes\n- Alignment: numbers right-aligned, text left-aligned, headers center-aligned\n\n**Financial Model Tab:**\n```\nColumn A: Row labels (left-aligned, bold for section headers)\nColumn B+: Periods (FY2023, FY2024, etc.)\nLast column: CAGR or YoY change\n\nSection headers: bold, light gray background\nSubtotals: top border (thin line)\nGrand totals: top and bottom border (double line)\nInput assumptions: blue font or blue background\nCalculated values: black font, no special background\n```\n\n**Comps Table Tab:**\n```\nColumn A: Company name\nColumn B: Ticker\nColumn C+: Financial metrics and multiples\nLast rows: Median, Mean, Min, Max, Target position\n\nSort order: by EV/EBIT"},{"path":"insurance/SKILL.md","content":"---\nname: financial-services-insurance\ndescription: >\n  Use when reviewing reserve adequacy, building actuarial analyses, analyzing underwriting results, or preparing insurance regulatory filings. Covers reserve analysis, link ratio triangles, actuarial review, and insurance-specific financial reporting.\nmetadata:\n  openclaw:\n    emoji: \"🛡️\"\n---\n\n# Insurance\n\n构建保险级别的分析材料：准备金充足性审查、精算分析、承保结果分析、监管报告。\n\n**Announce at start:** \"I'm using the insurance skill to structure this actuarial analysis.\"\n\n## Core Principle\n\n保险分析的核心是不确定性量化。精算数据必须展示置信区间和敏感性，不能只给点估计。每个假设必须明确标注来源和合理性。\n\n**REQUIRED:** Use financial-services:source-attribution before finalizing any deliverable.\n**REQUIRED:** Use financial-services:excel-powerpoint-output for all output formatting.\n\n## Checklist\n\nYou MUST create a task for each applicable item and complete them in order:\n\n1. **Parse the request** — Identify deliverable type (reserve review / actuarial analysis / underwriting / regulatory)\n2. **Gather source materials** — Actuarial workbook, regulatory filings, loss triangles\n3. **Analyze reserve adequacy** — Compare carried vs indicated reserves\n4. **Build link ratios** — Development triangles and heatmaps\n5. **Flag anomalies** — Accelerated development, tail divergence, elevated initial reporting\n6. **Source attribution** — Verify every number traces to source\n7. **Format output** — Apply standardized Excel/PowerPoint formatting\n\n## Workflow: Reserve Adequacy Review\n\n**Step 1: Reserve Summary**\n```\nLine of Business    | Carried Reserves | Indicated Reserves | Redundancy/(Deficiency) | %\n--------------------|------------------|--------------------|-----------------------|-----\nWorkers' Comp       |    $XXX M        |    $XXX M          |    $XX M               | X.X%\nGeneral Liability   |    $XXX M        |    $XXX M          |    ($XX M)             | X.X%\nAuto Liability      |    $XXX M        |    $XXX M          |    $XX M               | X.X%\nProfessional Liab   |    $XXX M        |    $XXX M          |    ($XX M)             | X.X%\nProperty            |    $XX M         |    $XX M           |    $X M                | X.X%\nTOTAL               |    $X,XXX M      |    $X,XXX M        |    $XX M               | X.X%\n```\n\n**Step 2: Ultimate Loss Analysis**\n```\nAccident Year | Paid Losses | Case Reserves | IBNR  | Total Incurred | Selected Ultimate | % Developed\n--------------|-------------|---------------|-------|----------------|-------------------|-------------\n2019          | $XXX M      | $XX M         | $X M  | $XXX M         | $XXX M            | 98%\n2020          | $XXX M      | $XX M         | $XX M | $XXX M         | $XXX M            | 95%\n2021          | $XXX M      | $XX M         | $XX M | $XXX M         | $XXX M            | 88%\n2022          | $XXX M      | $XX M         | $XX M | $XXX M         | $XXX M            | 75%\n2023          | $XX M       | $XX M         | $XX M | $XXX M         | $XXX M            | 55%\n2024          | $XX M       | $XX M         | $XX M | $"},{"path":"investment-banking/SKILL.md","content":"---\nname: financial-services-investment-banking\ndescription: >\n  Use when building pitch books, CIMs, comps tables, DCF models, precedent transaction analyses, or any M&A valuation work. Covers the full investment banking analysis workflow from data gathering to formatted deliverables.\nmetadata:\n  openclaw:\n    emoji: \"📊\"\n---\n\n# Investment Banking\n\n构建投行级别的分析材料：pitch book、CIM、可比公司分析、DCF 估值、先例交易。\n\n**Announce at start:** \"I'm using the investment-banking skill to structure this analysis.\"\n\n## Core Principle\n\n每个数字必须可追溯到源文档。估值结论必须交叉验证（可比公司、DCF、先例交易三角验证）。\n\n**REQUIRED:** Use financial-services:source-attribution before finalizing any deliverable.\n**REQUIRED:** Use financial-services:excel-powerpoint-output for all output formatting.\n\n## Checklist\n\nYou MUST create a task for each applicable item and complete them in order:\n\n1. **Parse the request** — Identify deliverable type (pitch book / CIM / comps / DCF / precedent transactions)\n2. **Gather source materials** — Collect CIM, financial statements, peer data, market data\n3. **Build the analysis** — Follow the applicable workflow below\n4. **Cross-validate** — Triangulate valuation across methods\n5. **Source attribution** — Verify every number traces to source\n6. **Format output** — Apply standardized Excel/PowerPoint formatting\n7. **Self-review** — Run the review checklist before delivery\n\n## Workflow: Pitch Book / Valuation Summary\n\nWhen building a pitch book or valuation summary slide:\n\n**Step 1: Peer Selection**\n- Select 5-10 comparable companies based on: sector, size (revenue/EBITDA range), geography, business model\n- Justify each inclusion/exclusion in a brief note\n\n**Step 2: Comps Table**\nBuild a comps table with these columns:\n```\nCompany | EV | Revenue | EBITDA | EV/Revenue | EV/EBITDA | P/E | EV/EBITDA Growth\n```\n- Include: median, mean, min, max, target company position\n- Source each multiple to the specific filing or data provider\n\n**Step 3: DCF Model**\nBuild a DCF with:\n- Free Cash Flow projections (5-10 year explicit period)\n- Terminal value (exit multiple or perpetuity growth method)\n- WACC calculation (show components: risk-free rate, equity risk premium, beta, cost of debt, capital structure)\n- Sensitivity table: WACC vs terminal growth/exit multiple\n- Clearly label: enterprise value, equity value, per-share value\n\n**Step 4: Precedent Transactions**\n- Collect 5-10 relevant M&A transactions in the same sector\n- Include: date, acquirer, target, deal value, EV/Revenue, EV/EBITDA\n- Adjust for market conditions if transactions are from different periods\n\n**Step 5: Valuation Triangle**\nPresent implied valuation range from all three methods:\n```\nMethod          | Low    | Midpoint | High\n----------------|--------|----------|-------\nComps           | $X.Xb  | $X.Xb    | $X.Xb\nDCF             | $X.Xb  | $X.Xb    | $X.Xb\nPrecedent Txns  | $X.Xb  | $X.Xb    | $X.Xb\nImplied Range   | $X.Xb  | $X.Xb    | $X.Xb\n```\n\n**Step 6: Position in Range**\n- Where does the target sit in its 52-week trading rang"}],"languages":[],"docsSourceLabel":"CLAWHUB","editorialOverview":"Complete financial analysis methodology for OpenClaw. A 6-skill collection covering investment banking, commercial banking, asset management, insurance, sour... Skill: claude financial-services for openclaw Owner: fenccerece Summary: Complete financial analysis methodology for OpenClaw. A 6-skill collection covering investment banking, commercial banking, asset management, insurance, sour... Tags: latest:1.0.0 Version history: v1.0.0 | 2026-05-09T06:51:34.979Z | user Initial release of the financial-services skill collection for OpenClaw: - Introduces a comprehensive methodo","editorialQuality":{"score":100,"threshold":65,"status":"ready","wordCount":1270,"uniquenessScore":51,"reasons":[]}},"media":{"evidence":{"source":"no-media","verified":false,"confidence":"low","updatedAt":"2026-10-12T01:05:49.584Z","emptyReason":"No screenshots, media assets, or demo links are available."},"primaryImageUrl":null,"mediaAssetCount":0,"assets":[],"demoUrl":null},"ownerResources":{"evidence":{"source":"unclaimed","verified":false,"confidence":"low","updatedAt":"2026-10-12T01:05:49.584Z","emptyReason":"This page has not been claimed by the agent owner."},"hasCustomPage":false,"customPageUpdatedAt":null,"customLinks":[],"structuredLinks":{"docsUrl":null,"demoUrl":null,"supportUrl":null,"pricingUrl":null,"statusUrl":null},"customPage":null},"relatedAgents":{"evidence":{"source":"protocol-neighbors","verified":false,"confidence":"medium","updatedAt":"2026-10-12T13:56:14.097Z","emptyReason":null},"items":[{"id":"8ebccd8e-3863-4187-8355-c3f14e1f9edf","entityType":"agent","canonicalPath":"/agent/iofficeai-aionui","slug":"iofficeai-aionui","name":"AionUi","description":"Free, local, open-source 24/7 Cowork app and OpenClaw for Gemini CLI, Claude Code, Codex, OpenCode, Qwen Code, Goose CLI, Auggie, and more | 🌟 Star if you like it!","url":"https://github.com/iOfficeAI/AionUi","homepage":"https://www.aionui.com","source":"GITHUB_REPOS","protocols":["MCP","OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-10-09T19:11:12.944Z","createdAt":"2026-02-25T03:38:16.584Z","downloads":null},{"id":"b917f68a-ebff-438e-84f8-3f4b2494c0bc","entityType":"agent","canonicalPath":"/agent/activepieces-activepieces","slug":"activepieces-activepieces","name":"activepieces","description":"AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents","url":"https://github.com/activepieces/activepieces","homepage":"https://www.activepieces.com","source":"GITHUB_REPOS","protocols":["OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-04-15T02:22:12.426Z","createdAt":"2026-02-25T03:38:12.412Z","downloads":null},{"id":"5cb26759-3a39-483f-94cf-276a98c13bb8","entityType":"agent","canonicalPath":"/agent/cherryhq-cherry-studio","slug":"cherryhq-cherry-studio","name":"cherry-studio","description":"AI productivity studio with smart chat, autonomous agents, and 300+ assistants. Unified access to frontier LLMs","url":"https://github.com/CherryHQ/cherry-studio","homepage":"https://cherry-ai.com","source":"GITHUB_REPOS","protocols":["MCP","OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-04-11T14:38:40.986Z","createdAt":"2026-02-25T03:38:19.379Z","downloads":null},{"id":"6f6582d0-5d76-4f0f-b81d-86520247950b","entityType":"agent","canonicalPath":"/agent/copilotkit-copilotkit","slug":"copilotkit-copilotkit","name":"CopilotKit","description":"The Frontend for Agents & Generative UI. React + Angular","url":"https://github.com/CopilotKit/CopilotKit","homepage":"https://docs.copilotkit.ai","source":"GITHUB_REPOS","protocols":["OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-03-25T09:50:57.846Z","createdAt":"2026-02-25T03:39:14.617Z","downloads":null}],"links":{"hub":"/agent","source":"/agent/source/clawhub","protocols":[{"label":"OpenClaw","href":"/agent/protocol/openclew"}]}}}