use excel formulas to solve and show work

When Crossett Corporation was organized in January Year 1, it immediately issued 4,000 shares of $50 par, 6 percent, cumulative preferred stock and 50,000 shares of 520 par common stock. \begin{tabular}{|r|rrrrr} 4,000 & $50 & 6% & 50,000 & $20 \\ \hline$35,000 & $125,000 & $215,000 & & \end{tabular} Required (Use the cells from the given information above to complete this question.) a. How much is the dividend arrearage as of January 1, Year 2 ? b. Assume that the board of directors declares a $25,000 cash dividend at the end of Year 2 (remember $ that the Year 1 and Year 2 preferred dividends are due). $25,000 How will the dividend be divided between the preferred and common stoctholders? (Use the cells from the given information and from Required A to complete this question) (Amounts to be deducted should be indicated with a minus sign.)