Complete the financing portion of Panera Bread Company's 2007 forecast financial statements, and provide a forecast for the next 5 years. A worksheet has been provided for this purpose. As an initial (base case) analysis, assume all borrowings are some form of debt. You may also assume the share repurchase occurs in 2008 and that interest expense is equal to 6% of outstanding debt. One set of assumptions is for sales growth of 25% for the first two years after 2007 and 5% thereafter (other sales growth patterns should be explored). Perform sensitivity analysis of the important assumptions. Note that the spreadsheet does not provide a detailed forecast of the current asset and current liability accounts. You should add detailed current asset and liability accounts.
Attachment:- Panera Assignment.rar