Executive summary

FIN 4596 Spring 2018

Guidelines for forecasting work in Panera Bread Case

The Panera Bread Company case analysis (done individually) focuses on forecasting financial

statements using the Percent of Sales approach for a firm that will almost surely need significant

external financing for the first time in its recent corporate history.

Address each of the following:

1. Complete the financing portion of the Panera Bread Company's 2007 forecast financial

statements, and provide a forecast for the next five years (2008-2012). A worksheet has been

provided for this purpose. Assume all borrowings are some form of debt and that interest expense

equals 6% of the outstanding debt. You may also assume the $75 million share repurchase occurs

in 2008 as planned. Assume sales growth of 25% for the first two years after 2007 and 5%

thereafter. Note that you need not provide a detailed forecast of the current asset and current

liability accounts.

The Excel spreadsheet must have the following format:

All of your assumptions about growth rates and percent of sales, etc. must be listed in the

upper left-hand corner.

Those assumptions must then be LINKED to the forecasts in the financial statements. For

example, if cell B5 contains an assumed sales growth rate of .25, the 2008 sales forecast in

your income statement should show "sales 2007 * (1+ B5)" behind the figure reflected in

the 2008 Sales cell.

2. Given the need for external sources of capital, please also briefly discuss (without adjusting

your actual forecasts) the pros and cons of using

a) a public issue of debt,

b) a bank term loan, and

c) a bank revolving line of credit.

You are encouraged to do outside research to address this second question, but please limit your

response to a well-crafted, clear half-page of qualitative analysis that focuses on the key

differences between using each of these three forms of financing.

The submission should begin with a one-page Executive Summary that contains a cover

page with your name, the title (that specifies the type of document, the name of the company, and

the financial issue explores), and the man body with the key issue(s) at hand and your

recommended solution to that problem(s). This document is directed at Panera Bread senior

management, so do not review background known to them. Remember to focus and to be as

clear and concise as possible in describing the problem, the results, and the solution; the goal is to

help Panera Bread senior managers make a more informed decision moving forward.

You may add up to two pages of more detailed analysis of the points raised in your

executive summary. Remember those additional analyses are there for reference only, if the reader

would like to confirm or further explore your main points in the summary.

The document should be double-spaced with 12 font using normal margins; please insert

page numbers and use subheadings as needed for clarity, flow and organization.

In the end, you will submit TWO files to the Assignment: the Excel file of these forecast

financial statements, and the PDF file containing the Executive Summary (and the additional

analysis if any). Be sure to retain the original Excel formatting so that I may click on each cell to

determine its derivation.