PANERA BREAD COMPANY 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 to create your sheets Financial projections for the years 2007, 2008 and 2009 indicating Paneras 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 Paneras 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 Paneras need for funds

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 16, 2024

PANERA BREAD COMPANY You are a financial analyst for Panera Bread Company, reporting to the CFO. Part of your job involves preparing financial projections and

PANERA BREAD COMPANY

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 to create your sheets.

Financial projections for the years 2007, 2008 and 2009 indicating Paneras 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 Paneras 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 Paneras need for funds.