BNCM - JM L Uhlnygkf
BNCM - JM L Uhlnygkf
BNCM - JM L Uhlnygkf
Section - A
Group 4
©2015 by the Kellogg School of Management at Northwestern University. This case was prepared by
Professor Mitchell A. Petersen. Teuer Furniture is a fictional company whose profile was created based on
data from real industry leaders. Cases are developed solely as the basis for class discussion. Cases are not
intended to serve as endorsements, sources of primary data, or illustrations of effective or ineffective
management. To order copies or request permission to reproduce materials, call 800-545-7685 (or 617-783-
7600 outside the United States or Canada) or e-mail custserv@hbsp.harvard.edu. No part of this publication
may be reproduced, stored in a retrieval system, used in a spreadsheet, or transmitted in any form or by any
means—electronic, mechanical, photocopying, recording, or otherwise—without the permission of Kellogg
Case Publishing.
low Valuation, Case
as prepared by
as created based on
cussion. Cases are not
e or ineffective
545-7685 (or 617-783-
part of this publication
d in any form or by any
ermission of Kellogg
Exhibit 1: Teuer Furnitures Showrooms and Square Footage
763655
764480 1290960
48900
40 700,000
35 600,000
30
500,000
25
400,000
20
300,000
15
200,000
10
5 100,000
0 0
2003 2005 2007 2009 2011 2013 2015
Number of Showrooms Total Square Feet
Exhibit 2: Economic Indicators: GDP and Furniture Sales Growth
2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019
CPI index 180.9 184.3 190.3 196.8 201.8 210.0 210.2 215.9 219.2 225.7 229.6 233.5 237.7 242.3 247.4 252.1 256.6 261.3
Inflation (CPI) 1.9% 3.3% 3.4% 2.5% 4.1% 0.1% 2.7% 1.5% 3.0% 1.7% 1.7% 1.8% 1.9% 2.1% 1.9% 1.8% 1.8%
GDP (T$) 10,642 11,142 11,853 12,623 13,377 14,029 14,292 13,974 14,499 15,076 15,685 16,238 17,049 18,012 19,021 20,078 21,101
GDP growth 4.7% 6.4% 6.5% 6.0% 4.9% 1.9% -2.2% 3.8% 4.0% 4.0% 3.5% 5.0% 5.6% 5.6% 5.6% 5.1%
Furniture sales ($B) 94.44 96.7 103.8 109.1 112.8 111.1 99.6 86.3 87.3 90.1 93.1 95.9 98.6 101.2 103.6 105.9 108.0 110.2
Furniture sales growth 2.4% 7.3% 5.2% 3.4% -1.5% -10.4% -13.4% 1.2% 3.2% 3.4% 3.0% 2.8% 2.6% 2.4% 2.2% 2.0% 2.0%
10.0%
5.0%
0.0%
2003 2005 2007 2009 2011 2013 2015 2017
-5.0%
-10.0%
-15.0%
Parameters:
Corporate tax rate 40%
Sales Growth 406.44% 156.37% 93.03% 53.65% 14.51% 22.91% 20.32% 10.53%
Exhibit 4: Teuer Furniture Balance Sheet
2003 2004 2005 2006 2007 2008 2009 2010 2011 2012
Assets
Accounts Receivable 0 751 3,479 8,675 16,946 25,272 29,059 36,625 42,421 48,200
Inventory 671 3,151 8,216 15,125 20,908 21,715 24,868 26,808 29,216 33,343
Total Current Assets 671 3,902 11,695 23,800 37,853 46,987 53,927 63,433 71,637 81,543
PPE 358 1,461 2,969 5,270 8,065 6,914 5,119 3,839 3,142 3,920
Total Assets 1,029 5,364 14,663 29,070 45,918 53,900 59,046 67,272 74,779 85,463
Parameters:
Lease rate (2013) 20.88
Lease inflation 2.0%
Exhibit 6: Teuer Furniture Balance Sheet for Individual Showrooms
# Avg Size 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018
2003 1 17,200 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Cap expenditure 358 324
Accts receivable 751 1,187 1,665 1,975 2,040 1,700 1,745 1,742 1,902 2,020 2,083 2,144 2,203 2,259 2,311
Inventory 671 1,090 1,330 1,206 1,167 980 972 1,082 1,027 1,090 1,216 1,251 1,285 1,318 1,349 1,380
Accts payable 236 396 448 405 403 350 345 370 369 390 416 428 440 451 462 473
Accr expenses 29 49 62 61 61 53 54 57 58 58 64 66 68 70 71 73
PPE 260 195 130 65 0
2004 3 17,600 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Cap expenditure 1,175 936
Accts receivable 2,292 3,870 5,029 5,526 5,276 5,599 5,612 5,691 5,982 9,064 9,329 9,584 9,826 10,055
Inventory 2,061 3,590 4,304 3,352 2,851 3,042 3,248 3,397 3,619 3,598 3,704 3,805 3,901 3,992 4,085
Accts payable 762 1,255 1,421 1,124 1,025 1,090 1,124 1,139 1,153 1,232 1,268 1,303 1,336 1,367 1,399
Accr expenses 95 158 193 173 162 162 175 177 179 190 196 201 206 211 216
936 748 561 374 187 0
2005 4 18,500 0 1 2 3 4 5 6 7 8 9 10 11 12 13
Cap expenditure 1,814 1,506
Accts receivable 3,140 5,508 6,296 6,231 7,149 7,751 7,950 8,202 8,459 8,707 8,944 9,170 9,384
Inventory 3,296 5,271 4,640 3,975 4,075 4,427 4,354 5,114 4,934 5,078 5,217 5,349 5,473 5,600
Accts payable 1,078 1,760 1,742 1,381 1,523 1,572 1,565 1,631 1,689 1,739 1,786 1,832 1,874 1,918
Accr expenses 138 212 240 203 240 244 251 259 261 268 276 283 289 296
1,506 1,205 904 603 301 0
2006 5 21,100 0 1 2 3 4 5 6 7 8 9 10 11 12
Cap expenditure 2,971 2,450
Accts receivable 4,433 6,593 7,974 10,040 10,908 11,761 11,659 12,024 12,376 12,713 13,035 13,338
Inventory 4,344 6,518 6,635 5,870 6,689 6,854 6,348 7,013 7,218 7,415 7,603 7,779 7,960
Accts payable 1,533 2,227 2,181 1,889 2,165 2,325 2,377 2,401 2,472 2,539 2,603 2,664 2,726
Accr expenses 193 272 300 291 337 343 362 371 381 392 402 411 421
2,450 1,960 1,470 980 490
2007 6 22,100 0 1 2 3 4 5 6 7 8 9 10 11
Cap expenditure 4,058 3,277
Accts receivable 4,817 6,829 9,849 12,400 13,920 14,756 15,217 15,663 16,091 16,497 16,881
Inventory 5,232 6,246 8,710 7,320 8,121 9,022 8,876 9,135 9,385 9,622 9,846 10,075
Accts payable 1,732 2,480 2,712 2,631 2,712 2,919 3,039 3,128 3,214 3,295 3,372 3,450
Accr expenses 213 293 362 381 436 435 469 483 496 508 520 532
3,277 2,622 1,966 1,311
2008 2 15,500 0 1 2 3 4 5 6 7 8 9 10
Cap expenditure 924 761
Accts receivable 1,048 1,758 2,212 2,905 3,389 3,538 3,642 3,741 3,836 3,925
Inventory 1,028 1,711 2,147 1,727 1,911 2,064 2,124 2,182 2,237 2,289 2,343
Accts payable 349 547 662 586 690 707 727 747 766 784 802
Accr expenses 43 72 88 94 101 109 112 115 118 121 124
924 739 554 370 185 0 761 609 457
2009 1 14,500 0 1 2 3 4 5 6 7 8 9
Cap expenditure 394 322
Accts receivable 484 840 1,191 1,452 1,638 1,706 1,753 1,797 1,839
Inventory 488 882 881 823 955 995 1,022 1,048 1,073 1,097
Accts payable 171 261 327 281 327 341 350 359 367 376
Accr expenses 21 34 43 44 50 53 54 55 57 58
394 315 236 158 79 0 322 258
2010 2 14,700 0 1 2 3 4 5 6 7 8
Cap expenditure 752 616
Accts receivable 956 1,787 2,361 2,983 3,358 3,492 3,580 3,664
Inventory 1,013 1,787 1,913 1,740 1,959 2,037 2,088 2,137 2,186
Accts payable 348 577 683 596 671 697 715 732 749
Accr expenses 44 71 91 92 103 108 110 113 116
752 602 451 301 150 0 616
2011 2 15,400 0 1 2 3 4 5 6 7
Cap expenditure 798
Accts receivable 1,093 1,905 2,614 3,296 3,703 3,844 3,933
Inventory 1,067 1,795 2,158 1,923 2,160 2,242 2,294 2,347
Accts payable 387 623 739 658 740 768 786 804
Accr expenses 47 76 99 102 114 118 121 124
798 638 479 319 160 0
2012 3 16,300 0 1 2 3 4 5 6
Cap expenditure 1,293
Accts receivable 1,743 3,049 4,177 5,256 5,894 6,105
Inventory 1,708 2,854 3,448 3,066 3,438 3,561 3,643
Accts payable 617 977 1,181 1,050 1,177 1,219 1,248
Accr expenses 79 123 158 162 182 188 192
1,293 1,034 776 517 259 0
2013 2 16,000 0 1 2 3 4 5
Cap expenditure 860
Accts receivable 1,174 2,050 2,802 3,519 3,938
Inventory 1,918 2,313 2,053 2,297 2,379
Accts payable 657 792 703 787 815
Accr expenses 83 106 108 121 126
860 688 516 344 172 0
2014 2 16,000 0 1 2 3 4
Cap expenditure 876
Accts receivable 1,209 2,107 2,875 3,604
Inventory 1,229 1,677 2,102 2,352
Accts payable 421 574 720 805
Accr expenses 114 147 145 163
876 701 526 350 175
2015 2 15,000 0 1 2 3
Cap expenditure 837
Accts receivable 1,165 2,027 2,760
Inventory 1,182 1,610 2,018
Accts payable 405 551 691
Accr expenses 73 97 103
837 670 502 335
Exhibit 7: Teuer Furniture Cash Flow Assets
2003 2004 2005 2006 2007 2008 2009
Sales 2,057 10,415 26,701 51,540 79,191 90,680
- Costs -2,582 -12,003 -29,394 -53,144 -77,591 -84,510
- Taxes 0 0 0 0 0 -543
Net income 0 -526 -1,588 -2,693 -1,604 1,600 5,626
- Capital expenditure -358 -1,175 -1,814 -2,971 -4,058 -924 -394
+ Depreciation 0 72 307 669 1,264 2,075 2,188
- Increase in NWC -406 -2,193 -5,957 -9,467 -11,645 -8,498 -6,281
Cash flow to assets -764 -3,823 -9,052 -14,461 -16,043 -5,747 1,139
0.8466941 1.1630737
Exhibit 8: Forecasting Sales Revenue and Costs
Year 1 2 3 4 5 6 7 8
Sales growth 2003 73.6% 34.6% 19.5% 15.1% 0.2% 1.2% 1.0%
2004 72.9% 29.2% 21.4% 8.1% 3.6% 3.4% 0.0%
2005 76.6% 32.6% 22.2% 7.8% 3.7% -3.1%
2006 73.8% 28.8% 24.4% 11.3% -1.3%
2007 64.5% 36.8% 26.1% 6.3%
2008 60.5% 35.6% 23.6%
2009 69.0% 36.6%
2010 70.4%
2011
Average 70.2% 33.5% 22.9% 9.7% 1.5% 0.3%
Year 1 2 3 4 5 6 7 8
CGS 2003 71.1% 61.5% 57.8% 38.9% 43.4% 42.0% 38.9% 36.6%
2004 71.3% 62.4% 52.1% 43.8% 39.0% 41.2% 38.7% 40.2%
2005 72.9% 65.6% 57.8% 40.6% 41.1% 40.3% 36.9%
2006 70.1% 53.1% 57.6% 33.3% 38.9% 40.0%
2007 72.6% 67.3% 53.9% 38.4% 41.0%
2008 64.4% 67.0% 61.0% 40.7%
2009 71.0% 65.9% 53.3%
2010 74.0% 66.5%
2011 70.3%
Average 70.9% 63.7% 56.2% 39.7% 39.9% 39.5% 38.6%
Year 1 2 3 4 5 6 7 8
SGA 2003 19.9% 17.1% 16.4% 13.9% 12.9% 13.9% 13.6% 11.7%
2004 17.6% 18.0% 17.4% 14.1% 14.5% 13.7% 13.9% 13.0%
2005 20.4% 17.9% 17.0% 14.5% 13.2% 13.2% 15.1%
2006 20.4% 19.0% 18.0% 12.7% 14.4% 14.2%
2007 19.8% 17.6% 18.0% 13.0% 13.6%
2008 16.4% 18.4% 16.9% 13.4%
2009 17.9% 19.2% 17.4%
2010 20.7% 19.4%
2011 20.9%
Average 19.3% 18.3% 17.3% 13.6% 13.6% 13.5% 13.4%
Year 1 2 3 4 5 6 7 8
Advertising 2003 9.9% 8.9% 7.6% 7.1% 6.7% 7.7% 6.9% 6.8%
2004 10.3% 8.2% 8.3% 7.4% 8.0% 7.7% 7.2% 7.2%
2005 10.9% 8.9% 8.0% 7.6% 7.0% 6.7% 7.3%
2006 10.3% 8.4% 8.3% 6.8% 6.8% 6.6%
2007 10.2% 9.0% 8.1% 6.9% 7.1%
2008 10.2% 9.6% 8.3% 7.3%
2009 11.0% 9.1% 8.6%
2010 11.7% 8.9%
2011 10.7%
Average 10.6% 8.9% 8.2% 7.2%
9
-0.6%
9
40.0%
9
13.1%
9
7.6%
Exhibit 9: Forecasting Investment
Year 1 2 3 4 5 6 7 8
Accounts Receivable 2003 36.5% 31.6% 31.9% 32.1% 32.2% 30.9% 31.0% 29.7%
2004 34.4% 32.5% 33.2% 33.5% 34.2% 34.6% 32.5% 31.9%
2005 32.8% 33.1% 31.8% 29.7% 31.3% 31.7% 32.4%
2006 32.6% 31.2% 33.8% 33.8% 32.0% 33.8%
2007 31.2% 31.0% 32.3% 31.3% 32.0%
2008 32.9% 34.0% 30.5% 31.4%
2009 33.7% 33.5% 33.6%
2010 31.8% 33.7%
2011 32.6%
Average 32.4%
Year 1 2 3 4 5 6 7 8
Inventory 2003 45.9% 47.2% 44.0% 50.4% 42.4% 42.4% 44.3% 50.3%
2004 43.4% 48.3% 54.5% 46.4% 47.3% 45.6% 48.5% 47.3%
2005 47.2% 48.3% 40.6% 46.8% 43.4% 44.9% 48.2%
2006 45.6% 58.0% 48.8% 59.3% 50.4% 49.2%
2007 46.7% 42.2% 53.0% 48.1% 45.5%
2008 50.1% 49.4% 48.6% 45.9%
2009 47.8% 53.4% 46.7%
2010 45.5% 50.7%
2011 45.3%
Average 47.6%
Year 1 2 3 4 5 6 7 8
Accounts Payable 2003 16.1% 17.2% 14.8% 16.9% 14.6% 15.2% 15.7% 17.2%
2004 16.1% 16.9% 18.0% 15.6% 17.0% 16.3% 16.8% 15.9%
2005 15.4% 16.1% 15.2% 16.2% 16.2% 15.9% 17.3%
2006 16.1% 19.8% 16.0% 19.1% 16.3% 16.7%
2007 15.5% 16.8% 16.5% 17.3% 15.2%
2008 17.0% 15.8% 15.0% 15.6%
2009 16.8% 15.8% 17.3%
2010 15.6% 16.4%
2011 16.4%
Average 16.3%
Year 1 2 3 4 5 6 7 8
Accrued Expenses 2003 4.7% 5.1% 4.9% 4.7% 4.9% 4.5% 4.6% 5.2%
2004 5.1% 5.1% 4.9% 4.9% 4.7% 4.7% 4.8% 4.9%
2005 4.6% 4.7% 4.8% 4.4% 5.2% 5.0% 4.6%
2006 4.6% 4.7% 4.8% 5.0% 4.7% 4.7%
2007 4.6% 5.0% 4.6% 4.8% 4.8%
2008 5.1% 5.0% 4.8% 4.9%
2009 5.2% 4.8% 4.7%
2010 4.5% 4.7%
2011 4.4%
Average 4.8%
Nominal Real
Construction costs 2003 20.8 25.9
2004 22.3 26.8
2005 24.5 28.6
2006 28.2 32.0
2007 30.6 33.5
2008 29.8 32.6
2009 27.2 28.9
2010 25.6 26.8
2011 25.9 26.4
2012 26.4 26.4
2013 26.9 26.4
2014 27.4 26.4
2015 27.9 26.4
Nominal Real
Refresh cost 2003 90.6% 74.0%
2004 79.6% 66.0%
Average 70.0%
9
31.5%
9
42.5%
9
15.3%
9
4.7%
Exhibit 10: Forecasting Parameters
1 2 3 4 5 6 7
Sales growth 70.2% 33.5% 22.9% 9.7% 1.5% 0.3%
CGS (% sales) 70.9% 63.7% 56.2% 39.7% 39.7% 39.7% 39.7%
SGA (% sales, excluding dep & advertising) 19.3% 18.3% 17.3% 13.6% 13.6% 13.6% 13.6%
Advertising (% sales) 10.6% 8.9% 8.2% 7.2% 7.2% 7.2% 7.2%
Accounts Receivable (% sales) 32.4%
Inventory (% next year's CGS) 47.6%
Accounts Payable (% next year's CGS) 16.3%
Accrued expenses (next year's SGA adv) 4.8%
Depreciation (years) 5
Refresh cost 70.0%
Corporate tax rate 40.0%
Corporate expenses 5.0%
Discount rate 12.1%
Long-term growth rate 3.5%
Shares outstanding (K) 9,945
Teuer Furniture Pro Forma Income Statement
2012 2013 2014 2015 2016 2017 2018 2019
Sales 148,218 165,028 181,941 199,623 217,575 231,545 242,363 251,183
CGS -61,955 69,809 76,952 83,512 87,805 91,925 96,219 99,721
SGA (exc adv & dep) -21,253 23,296 25,691 28,136 30,421 32,112 33,277 34,161
Advertising -10,744 12,238 13,464 15,061 16,596 17,674 18,247 18,882
Depreciation -1,450 1,084 1,373 1,959 2,631 2,559 2,178 1,828
Lease (stores) -9,320 10,719 11,915 12,724 13,497 13,825 14,267 14,516
Corp Expense (inc lease/adv) -7,411 8,251 9,097 9,981 10,879 11,577 12,118 12,559
Tax calculation -14,434
Tax loss carry forwards 0
Taxes -14,434 15,852 17,380 19,300 22,298 24,749 26,423 27,807
Net income 21,651 23,778 26,069 28,950 33,447 37,124 39,634 41,710
Parameters:
Corporate tax rate 40%
Corporate expenses 5%
Teuer Furniture Pro Forma Balance Sheet
2012 2013 2014 2015 2016 2017 2018
Assets
Accounts Receivable 48,200 53,469 61,843 67,657 73,555 78,158 81,736
Inventory 33,343 35,407 38,754 41,116 43,756 45,800 47,467
Total Current Assets 81,543 88,876 100,597 108,772 117,311 123,959 129,203
Cash (balance) 0 17,226 29,982 49,198 76,905 110,055 146,624
PPE 3,920 5,203 7,155 9,310 7,440 5,203 3,641
Total Assets 85,463 111,305 137,734 167,281 201,656 239,216 279,469