dcf-valuationlisted
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