ASIANMASC亜細亜男子SUBSCRIBE
UPDATED SEP 29 · 6 PIECES

Tool 道具 · Valuation lab

Build a range, not a target

Kaiju Beverage Co. (fictional): $1,000M revenue, $200M net debt. Choose three assumptions and watch the equity value move, then read what the model simplifies.

FCF margin
Perpetual growth
Discount rate
Equity value, your case
$1,690M
Next year free cash flow
$95M
Enterprise value: FCF ÷ (discount − growth)
$1,890M
Less net debt (assumed)
−$200M
Equity value
$1,690M
RANGE ACROSS THE TABLE: $718M to $4,660M · 1 UNDEFINED CELL EXCLUDED

At this margin, equity ranges from $718M to $4,660M. From your case, the result is most sensitive to growth, then discount rate, then margin. Write down which inputs deserve the range. That sentence is the deliverable.

Sensitivity: equity value ($M)
Equity value in $M by discount rate (rows) and perpetual growth (columns), at the selected FCF margin. Cells where growth reaches the discount rate are undefined.
2% growth5% growth8% growth
8% disc$1,330M$2,950Mn/a
10% disc$948M$1,690M$4,660M
12% disc$718M$1,150M$2,230M

n/a · Undefined: perpetual growth must stay below the discount rate, or the formula divides by zero or a negative number.

What this simplifies

One year of cash flow grown forever, one discount rate, net debt as the only bridge item. There is no explicit forecast, so all of the value is terminal value. A full DCF forecasts several years of cash flow, then a terminal value, then the whole bridge. The table can't fix weak assumptions: explain which inputs deserve the range.