跳到正文
cccskills
Claude 官方免费在 GitHub 公开

portfolio-monitoring

Review portfolio company financial reports in Excel, PDF, or CSV, compare key measures with budgets and prior periods, and summarize performance trends, warning signs, and compliance with financial conditions in loan agreements.

中文简介正在准备中。当前显示英语简介。

原文查看原文说明

Track and analyze portfolio company performance against plan. Ingests monthly/quarterly financial packages (Excel, PDF), extracts KPIs, flags variances to budget, and produces summary dashboards. Use when reviewing portfolio company financials, preparing board materials, or monitoring covenant compliance. Triggers on "review portfolio company", "monthly financials", "how is [company] performing", "covenant check", or "portfolio update".

集成工具Excel

实测评分 未实测

查看安装方法

适用场景

  • Reviewing monthly performance against budget
  • Preparing financial summaries for board meetings
  • Checking financial conditions in loan agreements
  • Tracking revenue, earnings, and cash over time

包含的文件(1)

  • SKILL.md2.3 KB

SKILL.md(原文)

安装前可以查看交给 AI 代理的指令内容。

Portfolio Monitoring

Workflow

Step 1: Ingest Financial Package

  • Accept the user's portfolio company financial package (Excel workbook, PDF, or CSV)
  • Extract key financials: Revenue, EBITDA, cash balance, debt outstanding, capex, working capital
  • Identify the reporting period and compare to prior period and budget/plan

Step 2: KPI Extraction & Variance Analysis

Key metrics to track (adapt to the company's sector):

Financial KPIs:

  • Revenue vs. budget ($ and %)
  • EBITDA and EBITDA margin vs. budget
  • Cash balance and net debt
  • Leverage ratio (Net Debt / LTM EBITDA)
  • Interest coverage ratio
  • Capex vs. budget
  • Free cash flow

Operational KPIs (ask user or infer from data):

  • Customer count / revenue per customer
  • Employee headcount / revenue per employee
  • Backlog / pipeline
  • Churn / retention rates

Step 3: Flag & Summarize

  • Green: Within 5% of plan
  • Yellow: 5-15% below plan — flag for discussion
  • Red: >15% below plan or covenant breach risk — immediate attention

Output a concise summary:

  1. One-paragraph executive summary ("Company X is tracking [ahead/behind/on] plan...")
  2. KPI table with actual vs. budget vs. prior period
  3. Red/yellow flags with context
  4. Covenant compliance status (if applicable)
  5. Questions for management

Step 4: Trend Analysis

If multiple periods are provided:

  • Chart key metrics over time (revenue, EBITDA, cash)
  • Identify trends — accelerating, decelerating, or stable
  • Compare vs. underwriting case

Important Notes

  • Always ask for the budget/plan to compare against if not provided
  • Don't assume sector-specific KPIs — ask what matters for this company
  • If covenant levels aren't known, ask the user for the credit agreement terms
  • Output should be board-ready — concise, factual, no fluff

评价

还没有评价。欢迎分享你的使用感受。

评论

无需登录即可发表。欢迎分享使用感受、提问,或说明在哪些环境下无法运行。

还没有评论。来写第一条吧。

提交后会立即公开。请勿填写邮箱、电话等个人信息。URL 最多 2 个。

0 / 1000 字

此表单受 reCAPTCHA 保护,适用 Google 的隐私权政策和服务条款。

同一仓库的技能

3-statement-model

Claude 官方免费

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

中文简介正在准备中。当前显示英语简介。

  • Complete a partially filled financial model
  • Link forecasts across three financial statements
  • Check balance sheet and cash flow consistency
anthropics/financial-services4.1万2026年9月22日 更新

accrual-schedule

Claude 官方免费

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

中文简介正在准备中。当前显示英语简介。

  • Preparing an accrual schedule for month-end close
  • Calculating audit fee, bonus, or utilities accruals
  • Drafting journal entries with supporting references
anthropics/financial-services4.1万2026年9月22日 更新

ai-readiness

Claude 官方免费

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

中文简介正在准备中。当前显示英语简介。

  • Quarterly reviews of AI opportunities across portfolio companies
  • Prioritizing companies for AI investment and operational support
  • Finding ways to reuse successful AI projects across companies
anthropics/financial-services4.1万2026年9月22日 更新

audit-xls

Claude 官方免费

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

中文简介正在准备中。当前显示英语简介。

  • Checking formulas in a selected range
  • Investigating a balance sheet that does not balance
  • Reviewing a financial model before client delivery
anthropics/financial-services4.1万2026年9月22日 更新

bond-futures-basis

Claude 官方免费

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

中文简介正在准备中。当前显示英语简介。

  • Comparing bond futures with cash bond prices
  • Identifying the cheapest bond to deliver
  • Comparing implied financing rates with market rates
anthropics/financial-services4.1万2026年9月22日 更新

bond-relative-value

Claude 官方免费

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

中文简介正在准备中。当前显示英语简介。

  • Comparing the relative value of candidate bonds
  • Separating credit risk from other yield differences
  • Estimating gains and losses under interest rate shifts
anthropics/financial-services4.1万2026年9月22日 更新

查看 anthropics 的全部技能

报告此技能的问题