Stock Valuation Model — DCF, Comparable Multiples & DDM with Automatic Over/Undervaluation Verdict (Excel)

Valuation methods included
• Discounted Cash Flow (DCF) — two-stage model with explicit free-cash-flow projection, Gordon terminal value, WACC discounting, and a clean bridge from Enterprise Value to equity value per share.
• Relative valuation (Multiples) — implied price from peer P/E, EV/EBITDA and P/B, with net-debt adjustment.
• Dividend Discount Model (DDM) — Gordon Growth for dividend-paying names, with built-in handling of the Ke ≤ g edge case.

Output
A weighted fair value across the three methods, the percentage gap versus market price (margin of safety), and an automatic traffic-light verdict: undervalued / fairly valued / overvalued.
• Inputs are fully separated from calculations. Only the input cells are editable; all formulas and sheets are password-protected to prevent accidental breakage.
• Adjustable weights let you tailor the blend to the company profile (e.g. zero-weight the DDM for low-yield names).
• A dedicated instructions sheet documents every assumption and where to source it.
. Ships with Apple as example included