Please show Excel Calculations/working for solutions. Check figures are: June 30 - Stock dividend- Dr to Retained Earnings - $140,250Aug 1: Stock buy back: Dr to Common shares: $87,943Ending balance of retained earnings: $1,230,206Ending balance of common shares: $2,328,294

Assignment on Shareholders' Equity Pine Inc. ("Pine\") had the following shareholders' equity account balances on January 1, 2021: Common shares, unlimited authorization, 210,000 shares issued $1,680,000 Preferred shares - $2.50 cumulative, 100,000 shares authorized, 15,000 issued $562,500 Contributed Surplus (Credit balance) 5 30,000 Retained earnings $1,200,000 All shares were issued between 2017 and 2019. The last time the company declared and paid any dividends was December 31, 2019. All preferred dividends were satisfied on that date. The contributed surplus arose from past common share transactions. The following transactions took place during 2021: 1. On January 1, the company issued 25,000 common shares and received $225,000. 2. On March 15', the company acquired a piece of land in exchange for common shares. The land had a fair value of 200,000. The company issued 20,000 common shares. 3. On June 30'\