-- Estimating Share Value Using the ROPI Model Assume the following are the income statement...
50.1K
Verified Solution
Link Copied!
Question
Accounting
--
Estimating Share Value Using the ROPI Model
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 anegative 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)
--
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!