Stockplify
Stock Valuation & DCF Calculator
Currency

Assumptions

Company
CURRENT

Current company ticker or name.

CURRENT

Use today's market price.

Affects which valuation multiple is highlighted.

ASSUMPTION

Usually 5 years.

Revenue & Margins
LTM / 2025A

Use latest actual/LTM revenue as base.

FORWARD EST.

Use forward 2026E–2027E growth or your forecast.

FORWARD EST.

Use normalized forward EBIT margin.

LTM / NORMALIZED

Use normalized effective tax rate.

CapEx & Working Capital
LTM / 2025A

Use historical/LTM average.

LTM / NORMALIZED

Use normalized capex intensity.

LTM / NORMALIZED

Use historical working capital need.

Balance Sheet
CURRENT / LATEST

Use latest balance sheet cash.

CURRENT / LATEST

Use latest total interest-bearing debt.

CURRENT / LATEST

Use latest diluted shares outstanding.

CURRENT / LATEST

Use latest book value per share.

CAPM / WACC
CURRENT

Use current Thailand 10Y government bond yield.

CURRENT

Use current Bloomberg adjusted beta.

CURRENT / ASSUMPTION

Use Thailand ERP assumption.

CURRENT / NORMALIZED

Use current or normalized borrowing cost.

LONG-TERM

Conservative long-term growth assumption. Must be below WACC.

Earnings & Multiples
LTM / 2025A

Use latest actual net income.

LTM / 2025A

Use latest dividends paid.

FORWARD EST.

Use forward 2026E EPS for P/E target pricing.

LTM / 2025A

Latest actual/LTM or 2026E for forward EV/EBITDA.

LTM / 2025A

Operating cash flow divided by diluted shares.

FORWARD EST.

Mainly for REIT/property-style valuation.

DCF Methodology Reference

Free Cash Flow

FCF = EBIT × (1 − Tax Rate)
    + D&A − CapEx − ΔNWC

NOPAT + non-cash add-back − reinvestment.

Cost of Equity (CAPM)

CoE = Risk-Free Rate
    + Beta × Equity Risk Premium

Required return given systematic risk.

WACC

WACC = (E/(D+E)) × CoE
     + (D/(D+E)) × After-Tax CoD
After-Tax CoD = Pre-Tax CoD × (1−Tax)

Weighted average of equity and debt costs.

Terminal Value

TV = Final FCF × (1 + g) / (WACC − g)
Condition: g < WACC

Gordon Growth Model beyond the forecast horizon.

Enterprise Value

EV = Σ FCFₜ/(1+WACC)^(t−0.5)
   + TV/(1+WACC)^(N−0.5)

Mid-year convention applied to all cash flows.

Equity Bridge & Upside

Equity Value = EV − Debt + Cash
Target Price = Equity Value / Shares
Upside = (Target − Price) / Price × 100

Bridge from EV to per-share intrinsic value.

Scenario Comparison

Calculate and save up to 3 scenarios to compare them here.

TickerPriceDCF PriceUpside / Down WACCTV % EVMain MultipleSignal