Professional Equity Valuation Modeling
Paste the following prompt into your AI chat to install this skill:
Please install @user_238915fc/equity-valuation by following https://skillhub.cn/install/skillhub.md.
About this skill
Problem
Equity valuations often fail because the inputs, model, and conclusion are not tightly coupled: FCFF is paired with the wrong WACC, FCFE mixes in the equity cost incorrectly, exam-style shortcuts leak into deal materials, or a single valuation point is presented without parameter sources, key assumptions, or sensitivity bounds. equity-valuation treats valuation as an auditable engineering workflow rather than a one-off answer.
How It Works
The skill is a valuation modeling engine and does not fetch prices, financials, β, Rf, or comparable multiples by itself; inputs must come from the user or an upstream connector such as ifind-finance-data. It classifies the target (public/private, cyclical/growth, financial/non-financial), selects a primary model plus a cross-check, and normalizes one-off gains, abnormal taxes, and accounting-policy noise. It supports DDM, FCFF, FCFE, relative multiples, and RI, with explicit formulas, WACC or cost-of-equity build-up, parameter sources, key assumptions, and sensitivity ranges. For semiconductor or private targets, it mandates data-trust checks via semiconductor-equity-investment-dd before modeling.
Boundaries
It does not execute trades and does not provide buy/sell advice. Missing inputs must be flagged as assumptions rather than filled with placeholder values. Report generation is local; .md, .html, and .docx outputs are produced in the workspace, with DOCX depending on python-docx.
Use Cases
- An equity analyst builds an FCFF-WACC DCF for a public company after receiving cleaned financials and outputs a valuation range.
- An M&A team compares DCF, comparable multiples, and residual income while documenting rejected models and parameter sources.
- A PE fund values a private target and presents control premium, minority discount, and liquidity discount separately.
- A semiconductor valuation first passes data-trust checks, then applies cycle-position and multiple adjustments to cleaned inputs.
Best For
- Equity analysts who need to convert supplied financials and assumptions into auditable DCF or relative-valuation reports.
- M&A or PE due-diligence staff who must explain model choice, parameter sources, sensitivities, and premium/discount conclusions.
- Buy-side or sell-side deal teams who need valuation worksheets with full formulas and disclosed bounds.
- Semiconductor investment teams that require data-trust verification before modeling a target.
Related Skills
Switch AI from a polite executor into a skeptical thinking partner, using assumption checks, pre-mortems, and evidence gates to expose weak ideas early.
Applies research discipline, data lookup, evidence grading, red-team checks, and structured reporting to analyze AI company investment logic.
Uses Qichacha or Tianyancha MCP data and public information to score corporate credit across 12 dimensions and output a Markdown risk report.
Calculates personal injury compensation via CLI and outputs case summary, standards, line items, sources, and risk notes.