DCF Tool

BBW

Build A Bear Workshop Inc – Hobby, Toy, and Game Stores
build-a-bear workshop, inc., is the leading and only global company that offers an interactive retail-entertainment experience. we take pride in helping our guests mark special occasions, start new friendships, and create their own unique adventures. since 1997, millions of people have found their own meaning in one of our bears. build-a-bear currently operates more than 400 build-a-bear workshop® stores worldwide, including company-owned stores in the united states, puerto rico, canada, the united kingdom, ireland, denmark and franchise stores in europe, asia, australia, africa, the middle east, and mexico. build-a-bear empowers kids of all ages to express themselves and discover new furry friends in an exciting and fun environment. for the seventh consecutive year, we have been named to the fortune 100 best companies to work for® list.
Analysis Results
Intrinsic Value $141.87
Latest Price $28.92
Relative Value 80% undervalued
Thoughts on this result? Let us know.
Ad
Cash Flow (Millions)
Analysis Parameters
%
%
%
New Ticker
Ad
Analysis Details
Growth Rate Projection

An exponential growth model was fit to the past cash flow data, giving more weight to more recent years. This model determined a growth rate estimate of 28.9%.

Weighted Average Cost of Capital (WACC)

The calculated WACC is 9.2%. This value is used as the default discount rate.

Value of Future Flows

Assuming a growth rate of 28.9%, the cash flows for the next 5 years are projected.

The present value of each year's flow is adjusted to present value using the discount rate.

Year Future flow (million) Present value (million)
2023 69.7 63.8
2024 89.9 75.3
2025 116 88.9
2026 149 105
2027 192 124
Terminal Value

Assuming a growth rate after the projection years of 2.0%, the terminal value of the company would be 2720 million. This corresponds to a present value of 1600 million.

Intrinsic Value Per Share

The total present value of the projected cash flows is 457 million. Adding in the terminal value gives a total present value of 2060 million.

There are presently 14.5 million outstanding shares, so the intrinsic value per share is 141.87.

Financial Statements

The following data was to determine the past cash flows.

Current Assets 147,431,000
Current Cash 42,198,000
Current Liabilities 101,151,000
Current Debt 0
Non-Cash Working Capital (NCWC) 4,082,000
Change in NCWC 4,311,000
EBIT 61,943,000
Tax Provision 13,939,000
Depreciation and Amortization 12,482,000
Capital Expenditure -13,634,000
Unlevered Free Cash Flow 51,158,723
Current Assets 129,998,000
Current Cash 32,845,000
Current Liabilities 97,382,000
Current Debt 0
Non-Cash Working Capital (NCWC) -229,000
Change in NCWC 23,746,000
EBIT 50,705,000
Tax Provision 3,445,000
Depreciation and Amortization 12,276,000
Capital Expenditure -8,130,000
Unlevered Free Cash Flow 75,152,339
Current Assets 100,193,000
Current Cash 34,840,000
Current Liabilities 89,328,000
Current Debt 0
Non-Cash Working Capital (NCWC) -23,975,000
Change in NCWC -10,035,000
EBIT -12,830,000
Tax Provision 2,797,000
Depreciation and Amortization 13,292,000
Capital Expenditure -5,046,000
Unlevered Free Cash Flow -14,619,000
Current Assets 98,750,000
Current Cash 26,726,000
Current Liabilities 85,964,000
Current Debt 0
Non-Cash Working Capital (NCWC) -13,940,000
Change in NCWC -39,667,000
EBIT 1,576,000
Tax Provision 1,300,000
Depreciation and Amortization 13,705,000
Capital Expenditure -12,384,000
Unlevered Free Cash Flow -38,082,491
Current Assets 99,798,000
Current Cash 17,894,000
Current Liabilities 56,177,000
Current Debt 0
Non-Cash Working Capital (NCWC) 25,727,000
Change in NCWC 15,806,000
EBIT -13,227,000
Tax Provision -574,000
Depreciation and Amortization 16,042,000
Capital Expenditure -11,651,000
Unlevered Free Cash Flow 6,970,000
Current Assets 110,229,000
Current Cash 30,445,000
Current Liabilities 69,863,000
Current Debt 0
Non-Cash Working Capital (NCWC) 9,921,000
Change in NCWC 15,217,000
EBIT 13,824,000
Tax Provision 5,897,000
Depreciation and Amortization 16,165,000
Capital Expenditure -18,073,000
Unlevered Free Cash Flow 21,231,303
Current Assets 110,044,000
Current Cash 32,483,000
Current Liabilities 82,857,000
Current Debt 0
Non-Cash Working Capital (NCWC) -5,296,000
Change in NCWC 11,030,000
EBIT 5,314,000
Tax Provision 3,932,000
Depreciation and Amortization 16,171,000
Capital Expenditure -28,118,000
Unlevered Free Cash Flow 461,296
Current Assets 128,731,000
Current Cash 45,196,000
Current Liabilities 99,861,000
Current Debt 0
Non-Cash Working Capital (NCWC) -16,326,000
Change in NCWC 2,372,000
EBIT 17,755,000
Tax Provision -9,447,000
Depreciation and Amortization 16,419,000
Capital Expenditure -24,388,000
Unlevered Free Cash Flow 12,158,000
Current Assets 145,778,000
Current Cash 65,389,000
Current Liabilities 99,087,000
Current Debt 0
Non-Cash Working Capital (NCWC) -18,698,000
Change in NCWC -5,958,000
EBIT 16,077,000
Tax Provision 1,662,000
Depreciation and Amortization 18,128,000
Capital Expenditure -10,790,000
Unlevered Free Cash Flow 15,789,502
Current Assets 121,755,000
Current Cash 44,665,000
Current Liabilities 89,830,000
Current Debt 0
Non-Cash Working Capital (NCWC) -12,740,000
Change in NCWC 1,928,000
EBIT -2,377,000
Tax Provision -6,000
Depreciation and Amortization 19,216,000
Capital Expenditure -19,362,000
Unlevered Free Cash Flow -595,000
Current Assets 116,706,000
Current Cash 45,171,000
Current Liabilities 86,203,000
Current Debt 0
Non-Cash Working Capital (NCWC) -14,668,000
Change in NCWC -5,911,000
EBIT -14,756,000
Tax Provision 866,000
Depreciation and Amortization 21,422,000
Capital Expenditure -17,268,000
Unlevered Free Cash Flow -16,513,000

This analysis is provided for informational purposes only and does not constitute financial or investing advice. For more information on the advantages and limitations of DCF analysis see background. This information is provided on an "as is" basis. No warranty, expressed or implied, is made regarding accuracy, adequacy, completeness, legality, reliability or usefulness of any information. By using this site you agree that under no circumstances shall Valuation Tools LLC be held liable for any loss or damage caused by information obtained from this website including any articles, data, videos, its social media accounts, or any other materials.