Please see the attached copy of questions including a copy of the excel sheet. Please follow sections.
Please see the attached file
The first part is based on the par value - $100 for preferred stock and $2 for common stock. The additional paid in capital is based on the difference between the par value and the issue price - $3 for preferred stock and $11 for common stock.
The balance sheet is based on cost and changes in the market price of stock ...
The solution explains how to prepare the stockholders equity section in the balance sheet