Need help with this question

Pranks, Inc. is a manufacturer of joke and novelty products for perpetrators of practical jokes. The corporation has paid several cash dividends throughout 20Y6, the current year. It is also declaring a stock dividend to its stockholders as the calendar year-end approaches. You've been brought in as a consultant to assist with this process, and also to help determine whether some missing information can be determined before the distribution of the stock dividend is made. The company has two classes of stock: common stock and cumulative preferred stock. You've been able to retrieve the following information so far: Number of common shares authorized 800,000 Number of common shares issued 650,000 Par value of common shares $20 Par value of cumulative preferred shares $30 Paid-in cam in excess of par-common stock $7,000,000 Paid-in capital in excess of par-preferred stock $0 Total retained earnings before the stock dividend is declared $83,500,000 No treasury shares have been reissued. Total Cash Preferred Dlvldends Common Dlvldends Year Dividends Total Per Share Total Per Share 20Y1 $20,000 $20,000 $0.20 $0 $0.00 20Y2 36,000 36,000 0.36 0 0.00 20Y3 88,000 34,000 0.34 54,000 0.09 20Y4 120,000 30,000 0.30 90,000 0.15 20Y5 138,000 30,000 0.30 108,000 0.18 20Y6 210.000 30.000 0.30 180.000 0.30 i IE\" I The accounting manager for the company prepared the schedule of cash dividends paid from 20Y1 to 20Y6 on the Franks, Inc. panel. However, one of the reasons for Pranks, lnc.'s missing information is tha the manager is away on vacation and is unreachable by phone, because he is backpacking on a remote island that does not have cell phone reception. Management would like you to determine some information from the data you've collected regarding its outstanding stock. Fill in the following answers. How many shares of common stock are outstanding? How many shares of preferred stock are outstanding? What is the preferred dividend as a percent of par? % In which years has Pranks, Inc. paid cumulative preferred dividends in arrears? Check all that apply. _ Year 1 _ Year 2 _ Year 3 Year 4 _. Year 5 Year 6 The company declared a 2% common stock dividend on December 1, and would like you to compute the following pieces of missing information. The market value of the common shares is $26.00 on December 1, and is $32.00 on the actual distribution date of the stock, December 31. Fill in the missing information in the following table, using the information given and your work on the other panels. All \"before\" items are before the stock dividend was declared. All \"after\" items are after the stock dividend was declared and closing entries were recorded at the end of the year. Total paid-in capital before the stock dividend '$ Total retained earnings before the stock dividend Total stockholders' equity before the stock dividend $ Total paid-in capital after the stock dividend $ Total retained earnings after the stock dividend Total stockholders' eqy after the stock dividend $