Skip to content
cccskills
Official · ClaudeFreePublished on 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.

OriginalShow the original description

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".

Works withExcel

Run score Not tested

See how to install

Good for

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

Files included (1)

  • SKILL.md2.3 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

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

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

3-statement-model

Official · ClaudeFreeSummary

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-services40.7KUpdated Sep 22, 2026

accrual-schedule

Official · ClaudeFreeSummary

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-services40.7KUpdated Sep 22, 2026

ai-readiness

Official · ClaudeFreeSummary

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-services40.7KUpdated Sep 22, 2026

audit-xls

Official · ClaudeFreeSummary

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-services40.7KUpdated Sep 22, 2026

bond-futures-basis

Official · ClaudeFreeSummary

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-services40.7KUpdated Sep 22, 2026

bond-relative-value

Official · ClaudeFreeSummary

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-services40.7KUpdated Sep 22, 2026

See all skills by anthropics

Report a problem with this skill