Building an Integrated Forecast-to-Value Model

From Operating Forecast to Value

A valuation model is a chain of linked assumptions, not a collection of unrelated formulas. Revenue and operating costs determine operating profit; taxes and reinvestment determine the cash flow available to investors; discounting converts future cash flows to present value; and financing claims determine how much of enterprise value belongs to common shareholders. Errors often occur when one link uses a different basis from another—for example, discounting shareholder cash flow at a rate intended for all capital providers.

This tutorial develops that chain using free cash flow to the firm (FCFF). FCFF is calculated before payments to lenders and shareholders, so it is used to value the operating enterprise. The value of common equity is then found by adjusting enterprise value for debt, excess cash, and other claims that rank ahead of common equity.

Definition: Enterprise value (EV) is the present value of the cash flows generated by a firm's operating assets, before payments to debt and equity investors. Common equity value is the portion of value attributable to common shareholders after accounting for debt and other senior claims, and adding excess cash not included in the operating forecast.

Turning an Operating Forecast into FCFF

The operating forecast supplies earnings, but accounting earnings are not the same as cash flow. Depreciation reduces accounting profit without being a current cash payment, so it is added back. Capital expenditure is a cash outflow that may not appear as an expense immediately, so it is subtracted. An increase in net working capital ties up cash in operations and is also subtracted; a decrease releases cash.

For a standard unlevered forecast, let EBIT be earnings before interest and taxes, let $T$ be the corporate tax rate, let $D\&A$ denote depreciation and amortization, and let $\Delta NWC$ be the change in net working capital during the period. Assuming operating taxes are calculated on EBIT, with no tax losses or unusual tax adjustments, the period's FCFF is:

FCFF = EBIT(1-T) + D\&A - Capital\ Expenditures - \Delta NWC.

This is an unlevered cash flow: interest expense is not subtracted. The point is to measure cash generated by operations before deciding how much goes to lenders and how much to shareholders. If interest were subtracted while the discount rate also reflected debt and equity financing, financing could be counted twice.

Model consistency: FCFF is discounted at a required return appropriate for the operating assets and all capital providers. A common choice is WACC when its assumptions fit the valuation. With market-value weights and a stable target financing mix, one conventional expression is $WACC = \frac{E}{D+E}k_e + \frac{D}{D+E}k_d(1-T)$, where $E$ and $D$ are market values of equity and debt, and $k_e$ and $k_d$ are their required returns. The discount rate must match the risk and currency of the cash flows; this expression is not automatically appropriate for every project or changing financing policy.

The forecast horizon is usually finite, while a continuing business may produce cash flow beyond it. If FCFF in year $n+1$ is expected to grow at a constant rate $g$ forever, the terminal value at the end of year $n$ is:

TV_n = \frac{FCFF_{n+1}}{r-g}, \qquad r>g,

where $r$ is the discount rate used for FCFF. The strict condition $r>g$ is essential: without it, the perpetuity does not have a finite value. The constant-growth formula also assumes a stable long-run business with sustainable cash-flow growth and reinvestment, not a high-growth forecast that continues unchanged forever.

Why the Continuing-Value Formula Holds

At the end of year $n$, the continuing value is the value of FCFF received in years $n+1,n+2,\ldots$. If the first continuing cash flow is $C=FCFF_{n+1}$, and each later cash flow grows by $g$, the value at that date is the infinite series:

TV_n = \frac{C}{1+r} + \frac{C(1+g)}{(1+r)^2} + \frac{C(1+g)^2}{(1+r)^3}+\cdots.

This is a geometric series whose first term is $C/(1+r)$ and whose common ratio is $(1+g)/(1+r)$. Because $r>g$, that ratio is less than one, and the series converges. Its sum is:

TV_n = \frac{C/(1+r)}{1-(1+g)/(1+r)} = \frac{C}{r-g} = \frac{FCFF_{n+1}}{r-g}.

The formula gives a value at the end of year $n$, not at the valuation date. It must therefore be discounted by $(1+r)^n$ when calculating enterprise value today.

A Consistent Valuation Sequence

A practical model can be built in a fixed order. Keeping the steps separate makes it easier to locate errors and to check whether operating and financing items have been treated consistently.

Forecast operating performance.
Project revenue, operating costs, and EBIT for each explicit forecast year. State the relevant assumptions, such as growth rates and operating margins.

Calculate FCFF.
Apply operating taxes to EBIT, add back noncash depreciation and amortization, then subtract capital expenditure and the increase in net working capital.

Estimate continuing value.
Use a defensible long-run growth assumption and the next year's FCFF. Confirm that the discount rate exceeds the growth rate.

Discount to the valuation date.
Discount each forecast FCFF for its own year and discount terminal value from the end of the final forecast year.

Bridge enterprise value to equity value.
Subtract debt and other senior claims, and add excess cash that is outside the operating cash flows.

Enterprise-value equation: If $n$ years of FCFF are forecast explicitly, then $EV=\sum_{t=1}^{n}\frac{FCFF_t}{(1+r)^t}+\frac{TV_n}{(1+r)^n}$. A basic equity bridge is $Equity\ value=EV-Debt-Other\ senior\ claims+Excess\ cash$, using values measured on a consistent date and basis.

Worked Valuation Examples

Worked Example: From Three Years of Operations to Equity Value

A hypothetical firm forecasts revenue of $500 million in year 1, $550 million in year 2, and $605 million in year 3. EBIT is 20% of revenue. The tax rate is 25%; depreciation and amortization, capital expenditure, and the increase in net working capital are respectively 4%, 6%, and 1% of revenue in each year. Use a 10% annual discount rate and a 2% perpetual FCFF growth rate after year 3. At the valuation date, debt is worth $180 million, excess cash is $25 million, and preferred claims are worth $10 million. Calculate EV and common equity value.

Method. First calculate FCFF for each forecast year. Then calculate the terminal value at the end of year 3, discount all amounts, and make the financing-claim adjustment. All amounts below are in millions of dollars.

Year 1. EBIT is $0.20(500)=100$. After-tax EBIT is $100(1-0.25)=75$. Depreciation and amortization are $0.04(500)=20$, capital expenditure is $0.06(500)=30$, and the increase in working capital is $0.01(500)=5$. Thus $FCFF_1=75+20-30-5=60$.

Year 2. EBIT is $0.20(550)=110$, so after-tax EBIT is $110(0.75)=82.5$. The other amounts are $D\&A=22$, capital expenditure $=33$, and $\Delta NWC=5.5$. Therefore $FCFF_2=82.5+22-33-5.5=66$.

Year 3. EBIT is $0.20(605)=121$, and after-tax EBIT is $121(0.75)=90.75$. The other amounts are $D\&A=24.2$, capital expenditure $=36.3$, and $\Delta NWC=6.05$. Therefore $FCFF_3=90.75+24.2-36.3-6.05=72.6$.

The first continuing cash flow is $FCFF_4=72.6(1.02)=74.052$. The end-of-year-3 terminal value is $TV_3=74.052/(0.10-0.02)=925.65$. The year-3 cash flow plus terminal value is $72.6+925.65=998.25$.

Discount the cash flows using their actual dates: $FCFF_1/1.10=60/1.10=54.545455$; $FCFF_2/1.10^2=66/1.21=54.545455$; and $(FCFF_3+TV_3)/1.10^3=998.25/1.331=750$. Thus $EV=54.545455+54.545455+750=859.090909$ million.

Finally, common equity value is $859.090909-180+25-10=694.090909$ million. To the nearest cent, EV is $859.09 million and common equity value is $694.09 million. The check is that debt and preferred claims reduce common equity value, while excess cash increases it.

Common mistake avoided: The terminal value is first calculated at the end of year 3 and then discounted for three years. Adding the terminal value to year-3 FCFF before discounting gives the same correct timing; treating the terminal value as already being at the valuation date would overstate EV.

Worked Example: Correctly Timing a Two-Year Terminal Value

A hypothetical service company forecasts year-1 EBIT of $200,000 and year-2 EBIT of $240,000. In each year, depreciation is 15% of EBIT, capital expenditure is 25% of EBIT, and the increase in net working capital is 5% of EBIT. The tax rate is 25%. After year 2, FCFF grows at 4% annually forever. Use a 10% discount rate. Debt is worth $600,000, excess cash is $90,000, and there are no other senior claims. Find EV and common equity value.

Method. Derive each forecast FCFF, use year-3 FCFF for the terminal-value numerator, and discount the terminal value two years. All calculations are in dollars.

Year 1 after-tax EBIT is $200{,}000(0.75)=150{,}000$. Depreciation is $30{,}000$, capital expenditure is $50{,}000$, and the increase in working capital is $10{,}000$. Therefore $FCFF_1=150{,}000+30{,}000-50{,}000-10{,}000=120{,}000$.

Year 2 after-tax EBIT is $240{,}000(0.75)=180{,}000$. Depreciation is $36{,}000$, capital expenditure is $60{,}000$, and the increase in working capital is $12{,}000$. Therefore $FCFF_2=180{,}000+36{,}000-60{,}000-12{,}000=144{,}000$.

Year-3 FCFF is $144{,}000(1.04)=149{,}760$. The terminal value at the end of year 2 is $TV_2=149{,}760/(0.10-0.04)=2{,}496{,}000$. Consequently, $EV=120{,}000/1.10+(144{,}000+2{,}496{,}000)/1.10^2$. The first present value is $109{,}090.909$, and the second is $2{,}640{,}000/1.21=2{,}181{,}818.182$. Thus EV is $2{,}290{,}909.091$.

Common equity value is $2{,}290{,}909.091-600{,}000+90{,}000=1{,}780{,}909.091$. To the nearest cent, EV is $2,290,909.09 and common equity value is $1,780,909.09. The result is greater than debt because the operating enterprise is also supported by equity value and excess cash.

Common mistake avoided: Using year-2 FCFF of $144,000 as the numerator would give a terminal value of $2,400,000, understating the correct value by $96,000 at the end of year 2, or $96{,}000/1.21=$79{,}338.84$ at the valuation date. The perpetuity formula uses the next cash flow, year 3.

Worked Example: Forecasting from Operating Ratios

A hypothetical manufacturer had prior-year revenue of $360 million and forecasts revenue of $400 million in year 1 and $440 million in year 2. EBIT is 15% of revenue, depreciation is 5% of revenue, and capital expenditure is 7% of revenue. Net working capital rises by 2% of the increase in revenue from the preceding year. The tax rate is 30%. Assume FCFF grows at 2% per year after year 2, and use an 8% discount rate. Debt is worth $140 million, excess cash is $18 million, and preferred claims are worth $5 million. Calculate EV and common equity value.

Method. Apply the forecast ratios carefully, noting that working capital is based on the change in revenue rather than total revenue. Then value the continuing cash flows and bridge to common equity.

For year 1, EBIT is $0.15(400)=60$, and after-tax EBIT is $60(0.70)=42$. Depreciation is $0.05(400)=20$, and capital expenditure is $0.07(400)=28$. Revenue increases by $400-360=40$, so $\Delta NWC=0.02(40)=0.8$. Hence $FCFF_1=42+20-28-0.8=33.2$ million.

For year 2, EBIT is $0.15(440)=66$, and after-tax EBIT is $66(0.70)=46.2$. Depreciation is $0.05(440)=22$, and capital expenditure is $0.07(440)=30.8$. Revenue increases by $440-400=40$, so $\Delta NWC=0.8$. Hence $FCFF_2=46.2+22-30.8-0.8=36.6$ million.

Year-3 FCFF is $36.6(1.02)=37.332$ million, so $TV_2=37.332/(0.08-0.02)=622.2$ million. The year-1 present value is $33.2/1.08=30.740741$ million. The year-2 FCFF plus terminal value is $36.6+622.2=658.8$ million, with present value $658.8/1.1664=564.814815$ million. Therefore $EV=30.740741+564.814815=595.555556$ million.

Common equity value is $595.555556-140+18-5=468.555556$ million. To the nearest cent, EV is $595.56 million and common equity value is $468.56 million. The working-capital calculation is checked against the stated 2% of the $40 million revenue increase in each forecast year.

Common mistake avoided: Applying 2% to total year-1 or year-2 revenue would not follow the stated assumption. The model specifies 2% of incremental revenue, so the working-capital investment is $0.8 million in each year.

Interpreting the Model and Avoiding Traps

An integrated model is useful because it makes the economic source of value visible. Operating margins affect after-tax operating profit; depreciation, capital expenditure, and working capital determine how much of that profit becomes cash; and the discount rate reflects the risk and timing of that cash. The equity bridge then separates the value of operations from the distribution of claims on those operations.

The bridge should use market values of debt and other claims when valuing equity, rather than automatically using accounting book values. Cash should be added only if it is excess to the operating requirements already captured in the forecast. If required operating cash is embedded in working capital, adding it again as excess cash would double count it. Similarly, do not subtract debt in the FCFF calculation and then subtract it again in the equity bridge.

Mixing cash-flow and discount-rate bases. FCFF is before financing payments, so it should not be discounted using a rate intended only for shareholders.
Using the wrong terminal year. A terminal value at the end of year $n$ uses FCFF in year $n+1$ in its numerator and is discounted by $(1+r)^n$.
Ignoring reinvestment. Growth is not free: the continuing-growth assumption must be compatible with the capital expenditure and working capital needed to sustain it.
Adding cash twice. Separate excess cash from cash required to support operating activity.
Using an invalid growth spread. If $r\leq g$, the constant-growth perpetuity formula does not produce a finite, economically usable value.

Key takeaway: A defensible forecast-to-value model preserves one consistent basis from start to finish: operating earnings become unlevered cash flow after taxes and reinvestment; forecast cash flows and continuing value are discounted at a rate consistent with their risk; and financing claims are handled in the equity bridge rather than mixed into operating cash flow.

Check Your Understanding

For each problem, keep the cash-flow timing and the stated operating or financing basis explicit.

A firm has EBIT of $80,000, a 25% tax rate, depreciation of $12,000, capital expenditure of $20,000, and an increase in net working capital of $4,000. Calculate FCFF for the year. (Answer: $48,000)
A firm expects FCFF of $50,000 in year 1 and $60,000 in year 2, with no cash flows after year 2. At a 10% annual discount rate, calculate the present value of these forecast cash flows. (Answer: $95,041.32)
At the end of year 3, a business expects year-4 FCFF of $103,000. If the discount rate is 9% and perpetual growth is 3%, calculate the terminal value at the end of year 3. (Answer: $1,716,666.67)
A firm's EV is $700 million. Its debt is worth $160 million, excess cash is $25 million, and preferred claims are worth $15 million. Calculate common equity value. (Answer: $550 million)
A firm forecasts FCFF of $40 million in year 1 and $44 million in year 2. After year 2, FCFF grows at 2% forever. At a 10% discount rate, calculate EV. (Answer: $536.36 million)

What You'll Learn