Silicon Investor (SI) -- The First Internet Community

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Technology Stocks : Cisco Systems, Inc. (CSCO) -- Ignore unavailable to you. Want to Upgrade?

To: Dave who wrote (57906)	2/23/2002 8:11:47 AM
From: RetiredNow	Read Replies (1) \| Respond to of 77400

Part 1: Adjusting Operating Cash Flows 10/31/2001 7/31/2001 7/31/2000 7/31/1999 7/31/1998 7/31/1997 7/31/1996 shares used in fully diluted EPS 7.307 7.196 7.438 7.062 6.658 6.287 6.008 growth 1.5% -3.3% 5.3% 6.1% 5.9% 4.6% dilutive effect of stock options 0 0 0.521 0.416 0.346 0.280 0.250 o/s shares 7.307 7.196 6.917 6.646 6.312 6.007 5.758 growth 1.5% 4.0% 4.1% 5.3% 5.1% 4.3% Operating Cash Flows 1,384 6,392 6,141 4,325 2,865 1,448 1,063 less provision for doubtful accts 26 268 40 19 43 13 19 provision for inventory (29) 2,775 339 151 161 123 53 tax benefits from employee stock options 43 1,397 2,495 837 422 274 198 restructuring costs 501 Net (gain) loss from investments 971 43 (92) - Adjusted operating cash flows 373 1,408 3,359 3,318 2,239 1,038 793 AOCF/share 0.05 0.20 0.45 0.47 0.34 0.17 0.13 Sales 4,448 22,293 18,928 12,173 8,489 6,452 4,101 AOCF/Sales 8% 6% 18% 27% 26% 16% 19%

To: Dave who wrote (57906)	2/23/2002 8:13:34 AM
From: RetiredNow	Read Replies (1) \| Respond to of 77400

Sorry, Dave. It's not pretty, but there it is.

To: Dave who wrote (57906)	2/23/2002 12:27:05 PM
From: Stock Farmer	Respond to of 77400

Hi Dave, already posted. Here: Message 17092656 Two spreadsheets. One calculates the PV of $1 of profit growing at a determined rate given a discount (that's the first spreadsheet, column PV Cash, total). Second multiplies first PV Cash total by first year profit value and then divides by #shares in the terminal year. Mine went to 2020, his went to 2030. Plus one other subtle difference in how we handle growth of OS shares. See also my comment to mindmeld about his spreadsheet. John