Use the Allied Food products worksheet and make a cash flow statement for the company. Do it in excel if possible.

TABLE 3-1 Allied Food Products: December 31 Balance Sheets (Millions of Dollars) 2005 2004 $ 10 375 $ 80 315 415 $ 810 870 $1,680 $1,000 1,000 $2,000 Assets Cash and equivalents Accounts receivable Inventories Total current assets Net plant and equipment Total assets Liabilities and Equity Accounts payable Notes payable Accruals Total current liabilities Long-term bonds Total debt Common stock (50,000,000 shares) Retained earnings Total common equity Total liabilities and equity $ 60 110 149 $_310 250 $1,060 130 810 $ 940 $2,000 $ 30 60 130 $ 220 580 $ 800 130 750 $ 880 $1,680 Book value per share - $940/50 - $18.80 TABLE 3-2 Allied Food Products: Income Statements for Years Ending December 31 (Millions of Dollars, Except for Per-Share Data) 2005 2004 $3,000.0 2,616.2 $2,850.0 2,497.0 Net sales Operating costs except depreciation Earnings before interest, taxes, and depreciation (EBITDAY Depreciation Earnings before interest and taxes (EBIT) Less interest Earnings before taxes (EBT) Taxes Not income Common dividends Addition to retained earnings Per-share data: $ 383.8 100.0 $ 283.8 Ba. $ 195,8 783 $ 353.0 90.0 $ 263.0 600 $ 203.0 81.2 $ 121.9 $ 53.0 $ 68.8 117 SEA FC $ 57.5 $ 60.0 Samman stock price - Market Roice Earnings per share (EPSE Dividends per share (DPSY Book value per share (BVPSY Cash flow per share (CFPSY $ 23.00 $ 2.35 $ 1.15 $ 18.00 $ $ 26.00 $ 2.44 $ 1.06 $17.60 $ 4.24 Notes: Operating costs include leasd payments of $28 milion Allied has no amortization charges Allied has 50 million shares of common stock outstanding Note that EPS is based on net income available to common stockholders. Calculations of EPS, DPS, BVPS, and CFPS for 2005