Could you please explain how to get the total paid-in capital and retained earnings. Use excel formulas or detailed work.

During its second year of operations, Panzarella Corporation entered into several transactions relating to shareholders' equity. The articles of incorporation authorized the issue of 7,000,000 common shares, $2.50 par per share, and 900,000 preferred shares, $30.00 par per share. Its balance sheet at December 31 of the prior year follows. Prepar 1) Sold 1,750,000 common shares for $15.00 per share. 2) Reacquired 35,000 common shares to be held in treasury at $17.00 per share. 3) Sold 7,000 of its treasury shares for $18.70 per share. 4) Sold 10,500 of its treasury shares for $13.60 per share. 5) Prepare the shareholders' equity section of the balance sheet for the Panzarella Company at December 31, 2023. Net income for the year was $393,750 and dividends totaled $140,000. During its second year of operations, Panzarella Corporation entered into several transactions relating to shareholders' equity. The articles of incorporation authorized the issue of 7,000,000 common shares, $2.50 par per share, and 900,000 preferred shares, $30.00 par per share. Its balance sheet at December 31 of the prior year follows. Prepar 1) Sold 1,750,000 common shares for $15.00 per share. 2) Reacquired 35,000 common shares to be held in treasury at $17.00 per share. 3) Sold 7,000 of its treasury shares for $18.70 per share. 4) Sold 10,500 of its treasury shares for $13.60 per share. 5) Prepare the shareholders' equity section of the balance sheet for the Panzarella Company at December 31, 2023. Net income for the year was $393,750 and dividends totaled $140,000