← ClaudeAtlas

dcf-valuationlisted

Performs discounted cash flow (DCF) valuation analysis to estimate intrinsic value per share for Japanese listed companies. Triggers when user asks for fair value, intrinsic value, DCF, valuation, "what is X worth", price target, undervalued/overvalued analysis, or wants to compare current price to fundamental value.
rollinirenic365/dexter-jp · ★ 1 · AI & Automation · score 74
Install: claude install-skill rollinirenic365/dexter-jp
# DCF Valuation Skill (Japanese Market) ## Workflow Checklist Copy and track progress: ``` DCF Analysis Progress: - [ ] Step 1: Gather financial data - [ ] Step 2: Calculate FCF growth rate - [ ] Step 3: Estimate discount rate (WACC) - [ ] Step 4: Project future cash flows (Years 1-5 + Terminal) - [ ] Step 5: Calculate present value and fair value per share - [ ] Step 6: Run sensitivity analysis - [ ] Step 7: Validate results - [ ] Step 8: Present results with caveats ``` ## Step 1: Gather Financial Data Call the `get_financials` tool with these queries: ### 1.1 Cash Flow History **Query:** `"[TICKER] annual financial statements for the last 5 years"` **Extract:** `cfOperating` (operating cash flow), `cfInvesting`, `capex`, calculate FCF = cfOperating - capex (absolute value) ### 1.2 Financial Metrics / Key Ratios **Query:** `"[TICKER] key ratios and financial metrics"` **Extract:** `ROIC`, `financialLeverage`, `deRatio`, `operatingMargin`, `netMargin`, `dividendYield` ### 1.3 Balance Sheet **Query:** `"[TICKER] latest financial statements"` **Extract:** `totalAssets`, `netAssets`, `interestBearingDebt` (or calculate from shortTermLoans + longTermLoans + bondsPayable), `cash`, `sharesIssued` ### 1.4 Company Info **Query:** `"[TICKER] company info"` **Extract:** `industry`, `accountingStandard`, `healthScore`, `PER`, `BPS`, `EPS` ### 1.5 Current Price EDINET DB does not provide stock price data. Use the latest `PER × EPS` as a price estimate, or note that the user