Homework Help

Business
Accounting
how would i calculate diluted weighted average shares in excel...

Question: how would i calculate diluted weighted average shares in excel...

Question details

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

Solution by an expert tutor

Blurred Solution

This question has been solved

Subscribe to see this solution