Build a simple DCF model
Imagine buying a bakery. How much would you pay today for the cash it could earn in the future? Follow one fictional business from the cost of flour to the value of a single share.
Download the Excel modelWACC 10% · g 2%
Find the cash the business can generate
Start with operating profit in the income statement. Our bakery earns PLN 160 thousand before interest and tax. An assumed 25% tax leaves 120. Add back 20 for depreciation, because wear on the oven reduced accounting profit. Subtract 30 spent on equipment and 10 tied up in extra stock and receivables after supplier credit. That leaves 100 thousand for lenders and owners together. This is free cash flow to the firm (FCFF).
Free cash flow · PLN thousands
- Operating profit (EBIT)
- 160
- Tax rate (25%)
- -40
- Depreciation
- +20
- Capital expenditure
- -30
- Increase in working capital
- -10
- FCFF
- 100
Forecast five years and bring the money back to today
Assume cash left after investment grows 5% each year. That gives 105 thousand in year one. Each payment arrives at year-end. The discount rate (WACC) blends the cost of borrowing with the return owners require. At 10%, PLN 110 received a year from now is worth PLN 100 today. Divide by 1.10 once more for each extra year.
Try your own assumptions
Raise WACC by one percentage point and watch the value per share. Then change only growth after year five. Which change makes the bigger difference? The table and chart recalculate with each adjustment.
| Year | Free cash flow | Value today |
|---|---|---|
| 1 | 105 | 95.45 |
| 2 | 110.25 | 91.12 |
| 3 | 115.76 | 86.97 |
| 4 | 121.55 | 83.02 |
| 5 | 127.63 | 79.25 |
Include the years beyond the forecast
The oven will still be working in year six. Choose a modest long-run growth rate, g, that the business can sustain after paying for investment. It must stay below WACC. Divide year-six cash by WACC minus g to find the value of the remaining business at the end of year five. Discount that value back to today as well.
Include the years beyond the forecast · PLN thousands
- FCFF₆
- 130.18
- Continuing value at the end of year 5
- 1,627.26
- Continuing value in today’s money
- 1,010.4
Go from the whole bakery to one share
Add the present value of the five payments to the present value of the remaining business. To find the owners’ portion, add PLN 50 thousand in surplus cash and subtract PLN 200 thousand of debt. Divide by 10 thousand shares. The result is an estimate that depends on your assumptions.
- Years 1–5 in today’s money435.81 · 30.1%
- Continuing value in today’s money1,010.4 · 69.9%
- Value of operations · PLN thousands
- 1,446.21
- Surplus cash · PLN thousands
- +50
- Interest-bearing debt · PLN thousands
- -200
- Equity value · PLN thousands
- 1,296.21
- Shares (thousands)
- 10
- Value per share
- PLN 129.62
In your own spreadsheet, find depreciation and equipment purchases in the cash flow statement, and cash and debt on the balance sheet. Use one currency, consistent inflation assumptions and matching periods. WACC already reflects interest costs, so leave interest out of FCFF.
What do a real bakery’s accounts show?
The UK bakery chain Greggs reports sales and capital spending for each financial year. For every £100 of sales, it invested about £11 in 2023 and over £13 in 2025. When forecasting growth, ask how much cash new ovens, shops and equipment will absorb. These Greggs figures are a separate historical example.
| Year | Sales | Capital expenditure | Investment as % of sales |
|---|---|---|---|
| 2023 | 1,809.6 | 199.8 | 11% |
| 2024 | 2,014.4 | 249 | 12.4% |
| 2025 | 2,151.2 | 287.5 | 13.4% |
