Equity Equation Assignment

For this assignment, you will determine missing values within the equity equation and prepare separate owner's equity sections of a 'Report Form' balance sheet for three equity scenarios.

Use proper accounting conventions with respect to spreadsheet formatting and spreadsheet formulas for accounting calculations.

For Part A$,$ re$-$create the tables shown below in a Word document; for Part B$,$ you will create a spreadsheet file.

Part A: Working with the Equity Equation

Recreate and complete the following equity equation chart. Highlight or bold the values you enter.

$10$ marks

$\backslash$table$[[,\backslash$table$[[$Opening$],[$Capital$]],\backslash$table$[[$Net Incomel$],[$Net Loss$]],$Drawings,$\backslash$table$[[$Ending$],[$Capital$]]],[1,$$$50000,$$$20000,$$$5000,],[2,$$$80000,-$$$4500,$$$1000,],[3,,$$$35000,$$$12000,$$$32000$