need to make statement if cash flows from this information

Panera Bread Co. 1. Use Excel to compile Indirect Statement of Cash Flows, Common-Size Income Statement and Financial Ratios for each year. Exhibit 1 Panera Bread Company Historic Income Statements (in thousands of dollars) 2003 2004 2005 2006 Number of bakery-cafs 602 741 877 1,027 363,702 479,139 640,275 828,971 Revenue Costs of goods sold Bakery-caf Dough sold to franchisees Depreciation General and administrativell) 210,822 54,967 18,304 31,502 315,595 288,706 65,627 25,298 38,735 418,366 399,760 75,036 33,011 50,240 558,047 542,916 85,618 44,166 63,502 736,202 48,107 82,228 92,769 Operating profit Interest expense Pretax profit 48 50 92 60,773 18 60,755 22,175 38,580 48,059 17,629 30,430 82,178 29,995 52,183 92,677 33,827 58,850 Net income Includes both company owned and franchised bakery-cafs Includes preopening expenses and other expenses Data source: Panera Bread Company annual reports, 2003-06 Exhibit 2 Panera Bread Company Historic Balance Sheets (in thousands of dollars) 2003 2004 2005 2006 Cash and short-term investments Accounts receivable Inventory Prepaid expenses and deferred taxes Current assets 51,421 12,394 4,350 3,887 72,052 58,054 17,256 5,398 60,651 25,158 7,358 9,607 102,774 72,122 30,919 8,714 15,863 127,618 3,905 84,613 Property, plant, and equipment Goodwill and other assets 146,362 38,421 36,421 293,334 201,725 38,334 268,884 268,809 66,084 345,072 345,977 69,014 Total assets 256,835 324,672 437,667 542,609 4,422 Accounts payable Accrued expenses and deferred revenue Current liabilities 8,072 37,571 45,643 5,840 49,865 55,705 82,443 86,865 5,800 103,810 109,610 Deferred rent and other liabilities Total liabilities 13,616 59,259 27,604 83,309 33,824 120,689 35,333 144,943 Equity Total liabilities and equity 197,576 256,835 241,363 324,672 316,978 437,667 397,666 542,609 Data source: Panera Bread Company annual reports, 2003-06. Exhibit 3 Panera Bread Company 2007 Operating Forecast in thousands of dollars) Income Statement Number of bakery-cafs 1,230 1,050,000 Revenue Costs of goods sold Bakery-caf Dough sold to franchisees Depreciation General and administrativelo 738,000 86,000 60,000 78,000 962,000 Operating profit (EBIT) Interest expensel Pretax profit Tax Net income 88,000 150 87,850 31,500 56,350 Balance Sheet Assets Current assets Property, plant, and equipment Goodwill and other assets 150,000 430,000 110,000 Operating Liabilities Current liabilities Deferred rent and other liabilities 130,000 45,000 W Author estimate based on third quarter results Indudes both company owned and franchised bakery-cafs Includes preopening expenses and other expenses Aumes soificant boing Dua ore Punera Bead Company will reports, 2005-06. 11/1/2007 10/1/2007 9/1/2007 8/1/2007 mengaman 7/1/2007 6/1/2007 5/1/2007 4/1/2007 Exhibit 4 Panera Bread Company Stock Price History Panera Stock Price 3/1/2007 2/1/2007 1/1/2007 12/1/2006 11/1/2006 10/1/2006 9/1/2006 8/1/2006 7/1/2006 Data source: Datastream - 6/1/2006 Exhibit 5 Panera Bread Company Data on Comparable Firm Capital Structure (numbers in thousands except for prices) Estimates for Year-End 2007 Revenue EBIT Debt 11/30/2007 Price Shares Quick Service Restaurants McDonald's Corporation Wendy's Group, Inc. Burger King Holdings, Inc. Domino's Pizza, Inc. Jack in the Box Inc. 22,786,600 1,263,717 2,234,000 1,462,870 2,513,431 3,879,000 19,900 290,000 193,910 216,996 8,174,500 739,333 943,000 1,720,083 433,303 56.32 8.10 25.90 13.86 29.95 1,165,300 28,884 135,000 59,665 59,736 Casual Dining Darden Restaurants, Inc. Ruby Tuesday, Inc. P.F. Chang's China Bistro, Inc. The Cheesecake Factory Inc. California Pizza Kitchen, Inc. 5,567,100 1,410,227 1,084,193 1,511,577 632,884 574,400 154,855 53,312 110,803 21,517 491,600 514,338 191,195 175,000 38.25 13.11 25.59 23.29 15.91 141,400 53,240 24,152 69,152 28,358 Fast Casual Chipotle Mexican Grill, Inc. Starbucks Corporation Buffalo Wild Wings, Inc. 1,085,782 9,411,497 329,652 113,706 1,053,945 28,518 550,000 12,585 133.15 23.39 28.91 32,805 727,600 17,657 Duta sources Investex, Onesource, Yahoo Finance, and individual firm 10-K filing