I need help calculating the Price/Book Ratio, the Equity-Book Value Per Share, E
ID: 2414843 • Letter: I
Question
I need help calculating the Price/Book Ratio, the Equity-Book Value Per Share, Earning Per Share, and the Economic Value Added with the income statement and balance sheet posted below. The Market Price per Share is $154.12 and the number of shares outstanding as of 9/30/17 is 5.126B.
?AAPL Financial model Home Saved torr Insert Page Layout Formulas Data Review View Cut Copy Format General Paste Security Warning External Data Connections have been disabled Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. F3 1 Apple Inc. (AAPL) Income Statement Dollars %Of Sales s Revenue 6 Total Revenue 7 Cost of Revenue 8 Gross Profit 9 Operating Expenses 9/24/16 /26/15 9/30/17 9/24/16 9/26/15 229,234,000 215,639,000 233,715,000 100%100% 100% , 141,048,000 131,376,000 140,089,000 88,186,000 84,263,000 93,626,000 62% 38% 61% 39% 60% 40% 4096 Research Development 11 Selling General and Administrative 12 Non Recurring 13 Others 14 Total Operating Expenses 11,581,000 10,045,000 8,067,000 5% 5% 3% 96 ) 5961 396 15,261,000 14,194,000 14,329,000 7% 7% 6 Operating Income or Loss 16 Income from Continuing Operations 17 Total Other Income/Expenses Net 18 Eamings Before Interest and Taxes 19 Interest Expense 20 Income Before Tax 21 Income Tax Expense 22 Minority Interest 61,344,000 60,024,000 71,230,000 27% 28% 30% 2,745,000 1,348,000 1,285,000 1% 1% 1%; ,_ 1961 196 28%, 64,089,000 61,372,000 72,515,000 64089,000 61,372,000 72515,000 15,738,000 15,685,000 19,121,000 48,351,000 45,687,000 53,394,000 28% 28% 796 21% 31% , 28% 31% / 796| 896 7%--8% 21%, 23% 3 Net Income From Continuing Ops 24 Non-recurring Events Discontinued Operations 26 Extraordinary Items Effect Of Accounting Changes 28 Other Items 29 Net Income 30 Net Income 48,351,000 45,687,000 53,394,000 21% 21%23% , 1 Preferred Stock And Other Adjustments 32 Net Income Applicable To Common Shares 48,351,000 4 5,687,000 53,394,000 2196. 21%- 23% 34 Balance SheetCash Flow+ Ready esc FlExplanation / Answer
ALL CALCULATIONS ARE AS ON 30TH September, 2017
Price /Book ratio
Market price per share
154.12
Equity book per share (Note 1)
24.5868123
Price /Book ratio
6.26840104
Earnings per share (Net income / Number of shares outstanding)
Net income
48351000
Number of shares outstanding
5126000
Earnings per share (Net income / Number of shares outstanding)
9.43250098
Economic value added (EVA)
(Operating income - Cost of capital)
Operating income
61344000
Less: Cost of capital (126032000 x 10%)
12603200
Economic value added (EVA)
48740800
Note:
In respect of cost of capital it has been assumed that the standard rate of return is 10% and accordingly, the same has been charged on net tangible assets of the company to calculate the cost of capital in ascertaining the EVA.
ALL CALCULATIONS ARE AS ON 30TH September, 2017
Price /Book ratio
Market price per share
154.12
Equity book per share (Note 1)
24.5868123
Price /Book ratio
6.26840104
Earnings per share (Net income / Number of shares outstanding)
Net income
48351000
Number of shares outstanding
5126000
Earnings per share (Net income / Number of shares outstanding)
9.43250098
Economic value added (EVA)
(Operating income - Cost of capital)
Operating income
61344000
Less: Cost of capital (126032000 x 10%)
12603200
Economic value added (EVA)
48740800
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.