Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Estimating Share Value Using the ROPI Model - This would not allow the tables to copy correctly...so attached is screenshots of the question. It is

Estimating Share Value Using the ROPI Model - This would not allow the tables to copy correctly...so attached is screenshots of the question. It is easier to read. Thanks.

Assume the 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 adminstrative 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

Currnet 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 --

Compute Intel's net operating assets (NOA) for year-end 2010

Compute net operating profit after tax for 2010, assuming a federal and state stat utory tax rate of 37%. HINT: Gains/losses on equity method investments are considered operating income. Round your answer to the nearest whole number.

--

(c) Forecast Intel's sales, NOPAT, and NOA for years 2011 through 2014 using the following assumptions:

Sales growth 10% Net operating profit margin (NOPM) 26% Net operating asset turnover (NOAT) at fiscal year-end 1.50 --

Forecast the terminal period value using the assumptions above and assuming a terminal period growth of: 1%.

INTC Reported Forecast Horizon Terminal ($ millions) 2010 2011 Est. 2012 Est. 2013 Est. 2014 Est. Period Sales (rounded two decimal places) $Answer $Answer $Answer $Answer $Answer $Answer Sales (rounded nearest whole number) Answer Answer Answer Answer Answer Answer NOPAT (rounded nearest whole number)* Answer Answer Answer Answer Answer Answer NOA (rounded nearest whole number)* Answer Answer Answer Answer Answer Answer * Use sales rounded to nearest whole number for this calculation.

(d) Estimate the value of a share of Intel common stock using the residual operating income (ROPI) model as of December 25, 2010; assume a discount rate (WACC) of 11%, common shares outstanding of 5,511 million, and net nonoperating obligations (NNO) of $(21,178) million (NNO is negative which means that Intel has net nonoperating investments). Use your rounded answers for subsequent calculations.

INTC Reported Forecast Horizon Terminal ($ millions) 2010 2011 Est. 2012 Est. 2013 Est. 2014 Est. Period ROPI Model

ROPI [NOPAT - (NOA beg x WACC)] (rounded to nearest whole number)

Answer Answer Answer Answer Answer Discount factor (rounded to 5 decimal places)

Answer Answer Answer Answer

Present value of horizon ROPI (rounded to nearest whole number)

Answer Answer Answer Answer

Cumulative present value of horizon ROPI $Answer (rounded to nearest whole number)

Present value of terminal ROPI $Answer (rounded to nearest whole number)

NOA Answer (rounded to nearest whole number)

Total firm value Answer (rounded to nearest whole number)

Plus negative NNO Answer (enter as a

negative number)

Firm equity value $Answer (rounded to nearest whole number)

Shares outstanding (millions) Answer (rounded to nearest whole number)

Stock price per share $Answer (rounded to two decimal places)

--

image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Reporting Financial Statement Analysis And Valuation A Strategic Perspective

Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

9th Edition

1337614689, 1337614688, 9781337668262, 978-1337614689

More Books

Students also viewed these Accounting questions