Classes of stock outstanding of coca cola

Keystone Company has two classes of capital stock outstanding: 10%, $40 par preferred and $1 par common. During the fiscal year ended November 30, 2013, the company was active in transactions affecting the stockholders' equity. Page 13-71 summarizes these transactions.
Type of Transaction..........................................Number of Shares......Price per Share
(a) Issue of preferred stock . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6,000....................$47
(b) Issue of common stock . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40,000.....................76
(c) Reacquisition and retirement of preferred stock . . . . . . . . . . . .3,000.....................50
(d) Purchase of treasury stock-common (reported at cost) . . . . 15,000.....................80
(e) Stock split-common (par value reduced to $0.50) . . . . . . . . 2 for 1
(f) Reissuance of treasury stock-common (after stock split) . . . 15,000.....................56
Balances of the accounts in the Stockholders' Equity section of the November 30, 2012, balance sheet were
Preferred stock, 40,000 shares . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 1,600,000
Common stock, 250,000 shares . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 250,000
Paid-in capital in excess of par-preferred . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 200,000
Paid-in capital in excess of par-common . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18,250,000
Retained earnings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 960,000
Dividends were paid at the end of the fiscal year on the common stock at $1.20 per share and on the preferred stock at the preferred rate. Net income for the year was $800,000.
Instructions:
Based on the preceding data, prepare the Stockholders' Equity section of the balance sheet as of November 30, 2013. For shares retired, assume that the most recently issued shares are retired first.