Complete the financing portion of Panera Bread Company$$s $2007$ projected financial

statements and provide a forecast for the next five years. As an initial base case, assume all borrowings will be some form of debt. Also assume

the company has $31\mathrm{.}497$MM fully diluted shares outstanding, the share repurchase

discussed in the case occurs in $2008$ and interest expense is equal to $6\mathrm{.}0\%$ of

outstanding debt. Assume sales growth of $25\%$ each year for the first two years after

$2007($i$.$e$.,2008$ and $2009),$ and $5\%$ each year thereafter.

PLEASE SHOW EXCEL FORMULAS TO FILL IN THE FORECASTS