🎯 Introduction to the Core Concept
Most teams don’t struggle because they lack valuation theory. They struggle because they can’t run a consistent stock valuation analysis across a watchlist without it turning into spreadsheet sprawl. Relative valuation and intrinsic valuation are both valid. The question is when each is the right tool, and how to reconcile them when they disagree.
This cluster article is a tactical deep dive under the broader stock valuation.
Sitemap
It gives you a simple decision tree, plus a five-step workflow you can repeat. The goal is not academic precision. It’s decision-grade clarity: what assumptions matter, what outputs you trust, and what checks keep you honest.
If you want this process to be fast and auditable, it helps to run it inside a system that keeps assumptions, scenarios, and version history clean. That’s where Model Reef can support your workflow, especially when you need the same structure across multiple companies.
🧭 A Simple Framework You Can Use
Use the “Fit-For-Purpose Valuation” framework:
- Data fit: Do you have reliable inputs (peers, margins, capital structure, cash-flow drivers)?
- Method fit: Choose the method that is most defensible given the data: relative first, intrinsic first, or both in parallel.
- Assumption fit: Make assumptions explicit and test the few that drive most of the outcome (growth, margins, reinvestment, discount rate, exit multiple).
- Cross-check fit: Reconcile with a second method and sanity checks like implied multiples or implied growth.
Relative valuation usually leans on stock valuation ratios such as P/E or EV/EBITDA, which are only useful when the peer set is credible.
Sitemap
Intrinsic valuation leans on cash flows and a terminal value, which are only useful when your operating assumptions are coherent. This framework keeps you from forcing the wrong tool onto the wrong company.
🛠️ Step-by-Step Implementation
Step 1: Clarify the question and pick the primary method.
Start by writing down the decision you need to support. Is this a quick screen, a position sizing review, or an investment committee memo? That determines how deep your stock valuation model needs to go. Next, pick your primary method using a simple rule: if you can define a defensible peer group, start with relative valuation; if you can’t, start with intrinsic valuation.
Also define the valuation object. Relative valuation often anchors on enterprise value multiples. Intrinsic valuation can land on enterprise value (FCFF-style) or equity value (FCFE or dividends). This is where people mix up the company valuation formula (enterprise vs equity) and end up comparing the wrong numbers. Keep it explicit: what is being valued, and what will you divide by to get value per share?
Step 2: Build the relative valuation view (multiples) with clean peer logic.
Relative valuation is only as good as the peer set. Build a short list of comparable companies, then document why they’re comparable: revenue model, margins, growth profile, capital intensity, and risk. If you can’t explain the peer logic in two sentences, your multiple will be noise. For a practical workflow on peer selection and adjustments, see the comparable analysis guide.
Then choose the right multiple for the economics. Use EV-based multiples when leverage differs. Use earnings-based multiples when accounting is comparable and non-cash items are stable. Apply simple adjustments rather than complex “precision theatre”: normalize one-offs, align fiscal periods, and sanity-check implied growth. At this stage, treat the output as a range, not a point estimate.
Step 3: Build the intrinsic valuation view (cash-flow based) with explicit drivers.
Intrinsic valuation is where your operating story becomes math. The core stock valuation formula is: present value of forecast cash flows plus present value of terminal value, adjusted to equity value and divided by diluted shares. That sounds simple, but the work is in the drivers: revenue growth, margins, reinvestment (capex and working capital), and the discount rate.
If the business is dividend-led, a dividend discount approach can be cleaner than forcing a generic DCF. Use the dividend model when dividends are a deliberate policy and reasonably forecastable.
Keep the model “driver-first.” Avoid hard-coding. Even if you start in a spreadsheet, structure it so you can update assumptions quickly after earnings without rebuilding the logic. That’s the difference between a one-off calculation and a repeatable stock valuation analysis process.
Step 4: Reconcile the two methods using a decision tree and “why” diagnostics.
When relative and intrinsic differ, don’t average them. Diagnose the gap. Start with three questions:
- Is the peer set implicitly pricing something your intrinsic model doesn’t capture (cycle timing, risk, optionality)?
- Are you embedding aggressive assumptions (growth, margins, terminal multiple) that the market is not paying for?
- Is capital structure, dilution, or one-off normalization driving the difference?
This is where “bull/base/bear” thinking becomes practical, not theoretical. Build three assumption sets and see which variable actually moves value. If you want a template-driven approach to scenario valuation, use the bull/base/bear workflow.
Sitemap
Also pressure-test any “one-number” tool outputs. Many teams get misled by a stock valuation calculator that hides assumptions or embeds default inputs that don’t fit the company.
Step 5: Operationalise the workflow: scenarios, version control, and update cadence.
To make this repeatable, standardise three things: (1) your input set, (2) your assumption layer, and (3) your output pack. Run scenarios on the assumptions that matter most, then keep a simple “changes since last update” log. In practice, the biggest upgrade you can make is moving from a static file to a workflow where scenarios and assumptions are governed. Model Reef’s scenario tooling is designed for that kind of iteration, so you can compare cases without duplicating workbooks.
Sitemap
Finally, define a cadence. For liquid names, update after earnings and major guidance changes. For long-horizon names, update quarterly but revisit key drivers monthly. The goal is not constant modelling. It’s controlled updates that preserve context, so your stock valuation model stays decision-ready.
🧩 Real-World Examples
A small investment team runs coverage on 25 mid-cap stocks. They start with relative valuation to screen names quickly, using a consistent peer template. For the five names that pass the screen, they build intrinsic models to understand the cash-flow story and identify what the market is pricing incorrectly.
Where it used to break down was upkeep. Earnings season meant rebuilding spreadsheets, re-checking links, and arguing about which version was “current.” They moved to a structured workflow where fundamentals can be pulled in and mapped consistently across names, and scenarios can be compared without duplicating models. For teams using ticker-based inputs, the “Stock Ticker to Model” workflow is a practical starting point.
The result is faster updates, cleaner review cycles, and fewer valuation debates driven by spreadsheet mechanics instead of assumptions.
✅ Next Steps
If you’ve built the decision tree and run both methods once, the next move is to turn it into a workflow you can reuse. Start by choosing a standard template: one relative valuation page, one intrinsic valuation page, and one reconciliation page with sensitivities and checks. Then apply it to three companies in the same sector to pressure-test your peer logic and assumptions.
For teams who want to publish valuation outputs consistently, the “Valuation and DCF Outputs” walkthrough is a helpful next step.