← L3VLUP Labs
Free · no sign-up

DCF Builder

A discounted cash flow valuation, built the way it is built at a desk: forecast the cash the business throws off, put a value on everything after the forecast, discount it all back to today, walk from enterprise value to equity, and divide by the shares. Six steps, each checked as you go, with room for the rounding that hand arithmetic needs.

The forward companion to the Reverse DCF. That lab starts from a share price and asks what growth it assumes; this one starts from the drivers and ends at a price, then puts it next to the market’s.

Project Aster
present values, stacking into EV
Check step 1 and the cash flows appear here.Y1Y2Y3Y4Y5TVEVEquity$m · end-of-year discounting at 9.0%
PV of each yearPV of terminal valueEnterprise valueEquity valueBefore discounting
0 of 6 steps checked
Project Aster
the drivers you are given
Revenue, year 0
$500m
Revenue growth
8% a year
EBITDA margin
25%
D&A
4% of revenue
Tax rate
25%
Capex
5% of revenue
Working capital
15% of Δ revenue
WACC
9.0%
Terminal growth
2.5%
Exit multiple
9.0x EBITDA
Bridge and shares
Debt
$150m
Cash
$50m
Minorities
$20m
Investments
$40m
Basic shares
50m
Options
3m at $15
Share price
$24.00

Work down in order. Each step checks against the arithmetic with about 3% of room, because you are compounding and discounting by hand and the rounding adds up.

1

Forecast unlevered free cash flow

Start from revenue and walk down to the cash the whole business generates before anyone who funds it is paid: EBIT after tax, add back D&A, take off capex and the working capital that growth ties up.

2

Value everything after year 5

Five years of forecast, then one number for the rest of time. Two ways to get it, and they should roughly agree.

3

Discount to today

A dollar in year 5 is worth less than a dollar now. Each cash flow is divided by (1 + WACC) raised to its year, end-of-year convention.

4

Enterprise value

Add the two, then ask how much of the answer is the forecast and how much is the assumption about forever.

5

From enterprise value to equity value

EV belongs to everyone who funds the business. Take out the claims that rank ahead of shareholders, add back what the company owns outside the operations.

6

Implied share price

Divide by every share that would exist if the in-the-money options were exercised, then put the answer next to where the shares trade.

You have built a price from a growth rate. The Reverse DCF runs it the other way: now read the market’s growth off a price, and decide whether the company can clear it.Open it The discount rate was handed to you here. The WACC Builder makes you earn it: beta, equity risk premium and cost of debt, each from a source you can name.Build one