Fundamental valuation workspace

Stock Valuation & Fair Value Lab

Translate operating assumptions into enterprise value, equity value, and a per-share fair-value range using a transparent five-year discounted cash-flow model.

Editable illustrative inputs are loaded. Verify every figure before relying on the model.

Base fair value / share - -
Enterprise value - Base scenario
Equity value - After cash and debt
Terminal value weight -

Base-case forecast

Revenue and free cash flow

RevenueFree cash flow

Assumption sensitivity

Fair value per share matrix

Rows vary WACC; columns vary terminal growth.

How this valuation works

The model forecasts unlevered free cash flow for five years, discounts each year at the selected weighted average cost of capital, estimates a perpetual terminal value, then adds cash, subtracts debt, and divides by diluted shares. Small changes in long-term assumptions can materially change fair value; use the scenario range and matrix instead of treating one output as precise.

Decision guide

Use valuation as an assumption audit, not a precise price target

The decision it supports

Test what revenue growth, margins, reinvestment, discount rate, and terminal growth would need to be true for a range of equity values. The bear, base, and bull cases make disagreement visible instead of hiding it in one output.

Worked example

Load a company, verify every baseline against its filings, and run the base case. Then raise the discount rate by one percentage point and reduce year-five margin by two points. If value changes sharply, the thesis is highly sensitive and needs a wider margin of safety.

Method

The model projects five years of operating results, estimates after-tax operating profit and reinvestment, discounts free cash flow to present value, and adds a discounted terminal value. Cash is added, debt is subtracted, and equity value is divided by diluted shares.

Assumptions and limitations
  • Loaded figures may be delayed, normalized differently, or incomplete. Verify them against current company filings.
  • Terminal value can dominate the result and is especially sensitive when terminal growth approaches the discount rate.
  • The model does not fully represent dilution, leases, pensions, cyclicality, currency, regulation, or unusual capital structures.
  • Fair value is a conditional range, not a promise that the market will trade there.
Common mistakes to avoid
  • Using management targets as facts without testing a weaker case.
  • Combining nominal cash flows with a real discount rate, or mixing currencies and units.
  • Ignoring share-based compensation, net debt, and future dilution.
  • Changing several assumptions to force the output near the current market price.

Continue learning: Evidence-led research · Valuation terms

Verify the baseline: Find the company filings in SEC EDGAR. Match the reporting period, currency, diluted share count and cash flow definitions before entering figures. A filing supplies evidence, not a fair value guarantee.

Print a free planning worksheet to keep the assumptions, outputs and review questions together. No account or payment is required; worksheet entries are not sent to Market Master.

From inputs to a decision

Work through the calculation in context

Method in practice

Reproduce a valuation before relying on a range.

An illustrative company, explicit units and a sensitivity check you can verify in the calculator.

A baseline you can reproduce

Use a fictional company with $1,000 million revenue, a constant 20% operating margin, a 25% cash tax rate, depreciation of 2% of revenue, capital spending of 6% and working capital investment of 1%. Set revenue growth to zero and year-five margin to 20%. These inputs produce $100 million of annual unlevered free cash flow: 200 × (1 − 0.25) + 20 − 60 − 10.

Assume $200 million cash, $150 million debt and 20 million diluted shares. At a 10% discount rate and 2% perpetual growth, the first five cash flows have a combined present value of approximately $379.08 million. The year-six cash flow is $102 million. Divide it by 10% − 2% to obtain a $1,275 million terminal value at the end of year five.

Discount the terminal value too

Discount $1,275 million by 1.10⁵ to obtain about $791.67 million today. Adding the explicit cash flows gives $1,170.75 million enterprise value. Add cash, subtract debt and divide by shares: (1,170.75 + 200 − 150) ÷ 20 = about $61.04 per share. All amounts except the per-share result are in millions.

About 67.62% of enterprise value comes from the terminal component. Increase only the discount rate to 11% and the modeled share value falls to about $54.61. Keep the rate at 10% but raise terminal growth to 3% and it rises to about $67.14. These are sensitivities, not predicted prices or confidence bounds.

Check the inputs before comparing values

This example holds margins and annual cash flows constant to make the calculation reproducible. Real businesses have cycles, investment needs, dilution and accounting differences. Reconcile every input to a dated filing and use consistent currency, units and share counts.

Perpetual growth must remain below the discount rate. A mathematically valid spread can still produce an economically implausible terminal value. If distant assumptions dominate the result, widen the scenarios and investigate their basis rather than treating extra decimal places as precision.