Using an unlevered Free Cash Flow to Firm (FCFF) model, we project Best Buy Co., Inc.'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.2% to 1.6% 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 9, DPO 56, DIO 55). At a 7.3% WACC with mid-year discounting, the terminal value (58% of enterprise value) is derived from the Gordon Growth Model on Year 11 FCFF at a 2.5% perpetual rate. After subtracting net debt, the equity value implies a fair price of $117.03 per share, suggesting BBY is undervalued by 85.9% at the current price of $62.97.
Adjust parameters to explore scenarios. Changes are for exploration only and do not affect saved valuations.
| 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | Terminal | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Profit Before Tax | 1,870 | 1,897 | 1,932 | 1,956 | 1,989 | 1,912 | 1,864 | 1,843 | 1,847 | 1,877 | 1,924 |
| (−) Net Interest | 40 | 41 | 41 | 42 | 43 | 41 | 40 | 39 | 40 | 40 | 41 |
| (+) D&A | 774 | 772 | 732 | 723 | 733 | 746 | 749 | 746 | 740 | 731 | 749 |
| EBITDA | 2,684 | 2,709 | 2,705 | 2,721 | 2,764 | 2,699 | 2,653 | 2,629 | 2,626 | 2,649 | 2,715 |
| (−) Tax | 432 | 439 | 447 | 452 | 460 | 442 | 431 | 426 | 427 | 434 | 445 |
| (−) CapEx | 723 | 733 | 747 | 756 | 769 | 739 | 721 | 712 | 714 | 726 | 744 |
| (−) ΔWC | -587 | 14 | 17 | 12 | 17 | -39 | -24 | -11 | 2 | 15 | 15 |
| Free Cash Flow (FCFF) | 2,116 | 1,523 | 1,494 | 1,500 | 1,519 | 1,556 | 1,525 | 1,501 | 1,483 | 1,473 | 1,510 |
| Terminal Value | 31,777 | ||||||||||
| WACC / Discount Rate | 7.3% | ||||||||||
| Long-term Growth Rate | 2.5% | ||||||||||
| 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 | 2,043 | 1,371 | 1,254 | 1,174 | 1,108 | 1,059 | 968 | 888 | 818 | 758 | 15,777 |
| Enterprise Value | 27,217 | ||||||||||
| Projection Period | 11,439 | 42.0% | |||||||||
| Terminal Value | 15,777 | 58.0% | |||||||||
| (−) Current Net Debt | 2,395 | ||||||||||
| Equity Value | 24,822 | ||||||||||
| (/) Outstanding Shares | 212 | ||||||||||
| Fair Price | $117.03 | ||||||||||
| WACC \ Terminal Growth Rate | 1.5% | 2.0% | 2.5% | 3.0% | 3.5% |
|---|---|---|---|---|---|
| 5.3% | $161 | $178 | $202 | $237 | $291 |
| 6.3% | $127 | $136 | $148 | $164 | $186 |
| 7.3% | $104 | $110 | $117 | $126 | $137 |
| 8.3% | $88 | $92 | $97 | $102 | $108 |
| 9.3% | $77 | $79 | $82 | $86 | $90 |
Current price: $62.97. Green = undervalued, Red = overvalued.
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 (COGS, SG&A, R&D, Interest) are modeled as individual line items based on historical ratios. Depreciation is calculated from a vintage matrix that tracks each year's CapEx depreciated straight-line over its useful life. Working capital is projected using historical turnover days (DSO, DPO, DIO).
The longer 10-year horizon reduces the weight of the terminal value in the total enterprise value, making the model less sensitive to terminal growth assumptions. FCFF equals EBITDA minus taxes, capital expenditure, and change in net working capital. The terminal value is calculated using the Gordon Growth Model on the Year 11 FCFF. Cash flows are discounted at the Weighted Average Cost of Capital (WACC) using mid-year convention. Enterprise value is converted to equity value by subtracting net debt (total debt minus cash).