| Please enter data on this sheet before entering financial statement information.
The 'Analysis ToolPak' add-in must be installed and active. | | | | Verify using menu path of Tools > Add-Ins, then ensure 'Analysis ToolPak' is checked |
| Company Name: | EASTMAN KODAK COMPANY | | | Use the 'TAB' key to move efficiently between enterable (bordered) fields |
| Stock Ticker Symbol: | KODK |
| U.S. Stock Exchange: | NYSE | | Fixed | Options: NYSE, AMEX, NASDAQ |
| Year End Dates for Financial Statements: | 12/31/07 | 12/31/06 | 12/31/05 | Sequence: Current yr (Col.B) to prior yrs (Cols. C & D) |
| Financial Reports Rounded to : | Millions | | | Options: Thousands, Millions, Billions |
| Supplemental Ratio Requirements: | 2007 | 2006 | 2005 | Type all entries, DO NOT cut & paste values |
| Rent expense (in millions): | $130 | $160 | $149 |
| Dividends per share: | $ 0.50 | $ 0.50 | $ 0.50 | Split adjusted prices, if applicable, appear under the web site's price chart |
| End of year stock price (adjusted for splits): | $ 23.78 | $ 25.80 | $ 25.04 |
| Marketwatch.com URL for stock prices: | http://marketwatch.com/tools/quotes/historical.asp?date=12%2F31%2F2007&symb=KODK&siteid=mktw | http://marketwatch.com/tools/quotes/historical.asp?date=12%2F29%2F2006&symb=KODK&siteid=mktw | http://marketwatch.com/tools/quotes/historical.asp?date=12%2F30%2F2005&symb=KODK&siteid=mktw | Select a URL cell, copy the contents and paste into your browser's Address area for each year. If the market was not open on the day provided, modify the web site's quote date to the previous weekday. |
| Check Figures: |
| Balance Sheet Current Assets: | $ 6,053 | $ 5,557 | | Enter a negative amount to bracket check figures |
| Total Assets: | $ 13,659 | $ 14,320 |
| Current Liabilities: | $ 4,446 | $ 4,554 |
| Total Stockholders' Equity: | $ 3,029 | $ 1,388 |
| | | | | Gross Profit = Net Sales - Cost of Goods Sold
Use net sales amount when cost of goods sold isn't available |
| Income Statement Gross Profit: | $ 2,516 | $ 2,409 | $ 2,531 |
| Operating Profit: | $ 87 | $ 65 | $ 4 |
| Net Profit: | $ 676 | $ (601) | $ (1,261) |
| Cash Flow Net Flows from Operations: | $314 | $946 | $1,208 |
| Net Flows from Investing Activity: | $2,408 | ($225) | ($1,304) |
| Net Flows from Financing Activity: | ($1,280) | ($947) | $533 |
| | No enterable fields exist below this point |
esyim
spreadsheet_week_1.xls
