Preferred and Common Stock Dividends

Delafield Corporation has a single class of common stock and a single class of cumulative preferred stock. The cumulative preferred stock requires the corporation to pay

an annual dividend of $$14,000$ to preferred stockholders. On January $1,2023,$ Delafield's preferred dividends were $1$ year in arrears. During the $3$ years $(2023-2025),$

Delafield's board of directors determined they would be able to pay $$20,000,$$$25,000,$ and $$26,000,$ respectively.

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answer in the question below.

Open spreadsheet

Required:

Show how these anticipated payments will be split between preferred and common stockholders. If an amount box does not require an entry, leave it blank and if the

answer is zero, enter $"0".$