Forecasting and Estimating Share Value Using the DCF Model
Following are the income statement and balance sheet for Intel
Corporation.
| INTEL CORPORATION Consolidated Statements of Income |
|||
|---|---|---|---|
| Year Ended (In millions) | Dec. 25, 2010 | Dec. 26, 2009 | Dec. 27, 2008 |
| Net revenue | $ 44,423 | $ 35,127 | $ 37,586 |
| Cost of sales | 15,132 | 15,566 | 16,742 |
| Gross margin | 29,291 | 19,561 | 20,844 |
| Research and development | 6,576 | 5,653 | 5,722 |
| Marketing, general and administrative | 6,309 | 7,931 | 5,452 |
| Restructuring and asset impairment charges | -- | 231 | 710 |
| Amortization of acquisition-related intangibles | 18 | 35 | 6 |
| Operating expenses | 12,903 | 13,850 | 11,890 |
| Operating income | 16,388 | 5,711 | 8,954 |
| Gains (losses) on equity method investments, net* | 117 | (147) | (1,380) |
| Gains (losses) on other equity investments, net | 231 | (23) | (376) |
| Interest and other, net | 109 | 163 | 488 |
| Income before taxes | 16,845 | 5,704 | 7,686 |
| Provisions for taxes | 4,581 | 1,335 | 2,394 |
| Net income | $ 12,264 | $ 4,369 | $ 5,292 |
*This should be considered as operating income.
| INTEL CORPORATION Consolidated Balance Sheets |
||
|---|---|---|
| As of Year-Ended (In millions, except par value) | Dec. 25, 2010 | Dec. 26, 2009 |
| Assets | ||
| Current assets | ||
| Cash and cash equivalents | $ 5,498 | $ 3,987 |
| Short-term investments | 11,294 | 5,285 |
| Trading assets | 5,093 | 4,648 |
| Accounts receivables, net | 2,867 | 2,273 |
| Inventories | 3,757 | 2,935 |
| Deferred tax assets | 1,888 | 1,216 |
| Other current assets | 1,614 | 813 |
| Total current assets | 32,011 | 21,157 |
| Property, plant and equipment, net | 17,899 | 17,225 |
| Marketable equity securities | 1,008 | 773 |
| Other long-term investments** | 3,026 | 4,179 |
| Goodwill | 4,531 | 4,421 |
| Other long-term assets | 5,111 | 5,340 |
| Total assets | $63,586 | $53,095 |
| Liabilities | ||
| Current liabilities | ||
| Short-term debt | $38 | $172 |
| Accounts payable | 2,190 | 1,883 |
| Accrued compensation and benefits | 2,888 | 2,448 |
| Accrued advertising | 1,007 | 773 |
| Deferred income on shipments to distributors | 622 | 593 |
| Other accrued liabilities | 2,482 | 1,722 |
| Total current liabilities | 9,227 | 7,591 |
| Long-term income taxes payable | 190 | 193 |
| Long-term debt | 1,677 | 2,049 |
| Long-term deferred tax liabilities | 926 | 555 |
| Other long-term liabilities | 1,236 | 1,003 |
| Total liabilities | 13,256 | 11,391 |
| Stockholders' equity: | ||
| Preferred stock, $0.001 par value | -- | -- |
| Common stock, $0.001 par value, 10,000 shares authorized; 5,581 issued and 5,511 outstanding and capital in excess of par value | 16,178 | 14,993 |
| Accumulated other comprehensive income (loss) | 333 | 393 |
| Retained earnings | 33,819 | 26,318 |
| Total stockholders' equity | 50,330 | 41,704 |
| Total liabilities and stockholders' equity | $ 63,586 | $ 53,095 |
** These investments are operating assets as they relate to
associated companies.
(a) Compute Intel's net operating assets (NOA) for year-end
2010.
2010 NOA = $Answer
(b) Compute net operating profit after tax (NOPAT) for 2010,
assuming a federal and state statutory tax rate of 37%.
HINT: Gains/losses on equity method investments are considered
operating income. Round your answer to the nearest whole
number.
2010 NOPAT = $Answer


Forecasting and Estimating Share Value Using the DCF Model Following are the income statement and balance...
Forecasting and Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for Intel Corporation. INTEL CORPORATION Consolidated Statements of Income Year Ended (In millions) Dec. 25, 2010 Dec. 26, 2009 Dec. 27, 2008 Net revenue $ 44,123 $ 35,127 $ 37,586 Cost of sales 15,132 15,566 16,742 Gross margin 28,991 19,561 20,844 Research and development 6,576 5,653 5,722 Marketing, general and administrative 6,309 7,931 5,452 Restructuring and asset impairment charges -- 231 710 Amortization...
Forecasting with the Parsimonious Method and Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for Cisco Sytems for the year ended July 30, 2016. Cisco Sytems Consolidated Statements of Income Years Ended December ($ millions) July 30, 2016 July 25, 2015 Revenue Product $37,254 $37,750 Service 11,993 11,411 Total revenue 49,247 49,161 Cost of sales Product 14,161 15,377 Service 4,126 4,103 Total cost of sales 18,287 19,480 Gross margin 30,960 29,681 Operating expenses...
Analyzing, Forecasting, and Interpreting Income Statement and Balance Sheet Following are the income statement and balance sheet of Whole Foods Market, Inc. Income Statement, For Years Ended (in $ 000s) 2010 2009 Sales $ 9,005,794 $ 8,031,620 Cost of goods sold and occupancy costs 5,870,393 5,277,310 Gross profit 3,135,401 2,754,310 Direct store expenses 2,375,716 2,145,809 General administrative expenses 272,449 243,749 Pre-opening expenses 38,044 49,218 Relocation, store closures and lease termination costs 11,217 31,185 Operating income 437,975 284,349 Interest expense (33,048)...
Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and balance sheets of General Mills, Inc. Income Statement, Fiscal Years Ended ($ millions) May 29, 2011 May 30, 2010 Net Sales $ 14,880.2 $ 14,635.6 Cost of sales 8,926.7 8,835,4 Selling general and administrative expenses 3.192.0 3,162.7 Divestitures (gain), net (17.4) Restructuring, impairment, and other exit costs 4.4 31.4 Operating income 2.606.1 Interest, net 401.6 Earnings before income tax expense and equity in income...
Analyzing. Forecasting, and Interpreting Income Statement and Balance Sheet Following are the income statement and balance sheet of General Mills, Inc. Income Statement, Fiscal Years Ended (in s millions) May 26, 2013 May 27, 2012 May 29, 2011 Net Sales $16.657.9 $14.380 2 Cost of Sales 11.350.2 10.613.2 892 Selling general and administrative expenses 3.5523 3.380.7 2. 1920 Divestitures (gain) Restructuring impairment, and other exit costs 101.6 Operating profit 2851.8 2562.4 27745 net 351.9 Earnings before income taxes and after...
please complete the balance sheet.
Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and balance sheets of General Mills, Inc. Income Statement, Fiscal Years Ended ($ millions) May 29, 2011 May 30, 2010 Net Sales $ 14,880.2 $ 14,635.6 Cost of sales 8,926.7 8,835,4 Selling general and administrative expenses 3.192.0 3,162.7 Divestitures (gain), net (17.4) Restructuring, impairment, and other exit costs 4.4 31.4 Operating income 2.606.1 Interest, net 401.6 Earnings before income tax...
Analyzing, Forecasting, and Interpreting Income Statement and Balance Sheet Following are the income statement and balance sheet of General Mills, Inc. Income Statement, Fiscal Years Ended (in $ millions) May 26, 2013 May 27, 2012 May 29, 2011 Net Sales $ 17,774. 1 5 16.657.9 5 14,880.2 Cost of Sales 11.350.2 10.613.2 8,926.7 Selling, general and administrative expenses 3.552.3 3.380.7 3.192.0 Divestitures (gain) (17.4) Restructuring, impairment and other exit costs 19.8 101.6 Operating profit 2.851.8 2.562.4 2.774.5 Interest, net 316.9...
Analysis and Interpretation of Profitability Balance sheets and income statements for Costco Wholesale Corporation follow. Costco Wholesale Corporation Consolidated Statements of Earnings For Fiscal Years Ended (5 millions) September 2, 2018 Total revenue $141,576 Operating expenses Merchandise costs 123,152 Selling general and administrative 13,876 Preopening expenses 68 Operating Income 4,480 Other Income (expense) Interest expense 159 Interest income and other, net (121) Income before income taxes Provision for income taxes 1,263 Net income including noncontrolling interests 3,179 Net income attributable...
Identify and Compute Net Operating Assets Following is the balance sheet for Lowe's Companies Inc. 461 LOWE'S COMPANIES INC. Consolidated Balance Sheet $ millions, except par value Feb. 1, 2019 Current assets Cash and cash equivalents $920 Short-term investments 392 Merchandise inventory-net 22,610 Other current assets 1,688 Total current assets 25,610 Property, less accumulated depreciation 33,178 Long-term investments Deferred income taxes-net 529 Goodwill 545 Other assets 1,791 Total assets $62,114 Current liabilities Short-term borrowings $1,300 Current maturities of long-term debt...
Given the Balance Sheet and Income Statement calculate the
follow ratios (must include calculations):
profit ratio, liquidity ratio, activity ratio, leverage ratio,
shareholder return ratio
Balance Sheet All numbers in thousands A Get access to 15+ years of historical data with Yahoo Financ Breakdown 12/31/2019 v Assets v Current Assets v Cash Cash And Cash Equivalents 2,594,000 Short Term Investments Total Cash 2,594,000 Net Receivables 25,429,000 Inventory 1,422,000 Other Current Assets Total Current Assets 37,473,000 Total Current Assets 37,473,000 Non-current...