🌐 VI
← Home
📊 Valuation Tool

DCF · FCFF Valuation

Enter a ticker → instantly use the 1,500+ financial statements already on the system

Awaiting data 💡Guided 📡Market Cash Flow
§ 01

Load Financial Statement Data

Enter a ticker to load the financial statements already on the system
Getting Started — 8-Step Valuation Process
  • Step 1: Enter a ticker below to load its financial statements (or click Load Sample Data (FPT) for a quick demo).
  • Step 2: The tool auto-detects the entity type — regular company / bank / securities firm — and routes to the matching analysis view.
  • Step 3: Check §02 — historical income statement & FCFF table. Verify the figures match the original financial statements.
  • Step 4: §03 — all assumptions are auto-filled from the 3-year average. Adjust any cell with good reason (see the banner in §03).
  • Step 5: Enter the current market price in §03 to see Upside/Downside.
  • Step 6: Review §05 (DCF + FCFE), §06 (P/E), §07 (P/B) — triangulation.
  • Step 7: §08 — sensitivity heatmap.
  • Step 8: §10 — export to xlsx/JSON for record-keeping.
🔎

1,500+ HOSE · HNX · UPCOM tickers already available in the system

Enter a ticker to load its full financial statements — no Excel upload needed.

Methodology

This tool uses the international-standard FCFF approach, applicable to non-bank companies. Free cash flow is derived from EBIT rather than CFO to keep historical and projected figures consistent.

  • FCFF = EBIT(1−t) + D&A − CapEx − ΔNWC
  • EV = Σ PV(FCFF) + PV(TV)
  • TV = FCFFn+1 / (WACC − g)
  • Equity = EV + Cash − Total Liabilities − MI

📏 Analysis window: minimum 3 years — maximum 5 most recent years (standard financial-analysis practice, avoids blending periods with a different business character).

Data loaded successfully ↻ RELOAD

No data yet

Enter a ticker in §01 above to start the valuation analysis.

🛡️ Professional Credentials | 🏢 Vietcap Securities JSC | 📋 Securities Practice License: 002748/MGCK | 📋 Fund Management License: 003044/QLQ | Content is for reference only, not investment advice

DCF/FCFF Valuator User Guide

Operating manual for the multi-sector valuation workstation — Formulas · Logic · How to Adjust

§01 Tool Overview

Philosophy

The DCF/FCFF Valuator is a single-file HTML valuation tool: "FA determines WHAT to buy, Macro determines WHICH sector, TA determines WHEN to buy". The tool handles the FA layer — an engine that computes intrinsic value from financial statements.

Key Features

Routing across 3 entity types

EntityDetection SignalMethod
BankNet interest income, TOI, credit-loss provisions, customer loans...P/B Justified, RIM
Securities FirmOperating revenue, FVTPL gains, brokerage revenue, margin loans...P/B Justified, Revenue Mix
CorporateNet revenue, gross profit, operating profit, inventory...DCF, FCFE, P/E, P/B

8-Step Workflow

  1. Open DCF_FCFF_Valuator_VN-en.html in your browser
  2. Enter a ticker to load its financial statements already on the system (or click "Load sample data")
  3. The tool auto-detects the entity type and routes to the matching section
  4. Check the historicals table — verify the key figures
  5. Review/adjust the auto-filled values in the input fields
  6. Enter the current market price
  7. Read the verdict (BUY/HOLD/SELL) + sensitivity heatmap
  8. Export the report via §10

§02 Hint Pill System & Units

4 Types of Hint Pills

TypeIconMeaning
Gold hint (historical)📊Actual 3-year average from the financials. Has a ↻ Restore button
BS Snapshot📒Value from the most recent period
Gray hint (default)No historical data — shows a default value
ManualMust be entered manually — not present in the financials

Units and Formatting

5-Level Verdict Scale

VerdictUpsideAction
STRONG BUY> +20%Large position
BUY+10% to +20%Standard position
HOLD−10% to +10%Hold position
REDUCE−10% to −20%Partial profit-taking
SELL< −20%Consider exiting

§03 Loading Financials & Historicals

The system already has financial statements (sourced from VietcapIQ, 4 sheets: IS, BS, CF, Note) for 1,500+ HOSE · HNX · UPCOM tickers. Just enter a ticker in §01 to load it — no need to upload an Excel file yourself. Once loaded, the Historicals table shows the income statement and restated Free Cash Flow across multiple years.

The tool has fully standardized on the Vietcap data source to ensure data consistency — FireAnt and FiinPro are no longer supported.

EBIT Formula under VAS

EBIT = Operating Profit + |Interest Expense|

FPT 2025 example:
  Operating Profit = 12,952 bn
  Interest Expense = 810 bn
  EBIT             = 13,762 bn

Restated FCFF (Historical)

FCFF = EBIT × (1 − t) + D&A − CapEx − ΔNWC

Operating NWC (excluding Cash, ST Inv, ST Debt):
  NWC = (Current Assets − Cash − ST Inv)
      − (Current Liab − ST Debt)

§04 Model Assumptions — Auto-fill

11 Core Input Fields

Input FieldDefaultWhen to Adjust Manually
Revenue GrowthStep-down from 3-yr avgManagement has given guidance
EBIT Margin3-yr avg; fallback 18%Structural improvement/decline
Effective Tax Rate3-yr avg (capped 30%)Rarely needs changing
D&A / Revenue3-yr avg; fallback 4%Change in capex policy
CapEx / Revenue3-yr avg; fallback 5%Major investment project
ΔNWC / ΔRevenue3-yr avg; fallback 10%Significant WC change
WACC12.00%Unusually high/low risk
Terminal g4.00%Rarely needs changing (2-5%)
Cost of Equity13.50%Unusually high/low β
Effective Interest Rate3-yr avgDebt restructuring
Debt Growth Factor1.0xDeleveraging or levering up

Step-Down Growth Logic

g_base = clip(avg(rev_growth_3y), 5%, 25%)
g_terminal = terminal_g + 1.5%

for i in [0, n-1]:
    t    = i / (n-1)
    g[i] = g_base × (1-t) + g_terminal × t

FPT example (base=16.8%, term=4%):
  Y1: 16.9%, Y2: 14.9%, Y3: 13.0%
  Y4: 11.1%, Y5: 9.3%, Y6: 7.4%, Y7: 5.5%
When to override? Specific guidance available → adjust Y1. Cycle expansion → raise EBIT Margin +1-2%. Cyclical companies (real estate) → WACC 13-14%. Avoid lowering the Tax Rate below 15% unless a genuine tax incentive applies.

§05 Year-by-Year Projections

for i = 0 to N-1:
    Rev[i]   = Rev[i-1] × (1 + g[i])
    EBIT[i]  = Rev[i] × ebitMargin
    D&A[i]   = Rev[i] × daRatio
    CapEx[i] = Rev[i] × capexRatio
    ΔNWC[i]  = (Rev[i] − Rev[i-1]) × nwcRatio
    FCFF[i]  = EBIT×(1−t) + D&A − CapEx − ΔNWC
    PV[i]    = FCFF[i] / (1 + WACC)^(i+1)

§06 DCF + FCFE Valuation

FCFF Two-Stage Model

Stage 1: PV(FCFF) = Σ FCFF[t] / (1+WACC)^t
Stage 2: TV = FCFF[N] × (1+g) / (WACC−g)
         PV(TV) = TV / (1+WACC)^N
EV = Σ PV(FCFF) + PV(TV)

Equity Bridge:
  Equity = EV + Cash − Total Liabilities − MI
  Per Share = Equity / Shares × 1,000

FCFE Model

FCFE = FCFF − Interest×(1−t) + Net Borrowing
Discount rate: Re (instead of WACC)

Equity Value = Σ PV(FCFE) + PV(TV_FCFE)
Per Share = Equity Value / Shares × 1,000

FCFF vs FCFE Comparison

DifferenceInsight
< 5%✅ The two methods agree well
5-15%⚠ Check Net Borrowing and Re
> 15%🔴 Review the debtGrowthFactor

§07 P/E + P/B Cross-Check

P/E — 3 Scenarios

Forward EPS Y1 = Revenue Y1 × Net Margin / Shares
Bear:  EPS × peLow   (8x default)
Base:  EPS × peMid   (12x default)
Bull:  EPS × peHigh  (18x default)

Vietnam Sector P/E Reference

SectorBearBaseBull
Banks5x8x12x
Retail8x12x16x
Real Estate6x10x15x
Technology12x18x25x
Consumer Goods12x16x22x
VN30 Avg10x13x16x

P/B Justified (Gordon Growth)

P/B = (ROE − g) / (Re − g)
BVPS = (Equity − MI) / Shares × 1,000
Implied Price = BVPS × P/B

ROE > Re → P/B > 1 (creates value)
ROE = Re → P/B = 1 (just covers cost of capital)
ROE < Re → P/B < 1 (destroys value)

§08 Sensitivity + Kelly Position Sizing

5×5 Heatmap

Column axis: WACC ∈ [WACC-2%, ..., WACC+2%]
Row axis: Terminal g ∈ [g-1.5%, ..., g+1.5%]
Skip a cell if WACC ≤ g + 0.5%

Modified Kelly (¼ Kelly)

Edge = (mean intrinsic / current price) − 1
Risk = CV (coefficient of variation)
Kelly = (Edge / CV²) × 0.25
Cap: 0% ≤ Kelly ≤ 25% NAV

Tiers:
  Negative edge  → Do not open a long position
  < 2% NAV       → Small position
  2-5% NAV       → Small-to-medium position
  5-10% NAV      → Standard position
  10-20% NAV     → Large position
  > 20% (cap 25%)→ Maximum position
Why ¼ Kelly? Full Kelly is often too large (50-200%). ¼ Kelly cuts risk by 75% while still capturing 90% of the long-run upside. The 25% NAV cap ensures diversification.

§09 Charts & Export

FormatContentUse Case
.xlsx (7 sheets)Summary, Historicals, Assumptions, FCFF, FCFE, Valuation, SensitivityBackup, share with team
HTML ReportFull DCF report (printable)Personal report
Bank ReportP/B + RIM + CAMELSBank analysis
Securities ReportP/B + Revenue MixSecurities-firm analysis

§10 Bank Section (§B)

When a bank is detected (≥4 signals), the tool auto-routes to §B. DCF/FCFF does not apply to banks because borrowed funds are raw material for the business, not financing.

Valuation Methods

RIM Formula

for t = 1 to 10:
    fadeFactor = (t-1) / 9
    ROE[t] = ROE_initial × (1−f) + Re × f
    Residual[t] = BV[t-1] × (ROE[t] − Re)
    BV[t] = BV[t-1] × (1 + ROE[t] × 0.7)

Equity = BV[0] + Σ PV(Residual)

§B Assumptions

Input FieldDefaultReason
Re14.0%CAPM: Rf 3% + β 1.1 × ERP 10%
Terminal g5.0%≈ Vietnam nominal GDP
Sustainable ROE3-yr avgCycle-adjusted, can be overridden

§11 Securities Firm Section (§S)

A securities firm's main assets are financial assets (FVTPL, margin loans). Revenue mix: proprietary trading (volatile) + margin interest (stable) + brokerage + IB.

Revenue Quality Heuristic

Stable = Margin + Brokerage + Advisory + Custody
Volatile = FVTPL + AFS

if volatile > 50% TOI:
  ⚠ "High market dependence"
elif stable > 60% TOI:
  ✓ "Balanced revenue mix"

3 P/B Scenarios for Securities Firms

Bear: ROE × 0.80 → P/B Bear
Base: ROE × 1.00 → P/B Base
Bull: ROE × 1.25 → P/B Bull

(A wider range than banks since ROE swings 10-25%)

§12 FAQ & Best Practices

Checklist Before Trusting the Results

  1. Verify: Total Assets = Total Liabilities + Equity (difference <1 bn is OK)
  2. CFO/NI ≥ 80% consistently → good earnings quality
  3. EBIT margin swinging >50% year to year = red flag
  4. PV(TV)/EV > 75% → the model is less stable
  5. Cross-check DCF against P/E and P/B
  6. FCFF vs FCFE differing >15% → review the debtGrowthFactor
  7. Run ≥3 scenarios: Bear, Base, Bull

3 Core Principles

1. "FA tells you WHAT to buy — Macro tells you WHICH sector — TA tells you WHEN"
2. Triangulation beats any single method — always use ≥2 methods
3. Margin of Safety is non-negotiable — if DCF says 100k, buy under 80k (20% safety)

When Is the Tool NOT Suitable?

Frequently Asked Questions

"The DCF result is far from the broker's report?"
Broker reports tend to be more optimistic (higher growth, lower WACC). This tool is conservative — suited to value investing.

"The tool says BUY but the price keeps falling?"
DCF gives intrinsic value, not short-term price. You need a TA layer to time your entry.

"Kelly shows 0%?"
A negative edge means the market price is above fair value. You shouldn't go long. Wait for the price to adjust or change your assumptions.

DCF/FCFF VALUATOR — Operating Manual v03 · 2026-05-10
Methodology follows the Damodaran standard, adapted for VAS