"Beginning Transactions" on the first Excel worksheet will provide the Balance SheetIncome Statement For January $2020$

Balance Sheet as of January $31,2020$

How many units and at what cost are in inventory to start February?

Statement of Equity for January $2020$

for $2019$ and the Transactions for January $2020.$

On the second Excel worksheet, "Journal Entries", you should record the transactions

provided on the first Excel worksheet by creating Journal Entries with dates and

descriptions.

On the third Excel worksheet, $"$T$-$accounts and trial balance", you should record the

required journal entries in the T $-$accounts and prepare an unadjusted trial balance.

The fourth and final Excel worksheet, "Financial Statements", you will prepare an

Income Statement, Statement of Equity and a Balance Sheet as of January $31,2020$

and answer the inventory question. Chapter $1$ Appendix A$,$ Section $1\mathrm{.}8$ in the text will

show examples of financial statements. This is very much like your assignment in

Week $1$ and there is a module for Financial Statement review which will have videos

to help.