Question

How would I calculate diluted weighted average shares in excel using the following information? (The blank cells are what I need)

Excel File Edit View Insert Format Tools Data Window Home Insert Page Layout Formulas Data ReviewView Calibri (Body) 12A- A Paste As reported 43 Merck & co., Inc. and subsidiaries 44 | Income statements 45 In millions except per share data 46 47 Sales 48 Costs/expenses 49 Materials and production 2017 40,122 2015 39,498 Year ended near 12/31: 2016 39,807 12,775 13,891 9,762 10,208 10,124 651 720 33,60135,148 4,659 718 3,941 21 14,934 10,313 6,704 619 1,527 34,097 5,401 942 4,459 17 4,442 Marketing and administrative 51 Research and development 52 Restructuring costs 53 Other 9,830 776 12 55 Income before taxes 6 Taxes on income 7 Net income 8 Less: Nl noncontroling interests 9 NI Attributable to Merck & co., Inc. 0 Diluted w. average shares 1 EPS Assuming Dilutiorn 6,521 4,103 2.418 24 2394 3,920 0.87 141 1.56

Answer 1

EPS = NI attributable to Merck & Co./Diluted w. average shares

Thus Diluted w. average shares = NI attributable to Merck & Co/EPS

		2017	2016	2015
A	NI attributable to Merck & Co.	2,394.00	3,920	4,442.00
B	EPS assuming dilution	0.87	1.41	1.56
C = A/B	Diluted w. average shares	2,751.72	2,780.14	2,847.44

If you want you can round the share numbers to the nearest whole number and if you do that the answers for 2017,2016 and 2015 will be = 2,752 shares for 2017, 2,780 shares for 2016 and 2,847 shares for 2015.