|
|
|
| Symbol | Price | Change | % Chg |
| INTC | 24.04 | 0.10 | 0.42% |
Quotes are by IDC Comstock and are delayed 20 minutes.
Fund prices are from Morningstar. |
Link to Articles Link to INTC Quarterly Data
Check the Fair Value List tab for current updates to Fair Values. Information is provided "as is", solely for informational purposes, not for trading purposes or advice Please read disclaimer - link at the bottom of this page
| |
| | Intel Corp-Entry target below-$18.1 | INTC | | | | | Intel Corporation designs, manufactures, and sells integrated digital technology platforms worldwide. The company operates through PC Client Group, Data Center Group, Other Intel Architecture, Software and Services, and All Other segments. It offers microprocessors that process system data and controls other devices in the system; and chipsets, which sends data between the microprocessor and input, display, and storage devices, such as keyboard, mouse, monitor, hard drive or solid-state drive, and optical disc drives; system-on-chip products that integrate its processing functions with other system components, including graphics, audio, and video onto a single chip; wired network connectivity products; and wireless connectivity products. The company also provides mobile phone components comprising baseband processors, radio frequency transceivers, and power management integrated circuits; and mobile phone platforms, such as Bluetooth wireless technology and global positioning systems receivers, software solutions, customization, and interoperability tests. In addition, it offers endpoint security, network and content security, risk and compliance, and consumer and mobile security software products for consumer, mobile, and corporate environments to protect systems from malicious virus attacks, as well as loss of data. Further, the company provides NAND flash memory products, which are used in solid-state drives. Intel Corporation sells its products primarily to original equipment manufacturers, original design manufacturers, and industrial and communications equipment manufacturers in the computing and communications industries. The company has a strategic collaboration with ZTE Corporation focusing on the Intel Atom Processor Z2580 platform. Intel Corporation was founded in 1968 and is based in Santa Clara, California. | | This page Last Updated: | 5/2/2013 10:49 | | | PE HISTORY | | Calculated Fair Value as of above date | $24.5 | Zacks | MorningStar | (based on yr end price) | | Price as of last update given above | $23.92 | 3 | 3 | fiscal year | PE | | | Current discount at time of update | 2.4% | | | 2008 | 13.8 | | | Tangible book value/share per IIEX calcs | $6.94 | | | 2009 | 23.9 | | | Market Cap (million) | $118,094 | | | 2010 | 9.7 | | | Forward diluted shares used in calcs (million) | 5080.0 | | | 2011 | 9.7 | | | Diviidend yield | 3.76% | | | 2012 | 9.4 | | | Payout to FCF | 74% | | | current | 12.0 | 5/2/2013 | | Estimated 5 year EPS growth (see below) | 3.64% | | | Forward | 13.1 | 5/2/2013 | | Current PE | 11.8 | | | 4 year ave | 5.0 | 5/2/2013 | | Fair Value PE | 13.4 | | | Past 5 yr Growth Rates | | | Projected FCF growth | 9.9% | | | Revenue | 7.5% | | | Projected FCF growth after year 10 | 2.0% | | | Op. Income | 13.0% | | | DCF discount | 9% | | | FCF | 5.9% | | | DCF MOS | 35.0% | | | | | | | Current Earnings-Projected | $1.83 | Check the Value Calcs tab for any updates in fair values and target prices made after this page was last updated. | | 52 Week Range | 19.23-29.27 | | Current Ratio | 2.43 | | Liab./ Equity | 0.62 | | Piotroski Score (last year| TTM) | 6 | 5 | | | | | | | Altman Z Score (manufacturer) | 4.44 | 0.00 | Below numbers in millions | | | Data sources: Advfn; Yahoo; IIEX, MSN, Zacks, Morning Star | | Quarterly data below the yearly data | | Fiscal year ends - Dec | | | | | PAST DATA USED | 0 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | TTM | | Income Statement-Selected financials | NA=not available at update | 0 | 0 | 0 | 0 | 0 | 12/30/2008 | 12/30/2009 | 12/30/2010 | 12/30/2011 | 12/30/2012 | 0 | Revenues | Revenue | $30,141.0 | $34,209.0 | $38,826.0 | $35,382.0 | $38,334.0 | $37,586.0 | $35,127.0 | $43,623.0 | $53,999.0 | $53,341.0 | $53,015.0 | COGS | $13,047.0 | $14,463.0 | $15,777.0 | $17,164.0 | $18,430.0 | $16,742.0 | $15,566.0 | $15,132.0 | $20,242.0 | $20,190.0 | $21,063.0 | COGS (%) | 43.3% | 42.3% | 40.6% | 48.5% | 48.1% | 44.5% | 44.3% | 34.7% | 37.5% | 37.9% | 39.7% | Gross Profit | $17,094.0 | $19,746.0 | $23,049.0 | $18,218.0 | $19,904.0 | $20,844.0 | $19,561.0 | $28,491.0 | $33,757.0 | $33,151.0 | $31,952.0 | Gross Profit (%) | 56.7% | 57.7% | 59.4% | 51.5% | 51.9% | 55.5% | 55.7% | 65.3% | 62.5% | 62.1% | 60.3% | Operating Expenses | SG&A | $4,278.0 | $4,659.0 | $5,688.0 | $6,096.0 | $5,401.0 | $5,458.0 | $7,931.0 | $6,309.0 | $7,670.0 | $8,057.0 | $8,031.0 | SG&A (%) | 14.2% | 13.6% | 14.6% | 17.2% | 14.1% | 14.5% | 22.6% | 14.5% | 14.2% | 15.1% | 15.1% | R&D | $4,360.0 | $4,778.0 | $5,145.0 | $5,873.0 | $5,755.0 | $5,722.0 | $5,653.0 | $6,576.0 | $8,350.0 | $10,148.0 | $10,274.0 | R&D (%) | 14.5% | 14.0% | 13.3% | 16.6% | 15.0% | 15.2% | 16.1% | 15.1% | 15.5% | 19.0% | 19.4% | Other (Inc. D&A) | $923.0 | $179.0 | $126.0 | $597.0 | $532.0 | $710.0 | $266.0 | $18.0 | $260.0 | $308.0 | $300.0 | Other (%) | 3.1% | 0.5% | 0.3% | 1.7% | 1.4% | 1.9% | 0.8% | 0.0% | 0.5% | 0.6% | 0.6% | Operating Income | $7,533.0 | $10,130.0 | $12,090.0 | $5,652.0 | $8,216.0 | $8,954.0 | $5,711.0 | $15,588.0 | $17,477.0 | $14,638.0 | $13,347.0 | Operating Income (%) | 25.0% | 29.6% | 31.1% | 16.0% | 21.4% | 23.8% | 16.3% | 35.7% | 32.4% | 27.4% | 25.2% | Other Income and
Expense | Net i Inc,other &charges | $186.0 | $251.0 | $558.0 | $612.0 | $789.0 | $584.0 | $167.0 | $119.0 | $57.0 | $7.0 | ($40.0) | Earnings Before Taxes | $7,442.0 | $10,417.0 | $12,610.0 | $7,068.0 | $9,166.0 | $7,686.0 | $5,704.0 | $16,045.0 | $17,781.0 | $14,873.0 | $13,502.0 | Income Taxes | $1,801.0 | $2,901.0 | $3,946.0 | $2,024.0 | $2,190.0 | $2,394.0 | $1,335.0 | $4,581.0 | $4,839.0 | $3,868.0 | $3,190.0 | Earnings After Taxes | $5,641.0 | $7,516.0 | $8,664.0 | $5,044.0 | $6,976.0 | $5,292.0 | $4,369.0 | $11,464.0 | $12,942.0 | $11,005.0 | $10,312.0 | Acctg Changes | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | Disc Operations | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | Ext Items | $0.0 | $0.0 | $0.0 | $5,044.0 | $6,976.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | Net Income | Net Income | $5,641.0 | $7,516.0 | $8,664.0 | $5,044.0 | $6,976.0 | $5,292.0 | $4,369.0 | $11,464.0 | $12,942.0 | $11,005.0 | $10,312.0 | Net Income (%) | 18.7% | 22.0% | 22.3% | 14.3% | 18.2% | 14.1% | 12.4% | 26.3% | 24.0% | 20.6% | 19.5% | Diluted EPS, Cont Ops | $0.85 | $1.16 | $1.40 | $0.86 | $1.18 | $0.92 | $0.77 | $2.01 | $2.39 | $2.13 | $2.03 | Diluted EPS - adj. | $0.85 | $1.16 | $1.40 | $0.86 | $1.18 | $0.92 | $0.77 | $2.01 | $2.39 | $2.13 | $2.00 | Shares | 6621 | 6494 | 6178 | 5880 | 5936 | 5748 | 5645 | 5696 | 5411 | 5160 | 5080 | Balance Sheet | 0 | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ 5,160.0 | $ 5,080.0 | Assets | Cash and Equiv | $7,971.0 | $8,407.0 | $7,324.0 | $6,598.0 | $7,307.0 | $3,350.0 | $3,987.0 | $5,498.0 | $5,065.0 | $8,478.0 | $5,698.0 | Short-Term Investments | $8,193.0 | $8,765.0 | $5,448.0 | $3,404.0 | $5,490.0 | $5,331.0 | $5,285.0 | $16,387.0 | $9,772.0 | $9,684.0 | $4,323.0 | Accts Rec | $2,960.0 | $2,999.0 | $3,914.0 | $2,709.0 | $2,576.0 | $1,712.0 | $2,273.0 | $2,867.0 | $3,650.0 | $3,833.0 | $3,536.0 | Inventory | $2,519.0 | $2,621.0 | $3,126.0 | $4,314.0 | $3,370.0 | $3,744.0 | $2,935.0 | $3,757.0 | $4,096.0 | $4,734.0 | $4,358.0 | Other Current Assets | $270.0 | $287.0 | $233.0 | $258.0 | $3,956.0 | $4,344.0 | $5,461.0 | $1,614.0 | $1,589.0 | $2,512.0 | $8,653.0 | Total Current Assets | $22,882.0 | $24,058.0 | $21,194.0 | $18,280.0 | $23,885.0 | $19,871.0 | $21,157.0 | $31,611.0 | $25,872.0 | $31,358.0 | $28,677.0 | Net PP&E | $16,661.0 | $15,768.0 | $17,111.0 | $17,602.0 | $16,918.0 | $17,544.0 | $17,225.0 | $17,899.0 | $23,627.0 | $27,983.0 | $28,418.0 | Intangibles/Goodwill | $3,705.0 | $3,719.0 | $3,873.0 | $0.0 | $0.0 | $775.0 | $0.0 | $0.0 | $6,267.0 | $6,235.0 | $4,875.0 | Other Long-Term Assets | $3,895.0 | $4,598.0 | $6,136.0 | $12,486.0 | $14,848.0 | $12,525.0 | $14,713.0 | $13,676.0 | $15,353.0 | $18,775.0 | $21,113.0 | Total Assets | $47,143.0 | $48,143.0 | $48,314.0 | $48,368.0 | $55,651.0 | $50,715.0 | $53,095.0 | $63,186.0 | $71,119.0 | $84,351.0 | $83,083.0 | Liabilities & Equity | Accts Payable | $1,660.0 | $1,943.0 | $2,249.0 | $2,256.0 | $2,361.0 | $2,390.0 | $1,883.0 | $2,290.0 | $2,956.0 | $3,023.0 | $2,654.0 | Short-Term Debt | $224.0 | $201.0 | $313.0 | $180.0 | $142.0 | $102.0 | $172.0 | $38.0 | $247.0 | $312.0 | $88.0 | Taxes Payable | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | Accrued Liabilities | $3,577.0 | $4,107.0 | $4,080.0 | $3,682.0 | $5,104.0 | $4,863.0 | $4,857.0 | $6,377.0 | $6,896.0 | $7,631.0 | $7,155.0 | Other Short-Term Liabilities | $785.0 | $1,163.0 | $1,960.0 | $1,797.0 | $339.0 | $0.0 | $86.0 | $0.0 | $0.0 | $0.0 | $1,901.0 | Total Current Liabilities | $6,879.0 | $8,006.0 | $9,234.0 | $8,514.0 | $8,571.0 | $7,818.0 | $7,591.0 | $9,327.0 | $12,028.0 | $12,898.0 | $11,798.0 | Long-Term Debt | $936.0 | $703.0 | $2,106.0 | $1,848.0 | $1,980.0 | $1,886.0 | $2,049.0 | $2,077.0 | $7,084.0 | $13,136.0 | $13,143.0 | Other Long-Term Liabilities | $1,482.0 | $855.0 | $792.0 | $1,254.0 | $2,338.0 | $1,923.0 | $1,751.0 | $2,352.0 | $6,096.0 | $7,114.0 | $6,948.0 | Total Liabilities | $9,297.0 | $9,564.0 | $12,132.0 | $11,616.0 | $12,889.0 | $11,627.0 | $11,391.0 | $13,756.0 | $25,208.0 | $33,148.0 | $31,889.0 | Total Equity | $37,846.0 | $38,579.0 | $36,182.0 | $36,752.0 | $42,762.0 | $39,088.0 | $41,704.0 | $49,430.0 | $45,911.0 | $51,203.0 | $51,194.0 | Total Liabilities & Equity | $47,143.0 | $48,143.0 | $48,314.0 | $48,368.0 | $55,651.0 | $50,715.0 | $53,095.0 | $63,186.0 | $71,119.0 | $84,351.0 | $83,083.0 | Cash Flow Data | 0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | Cash Flows From
Operating Activities | Net Income | $5,641.0 | $7,516.0 | $8,664.0 | $5,044.0 | $6,976.0 | $5,292.0 | $4,369.0 | $11,464.0 | $12,942.0 | $11,005.0 | $10,312.0 | Depr & Amort | $5,070.0 | $4,889.0 | $4,595.0 | $4,912.0 | $4,798.0 | $4,616.0 | $5,052.0 | $4,638.0 | $6,064.0 | $7,522.0 | $6,520.0 | Deferred Taxes | $391.0 | ($207.0) | ($413.0) | ($325.0) | ($443.0) | ($790.0) | $271.0 | ($46.0) | $790.0 | ($242.0) | ($253.0) | Other | $413.0 | $921.0 | $1,977.0 | $989.0 | $1,294.0 | $1,808.0 | $1,478.0 | $636.0 | $1,167.0 | $599.0 | $3,618.0 | Cash from Operations | $11,515.0 | $13,119.0 | $14,823.0 | $10,620.0 | $12,625.0 | $10,926.0 | $11,170.0 | $16,692.0 | $20,963.0 | $18,884.0 | $20,197.0 | Cash Flows From
Investing Activities | Cap Ex | ($3,656.0) | ($3,843.0) | ($5,818.0) | ($5,779.0) | ($5,000.0) | ($5,197.0) | ($4,515.0) | ($5,207.0) | ($10,764.0) | ($11,842.0) | ($11,075.0) | Purchase of Business | ($61.0) | ($53.0) | ($191.0) | $752.0 | ($44.0) | $69.0 | ($853.0) | ($218.0) | ($8,671.0) | ($33.0) | $45.0 | Other | ($3,373.0) | ($1,136.0) | ($353.0) | $120.0 | ($4,882.0) | ($737.0) | ($2,597.0) | ($5,114.0) | $9,134.0 | ($2,185.0) | ($6,236.0) | Cash from Investing | ($7,090.0) | ($5,032.0) | ($6,362.0) | ($4,907.0) | ($9,926.0) | ($5,865.0) | ($7,965.0) | ($10,539.0) | ($10,301.0) | ($14,060.0) | ($17,266.0) | Cash Flows From
Financing Activities | Net Issuance of Stock | ($3,045.0) | ($6,622.0) | ($9,435.0) | ($3,547.0) | $264.0 | ($6,090.0) | ($1,362.0) | ($1,149.0) | ($12,295.0) | ($2,999.0) | ($2,818.0) | Net Issuance of Debt | ($289.0) | ($7.0) | $1,849.0 | $0.0 | $0.0 | ($40.0) | $1,893.0 | ($78.0) | $5,086.0 | $6,062.0 | $5,947.0 | Dividends | ($524.0) | ($1,022.0) | ($1,958.0) | ($2,320.0) | ($2,618.0) | ($3,100.0) | ($3,108.0) | ($3,503.0) | ($4,127.0) | ($4,350.0) | ($4,415.0) | Other | $0.0 | $0.0 | $0.0 | ($572.0) | $364.0 | $212.0 | $9.0 | $88.0 | $236.0 | ($121.0) | ($365.0) | Cash from Financing | ($3,858.0) | ($7,651.0) | ($9,544.0) | ($6,439.0) | ($1,990.0) | ($9,018.0) | ($2,568.0) | ($4,642.0) | ($11,100.0) | ($1,408.0) | ($1,651.0) | Free Cash Flow | Currency Adj | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $5.0 | ($3.0) | ($11.0) | Change in Cash | $567.0 | $436.0 | ($1,083.0) | ($726.0) | $709.0 | ($3,957.0) | $637.0 | $1,511.0 | ($433.0) | $3,413.0 | $1,269.0 | Cash from Operations | $11,515.0 | $13,119.0 | $14,823.0 | $10,620.0 | $12,625.0 | $10,926.0 | $11,170.0 | $16,692.0 | $20,963.0 | $18,884.0 | $20,197.0 | Cap Ex | ($3,656.0) | ($3,843.0) | ($5,818.0) | ($5,779.0) | ($5,000.0) | ($5,197.0) | ($4,515.0) | ($5,207.0) | ($10,764.0) | ($11,842.0) | ($11,075.0) | Free Cash Flow | $7,859.0 | $9,276.0 | $9,005.0 | $4,841.0 | $7,625.0 | $5,729.0 | $6,655.0 | $11,485.0 | $10,199.0 | $7,042.0 | $9,122.0 | Misc Data | Book Value Per Share | $5.72 | $5.94 | $5.86 | $6.25 | $7.20 | $6.80 | $7.39 | $8.68 | $8.48 | $9.92 | $10.08 | Div/Share | ($0.08) | ($0.16) | ($0.32) | ($0.39) | ($0.44) | ($0.54) | ($0.55) | ($0.61) | ($0.76) | ($0.84) | ($0.87) | Year end stock price | $25.55 | $18.62 | $20.63 | $16.87 | $22.62 | $12.72 | $18.44 | $19.41 | $23.19 | $20.01 | $23.92 | PE | 30.1 | 16.1 | 14.7 | 19.6 | 19.2 | 13.8 | 23.9 | 9.7 | 9.7 | 9.4 | 11.8 | Free Cash Flow %Revenue | 26.1% | 27.1% | 23.2% | 13.7% | 19.9% | 15.2% | 18.9% | 26.3% | 18.9% | 13.2% | 17.2% | Quarterly Income Statement | | 2013/03 | 2012/12 | 2012/09 | 2012/06 | | | | | | | | Revenues | Revenue | $12,580.0 | $13,477.0 | $13,457.0 | $13,501.0 | | | | | | | | COGS | $5,514.0 | $5,660.0 | $4,942.0 | $4,947.0 | | | | | | | | Gross Profit | $7,066.0 | $7,817.0 | $8,515.0 | $8,554.0 | | | | | | | | Operating Expenses | SG&A | $1,947.0 | $1,958.0 | $1,995.0 | $2,131.0 | | | | | | | | R&D | $2,527.0 | $2,629.0 | $2,605.0 | $2,513.0 | | | | | | | | Other | $73.0 | $75.0 | $74.0 | $78.0 | | | | | | | | Operating Income | $2,519.0 | $3,155.0 | $3,841.0 | $3,832.0 | | | | | | | | Other Income and
Expense | Net Int Inc & Other | ($50.0) | ($3.0) | $9.0 | $4.0 | | | | | | | | Earnings Before Taxes | $2,443.0 | $3,204.0 | $3,921.0 | $3,934.0 | | | | | | | | Income Taxes | $398.0 | $736.0 | $949.0 | $1,107.0 | | | | | | | | Earnings After Taxes | $2,045.0 | $11,005.0 | $0.0 | $0.0 | | | | | | | | Acctg Changes | $0.0 | $0.0 | $0.0 | $0.0 | | | | | | | | Disc Operations | $0.0 | $0.0 | $0.0 | $0.0 | | | | | | | | Ext Items | $0.0 | $0.0 | $0.0 | $0.0 | | | | | | | | Net Income | Net Income | $2,045.0 | $2,468.0 | $2,972.0 | $2,827.0 | | | | | | | | Diluted EPS, Cont Ops$ | $0.40 | $0.48 | $0.58 | $0.54 | | | | | | | | Diluted EPS$ | $0.40 | $0.48 | $0.58 | $0.54 | | | | | | | | | | | | | | | | | | | | | Quarterly Cash Flow Data | (#'s are cummulative) | 2013/03 | 2012/12 | 2012/09 | 2012/06 | 2012/03 | | | | | | | Cash Flows From
Operating Activities | Depr & Amort | $1,682.0 | $6,357.0 | $4,716.0 | $3,091.0 | $1,519.0 | | | | | | | Deferred Taxes | ($56.0) | ($242.0) | ($42.0) | $55.0 | ($45.0) | | | | | | | Other | $614.0 | $1,764.0 | ($353.0) | ($1,000.0) | ($1,240.0) | | | | | | | Cash from Operations | $4,285.0 | $18,884.0 | $12,858.0 | $7,711.0 | $2,972.0 | | | | | | | Cash Flows From
Investing Activities | Cap Ex | ($2,207.0) | ($11,842.0) | ($9,088.0) | ($5,636.0) | ($2,974.0) | | | | | | | Purchase of Business | ($98.0) | ($33.0) | $37.0 | $147.0 | ($176.0) | | | | | | | Other | ($3,012.0) | ($2,185.0) | $323.0 | $1,613.0 | $1,039.0 | | | | | | | Cash from Investing | ($5,317.0) | ($14,060.0) | ($8,728.0) | ($3,876.0) | ($2,111.0) | | | | | | | Cash Flows From
Financing Activities | Net Issuance of Stock | ($94.0) | ($2,999.0) | ($2,115.0) | ($1,234.0) | ($275.0) | | | | | | | Net Issuance of Debt | $0.0 | $6,062.0 | $0.0 | ($155.0) | $115.0 | | | | | | | Dividends | ($1,114.0) | ($4,350.0) | ($3,231.0) | ($2,106.0) | ($1,049.0) | | | | | | | Other | ($530.0) | ($121.0) | ($329.0) | ($176.0) | ($286.0) | | | | | | | Cash from Financing | ($1,738.0) | ($1,408.0) | ($5,675.0) | ($3,671.0) | ($1,495.0) | | | | | | | | Currency Adj | ($10.0) | ($3.0) | $0.0 | ($6.0) | ($2.0) | | | | | | | Change in Cash | ($2,780.0) | $3,413.0 | ($1,545.0) | $158.0 | ($636.0) | | | | | | | Net Income - per year or Qtr | $2,045.0 | $2,468.0 | $2,972.0 | $2,827.0 | $2,738.0 | | | | | | | Net Income - cumm per FY | $2,045.0 | $11,005.0 | $8,537.0 | $5,565.0 | $2,738.0 | | | | | | | Free Cash Flow | FCF | $2,078.0 | $7,042.0 | $3,770.0 | $2,075.0 | ($2.0) | | | | | | | FCF/Share | $0.41 | $1.39 | $0.74 | $0.41 | $0.00 | | | | | | | | | | | | | | | | | | | | | | Additional analysis information - see notes below | | | | | | | | | | | | | Earnings Growth information | | Year | 3yr op income average (y) | Operating income (y) | Diluted EPS - cont. ops. | | | Year | 3yr op income average (y) | Operating income (y) | Diluted EPS - cont. ops. | | | | | 2005 | 9918 | 12090 | 1.40 | 10 year trend data | | 2005 | 9918 | 12090 | 1.40 | Actural | | | | 2006 | 9291 | 5652 | 0.86 | | 2006 | 9291 | 5652 | 0.86 | | Past EPS Growth using averages - info only | 2007 | 8653 | 8216 | 1.18 | | 2007 | 8653 | 8216 | 1.18 | | 10.16% | 5 yr ave | 2008 | 7607 | 8954 | 0.92 | | 2008 | 7607 | 8954 | 0.92 | | 11.18% | 4 yr ave | 2009 | 7627 | 5711 | 0.77 | | 2009 | 7627 | 5711 | 0.77 | | 12.54% | 3 yr ave | 2010 | 10084 | 15588 | 2.01 | 5 year trend data | 2010 | 10084 | 15588 | 2.01 | | 9.86% | 2 yr ave | 2011 | 12925 | 17477 | 2.39 | 2011 | 12925 | 17477 | 2.39 | | calculates the statistics for a trend line by using the "least squares" method to calculate a straight line that best fits the data, and then returns an array that describes the trend line. Projections are an extension of the historical data based on 10 and 5 year trends. Also applies to the FCF section. | 2012 | 15901 | 14638 | 2.13 | 2012 | 15901 | 14638 | 2.13 | | 2013 | 15328 | 13870 | 1.83 | 2013 | 15328 | 13870 | 1.83 | Estimates | | 2014 | 14629 | 15378 | 2.03 | EPS based | on %USED | 2014 | 14629 | 15378 | 2.03 | | 2015 | 15840 | 16913 | 2.31 | $1.97 | 2015 | 17221 | 14182 | 1.87 | Projections | | 2016 | 16684 | 17850 | 2.45 | $2.04 | 2016 | 18370 | 13779 | 1.82 | | 2017 | 17529 | 18788 | 2.59 | $2.11 | 2017 | 19519 | 13376 | 1.77 | | 2018 | 18373 | 19725 | 2.73 | $2.19 | 2018 | 20668 | 12973 | 1.71 | | | | 10 year analysis | 9.22% | 8.22% | 11.49% | | | 5 year analysis | 6.16% | -1.33% | -1.33% | Blended 10 & 5 yr EPS | | | | | From MSN or NASDAQ | 9.00% | From Yahoo | 11.00% | USED | 3.64% | | 5.08% | | | | | | | | | | | | | | | | FCF & operating cash Growth information | | Year | 10 yr FCF trend projection | 5 yr FCF trend projection | 3 yr FCF trend projection | | | Year | 10 yr op cash trend projection | 5 yr op cash trend projection | 3 yr op cash trend projection | | | | Actual Data | 2003 | 7859 | 7859 | 7859 | | Actual Data | 2003 | 11515 | 11515 | 11515 | | | | 2004 | 9276 | 9276 | 9276 | | 2004 | 13119 | 13119 | 13119 | | | | 2005 | 9005 | 9005 | 9005 | | 2005 | 14823 | 14823 | 14823 | | | | 2006 | 4841 | 4841 | 4841 | | 2006 | 10620 | 10620 | 10620 | | | | 2007 | 7625 | 7625 | 7625 | | 2007 | 12625 | 12625 | 12625 | | | | 2008 | 5729 | 5729 | 5729 | | 2008 | 10926 | 10926 | 10926 | | | | 2009 | 6655 | 6655 | 6655 | | 2009 | 11170 | 11170 | 11170 | | | | 2010 | 11485 | 11485 | 11485 | | 2010 | 16692 | 16692 | 16692 | 2012-2016 | | | 2011 | 10199 | 10199 | 10199 | | 2011 | 20963 | 20963 | 20963 | Blended | | | 2012 | 7042 | 7042 | 7042 | FCF USED | 2012 | 18884 | 18884 | 18884 | -4.63% | | Manual are projections from research not the least squares method as decscribed above | Manual | 2013 | 6000 | 6000 | 6000 | Manual | 2013 | 20197 | 20197 | 20197 | 2013-2016 | | | 2014 | 7655 | 6550 | 3548 | 6597 | Possible projections | 2014 | 19898 | 23849 | 21293 | Blended | | | 2015 | 8000 | 4035 | 2036 | 7253 | 2015 | 20767 | 25956 | 22137 | 6.93% | | Projections | 2016 | 8068 | 8293 | 2240 | 7975 | 2016 | 21636 | 28064 | 22980 | | | | | Calc FCF Growth | 10 yr calc | 5 yr calc | 3yr calc | | | Calc Op.Cash Growth | 10 yr calc | 5 yr calc | 3yr calc | Ave weighting | | | | 5.24% | -4.05% | -27.98% | | 7.38% | 6.01% | 4.39% | 5.43% | | | Adjusted Trend | 9.48% | 0.00% | USED | 9.95% | | 2012-2016 | 3.46% | 10.41% | 5.03% | | | | | | | | | | | | | | | | FCF & operating cash Growth information per share | | Year | 10 yr FCF trend projection | 5 yr FCF trend projection | 3 yr FCF trend projection | | | Year | 10 yr op cash trend projection | 5 yr op cash trend projection | 3 yr op cash trend projection | | | | | 2003 | 1.19 | 1.19 | 1.19 | Actual Data | 2003 | 1.74 | 1.74 | 1.74 | | | | | 2004 | 1.43 | 1.43 | 1.43 | 2004 | 2.02 | 2.02 | 2.02 | | | | | 2005 | 1.46 | 1.46 | 1.46 | 2005 | 2.40 | 2.40 | 2.40 | | | | | 2006 | 0.82 | 0.82 | 0.82 | 2006 | 1.81 | 1.81 | 1.81 | | | | | 2007 | 1.28 | 1.28 | 1.28 | 2007 | 2.13 | 2.13 | 2.13 | | | | | 2008 | 1.00 | 1.00 | 1.00 | 2008 | 1.90 | 1.90 | 1.90 | | | | | 2009 | 1.18 | 1.18 | 1.18 | 2009 | 1.98 | 1.98 | 1.98 | | | | | 2010 | 2.02 | 2.02 | 2.02 | 2010 | 2.93 | 2.93 | 2.93 | | | | | 2011 | 1.88 | 1.88 | 1.88 | 2011 | 3.87 | 3.87 | 3.87 | | | | | 2012 | 1.36 | 1.36 | 1.36 | 2012 | 3.66 | 3.66 | 3.66 | | | | | 2013 | 1.18 | 1.18 | 1.18 | 2013-2016 | | 2013 | 3.98 | 3.98 | 3.98 | 2013-2016 | | | | 2014 | 1.55 | 1.33 | 0.72 | 1.96% | | 2014 | 4.03 | 4.83 | 4.31 | 10.09% | | | | 2015 | 1.67 | 0.84 | 0.42 | 2012-2016 | | 2015 | 4.33 | 5.41 | 4.62 | 2012-2016 | | | | 2016 | 1.73 | 1.78 | 0.48 | -2.12% | | 2016 | 4.65 | 6.03 | 4.94 | 9.81% | | | | Proj FCF Growth | 10 yr calc | 5 yr calc | 3yr calc | Ave | | Proj Op.Cash Growth | 10 yr calc | 5 yr calc | 3yr calc | Ave | | | | 7.74% | -1.11% | -25.83% | -11.99% | | 9.92% | 9.27% | 7.51% | 8.50% | | The USED earnings and FCF growthrates are determined based on several sources which may include but may not be limited to the percentages generated through the model (used as a starting point) various third party analyst reports, conference call transcripts, etc. | |
| |
|
|