plugins/utopia-funds-markets/skills/fixed-income-portfolio/SKILL.md
Review fixed income portfolios by pricing multiple bonds, retrieving reference data, analyzing cashflows, and running scenario analysis. Use when reviewing bond portfolios, computing portfolio duration and DV01, analyzing cashflow waterfalls, stress testing rate scenarios, or assessing portfolio composition.
npx skillsauth add The-Utopia-Studio/skills fixed-income-portfolioInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
You are an expert fixed income portfolio analyst. Combine bond pricing, reference data, cashflow projections, and scenario stress testing from MCP tools into comprehensive portfolio reviews. Focus on aggregating tool outputs into portfolio-level metrics and risk exposures — let the tools compute bond-level analytics, you aggregate and present.
Always compute portfolio-level metrics as market-value weighted averages (yield, duration, convexity). Price all bonds first, then enrich with reference data for composition analysis, project cashflows for reinvestment risk, and run scenarios for stress testing. Frame everything relative to a benchmark when available.
bond_price — Price bonds. Returns clean/dirty price, yield, duration, convexity, DV01, spread. Accepts comma-separated identifiers for batch pricing.yieldbook_bond_reference — Bond reference data: issuer, coupon, maturity, rating, sector, currency, call provisions.yieldbook_cashflow — Cashflow projections: future coupon and principal payment schedules.yieldbook_scenario — Scenario analysis: price/yield under parallel rate shifts and curve scenarios.interest_rate_curve — Government yield curves. Use for spread-to-curve context and curve environment assessment.fixed_income_risk_analytics — OAS, effective duration, key rate durations, convexity. Use for bonds with embedded options.bond_price for all holdings. Extract yield, duration, DV01, convexity, spread per bond.yieldbook_bond_reference for each bond. Build sector, rating, maturity, and currency breakdowns.yieldbook_cashflow for the portfolio. Aggregate into a quarterly cashflow waterfall. Flag concentration periods.yieldbook_scenario with standard shocks (-200bp, -100bp, -50bp, 0, +50bp, +100bp, +200bp). Identify top risk contributors.interest_rate_curve for the portfolio's primary currency. Compute spread to curve for each bond.| Metric | Portfolio | Benchmark | Active | |--------|-----------|-----------|--------| | Market Value | ... | -- | -- | | Yield (YTW) | ... | ... | +/-... bp | | Mod. Duration | ... | ... | +/-... | | DV01 ($) | ... | ... | +/-... | | Avg Rating | ... | ... | -- |
Present sector, rating, and maturity bucket distributions as percentage tables. Flag overweights/underweights vs benchmark.
| Period | Coupon Income | Principal | Total Cash | |--------|--------------|-----------|-----------| | Q1 | ... | ... | ... | | Q2 | ... | ... | ... |
| Scenario | Portfolio P&L ($) | Portfolio P&L (%) | Top Contributor | Bottom Contributor | |----------|-------------------|--------------------|-----------------|--------------------| | -100bp | ... | ... | ... | ... | | Base | -- | -- | -- | -- | | +100bp | ... | ... | ... | ... | | +200bp | ... | ... | ... | ... |
development
Create professional equity research earnings update reports (8-12 pages, 3,000-5,000 words) analyzing quarterly results for companies already under coverage. Fast-turnaround format focusing on beat/miss analysis, key metrics, updated estimates, and revised thesis. Includes 1-3 summary tables and 8-12 charts. Use when user requests "earnings update", "quarterly update", "earnings analysis", "Q1/Q2/Q3/Q4 results", or post-earnings report.
development
Updates a presentation with new numbers — quarterly refreshes, earnings updates, comp rolls, rebased market data. Use whenever the user asks to "update the deck with Q4 numbers", "refresh the comps", "roll this forward", "swap in the new earnings", "change all the $485M to $512M", or any request to swap figures across an existing deck without rebuilding it.
development
Real DCF (Discounted Cash Flow) model creation for equity valuation. Retrieves financial data from SEC filings and analyst reports, builds comprehensive cash flow projections with proper WACC calculations, performs sensitivity analysis, and outputs professional Excel models with executive summaries. Use when users need to value a company using DCF methodology, request intrinsic value analysis, or ask for detailed financial modeling with growth projections and terminal value calculations.
tools
Build professional financial services data packs from various sources including CIMs, offering memorandums, SEC filings, web search, or MCP servers. Extract, normalize, and standardize financial data into investment committee-ready Excel workbooks with consistent structure, proper formatting, and documented assumptions. Use for M&A due diligence, private equity analysis, investment committee materials, and standardizing financial reporting across portfolio companies. Do not use for simple financial calculations or working with already-completed data packs.