Use Excel to create a Statement of Changes in Equity based on the data below and answer question A in succinct, organized way Include a $$Total S$/$H Equity$$ column in your Statement of Changes in Equity the Company $($you can make up a company name$)$ began the year on January $1,2024$ with the following balances in the Equity Section of the balance sheet: $$ Preferred Shares; $$1\mathrm{.}10$; $22,000$ issued & outstanding $$500,000$ Common Shares $(200,000$ par$-$value shares$)400,000$ $$282,000$ Additional Paid$-$In Capital $$ $$135,000$ Retained Earnings $$ AOCI balance was negative: $$(10,000)$ During $2024,$ the following transactions took place: $$ During February $2024,50,000$ common shares were issued at $$4\mathrm{.}50$ per share $$ Net Income: $$55,000$ Preferred Share dividends were paid in December; this was the last $($of four$)$ quarterly preferred dividend payments; the first three dividend payments were in March, June, September $2024.$ Foreign currency change in valuation was positive; unrealized gain, net of tax $$15,000$ On December $1,2024$ the company purchased $70,000$ of its own common shares back from the open market when the share price was $$3\mathrm{.}00.$ Dividends were paid to common shareholders on December $20$: $$0\mathrm{.}15$ per share