executing-plans
executing-plans
Use when executing an implementation plan in the current session as the implementer yourself — your human partner chose inline execution, or no subagent tool is available
reverse-dcfReverse DCF (reverse discounted cash flow) valuation tool. Uses the market price to back-solve the market's implied growth rate expectations, replacing the common forward DCF routine of "tweaking parameters to fit the conclusion." Suitable for mature companies with positive FCFF (A-shares, Hong Kong-listed stocks, and U.S.-listed stocks). Trigger when the u…
Independent GitHub snapshot · Automated classification · Original documentation governs
Forward DCF: given assumptions, calculate a target price. The parameters can be adjusted arbitrarily and end up "serving the conclusion."
Reverse DCF: given the market price, back-solve the implied growth rate and translate "expensive" or "cheap" into a verifiable proposition.
The essential difference:
Necessary condition: base-year FCFF must be positive.
Applying a standard two-stage DCF to companies with negative FCFF, such as early-stage high-growth companies or companies in an asset-heavy expansion phase, produces meaningless results.
Alternative: use PS-implied revenue back-solving (see "Handling Special Cases" below).
Data requirements:
EV = Market Capitalization + Net Debt
Net Debt = Interest-Bearing Debt - Cash and Cash Equivalents - Financial Assets Held for Trading
Notes:
Recommended Method A: Back-solve from CFO (most reliable in practice)
FCFF = CFO - Capex + After-Tax Interest Expense
Verification Method B: Bottom-up from NOPAT
NOPAT = Operating Profit × (1 - Effective Tax Rate)
FCFF = NOPAT + D&A - Capex - ΔWC
Important: the base year determines everything
Re = Rf + β × ERP
WACC = Re × We + Rd×(1-t) × Wd
Suggested parameter sources:
| Parameter | Source |
|---|---|
| Risk-free rate Rf | 10-year government bond yield in the company's home country |
| Equity risk premium ERP | Damodaran annual data (varies by country) |
| β | Damodaran industry unlevered β → re-lever based on D/E (more robust than a single-stock regression β) |
| Pre-tax cost of debt Rd | Average level of investment-grade corporate bonds in the company's home country |
| Effective tax rate | Company's actual effective tax rate (calculated from financial statements, not the statutory rate) |
EV = Σ [FCFF₀ × (1+g₁)ᵗ / (1+WACC)ᵗ] + [FCFF₁₀ × (1+g₂) / (WACC-g₂)] / (1+WACC)¹⁰
Where:
Forward DCF: given g₁ and g₂, solve for EV.
Reverse DCF: given EV and g₂, solve for g₁.
Perpetual growth g₂
1.5% 2.0% 2.5% 3.0% 3.5%
18% xxx xxx xxx xxx xxx
CAGR 20% xxx xxx xxx xxx xxx
g₁ 22% xxx xxx xxx xxx xxx
25% xxx xxx xxx [1189] xxx ← Target EV
28% xxx xxx xxx xxx xxx
Key observations:
After calculating the implied CAGR, make three translations:
Translation 1: Company size in 10 years
FCFF₁₀ = FCFF₀ × (1+g₁)¹⁰
Corresponding revenue ≈ FCFF₁₀ / (current FCFF/revenue conversion rate)
Translation 2: What needs to happen at the industry level
Current TAM → required revenue in 10 years → implied market share change
Or: how many times TAM must grow to support it
Translation 3: Compare with history
Company's actual CAGR over the past 10 years vs implied CAGR
Historical CAGR comparison with industry peers/global tech giants
(TSMC's CAGR over the past 20 years was approximately 18%, already an industry miracle)
A standard two-stage DCF cannot be used for the back-solve. Use PS-implied revenue back-solving instead:
Implied Revenue₁₀ = Market Capitalization / Terminal PE / Net Profit Margin
Implied CAGR = (Implied Revenue₁₀ / Current Revenue)^(1/10) - 1
Use cycle-median FCFF instead of a single year's FCFF as the base-year data.
You can also use the Exit Multiple method instead of the Gordon Growth Model to calculate terminal value.
| Data | Recommended acquisition method |
|---|---|
| Stock price/market capitalization | browser_use navigate to Sina Finance or Xueqiu individual stock pages, then use get_text to extract |
| Financial statement data | Use browser_use navigate to open https://emweb.securities.eastmoney.com/PC_HSF10/NewFinanceAnalysis/Index?type=web&code=<stock-code>; the income statement, balance sheet, and cash flow statement tabs provide the complete data. |
| Details of interest-bearing debt | Same as above, balance sheet tab: short-term borrowings, long-term borrowings, lease liabilities, and bonds payable |
| CFO/Capex | Same as above, cash flow statement tab: net cash flow from operating activities and cash paid to acquire and construct fixed assets |
| Industry β/ERP | Damodaran Online (pages.stern.nyu.edu/~adamodar/) |
| 10-year government bond yield | TradingView or official central bank websites, retrieved with browser_use navigate |
| Historical revenue/CAGR | East Money PC_HSF10 income statement tab, pull 5-10 years of revenue data and calculate manually |
Note: All data should be retrieved in real time through
browser_use; do not rely on training data. A-share stock codes in emweb format areSH600519(Shanghai) orSZ000651(Shenzhen), and Hong Kong stocks useHK00700.
Series of articles (author: monokuro, Manager on the valuation team at a Big Four accounting firm in Tokyo):
The core methodological reference is Aswath Damodaran's valuation framework (Investment Valuation and the country risk premium data updated each year).