Excel McGraw Hill Excel Question - Saved Search (Option+Q) File Home Insert Draw Formulas Data Review View Help Editing Calibri 11 I v &v Av General $ Conditional Formatting Comm Styles Format As Table v A1 fx Accessibility tab summary: Two data tables are presented in cells F3 to 15 and A7 to B10. A statement of requirement is presented in rows 12 to 14 and a table for student preparation is presented in cells A16 to F23. F L Q B D 80,000 G H J 1 3 4 5 2 York's outstanding stock consists of 80,000 shares of cumulative 7.5% preferred stock with a $5 par value and also 200,000 shares of common stock with a $1 par value. During its first four years of operation, the corporation declared and paid the following total cash dividends: Preferred Dividend Preferred Common Common Shares % 7.5% Par Value $5 Shares 200,000 Par Value $1 6 7 Year 1 total cash dividends 8 Year 2 total cash dividends $20,000 28,000 9 Year 3 total cash dividends 200,000 10 Year 4 total cash dividends 350,000 11 12 Required: 13 14 (Use cells A2 to J10 from the given information to complete this question.) 15 K M N R McGraw Hill Check Answers Check My Work Legend Graded cell: Leave blank if no answer is needed. Scratchpad: Use as a non-graded workspace Par Value per per Preferred 16 Share Number of Dividend Preferred Preferred Rate Share Shares Preferred Dividend 17 Dividend: Year Total Cash Dividend Paid Paid to Preferred Paid to Common Dividends in Arrears at 18 19 1 $20,000 20 2 28,000 21 3 200,000 22 4 350,000 23 Totals $598,000 24 25 26 27 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. 28 Nothing in this area will be graded, but it will be submitted with your assignment. 29 30 < = Graded Worksheet + Calculation Mode: Automatic Workbook Statistics Save and Return to Assignment Give Feedback to Microsoft 100