Reference no: EM132636430

Problem 1: You are a financial analyst for Panera Bread Company, reporting to the CFO. Part of your job involves preparing financial projections and it is time to generate those for the coming years. You need to provide a report to your boss that details the external funding needs required by Panera Bread Company as they undergo some tightening of margins and a repurchase of $75 million of stock. Using excel.

• Financial projections for the years 2007, 2008 and 2009 indicating Panera's need for funds. Use a sales projections of $1,050,000,000 for 2007 and generate your own revenue projections for 2008 and 2009.
• Size of the loan you think Panera should request from their bank. Assume that the loan will carry a 6% rate of interest, may be taken out over a two-year period beginning in 2007, and will require no principal payments until 2011.
• Assume the stock buy-back will be spread over two years so that $37.5 million is repurchased in each 2007 and 2008.
• Note that the equity account on Panera's balance sheet includes stock and retained earnings. The value of property, plant and equipment is shown net of depreciation.
• Results of sensitivity analysis on key parameters indicating why changes in their values may occur and how those changes will affect Panera's need for funds.