What a share price implies
A reverse DCF runs the DCF arithmetic backwards, from today's share price to the growth rate, exit multiple or margin path that would justify it. The workbook does this with four formula cells and one grid, so it recalculates with the model and needs no goal seek. Whether the implied assumptions are believable is still your judgement.
| Line | Street case | Cell |
|---|---|---|
| Market enterprise value, which is the market value of the equity taken back to the balance sheet date, less the net cash in the bridge | €85,990m | DCF · C61 |
| Present value of the explicit UFCF, FY2026 to FY2035 | €32,985m | DCF · C21 |
| Terminal value the price requires | €127,807m | DCF · C62 |
| UFCF in FY2035, the terminal year | €8,172m | DCF · Q12 |
| EBIT in FY2035 | €10,217m | DCF · Q5 |
| WACC, euro basis | 10.27% | DCF · C22 |
| Market-implied perpetual growth | 3.6% | DCF · C63 |
| Market-implied exit EV/EBIT, FY2035 | 12.5x | DCF · C64 |
What the block says
Hold the Street case's ten years of cash flow fixed, and Spotify's $543.17 price only works if free cash flow keeps growing at 3.6% a year after 2035, where the model assumes 3.0%. Read as a multiple, the price pays 12.5x year-ten EBIT for everything beyond the forecast, against 11.3x in the model. The gap is modest, since the Street DCF sits 5.2% below the price.
The seven steps below show how the block is built, cell by cell.
How the reverse DCF is built
A forward DCF is a chain of formulas from assumptions to a value per share. A reverse DCF reads the same chain the other way. You fix the price, lock every link but one, and solve for the one you left open. Seven steps, using the Spotify workbook's own cells.
- Assumptionsg 3.0% · WACC 10.27%
- Cash flowsUFCF, FY2026 to FY2035
- Value todayEV €81,011m
- Equity€92,763m
- Per share$515.03
- Price$543.17, to compare
Start from a forward DCF that is all formulas
You need a linked forward model first. It holds ten years of unlevered free cash flow, a WACC and discount periods, a terminal method, the bridge from enterprise value to equity and a diluted share count, all as formulas. Spotify's workbook has 1,984 of them and no typed values, so anything read off it stays live when an input moves.
Turn the price into the number the model produces
The model values the operating business at the balance-sheet date, but the price is equity per share at the valuation date. So run the bridge backwards. The $543.17 price times 209.4m diluted shares is €97,830m in the model's currency. Divide by the 1.018 roll-forward to move back to 30 June 2026, then take off €10,122m of net cash. The market is paying €85,990m for the business the DCF values.
| DCF · C61 | =Inputs!$C$20/C43-C41 | €85,990m |
Choose what to hold fixed
A reverse DCF can free only one unknown, so everything else is locked. This block holds the ten forecast years fixed and releases the terminal assumption, because the usual question is what the price assumes about the long run. The ten years are worth €32,985m today. Whatever the market pays above that, €53,005m, has to be terminal value.
| DCF · C21 | =SUM(H19:Q19) | €32,985m |
Undo the discounting, then rearrange the terminal formula
The terminal value sits 9.0 years out, so gross the €53,005m up at the WACC over the model's own terminal period. That gives €127,807m. The Gordon formula, TV = UFCF2035 × (1 + g) ÷ (WACC − g), now has only g unknown, so it rearranges to 3.6%. Divided by FY2035 EBIT, the same terminal value is 12.5x. Both are single cells, which is why there is no goal seek.
Prove it by running forwards
Put 3.64% back into the forward chain and the value per share has to come out at exactly $543.17. At the model's own 3.0% it comes out at $515.03. If the round trip missed, the reverse read would be wrong. Move the slider to run the forward model at any growth rate.
| DCF · C47 | =((C21+C24/(1+C22)^C27+C41)*C43)/C45*Inputs!$C$13 | $515.03 at g = 3.0% |
When there is no formula to rearrange, sweep
Revenue growth and margin sit inside the forecast, so value is not a simple expression of them and cannot be solved backwards. Grid 3 runs the forward calculation for 25 pairs of ten-year revenue growth and terminal margin, each cell a complete simplified DCF in one formula, and shades each against the price. The reverse reading is the line between the shaded cells. The nearest cell is $547.22 at 10% growth and a 28% margin.
| Sensitivity · E34 | =((SUMPRODUCT($B$26*(1+$A34)^$B$23:$K$23*(($B$27+(E$32-$B$27)*$B$23:$K$23/10)*(1-$B$28)+$B$29)*$B$24:$K$24*(1+DCF!$C$22)^(-$B$25:$K$25))+($B$26*(1+$A34)^10*(E$32*(1-$B$28)+$B$29))*(1+DCF!$C$23)/(DCF!$C$22-DCF!$C$23)/(1+DCF!$C$22)^DCF!$Q$17+DCF!$C$41)*DCF!$C$43)/DCF!$C$45*Inputs!$C$13 | $547.22 |
Read it against the model
Implied figures mean little on their own. Against the model's own 3.0% growth and 11.3x multiple, they say the price sits modestly above the Street case, whose DCF value is 5.2% below it. Every implied number is conditional on what was held fixed, which is why the block recalculates with the model. Whether 3.6% is believable for this business is still your call.
Every cell reference opens the workbook at that cell. The bear, management and bull cases produce their own implied growth and multiple from the same formulas.
Try it on a fictional company
XMPL is a made-up company with round-number inputs. The grid runs the same formula as grid 3 on the workbook's Sensitivity tab, without the stub period and the equity bridge. Move the price, the WACC or the terminal growth and see which growth and margin pairs still clear the price.
Cells towards the lower right are worth more than the price, and cells towards the upper left less. Hover a cell to read it, click or press Enter to pin it, and use the arrow keys to move between cells.
Fixed inputs and sliders
The readout under the grid applies the market-implied block's four lines to whichever cell you pin. In the Spotify workbook the nearest cell to the price is $547.22 at 10% growth and a 28% terminal margin.
The four formulas
The market-implied block on the DCF tab reads the model's own cash flows and solves for growth by rearranging the Gordon formula. Because it is made of ordinary formulas, it recalculates whenever an input changes, in Excel and in LibreOffice.
Each line below is one cell on the DCF tab. The notes at the end of the page say why the workbook uses closed-form formulas rather than goal seek or data tables.
Modelling rules in the DCF builder
These rules are written into the builder script and its reference document, and each one can be seen at work in the Spotify workbook. Both files are in the plugin source viewer on the diligence page.
- Interest on opening balances. Interest is calculated on the balance at the start of each year, so the model has no circular reference and needs no iteration setting.
- SBC is a real cost by default. Stock-based compensation is left in as an expense. Adding it back is a toggle, and switching it on means diluting the share count for future grants by hand, because the model doesn't do that for you.
- Diluted shares by the treasury stock method. The count is basic shares, plus in-the-money options net of the shares bought back at the strike price, plus all unvested RSUs.
- Stub period, mid-year convention and roll-forward. The model uses all three so that its value can be compared like for like with today's price.
- Discount rate in the cash-flow currency. Euro cash flows use a Bund-based risk-free rate.
- The exit multiple is applied to year-ten EBIT. The exit terminal value is EBIT × EV/EBIT, 18x for Spotify. The reference document allows EV/EBITDA where D&A is large and non-cash, and EV/(EBITDA − capex) for heavy reinvesters, but neither is wired into the builder.
- Each projection row is one formula copied across the forecast columns. The builder writes formulas, not typed-in values, and each input carries a note saying where it came from.
- Grid 1's centre must equal the DCF value per share. Grid 1 runs WACC against terminal growth and grid 2 WACC against the exit multiple. The WACC axis follows the model's WACC, but the growth axis is fixed at 2% to 4% and the multiple axis at 12x to 24x, so the check holds only at 3% growth and 18x, as in Spotify's case.
The tool
- Calibrating the Street case to consensus revenue and EPS, and recording the gap to management targets
- Drafting the management, bull and bear cases as deviations from the Street case, each with a reason given
- Solving implied growth and the implied exit multiple from the price
- Building all three grids as live formulas, and checking that grid 1's centre equals the DCF value per share
You
- Judging whether the implied growth and margin are achievable for this business
- Reviewing and signing off the scenario deviations
- Checking the memo's explanation of the gap between the Street DCF and the price