Using an unlevered Free Cash Flow to Firm (FCFF) model, we project Molson Coors Beverage Company's cash flows over 10 years with analyst estimates for the first 3–5 years, fading toward long-term GDP growth for the remaining years with line-by-line expense modeling. Revenue is projected revenue growing from -0.1% to 2.8% annually, with expenses (COGS, SG&A, R&D) held at historical ratios. Depreciation is computed from a vintage matrix based on a 5-year useful life. Working capital is modeled using historical turnover days (DSO 28, DPO 104, DIO 41). At a 5.5% WACC with mid-year discounting, the terminal value (74% of enterprise value) is derived by applying the industry peer median EV/EBITDA multiple of 19.0x to Year 11 EBITDA. After subtracting net debt, the equity value implies a fair price of $171.71 per share, suggesting TAP is undervalued by 310.2% at the current price of $41.86.
Adjust parameters to explore scenarios. Changes are for exploration only and do not affect saved valuations.
| 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | Terminal | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Profit Before Tax | 1,300 | 1,301 | 1,309 | 1,317 | 1,349 | 1,379 | 1,411 | 1,447 | 1,486 | 1,528 | 1,566 |
| (−) Net Interest | 248 | 248 | 250 | 251 | 257 | 263 | 269 | 276 | 283 | 292 | 299 |
| (+) D&A | 649 | 675 | 673 | 670 | 667 | 659 | 667 | 678 | 692 | 709 | 726 |
| EBITDA | 2,197 | 2,225 | 2,232 | 2,238 | 2,274 | 2,301 | 2,348 | 2,401 | 2,461 | 2,528 | 2,591 |
| (−) Tax | 283 | 283 | 285 | 286 | 293 | 300 | 307 | 315 | 323 | 332 | — |
| (−) CapEx | 651 | 652 | 656 | 660 | 676 | 691 | 707 | 725 | 744 | 765 | — |
| (−) ΔWC | 57 | -0 | -2 | -2 | -9 | -8 | -9 | -9 | -10 | -11 | — |
| Free Cash Flow (FCF) | 1,206 | 1,290 | 1,294 | 1,294 | 1,313 | 1,318 | 1,342 | 1,371 | 1,404 | 1,442 | — |
| Peers' EBITDA Multiple | 19.0x | ||||||||||
| Terminal Value | 49,231 | ||||||||||
| WACC / Discount Rate | 5.50% | ||||||||||
| Timing of FCF (mid year) | 0.5 | 1.5 | 2.5 | 3.5 | 4.5 | 5.5 | 6.5 | 7.5 | 8.5 | 9.5 | 5 |
| Present Value of FCF | 1,175 | 1,191 | 1,131 | 1,073 | 1,032 | 982 | 948 | 917 | 890 | 867 | 28,808 |
| Enterprise Value | 39,013 | ||||||||||
| Projection Period | 10,205 | 26.2% | |||||||||
| Terminal Value | 28,808 | 73.8% | |||||||||
| (−) Current Net Debt | 5,403 | ||||||||||
| Equity Value | 33,610 | ||||||||||
| (÷) Outstanding Shares | 196M | ||||||||||
| Fair Price | $172 | +310.3% | |||||||||
| WACC \ EV/EBITDA Exit Multiple | 15.0x | 17.0x | 19.0x | 21.0x | 23.0x |
|---|---|---|---|---|---|
| 3.5% | $170 | $189 | $208 | $227 | $245 |
| 4.5% | $155 | $172 | $189 | $206 | $223 |
| 5.5% | $141 | $156 | $172 | $187 | $203 |
| 6.5% | $128 | $142 | $156 | $170 | $184 |
| 7.5% | $117 | $129 | $142 | $155 | $168 |
Current price: $41.86. Green = undervalued, Red = overvalued.
Based on default parameters
This is an unlevered Free Cash Flow to Firm (FCFF) model with a 10-year projection period. Revenue is projected using analyst consensus estimates for the first 3–5 years, then gradually fading toward long-term GDP growth (~3%) for the remaining years. Expenses, D&A, and working capital follow the same line-by-line approach as the 5-year variant. The terminal value is calculated by applying the industry peer median EV/EBITDA multiple to the projected Year 11 EBITDA.
The longer 10-year horizon reduces the weight of the terminal value in the total enterprise value, making the model less sensitive to the exit multiple assumption. This approach combines the advantages of detailed FCFF modeling with a market-anchored exit, providing a more robust valuation for companies where long-term fundamentals are expected to converge toward industry norms. The sensitivity matrix shows how fair value changes across different WACC and EV/EBITDA multiple scenarios.