Public Company Financing Metric Analysis
Paste the following prompt into your AI chat to install this skill:
Please follow https://skillhub.cn/install/skillhub.md and install @user_231765ee/jango.
About this skill
Problem
Listed-company financing analysis is often reduced to checking leverage and interest expense, which does not reveal the actual capital structure. This skill organizes balance-sheet and income-statement inputs around WACC, ROIC, and ICR, creating a reviewable calculation path for public-company financing quality.
How It Works
The skill identifies the required fields first, then writes step-by-step JSON output:
- Interest-bearing debt: combines short-term borrowings, long-term borrowings, bonds payable, and non-current liabilities due within one year.
- Blended financing cost: uses interest expense / interest-bearing debt to estimate the cost of debt.
- WACC: applies Ke × E/(D+E) + Kd × (1-T) × D/(D+E) to calculate weighted cost of capital.
- ROIC: derives NOPAT, then divides by invested capital, where excess cash is deducted.
- ICR: compares the change in NOPAT with the change in invested capital to assess capital allocation efficiency.
Boundaries
It is suited for preliminary dissection of a listed company financing structure, not audit or valuation. Field definitions must be consistent; Ke, Kd, and tax rate require explicit assumptions when missing. The excess-cash rule uses 30% of interest-bearing debt, which may not fit cash-intensive businesses.
Use Cases
- When dissecting annual reports, organize borrowings, bonds, and interest fields into debt and cost tables.
- When evaluating M&A targets, fill Ke, Kd, and tax rate inputs to calculate WACC and sensitivity assumptions.
- When preparing investment committee materials, split NOPAT, invested capital, and excess cash into ROIC and ICR.
- In credit due diligence, aggregate debt components and annotate interest expense definitions before modeling.
Best For
- Sell-side analysts preparing annual-report teardowns who need interest-bearing debt, cost, and WACC inputs.
- Fund investment managers tracking post-deal projects who need NOPAT, invested capital, and ICR as JSON fields.
- Bank credit analysts conducting due diligence who must aggregate borrowings, bonds, and current liabilities.
- Finance managers drafting investment materials who need ROIC and ICR broken into traceable formulas.
Related Skills
A nanoAR projection advisor that applies fixed optics formulas to select films, projectors, and quote templates.
Run the ORI Nextflow collection on the Tencent Health Genomics Platform for protein generation, signal peptide, solubility, thermostability, and structure prediction.
Evaluates regional resources, industrial base, and innovation capacity to recommend future industry directions with actionable layout guidance.
A pre-IPO tax and internal-control framework covering three-year cleanup, restructuring tax, controls, remediation, related-party transactions, and compliance reporting.