Microsoft Word - Writing Guidelines for Panera Bread Case FIN 4596 Fall 2020 Guidelines for Executive Summary in Panera Bread Case The Executive Summary submission should begin with a cover page with...

1 answer below »

View more »
Answered Same DayOct 02, 2021

Answer To: Microsoft Word - Writing Guidelines for Panera Bread Case FIN 4596 Fall 2020 Guidelines for...

Sumit answered on Oct 02 2021
145 Votes
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 tosales@dardenbusinesspublishing.com. 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...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
April
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30