Required: Answer the questions on the following page in Excel and upload your file to

Moodle by the deadline specified by your instructor.

Shown below is the stockholders' equity section of Holiday Travels' balance sheet at

December $31,2023$:

Common stock, $$4$ par value, $5,000,000$ shares authorized,

$230,000$ shares issued and outstanding

Additional paid$-$in capital

Retained earnings

Total stockholders' equity

During $2024,$ the following events occurred:

$>$ Holiday Travels was authorized to sell $130,000$ shares of $$100$ par, $5\%$ preferred

stock

$>$ Holiday sold $19,000$ shares of the preferred stock at par value

$>$ A cash dividend of $$273,000$ was declared and paid

$>$ Holiday Travels declared and issued a $10\%$ stock dividend on the common stock when

the market value of the stock was $$22$ per share

Net income for the year was $$1,830,000$

Instructions for Project $1$:

Answer the following, based on the information given on the pre

Capital stock, as of December $31,2024$:

# of common shares authorized

# of common shares issued and outstanding

# of preferred shares issued and outstanding

Amount of cash dividend to common stockholders

Amount of cash dividend to preferred stockholders

Total debit to Stock Dividends account

Additional paid$-$in capital, at December $31,2024$

Retained earnings, at January $1,2024$

Retained earnings, at December $31,2024$

Total Stockholders' Equity, at December $31,2024$How to solve