XYZ, Inc. has declared the following annual cash dividends over a six-year period as noted below in Instruction #1. During the entire period ended December 31st of each year, the outstanding stock of the company was composed of: 100,000 shares of 1 %, cumulative preferred stock [PS] with a par value of $30 per share AND 400,000 shares of common stock with a par value of $20 per share INSTRUCTIONS: 1. Calculate the total dividends and the dividends per share for each class of stock for each of the six years. There were no dividends in arrears as of 1/1/2011. Summarize the data in tabular form using the column headings below. Year Total Divs. PS Total Divs. PS Div. Per Share CS Total Divs. CS Div. per Share 2011 $20,000 2012 36,000 2013 70,000 2014 90,000 2016 102,000 2016 150,000 2. Calculate the Average Annual Dividend per share for each class of stock for [over] the six-year period. SEE THE EXCEL TEMPLATE. 3. Calculate the Average Annual Return on the initial shareholders' investment based on the average annual dividend per share. Compute this for BOTH Preferred Stock and Common Stock. To do this, assume a Market Price of $37.50 per share for the preferred stock and a Market Price of $30.00 per share for the common stock. SEE THE EXCEL TEMPLATE View P MacBook Air