Panera Bread Company (SPREADSHEET)
Title Page
This spreadsheet supports STUDENT analysis of the case "Panera Bread Company" (UVA-F-1575).
This spreadsheet was prepared by Marc Lipson, Associate Professor of Business Administration. Copyright © 2009 by the University of Virginia Darden School Foundation, Charlottesville, VA. All rights reserved. For customer service inquiries, send an e-mail [email protected]. No part of this publication may be reproduced, stored in a retrieval system, posted to the Internet, or transmitted in any form or by any means—electronic, mechanical, photocopying, recording, or otherwise—without the permission of the Darden School Foundation.
Rev. Jun. 21, 2012
Exhibit 1 - Income Statement
Exhibit 1
PANERA BREAD COMPANY
Historic Income Statements
(n thousands of dollars)
Horizontal Common Size Vertical Common Size
2003 2004 2005 2006 2003 2004 2005 2006 2003 2004 2005 2006
Number of Bakery Cafés(a) 602 741 877 1,027
Revenue 363,702 479,139 640,275 828,971 1.00 1.32 1.76 2.28 100% 100% 100% 100%
Revenue growth rate 31.74% 33.63% 29.47%
Costs of Goods Sold
Bakery Café 210,822 288,706 399,760 542,916 1.00 1.37 1.90 2.58 57.97% 60.26% 62.44% 65.49%
Dough Sold to Franchisees 54,967 65,627 75,036 85,618 1.00 1.19 1.37 1.56 15.11% 13.70% 11.72% 10.33%
Depreciation 18,304 25,298 33,011 44,166 1.00 1.38 1.80 2.41 5.03% 5.28% 5.16% 5.33%
General and Administrative (b) 31,502 38,735 50,240 63,502 1.00 1.23 1.59 2.02 8.66% 8.08% 7.85% 7.66%
315,595 418,366 558,047 736,202 1.00 1.33 1.77 2.33 86.77% 87.32% 87.16% 88.81%
Growth of COGS 32.56% 33.39% 31.92%
Operating Profit (EBIT) 48,107 60,773 82,228 92,769 1.00 1.26 1.71 1.93 13.23% 12.68% 12.84% 11.19%
Operating Profit growth rate 26.33% 35.30% 12.82%
Interest Expense 48 18 50 92
Pretax Profit 48,059 60,755 82,178 92,677
Tax 17,629 22,175 29,995 33,827
Net Income 30,430 38,580 52,183 58,850 1.00 1.27 1.71 1.93
NI growth rate 26.78% 35.26% 12.78%
(a) Including both company-owned and franchised bakery cafés
(b) Includes pre-opening expenses and other expenses
Data source: Panera Bread Company annual reports, 2003–06.
Exhibit 2 - Balance Sheet
Exhibit 2
PANERA BREAD COMPANY
Historic Balance Sheets
(in thousands of dollars)
Historic Balance Sheets:
Horizontal Common Size Vertical Common Size
2003 2004 2005 2006 2003 2004 2005 2006 2003 2004 2005 2006
Cash and Short Term Investments 51,421 58,054 60,651 72,122 1.00 1.13 1.18 1.40 14.14% 12.12% 9.47% 8.70%
Accounts Receivable 12,394 17,256 25,158 30,919 1.00 1.39 2.03 2.49 3.41% 3.60% 3.93% 3.73%
Inventory 4,350 5,398 7,358 8,714 1.00 1.24 1.69 2.00 1.20% 1.13% 1.15% 1.05%
Prepaid Expenses and Deferred Taxes 3,887 3,905 9,607 15,863 1.00 1.00 2.47 4.08 1.07% 0.82% 1.50% 1.91%
Current Assets 72,052 84,613 102,774 127,618 1.00 1.17 1.43 1.77 19.81% 17.66% 16.05% 15.39%
Property, Plant and Equipment 146,362 201,725 268,809 345,977 1.00 1.38 1.84 2.36 40.24% 42.10% 41.98% 41.74%
Goodwill and Other Assets 38,421 38,334 66,084 69,014 1.00 1.00 1.72 1.80 10.56% 8.00% 10.32% 8.33%
Total Assets 256,835 324,672 437,667 542,609 1.00 1.26 1.70 2.11 70.62% 67.76% 68.36% 65.46%
Accounts Payable 8,072 5,840 4,422 5,800 1.00 0.72 0.55 0.72 2.22% 1.22% 0.69% 0.70%
Acrued Expenses and Deferred Revenue 37,571 49,865 82,443 103,810 1.00 1.33 2.19 2.76 10.33% 10.41% 12.88% 12.52%
Current Liabilities 45,643 55,705 86,865 109,610 1.00 1.22 1.90 2.40 12.55% 11.63% 13.57% 13.22%
Deferred Rent and Other Liabilities 13,616 27,604 33,824 35,333 1.00 2.03 2.48 2.59 3.74% 5.76% 5.28% 4.26%
Total Liabilities 59,259 83,309 120,689 144,943 1.00 1.41 2.04 2.45 16.29% 17.39% 18.85% 17.48%
Equity 197,576 241,363 316,978 397,666 1.00 1.22 1.60 2.01
256,835 324,672 437,667 542,609
Data source: Panera Bread Company annual reports, 2003–06.
Exhibit 3 - 2007 Forecast
Exhibit 1
PANERA BREAD COMPANY
2007 Operating Forecast(a)
(in thousands of dollars)
Number of Bakery-Cafes(b) 1,230
Revenue 1,050,000
Costs of Goods Sold
Bakery Café 738,000
Dough Sold to Franchisees 86,000
Depreciation 60,000
General and Administrative (c) 78,000
962,000
Operating Profit (EBIT) 88,000
Interest Expense 150
Pretax Profit 87,850
Tax 31,500
Net Income 56,350
Current Assets 150,000
Property, Plant, and Equipment 430,000
Goodwill and Other Assets 110,000
Total Assets 690,000
Current Liabilities 130,000
Deferred Rent and Other Liabilities 45,000
Total Liabilities 175,000
Total equity 515,000
(a) Case writer estimate based on history and third-quarter results.
(b) Including both company-owned and franchised bakery cafés
(c) Includes pre-opening expenses and other expenses
Exhibit 4 - Stock Price
Panera Stock Price and Volume
Panera Stock...