Question

How do I figure the earnings per share, price earnings, and market to book for each year listed in the attached spread sheet? Thank you so much!

Walmart Inc income Statements) ..2015 ..2014 ..2013 Total Sales 485,651,000 476,294,000 468,651,000 (Supplier Purchases) Cost of Goods Sold 365,086,000 358,069,000 352,297,000 Gross Profit 120,565,000 118,225,000 116,354,000 Selling and General Administrative 93,418,000 91,353,000 88,629,000 Operating Profit 27,147,000 26,872,000 27,725,000 Total Other Income/Expenses Net 113,000 119,000 186,000 Earnings Before Interest And Taxes 27,034,000 26,753,000 27,539,000 Interest Expense 2,461,000 2,335,000 2,249,000 Income Before Tax 24,573,000 24,418,000 25,290,000 Income Tax Expense 7,985,000 8,105,000 7,958,000 Net Income From Continuing Ops 16,588,000 16,313,000 17,332,000 Discontinued Operations 285,000 144,000 52,000 Net Income 16,303,000 16,169,000 17,280,000 14,000,000 shares outstanding Earnings per share USE THESE PRICES Price per share $ 10.00 $ 9.00 $ 8.00 Price to Earnings Ratio

Answer 1

Earnings per share = Net income / Shares outstanding

2015 = 16303000 / 14000000 = $1.1645 per share

2014 = 16169000 / 14000000 = $1.1549

2013 = 17280000 / 14000000 = $1.2343

Price earnings = Market price per share / Earnings per share

2015 = 10 / 1.1645 = 8.59

2014 = 9 / 1.1549 = 7.79

2013 = 8 / 1.1234 = 7.12