Teuer Furniture A
Teuer Furniture’s valuation per share based on our discounted forecast cash flow methodology is $31.03. The discounted cash flow methodology is based on forecasting the free cash flows for two time periods (2013-2018) and thereafter in perpetuity.
Estimating free cash flow involves forecasting variables across the three main financial statements (Income statement, Balance Sheet and Cash flow statement). The variables are segregated by the treatment and ordered in priority of its impact on the final forecast. Sales growth at an individual cohort level (i.e – break sales by new store sales by year and old store sales by year), the rate of new store openings, and inventory assumptions have a disproportionate impact on the forecast methodology.
In particular, high inventory levels mean that higher sales growth actually hurts the Company’s free cash flow in the short run, due to the increase in net working capital, and opening too many stores too quickly can eat up all the Company’s free cash flow through the projection period.
For the following parameters we made no change to the assumptions made by Teuer’s finance team
Our share price calculation process is described below:
- Calculate individual store cohort P&Ls using above assumptions
- Calculate individual store cohort balance sheets using above assumptions
- Consolidate 1 and 2
- Derive a net income figure from the consolidated IS: NI = Sales – CGS – SG&A – Depreciation - Advertising – Tax Rate x Pretax Profit
- Derive non-cash items and cash outflows from the consolidated balance sheet and total capex from individual store cohort balance sheets
- Calculate the FCF as follows: FCF = NI – capex – ΔNWC + Depreciation
- Use the FV of the final FCF in 2019 to calculate a perpetuity value for the business assuming 12.1% cost of capital and 3.5% growth rate
- Add the perpetuity value to the FV of the final FCF
- Discount all FCFs to present value using 12.1% cost of capital
- Add all discounted values together to get value of businesses operating assets through the NPV of their future cash flows
- Subtract debt and add cash to get equity value of business. In this case, both were zero as the firm did not raise capital since 2008 and the firm’s cash flow in excess of its investments always returns to the shareholders each year in the form of dividends. so they did not impact our analysis
- Divide equity value by number of shares outstanding to get final value of $31.03 per share
Note: Sales projection is one of the most critical activities in valuing the company. We understand that given the nature of the industry, (high end furniture) it is highly sensitive to GDP growth. In an ideal scenario given resources, we would like to build a co-relation model, which would derive an elasticity metric w.r.t GDP. This would in turn give us an indexed sales number that would be more realistic. However, given our limitations, we have segmented the Sales numbers by new store sales by year (Eg: rate of growth of a new store in year 1, year 2 and so on) and used that to project for future sales.
Mitchell Petersen is the Glen Vasel Professor of Finance. He has published widely in finance and economics. Professor Petersen's research is in the area of empirical corporate finance—the questions of how firms evaluate potential investment projects and how they fund such projects. His recent writing focuses on the funding of small firms and how such funding has been altered by technology and changes in the financial (banking) market. He was awarded the Smith-Breeden Prize for Outstanding Paper in the Journal of Finance in 1995 (for his paper “The Benefits of Lending Relationships: Evidence from Small Business Data”) and the Michael Brennan Award for Best Paper in the Review of Financial Studies in 1998 (for his paper “Trade Credit: Theories and Evidence”). He was runner-up for the Brennan Award in 2008 (for his paper “Does the Source of Capital Affect Capital Structure”) and 2010 (for his paper “Estimating Standard Errors in Finance Panel Data Sets: Comparing Approaches”).
He has been a member of the editorial board of various journals, including the Journal of Finance, Financial Management, Review of Financial Studies and the Journal of Financial Intermediation. He is also a research associate with the National Bureau of Economic Research (NBER) and is a member of the Moody's Academic Advisory and Research Committee and served on the Board of Directors of L.R. Nelson. Professor Petersen was awarded the Sidney J. Levy Teaching Award in 1996, 1999, 2001, 2003, 2006, 2008, 2010, and 2012 and was voted the Kellogg Professor of the Year in 2000, the Executive MBA Outstanding Professor in 2008, 2010, and 2011, and Kellogg Alumni Professor of the Year in 2010. He received his Ph.D. in Economics from the Massachusetts Institute of Technology. Prior to joining Kellogg Professor Petersen taught at the University of Chicago.