Question

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.

Answer 1

		Cash Flow Statements
				2004	2005	2006
		Cash flows from operations
		Net Income		38,580	52,183	58,850
	Add:	Depreciation		25,298	33,011	44,166
	Add:	Interest Expenses		18	50	92
		Cash Flows from operating activities before working Capital Changes		63,896	85,244	103,108
	Add:	Opening Current Assets excluding Cash		20,631	26,559	102,774
	Add:	Closing Current Liabilities		55,705	86,865	48,959
	Less:	Closing Current Assets excluding Cash		26,559	42,123	55,496
	Less:	Opening Current Liabilities		45,643	55,705	86,865
		Cashflows from operating activities		68,030	100,840	112,480
		Cash flows from Investing Activities
		(Increase)/Decrease Other Assets Excluding Current assets*		-55,276	-94,834	-80,098
		( Depreciation charged during the year)		-25,298	-33,011	-44,166
		Cash flows from Investing Activities		-80,574	-127,845	-124,264
		Cash flows from Financing Activities
		Increase/(Decrease) Other Liabilities Excluding Current Liabilities**		13,988	6,220	1,509
		Interest Expenses		-18	-50	-92
		Increase/(Decrease) in Equity***		5,207	23,432	21,838
		Cash flows from Financing Activities		19,177	29,602	23,255
		Cash flows		6,633	2,597	11,471
		Opening		51,421	58,054	60,651
		*Increase/(Decrease) Other Assets Excluding Current assets = (Closing Assets-Opening Assets)
		** Increase/(Decrease) Other Liabilities Excluding Current Liabilities = Closing Other Long-term liabilites - Opening other Long-term liabilities
		*** Increase/(Decrease) in Equity = Closing Equity - Opening Equity - Net Profit for the current year