Valuation at a glance
Analyze a stock to see how it compares with your valuation, margin-of-safety and book-health filters.
TrendingWire separates Benjamin Graham’s published formulas from your custom workbook model, then adds asset-value screens, a user-defined margin of safety and market momentum without mixing the methodologies.
The audited build keeps the book’s published formulas, your workbook modifications, and modern technical analysis in separate modules so a user always knows what they are looking at.
Normal earnings multiplied by 8.5 plus twice expected growth. Expected growth is explicitly a forward assumption, not automatically a historical average.
V = Normal EPS × (8.5 + 2g)Your spreadsheet’s average EPS, average YoY growth and 50% growth haircut are preserved as a separate TrendingWire model instead of being attributed to Graham.
TW Value = Avg EPS × (8.5 + 50% × Avg YoY Growth)NCAV and the Graham screens are book-based. RSI and moving averages remain a separate technical layer.
NCAV = Current Assets − Total Liabilities| Item | Audited formula / rule | Status |
|---|---|---|
| Growth-stock value | Normal EPS × (8.5 + 2g) | Book formula. g is expected annual growth for the next 7–10 years. |
| Past growth | Compare average EPS of latest 3 years with corresponding 3-year average 10 years earlier | Book method; TrendingWire also annualizes it as a historical proxy. |
| 50% growth haircut | Avg YoY growth × 50% | Custom workbook assumption; not presented as Graham. |
| NCAV | (Current assets − Total liabilities) ÷ shares | Corrected. Workbook was using current liabilities in its NCA block. |
| NCAV bargain threshold | Price ≤ ⅔ × NCAV/share | Book practice; kept outside the NCAV calculation itself. |
| Defensive liquidity | Current assets ≥ 2 × current liabilities | Book rule for industrial companies. |
| Enterprising liquidity | Current assets ≥ 1.5 × current liabilities | Book rule for industrial companies. |
| NAV/share | (Total assets − Total liabilities) ÷ shares | Unit mismatch corrected. |
| NTA/share | (Assets − liabilities − goodwill − intangibles) ÷ shares | Uses tangible net assets rather than mixing crore/share units. |
| Margin of safety | User target = selected value × (1 − user MOS%) | User-controlled app tool. Book defines the principle, not one mandatory percentage. |
| Bargain % | (Value − Price) ÷ Price | Retained as workbook comparison; shown separately from MOS% of value. |