DCF Calculator

Tutorial

Value a stock based on its free cash flow and a 10-year discounted cash flow (DCF) model.

WMT
Walmart trades at $107.44, with free cash flow of $1.70 per share, analysts' expected free cash flow growth of 7.4%, and a weighted average cost of capital (WACC) of 7.1%.

Assumptions

$
%
%
%
%
%
Value of Years 1–10
$16.41
Terminal Value (Today)
$32.64
Terminal Share of Value
66.5%
FCF per Share in Year 10
$2.92
Fair Value (Discounted Cash Flow)
$49.05 -54.3% downside
Current Price
$107.44
Analyst Target
$127.43 +18.6%
Projected free cash flow per share

Fair value by discount rate and terminal growth

Green cells are above the current price, red cells below. The outlined cell is your current assumption.

Discount Rate ↓ / Terminal Growth →
1.5%2.0%2.5%3.0%3.5%
5.1%$68.01$76.31$87.78$104.70$132.11
6.1%$52.76$57.27$63.04$70.66$81.19
7.1%$42.97$45.71$49.05$53.20$58.49
8.1%$36.16$37.95$40.06$42.58$45.65
9.1%$31.15$32.38$33.80$35.45$37.39

How the Discounted Cash Flow method works

The model projects free cash flow per share for the next 10 years using two growth rates, then assumes the cash flows keep growing at the terminal rate forever. Every year is discounted back to today at the discount rate, and the sum is the fair value. The discount rate has the biggest effect on the result, so the sensitivity table shows how the fair value moves as it changes.

Fair Value = Σ FCFₜ / (1 + r)ᵗ + Terminal Value / (1 + r)¹⁰

These models are estimates that depend entirely on your assumptions. They are provided for educational purposes only and are not investment advice. If you prefer a different valuation approach, try the Fair Value Calculator.