DAIS McNamara Limiteds ledger shows
the following balances on December :
Preferred shares outstanding: shares $
Common shares outstanding: shares
Retained earnings
Instructions
Assuming that the directors decide to declare total dividends in the amount of $ determine how
much each class of shares should receive under each of the conditions that follow. Note that one years
dividends are in arrears on the preferred shares, which pay a dividend of $ per share.
a The preferred shares are cumulative and fully participating. Round the intermediate percentage
calculation to four decimal places and the final amount to the nearest dollar.
b The preferred shares are noncumulative
and nonparticipating.
Round to the nearest dollar.
c The preferred shares are noncumulative
and are participating in distributions in excess of a
dividend rate on the common shares. Round the intermediate percentage calculation to four decimal
places and the final amount to the nearest dollar.
d Using your answers to parts ab and c create visualizations in Excel that show the dividends
for the common shares and preferred shares in each scenario. Give me calculation in excel format