On June $1,2024,$ the board of directors of Walsh Corporation declared a $10\%$ stock dividend on common shares, to be distributed

on September $1,2024.$ The market price of Walsh's common stock was $$24\mathrm{.}00$ on June $1,2024,$ and $$26\mathrm{.}00$ on September $1,2024.$

Stock dividend percentage

Market price of Walsh common stock on June $1,2024$

Market price of Walsh common stock on September $1,2024$

Prepare the appropriate journal entries to record each of the following transactions:

On June $1,2024$ the board of directors declared a $10\%$ stock dividend on common shares, to be distributed on September $1,$

Record the declaration.

Prepare the shareholders' equity section of the balance sheet for the Walsh Company at December $31,2024.$ Net income for the

year was $$11,085,000$ and dividends totaled $$3,880,800.$

Net income for the year ended December $31,2024$

Answer needs to be formulas for excel.