Corporate Bond Portfolio Construction + Multi-Dimensional Risk Analysis
Corporate bond portfolio manual Excel calculations + cross-table credit risk lookups are too slow — Ginkgo offers a client-defined bond universe + one-click multi-dimensional portfolio analysis.
SCENARIO
Business Scenario
Family office fixed income allocations often hold corporate bond portfolios (10-100 bonds). Traditional workflow has multiple pain points: (1) Weighted yield / weighted duration calculated by Excel formulas are error-prone. (2) Credit risk indicators (rating divergence / gross debt leverage / net debt leverage / debt-to-asset ratio / interest coverage / cash flow interest coverage / free cash flow status / free cash flow coverage / NPL ratio / quick ratio / rapid price crash risk / short interest surge / redemption warning — 13+ types) are scattered across Bloomberg / sell-side research / rating agency reports. (3) Interest rate sensitivity tests at +/- N bps require Excel formula calculations. (4) Multi-dimensional exposure analysis (HQ country / revenue country / sector / issuer concentration) requires manual cross-table tabulation. (5) Principal / coupon cash flow waterfall by year requires Excel pivot tables.
MECHANISM
Mechanism · Three-Core Combination
Powered by Decoder + Polymorph + Horizon three-core combination
Decoder
Clients define their own corporate bond universe (investable scope freely maintained by the family office) + Ginkgo continuously ingests issuer financial metrics / ratings / sector classification / HQ country / revenue geography / cash flow data / stock price / short interest data and other multi-source data, structured into the database.
Polymorph
Client selects instruments from the universe + sets notional per bond → one-click portfolio analysis: KPI panel (portfolio NAV / weighted yield to maturity / weighted duration / simulated P&L) + interest rate sensitivity slider (-200bps ↔ +200bps real-time P&L) + principal / coupon cash flow waterfall bar chart by year + multi-dimensional exposure pie charts (HQ country / revenue country / sector group / issuer concentration).
Horizon
13+ credit risk indicator auto-scan — rating divergence / gross debt leverage / net debt leverage / debt-to-asset ratio / interest coverage / cash flow interest coverage / free cash flow status / free cash flow coverage / NPL ratio / quick ratio / rapid price crash / short interest surge / redemption warning etc. Each indicator shows the count of bonds in the portfolio that are triggered + red-yellow tiered flagging, so PMs see risk concentrations at a glance.