please follow this format so it can be easy for me to understand. thank you so much in advance.

Aggregate Mining Corporation was incorporated five years ago. It is authorized to issue 500,000 shares of $100 par value 8% cumulative preferred stock. It is also authorized to issue 750,000 shares of $6 par value common stock. It has issued 50,000 of the common shares and 1,000 of the cumulative preferred shares. The corporation has never declared a dividend and the preferred shares are one years in arrears (including current year). Aggregate Mining has the following transactions this year: A: 3/1/2023 Declares a cash dividend of $20,000 B: 3/30/2023 Pays the cash dividend C: Compute the share of dividends to preferred and common stock holders D: Journalize the transactions Inputs - Must be formatted as numbers, e.g: 1,000 for numbers and $1,000 for dollar values) Computations - Must be formatted as numbers, e.g: 1,000 for numbers and $1,000 for dollar values, Must use formulas References - Must refer to another cell in the same sheet Computations Total cash dividend declared Preferred shares dividend computation Number of years of dividend in arrears Number of preferred shares issued and outstanding Par value per preferred share Rate of dividend for preferred shares Total dividend due to preferred shares Common shares dividend computation Remaining cash dividend available to common stock holders Number of common shares outstanding Cash dividend per common share Part F