OPEN-SOURCE SCRIPT

Intrinsic Value Analyzer

166
The Intrinsic Value Analyzer is an all-in-one valuation tool that automatically calculates the fair value of a stock using industry-standard valuation techniques. It estimates intrinsic value through Discounted Cash Flow (DCF), Enterprise Value to Revenue (EV/REV), Enterprise Value to EBITDA (EV/EBITDA), and Price to Earnings (P/EPS). The model features adjustable parameters and a built-in alert system that notifies investors in real time when valuation multiples reach predefined thresholds. It also includes a comprehensive, color-coded table that compares the company’s historical average growth rates, valuation multiples, and financial ratios with the most recent values, helping investors quickly assess how current values align with historical averages.

The model calculates the historical Compounded Annual Growth Rates (CAGR) and average valuation multiples over the selected Lookback Period. It then projects Revenue, Earnings Before Interest, Taxes, Depreciation, and Amortization (EBITDA), Earnings per Share (EPS), and Free Cash Flow (FCF) for the selected Forecast Period and discounts their future values back to the present using the Weighted Average Cost of Capital (WACC) or the Cost of Equity. By default, the model automatically applies the historical averages displayed in the table as the growth forecasts and target multiples. These assumptions can be modified in the menu by entering custom REV-G, EBITDA-G, EPS-G, and FCF-G growth forecasts, as well as EV/REV, EV/EBITDA, and P/EPS target multiples. When new input values are entered, the model recalculates the fair value in real time, allowing users to see how changes in these assumptions affect the company’s fair value.

  • DCF = (Sum of (FCF × (1 + FCF-G) ^ t ÷ (1 + WACC) ^ t) for each year t until Forecast Period + ((FCF × (1 + FCF-G) ^ Forecast Period × (1 + LT Growth)) ÷ ((WACC - LT Growth) × (1 + WACC) ^ Forecast Period)) + Cash - Debt - Preferred Equity - Minority Interest) ÷ Shares Outstanding
  • EV/REV = ((Revenue × (1 + REV-G) ^ Forecast Period × EV/REV Target) ÷ (1 + WACC) ^ Forecast Period + Cash - Debt - Preferred Equity - Minority Interest) ÷ Shares Outstanding
  • EV/EBITDA = ((EBITDA × (1 + EBITDA-G) ^ Forecast Period × EV/EBITDA Target) ÷ (1 + WACC) ^ Forecast Period + Cash - Debt - Preferred Equity - Minority Interest) ÷ Shares Outstanding
  • P/EPS = (EPS × (1 + EPS-G) ^ Forecast Period × P/EPS Target) ÷ (1 + Cost of Equity) ^ Forecast Period

The discounted one-year average analyst price target (1Y PT) is also displayed alongside the valuation labels to provide an overview of consensus estimates. For the DCF model, the terminal long-term FCF growth rate (LT Growth) is based on the selected country to reflect expected long-term nominal GDP growth and can be modified in the menu. For metrics involving FCF, users can choose between reported FCF, calculated as Cash From Operations (CFO) - Capital Expenditures (CAPEX), or standardized FCF, calculated as Earnings Before Interest and Taxes (EBIT) × (1 - Average Tax Rate) + Depreciation and Amortization - Change in Net Working Capital - CAPEX. Historical average values displayed in the left column of the table are based on Fiscal Year (FY) data, while the latest values in the right column use the most recent Trailing Twelve Month (TTM) or Fiscal Quarter (FQ) data. The indicator displays color-coded price labels for each fair value estimate, showing the percentage upside or downside from the current price. Green indicates undervaluation, while red indicates overvaluation. The table follows a separate color logic:

  • REV-G, EBITDA-G, EPS-G, FCF-G = Green indicates positive annual growth when the CAGR is positive. Red indicates negative annual growth when the CAGR is negative.
  • EV/REV = Green indicates undervaluation when EV/REV ÷ REV-G is below 1. Red indicates overvaluation when EV/REV ÷ REV-G is above 2. Gray indicates fair value.
  • EV/EBITDA = Green indicates undervaluation when EV/EBITDA ÷ EBITDA-G is below 1. Red indicates overvaluation when EV/EBITDA ÷ EBITDA-G is above 2. Gray indicates fair value.
  • P/EPS = Green indicates undervaluation when P/EPS ÷ EPS-G is below 1. Red indicates overvaluation when P/EPS ÷ EPS-G is above 2. Gray indicates fair value.
  • EBITDA% = Green indicates profitable operations when the EBITDA margin is positive. Red indicates unprofitable operations when the EBITDA margin is negative.
  • FCF% = Green indicates strong cash conversion when FCF/EBITDA > 50%. Red indicates unsustainable FCF when FCF/EBITDA is negative. Gray indicates normal cash conversion.
  • ROIC = Green indicates value creation when ROIC > WACC. Red indicates value destruction when ROIC is negative. Gray indicates positive but insufficient returns.
  • ND/EBITDA = Green indicates low leverage when ND/EBITDA is below 1. Red indicates high leverage when ND/EBITDA is above 3. Gray indicates moderate leverage.
  • YIELD = Green indicates positive shareholder return when Shareholder Yield > 1%. Red indicates negative shareholder return when Shareholder Yield < -1%.

The Return on Invested Capital (ROIC) is calculated as EBIT × (1 - Average Tax Rate) ÷ (Average Debt + Average Equity - Average Cash). Shareholder Yield (YIELD) is calculated as the CAGR of Dividend Yield - Change in Shares Outstanding. The Weighted Average Cost of Capital (WACC) is displayed at the top left of the table and is derived from the current Market Cap (MC), Debt, Cost of Equity, and Cost of Debt. The Cost of Equity is calculated using the Equity Beta, Index Return, and Risk-Free Rate, which are based on the selected country. The Equity Beta (β) is calculated as the 5-year Blume-adjusted beta between the weekly logarithmic returns of the underlying stock and the selected country’s stock market index. For accurate calculations, it is recommended to use the stock ticker listed on the primary exchange corresponding to the company’s main index.

  • Cost of Debt = (Interest Expense on Debt ÷ Average Debt) × (1 - Average Tax Rate)
  • Cost of Equity = Risk-Free Rate + Equity Beta (β) × (Index Return - Risk-Free Rate)
  • WACC = (MC ÷ (MC + Debt)) × Cost of Equity + (Debt ÷ (MC + Debt)) × Cost of Debt

This indicator works best for operationally stable and profitable companies that are primarily valued based on fundamentals rather than speculative growth, such as those in the industrial, consumer, technology, and healthcare sectors. It is less suitable for early-stage, unprofitable, or highly cyclical companies, including energy, real estate, and financial institutions, as these often have irregular cash flows or distorted balance sheets. It is also worth noting that TradingView’s financial data provider, FactSet, standardizes financial data from official company filings to align with a consistent accounting framework. While this improves comparability across companies, industries, and countries, it may also result in differences from officially reported figures.

In summary, the Intrinsic Value Analyzer is a comprehensive valuation tool designed to help long-term investors estimate a company’s fair value while comparing historical averages with the latest values. Fair value estimates are driven by growth forecasts, target multiples, and discount rates, and should always be interpreted within the context of the underlying assumptions. By default, the model applies historical averages and current discount rates, which may not accurately reflect future conditions. Investors are therefore encouraged to adjust inputs in the menu to better understand how changes in these key assumptions influence the company’s fair value.

Aviso legal

As informações e publicações não devem ser e não constituem conselhos ou recomendações financeiras, de investimento, de negociação ou de qualquer outro tipo, fornecidas ou endossadas pela TradingView. Leia mais em Termos de uso.